My Forum is terribly slow compared to vbulletin

[rafass]

I'm testing with this too now, My server admin says: Zend Opcache is installed:
# php -v
PHP 5.4.36 (cli) (built: Dec 29 2014 11:06:41)
Copyright (c) 1997-2014 The PHP Group
Zend Engine v2.4.0, Copyright (c) 1998-2014 Zend Technologies
with the ionCube PHP Loader v4.6.1, Copyright (c) 2002-2014, by ionCube Ltd., and
with Zend OPcache v7.0.5, Copyright (c) 1999-2015, by Zend Technologies
with Zend Guard Loader v3.3, Copyright (c) 1998-2013, by Zend Technologies
----------
now, ¿what is the best configuration to use in library/config.php?

 

[rdn]

Zend Opcache

Doesn't need any config.php codes

 

[rafass]

Thank you Roldan, anyway this is my config.php:

<?php

$config['db']['host'] = 'localhost';
$config['db']['port'] = 'xxxxxxxx';
$config['db']['username'] = 'xxxxxxxx';
$config['db']['password'] = 'xxxxxxxx';
$config['db']['dbname'] = 'xxxxxxxx';


$config['superAdmins'] = '1';

# Added caching directives for Ticket #xxxxxxxx

$config['cache']['enabled'] = true;
$config['cache']['frontend'] = 'Core';
$config['cache']['frontendOptions']['cache_id_prefix'] = 'xf_';

$config['cache']['cacheSessions'] = true;

$config['cache']['backend'] = 'Memcached';
$config['cache']['backendOptions'] = array(
    'compression' => false,
    'servers' => array(
        array(
            // your memcached server IP /address
            'host' => 'localhost',
          
            // memcached port
            'port' => 11211,

            'persistent' => 'true'
        )
    )
);

That's ok?

 

[rdn]

Thank you Roldan, anyway this is my config.php:

<?php

$config['db']['host'] = 'localhost';
$config['db']['port'] = 'xxxxxxxx';
$config['db']['username'] = 'xxxxxxxx';
$config['db']['password'] = 'xxxxxxxx';
$config['db']['dbname'] = 'xxxxxxxx';


$config['superAdmins'] = '1';

# Added caching directives for Ticket #xxxxxxxx

$config['cache']['enabled'] = true;
$config['cache']['frontend'] = 'Core';
$config['cache']['frontendOptions']['cache_id_prefix'] = 'xf_';

$config['cache']['cacheSessions'] = true;

$config['cache']['backend'] = 'Memcached';
$config['cache']['backendOptions'] = array(
    'compression' => false,
    'servers' => array(
        array(
            // your memcached server IP /address
            'host' => 'localhost',
         
            // memcached port
            'port' => 11211,

            'persistent' => 'true'
        )
    )
);

That's ok?

Yeah seems fine.

 

[rafass]

Thanks again!

 

[PetForums]

My forum has come to a standstill again, and pages won't even open.

 

[m1ne]

My forum has come to a standstill again, and pages won't even open.

What was the last thing you did? Be careful not to break things even more.

 

[PetForums]

The memcached is setup and working, I'll keep you all informed of what happens over the next few days and how my forum/server performs.


Thanks for all your help.

 

[m1ne]

You should also use Zend Opcache and https://xenforo.com/community/resources/bd-cache.2763/

 

[PetForums]

Spoke to soon, the site is unresponsive again. I'm getting my server admin to look in to this again.

 

[m1ne]

Paste your MySQL config here (my.cnf) and also run mysqltuner.

 

[PetForums]

Hi, I have pasted my MySQL config file for you to see below, my server spec is mentioned further up in this thread, it has 12 cores and 96gb memory.

My forum occasionally ends up being unresponsive due to queries stacking up. My server admin has said that when looking at some of the logs from when it locks , the queries that end up stacking up are waiting on the xf_session_activity table which is why perfectly good queries seem to build up from time to time.


slow-query-log=1
long-query-time=1
skip-name-resolve
innodb_file_per_table=1
max_allowed_packet=268435456
tmpdir="/dev/shm"
datadir="/var/lib/mysql"
socket="/var/lib/mysql/mysql.sock"
max_connections=300
key_buffer=7000M
myisam_sort_buffer_size=64M
join_buffer_size=64M
read_buffer_size=8M
sort_buffer_size=128M
table_cache=1500
thread_cache_size=64
wait_timeout=1200
connect_timeout=10
tmp_table_size=256M
read_rnd_buffer_size=524288
bulk_insert_buffer_size=8M
max_allowed_packet=16M
max_connect_errors=10
query_cache_limit=8M
query_cache_size=128M
query_cache_type=1
query_prealloc_size=16384
query_alloc_block_size=16384
tmp_table_size=512M
max_heap_table_size=512M
innodb_buffer_pool_size=20G
open_files_limit=10000

 

[m1ne]

Try this,

slow-query-log=1
long-query-time=1
skip-name-resolve
innodb_file_per_table=1
max_allowed_packet=268435456
tmpdir="/dev/shm"
datadir="/var/lib/mysql"
socket="/var/lib/mysql/mysql.sock"
max_connections=300
key_buffer=12G
myisam_sort_buffer_size=64M
join_buffer_size=2M
read_buffer_size=2M
sort_buffer_size=2M
table_open_cache=25000
thread_cache_size=256
wait_timeout=300
connect_timeout=10
tmp_table_size=256M
max_heap_table_size=256M
query_cache_type = 1
query_cache_size = 256M
query_cache_limit = 256k
#read_rnd_buffer_size=524288
#bulk_insert_buffer_size=8M
max_allowed_packet=5M
max_connect_errors=10
query_cache_limit=512k
query_cache_size=256M
query_cache_type=1
#query_prealloc_size=16384
#query_alloc_block_size=16384
innodb_buffer_pool_size=40G
innodb_thread_concurrency = 0
innodb_buffer_pool_instances = 4
innodb_flush_method=O_DIRECT
innodb_file_per_table=1
innodb_log_buffer_size=8M
open_files_limit=48000

You had a couple duplicates and some values set far too high. Backup your old config, make a new my.cnf with these contents and restart MySQL.

 

[WSWD]

Perhaps I missed it, but I don't see anyone asking the big question...are your drives RAID10? I'm guessing so, but you never know.

Also, hybrid drives are largely worthless. They help a little bit, but not a whole lot. You might benefit from putting the OS and MySQL on a real SSD drive. That's a hell of a beefy server and should absolutely not have any issues with XF.

 

[rafass]

I'm using SSD in a VPS and the speed is really awesome (with tons of addons running together)

 

[Slavik]

What MySQL version are you using?

 

[PetForums]

What MySQL version are you using?

MySQL is version 5.5.42-cll

Php version 5.4.30

 

[motowebmaster]

Care to share what your server load is?

Also, does your site/server behave differently when using the default style?

Did you try running mysqltuner as previously suggested?

How are things with no addons enabled?

 

[Mouth]

Php version 5.4.30

Quite old - you should upgrade to 5.5. or 5.6

 

[PlayStage]

Hello,

Have you compiled your php with libmemcached or memcached support?

Also that memcached server needs to be configured too. My suggestion to you is to run memcached on a Unix socket rather than an IP : PORT.

You can Google the advantages of running a service on a Unix socket I'm not going to detail it here as it does not make the object of this discussion.


Kind regards,
George.