[MySQL]: Purpose of Profiler in MySQL
MySQL Profiler: The SQL Profiler is built into the database server and can be dynamically enabled/disabled via the MySQL client utility. To begin profiling one or more SQL queries, simply issue the following command: mysql> set profiling=1; Two…
[MySQL]: Event Scheduler
The MySQL Event Scheduler manages the scheduling and execution of events: Tasks that run according to schedule. Event support was added in MySQL 5.1.6. MySQL Events are tasks that run according to a schedule. Therefore, we sometimes refer…
[MySQL]: Buffering and Caching
MySQL uses several strategies that cache information in memory buffers to increase performance. Depending on your database architecture, you balance the size and layout of these areas, to provide the most performance benefit without wasting memory or exceeding…
[MySQL]: InnoDB Buffer Pool
The InnoDB Buffer Pool InnoDB maintains a buffer pool for caching data and indexes in memory. InnoDB manages the pool as a list, using a least recently used (LRU) algorithm incorporating a midpoint insertion strategy. When room is needed…
[MySQL] : Locking issues
Locking Issues MySQL manages contention for table contents using locking: Internal locking is performed within the MySQL server itself to manage contention for table contents by multiple threads. This type of locking is internal because it is performed entirely…
[MySQL]: How do we set-up Replication
How to Set Up Replication: This section describes how to set up complete replication of a MySQL server. There are a number of different methods for setting up replication, and the exact method to use depends on how you…
[MySQL]: HA and Scalability
Replication: Replication enables data from one MySQL database server (the master) to be replicated to one or more MySQL database servers (the slaves). Replication is asynchronous – slaves need not be connected permanently to receive updates from the master. Depending…
Setting password for MySQL root ID
Once you’re done with MySQL Installation from http://dbversity.com/mysql-rpm-installation/ You can set password for MySQL root ID as below. MySQL installs with no password protection on root access (blanks) We use this method to set it to Winter06 and GPA will…
MySQL stored procedures
What’s a Stored Function If procedural programming is new to you, you may be wondering what the difference is between a Stored Procedure and a Stored Function. Not too much really. A function always returns a result, and can be…
HOW DO WE EXCLUDE SQL FROM REPLICATING IN MYSQL
If you’re using MySQL Replication, in few cases you may require to skip a particular SQL statement from replicating – which is to be executed on Master and should not be on the Slave. Though, its not a good practice!…