smf_log_activity table

Started by Realinfo, April 23, 2013, 09:16:42 AM

Previous topic - Next topic

Realinfo

Quote from: Arantor on May 02, 2013, 09:35:09 PM
I give up trying to help you. You continually refuse to answer any question I actually ask, which means no-one can help you.

What are your questions ?

Ask me in points, i will answer them.

Thanks

Realinfo

Quote from: Liam_michael on May 02, 2013, 10:15:11 PM
Quote from: Realinfo on May 02, 2013, 09:33:04 PM
Is it an InnoDB table

2.0.4 default theme

any solution for SLOW QUERY?

can we fix time for query? I mean like after 60 seconds qurey will be disabled, or something like that

Queries are considered "slow" if they are poorly written. If it takes the query a long time to execute (because of poor programming), it means it wasn't written properly (i.e. no limits or some sort of loop). All SMF queries, as far as I'm concerned are executed with great efficiency.

Most of time it's working on but near about 1:00pm GMT or on high traffic, i have this problem of slow query and by slowquery MYSQL got hang

Advertisement: