Contact Menu

Search results for "how to configure mysql for best performance"


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

… for the script only) MySQL Tuning Primer: phpMyAdmin 3.5+: Status Monitor and Advisor are excellent tools, but require proper phpMyAdmin setup These scripts will analyze MySQL performance and make suggestions regarding your my.cnf configuration. mysqltuner is now deprecated, but it still widely used and is very simple. Tuning Primer is the most up-to-date, […]

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

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

…rDefault’] = 1; ?> Create the phpmyadmin database for advanced functionality Look in phpMyAdmin folder /usr/share/phpMyAdmin/examples for create_tables.sql ssh to server as root user mysql — or if it asks for password — mysql -u your-mysql-superuser -pyour-superuser-password mysql > source /usr/share/phpMyAdmin/examples/create_tables.sql Log in to PMA Now you can log into PMA with your mysql root […]

Continue Reading 0
APC INFO Monitor

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

…oomla 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 FCGId, then you […]

Continue Reading 54 website

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

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

Continue Reading 4

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

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

…— makes WordPress more compatible with Nginx, allows use of permalinks without /index.php/ Configuring Nginx for WordPress pretty URL Permalinks The nginx Compatibility plugin has support for pretty URLs, but you must configure Nginx to use them. You should add or edit the following URL path locations to nginx.conf for your virtual domain… either by […]

Continue Reading 18


Chris Gilligan Web Developer, Information Architect, Web Server Administrator, Media Producer web • video • print 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

Content Management – Search Engine Optimization – Servers – Hosting – Chris Gilligan

Web and search engine optimization (SEO) services WordPress development high performance hosting site and server performance tuning Decades of experience developing and hosting websites, from small local sites with only a few html pages, to high-traffic sites with thousands of users and pages.  I’ve been building websites since the early days of the world wide […]

Continue Reading
APC INFO Monitor

APC Cache Considerations for Virtual Hosting Environments

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

Continue Reading 4
Screen Shot 2013-04-19 at 6.32.51 PM

Fail2Ban Regex for RedHat, Fedora, CentOS and Amazon Linux 2013

…y old standby, Fail2Ban. “Out of the box,” Fail2Ban for CentOS & other RedHat downstream distros only provides protection against SASL login failures. But with a little work and research, one can successfully configure many more “jails” for the malicious traffic. To take full advantage of Fail2Ban, the admin will need to become familiar with […]

Continue Reading 1