MySQL version 5.6 - please also tag with mysql for search purposes.

learn more… | top users | synonyms

1
vote
0answers
41 views

Restoring MySQL Master-Master Replication

I am trying to restore Master-Master MySQL 5.6 servers. The replication failed between DB1=>DB2 and so DB2 went out of sync. GTIDs are enabled. I have done an export and import from DB1 to DB2 and ...
1
vote
0answers
25 views

Alter a large mysql table 700 gb

The production table I want to alter is around 700 Gb. I want to remove a FK from that table. Mysql version is 5.1.61-log. I found following options: pt-online-schema-change: alters a table’s ...
0
votes
0answers
28 views

Unable to update table in MySQL Function

I have a requirement, where in i have create a function which will generate Alphanumeric Values based on the two Inputs..1. A string 2. A Digit. Like If the string is Mem..then Mem001,Mem002 and If ...
1
vote
1answer
81 views

How do flush innodb table, copy files, then unlock tables from Windows bat file?

I can successfully execute "FLUSH TABLES myTable FOR EXPORT;" in MySql Workbench. Then I can copy the cfg and ibd files I need, and then I can go back to workbench and run "UNLOCK TABLES" and all is ...
0
votes
0answers
53 views

Unable to set InnoDB buffer pool size >900Mb

On Windows server 2003 sp2 OS with 4 GB of RAM, running MySQL 5.6 it was previously running with 1000Mb but when I try to restart the service it was failing to start with this error: InnoDB: ...
1
vote
1answer
198 views

MySQLWorkbench with MariaDB 10.0 Performance tab not working

I'm using MySQLWorkbench 6.3.3.0 (build 592) and I cannot use the performance tab on a Mariadb10 connection. This is the error I receive: This feature requires MySQL version 5.6.6 or newer ...
1
vote
1answer
55 views

Really strange behavior using variables in MySql query

I was answering a Question on Stack Overflow forum and the OP notice a really strange behavior that I could reproduce using the SQLFiddle site So lets go to it. We have this setup: CREATE TABLE ...
0
votes
0answers
19 views

events not getting completely written in binary log file MySQL 5.0.32

referring this question : Records not getting replicate from Mysql 5.5.32 to MySQL 5.6 i found that binary log files which has been created at master database server , i see following surprising ...
0
votes
1answer
93 views

Missing statement information from 'LATEST DETECTED DEADLOCK' InnoDB status output

I'm learning how to interpret the LATEST DETECTED DEADLOCK section in the output of SHOW ENGINE INNODB STATUS, and had a question about the output. Some sample output of SHOW ENGINE INNODB STATUS ...
1
vote
1answer
784 views

Cannot connect to MySQL sever with MySQL Workbench

I am using MySQL 5.6.26 Community Server on a Mac OSX 10.10.4. The server is running, according to the preference pane utility. Also I can connect to the server using the command line tool with the ...
1
vote
1answer
390 views

MySQL UPDATE query stuck on “Sending Data” State

I am having difficulty getting an UPDATE query to successfully execute, due to the process getting stuck on "Sending Data" state. I feel this differs from similar questions about the "Sending Data" ...
1
vote
1answer
55 views

MySQL Dying After a Few Days

I just recently upgraded to Ubuntu 15.04 from 14.04, I guess the MySQL was also upgraded to 5.6. Is there a reason why my database stops working. Rebooting the system is the only fix for it, but it ...
1
vote
2answers
432 views

ERROR Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)

We are facing the issue in replication that we are not getting any error in Show slave status\G output rather facing the following issue in Error Log File [ERROR] Error reading packet from server: ...
0
votes
1answer
35 views

dev.mysql.com has 2 different installers to download, which do I need?

If you go to http://dev.mysql.com/downloads/windows/installer/ there are 2 installers you can download. They both are named exactly the same and have the same version number. There is nothing on the ...
2
votes
1answer
59 views

Calling stored Procedure from one db to give me a result in another db

CREATE DEFINER=root@localhost PROCEDURE AccountReqs( IN IsNewAccountStart VARCHAR (255) , In AccountName varchar (255) , IN AccountNumber varchar(255) ...
1
vote
0answers
127 views

Poor performance after switching from EC2 Percona to RDS MySQL. What am I missing?

Current RDS Setup: db.r3.2xlarge running in Multi-AZ, 8 VCPU, 61GB RAM, 1500GB EBS Volume with 5000PIOPS, Mysql5.6 Here are our current MySQL variable values: ...
0
votes
1answer
334 views

MySQL: find full table scan queries

Using MySQL 5.6.24. What is the best way to extract the text of queries using full-table scans? The "Full Table Scans" report in MySQL Workbench doesn't include the complete query (some text is ...
0
votes
1answer
39 views

Multiple select for single row insert

I need to insert a row into a table by selecting value from multiple tables. I want a row to be inserted from multiple tables. insert into tab(id,name,date) values ((select max(id)+1 from ...
0
votes
0answers
72 views

Significance of common schema - MySQL

Why common schema is not available in MySQL 5.6? What is the significance of it? So If there is a need for common schema for an application, what is the workaround to have common schema in 5.6 or ...
1
vote
0answers
200 views

Records not getting replicate from Mysql 5.5.32 to MySQL 5.6

1. I have a MySQL 5.5.32 server (community edition) on one Linux server which is master. 2. I have a MySQL 5.6 server (community edition ) on another Linux server which is ...
0
votes
0answers
83 views

How to implement a query insert into BEFORE INSERT trigger syntax

I want to insert data using trigger into 2 tables. I want to implement my query insert to a before insert trigger. Since I was newbie for using MYSQL, I'm confused how to implement it. insert into ...
0
votes
0answers
47 views

When does query data get aged evicted out of cache in MySQL query runs slow then fast then slow again

Running Virtual Machine - 5.6.19 MySQL Community Server on Linux When does the data / queries get aged out of the buffer pool in MySQL? I have a dev server with 1GB was using default sized buffer ...
2
votes
1answer
181 views

MySQL BEFORE INSERT trigger with IF conditions

In my BEFORE INSERT trigger, I select data, then I check the value if it's null then I do insert data into table A then else into table B. I select data from a table in another database called ...
7
votes
1answer
498 views

Issues with MySQL installation

First of all, excuse the length, this post is very long, and needs some background, second; it has been hard for me discerning the signal from the noise, please bear if some of this is not relevant: ...
6
votes
1answer
93 views

MySQL database design to sort and filter air traffic data

I am struggling to design the correct database / structure for what I'm trying to do. Let me try and explain the situation. Background We are a group of enthusiasts who monitor air traffic via ...
2
votes
1answer
36 views

MySQL users not visible after import

I have a Percona MySQL database 5.6 running in a linux machine. I have created new users called test1 and test2. What I did was I imported mysql database from my test setup to this new setup. After ...
2
votes
1answer
53 views

MySQL connection process slow for non-root user

I'm using Percona server 5.6 on Linux. When I connect to MySQL from the command line as the root user, it connects immediately. I have also created a new user in the database, but when I try to ...
1
vote
2answers
162 views

Disaster recovery solution for MySQL

I have set a Master-master replication with the second Master running as read-only. This master-master setup is on the same location. Now I will have to setup an DR for this production at a different ...
0
votes
2answers
72 views

Setting up MySQL master-slave replication

I am trying to setup master-slave replication on MySQL 5.6. When I update my database in the master, the change is not reflected on the slave. When I show the process list on the slave it shows this ...
1
vote
1answer
121 views

MySQL queries taking very long/not finishing

I just started working with databases and have a problem with queries taking very long. My table has the following form CREATE TABLE table (column1 INT(10) AUTO_INCREMENT PRIMARY KEY, column2 ...
2
votes
1answer
87 views

How to:: Master-Master replication

I have setup Master-Master replication on two servers. Now, my question is that if I need to have the second master as only read-only, what should I do? I tried doing mysql> flush tables with ...
0
votes
0answers
28 views

Doubt on Master-Master replication

I'm setting up a master-master replication where in the second master is only read only there by reducing the issues of conflicts. My doubt is that to reduce the downtime when my master goes down I ...
0
votes
1answer
79 views

replication filtering replicate-rewrite and do-table Mysql 5.6 (innodb engine )

I have a master/slave replication setup based on statement based replication. On master database named DB1, I have 5 tables and I want to replicate only two table on slave's database named DB2. Also, ...
2
votes
0answers
142 views

Issues with mysql enterprise backup, assertion failure on restore

I'm trying to restore a backup to a new server, but having some issues with corruption. The source server has a 2.5T table which is very active. I copied the latest backup over to a new server and ...
0
votes
1answer
210 views

Changing Data Directory on MySQL DB Server

I have installed mysql server 5.6.24 on Windows Server 2012 R2. I imported dump files and the data files are stored in C:\ProgramData\MySQL\MySQL Server 5.6\data I want to change directory like ...
1
vote
1answer
64 views

Slow MySQL query when the IN list is long

I have 3 tables, namely: product, product_has_category, category: CREATE TABLE IF NOT EXISTS `product` ( `id` int(11) NOT NULL, `name` varchar(255) DEFAULT NULL, `des` text COMMENT 'description', ...
0
votes
2answers
55 views

Upgrading the mysql server from 5.1 to 5.6?

My server have CentOS6. Currently I'm are using the Percona 5.1.47 version. Would like to upgrade to 5.6. What is the best way to do, and what are the prerequisites to keep in mind before doing ...
0
votes
0answers
72 views

Importing old SQL database dump onto local Windows 10 desktop system

Hi I just installed MySQL 5.6 on Windows 10 x64. I'm trying to execute an old backup file that happens to be 5 gigs. Some of the insert lines are really long and so the server loses connection. I ...
2
votes
1answer
136 views

MySQL slave server getting stopped after each replication request from Master

Basic master-slave MySQL configuration has been done on Windows machine. Master and slave servers are running on localhost with different ports. Now when executing update or insert in master server, ...
1
vote
1answer
42 views

enable log_bin_use_v1_row_events in mysql 5.6

I have a MYSQL master with two slaves also running MYSQL 5.6. I want to create another slave and that needs to be MYSQL 5.5. I was wondering if replication will work smoothly. I have ...
1
vote
2answers
174 views

FLUSH TABLE : can't execute the given command because you have active locked tables mysql

If I execute these queries one by one, all fail except the first: Query1 : flush table tablename1 with read lock; Works Query2 : flush table tablename2 with read lock; Error : can't ...
1
vote
0answers
129 views

MySQL Master-Master Crash-Safe Replication: Slow UPDATE times

Environment 2 MySQL version 5.6.26 Dedicated MySQL Servers connected on a LAN. Servers Have 16 Cores with 32 GB RAM each and are really fast. Master-Master Crash Safe Replication is setup on both ...
0
votes
0answers
36 views

One node in Percona Cluster isn't coming up with following error

Whenever I try to start the services on this specific node it is failing with this error in log: [ERROR] WSREP: Node IP address not obtained from bind_address, trying alternate methods
3
votes
1answer
123 views

query optimization of a left join

I have the following query written into the slow log (mysql-slow.log). I don't have much idea how to optimize this query. I already have indexes for: mode, f.user_id... etc but doesn't seem to ...
1
vote
0answers
136 views

MySQL Server Instance Configuration Wizard does not start for the first time

I tried to install MySQL on my machine (win 8 64 bit). I downloaded mysql-5.6.24-winx64.exe and after completing the MySQL 5.6 setup wizard, MySQL Server Instance Configuration Wizard does not start ...
5
votes
3answers
862 views

How can I force MySQL to IGNORE ALL indexes?

I have read articles about FORCE index, but how can I force MySQL to IGNORE ALL indexes? I tried SELECT * FROM tbl IGNORE INDEX(*), but I was not successful. As for why I (and others) need to do ...
1
vote
2answers
77 views

Weird Syntax Error [closed]

I'm working with MySQL 5.6 on a Ubuntu 14.04 server. Checking in this online syntax checker: https://sql.treasuredata.com/ The syntax checker tool throws the exception: mismatched input 'NOT' ...
2
votes
0answers
149 views

Replication stops with GTID_NEXT error after creation/drop of memory table in mysql5.6

We have recently upgraded to mysql5.6.25 from mysql5.5.x/mysql5.1.x on our mysql-cluster. Below is a brief snapshot of our architecture. Since we have upgraded and enabled gtid-mode we have been ...
1
vote
1answer
449 views

Set sql_mode “blank” after upgrading to MySQL 5.6

After upgrading MySQL from 5.5 to 5.6, some our app face to problem and need set sql_mode to blank to solve this issue. I added sql_mode = '' to my.cnf but there was no effect on the mysql setting. ...
0
votes
0answers
33 views

Checksum mis-match found on a table while restoring data using mysqlbackup

We are trying to restore MySQL data (which was backed up using a single image) using the mysqlbackup utility. But, all of a sudden, it is showing checksum mis-match for table t1 Our questions ...