Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 61 to 70 of 983 10 Older Entries

Displaying posts with tag: Uncategorized (reset)

How to use mysql_config_editor – video
+0 Vote Up -0Vote Down

Below video will depict :

* How to set a login path

* How to use login path in mysql client

* How to use login path in mysqldump

* How to remove login path



You can download the slides from below URL


Musings on MySQL enhancements
+0 Vote Up -0Vote Down

1) Update_time not accurate in information_schema.tables

Information_schema.tables has a field called update_time and in 5.6 you will notice that it is always NULL. Future versions of MySQL will fix this problem

2) Multiple instance manager

Currently creating , managing and dropping instances in MySQL requires many DBA hours. mysqld_multi is there to help you but it requires initial configuration and there are other third party utilities that could come to your rescue

It would be better to have built in utilities to help us in this regard.. For example db2 has db2icrt that creates an instance , db2ilist …

  [Read more...]
Paramiko Update Tutorial
Employee_Team +0 Vote Up -0Vote Down

There are situations when you need to update the python-paramiko library that is bundled with MySQL Workbench. This may be because you prefer
using the latest cutting edge versions, are just curious, or you can’t wait for a new Workbench version.

To update, first download the latest python-paramiko release from After downloading and extracting the archive, you’ll see a paramiko folder inside of the extracted folder. This folder needs to be copied into the appropriate MySQL Workbench folder on the system.

* …

  [Read more...]
MySQL:The user specified as a definer does not exist (error 1449)-Solutions
+0 Vote Up -1Vote Down

Explaining and providing solutions of MySQL error 1449: The user specified as a definer does not exist using SQL SECURITY INVOKER and DEFINER.

Heads up! MySQL 5.7 DMR6 contains a (small) known bug
Employee +1 Vote Up -0Vote Down

MySQL 5.7 DMR6 was been released today! By my crude measurement, it is a big release with a number of new features and bug fixes:

morgo@Rbook:~$ for V in 1 2 3 4 5 6; do curl --silent$V.html | wc -l; done;
4914 <-- DMR2
4121 <-- DMR6

The release notes have one important known bug to note:

  [Read more...]
MySQL Utilities Makes Skipping Transactions on Multiple Servers Easy
Employee_Team +0 Vote Up -0Vote Down

We are very happy to introduce a new MySQL utility named “mysqlslavetrx“, which allows users to easily skip multiple transactions on multiple servers in a single step. This utility is one of three new utilities included in MySQL Utilities release-1.6.1 Alpha. The other utilities are “mysqlbinlogpurge” and “mysqlbinlogrotate“, which can be used to purge and rotate binary logs.

The mysqlslavetrx utility allows you to skip multiple transactions on several slaves. More precisely, it injects empty transactions for the specified Global Transaction Identifier …

  [Read more...]
MySQL Vs Db2 – Part 1
+0 Vote Up -0Vote Down

MySQL is open-source RDBMS and is gaining popularity in the recent years.. I am starting a comparison series for mysql and db2..This series will help MySQL DBAs to catchup Db2 quickly and vice versa.. Please post your feedback

1. Knowing the software version :

mysql> select version() ;


| version() |
| 5.5.28 |
1 row in set (0.00 sec)

mysql> show global variables like 'version%' ;
| …

  [Read more...]
mysqlfailover – Installation and Operations tutorial
+1 Vote Up -0Vote Down



1) Download the utilities. Python connector is a prerequisite and this needs to be installed along with mysql utilities rpm




2) Install the RPMs. “Mysqlfailover –help” will confirm the install of the utilities

rpm –ivh mysql-connector-python-2.0.2-1.el6.noarch.rpm

rpm -ivh mysql-utilities-1.5.3-1.el6.noarch.rpm


3) Set the …

  [Read more...]
Enterprise Monitor: “Add Bulk MySQL Instances” 50 in 1-click.
Employee +1 Vote Up -0Vote Down

Carrying on with my MySQL 5.7 Labs Multi Source Replication scenario, I wanted to evaluate performance impact via MySQL Enterprise Monitor.

Whilst I opened my environment, I remember that I had generated lots of different skeleton scripts that allowed me to deploy the 50 servers quickly, and I didn’t want to add each of my targets 1 by 1 in MEM. So, I used one of the many features available, “Add Bulk MySQL Instances”.

So, I’ve …

  [Read more...]
MySQL Dumping and Reloading the InnoDB Buffer Pool
+0 Vote Up -0Vote Down

MySQL’s default storage engine as of version 5.5 is InnoDB. InnoDB maintains a storage area called the buffer pool for caching data and indexes in memory. By keeping the frequently-accessed data in memory, related searches are retrieved much faster than reading from disk.

When you stop or restart MySQL, you lose the cached data stored in the buffer pool. There is a feature in MySQL 5.6 which allows you to dump the contents of the …

  [Read more...]
10 Newer Entries Showing entries 61 to 70 of 983 10 Older Entries

Planet MySQL © 1995, 2016, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.