Title: MySql server issues Last modified: August 19, 2016 --- # MySql server issues * [smith201981](https://wordpress.org/support/users/smith201981/) * (@smith201981) * [18 years, 2 months ago](https://wordpress.org/support/topic/mysql-server-issues/) * I have a reseller account and i just moved from one host to another, i have this blog that has a lot of posts from a lot of differant authors, it only get about 50 visits a day maybe. the database is rather large though i think it’s 46MB with 25000 records or something like that * It killed the new reseller sever and i was only moving around in the admin area. * the settings for both are * ————————-OLD——–NEW connect timeout———-10———6 delayed insert timeout—300——–6 interactive timeout——45———6 join buffer size———8384512—-1,044,480 key buffer size———-201326592–67,108,864 max allowed packet——-33553408—16,776,192 max connect errors——-10———20 max connections———-650——–200 max prepared stmt count–16382—— 16,382 max user connections—–35———25 old passwords————ON———OFF open files limit——— 4756——-2,258 query cache size———83886080—67,108,864 read buffer size———8384512—- 2,093,056 read rnd buffer size—–262144—–2,093,056 sort buffer size———8388600—- 2,097,144 table cache————–2048——-1,024 tmp table size———–134217728–33,554,432 wait timeout————-20———6 * What would make the most difference in a case like this and what would a host be willing to change? * Thanks * This is the email they send me: * That database is causing an issue: * k+——-+————–+———–+—————-+———+—- | Id | User | Host | db | Command | Time | State | Info | +——-+————–+———–+—————-+———+—- | 21638 | needto_wrdp6 | localhost | needto_wrdp6 | Query | 493 | Sending data | SELECT items.*, floor( 100 * exp( ( object_weight + max_weight ) / ( 2 * max_weight ) ) / exp( | | 21643 | needto_wrdp6 | localhost | needto_wrdp6 | Query | 493 | Sending data | SELECT items.*, floor( 100 * exp(( object_weight + max_weight ) / ( 2 * max_weight ) ) / exp( | | 21676 | needto_wrdp6 | localhost | needto_wrdp6 | Query | 493 | Sending data | SELECT items.*, floor( 100 * exp( ( object_weight + max_weight ) / ( 2 * max_weight ) ) / exp( | | 21677 | needto_wrdp6 | localhost | needto_wrdp6 | Query | 493 | Sending data | SELECT items.*, floor( 100 * exp( ( object_weight + max_weight ) / ( 2 * max_weight ))/ exp( | | 21686 | needto_wrdp6 | localhost | needto_wrdp6 | Query | 493 | Sending data | SELECT items.*, floor( 100 * exp( ( object_weight + max_weight ) / ( 2* max_weight ) ) / exp( | | 21690 | needto_wrdp6 | localhost | needto_wrdp6 | Query | 493 | Sending data | SELECT items.*, floor( 100 * exp( ( object_weight + max_weight)/( 2 * max_weight ) ) / exp( | | 21695 | needto_wrdp6 | localhost | needto_wrdp6 | Query | 493 | Sending data | SELECT items.*, floor( 100 * exp( ( object_weight + max_weight ) / ( 2 * max_weight ) ) / exp( | | 21697 | needto_wrdp6 | localhost | needto_wrdp6 | Query | 493 | Sending data | SELECT items.*, floor( 100 * exp(( object_weight + max_weight ) / ( 2 * max_weight ) ) / exp( | | 21705 | needto_wrdp6 | localhost | needto_wrdp6 | Query | 493 | Sending data | SELECT items.*, floor( 100 * exp( ( object_weight + max_weight ) / ( 2 * max_weight ) ) / exp( | | 21708 | needto_wrdp6 | localhost | needto_wrdp6 | Query | 493 | Sending data | SELECT items.*, floor( 100 * exp( ( object_weight + max_weight ) / ( 2 * max_weight ))/ exp( | | 21716 | needto_wrdp6 | localhost | needto_wrdp6 | Query | 493 | Sending data | SELECT items.*, floor( 100 * exp( ( object_weight + max_weight ) / ( 2* max_weight ) ) / exp( | | 21730 | needto_wrdp6 | localhost | needto_wrdp6 | Query | 493 | Sending data | SELECT items.*, floor( 100 * exp( ( object_weight + max_weight)/( 2 * max_weight ) ) / exp( | | 21750 | needto_wrdp6 | localhost | needto_wrdp6 | Query | 451 | Locked | SELECT items.*, floor( 100 * exp( ( object_weight + max_weight ) / ( 2 * max_weight ) ) / exp( | | 21774 | needto_wrdp6 | localhost | needto_wrdp6 | Query | 493 | Sending data | SELECT items.*, floor( 100 * exp(( object_weight + max_weight ) / ( 2 * max_weight ) ) / exp( | | 21800 | eximstats | localhost | eximstats | Sleep | 2 | | | | 21808 | needto_wrdp6 | localhost | needto_wrdp6 | Query | 493 | Sending data | SELECT items.*, floor( 100 * exp(( object_weight + max_weight ) / ( 2 * max_weight ) ) / exp( | | 21832 | needto_wrdp6 | localhost | needto_wrdp6 | Query | 493 | Sending data | SELECT items.*, floor( 100 * exp( ( object_weight + max_weight ) / ( 2 * max_weight ) ) / exp( | | 21838 | needto_wrdp6 | localhost | needto_wrdp6 | Query | 451 | Locked | SELECT COUNT(*) FROM wp_term_relationships, wp_posts WHERE wp_posts.ID = wp_term_relationships. objec | | 21845 | needto_wrdp6 | localhost | needto_wrdp6 | Query | 449 | Locked | SELECT COUNT(*) FROM wp_term_relationships, wp_posts WHERE wp_posts.ID = wp_term_relationships. objec | | 21860 | needto_wrdp6 | localhost | needto_wrdp6 | Query | 449 | Locked | SELECT COUNT(*) FROM wp_term_relationships, wp_posts WHERE wp_posts.ID = wp_term_relationships. objec | | 21888 | needto_wrdp6 | localhost | needto_wrdp6 | Query | 452 | Locked | UPDATE wp_posts SET guid = ‘[http://need-toknow.com/2008/03/15/pay-day-loans-uk-process/’](http://need-toknow.com/2008/03/15/pay-day-loans-uk-process/’); WHERE ID = | | 21903 | needto_wrdp6 | localhost | needto_wrdp6 | Query | 452 | Locked | UPDATE wp_posts SET guid = ‘[http://need-toknow.com/2008/03/15/pay-day-loans-uk-process/’](http://need-toknow.com/2008/03/15/pay-day-loans-uk-process/’); WHERE ID = | | 21918 | needto_wrdp6 | localhost | needto_wrdp6 | Query | 452 | Locked | SELECT * FROM wp_posts WHERE ID = ‘5609’ LIMIT 1 | | 21985 | needto_wrdp6 | localhost | needto_wrdp6 | Query | 455 | Sending data | SELECT items.*, floor( 100 * exp( ( object_weight + max_weight ) / ( 2 * max_weight ) ) / exp( | | 21987 | needto_wrdp6 | localhost | needto_wrdp6 | Query | 455 | Sending data | SELECT items.*, floor( 100 * exp( ( object_weight + max_weight ) / ( 2 * max_weight ))/ exp( | | 22033 | eximstats | localhost | eximstats | Sleep | 991 | | | | 22085 | needto_wrdp6 | localhost | needto_wrdp6 | Query | 449 | Locked | SELECT post_name FROM wp_posts WHERE post_name = ‘buy-a-franchise-with-your-ira-self-directed- ira’ A | | 22091 | needto | localhost | | Query | 450 | Locked | SHOW TABLE STATUS FROM `needto_wrdp6` | | 22140 | root | localhost | | Query | 0 | | show processlist | Viewing 3 replies - 1 through 3 (of 3 total) * [cstina](https://wordpress.org/support/users/cstina/) * (@cstina) * [18 years, 2 months ago](https://wordpress.org/support/topic/mysql-server-issues/#post-712729) * First of all, what do you mean it’s “killed” the server… do you mean high CPU usage? * If so, then the email they sent you doesn’t really make sense, as some of the numbers on the “new” server look better than the old. The email they sent doesn’t speak to the exact problem….hm. * If it’s CPU usage that’s the dilemma, have you checked to see if you have wp- cron.php running on a high rotation schedule? It could be that with all the work you’ve been doing in Admin, each job was pinging the server as the wp-cron.php was moving the jobs through. * . * Thread Starter [smith201981](https://wordpress.org/support/users/smith201981/) * (@smith201981) * [18 years, 2 months ago](https://wordpress.org/support/topic/mysql-server-issues/#post-712783) * CPU usage, i looked around not sure hot to change the rotation schedule. but that could of been a reasons for a spike. The database was also not optimized so it had 10 MB of extra junk in it. * Do you have any idea what the best way to setup Indexes would be if i have a site with multiple thousands of posts? or how exactly is the best way to setup a site like that? It does not get much traffic at all. Page load times are high right now because of the database being 30MB * So any ideas how to make things work a little smother? * Thread Starter [smith201981](https://wordpress.org/support/users/smith201981/) * (@smith201981) * [18 years, 2 months ago](https://wordpress.org/support/topic/mysql-server-issues/#post-712901) * It was a plugin/widget go figure 😉 * A related plugin for the semiologic theme. * Thanks for helping. Viewing 3 replies - 1 through 3 (of 3 total) The topic ‘MySql server issues’ is closed to new replies. * In: [Everything else WordPress](https://wordpress.org/support/forum/miscellaneous/) * 3 replies * 2 participants * Last reply from: [smith201981](https://wordpress.org/support/users/smith201981/) * Last activity: [18 years, 2 months ago](https://wordpress.org/support/topic/mysql-server-issues/#post-712901) * Status: not resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics