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

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.

INNODB doesn't support fulltext search, So you will have to switch to 'traditional' search If you are using fulltext now.

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