Profile cover photo
Profile photo
Rathish Kumar
225 followers
225 followers
About
Posts

Post has attachment
How to find database and table size in MySQL?
As a Database Administrator(DBA), your job want you to know the most atomic details of databases in your server. It happens for me many times, my boss/ delivery manager asking me, what is the size of a specific database or specific table, in this kind of si...
Add a comment...

Post has attachment
Deleting huge number of records in MySQL
This is a short post about DELETE data from huge table in MySQL. Most of us experienced, deleting huge record from MySQL tables taking long time, sometimes hours to complete deleting millions of records. Also, on production servers it locks the other table ...
Add a comment...

Post has attachment

Post has attachment
Understanding MySQL innodb_flush_log_at_trx_commit variable
The main objective of this post is to understand why innodb_fush_log_at_trx_commit variable is used? What are the applicable values for innodb_fush_log_at_trx_commit? How innodb_fush_log_at_trx_commit value will impact the MySQL performance and data safety?...
Add a comment...

Post has attachment

Post has attachment
How to store IP (internet protocol) address in MySQL?
Internet Protocol address is a special kind of data. This data does not correspond directly to available MySQL built-in data types. I have seen in many servers, the IP(Internet Protocol) address is stored in CHAR(12), VARCHAR(15), TEXT and so on.  The dotte...
Add a comment...

Post has attachment

Post has attachment
[Solved] Can’t connect to MySQL Server
There are a lot of different reasons behind this error. Sometime, you may not see the exact issue on the error message. You have to dig deeper to identify the exact cause. It may take a lot of time and energy to debug this error. I have encountered this err...
Add a comment...

Post has attachment
How to fix MySQL Too many connections error?
Error Message: ERROR 1040 (HY000): Too many connections MySQL Too many connections Reason for this error: This error occurs when connection reaches the maximum limit as defined in the configuration file. The variables holding this value is max_connections T...
Add a comment...

Post has attachment
Wait while more posts are being loaded