Reputation
Top tag
Next privilege 100 Rep.
Edit community wikis
Badges
7
Newest
 Promoter
Impact
~17k people reached

  • 0 posts edited
  • 0 helpful flags
  • 12 votes cast
Nov
9
comment mysql stops responding periodically
Thanks for a great answer. [1] No, I have not monitored Disk I/O (yet). [2] I don't know how to monitor queued transactions. [3] mysqltuner says the highest usage of available connections is 15 % (157 used out of 1024 available). Unfortunately the site is currently not under this load so the freeze doesn't happen anymore. But I will setup I/O monitoring and try to provoke the freeze via a load test and watch what happens with I/O and queued transactions.
Nov
9
revised mysql stops responding periodically
Update with mysql config and ram usage
Nov
9
comment mysql stops responding periodically
I were running with 256 GB RAM and a 950 Mb swap partition which was never utilized. I have updated innodb_buffer_pool_size to 10G (mysqltuner says 5.5 Gb is used). Also these settings, key_buffer = 16M max_allowed_packet = 16M thread_stack = 192K thread_cache_size = 8 max_connections = 1024
Nov
9
awarded  Promoter
Nov
3
awarded  Editor
Nov
3
revised mysql stops responding periodically
Update with system load.
Nov
3
comment mysql stops responding periodically
Certainly. The system load (1 minute load) typically peaks at 27-28, but can rise to as high as 40 under extreme load. When this freeze occurs, the load is typically 22-27 both before and during the freeze. All available CPU cores (32) have idle time. What system logs are of interest?
Nov
3
asked mysql stops responding periodically
Oct
15
comment How can I restart “monit” when it stops or crashes?
Actually, monit can die/be killed. It have happened to me on numerous occasions when a host has run out of RAM+swap. To be honest, this is in a fairly large server park.
Oct
2
awarded  Popular Question
Mar
2
answered Ubuntu 14.04 System Logging
Nov
22
comment “No input file specified” when running php under fastcgi inside chroot under nginx outside of chroot
Well, no... I didn't forget to translate to chrooted path. In fact, I did just that, and it would have worked if I hadn't made two errors. One of them was fixed either by setting a new root (which I had tried but that didn't work because of another error), or omitting the include or moving the include to the top of my location block. But the real culprit was that I mixed up SCRIPT_NAME and SCRIPT_FILENAME. So, long story short: I mixed up SCRIPT_NAME/SCRIPT_FILENAME and had some issues with my variables being overridden by the non-chrooted path.
Nov
22
awarded  Teacher
Nov
20
awarded  Student
Nov
20
asked “No input file specified” when running php under fastcgi inside chroot under nginx outside of chroot
Nov
20
answered “No input file specified” when running php under fastcgi inside chroot under nginx outside of chroot
Jun
12
awarded  Supporter
Feb
29
awarded  Autobiographer