Caez77

+Clients
  • Content count

    1
  • Joined

  • Last visited


Caez77's Activity

  1. Caez77 added a post in a topic: Performance problems   

    I'm not using Varnish for the moment.
    I'm using Nginx + php-fpm

    I'm using IPB3.1 and i can't perform the upgrade for the moment
    For the moment, i have separate my innodb table with the innodb_per_table option

    @PeterUK i'm sending the querys today
  2. Caez77 added a post in a topic: Performance problems   

    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 (
  3. Caez77 added a post in a topic: Performance problems   

    Yes I Have big topics the biggest is about 20 000 posts.
    The majority of topics have less than 1000 posts

    I'm just activate the slow query log with 1 second, before it was configured to 5 seconds
    Most pages are displayed in 1 or 2 seconds

    I'm posting and new message with my slow-query log

    Thanks for your answer.
  4. Caez77 added a post in a topic: Performance problems   

    Hello

    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 ?


    Sorry for my poor english
  5. Caez77 added a post in a topic: [HSC] Table BBCode   

    Thanks for your mod
    It's possible to specify color in tr ?



    <tr bgcolor="#97DEFF">

About Me

Status Feed