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.
Reply
 
Thread Tools Display Modes
  #1  
Old 29th November 2012, 01:01
Ventzy Ventzy is offline
Junior Member
 
Join Date: Jan 2010
Posts: 17
Thanks: 2
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
  #2  
Old 29th November 2012, 07:50
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,504
Thanks: 813
Thanked 5,265 Times in 4,129 Posts
Default

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)
  #3  
Old 15th December 2012, 23:38
Disassembler Disassembler is offline
Junior Member
 
Join Date: Jul 2012
Posts: 19
Thanks: 2
Thanked 7 Times in 5 Posts
 
Default

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)
Reply

Bookmarks

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 20:03
around 80 sleeping connections created by ISPConfig bkilinc General 2 1st October 2012 16:12
Control Panel - E-mail Tab is empty domi-nik General 15 14th April 2011 18:17
chroot SSH IspConfig2 kextra1 General 4 20th January 2011 18:41
SP-Server Setup - Ubuntu 5.10 "Breezy Badger" - Page 6 (changes) LuisC-SM HOWTO-Related Questions 0 21st April 2006 15:16


All times are GMT +2. The time now is 04:13.


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