2124 pointsLike some sort of WPMU DEV God"Mindblowingly helpful memberLifetime member
Ovidiu
Member
—
2nd September 2009 (2 years ago)
this is slightly offtopic, but still if someone can shed some light on it?
these questions arose as I isntalled a plugin that states it needs atable in a DB taht has innodb as engine...
can you please help me understand innodb and myisam?
as far as I understood it, if my mysql server runs both engines, I can then make either innodb or myisam tables right? InnoDB is available on this MySQL server. or does a DB run on either one of the engines? I do not really believ this is right, but I'm not sure, jsut seeking clarification because when I create a DB there is no choice between innodb and myisam, but when I create a table I can chose the storage engine, so the table should be simple to add to the existing wp DB.
this is slightly offtopic, but still if someone can shed some light on it?
these questions arose as I isntalled a plugin that states it needs atable in a DB taht has innodb as engine...
can you please help me understand innodb and myisam?
as far as I understood it, if my mysql server runs both engines, I can then make either innodb or myisam tables right? InnoDB is available on this MySQL server. or does a DB run on either one of the engines? I do not really believ this is right, but I'm not sure, jsut seeking clarification because when I create a DB there is no choice between innodb and myisam, but when I create a table I can chose the storage engine, so the table should be simple to add to the existing wp DB.
Looking at that and knowing that you;re going to have more reading than writes to the db with wpmu, I'd go with MyISAM. But using one of the object caching system or a server caching would make that moot I would think.
Heh, and I can't reach google today to do research because it's blocked as a sex/porn site. Gotta love Caribou.
Yahoo (What that?) pulls up a lot of bashing between the camps.
and the plugin states: PHPFreeChat uses an innodb mysql database type, it auto creates it.
but it doesn't work and the author warns against using the WPMU DB for it... but I asumed it can be done, but the plugin struggles creating the needed table
Can you convert a global table from myIsam to inodb and vice versa without any negative effect? Any tutorial for showing how one go about converting between myIsam and inoDB?
its not about multiDB just general. the plugin works with single wp also. hte author jsut advised against putting the chat table inside the normal wp/wpmu table because wp/wpmu uses myisam tables and the plugin wants innodb. that seemed strange to me so I asked here.
the plugin is not working sitewide, but per blog. although it can be easily tweaked with a function that checks if a user is logged in thus only allowing logged in users to chat.
7430 pointsLike some sort of WPMU DEV GodMindblowingly helpful memberLifetime member
Erstwhile founder
—
2nd September 2009 (2 years ago)
#
its not about multiDB just general.
So the developer is saying the plugin just doesn't work well with WPMU in general?
hte author jsut advised against putting the chat table inside the normal wp/wpmu table because wp/wpmu uses myisam tables and the plugin wants innodb. that seemed strange to me so I asked here.
That's definitely strange. Doesn't make any sense really. You can have myisam and innodb tables in the same db.
If there plugin is working ok then I would just ignore that comment from the developer.
sorry, no. the author is using wpmu himself. he just advises about not putting the chat table into a normal wp or wpmu DB. That is all.
Besides that, the plugin struggles creating the needed table, so next thing I am going to do is manually create it.
Besides, the chat plugin is running by default in text-based-mode" which can either be sped-up by changing it internally to use tmpfs or change it to use a DB table.
Responses (11)
Keeper of the Dark Chocolate — 2nd September 2009 (2 years ago) #
Luke hit on this once:
http://premium.wpmudev.org/forums/topic/database-for-wordpress-mu-to-consider-to-use-between-myisam-and-innodb
Looking at that and knowing that you;re going to have more reading than writes to the db with wpmu, I'd go with MyISAM. But using one of the object caching system or a server caching would make that moot I would think.
Heh, and I can't reach google today to do research because it's blocked as a sex/porn site. Gotta love Caribou.
Yahoo (What that?) pulls up a lot of bashing between the camps.
Hmmm....
Erstwhile founder — 2nd September 2009 (2 years ago) #
Hiya,
You can have both innodb and myisam tables on the same MySQL instance.
If you have a busy WPMU site I would go with innodb for your global tables.
Thanks,
Andrew
Member — 2nd September 2009 (2 years ago) #
I plan on installing this plugin: http://wordpress.org/extend/plugins/phpfreechat
and the plugin states: PHPFreeChat uses an innodb mysql database type, it auto creates it.
but it doesn't work and the author warns against using the WPMU DB for it... but I asumed it can be done, but the plugin struggles creating the needed table
Erstwhile founder — 2nd September 2009 (2 years ago) #
I'd definitely go with innodb for a chat table.
You meant Multi-DB correct? Did they say why? Without additional information there's not much we can say about that.
Does the plugin create one table for the entire site or a table for each blog?
Thanks,
Andrew
Member — 2nd September 2009 (2 years ago) #
Can you convert a global table from myIsam to inodb and vice versa without any negative effect? Any tutorial for showing how one go about converting between myIsam and inoDB?
Erstwhile founder — 2nd September 2009 (2 years ago) #
Hiya,
Google is your friend for that one. Converting tables is just a basic MySQL task and is not WPMU specific.
Thanks,
Andrew
Member — 2nd September 2009 (2 years ago) #
@Andrew:
its not about multiDB just general. the plugin works with single wp also. hte author jsut advised against putting the chat table inside the normal wp/wpmu table because wp/wpmu uses myisam tables and the plugin wants innodb. that seemed strange to me so I asked here.
the plugin is not working sitewide, but per blog. although it can be easily tweaked with a function that checks if a user is logged in thus only allowing logged in users to chat.
Erstwhile founder — 2nd September 2009 (2 years ago) #
So the developer is saying the plugin just doesn't work well with WPMU in general?
That's definitely strange. Doesn't make any sense really. You can have myisam and innodb tables in the same db.
If there plugin is working ok then I would just ignore that comment from the developer.
Thanks,
Andrew
Member — 3rd September 2009 (2 years ago) #
@Andrew:
sorry, no. the author is using wpmu himself. he just advises about not putting the chat table into a normal wp or wpmu DB. That is all.
Besides that, the plugin struggles creating the needed table, so next thing I am going to do is manually create it.
Besides, the chat plugin is running by default in text-based-mode" which can either be sped-up by changing it internally to use tmpfs or change it to use a DB table.
Keeper of the Dark Chocolate — 3rd September 2009 (2 years ago) #
Why not just put the table creation within one of the New Blog Default plugins? We have to do that with wp-shortstat.
Member — 3rd September 2009 (2 years ago) #
hmmmm manually created it as the plugin is currently not availabel for users yet... works just fine :-)
Become a member