rajasekharan/WP-Autoresponder — Issue #61: WP responder overloades sql server
Author: jozefant
Created: 2012-01-12 15:07:09+00:00
State: open

It seems that the latest version of WP responder (v. 5.2.6) overloads mysql server. I have upgraded from previous versions.

Here is a partial list of running queries:

| 706717 | xxxxx_tvorba | localhost | xxxxx_tvorba | Query | 2 | Locked | ALTER TABLE `wp_wpr_queue` CHANGE `sid` `sid` INT NOT NULL |
| 706718 | xxxxx_tvorba | localhost | xxxxx_tvorba | Query | 12 | Locked | ALTER TABLE `wp_wpr_queue` CHANGE `delivery_type` `delivery_type` tinyint(1) NOT NULL DEFAULT '0' |
| 706719 | xxxxx_tvorba | localhost | xxxxx_tvorba | Query | 7 | Locked | ALTER TABLE `wp_wpr_queue` ADD UNIQUE KEY `meta_key_is_unique` (`meta_key`) |
| 706721 | xxxxx_tvorba | localhost | xxxxx_tvorba | Query | 0 | Locked | ALTER TABLE `wp_wpr_queue` CHANGE `meta_key` `meta_key` VARCHAR(30) NOT NULL |
| 706724 | xxxxx_tvorba | localhost | xxxxx_tvorba | Query | 3 | copy to tmp table | ALTER TABLE `wp_wpr_queue` CHANGE `hash` `hash` VARCHAR(32) NOT NULL |
| 706725 | xxxxx_tvorba | localhost | xxxxx_tvorba | Query | 22 | Locked | ALTER TABLE `wp_wpr_queue` CHANGE `attachimages` `attachimages` TINYINT NOT NULL |
| 706726 | xxxxx_tvorba | localhost | xxxxx_tvorba | Query | 0 | Locked | ALTER TABLE `wp_wpr_queue` CHANGE `htmlenabled` `htmlenabled` TINYINT NOT NULL |
| 706728 | xxxxx_tvorba | localhost | xxxxx_tvorba | Query | 5 | Locked | ALTER TABLE `wp_wpr_queue` CHANGE `sent` `sent` INT NOT NULL |
| 706764 | xxxxx_tvorba | localhost | xxxxx_tvorba | Query | 2 | Locked | ALTER TABLE `wp_wpr_queue` CHANGE `sid` `sid` INT NOT NULL |
| 706765 | xxxxx_tvorba | localhost | xxxxx_tvorba | Query | 9 | Locked | ALTER TABLE `wp_wpr_queue` CHANGE `delivery_type` `delivery_type` tinyint(1) NOT NULL DEFAULT '0' |
| 706767 | xxxxx_tvorba | localhost | xxxxx_tvorba | Query | 19 | Locked | ALTER TABLE `wp_wpr_queue` CHANGE `htmlenabled` `htmlenabled` TINYINT NOT NULL |
| 706768 | xxxxx_tvorba | localhost | xxxxx_tvorba | Query | 11 | Locked | ALTER TABLE `wp_wpr_queue` CHANGE `delivery_type` `delivery_type` tinyint(1) NOT NULL DEFAULT '0' |
| 707104 | xxxxx_tvorba | localhost | xxxxx_tvorba | Query | 0 | Opening tables | UPDATE wp_wpr_followup_subscriptions set sequence='-2', last_date='1326373862' where id='125' |
| 707363 | xxxxx_tvorba | localhost | xxxxx_tvorba | Query | 0 | creating table | ALTER TABLE `wp_wpr_subscription_form` CHANGE `confirmed_subject` `confirmed_subject` TEXT CHARACTER |