Detect "Too many connections" error and show alternate web page
Tag Archives: MySQL
Mysql console How to update the max_connections setting in MySQL
If you are getting "too many connections" errors in MySQL you can change the max_connections setting to allow more connections, assuming you have enough RAM to handle the increased number. This post looks at how to update the max_connections setting in MySQL.
Backupninja allows you to coordinate system backup by dropping a few simple configuration files into/etc/backup.d/. Most programs you might use for making backups don’t have their own configuration file format. Backupninja provides a centralized way to configure and schedule many different backup utilities. It allows for secure, remote, incremental filesytem backup (via rdiff-backup), compressed incremental …
MYSQL COUNT GROUP BY
I’d like to only select the rows where the count is greater than 1 (in other words the duplicates) right now from a few thousand records i am mostly seeing ones with a few 2s and 3s here and there
Selecting random record from MySQL database table.
The simplest way of selecting random rows from the MySQL database is to use "ORDER BY RAND()" clause in the query.
Automatically & Manually Backup MySQL Database
MySQL is one of the most popular open source database management system for the development of interactive Websites.