Hello
I tried upgrading from MySQL-3.21.33 to 3.23.35 on an old linux host. It
worked but the new mysql version was *horrible* slow. E.g. under exactly
same situations I came to ca. 300 inserts/second with the old and 20 with
the new version making it absolutely unusable :-(
The only recognisable difference between the both was that the new mostly show
| 107 | root | localhost | westend | Query | insert into channel_traffic
|(timestamp, hostname, inte ...
when I enter mysqladmin processlist whereas the old one mostly said
| 107 | root | localhost | westend | Init | insert into channel_traffic
|(timestamp, hostname, inte ...
I know that a query traverses several states but it is strange that the
new version takes so long in this "Init" state. As it works well on a
nother host with a recent linux distribution I guess there're some problems
with...something...
Can anybody explain what "Init" does?
thanks in advance,
-christian-
--
Christian Hammers WESTEND GmbH - Aachen und Dueren Tel 0241/701333-0
[EMAIL PROTECTED] Internet & Security for Professionals Fax 0241/911879
WESTEND ist CISCO Systems Partner - Premium Certified
---------------------------------------------------------------------
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
