Contact Menu

Search results for "mysql server max connection calculator"

LAMP-linux-apache-mysql-php

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

…eginning value for [mysqld] max_connections. Begin with max_connections set slightly higher than Apache’s maxclients. If you are running database caching via APC, you may lower max_connections, because APC will serve the busiest queries directly from cache. Take Time to Get a Realistic Assessment of MySQL Performance If you have a PHP opcode and database caching […]

Continue Reading 8
Screen Shot 2012-09-07 at 11.09.50 AM

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

…Allow from ALL hosts, because the VPC firewall will prevent other access. Install phpMyAdmin on a separate web server, and restrict access to PMA’s directory (see below). # phpMyAdmin – Web based MySQL browser written in php # # Allows only localhost by default # # But allowing phpMyAdmin to anyone other than localhost should […]

Continue Reading 0
SoccerNews.com website

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

…lemented a Stateful Packet Inspection firewall and Login Failure Daemonto block malicious IP addresses, malware servers, bad bots, content scrapers, etc. Many of the problems leading to site crashes were due to constant bad bot traffic, security probes and Denial of Service attacks. Connection Tracking in the firewall now limits the amount of resources a […]

Continue Reading 4
APC INFO Monitor

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

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

Continue Reading 52

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 Web Developer, 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 Front-end UI design, HTML, PHP, LESS Linux Apache […]

Continue Reading
virtualmin-nginx-wordpress-permalinks-apc

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

Virtualmin now includes support for Nginx web server. I deploy many WordPress sites with W3 Total Cache and APC Alternative PHP Cache, so I was very interested to see how Nginx performance compares to Apache for WordPress, and whether APC and W3TC would play nice with Nginx. I prefer to install WordPress in public_html/wordpress for […]

Continue Reading 18
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 […]

Continue Reading 4
wordpress-installation

Automated WordPress Installation Via Custom Virtualmin Script Installer

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

Continue Reading 45
wordnish

Varnish VCL and Config for WordPress with W3 Total Cache

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

Continue Reading 23