dpkg: dependency problems prevent configuration of mysql-workbench-community for Ubuntu 13.04

While installing mysql-workbench-community-6.0.9 on Ubuntu 13.04 if you get below error. root@Dell-XPS:/home/nilnandan/Downloads# dpkg -i mysql-workbench-community-6.0.9-1ubu1204-amd64.deb Selecting previously unselected package mysql-workbench-community. (Reading database … 203112 files and directories currently installed.) Unpacking mysql-workbench-community (from mysql-workbench-community-6.0.9-1ubu1204-amd64.deb) … dpkg: dependency problems prevent configuration of mysql-workbench-community:  mysql-workbench-community depends on libctemplate0; however:   Package libctemplate0 is not installed.  mysql-workbench-community depends on…

“Duplicate Entry” error for key PRIMARY on UPDATE query (RBR + Triggers)

Recently, I have faced one interesting issue with Master(Active)-Master(Passive) replication (RBR + Triggers). Passive master was stopped due to “Duplicate Entry” error with update statement. It was something like this. Last_Error: Error ‘Duplicate entry ‘29014131’ for key ‘PRIMARY” on query. Default database: ‘db’. Query: ‘UPDATE `db`.`tab1` SET `empid`=’103′, `name`=’Nilnandan’,  `address`=’India ‘, `postcode`=’D100′, `phone`=’878 515 7788’;…

How InnoDB works with transactions and auto recovery

How InnoDB work with transactions: When any transaction will be completed with COMMIT,  InnoDB will write those changes in InnoDB Buffer Pool. After that InnoDB will run some background operations like checkpoint.  Checkpoint is the most important operation which will writes the changes on disk.   Lets see how it will work. During the checkpoint phase,…

Different type of threads used by MySQL

MySQL uses different type of threads for running specific utilities like mysql_install_db, flushes MyISAM tables, Replication, TCP/IP sockets etc. All threads can run with four different priorities like Interrupt, connect, wait and query priorities. Different types of threads are: The main thread : This one is created by MySQL client normally, this will be one…

Communication protocols in MySQL

Generally, MySQL supports connections between clients and the server using several networking protocols. Below are the main protocols which are used by client to connect with MySQL server. TCP/IP Unix socket file Named pipe Shared memory TCP/IP connections are supported by any MySQL server unless the server is started with the –skip-networking option. These connections…