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…

Percona server 5.5/5.6 installation failed on Ubuntu 13.04/13.10(amd64)

While installing Percona Server 5.5/5.6 on Ubuntu 13.04/13.10, I got some weird errors, which I never faced before. Errors were something like, dpkg: error processing /var/cache/apt/archives/libmysqlclient18_1%3a5.5.35-rel33.0-611.raring_amd64.deb (–unpack):   libmysqlclient18:amd64 1:5.5.35-rel33.0-611.raring (Multi-Arch: no) is not co-installable with libmysqlclient18 which has multiple installed instances shell>  sudo apt-get install percona-server-server-5.5 Reading package lists… Done Building dependency tree Reading…

“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,…

How to install Canon MP287 scanner in ubuntu 12.04

It’s bit tricky but easy to install. Download both printer/scanner deb packages from below location: http://support-in.canon-asia.com/contents/IN/EN/0100301402.html http://support-in.canon-asia.com/contents/IN/EN/0100302702.html Untar and install .deb packages in ubuntu. You can also install by running ./install.sh i.e tar -xzvf cnijfilter-mp280series-3.40-1-deb.tar.gz cd cnijfilter-mp280* ./install.sh Now, check that your scanner is being detected or not. shell$ sane-find-scanner   # sane-find-scanner will now…

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…