I'm running a web server on my pi at the moment, I run a forum that uses PHP and Mysql. The Average load time is 1 – 2 seconds for a page, I know for sure this can be a lot faster. This is because when I request a HTML page it's there in a few milliseconds (We have Fiber Optic Internet with 40Mbit upload speed).
I would like to know what I can do to make it even faster, there are no slow query's detected and Mysql caches have enough space. So I guess Mysql is not the problem. I also optimized Apache a bit, but I actual don't know what I could do to make it even faster.
So what tools are available on Debian to determine what the systems bottleneck is? And are there any tools like “Mysql tuner” for PHP?
When I run the command “top”, there is max 40% CPU and 50% ram usage when a user is browsing. So I guess more CPU power can be used to process data faster. I don't know about Disk usage, but I have a class 10 SD card that I want to keep. So I don't want to expand the SD card.
I know it's better to optimize the applications on the server, but first I would like to have Apache, PHP and Mysql as fast as possible for my system configuration.