Profile cover photo
Profile photo
ANIL YADAV
446 followers -
DBA/Consultant/Trainer
DBA/Consultant/Trainer

446 followers
About
ANIL's posts

Post has attachment
How THP and Kernel Version effects MySQL Stability
During last year , i have faced multiple stall issue. MySQL Service was getting stalled any time, without leaving any clue in any logs. MySQL Service was getting restarted after 15 Minute of stall. We (Me and My Team ) were clueless. Initially ,we were unde...

Hi, I am using #Smart_AppLock. It can lock any App you like, it is so great! Url: http://m.onelink.me/ff5f33e8

Post has attachment
MySQL: ERROR 1345 (HY000): EXPLAIN/SHOW can not be issued; lacking privileges for underlying table
While performing select on view one of db user got below
error ERROR 1345 (HY000): EXPLAIN/SHOW can not be issued; lacking privileges for underlying table Tough user was having select access on required database.
 I was surprise with error.  After trying fo...

Post has attachment
MySQL and MS SQL Datatype Comparison
While working on Database migration between MS SQL and MySQL(MSSQL-> MySQL) ,i compared different datatype   available in MS SQL and MySQL. Below is complete list. Data
Type Comparison Between MySQL and MS SQL Server MySQL MS SQL Comments Integer TINYINT(...

Post has attachment
MySQL 5.6 Installation Error and solution
While
installing MySQL 5.6  on Linux faced one error today. Can't
locate Data/Dumper.pm in @INC (@INC contains: /usr/local/lib64/perl5
/usr/local/share/perl5 /usr/lib64/perl5/vendor_perl
/usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at
/...

Post has attachment
Max Allowed Packet Error in MySQL Replication
 Last week one of my friend called and Ask for help. He told
me he is getting below error in his MySQL setup.   Last_IO_Error: Got fatal error 1236 from master
when reading data from binary log: 'log event entry exceeded
max_allowed_packet; Increase max_all...

Post has attachment

Post has attachment

Post has attachment

Post has attachment
Wait while more posts are being loaded