One of very interesting techniques Innodb uses is technique called “doublewrite” It means Innodb will write data twice when it performs table space writes – writes to log files are done only once.
So why doublewrite is needed ? It is needed to archive data safety in case of partial page writes. […]
If you care about archiving best performance in your application using MySQL you should learn about prepared statements. These do not neccesary provide performance beneft but they may, they also have other benefits.
As a quick introduction – before MySQL 4.1 there were only textual statements and textual protocol for data […]
I’m leaving MySQL starting 1st of August. This is surely not news for my collegues and friends who knew this is comming.
We’re starting our own company which will provide MySQL Consulting services. We’ll focus on MySQL Performance Optimization but will be able to help pretty much with all MySQL related […]
MySQL is known for its stability but as any other application it has bugs so it may crash sometime. Also operation system may be flawed, hardware has problems or simply power can go down which all mean similar things – MySQL Shutdown is unexpected and there could be various inconsistences. And this […]Read more