Jump to content

Which tables can i convert to innodb without breaking serch?


Recommended Posts

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

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

Archived

This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...