Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Developers' Forum

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Thread Tools Display Modes
Old 29th November 2012, 02:01
Ventzy Ventzy is offline
Junior Member
Join Date: Jan 2010
Posts: 17
Thanks: 3
Thanked 2 Times in 2 Posts
Default Why ispconfig uses MyISAM?

...and can I convert all tables to InnoDB without breaking ispconfig?

The reasons to ask are two:
1. On mysql crash tables can be corrupted and must be checked. It happened to me once.
2. I want to use Percona XtraBackup, but I have a problem, which may be caused of MyISAM tables (I think it completely locks MyISAM tables during backup, which can take long time)
Reply With Quote
Sponsored Links
Old 29th November 2012, 08:50
till till is offline
Super Moderator
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 37,015
Thanks: 840
Thanked 5,651 Times in 4,461 Posts

We use myisam as it works better in our tests, is faster and makes less problems with recovery and as ispconfig does not require any of the functions from innodb, there is no reason to switch to innodb.

If you want to convert the tables on your server, then you can do that. It will not break ispconfig.
Till Brehm
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
Ventzy (29th November 2012)
Old 16th December 2012, 00:38
Disassembler Disassembler is offline
Junior Member
Join Date: Jul 2012
Posts: 19
Thanks: 2
Thanked 7 Times in 5 Posts

I'd be interested in doing it for referential integrity, but I'm not quite sure I want to piece together all the implicit foreign key relationships myself
MyISAM may be a little faster depending on your queries but you can never be sure it's consistent, especially after a recovery. I daresay an InnoDB database that doesn't recover cleanly despite its log would have sustained some more or less subtle damage if it had been MyISAM.
Reply With Quote
The Following User Says Thank You to Disassembler For This Useful Post:
pityusasda2773 (20th January 2013)


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ISPConfig 3 - MultiServer Setup - With Dedicated Control Panel - How? SuperJC Installation/Configuration 4 16th October 2012 21:03
around 80 sleeping connections created by ISPConfig bkilinc General 2 1st October 2012 17:12
Control Panel - E-mail Tab is empty domi-nik General 15 14th April 2011 19:17
chroot SSH IspConfig2 kextra1 General 4 20th January 2011 19:41
SP-Server Setup - Ubuntu 5.10 "Breezy Badger" - Page 6 (changes) LuisC-SM HOWTO-Related Questions 0 21st April 2006 16:16

All times are GMT +2. The time now is 23:55.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.