Search results for "mysql connexions"

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

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

…ySQL 5 or later, the configuration statements can be in the following form (example from one of my servers): [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.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_defini… 20, 1, 1, 0 and 1087.47

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

…y 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 Allow from All and add your own static IPs here f… 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 }

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 •

LAMP-linux-apache-mysql-php

By on August 22, 2011 in
Continue Reading • Comments { 0 }
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

…cgi-bin> allow from all </Directory> SuexecUserGroup “#987″ “#756″ Options ExecCGI FollowSymLinks Includes IncludesNOEXEC -Indexes MultiViews SymLinksIfOwnerMatch RemoveHandler .php RemoveHandler .php5 IPCCommTimeout 12 </VirtualHost> You must “babysit” the configuration: use the APC monitor (apc.php) to see how many files are being cached, and how much memory (apc.shm_size) is needed to avoid fragmentation, which will… 2, 0, 0, 0 and 95.6

Continue Reading • Comments { 54 }

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 }

Automated WordPress Installation Via Custom Virtualmin Script Installer

By on May 17, 2012 in Virtualmin, Wordpress

…ngs > Default Script Installers Custom WordPress If you want to have the script archive download from a protected web directory, that is also possible: ‘url’ => “http://repo.server.com/file-ver.zip”, ‘nocache’ => 1, ‘user’ => “username”, ‘pass’ => “password” Incoming search terms for the article: virtualmin wordpress script installer virtualmin wordpress virtualmin script installers wordpress installer script virtualmin script… 1, 0, 0, 0 and 47.8

Continue Reading • Comments { 22 }
APC INFO Monitor

APC Cache Considerations for Virtual Hosting Environments

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

…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 the entire server. My web hosting server is for a small number of personal clients, so I adjust the APC settings for each individual account, depending… 1, 0, 0, 0 and 47.8

Continue Reading • Comments { 2 }

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 }