EmergencyEMERGENCY? Get 24/7 Help Now!

INSERT INTO … SELECT Performance with Innodb tables.

 | July 12, 2006 |  Posted In: Insight for DBAs

Everyone using Innodb tables probably got use to the fact Innodb tables perform non locking reads, meaning unless you use some modifiers such as LOCK IN SHARE MODE or FOR UPDATE, SELECT statements will not lock any rows while running. This is generally correct, however there a notable exception – INSERT INTO table1 SELECT * […]

Read More

Thoughts on MySQL Replication

 | July 7, 2006 |  Posted In: Insight for DBAs

Brian Aker recently published good write up about using MySQL replication. The piece I find missing however is good description of warning about limits of this approach as well as things you need to watch out for. You can call me person with negative mind but I tend to think about limits as well. So […]

Read More

Choosing proper innodb_log_file_size

 | July 3, 2006 |  Posted In: Insight for DBAs

If you’re doing significant amount of writes to Innodb tables decent size of innodb_log_file_size is important for MySQL Performance. However setting it too large will increase recovery time, so in case of MySQL crash or power failure it may take long time before MySQL Server is operational again. So how to find the optimal combination […]

Read More