-----BEGIN PGP SIGNED MESSAGE-----
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
- --
Danny Haworth
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Ge2 System Administrator
Gas~Elec Safety Systems
Tel : 01895 422 997
Email : [EMAIL PROTECTED] (mailto:[EMAIL PROTECTED])
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQE9iJstUKf+497XC3QRAneNAJ996eZ7vYchyQ/VTffyvgPP4WZklACeOi6b
o2M29ZjPj7bBHt0kC8amLQI=
=aXgE
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
