As you can read from my Innodb Architecture and Performance Optimization presentation Innodb automatically manages undo area in system tablespace so you never need to care about it. I present it as positive feature reducing administration effort needed but it also can cause a troubles as it happened for me today:
InnoDB: 11 transaction(s) […]Read more
I’m just back from OpenSource Database Conference and PHP International Conference which took place in Frankfurt.
I’ve uploaded slides for two talks I’ve been giving which you might want to check out.
In general Database portion of the conference was a bit boring. May be because it was not widely announced or may be […]
I’ve run into the following thread couple of days ago:
Basically someone is using sphinx to perform search simply on attributes (date, group etc) and get sorted result set and claiming it is way faster than getting it with MySQL. Honestly I can well believe it for cases when you […]
If you’re following MySQL or PHP landscape you should have seen announcement by MySQL to develop pure PHP driver. If not – Here is FAQ .
I’m to meet the team (Georg, Andrey etc) which will be developing this driver during my visit to Open Source Database Conference in November so I thought it would […]