Contact Menu

Search results for "mysql calculate max_connections"


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

…he. Take Time to Get a Realistic Assessment of MySQL Performance If you have a PHP opcode and database caching strategy (such as APC) implemented on your web server and for your PHP script packages, you will be able to lower maxconnections, based on the information you receive from mysqltuner after 24-48 hours of steady […]

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

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

…from the Internet’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 […]

Continue Reading 4
APC INFO Monitor

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

…217;s /home/, add the following configuration: (you may also install memcached, and should install fileinfo for full use of W3 Total Cache) [memcached] ;memcached for distributed servers – e.g. mysql server on separate host ; [fileinfo] ;fileinfo is included in PHP 5.3=>… uncomment the following line if using

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

…LISTEN_ADDRESS= VARNISH_ADMIN_LISTEN_PORT=6082 # # # Shared secret file for admin interface VARNISH_SECRET_FILE=/etc/varnish/secret # # # The minimum number of worker threads to start VARNISH_MIN_THREADS=1 # # # The Maximum number of worker threads to start VARNISH_MAX_THREADS=1000 # # # Idle timeout for worker threads VARNISH_THREAD_TIMEOUT=120 # # # Cache file location if using file cache… […]

Continue Reading 23

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

…-/home/username/public_html/scripts-not-to-cache/.*,-/home/username/public_html/apc/.*” apc.slam_defense = 0 apc.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… 1, 0, 0, 0 and 66.85

Continue Reading 18
APC INFO Monitor

APC Cache Considerations for Virtual Hosting Environments

…lients. 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 use APC cache, you may […]

Continue Reading 4