hi guys, we have a really strange problem

[Oleg Ipatov]

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]

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]

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]

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]

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]

It seems bad or default configuration for both of you

[LinkMania]

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]

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]

Have you run command to see what the top process are?

# top

 

[Oleg Ipatov]

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