Activities

March 2017
M T W T F S S
« Feb    
 12345
6789101112
13141516171819
20212223242526
2728293031  

MySQL : ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails

mysql-logo

While I’ve been working with MySQL host more frequently, I’d to drop a database due to storage space constraint. When I’m executing the drop command,it showing an error that

"ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails"

.

Some strange error but not severe since MySQL database is [...]

Renaming database having innodb tables/Moving inoodb database

mysql

While you are working with Huge MySQL data, you will need to switch your tables to innodb storage engine to get fast transactions performance. Suppose if you have a requirement to restore the database which having +>400G volume and the target server having the same database name exist. So if you restore the database, the [...]

MySQL : Managing Sleeping / Active connections to avoid “too many connections” error

One the busiest MySQL server recently had an issue with “SQL Error 1040: Too Many Connections”. This server has already set 1000 connections limit which I believe quite enough to handle our platform. But we were getting frequent MySQL outage due to this kind of errors. We know that it’s a application leakage issue and [...]

MySQL : Improving performance through thread_cache_size

mysql

We can improve the MySQL server performance at the best level if it is being used for read operations most of the time. Based of the Database server analysis, it is observed that more than 70% of traffic is being used “select” statements ie read operations. So I increased the “query_cache_size” and found faster throughput [...]

RDS- MySQL : How do I find the database size and bigger tables

mysql

I have to know the disk consumed by the MySQL data on a RDS server hosted in Amazon cloud. One of the easy thing which I used was PhpMyAdmin UI and check the tables brief list. Unfortunately this database has more than 500 tables. So I feel it’s a lazy approach.

When I started [...]

InnoDB: The error means mysqld does not have the access rights to

mysql-logo

I’m migrating my CentOS 6.4 Desktop to Ubuntu 14.04 LTS on this week as I found that CentOS 7 was not much Great that I expected. It does not support aged hardwares.

While I’m changing MySQL data directory to a different location and initializing the server. I got a strange error like this “InnoDB: [...]