2,912 reputation
513
bio website blog.9minutesnooze.com
location New York, United States
age
visits member for 2 years, 9 months
seen Jul 1 at 20:09

I'm a Systems Engineer on the Technical Operations team at Amplify Education. I occasionally blog at The 9 Minute Snooze.


Jun
3
awarded  Enlightened
Jun
3
awarded  Nice Answer
Oct
12
awarded  Yearling
Mar
22
revised Does MySQL have problems with nested insert like with subqueries in where?
OR, not ON
Mar
17
comment MySQL: Can't find .ibd files after turning on innodb_file_per_table
Did you compile mysql yourself?
Dec
22
awarded  Nice Answer
Oct
12
awarded  Yearling
Aug
30
answered Could running ANALYZE on all databases on large InnoDB tables show some performance increase?
Aug
25
answered Sub-query executes 1 time for a parent query or more?
Aug
15
awarded  Nice Answer
Aug
13
comment How to shard 14 gb of data for archival database?
It depends on your use case. It could be enough if you don't need all of the data in memory at once. If it's not enough, then scale up. Sharding should be the scaling technique of last resort. Benchmark.
Aug
11
comment MySQL replication fails due to duplicate keys after master is restarted
Setting the skip counter doesn't rebuild the slave from the master, it just skips one statement from executing on the slave.
Aug
11
comment How can I speed up “show columns” on MySQL?
Have you considered ALTER TABLE foo ENGINE=InnoDB? :) Is there a good reason for using MyISAM?
Aug
11
answered How can I speed up “show columns” on MySQL?
Aug
9
revised Is it possible to pass parameters to pt-table-checksum using an options file?
config file documentation
Aug
9
comment Is it possible to pass parameters to pt-table-checksum using an options file?
There is a --config option to read arguments from a file.
Aug
9
comment Is it possible to pass parameters to pt-table-checksum using an options file?
I like this approach. We also have a wrapper around pt-table-checksum which checks which of our active/passive master/master pair is active and only runs the checksum on that server.
Aug
9
answered Is it possible to pass parameters to pt-table-checksum using an options file?
Aug
5
comment How to shard 14 gb of data for archival database?
Why do you think that you need to shard such a small table?
Aug
3
comment many 'unauthenticated user', 'connecting host', in show full processlist (Mysql 5.1.5)
Mahesh covered the answer, but please, upgrade your MySQL installation. The early 5.1 builds were some of the worst in the history of MySQL. At least upgrade to a more recent 5.1.x build (5.1.63 is the latest 5.1 rev).