I experienced a problem on a MySQL Server configured with Master/Slave replication , the Slave wasn't updating properly and the comm...
Read More
Home / MySQL
Showing posts with label MySQL. Show all posts
Showing posts with label MySQL. Show all posts
MySQL - Drop tables with common prefix
I needed to delete multiple tables with name like 'TMP_%' the following procedure do this job in an effective way ! DELIMITER $$ D...
Read More
MySQL Restore slow
I notice dump restore is really slow and I tried to work on some parameters. The following parameters afftect in a positive manner: innodb_...
Read More
Subscribe to:
Posts
(
Atom
)