innodb_file_per_table=1, InnoDB places every table’s data and indexes in a separate
.ibd file, but there is still a “global” system tablespace, stored by default in a file named
ibdata1. This contains some of each table’s data, such as the undo log and insert buffer. If it is fixed-size, you can fill it up and crash the server, as I’ve mentioned in a few recent blog posts.
You surely have heard about Percona Live,NY taking place October 1-2 in New York, you however might have been wondering what kind of talks you would see on this event and why would should you attend.
I previously blogged about work I was doing on automatically finding problems in a MySQL server, with no hardcoded thresholds or predetermined indicators of what is “bad behavior.” I had to pause my studies on that for a while, due to time constraints. I’ve recently been able to resume and I’m happy to report that I’m making good progress.
The second edition of High Performance MySQL has 27 reviews on Amazon, but the third edition only has 5 so far. By this point I assume many of you have a copy and have read it cover to cover. I’d really appreciate your reviews — when purchasing, people look not only at the star rating but at the number of reviews. You can create a review here. And thanks!
While doing a performance audit for a customer a few weeks ago, I tried to improve the response time of their top slow query according to
pt-query-digest‘s report. This query was run very frequently and had very unstable performance: during the time data was collected, response time varied from 50µs to 1s.