3,052 reputation
616
bio website blog.9minutesnooze.com
location New York, United States
age
visits member for 3 years, 2 months
seen Nov 29 at 21:28

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


Dec
10
awarded  Nice Answer
Oct
12
awarded  Yearling
Sep
30
awarded  Explainer
Sep
24
awarded  Autobiographer
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.