Top Menu

Search results for "mysql server max connection calculator"

Tuning Apache and MySQL for Best Performance in a Shared Virtual Hosting Environment

…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 the MySQL server. Take a look at “Highest usage of available connections”, and lower maxconnections accordi… 21, 0, 1, 0 and 4553.38

Continue Reading 7

Install phpMyAdmin with SSL on CentOS, Amazon Linux, RedHat (Apache or NginX)

…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. <?php /* Servers configuration */ $i = 0; /* Server: MySQL Server [1] */ $i++; $cfg['Servers'][$i]['verbose'] = ‘MySQL Server‘; $cfg['Servers'][$i]['host'] = ’122.34.567.89′; $cfg[‘Serv… 12, 0, 0, 0 and 1971.81

Continue Reading 0
APC INFO Monitor

How to Configure APC Cache on Virtual Servers with PHP running under FCGId

…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 servers and Apache and MySQL performance tuning before you begin. If you are running your virtual servers under FC… 1, 0, 0, 0 and 1401.02

Continue Reading 53
SoccerNews.com website

Apache and MySql Performance Tuning for High Traffic WordPress Website on Cpanel

…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 Apache web server, PHP and MySQL to better utilize the server&#… 1, 0, 0, 0 and 1375.08

Continue Reading 2

Web Hosting

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 […]

Continue Reading

Résumé

Chris Gilligan Information Architect, Web Server Administrator, Media Producer web • video • print chris@chrisgilligan.net 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 […]

Continue Reading
APC INFO Monitor

APC Cache Considerations for Virtual Hosting Environments

…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 to use APC cache, you may wish to move them to a different server which can properly handle their needs. Virtualmin is a very goo… 6, 0, 2, 0 and 830.23

Continue Reading 2

Automated WordPress Installation Via Custom Virtualmin Script Installer

…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 custom script installer with plugins and themes: Download http://wordpress.org/latest.zip &am… 7, 0, 0, 0 and 778.34

Continue Reading 35

WordPress with W3 Total Cache on Nginx with APC (Virtualmin)

…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 from scratch. Testing the Virtualmin Nginx Modules Virtualmin does not support Nginx and Apache together, and there… 1, 0, 0, 0 and 518.9

Continue Reading 18

Varnish VCL and Config for WordPress with W3 Total Cache

…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 this # shell script fragment. # # # Maximum number of open files (for ulimit -n)… 2, 0, 0, 0 and 467.01

Continue Reading 23