Just an example of a query we take, in moment 10s :
SELECT p.*,t.*,m.member_group_id, m.mgroup_others,cca.* FROM ibf_posts p LEFT JOIN ibf_topics t ON ( t.tid=p.topic_id )
LEFT JOIN ibf_members m ON ( m.member_id=p.author_id )
LEFT JOIN ibf_content_cache_posts cca ON ( cca.cache_content_id=p.pid ) WHERE p.queued=0 AND t.approved=1 AND p.author_id=31499 AND p.new_topic=0 AND t.forum_id IN (
I Have some performance problem with my board.
MySQL Query are slow longer
And I have problem with Alter table.
When i Would like to optimize my table for cleaning it my table post is locked for 3 hours
I have installed percona-server-5.5 and optimize my MySQL configuration
MySQL is running on a separate server (Bixeon E5205, 12GB RAM and 2*74Go SATA RAPTOR 10000rpm)
I have more than 7 millions posts for 165000 members.
It is a Good idea to using partitioning table of MySQL ?
It is possible on IPb to separate read / write query ?
I think it's a good idea for having one MySQL writing master and some MySQL slave for read query with a load balling system.
With Master/Master replication, i'm limited with 2 server and I have to change the auto increment value.
The other way is to use MySQL Cluster, everyone have trying it with IPB ?