… some won’t be needed. And that’s where the Debian startup script breaks down entirely, because it doesn’t follow this… what happens: mysql> show processlist; +——+——————+—————-+————- | Id | User | State | Info +——+——————+—————-+————- | 7 | debian-sys-maint | NULL | CHECK TABLE tableA… | 739 | user | | NULL | 4776… to table B. The real solution is to disable this startup process. It’s not even needed for InnoDB. Sooner or…
Comment: How to change innodb_log_file_size safely
November 8, 2011 By 14 Comments
… for Zarafa MySQL tuning. I did not get this expected startup message: Nov 8 19:45:00 mysqld: 111108 19:45… the innodb logfiles (it did, but they never matched on startup, even when both timestamps where identical). Of course I was… this will work in every scenario! As this is a Debian hosting server migration I started over the weekend, cheers god…
Post: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 37 Comments
… probably only a few distributions, which can be considered: CentOS, Debian, RedHat Enterprise Linux, SuSE Linux and Ubuntu. Of course CentOS and Ubuntu derive from RedHat and Debian respectively, but their install bases are large enough to mention… opt-out option. More problems can come from the standard Debian init (startup) script for MySQL. By default it not only starts…
Comment: Which Linux distribution for a MySQL database server? A specific point of view.
December 9, 2011 By 37 Comments
… mysql packages now: you’re right to mention that the debian init script for mysql can do some bad things automatically… you have to do is modify /etc/mysql/debian-start (add exit 0 at startup for example), to disable these “features”. And…. Lastly, I recommend using Percona packages on Debian. They are 100% compatible with stable Debian system (both in dependancy matter and in…
Comment: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 37 Comments
… exceptionally poor/slow, and the ABI problems with MySQL and Debian has definitely not helped. For people looking to start a… toy with the improvements) For anything production or serious on Debian- you’d better get comfortable with compiling it manually to… it’s own host of issues: The source provides insufficient startup scripts – have fun pulling your hair out with mysqld_multi…
Post: XtraDB storage engine release 1.0.4-8
October 12, 2009 By 12 Comments
… on startup on windows fix-import-extern-pages Number of mysql-tests are fixed The builds for RedHat4,5 and Debian are… find on LaunchPAD. We are launching also the repository with Debian packages. To install XtraDB with APT put in your /etc…
Comment: Which Linux distribution for a MySQL database server? A specific point of view.
December 9, 2011 By 37 Comments
… end the “helpful” things the Debian/Ubuntu MySQL package wants to do for you at startup is a well known weakness. I…
Comment: About This Blog
March 27, 2009 By 48 Comments
[...] The MySQL Performance Blog, and this post in particular, The perils of InnoDB with Debian and startup scripts, by Baron Schwartz answered our question. [...]
