How do I fix a Database Query that is Crashing Site

  • westcoastkate

    (@westcoastkate)


    10 years, 4 months ago

    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.

    http://wordpress.org/plugins/woocommerce/

Viewing 4 replies - 1 through 4 (of 4 total)
  • vark

    (@vark)

    10 years, 4 months ago

    If you still have ftp access, you can go in and move or delete the woocommerce plugin folder. Then all should be calm, and hopefully you can get access to wp-admin again from your host. Then on to figuring out what’s causing all the ruckus.

    Thread Starter westcoastkate

    (@westcoastkate)

    10 years, 4 months ago

    Ok I can do that. If I delete the woo commerce folder, can I simply do a new install of the plugin? Will that fix the table issue?

    Thread Starter westcoastkate

    (@westcoastkate)

    10 years, 4 months ago

    does anyone have a solution or idea for this or do I just need to abandon woocommerce? I deleted the plugin and reinstalled it but the problem still exists. I have no idea what to do?

    vark

    (@vark)

    10 years, 4 months ago

    (1) how did you load the tax table
    (2) in phpmyadmin, how big are the 2 tax tables
    (3) backup all the db tables
    (4) in phpmyadmin, empty the 2 tax tables
    (5) test and see if that fixes the immediate issue

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘How do I fix a Database Query that is Crashing Site’ is closed to new replies.