Find Jobs
Hire Freelancers

fix this issue

$10-30 USD

Stengt
Lagt ut nesten 5 år siden

$10-30 USD

Betalt ved levering
I need this fixed now. I removed the temporary files and now your Cloud has inode usage below 300.000. There is a database larger than 1GB. On the GrowBig accounts the maximum allowed database size is 750M. Code: Database Tables Views InnoDB MyISAM Slow Queries Slowest Query DB Size --------------------------- ------ ----- ------ ------ ------------ ------------- ------- everyth5_eau 100 0 100 0 38 86.488 1.1 GB In order to downgrade your account you have to reduce the database size. Below you can find which are the largest tables in everyth5_eau. Code: wp3c_postmeta 560.0 MB wp3c_options 380.0 MB There are also slow MySQL queries which occupy quite a lot of CPU time. Slow MySQL query is considered a MySQL query which takes more than a second to execute, but in your everyth5_eau database there are queries which run for more than 100 seconds. Few examples can be found below: Code: === TOP 10 of 72 (total) Slow Queries for the past 24 hours ========== 1. Executed 1d 22m 42s ago for 196.792131 sec on Database --> Unknown (NOT FOUND / DELETED) Date: 2019-06-12 15:28:20 Query_time: 196.792131 Rows_examined: 19956: Rows_sent 1041 Lock_time: 0.000147 # Schema: everyth5_eau Last_errno: 0 Killed: 0 SELECT option_name, option_value FROM wp3c_options WHERE autoload = 'yes'; --------------------------------------------------------------------------------------------------------- 2. Executed 10h 17m 31s ago for 192.300894 sec on Database --> Unknown (NOT FOUND / DELETED) Date: 2019-06-13 05:33:31 Query_time: 192.300894 Rows_examined: 17434: Rows_sent 1042 Lock_time: 0.000070 # Schema: everyth5_eau Last_errno: 0 Killed: 0 SELECT option_name, option_value FROM wp3c_options WHERE autoload = 'yes'; Currently the CPU usage of your account exceeds the maximum allowed CPU quota for the GrowBig accounts. In order to downgrade your account you have to optimize both your websites and databases. I have exported the slow MySQL queries log. You can find it in: /home/everyth5/[login to view URL] The tutorial below provides guidance on how you can optimize your database. [login to view URL] If you are not able to optimize the database yourself, my recommendation is to contact your developer, as he should be able to help.  In case you do not have a trusted developer, I recommend you turn to our partner Codeable. Codeable is a WordPress exclusive freelancer platform that connects thousands of customers like you with WordPress freelance experts to work on WordPress projects of any size. We recommend them for the high-quality of development services they offer. As a SiteGround client, you’ll get a $60 discount on your first project posted with Codeable. If you are interested, you can find more information on this page: [login to view URL]
Prosjekt-ID: 19983244

Om prosjektet

3 forslag
Eksternt prosjekt
Aktiv 5 år siden

Ønsker du å tjene penger?

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen
Få betalt for arbeidet ditt
Skisser forslaget ditt
Det er gratis å registrere seg og by på jobber
3 freelancers are bidding on average $191 USD for this job
Brukeravatar
I can trim down the db size for you. I am a skilled wordpress developer with over 10 years experience. let discuss more via private message.
$50 USD om 2 dager
5,0 (132 omtaler)
5,8
5,8
Brukeravatar
Hello! I read your description carefully. I've always done my project as the fastest and highest quality. I think your project is best for me. The reason is that I am a DB query expert. If you want to check my skill, you can sure from my profile. To confirm this, please see the link below. https://www.freelancer.com/u/fastestJohn?w=f If you choose me, I will do my best. Thanks.
$300 USD om 3 dager
5,0 (9 omtaler)
4,5
4,5
Brukeravatar
Dear Sir, I have an question. why database --> Unknown !! It is clear that command can not execute in straight way. Please feel free to contact me if you have any queries. Best Regards, Tanvir Rumman
$222 USD om 10 dager
0,0 (0 omtaler)
0,0
0,0

Om klienten

GERMANYs flagg
wichita falls, Germany
4,6
30
Betalingsmetode bekreftet
Medlem siden sep. 16, 2016

Klientbekreftelse

Takk! Vi har sendt deg en lenke for at du skal kunne kreve din gratis kreditt.
Noe gikk galt. Vær så snill, prøv på nytt.
Registrerte brukere Publiserte jobber
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Forhåndsvisning innlasting
Tillatelse gitt for geolokalisering.
Påloggingsøkten din er utløpt og du har blitt logget ut. Logg på igjen.