On Mon, 12 May 2008 at 11:58 -0400, [EMAIL PROTECTED] confabulated:
You could also do:
SET GLOBAL expire_log_days=n;
You forgot the 's' in log:
SET GLOBAL expire_logs_days=n;
BTW - this same hint is on the the very same manual page you mentioned
at the beginning of this thread.
--
On Thu, 24 Apr 2008 at 08:58 +0200, [EMAIL PROTECTED] confabulated:
D Hill schrieb:
I have something I am trying to resolve with an over abundant number of
slow queries. Perhaps it is because of some additional indexes needed. As
soon as I enabled the option 'log_queries_not_using_indexes
On Thu, 24 Apr 2008 at 10:16 -0400, [EMAIL PROTECTED] confabulated:
On Thu, Apr 24, 2008 at 2:54 AM, Sebastian Mendel
[EMAIL PROTECTED] wrote:
IMHO not in this case, cause it is just a simple WHERE field IN ()
I'm pretty sure that just looks like a bunch of ORs to MySQL. If it
didn't use
I have something I am trying to resolve with an over abundant number of
slow queries. Perhaps it is because of some additional indexes needed. As
soon as I enabled the option 'log_queries_not_using_indexes = 1' in the
configuration file, I started getting messages relating to the select
On Mon, 10 Mar 2008 at 14:29 -0400, [EMAIL PROTECTED] confabulated:
Hello,
I have a huge database that I would like to migrate from a server
running 4.0.16 to a server running the Windows version 5.0.45. The
database is approximately 3,500,000 records. I get timeout errors using
PHPMyAdmin to