MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Danny Haworth Date:September 18 2002 3:26pm
Subject:Re: My Replication Story
View as plain text  
Hash: SHA1

Victoria Reznichenko wrote:
| As far as I remember there was found and fixed the similar bug in
| 4.0.3. Could you provide output of SHOW CREATE TABLE for testing?

Hi Victoria,

	When you say 'SHOW CREATE TABLE' I assume you mean during the creation of
the temporary table (SHOW CREATE TEMPORARY TABLE)? In which case mysql
politely informs me that i have an error in my SQL syntax ;-)

I cant afford to take down the master database since it is in use round
the clock but i have upgraded the slave server to 4.0.3 with an
identical copy of the data restored from dds. I was unable to reproduce
the problem either, probably because the database wasn't under load just
merely hosting my single connection.

Strangely this is the same behaviour I got from the main database after
its upgrade, worked fine with 2-3 connections but started jumpin' under
real load.

I know this probably isn't of much use to you, i'll try writing up a few
perl scripts to create some "virtual load" and see what happens then.

If there's anything else i can provide for you to help trace this bug
down. let me know.


- --

Danny Haworth
Ge2 System Administrator
Gas~Elec Safety Systems
Tel : 01895 422 997
Email : dan@stripped (mailto:dan@stripped)
Version: GnuPG v1.0.7 (GNU/Linux)
Comment: Using GnuPG with Mozilla -


My Replication StoryDanny Haworth18 Sep
  • re: My Replication StoryVictoria Reznichenko18 Sep
    • Re: My Replication StoryDanny Haworth18 Sep
      • re: Re: My Replication StoryVictoria Reznichenko21 Sep