At 01:55 PM 9/11/2002, you wrote:
>Version: MySQL.3.22.32-log
>
>Does this problem ring a bell with anyone?
>I'm seeing two undesired behaviors, both, *I think*
>seem to be because I'm pounding a lot of connections
>against the same server/table, all from the same
>remote host. The workload that reaches MySQL is
>a succession of CONNECT->QUERY (very simple)-> QUIT,
>say 200 times per second. After about the first 4000
>connections, MySQL restarts, complaining that
>mysqld is hanging.
>
>Secondly, prior to the restart, an occasional connection
>is denied because of an invalid password! All connections
>are requested by the same user with the same password.
>
>Please, someone, tell me that these 2 problems are both
>load related, were found and corrected by a later release
>than the one I have.
>
>Thanks,
>
>Kent Hoover
Kent,
Just a thought, but if your table is read-only and not extremely
large, have you thought of changing it to a heap table? When the server
starts up, create the heap table and import the MYISAM table into it. Use
something like "Create table h_mytable select * from mytable
type=heap". Then build the indexes for it. Heap tables may solve the
problem even for tables with a few thousand rows. Latency because of disk
access is also reduced. If you do need to write to it, add a TimeStamp
column and every 30 seconds write the modified rows back to the original
table.
Mike
(sql query)
>---------------------------------------------------------------------
>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
---------------------------------------------------------------------
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
