…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… (Search hits: 37 in body, 3 in title, 0 in categories, 2 in tags, 0 in other taxonomies, 0 in comments. Score: 682.59)
…mysql -u your-mysql-superuser -pyour-superuser-password mysql > source /usr/share/phpMyAdmin/examples/create_tables.sql Log in to PMA Now you can log into PMA with your mysql root user credentials. https://yourhost.tld/phpmyadmin Create a mysql user, pma,… (Search hits: 23 in body, 1 in title, 0 in categories, 0 in tags, 0 in other taxonomies, 0 in comments. Score: 355.95)
…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… (Search hits: 6 in body, 3 in title, 0 in categories, 2 in tags, 0 in other taxonomies, 0 in comments. Score: 195.07)
…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… (Search hits: 10 in body, 0 in title, 0 in categories, 1 in tags, 0 in other taxonomies, 0 in comments. Score: 150.33)
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 Web Developer, 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 Front-end UI design, HTML, PHP, LESS Linux Apache/Nginx […]
…a clean install of Virtualmin with Nginx as the Alternative Web Server. Switching from Apache to Nginx later is difficult, as is transferring apache virtual server backups. Best to start… (Search hits: 6 in body, 0 in title, 0 in categories, 0 in tags, 0 in other taxonomies, 0 in comments. Score: 79.84)
…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… (Search hits: 3 in body, 0 in title, 0 in categories, 1 in tags, 0 in other taxonomies, 0 in comments. Score: 56.31)
VacantServer WordPress sites are getting hammered with bad logins and probes. We’ve implemented a plugin to log failed login attempts to syslog, and a Fail2Ban filter for the same. If you run these on RedHat, you’ll need some additional configuration info… here it is: WordPress login failure regex (error_log): ^%(__prefix_line)sAuthentication failure for .* from <HOST>$ […]