Gauravk Posted March 29, 2020 Share Posted March 29, 2020 (edited) Looking for some experienced help and advice to optimize server side to reduce wait time to improvise the page load. We are running on dedicated server with clouldflare pro plan to speed up front end. We only have 1 main site on this server. Server spec: 2 X Intel(R) Xeon(R) CPU E3-1245 V2 @ 3.40GHz Speed: 3392.173 MHz Cache: 8192 KB RAM: 32 GB Operating system CENTOS 6.10 PHP MySql Apache CPU Load top - 22:20:01 up 286 days, 1:59, 1 user, load average: 0.14, 0.14, 0.17 Tasks: 244 total, 1 running, 241 sleeping, 0 stopped, 2 zombie Cpu0 : 31.8%us, 2.0%sy, 0.0%ni, 65.7%id, 0.0%wa, 0.0%hi, 0.5%si, 0.0%st Cpu1 : 4.0%us, 2.0%sy, 0.0%ni, 94.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu2 : 0.0%us, 0.5%sy, 0.0%ni, 99.5%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu3 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu4 : 0.0%us, 1.0%sy, 0.0%ni, 99.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu5 : 1.0%us, 0.5%sy, 0.0%ni, 98.5%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu6 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu7 : 2.0%us, 0.5%sy, 0.0%ni, 97.5%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Mem: 32909764k total, 14882656k used, 18027108k free, 1733764k buffers Swap: 523260k total, 158160k used, 365100k free, 5096856k cached MySql Config [mysqld] default-storage-engine=MyISAM open-files-limit=6553 performance-schema=0 local-infile=0 bind-address=127.0.0.1 innodb_buffer_pool_size=134217728 max_allowed_packet=268435456 # CACHES AND LIMITS # tmp-table-size=512M max-heap-table-size=256M query-cache-type=1 query-cache-size=256M query-cache-limit=1048576 max-connections=505 max_user_connections=500 thread-cache-size=32 table-definition-cache=102400 table-open-cache=20480 #### Per connection configuration #### join_buffer_size=4M sort_buffer_size=4M read_buffer_size=4M read_rnd_buffer_size=4M # INNODB # innodb_file_per_table=1 innodb_buffer_pool_size=134217728 # MyISAM # key-buffer-size=1G open_files_limit=10000 MySQL Tuner Report >> MySQLTuner 1.4.0 - Major Hayden <major@mhtx.net> >> Bug reports, feature requests, and downloads at http://mysqltuner.com/ >> Run with '--help' for additional options and output filtering [OK] Currently running supported MySQL version 5.7.29 [OK] Operating on 64-bit architecture -------- Storage Engine Statistics ------------------------------------------- [--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MRG_MYISAM [--] Data in MyISAM tables: 508M (Tables: 684) [--] Data in InnoDB tables: 34M (Tables: 476) [--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 87) [--] Data in MEMORY tables: 0B (Tables: 4) [!!] Total fragmented tables: 101 -------- Security Recommendations ------------------------------------------- ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause' [OK] All database users have passwords assigned -------- Performance Metrics ------------------------------------------------- [--] Up for: 5d 22h 27m 10s (95M q [186.335 qps], 582K conn, TX: 545B, RX: 27B) [--] Reads / Writes: 90% / 10% [--] Total buffers: 1.6G global + 16.2M per thread (505 max threads) [OK] Maximum possible memory usage: 9.7G (30% of installed RAM) [OK] Slow queries: 0% (0/95M) [OK] Highest usage of available connections: 43% (219/505) [OK] Key buffer size / total MyISAM indexes: 1.0G/240.5M [OK] Key buffer hit rate: 100.0% (1B cached / 72K reads) [OK] Query cache efficiency: 91.9% (84M cached / 91M selects) [!!] Query cache prunes per day: 608570 [OK] Sorts requiring temporary tables: 0% (176 temp sorts / 670K sorts) [!!] Joins performed without indexes: 6834 [OK] Temporary tables created on disk: 5% (106K on disk / 1M total) [OK] Thread cache hit rate: 99% (1K created / 582K connections) [OK] Table cache hit rate: 38% (19K open / 51K opened) [OK] Open file limit used: 27% (11K/41K) [OK] Table locks acquired immediately: 99% (10M immediate / 10M locks) [OK] InnoDB buffer pool / data size: 128.0M/34.9M [OK] InnoDB log waits: 0 Edited March 29, 2020 by Gauravk Link to comment Share on other sites More sharing options...
Makoto Posted March 29, 2020 Share Posted March 29, 2020 Hey @Gauravk, If you're looking to have your server professionally tuned, I'm happy to offer my services to you. You can find my rates and contact me here: Adlago, AlexWebsites and Gauravk 2 1 Link to comment Share on other sites More sharing options...
AlexWebsites Posted March 29, 2020 Share Posted March 29, 2020 Are you using Redis? Gauravk 1 Link to comment Share on other sites More sharing options...
Gauravk Posted March 30, 2020 Author Share Posted March 30, 2020 Thanks @AlexWebsites yes its showing on at the back-end, but Im not sure if its doing any good. Any ways to check the redis installation is alive and kicking....? Link to comment Share on other sites More sharing options...
AlexWebsites Posted March 30, 2020 Share Posted March 30, 2020 5 hours ago, Gauravk said: Thanks @AlexWebsites yes its showing on at the back-end, but Im not sure if its doing any good. Any ways to check the redis installation is alive and kicking....? Under the support section, you'll see to the right system info. If IPS is using Redis, you'll see something like: Gauravk 1 Link to comment Share on other sites More sharing options...
ASTRAPI Posted March 30, 2020 Share Posted March 30, 2020 Hello @Gauravk You should plan an upgrade to Centos 7 to get the new compilers and try to use phpfpm + Nginx + tuning everything on the system.... Not something that you can solve easily on a topic... Gauravk 1 Link to comment Share on other sites More sharing options...
Gauravk Posted March 30, 2020 Author Share Posted March 30, 2020 Thanks @AlexWebsites this is nice to verify that its working. Link to comment Share on other sites More sharing options...
Gauravk Posted March 30, 2020 Author Share Posted March 30, 2020 Thanks @Makoto and @ASTRAPI apart from the cost, there are several other reasons that I am stuck with DIY approach due to internal policies. If any of you have some mod, plugin, app or detailed guide, I'm happy to buy it. See if you can still support here with any inputs that will be highly appreciated. I made little progress so far from 1.96 Request/Sec - 6.43 Request/Sec, hope I can better this more. Baseline - Anonymous - Cloudflare ON Concurrency Level: 1 Time taken for tests: 51.114 seconds Complete requests: 100 Failed requests: 9 (Connect: 0, Receive: 0, Length: 9, Exceptions: 0) Non-2xx responses: 100 Total transferred: 4339200 bytes HTML transferred: 4244800 bytes Requests per second: 1.96 [#/sec] (mean) Time per request: 511.145 [ms] (mean) Time per request: 511.145 [ms] (mean, across all concurrent requests) Transfer rate: 82.90 [Kbytes/sec] received Redis + MySql config - Anonymous + Cloudflare ON Concurrency Level: 1 Time taken for tests: 15.553 seconds Complete requests: 100 Failed requests: 0 Total transferred: 19199846 bytes HTML transferred: 19138500 bytes Requests per second: 6.43 [#/sec] (mean) Time per request: 155.530 [ms] (mean) Time per request: 155.530 [ms] (mean, across all concurrent requests) Transfer rate: 1205.55 [Kbytes/sec] received Link to comment Share on other sites More sharing options...
Makoto Posted March 30, 2020 Share Posted March 30, 2020 (edited) You're welcome to refer to my guide on setting up and optimizing Nginx/PHP-FPM here: It's a little dated, so just use php7.3 or php7.4 in place of php5. Don't try and use php5 anymore. If you want to throw some support my way, I do have a small Patreon you can use: https://www.patreon.com/makotodev Edited March 30, 2020 by Makoto Link to comment Share on other sites More sharing options...
Steph40 Posted March 30, 2020 Share Posted March 30, 2020 I highly recommend centminmod: https://centminmod.com/ Gauravk 1 Link to comment Share on other sites More sharing options...
AlexWebsites Posted March 30, 2020 Share Posted March 30, 2020 1 hour ago, Steph40 said: I highly recommend centminmod: https://centminmod.com/ So are you using memcached vs redis? I'm on apache, wondering if I should move to nginx. Link to comment Share on other sites More sharing options...
Steph40 Posted March 30, 2020 Share Posted March 30, 2020 @AlexWebsites I have tried both and they both work very well. Redis does a lot more then memcached out of the box and you can still use it with centminmod, along with all the constant tweaking that eva2000 does. Gauravk and AlexWebsites 2 Link to comment Share on other sites More sharing options...
Gauravk Posted March 31, 2020 Author Share Posted March 31, 2020 On 3/30/2020 at 10:30 PM, Steph40 said: I highly recommend centminmod: https://centminmod.com/ Thanks @Steph40 for recommending this. Can you please explain little bit what it is? And can we use this with Apache and CentOS? Are you using this? If yes, I like to have a look at your IPB site for speed testing, please. Link to comment Share on other sites More sharing options...
Steph40 Posted March 31, 2020 Share Posted March 31, 2020 @Gauravk sent you a pm. Gauravk 1 Link to comment Share on other sites More sharing options...
Gauravk Posted April 1, 2020 Author Share Posted April 1, 2020 7 hours ago, Steph40 said: @Gauravk sent you a pm. Thanks for the PM, lovely site with a very beautiful and fresh design and awesome speed. Please share the backend details like: Apache or Nginx, MySQL or MariaDB, Redis or Memcached, InnoDB or MyISAM? Link to comment Share on other sites More sharing options...
Steph40 Posted April 1, 2020 Share Posted April 1, 2020 Centminmod uses Centos, a highly optimized version of nginx. Installed PHP 7.3 and redis. Gauravk 1 Link to comment Share on other sites More sharing options...
Durango Posted April 18, 2020 Share Posted April 18, 2020 Hi Is it normal that we cannot access topics ? https://carnity.com/forums/topic/14438-bmw-toyota-camry-saudi-creativity?do=getNewComment Link to comment Share on other sites More sharing options...
Recommended Posts