Top Menu

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

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

…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 serving static HTML files. This presents challenges in security as well as performance tuning. It is impossible to predict whether a certain configuration will work properly for a given server, unless the hardware, software, accounts, network and traffic are identical to a previously c… 7, 1, 1, 0 and 2404.86

Continue Reading 7
APC INFO Monitor

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

…itor My Virtualmin CentOS 5.6 Virtual Private Server runs several virtual domains with PHP under FCGId using APC for opcode caching: Joomla, PHPbb, WordPress, etc . APC is somewhat challenging to configure properly with fcgid-enabled virtual domains, but 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… 5, 0, 2, 0 and 1143.93

Continue Reading 53

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

…to PMA Now you can 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 host. Version 3.5+ now has Status Monitoring and Advisor. Used in conjunction with a perform… 1, 0, 0, 0 and 831.95

Continue Reading 0
SoccerNews.com website

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

…ache web server, PHP and MySQL to better utilize the server’s horsepower. Cpanel’s efault Apache 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 Co… 2, 1, 1, 0 and 753.95

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)

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 ease of development, compatibility with other scripts, etc. Accordingly, the suggested configuration is for WordPr… 2, 0, 0, 0 and 519.98

Continue Reading 18
APC INFO Monitor

APC Cache Considerations for Virtual Hosting Environments

…t with APC cache, because it does allow to set php.ini and fcgiwrapper for every individual virtual host, and so to set an individual configuration for APC per virtual server. However with 200+ virtual hosts all running PHP script packages, as is the case with a commodity shared hosting server, this will use a lot of memory, and you will need somewhere in the neighborhood of 10-30GB apc.shm_size if you attempt to configure a single APC cache for… 1, 0, 0, 0 and 259.98

Continue Reading 4

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

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

…used it with cPanel, Webmin and Virtualmin for many years. Moving to Amazon Web Services presented a challenge, however. I’ve yet to figure out how to use CSF on AWS, so I’ve backtracked to my 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 &… 1, 0, 0, 0 and 155.99

Continue Reading 1

Joomla Content Management

If you’ve read anything at all about Content Management Systems (CMS), you’ll probably know that CMS are the most effective way to keep your site relevant to your audience. You also know at least three other things: Keeping your site relevant and up-to-date can be time consuming CMS can be complicated Portals can be expensive […]

Continue Reading 0