Contact Menu

Search results for "mysql calculate max_connections"


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

…d_buffer_size = 8M read_buffer_size = 2M sort_buffer_size = 2M table_cache = 1600 table_definition_cache = 1600 max_allowed_packet = 4M key_buffer = 1G interactive_timeout = 2 wait_timeout = 5 long_query_time = 1 log_slow_queries = ON open_files_limit = 3200 innodb_buffer_pool_size = 26M join_buffer_size = 4M tmp_table_size = 72M max_heap_table_size = 72M max_connections = 80 [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/my… 55, […]

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)

…in 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 be considered # dangerous unless properly secured by SSL Alias /phpMyAdmin /usr/share/phpMyAdmin Alias […]

Continue Reading 0

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 website

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

…s millions of malicious and compromised servers and personal computers. Reconfigured Apache 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 […]

Continue Reading 4
APC INFO Monitor

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

…al 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 should do so for all virtual servers on your machine. Why? Because then you do not need apache’s mod_php […]

Continue Reading 54


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

Varnish VCL and Config for WordPress with W3 Total Cache

…sh # # /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) NFILES=131072 # # Locked shared memory (for ulimit -l) # Default log size is 82MB + header MEMLOCK=82000 # # Maximum size of corefile (for ulimit -c). […]

Continue Reading 23

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

…use_request_time = 1 apc.mmap_file_mask = /tmp/apc.XXXXXX apc.file_update_protection = 2 apc.enable_cli = 0 apc.max_file_size = 2M apc.stat = 1 apc.write_lock = 1 apc.report_autofilter = 0 apc.include_once_override = 0 apc.rfc1867 = 0 apc.rfc1867_prefix = “upload_” apc.rfc1867_name = “APC_UPLOAD_PROGRESS” apc.rfc1867_freq = 0 apc.localcache = 1 apc.localcache.size = 256 apc.coredump_unmap = 0 apc.stat_ctime = 0 Reloading PHP-fastcgi processes aft… […]

Continue Reading 18
APC INFO Monitor

APC Cache Considerations for Virtual Hosting Environments

…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 good choice for […]

Continue Reading 4