ASTRAPI Posted February 3, 2010 Share Posted February 3, 2010 Hello I have some big tables heavy loaded and locked when i have many members that slows down my server :( I need 5-8 seconds to open a topic :( Overhead tables: ibf cache store ibf forums ibf mail queue ibf reg antispa ibf search results ibf shoutbox shouts ibf task manager ibf validating Big tables: ibf members 15mb ibf message text 135mb ibf posts 415mb ibf task logs 180mb ibf topics 18mb ibf topic markers 150mb For search i am not using full text and i search in english and greek characters and the collation of tables is latin1_swedish_ci. Server: # 2x Intel Xeon Quad 5405 # 12GB DDR2 RAM # 2x SAS disks in Raid 1 15.000 RPM # 1.000 Mbit unshared port Thank you Link to comment Share on other sites More sharing options...
Guest Posted February 4, 2010 Share Posted February 4, 2010 It strikes me that your server is far too powerful to be struggling with a database of that size. How many active users do you generally have at any given time? To answer the question directly, you can convert any tables to InnoDB without breaking things, but I'd start with ones you know to be troublesome, i.e. the frequently accessed ones and/or those that are constantly being written to. Link to comment Share on other sites More sharing options...
Dhillon Posted February 4, 2010 Share Posted February 4, 2010 INNODB doesn't support fulltext search, So you will have to switch to 'traditional' search If you are using fulltext now. Link to comment Share on other sites More sharing options...
ASTRAPI Posted February 4, 2010 Author Share Posted February 4, 2010 I have about 550 users per 10 minute only :( I do not use full text search :) How can i check which tables i must convert? Thank you Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.