[Resolved] query causing slow site/db connection issues??
Our site has been running slow and we’ve been having database connection issues. I put in a ticket to our hosting company and they responded with the message below. Can you let me know if this is something that could be changed??? (Or if you need more info, what I need to ask my hosting company for??)
Thank you for contacting HostGator. One of your plugins, amr-users, runs the following query when trying to determine the user fields in WordPress:
SELECT DISTINCT(COLUMN_NAME) FROM information_schema.COLUMNS WHERE TABLE_NAME = “wp_users”;
Lavender’s mysql process has been killed 57 times in the past 24 hours while it was running this query. This query is especially discouraged on Shared servers with over thousands of other users and databases in mysql. Essentially it has to go over all the permissions for your user against the other users databases. This can take minutes to complete. We recommend that you talk to the developer of this plugin about changing their code to something less intensive.
More information about this can be found at the following link:
There is a way to mitigate this query and make it run in a shorter amount of time, but know that it is still highly discouraged. You can add “table_schema=”lavender_wrdp1″ and” after the “WHERE” and it will start in your WordPress database’s schema. The new query would look like:
SELECT DISTINCT(COLUMN_NAME) FROM information_schema.COLUMNS WHERE table_schema=”lavender_wrdp1″ and TABLE_NAME = “wp_users”;
- The topic ‘[Resolved] query causing slow site/db connection issues??’ is closed to new replies.