Contact Menu

Search results for "mysql tuning with apache"

LAMP-linux-apache-mysql-php

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

…adding more databases or tables, you will need to raise table_cache value. Follow the recommendations from the Apache tuning, and then follow the recommendations of the tuning scripts. The apache tuning will give you the number of maxclients, and from this you will know the appropriate beginning value for [mysqld] max_connections. Begin with max_connections set […]

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)

…log into PMA with your mysql root user credentials. 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 […]

Continue Reading 0
SoccerNews.com website

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

…umber of concurrent user sessions the server could handle. Changed PHP to run as FastCGI (fcgid) and recompiled Apache to better handle the needs of a high traffic WordPress site. Configured a large MySQL table and query cache based on performance and load testing. Configured Amazon CloudFront Content Distribution Network, page cache, browser cache, and […]

Continue Reading 4
APC INFO Monitor

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

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

Continue Reading 54

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

WordPress Fail2Ban RegEx for RedHat, CentOS, Amazon Linux

VacantServer WordPress sites are getting hammered with bad logins and probes. We’ve implemented a plugin to log failed login attempts to syslog, and a Fail2Ban filter for the same. If you run these on RedHat, you’ll need some additional configuration info… here it is: WordPress login failure regex (error_log):

Apache nohome regex (error_log):

[…]

Continue Reading 0