How do I fix a Database Query that is Crashing Site
The plugin was working fine up until I uploaded the tax tables. As soon as the tax tables were installed the site stopped working and my host shut down my entire hosting account due to excessive querys that were harming other sites on the server. I’ve spent nearly 10 hours with my hosts support and they are useless. Access to my wp dashboard has been cut off so I can’t easily uninstall and reinstall the plugin. How do I fix this?
It appears to be running a very intensive query involving some large tables in the the smbutfly_wrdp26 database. The query is quite long so I’ve attached it as a text file for your review.
The issue is its using order by commands which result in the tables being copied to a temporary table which uses a lot of time (and in most cases, the query is killed before it can even complete). The tables in question are listed below along with their size:
| Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment |
| wp_woocommerce_tax_rate_locations | MyISAM | 10 | Dynamic | 109185 | 32 | 3504304 | 281474976710655 | 2309120 | 0 | 109186 | 2013-11-26 08:40:26 | 2013-12-10 18:00:05 | NULL | utf8_general_ci | NULL | | |
| wp_woocommerce_tax_rates | MyISAM | 10 | Dynamic | 109185 | 24 | 2671296 | 281474976710655 | 4083712 | 0 | 109186 | 2013-11-26 08:40:26 | 2013-12-10 18:00:05 | NULL | utf8_general_ci | NULL | | |
As you can see these two tables are quite large and the query itself is quite over complicated. Unfortunately I do not have a solution to this problem as it’s a change that would need to be implemented in to the plugin directly. The plugin is a third party piece of software so we cannot provide direct support but it is widely used so the developer should be able to offer some assistance. If possible, you should see if the feature that needs the query be disabled or the table size be reduced.
- The topic ‘How do I fix a Database Query that is Crashing Site’ is closed to new replies.