MySQL errors – queries causing database delay

Hello,

My s2member site was loading slowly, so I contacted my hosting company and they informed me that a few s2member SQL queries are stuck, looping, and that I may provide the problematic queries to you for advice. Those are pasted below in two groups: 1) a set of queries and 2) an error that the hosting logs may have received.

My databse is called bloomsou_serenafit2 – obviously the 5.6s query time is an issue.

I don’t have logging/debugging enabled since this site is live.

1)

MySQL Queries

# Tue Jul 9 07:10:05 2013
# Query_time: 5.633323 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1373375405;
SET NAMES utf8

# Tue Jul 9 07:10:36 2013
# Query_time: 8.530148 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1373375436;
SET NAMES utf8

# Tue Jul 9 07:10:40 2013
# Query_time: 2.607986 Lock_time: 1.344371 Rows_sent: 249 Rows_examined: 313
use bloomsou_serenafit2;
SET timestamp=1373375440;
SELECT option_name, option_value FROM cjq_options WHERE autoload = ‘yes’

# Tue Jul 9 07:10:46 2013
# Query_time: 1.590615 Lock_time: 0.168314 Rows_sent: 0 Rows_examined: 0
use bloomsou_serenafit2;
SET timestamp=1373375446;
SELECT option_value FROM cjq_options WHERE option_name = ‘widget_pages’ LIMIT 1

# Tue Jul 9 07:10:59 2013
# Query_time: 5.787533 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1373375459;
SET NAMES utf8

2)

Today’s error:

Jul 9 10:08:00 box449 mysqld: 130709 10:08:00 [ERROR] Invalid (old?) table or database name ‘lost+found’

Your help is most appreciated. Thanks very much.

DB

Looking at this again, I’m wondering whether there is enough information to expect help on this question.

If anyone from support as looked at this thread, I’m happy to provide more info, but I was under the impression that there may be a simple setting change that could fix the problem with the NAMES issue, above.

Any advice is appreciated.

DB

I can’t tell much from the info there… But this seems to be unique to your installation. We haven’t seen this before during testing or from any other site owner that I remember.

Could you please try these? Knowledge Base » Common Troubleshooting Tips :)

Thanks! I will.

DB