I think my mysql is resolving host names, and I would prefer it to not,
where do I set skip-name-resolve to prevent it?
Thanks.
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 06, 2003 8:43 AM
To: Daniel Kiss
Cc: [EMAIL PROTECTED]
Subject: Re:
it everything comes to a halt for
a good 30-40 seconds.
I can't make these long queries any faster. What can I do?
Thanks,
Nihal
-Original Message-
From: Matt W [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 05, 2003 7:09 PM
To: Nihal; [EMAIL PROTECTED]
Subject: Re: INNODB flush
I am running FLUSH TABLES manually. I am doing it each hour to generate
a bin file, for incremental backups.
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 06, 2003 10:05 AM
To: Nihal
Cc: [EMAIL PROTECTED]
Subject: Re: INNODB flush holdup
I've recently switched from GEMINI to INNODB, to be able to get
continued support and upgrades of MySQL.
I'm running into to some major performance issues. The section in the
MySQL manual is not very thorough on optimizing INNODB.
I'm getting two problems, either all my queries pile up, or a
OK, I've got another quandary, thanks for the help on the last one, I'm
working on it.
| 15203 | root | web:36810 | ez2000 | Query | 137 | Sorting
result| SELECT from table_a |
| 15235 | root | web:36849 | ez2000 | Query | 67 | Sorting
result| SELECT from table_a |
|
4.00beta, that has support for both GEMINI and INNODB, will using this
version cause problems for me?
Thanks,
Nihal