Monthly Archives - September 2007

Heikki Tuuri to answer your in depth Innodb questions

Have you ever had a question about Innodb internal design or behavior which is not well covered in MySQL manual ? I surely had.
Now you have a great chance to have them answered !
Heikki Tuuri, Creator of Innodb will answer your Questions about Innodb at MySQL Performance Blog.
Please leave your questions […]

Read more

Using VIEW to reduce number of tables used

Many Open Source software solutions use database per user (or set of tables per user) which starts to cause problems if it is used on massive scale (blog hosting, forum hosting etc), resulting of hundreds of thousands if not millions of tables per server which can become really inefficient.
It is especially inefficient with […]

Read more

InnoDB auto-inc scalability fixed

There was long played scalability issue with InnoDB auto-increment field. For details check Bug 16979. In short words the problem is in case of insert into table with auto-increment column the special AUTO_INC table level lock is obtained, instead of usual row-level locks. With many concurrent inserted threads this causes serious scalability problems, […]

Read more

MySQL Master Class after HighLoad.RU

26th of September, just after HighLoad conference I will have full day MySQL master class.
This time we will talk about Innodb Architecture and Performance Optimization and when will discuss some MySQL Performance Optimization and Scaling case studies from audience (or some of from my MySQL Consulting Practice if there would not be enough […]

Read more