…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… 20, 1, 1, 0 and 3022.59
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… 14, 0, 0, 0 and 1556.7
…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… 3, 1, 0, 0 and 622.68
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 […]
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 […]
…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… 2, 0, 0, 0 and 259.45
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
…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 wish to move them to a different server which can properly handle their needs. Virtualmin is a very good choice for this, as it allows individual accounts to be configured with individual php.ini and fcgiwrapper, or even different versions o… 1, 0, 0, 0 and 155.67
Web and search engine optimization (SEO) services WordPress development high performance hosting site and server performance tuning Decades of experience developing and hosting websites, from small local sites with only a few html pages, to high-traffic sites with thousands of users and pages. I’ve been building websites since the early days of the world wide […]