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/’ 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/’ 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
|