Z-Car

Ramblings about everything from Cars to Computers

MySQL Collate and Case Sensitivity – Flexible Compare

By Prodromus August 31, 2010 MySQL No Comments

In a typical MySQL installation, the default character set and collation are latin1 and latin1_swedish_ci. This means that all string comparisons will be performed in a case insensitive manner. So, ‘Search String’=’search string’. This…

Top My.CNF Optimizations for Innodb

By Prodromus August 20, 2010 MySQL, Optimization No Comments

These are the four parameters which will have the most affect on the performance of MySQL 5.1x and Innodb. If you are suffering from poor performance, try changing the…

MySQL – Disabling Binary Logging for INSERT and UPDATE

By Prodromus June 2, 2010 MySQL, Replication 1 Comment

I have run into many situations where there would be a benefit to not replicate a large INSERT or UPDATE from the MASTER to SLAVE in order to not block…