206 reputation
19
bio website serverfault.com
location Manchester, NH
age 39
visits member for 1 year, 8 months
seen Apr 5 at 4:08

Moderator at Server Fault.

Contract system administrator since time out of mind. I can also read your code!

Do you miss seeing users' accept rates? Try my Accept Rate user script for Chrome!

If your DevOps is all Dev and no Ops, and you need help, contact me.


Mar
31
comment Every 30 minutes mysql stuck for 20-30 seconds
possible duplicate of Every 30 minutes mysql stuck for 20-30 seconds
Feb
19
awarded  Commentator
Feb
19
awarded  Yearling
Feb
16
comment MySQL “lost” all data(InnoBD)
@ChrisS It may have been a rude criticism, but it was correct. I did edit the answer to account for it.
Feb
16
answered MySQL “lost” all data(InnoBD)
Dec
11
awarded  Critic
Sep
13
comment Query getting periodically stuck in 'copying to tmp table' state, never completes
What is that /var/tmpfs? Did you make that yourself?
Aug
26
comment MySQL probelm in port: 3306
Use something like innotop to find out which queries are taking up all the CPU and which user ran the queries.
Aug
1
awarded  Autobiographer
Jul
16
awarded  Citizen Patrol
Jul
8
comment Mysql raising intermittent “system error: 32” errors on connect
Have you checked MySQL's logs?
Jul
3
answered Is MySQL replication okay after writing to slave then making identical write to master?
Jul
2
awarded  Talkative
May
26
awarded  Supporter
May
26
comment Setting mysql slow query to less than 1 second
You must be running EL5, then. EL6 came with MySQL 5.1, or you can get a third party repository such as remi to use MySQL 5.5 or higher.
May
26
awarded  Teacher
May
26
comment Setting mysql slow query to less than 1 second
Yes, become the system administrator and run your server yourself. We're generally unable to help in situations where you are not the server administrator.
May
25
answered Setting mysql slow query to less than 1 second
Mar
6
comment How to properly kill MySQL?
mytop is ancient and unmaintained. You should probably use innotop on a modern system.
Feb
28
awarded  Editor