Stack Exchange

Morgan Tocker

Toronto, Canada

tocker.ca

I answer questions mostly about MySQL / the InnoDB storage engine.

I've previously worked for MySQL AB (and Sun via acquisition), and Percona - authors of www.mysqlperformanceblog.com.

top accounts reputation activity favorites subscriptions
Top Questions
Top Answers
15
sql error errno: 121
stackoverflow.com

11
Which MySQL Fork/Version to Pick?
stackoverflow.com

9
How to speed up a data loading into InnoDB (LOAD DATA INFILE)?
stackoverflow.com

8
How to improve INSERT INTO … SELECT locking behavior
stackoverflow.com

8
Indexing from start or when performance problem arises?
dba.stackexchange.com

7
mysql “drop database” takes time — why?
stackoverflow.com

7
How many rows will be locked by SELECT … ORDER BY xxx LIMIT 1 FOR UPDATE?
stackoverflow.com

7
Effect of Oracle on MySQL
dba.stackexchange.com

6
In MySQL, does the order of the columns in a WHERE clause affect query performance?
dba.stackexchange.com

5
Is there a noticable difference between innodb and XtraDB?
stackoverflow.com

5
Is INNODB enabled by default in MySQL?
stackoverflow.com

5
what is the equivalent query in mysql?
stackoverflow.com

5
How to read innodb log file?
stackoverflow.com

5
Can I have create an InnoDB table without a PK? If so, would a secondary index be used as the clustered index?
dba.stackexchange.com

5
Performance implications of MySQL VARCHAR sizes
dba.stackexchange.com

5
MySQL for Administrators course from Oracle: worth it?
dba.stackexchange.com

5
Where does my.cnf get stored in Linux?
dba.stackexchange.com

5
What should I ask at a MySQL DBA interview?
dba.stackexchange.com

5
Consistent logical backup of databases that use MyISAM and InnoDB engines
dba.stackexchange.com

5
MySQL table_cache and Opened_tables
dba.stackexchange.com

5
Is XtraDB stable enough for production?
serverfault.com

5
What are the pros & cons of these MySQL engines for OLTP — XtraDB, PBXT, or TokuDB?
serverfault.com