Search results for "mysql max_connections"

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

By on August 22, 2011 in Consulting, Web Server Performance Tuning

….sock user=mysql symbolic-links=0 innodb_file_per_table = 1 thread_concurrency = 8 query_cache_size = 64M query_cache_limit = 4M thread_cache_size = 8 myisam_sort_buffer_size = 64M read_rnd_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 inn… 14, 0, 1, 0 and 4577.17

Continue Reading • Comments { 3 }

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

By on September 24, 2012 in Amazon Web Services, Consulting, Virtualmin

…nsidered # dangerous unless properly secured by SSL Alias /phpMyAdmin /usr/share/phpMyAdmin Alias /phpmyadmin /usr/share/phpMyAdmin <Directory /usr/share/phpMyAdmin/> <IfModule mod_authz_core.c> # Apache 2.4 <RequireAny> Require ip 127.0.0.1 Require ip ::1 </RequireAny> </IfModule> <IfModule !mod_authz_core.c> # Apache 2.2 Order Deny,Allow # comment out All… 14, 0, 0, 0 and 669.21

Continue Reading • Comments { 0 }
SoccerNews.com website

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

By on August 26, 2011 in Web Server Performance Tuning

SoccerNews.com is a high traffic WordPress site with over 600,000 unique visitors and over 2,000,000 page impressions per month. It is a content republisher and aggregator, presenting custom XML feeds for (what else?) soccer news from all over the world. The site has a very active user base, providing content in the forms of editorials and comments on news items. Advertising and sponsored referrals provide the revenue stream. SoccerNews.com web… 3, 1, 0, 0 and 239

Continue Reading • Comments { 2 }
APC INFO Monitor

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

By on November 8, 2010 in Virtualmin, Web Server Performance Tuning, Wordpress

…ault = 0 apc.filters = “-/home/username/public_html/apc/apc\.php$” apc.slam_defense = 0 apc.use_request_time = 1 apc.mmap_file_mask = /tmp/apc-accountname.XXXXXX ;OR apc.mmap_file_mask = /dev/zero 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…. 1, 0, 0, 0 and 191.21

Continue Reading • Comments { 54 }

Résumé

By on October 24, 2008 in

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 •

Varnish VCL and Config for WordPress with W3 Total Cache

By on August 14, 2012 in Amazon Web Services, Consulting, Content Management Systems, Web Server Performance Tuning, Wordpress

…t beresp.http.Set-Cookie; } # # don’t cache response to posted requests or those with basic auth if ( req.request == “POST” || req.http.Authorization ) { return (hit_for_pass); } # # only cache status ok if ( beresp.status != 200 ) { return (hit_for_pass); } # # don’t cache search results if( req.url ~ “\?s=” ){ return (hit_for_pass); } # # else ok to cache the response set beresp.ttl = 24h; return (deliver); } # sub vcl_deliver { # add debugging… 2, 0, 0, 0 and 95.61

Continue Reading • Comments { 17 }

LAMP-linux-apache-mysql-php

By on August 22, 2011 in
Continue Reading • Comments { 0 }

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

By on March 12, 2012 in Web Server Performance Tuning, Wordpress

…at file (/home/domainname/etc/php5/php.ini) Add the following to php.ini (adjust to your requirements) [APC] extension = apc.so apc.enabled = 1 apc.shm_segments = 1 apc.shm_size = 12M apc.optimization = 0 apc.num_files_hint = 256 apc.user_entries_hint = 1024 apc.ttl = 0 apc.user_ttl = 0 apc.gc_ttl = 600 apc.cache_by_default = 0 apc.filters = “-/home/username/public_html/scripts-not-to-cache/.*,-/home/username/public_html/apc/.*” apc.slam_defense… 1, 0, 0, 0 and 47.8

Continue Reading • Comments { 18 }

Punk Rock Music Community

By on April 10, 2012 in Consulting, Music, Portfolio, Publishing, Web Server Performance Tuning, Wordpress

Punktastic.com is a community powered site that covers punk music in Britain, but is poised to go worldwide. They cover punk and hardcore shows and festivals, and provide album reviews, video interviews and more. With a growing audience and user base, Punktastic needed a more reliable and robust web server, so they made the move to a dedicated CentOS 5 series web server with 3GB RAM. While this is a relatively low-end box, it has plenty of horse… 1, 0, 0, 0 and 47.8

Continue Reading • Comments { 0 }

Joomla Content Management

By on October 23, 2008 in

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 • Comments { 0 }