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

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?
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?"