161 reputation
15
bio website
location
age
visits member for 4 years, 4 months
seen Mar 4 at 21:01

Jan
17
awarded  Scholar
Jan
17
accepted Why do MySQL queries pile up in “Sending data” state?
Jan
17
answered Why do MySQL queries pile up in “Sending data” state?
Dec
24
awarded  Notable Question
Mar
19
awarded  Popular Question
Sep
28
awarded  Student
Dec
1
comment Why do MySQL queries pile up in “Sending data” state?
I so wish the NOC would let us install innotop...
Dec
1
comment Why do MySQL queries pile up in “Sending data” state?
InnoDB seems to be using an auto-increment lock for inserting new rows, which I have seen as an infrequent deadlock in show innodb status.
Dec
1
comment Why do MySQL queries pile up in “Sending data” state?
query_cache_size: 67108864 (64M) sort_buffer_size: 524280 (512K) innodb_buffer_pool_size: 26843545600 (25G) table_cache: 10240 open_files_limit: 22990 sysctl fs.file-max: 3150937 ulimit -Hn: 1024 ulimit -Sn: 1024
Dec
1
comment Why do MySQL queries pile up in “Sending data” state?
The swap space is almost unused at the moment, with (only!) about 40% of the physical memory used by MySQL. I wish I had better stats on that for the slow time, but it didn't look like swap was thrashing. Thank you for the command hints to be certain, though.
Dec
1
comment Why do MySQL queries pile up in “Sending data” state?
Operating system: Red Hat Enterprise Linux ES release 4 (Nahant Update 5)
Dec
1
comment Why do MySQL queries pile up in “Sending data” state?
I don't believe any hypervisor is in use, but it's not impossible. If so, I have no access to it, though the system does seem to have direct access to the hardware.
Dec
1
comment Why do MySQL queries pile up in “Sending data” state?
Sorry; I forgot to specify that the COUNT(*) queries were using a WHERE. The purpose was to point out how little information would actually be sent.
Nov
30
comment Why do MySQL queries pile up in “Sending data” state?
I would have thought so, too, until we discovered that restarting the database server fixed the problem. However, the "Sending data" state could very well be the result of the web servers giving up without disconnecting; in that case, it's a symptom of a much deeper issue. Where should I look?
Nov
30
asked Why do MySQL queries pile up in “Sending data” state?
Oct
19
comment How to watch logs in real time via Terminal?
For a small enough site, watching the logs is kind of fun, and can give you a general feel for how well your expectations are being met. In any case, the question just uses the movie as inspiration, asking "How can I do something like that?" instead of "How did they do that?"
Aug
10
awarded  Supporter
May
14
answered Error with Apache2 on Debian Lenny: “Could not reliably determine the server's fully qualified domain name, using 127.0.1.1 for ServerName”
Apr
23
awarded  Teacher
Apr
23
answered How long do you keep log files?