206 reputation
19
bio website serverfault.com
location Manchester, NH
age 39
visits member for 2 years
seen 2 days 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.


2d
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
Jul
8
comment Mysql raising intermittent “system error: 32” errors on connect
Have you checked MySQL's logs?