206 reputation
19
bio website serverfault.com
location Manchester, NH
age 39
visits member for 2 years, 3 months
seen Nov 21 at 2:47

Moderator at Server Fault.

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

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


Nov
7
comment MySQL 5.6: creating users kills mysql, and mysql_upgrade fails
Dump and reload.
Aug
24
comment Postgresql tries to connect to fe80::1, permission denied
There's no need for that to be in there. The only addresses that should be resolving to localhost are 127.0.0.1 and ::1.
Aug
18
comment Postgresql tries to connect to fe80::1, permission denied
No, the resolver isn't busted; the IP stack is busted. The loopback interface is not intended to have any link-scope address other than ::1. Unfortunately RFC 4007 is poorly written and this requirement is not made clear enough. Windows and Linux get it right; OS X (which appears to be the OS in use here) doesn't.
Aug
14
comment Connecting to MYSQL on an EC2 instance
Is it "zapier" or "zapper"? You have spelled it both ways several times.
Aug
12
comment Can MySQL reasonably perform queries on billions of rows?
Were you actually on a 64-bit OS at the time?
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