Aaron Brick writes:
> good day -
>
> i have found cases in which the daemon blocks waiting on a select() and
> just plain refuses to process certain queries. since i am reading in a 60
> meg file, meaning about 3.5 million queries, this consistently happens
> somewhere in the middle. i am using 3.23.41.
>
> restarting the server or rebooting the machine don't seem to affect the
> problem. i don't know what the daemon is waiting for - can i do some
> useful analysis with strace and lsof? if this is a bug, i would love to
> contribute a report of it.
>
> any suggestion is welcome; i'm really puzzled!
>
> thanks,
>
> aaron brick.
>
> ps - i include the word "database" so the filter lets me post this.
>
> _________________________________________________
> | |
> | Aaron Brick (415) 902 - 7209 |
> | [EMAIL PROTECTED] Room 3501C, SFGH |
>
> Programmer Analyst, Functional Genomics Core
> Sandler Center for Basic Research in Asthma
> Lung Biology Center, Department of Medicine
> San Francisco General Hospital
> University of California, San Francisco
>
>
>
Can you run mysqladmin proc ??
May be your LOAD DATA has locked a table and all connections are
waiting for a table to be released ??
If that is not a case, you might have problem with kernel or thread
lib.
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
---------------------------------------------------------------------
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
