Question : I currently have a Master with 2 slaves, all running MySql 5.5. What are the limitations on the […]
Tag: mysql-5.5
Reorder missing numbers in a sequencein two different tables using MySQL [duplicate]
Question : This question already has an answer here: Reorder / Fill the missing numbers in a sequence using MySQL […]
How do I use subquery on the same table in MySQL?
Question : I have a query like this which takes a really long time to run. The table is around […]
How to upgrade MySQL to a New version..?
Question : I have installed mysql using the package management system.I am using ubuntu machine. After that i have very […]
Reference outer variables in nested select in bigquery vs mysql
Question : I run following request in MySQL and it works, but results in an error with bigquery standard SQL. […]
What’s the practice to generate long user id like those on Facebook?
Question : Now I am about to launch a site and I have trouble coming up with a way to […]
INSTALL PLUGIN ‘rpl_semi_sync_master’ SONAME ‘semisync_master.so’ not working
Question : I’m trying to install semi synchronous replication in my mysql 5.5 and trying to execute the below command: […]
MySQL runs out of memory when importing innodb database
Question : I have a small VPS with 512MB RAM and no swap (can’t have any). I am importing a […]
Some MySQL slave errors?
Question : Master version: mysql-server-5.5.14-1.el5.remi Slave version: Percona-XtraDB-Cluster-server-5.5.24-23.6.340 Binlog format: ROW based I’m using PRM to setup HA for MySQL. […]
Database migration, how to
Question : I have two databases DB1 and DB2. In both databases exists this two tables mo_sms and mt_sms. This […]