…or your PHP script packages, you will be able to lower maxconnections, based on the information you receive from mysqltuner after 24-48 hours of steady traffic. For example, I have a server with Apache set to 256 maxclients, but the MySQL maxconnections set to 200, because many web requests do not require direct interaction with […]
Search results for "mysql server max connection calculator"
…p The config below shows some common config options. Important ones are ForceSSL and auth_type. For a production server, SSL should be ON and auth_type http is better; http auth uses MySQL user/pass combinations to restrict access to user-specific databases.
…t it is quite helpful to optimize system resources and prevent traffic surges on one site from affecting overall server performance. Joomla and PHPbb have 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 […]
…gitimate IP address can monopolize, in addition to blacklisting attackers. This is the first step to proper web server performance in today’s Internet climate. Popular sites that do not have a solid security and load balancing strategy are subject to crippling traffic from the Internet’s millions of malicious and compromised servers and personal computers. Reconfigured […]
Decades of experience hosting websites, from small local sites with 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 […]
Chris Gilligan Information Architect, Web Server Administrator, Media Producer web • video • print firstname.lastname@example.org chrisgilligan.com I design and produce information and communication media for university, corporate, small business, manufacturing and non-profit clients: web sites Information architecture and design for open source content management systems Linux Apache MySQL PHP web server administration Postfix Dovecot Sendmail […]
…administered by myself, not 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 […]
…ew example file. WordPress (or any other script) can automatically install during Virtualmin > Create Virtual Server. Virtualmin automatically creates users, MySQL database, and installs WordPress in the public_html root, then gives a link to the WordPress Installer. You can even create a custom installer with a set of plugins and themes. To create a […]
…for WordPress installed in a subfolder. This info also assumes you have successfully installed APC Cache on your server, and set up a clean install of Virtualmin with Nginx as the Alternative Web Server. Switching from Apache to Nginx later is difficult, as is transferring apache virtual server backups. Best to start fresh and build […]
…menting. This configuration also works well with W3 Total Cache. This configuration is for Varnish on a separate server, but should also work on a single server with appropriate changes to the port and backend IP settings. Varnish Config (/etc/sysconfig/varnish) # Configuration file for varnish # # /etc/init.d/varnish expects the variable $DAEMON_OPTS to be set from […]