Oleg Ipatov Posted April 26, 2016 Posted April 26, 2016 Hi, so, 8-) Huston we have a problem 8-) we have a stand alone server with debian 8.4, mysql 5.5.47-0+deb8u1, and php 5.6.19-0+deb8u1, also we have a ipboard 4.1.10, and we have a problem.. everyhing is sooo sloooowwww we have a theme with 150 or so pages and if i add some new message it add in about 20 sec. its too slow.. cant find why.. some one say use php 7.0 its twice faster then your 5.5.47. But, when i see the system requires from ipboard - there is no need to do this update, and install php 7. what can i do? i'am not really good in english and this board, but i try the best, its my help for biggest russian forum of disabled ppl with multiple sclerosis. any one have any ideas? Thank you. Andrew
RevengeFNF Posted April 26, 2016 Posted April 26, 2016 Probably you have your server not ideally configured. Im a Centos guy, but you are using, Apache, nginx or other webserver? Can you post here the result of mysqltuner?
LinkMania Posted April 26, 2016 Posted April 26, 2016 5 minutes ago, Oleg Ipatov said: Hi, so, 8-) Huston we have a problem 8-) we have a stand alone server with debian 8.4, mysql 5.5.47-0+deb8u1, and php 5.6.19-0+deb8u1, also we have a ipboard 4.1.10, and we have a problem.. everyhing is sooo sloooowwww we have a theme with 150 or so pages and if i add some new message it add in about 20 sec. its too slow.. cant find why.. some one say use php 7.0 its twice faster then your 5.5.47. Hi, same problem here i think.. Using Arch Linux with mariadb and php7. 4.1.10 and 4.1.11 are SLOW! Opening topics, submitting anything.. something is broken.. Maybe sql queries? I have seen mysqld topping one cpu many times. We did not have this problem before 4.1.10 and it still among us.
Oleg Ipatov Posted April 26, 2016 Author Posted April 26, 2016 Hi, RevengeFNF, i use nginx also 1 minute ago, Oleg Ipatov said: Hi, RevengeFNF, i use nginx also MySQLTuner 1.3.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] Logged in using credentials from debian maintenance account. [OK] Currently running supported MySQL version 5.5.47-0+deb8u1 [!!] Switch to 64-bit OS - MySQL cannot currently use all of your RAM -------- Storage Engine Statistics ------------------------------------------- [--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MRG_MYISAM [--] Data in MRG_MYISAM tables: 0B (Tables: 1) [--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17) [--] Data in InnoDB tables: 70M (Tables: 403) [--] Data in MEMORY tables: 0B (Tables: 8) [--] Data in MyISAM tables: 418M (Tables: 384) [!!] Total fragmented tables: 444 -------- Security Recommendations ------------------------------------------- [!!] User 'root@127.0.0.1' has no password set. [!!] User 'root@debian.50.lenny.32.minimal' has no password set. [!!] User 'root@localhost' has no password set. -------- Performance Metrics ------------------------------------------------- [--] Up for: 1d 10h 57m 8s (1M q [10.957 qps], 79K conn, TX: 8B, RX: 393M) [--] Reads / Writes: 77% / 23% [--] Total buffers: 192.0M global + 2.6M per thread (151 max threads) [OK] Maximum possible memory usage: 588.4M (1% of installed RAM) [OK] Slow queries: 0% (33/1M) [OK] Highest usage of available connections: 21% (33/151) [OK] Key buffer size / total MyISAM indexes: 16.0M/393.3M [OK] Key buffer hit rate: 98.9% (63M cached / 667K reads) [OK] Query cache efficiency: 65.0% (706K cached / 1M selects) [!!] Query cache prunes per day: 91465 [OK] Sorts requiring temporary tables: 0% (0 temp sorts / 58K sorts) [!!] Joins performed without indexes: 3271 [OK] Temporary tables created on disk: 20% (6K on disk / 32K total) [OK] Thread cache hit rate: 99% (36 created / 79K connections) [!!] Table cache hit rate: 16% (400 open / 2K opened) [OK] Open file limit used: 48% (498/1K) [OK] Table locks acquired immediately: 99% (656K immediate / 656K locks) [OK] InnoDB buffer pool / data size: 128.0M/70.1M [OK] InnoDB log waits: 0 -------- Recommendations ----------------------------------------------------- General recommendations: Run OPTIMIZE TABLE to defragment tables for better performance Enable the slow query log to troubleshoot bad queries 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: http://bit.ly/1mi7c4C Variables to adjust: query_cache_size (> 16M) join_buffer_size (> 128.0K, or always use indexes with joins) table_open_cache (> 400)
Oleg Ipatov Posted April 26, 2016 Author Posted April 26, 2016 10 minutes ago, LinkMania said: Hi, same problem here i think.. Using Arch Linux with mariadb and php7. 4.1.10 and 4.1.11 are SLOW! Opening topics, submitting anything.. something is broken.. Maybe sql queries? I have seen mysqld topping one cpu many times. We did not have this problem before 4.1.10 and it still among us. u2 & 8-) damn
ASTRAPI Posted April 26, 2016 Posted April 26, 2016 It seems bad or default configuration for both of you
LinkMania Posted April 26, 2016 Posted April 26, 2016 1 hour ago, ASTRAPI said: It seems bad or default configuration for both of you Or maybe there is a problem in IPS since version 4.1.10 until and included 4.1.11 ?
Oleg Ipatov Posted April 27, 2016 Author Posted April 27, 2016 11 hours ago, LinkMania said: Or maybe there is a problem in IPS since version 4.1.10 until and included 4.1.11 ? i'am dont really know... anyone have any clues?
craigf136 Posted April 27, 2016 Posted April 27, 2016 Have you run command to see what the top process are? # top
Oleg Ipatov Posted April 27, 2016 Author Posted April 27, 2016 4 hours ago, craigf136 said: Have you run command to see what the top process are? # top yep top top - 17:40:45 up 2 days, 11:34, 1 user, load average: 0.15, 0.19, 0.18 Tasks: 63 total, 1 running, 62 sleeping, 0 stopped, 0 zombie %Cpu0 : 0.0 us, 0.0 sy, 0.0 ni,100.0 id, 0.0 wa, 0.0 hi, 0.0 si, 0.0 st %Cpu1 : 0.0 us, 0.0 sy, 0.0 ni,100.0 id, 0.0 wa, 0.0 hi, 0.0 si, 0.0 st %Cpu2 : 0.0 us, 0.0 sy, 0.0 ni,100.0 id, 0.0 wa, 0.0 hi, 0.0 si, 0.0 st %Cpu3 : 1.9 us, 0.0 sy, 0.0 ni, 98.1 id, 0.0 wa, 0.0 hi, 0.0 si, 0.0 st %Cpu4 : 0.0 us, 0.0 sy, 0.0 ni,100.0 id, 0.0 wa, 0.0 hi, 0.0 si, 0.0 st %Cpu5 : 0.0 us, 0.0 sy, 0.0 ni,100.0 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 : 0.0 us, 0.0 sy, 0.0 ni,100.0 id, 0.0 wa, 0.0 hi, 0.0 si, 0.0 st KiB Mem: 52428800 total, 2478116 used, 49950684 free, 0 buffers KiB Swap: 4194304 total, 0 used, 4194304 free. 1940368 cached Mem
Recommended Posts
Archived
This topic is now archived and is closed to further replies.