Search results for "best mysql tune setting"

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

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

…your MySQL server performance, you may try: mysqltuner: https://github.com/rackerhacker/MySQLTuner-perl (or http://mysqltuner.pl for the script only) MySQL Tuning Primer: https://launchpad.net/mysql-tuning-primer phpMyAdmin 3.5+: Status Monitor and Advisor are excellent tools, but require proper phpMyAdmin setup These scripts will analyze MySQL performance and make suggestions regarding your my.cnf configuration. mysqltuner is now deprecated,… 2, 0, 0, 0 and 2653.74

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

phpMyAdmin database display I recently ran into a problem with the upgraded 3.5.2 phpMyAdmin package provided via the rpmforge.repo. Search no longer works, nor does pagination, etc. Plus, it’s out of date and vulnerable to an XSS exploit. I have solved this by changing to the EPEL repo, which maintains the latest version of phpMyAdmin. This post will teach you how to install phpMyAdmin on CentOS, Amazon Linux, or Redhat. Configuration ins… 1, 0, 0, 0 and 765.04

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… 3, 0, 0, 0 and 382.54

Continue Reading • Comments { 18 }
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

there were inevitable JavaScript and PHP conflicts, but W3TC is very flexible and was able to handle the task. Suggested a scheduled, offsite backup strategy that would utilize existing resources, and eliminate the need for a 3rd-party backup solution that was causing more load issues and costing $45.00 per month. Now the site is stable and fast, and is ready for very high traffic. With World Cup Brazil coming up in 2014, the site will definitel… 3, 1, 0, 0 and 239.07

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

…u may wish to run Apache with Worker MPM instead of Prefork MPM. More information about Apache Worker MPM vs. Prefork MPM » Installation Suggestions and Modification of Defaults Be sure to install the newest version of APC, 3.1.9 as of the last revision of this post (I assume you know how to install and configure all the packages mentioned in this post): pecl install apc Choose “no” for internal debugging,  but choose “yesR… 2, 0, 0, 0 and 95.63

Continue Reading • Comments { 54 }

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

By on April 19, 2013 in Amazon Web Services, Portfolio

…distribution. Neither can Fail2Ban account for every change in log file location or structure from version to version. What worked for Centos 5.x may not work for CentOS 6.x; what worked in kernel 2.8 may be invalid in kernel 3.4. Also stated earlier, it is well worth the time to learn a little about RegEx. One vehicle to propel the admin far along the path is RegExr. Author Greg Skinner provides an online version as well as Adobe AIR standalone… 1, 0, 0, 0 and 47.82

Continue Reading • Comments { 0 }

Remote publishing to WordPress from Facebook via RSS

By on July 25, 2011 in Wordpress

…deo. But be sure to add a tagline to “Say something about this…” This line becomes your Title in the RSS feed or WordPress post. Otherwise you will see a generic “Your Client’s Facebook Wall 07/12/2011 15:35:43″ as the title. And on the client’s site, you will see this: You may want to set up a WordPress Category for these posts. FeedWordPress can be configured to post to a specific Category, add Tags, etc. Y… 1, 0, 0, 0 and 47.82

Continue Reading • Comments { 6 }

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.81

Continue Reading • Comments { 22 }