Create an Account
username: password:
 
  MemeStreams Logo

The perils of InnoDB with Debian and startup scripts | MySQL Performance Blog

search

Lost
Picture of Lost
My Blog
My Profile
My Audience
My Sources
Send Me a Message

sponsored links

Lost's topics
Arts
Business
Games
Health and Wellness
Home and Garden
Miscellaneous
Current Events
Recreation
Local Information
Science
Society
Sports
Technology

support us

Get MemeStreams Stuff!


 
The perils of InnoDB with Debian and startup scripts | MySQL Performance Blog
Topic: Technology 4:52 pm EST, Jan 29, 2009

Are you running MySQL on Debian or Ubuntu with InnoDB? You might want to disable /etc/mysql/debian-start. When you run /etc/init.d/mysql start it runs this script, which runs mysqlcheck, which can destroy performance.

It can happen on a server with MyISAM tables, if there are enough tables, but it is far worse on InnoDB. There are a few reasons why this happens -- access to open an InnoDB table is serialized by a mutex, for one thing, and the mysqlcheck script opens all tables. One at a time.

The perils of InnoDB with Debian and startup scripts | MySQL Performance Blog



 
 
Powered By Industrial Memetics
RSS2.0