Introduction
In this article I will describe how logs work with MySQL and InnoDB. Very little of this material is in the manual. I gleaned it from the source code while researching for our latest book (SQL Performance Tuning by Peter Gulutzan and Trudy Pelzer).
If you've ever worked with MySQL and InnoDB tables then this article should give you some "insider" knowledge that you wont find anywhere else, so sit back and get ready to read!
Read More...
Practical Date and Time examples with PHP and MySQL Categories : Databases , MySQL , PHP , Date/time Creating an IE-Only Database Driven Menu System With PHP, MySQL and DHTML Categories : PHP , MySQL , Databases , DHTML PHP, MySQL and Authentication 101 Categories : PHP , Databases , MySQL , Authentication Building A Persistent Shopping Cart With PHP and MySQL Categories : PHP , MySQL , Databases , Ecommerce Speaking SQL part 2 Categories : General SQL , Databases , MySQL Managing Foreign Key Relationships In MySQL Using SQLyog Categories : Databases , MySQL , SQLyog Creating Users and Setting Permissions in MySQL Categories : Databases , MySQL Start Using MySQL Categories : MySQL , Databases , To MySQL , Beginner Guides Alternating row colors with PHP and mySQL Categories : PHP , Databases , MySQL , HTML and PHP Miles To Go Before I Sleep... Categories : PHP , Calendar , Databases , MySQL Multicolumn Output from a Database with PHP Categories : PHP , Databases , HTML and PHP , MySQL Simple Connection to MySQL with PHP Categories : PHP , MySQL , Databases Using Transactions In MySQL Part 1 Categories : Databases , MySQL , Transactions Date Arithmetic With MySQL Categories : PHP , Databases , MySQL , Date Time Time Is Money Part 1 of 2 - Designing and implementing a Web-based application Categories : PHP , Databases , MySQL , Complete Programs