Some mysql grant queries Granting permission for a particular DB only mysql> grant all privileges on databasename.* to ‘username’@’localhost’; mysql> flush privileges;

Granting Permission for all the DB mysql> grant all privileges on *.* to ‘username’@’localhost’;

Granting Permission from a particular IP # grant all privileges on *.* to ‘username’@’192.168.0.20’;

# […]

We can check how can we able to setting up mysql server with partition enabled. Lets see what is mysql partition means.

A partition is a division of a logical database or its constituting elements into distinct independent parts. Database partitioning is normally done for manageability, performance or availability reasons.

A popular and […]

We can monitor mysql queries and database using an utility called MonYog. MONyog is a monitoring and advisory tool for MySQL Community as well as Enterprise versions.MONyog is agent-less, and does not require anything to be installed on the MySQL servers. MONyog helps monitor enterprise database environments.

MONyog MySQL Monitor and Advisor MySQL DBAs […]

mysqlhotcopy vs mysqldump mysqlhotcopy is a Perl script that was originally written and contributed by Tim Bunce. It uses LOCK TABLES, FLUSH TABLES, and cp or scp to make a database backup quickly. It is the fastest way to make a backup of the database or single tables, but it can be run only on […]

Mysqlslap is a Load Emulation Client. mysqlslap is a diagnostic program designed to emulate client load for a MySQL server and to report the timing of each stage. It works as if multiple clients are accessing the server. mysqlslap is available as of MySQL 5.1.4.

mysqlslap runs in three stages:

1. Create schema, table, and […]