…s.com/clients/knowledgebase/25/HOW-TO-Optimize-Apache-for-Low-Memory-Usage.html (the formula works well as a basic guide… but does not take into account PHP memory requirements… see Ovidiu’s comment below). MySQL Tuning Is More Difficult: Trial and Error To test your MySQL server performance, you may try: mysqltuner: https://github.com/rackerhacker/MySQLTuner-perl (or http://mysqltuner.pl for the script only) MySQL Tuning… 30, 2, 2, 0 and 1616.36
Search results for "tuning-mysql-55"
…ntials. https://yourhost.tld/phpmyadmin Create a mysql user, pma, with the password you added to the config file, with no default permissions, on localhost Give pma user all permissions on phpmyadmin database, on localhost Now you have a secure PMA which will work for all mysql users on your host. Version 3.5+ now has Status Monitoring and […]
…from the Internet’s millions of malicious and compromised servers and personal computers. Reconfigured Apache web server, PHP and MySQL to better utilize the server’s horsepower. Cpanel’s efault Apache and MySQL configurations were limiting the number of concurrent user sessions the server could handle. Changed PHP to run as FastCGI (fcgid) and recompiled Apache to better […]
…th only a few html pages, to high-traffic sites with thousands of users and pages. Website hosting, evolved Web hosting has changed dramatically in the last few years. The majority of accounts are now running PHP scripts and MySQL, whereas in the past most accounts were only serving static HTML files. This presents challenges in […]
…ve code that is pre-optimized with hooks for APC, but WordPress requires a plugin called W3 Total Cache. First Things First Please read my posts about APC on commodity virtual hosting servers and Apache and MySQL performance tuning before you begin. If you are running your virtual servers under FCGId, then you should do so […]
…ot by the clients. I do not think APC is the correct cache for most shared web hosting servers, given the number of virtual hosts. You will probably have better results if you remove APC and concentrate on Apache performance tuning and MySQL cache. If your clients are adamant in their requests to use APC […]
…ve to a dedicated CentOS 5 series web server with 3GB RAM. While this is a relatively low-end box, it has plenty of horsepower for a single WordPress site and phpBB3 forum. Punktastic.com web site For this GIG, I soloed on… transferring the site from a WAMP development server to the live LAMP server configuring […]