Search found 43 matches

by icechieff
Mon Mar 01, 2021 9:23 am
Forum: General discussion
Topic: Some trouble with TTFB
Replies: 21
Views: 717

Re: Some trouble with TTFB

that's old school pci-e ssd (2 ssd with raid 0 or raid 1, use raid o for performance, 'cause the speed is very slow for today)
IMG_2104-1920.jpg
by icechieff
Sun Feb 28, 2021 2:52 pm
Forum: General discussion
Topic: Some trouble with TTFB
Replies: 21
Views: 717

Re: Some trouble with TTFB

just moved mysql to old ocz revodrive, and voila!:

https://webpagetest.org/result/210221_D ... 31dd9f330/
by icechieff
Wed Feb 17, 2021 6:38 pm
Forum: General discussion
Topic: Some trouble with TTFB
Replies: 21
Views: 717

Re: Some trouble with TTFB

here is my slow query log /usr/sbin/mariadbd, Version: 10.5.8-MariaDB-1:10.5.8+maria~buster-log (mariadb.org binary distribution). started with: Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock Time Id Command Argument # Time: 210217 8:41:09 # [email protected]: icechieff_ipb[icechieff_ipb] @ localho...
by icechieff
Wed Feb 17, 2021 3:43 pm
Forum: General discussion
Topic: Some trouble with TTFB
Replies: 21
Views: 717

Re: Some trouble with TTFB

found a long query, up to 2 sec some times.
by icechieff
Mon Feb 15, 2021 7:00 pm
Forum: General discussion
Topic: Some trouble with TTFB
Replies: 21
Views: 717

Re: Some trouble with TTFB

may be to try set long_query to 1 sec? because there is no queries longer than 2 sec
by icechieff
Mon Feb 15, 2021 6:59 pm
Forum: General discussion
Topic: Some trouble with TTFB
Replies: 21
Views: 717

Re: Some trouble with TTFB

ipb
by icechieff
Mon Feb 15, 2021 6:10 pm
Forum: General discussion
Topic: Some trouble with TTFB
Replies: 21
Views: 717

Re: Some trouble with TTFB

Is there a way to help mysql with this? I'm using forum engine, not write it by myself(
by icechieff
Sun Feb 14, 2021 6:30 pm
Forum: General discussion
Topic: Some trouble with TTFB
Replies: 21
Views: 717

Re: Some trouble with TTFB

installed elasticsearch, and while it update search cache mysql have much more load, but no troubles...
mysql2.png
by icechieff
Sun Feb 14, 2021 4:23 pm
Forum: General discussion
Topic: Some trouble with TTFB
Replies: 21
Views: 717

Re: Some trouble with TTFB

some screenshots from cp
mem.png
la.png
nginx.png
mysql.png
apache.png
by icechieff
Sun Feb 14, 2021 9:03 am
Forum: General discussion
Topic: Some trouble with TTFB
Replies: 21
Views: 717

Re: Some trouble with TTFB

morning tests failed
https://webpagetest.org/result/210214_D ... 98e4e7a2f/

wtf...

la is low, db request too, srv is running with a lot of free resources...