Top Menu

Search results for "mysql tuning script"

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

…ic guide… but does not take into account PHP memory requirements… see Ovidiu’s comment below). MySQL Tuning Is More Difficult: Trial and Error To test 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, bu… 2, 0, 0, 0 and 2711.25

Continue Reading 7

Automated WordPress Installation Via Custom Virtualmin Script Installer

Updated: please read instructions again and find link to new example file. WordPress (or any other script) can automatically install during Virtualmin > Create Virtual Server. Virtualmin automatically creates users, MySQL database, and installs WordPress in the public_html root, then gives a link to the WordPress Installer. You can even create a custom installer with a set of plugins and themes. To create a custom script installer with plugin… 12, 1, 1, 0 and 1582.64

Continue Reading 35

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

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

Continue Reading 0
APC INFO Monitor

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

…tal 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 (php module). Less modules loaded, less wasted memory. Comment out: LoadModule php5_module modules/libphp5.so in /etc/h… 8, 0, 0, 0 and 1037.8

Continue Reading 55

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
APC INFO Monitor

APC Cache Considerations for Virtual Hosting Environments

…sonal clients, so I adjust the APC settings for each individual account, depending on the number and type of PHP script packages running on the account. These accounts are all administered by myself, not by the clients. 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…. 2, 0, 2, 0 and 518.9

Continue Reading 2
SoccerNews.com website

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

…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 needs of a high traffic WordPress site. Configured a large MySQL tabl… 0, 1, 0, 0 and 467.01

Continue Reading 2

Résumé

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

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

…dpress/wp-includes/ms-files.php?file=$1 last; } location @wordpress { fastcgi_pass localhost:9000; fastcgi_param SCRIPT_FILENAME $document_root/index.php; include /etc/nginx/fastcgi_params; fastcgi_param SCRIPT_NAME /index.php; } location ~ \.php$ { try_files $uri @wordpress; fastcgi_index index.php; fastcgi_pass localhost:9000; fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name; include /etc/nginx/fastcgi_params; } location ^~ /blo… 6, 0, 0, 0 and 311.34

Continue Reading 18

Punk Rock Music Community

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 155.67

Continue Reading 0