[digiemp]

My hosting account was just suspended due to a SQL patch these guys had me add.

This is part of the email from Host Monster:

A whole lot of mysql queries are running slow and backing things up on the server. Please look into optimizing databases. Remember optimizing the database doesn't mean running "optimize" in mysql. It means adding useful indexes and looking for tables that are bloated in size. MySQL on localhost (5.1.xx-community-log) up 5+22:11:37 [00:22:15] Queries: 19.0 qps: 0 Slow: 0.0 Se/In/Up/De(%): 1147684xxx/00/00/00 qps now: 0 Slow qps: 0.0 Threads: 420 ( 405/ 6) 56600/00/00/00 Key Efficiency: 99.8% Bps in/out: 0.0/ 2.7 Now in/out: 8.3/34.5k Id User Host/IP DB Time Cmd Query or State -- ---- ------- -- ---- --- ---------- 28312xxx xxxx_ localhost xxxx_x 5xx Query REPLACE INTO xcart_config (`value`, `name`, `defvalue`, `variants`) VALUES ('130146xxxx', 'data_cache_expiration', '', '') 28322xxx xxxx_ localhost xxxx_x 4xx Query REPLACE INTO xcart_config (`value`, `name`, `defvalue`, `variants`) VALUES ('1301465xxx', 'data_cache_expiration', '', '') 28328xxx xxxx_ localhost xxxx_x 3xx Query REPLACE INTO xcart_config (`value`, `name`, `defvalue`, `variants`) VALUES ('1301465759', 'data_cache_expiration', '', '') 28332xxx xxxx_ localhost xxxx_x 3xx Query REPLACE INTO xcart_config (`value`, `name`, `defvalue`, `variants`) VALUES ('130146xxxx', 'data_cache_expiration', '', '')


And this is part of the email from Mercury Minds:

4.) Apply this in "patch or upgrade" section in your admin.
REPLACE INTO `xcart_config` (`name`, `comment`, `value`, `category`, `orderby`, `type`, `defvalue`, `variants`, `validation`) VALUES
('MM_term_and_condition', 'Enable this to show Terms and Condition in MM Checkout', 'Y', 'MM_Checkout', 3, 'checkbox', 'Y', '', '');

This does not make me happy in the slightest. Please quickly advise what to do as my site is down.