Detect "Too many connections" error and show alternate web page
Category 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.
Useful WordPress SQL Queries You Wish You Knew Earlier
WordPress is driven by a MySQL database. This is something active WordPress users would know. However, if you only just read about it here from us, here’s what you should know. MySQL is a free relational database management system available in most web hosting services. All of the WordPress data like the posts, comments, categories, …
Continue reading “Useful WordPress SQL Queries You Wish You Knew Earlier”
MySQL AES Encryption With PHP
Security should be at the top of every developer’s mind when building an application that could hold sensitive data. We wanted to replicate MySQL’s functions because a lot of our data is already AES-encrypted in our database, and if you’re like us, you probably have that as well.
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.