こまけぇこたぁいいんだよ!! PHPWebアプリケーションを早くする、それだけだ / It doesn't matter how small it is! Make PHPWeb applications faster, that's all!

PHPカンファレンス関西2024

Transcript

1. !! PHPWeb PHP 西 2024 2 0 24 . 2 . 11 @seike 4 60 1
2. 自己 @seike 46 0 - - @seike 46 0 - AWS Community Builder Serverless - Fusic - / 門 - / - 月 PHP - PHP 2024 LT ( ) - PHP 大 2024 LT (Now ) - PHPerKaigi 20 2 4 LT - PHP 小 田 2024 - PHP 香 2024 - PHP 2024 2
3. !! - @seike 4 60 - Fusic - PHPerKaigi 　　 3
4. Agenda 1 . 2 . 3 . 4 . 4
7. 用 - Web - DB - 　 c 5 .large vCPU 2 4 GiB 20GiB 7
9. ISUCON 12 ISUCON 12 PHP ISUCON 大 自 9
11. phpspy phpspy 　 11
12. 方 pgrep 　 phpspy 用 　 　 12 $ ./phpspy -b 81 920 --limit= 1 00 0 0 --pid=$(pgrep -n php-fpm) > traces $ ./stackcollapse-phpspy.pl <traces | ./vendor/flamegraph.pl >flame.svg
14. PHP 入 14 SCORE: 13 27 (+ 132 7 0 ( 0 %))
15. DB Web DB 行 用 Web DB 15
16. DB PHP 入 Web DB 16 SCORE: 13 27 (+ 132 7 0 ( 0 %)) SCORE: 14 69 (+ 146 9 0 ( 0 %))
17. htop htop 17
18. DB DB MySQL innodb_buffer_pool_size innodb_log_file_size innodb_flush_log_at_trx_commit innodb_flush_method table_open_cache thread_cache_size max_connections 18
19. DB PHP 入 Web DB DB 19 SCORE: 13 27 (+ 132 7 0 ( 0 %)) SCORE: 14 69 (+ 146 9 0 ( 0 %)) SCORE: 16 95 (+ 169 5 0 ( 0 %))
20. Index DB Index pt-query-digest 用 20 ALTER TABLE visit_history DROP INDEX tenant_id_idx; ALTER TABLE visit_history ADD INDEX tenant_id_idx(tenant_id, competition_id, player_id, created_at);
21. Index PHP 入 Web DB DB Index 21 SCORE: 13 27 (+ 132 7 0 ( 0 %)) SCORE: 14 69 (+ 146 9 0 ( 0 %)) SCORE: 16 95 (+ 169 5 0 ( 0 %)) SCORE: 18 67 (+ 186 7 0 ( 0 %))
22. N+ 1 22 MySQL App\Isuports\Handlers::playerHandler N+ 1 行
23. N+ 1 PHP 入 Web DB DB Index N+ 1 23 SCORE: 13 27 (+ 132 7 0 ( 0 %)) SCORE: 14 69 (+ 146 9 0 ( 0 %)) SCORE: 16 95 (+ 169 5 0 ( 0 %)) SCORE: 18 67 (+ 186 7 0 ( 0 %)) SCORE: 24 33 (+ 243 3 0 ( 0 %))
24. Nginx - worker_processes -> auto - worker_connections - keepalive_timeout 入 gzip gzip_vary gzip_proxied gzip_comp_level gzip_buffers gzip_http_version 24
25. php-fpm 25 Fork Process Process - pm.max_children - pm.start_servers - pm.min_spare_servers - pm.max_spare_servers - rlimit_files
26. php-fpm 26 OPcache PHP 8 目玉 JIT PHP 入 OPcache opcache.enable JIT opcache.jit opcache.jit_buffer_size opcache.max_accelerated_files opcache.memory_consumption opcache.validate_timestamps XDebug
27. OS OS 　 大 ⾒ ulimit 　 　 大 　 　 net.core.somaxconn vm.swappiness fs.file-max 27
28. Nginx + php-fpm + OS PHP 入 Web DB DB Index N+ 1 Nginx + php-fpm + OS 28 SCORE: 13 27 (+ 132 7 0 ( 0 %)) SCORE: 14 69 (+ 146 9 0 ( 0 %)) SCORE: 16 95 (+ 169 5 0 ( 0 %)) SCORE: 18 67 (+ 186 7 0 ( 0 %)) SCORE: 24 33 (+ 243 3 0 ( 0 %)) SCORE: 30 12 (+ 301 2 0 ( 0 %))
29. 見 立 用 大 手 大 自 29
30. 見 30 PHP https://speakerdeck.com/seike 4 6 0 /php-web-application-performance-tuning
31. Thank You We are Hiring ! https://recruit.fusic.co.jp/