Skip to main content

Wordpress / Prestashop / x Performance

TCB13
Hello, I've been trying to discover why websites I have running on wordpress are slow and unresponsive. The usual behavior is that the take like up to 5 seconds to start loading when using Wordpress. This performance issues also applies do website running Prestashop and other similar solutions. Custom made simple PHP scripts and plain HTML pages load fast. I tried clean installations of Wordpress on new cPanel accounts, all default and the problem persists and there's anything really wrong with my configuration probably. Here are the VPS Specs:
Total processors: 3 Processor #1 Vendor GenuineIntel Name QEMU Virtual CPU version (cpu64-rhel6) Speed 2659.982 MHz Cache 4096 KB Processor #2 Vendor GenuineIntel Name QEMU Virtual CPU version (cpu64-rhel6) Speed 2659.982 MHz Cache 4096 KB Processor #3 Vendor GenuineIntel Name QEMU Virtual CPU version (cpu64-rhel6) Speed 2659.982 MHz Cache 4096 KB
At apache statistics I usually get stuff like:
35 requests currently being processed, 35 idle workers 9 requests currently being processed, 59 idle workers
In terms of RAM: .vB .vB As you can see even the server load is low. At Apache Global Configuration I've been tweaking values the the configuration that gave me the most speed, specially on website frequently visited is: .vB I'm also running the latest PHP from cPanel and MariaDB, with the following config:
[mysqld] local-infile = 0 max_connections = 350 key_buffer = 150M myisam_sort_buffer_size = 64M join_buffer_size = 3M read_buffer_size = 3M sort_buffer_size = 5M max_heap_table_size = 16M table_cache = 5000 thread_cache_size = 286 interactive_timeout = 25 wait_timeout = 7000 connect_timeout = 15 max_allowed_packet = 150M max_connect_errors = 10 query_cache_limit = 3M query_cache_size = 150MB query_cache_type = 1 tmp_table_size = 16M innodb_buffer_pool_size=1024M key_buffer_size=300M
But with all this the performance of the wordpress / prestashop installations is still low is there anything wrong with my configuration? Is there anything special somewhere else I need to take a closer look? Thank you ;)

Comments

6 comments

Date Votes
  • cPanelMichael
    Hello :) You may want to run a MySQL tuning script to see if it's possible to increase the performance of your MySQL server. This thread may help: Optimize /etc/my.cnf with MariaDB Thank you.
    0
  • AdamDresch
    ]Hello, I've been trying to discover why websites I have running on wordpress are slow and unresponsive. The usual behavior is that the take like up to 5 seconds to start loading when using Wordpress.

    Same on my own cPanel server, the site gets very few visits, yet it takes upwards of 5 seconds for a page to appear Server is powerful, very low load and all the latest stuff, it's weird Have you tried an opcode cache? I need to check whether mine is using xcache. Could also try using PHP 5.5, as it comes with Zend Opcache.
    0
  • TCB13
    ]Same on my own cPanel server, the site gets very few visits, yet it takes upwards of 5 seconds for a page to appear Server is powerful, very low load and all the latest stuff, it's weird Have you tried an opcode cache? I need to check whether mine is using xcache. Could also try using PHP 5.5, as it comes with Zend Opcache.

    From my point of view, our problem is not related to PHP. I'm not using any king of caching right now. The thing is, if websites with high traffic load really fast and websites without traffic load slowly, the bottleneck must be the DB and not PHP. I say that because if PHP was the issue the website with high traffic would also be slow, actually much slower since I'm not running anything cached... (to avoid other issues). Side Note: Do you have enough available workers on your Apache to deal with the requests?
    0
  • TCB13
    ]Hello :) You may want to run a MySQL tuning script to see if it's possible to increase the performance of your MySQL server. This thread may help: Optimize /etc/my.cnf with MariaDB Thank you.

    I got the following results with MySQL Tunner:
    >> MySQLTuner 1.4.0 - Major Hayden >> Bug reports, feature requests, and downloads at [url=http://mysqltuner.com/]MySQLTuner-perl by major >> Run with '--help' for additional options and output filtering [!!] Currently running unsupported MySQL version 10.0.16-MariaDB [OK] Operating on 64-bit architecture -------- Storage Engine Statistics ------------------------------------------- [--] Status: +ARCHIVE +Aria +BLACKHOLE +CSV +FEDERATED +InnoDB +MRG_MyISAM [--] Data in MyISAM tables: 594M (Tables: 890) [--] Data in InnoDB tables: 801M (Tables: 5849) [--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 52) [--] Data in MEMORY tables: 7M (Tables: 96) [!!] Total fragmented tables: 19 -------- Performance Metrics ------------------------------------------------- [--] Up for: 1d 0h 59m 36s (2M q [26.223 qps], 74K conn, TX: 29B, RX: 737M) [--] Reads / Writes: 91% / 9% [--] Total buffers: 1.5G global + 11.5M per thread (350 max threads) [!!] Maximum possible memory usage: 5.4G (94% of installed RAM) [OK] Slow queries: 0% (9/2M) [OK] Highest usage of available connections: 12% (45/350) [OK] Key buffer size / total MyISAM indexes: 300.0M/95.9M [OK] Key buffer hit rate: 97.3% (5M cached / 143K reads) [OK] Query cache efficiency: 41.4% (1M cached / 3M selects) [!!] Query cache prunes per day: 22101 [OK] Sorts requiring temporary tables: 0% (0 temp sorts / 118K sorts) [!!] Joins performed without indexes: 3454 [OK] Temporary tables created on disk: 20% (29K on disk / 141K total) [OK] Thread cache hit rate: 99% (45 created / 74K connections) [!!] Table cache hit rate: 3% (5K open / 138K opened) [OK] Open file limit used: 1% (191/15K) [OK] Table locks acquired immediately: 99% (1M immediate / 1M locks) [OK] InnoDB buffer pool / data size: 1.0G/801.5M [OK] InnoDB log waits: 0 -------- Recommendations ----------------------------------------------------- General recommendations: Run OPTIMIZE TABLE to defragment tables for better performance Reduce your overall MySQL memory footprint for system stability Increasing the query_cache size over 128M may reduce performance Adjust your join queries to always utilize indexes Increase table_open_cache gradually to avoid file descriptor limits Read this before increasing table_open_cache over 64: [url=http://bit.ly/1mi7c4C]table_cache negative scalability - MySQL Performance Blog Variables to adjust: *** MySQL's maximum memory usage is dangerously high *** *** Add RAM before increasing MySQL buffer variables *** query_cache_size (> 150M) [see warning above] join_buffer_size (> 3.0M, or always use indexes with joins) table_open_cache (> 5000)
    Is query cache size that big? I made the following query to get a percentage of query cache usage:
    SELECT ((( @@GLOBAL.query_cache_size - (SELECT VARIABLE_VALUE FROM information_schema.SESSION_STATUS WHERE VARIABLE_NAME LIKE 'Qcache_free_memory') ) / @@GLOBAL.query_cache_size )*100) as query_cache_usage_percentage;
    And sometimes I get values like 70 to 80% used... So I guess it's not that big of a value. What do you thing?
    0
  • TCB13
    After reading the recommended posts and some more testing, I changed my.cnf values to:
    [mysqld] local-infile = 0 innodb_file_per_table = 1 tmp_table_size = 50M max_heap_table_size = 50M query_cache_type = 1 query_cache_limit=20M query_cache_size=20M innodb_buffer_pool_size = 100M key_buffer_size = 300M max_connections = 350 key_buffer = 500M myisam_sort_buffer_size = 64M join_buffer_size = 3M read_buffer_size = 3M sort_buffer_size = 5M read_rnd_buffer_size = 4M table_cache = 5000 thread_cache_size = 286 max_allowed_packet = 150M max_connect_errors = 10 connect_timeout = 2 interactive_timeout = 25 wait_timeout = 7000 delayed_insert_timeout = 40 collation_server = utf8mb4_unicode_ci character_set_server = utf8mb4 query_cache_strip_comments = 1 open_files_limit = 55000
    I'm not sure this configuration will help me. However I'll report in a few days. I didn't get any performance changes right away.
    0
  • TCB13
    I'm just replying to this for future reference for annoying looking into similar issues. From my tests my initial configuration and the latest one didn't make much difference. However I can say the query cache hit rate on my original configuration was better by 5-10% than in the other one. My last configuration was kinda made out of the other post, referenced above, about mariadb optimization. At this point I'm not entirely sure if I should keep it or revert to my original configuration. In any case, I'm keeping this settings form the new one: innodb_file_per_table = 1 collation_server = utf8mb4_unicode_ci character_set_server = utf8mb4
    This makes the DBs more manageable and can potentially make websites using default SQL settings like Wordpress safer. I managed to find out that my biggest performance issue was actually the disk I/O, a thing that should've been working fine. Other thing that was impacting my server performance was using suphp instead of fastcgi as PHP handler. I changed this and noticed some performance changes right away. I also installed Zend OPcache and rebuilt apache with it and now everything is much faster... but cached in RAM. My OPCache installation procedure was: 1. Create the file, /var/cpanel/easy/apache/rawopts/all_php5, that contains the following text: --enable-opcache ( NOTE: Each option passed to PHP needs to be on its own line. If this file already exists, then place this text at the end of the file, on its own line. ) 2. Run EasyApache 3. Once you've successfully built your web stack using EasyApache, enable and configure OPcache by adding the following at /usr/local/lib/php.ini: zend_extension=/usr/local/lib/php/extensions/no-debug-non-zts-20121212/opcache.so opcache.enable=1 opcache.enable_cli=1 opcache.memory_consumption=128 opcache.interned_strings_buffer=8 opcache.max_accelerated_files=50000 opcache.revalidate_freq=60 opcache.fast_shutdown=1 opcache.save_comments=1 opcache.use_cwd = 1 opcache.validate_timestamps = 1 opcache.enable_file_override = 0 4. Restart apache 5. Verify that OPcache is enabled: Create a PHP page that executes the phpinfo() function. Search for the "Zend OPcache". 6. Remove the temporary PHP page after you've verified.
    Please note: 1. You should list the folder /usr/local/lib/php/extensions/ to find the correct path of your opcache.so: zend_extension=/usr/local/lib/php/extensions/no-debug-non-zts-20121212/opcache.so
    2. Apart form the phpinfo() function, you should install a Opcache management interface on some cpanel account and check if the start time of opcache is not always equal to the current request time. - If yes, it means the opcahce is being restarted at every request and not working properly. Try to change your php hander from suphp to fcgi, reboot apache and test again until it works fine!. 3. The provided configuration is compatible with frameworks. Thank you. ;)
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post