206 reputation
19
bio website serverfault.com
location Manchester, NH
age 39
visits member for 1 year, 11 months
seen 6 hours ago

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.


Jun
13
comment Virtual SQL Server not consuming enough CPU
That's the version, not the edition. And I'm not as interested in the hypervisor as in the CPU topology that it's providing to the VM. Coreinfo can show you this.
Jun
13
comment Virtual SQL Server not consuming enough CPU
Which edition of SQL Server are you running? What is the hypervisor?
May
28
comment mySQL Optimization Suggestions
Have you run a full reindex on your catalog?
May
19
comment MySQL dump error (#1005 - Can't create table 'novephp_cz_bv.jos_jquarks_customsets' (errno: 150))
MySQL error code 150: Foreign key constraint is incorrectly formed
Apr
28
comment AES 256 data encryption on Mysql
Encrypt the hard drive?
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.