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

learn more… | top users | synonyms

6
votes
0answers
113 views

insufficient history for index

In MySql log, there is one error `InnoDB: insufficient history for index 0' I don't know why its occur. I have done google and found following http://dev.mysql.com/doc/relnotes/mysql/5.5/en/news-5-5-...
3
votes
0answers
58 views

Read READ COMMITED transaction advantage in MySQL, high performance object model

I am writing high performance object model with READ COMMITED locking. My question is if there is any reason to starting READ ONLY transaction for read only operations vs. standard SELECT not ...
3
votes
0answers
21 views

Cluster of Clusters (Not using MySQL-Cluster)

I'll start with an apology, I'm an Ops guy at heart, not a DBA, so I may use the wrong terminology, not in an effort to annoy, merely because I don't know any better. OK, that over with, on to the ...
3
votes
0answers
358 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 ...
3
votes
0answers
162 views

Create an SSL connection with ODBC driver to MySQL(5.6) using openSSL

I want to create an asymmetric SSL connection from MySQL to an ODBC driver but don't fully know how to generate the keys and certificates (I'm using openSSL as recommended here: https://dev.mysql.com/...
2
votes
0answers
38 views

How to avoid row locks on both tables joined in an update?

I have little knowledge about MySQL internals, but I'm experiencing that in a query like: UPDATE t1 JOIN t2 ON t1.id = t2.id SET t1.a = x, t1.b = y, [, ...] WHERE [ ... ] rows from both t1 and ...
2
votes
0answers
35 views

MySQL Performance issue: ~360ms to fetch 120 rows with 10 columns

I have the following tables: CREATE TABLE `events` ( `id` int(11) NOT NULL AUTO_INCREMENT, `status` varchar(255) COLLATE utf8_unicode_ci DEFAULT 'draft', `publish_at` datetime DEFAULT NULL, ...
2
votes
0answers
286 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 ...
2
votes
0answers
83 views

Mysql Match…against query performance in InnoDB Mysql 5.6

I need to search records in the table which contains millions of records. I have recently updated Mysql version from 5.1 to 5.6. I was using like in query which was taking around 15 sec to 30 sec. ...
2
votes
0answers
601 views

Upgrading from MySQL 5.5 to 5.6 - timestamp issue?

I'm looking at upgrading my Percona Server setup from 5.5 to 5.6. Reading the upgrade docs from MySQL sounds mostly straightforward except for anything involving time/date columns. As far as I can ...
1
vote
0answers
34 views

Do not want to allow Queries to take more than x minutes?

Do not want to allow Queries to take more than x minutes ! What System variable can I set to automatically terminate it.
1
vote
0answers
19 views

Mysql InnoDB relations vanish when exporting/importing to online database

My issue is the following : I have a local database running on EasyPhp server : WEB serv : Apache/2.4.7 (Win32) PHP/5.5.8 DB serv : 5.6.15-log - MySQL Community Server (GPL) PHPMYADMIN : version 4.1....
1
vote
0answers
29 views

“SHOW TABLES” command returning tables not in the schema

I was debugging a backup script at work and noticed that for some of our bigger tables (greater than 5GB), I'm noticing an odd discrepancy. If I run the command mysql -h $host -u $user -p $pass -e '...
1
vote
0answers
49 views

Getting InnoDb internal Errors on every query run

I am having following errors in error.log at the run of each query due to which I am not able to use error.log properly. 2016-05-30 09:39:58 7f7c7e3cb700 InnoDB: Error: Column last_update in table "...
1
vote
0answers
51 views

MySQL - Find bookings free time slot

I am trying to find free time blocks on a day between the business hours (08:00 to 18:00) of a service station. The schema of the database is as below, CREATE TABLE IF NOT EXISTS `Bookings` ( `id` ...
1
vote
0answers
54 views

ERROR 1 (HY000): Can't create/write to file (Errcode: 13 - Permission denied)

I've been struggling for a couple of days with this now and have been trying to use this thread amongst other google searches to resolve it but can't seem to get it to work. When I run this SELECT ...
1
vote
0answers
74 views

Missing DDL and table

I encounter the following errors after reinstalling MySQL Server. These seem to affect only one out of the several tables in the schema. The following errors are generated from MySQL Workbench. When ...
1
vote
0answers
39 views

MySQL Event scheduler not generating CSV

The scheduler seems to be running from INFORMATION_SCHEMA.EVENTS but there is no CSV output. The event scheduler has to automatically produce a csv to pass on the data to another system. It's like ...
1
vote
0answers
27 views

When are UPDATE / INSERT operations processed in Online DDL in MySQL 5.6?

MySQL 5.6 includes functionality called Online DDL which allows ALTER operations to proceed on tables without applying a LOCK to the table (technically referred to as allowing Concurrent DML). https:/...
1
vote
0answers
37 views

Manually specifying candidate masters in Maxscale

Looking over the documentation, I haven't quite been able to find if its possible to manually set the candidate master status of a server in Maxscale. The reason I am looking for this is because some ...
1
vote
0answers
50 views

Disable/Remove Table Index for INSERT Performance

I am doing a database maintenance where I have to add new fields to a table with over 10GB of data about (20 million rows). To solve that I renamed tableA to be old_tableA and created a new table ...
1
vote
0answers
105 views

MySQL 5.6 Performance Tuning Issue

I have read and try lots of things about MySQL optimization and tuning. I tried most of them one by one according to our needs but nearly I got nothing. I am doing my test using some simulation ...
1
vote
0answers
40 views

Fetch items where related rows has different values

I have table in MySQL called attributes, and other table, attribute_values, one attribute can have multiple values, values identified by context attribute and has value_c attribute wich contain value. ...
1
vote
0answers
34 views

How to sync incomplete replication records in MySQL

if replication breaks and you end up with a couple of records not pushed out to the slave, is there a way to update the slave without stopping locks on the master and manually transferring a new ...
1
vote
0answers
38 views

Classic vs. GTID replication MySQL 5.6 - how to identity which one used from errors?

Is that true? In classic replication (SQL_SLAVE_SKIP_COUNTER=1) you never see UUIDs in logs and show slave status like 3e11fa47-71ca-11e1-9e33-c80aa9429562:1-5? When you see an UUID, there is GTID ...
1
vote
0answers
3k views

mysqld upgrade 5.5 -> 5.6 mysql Error: Failed while fetching Server version! Could be due to unauthorized access

After updating mysql with yum to 5.6 I am getting such an error message when trying to run mysql [root@host rpm]# mysql_upgrade Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck ...
1
vote
0answers
58 views

After disabling replication, should I disable binary logging?

I have a master-slave setup currently but am going to remove the replication DB server. The DBs are running on MySQL 5.6. I have a couple of questions about removing the replication: 1) I have read ...
1
vote
0answers
16 views

Variables for Merging MySQL InnoDB Tables

I have several thousand InnoDB tables in MySQL 5.6 that I am trying to merge together into a single table. A simplified form of the queries I am executing (one for each of the tables to merge) is ...
1
vote
0answers
30 views

Connection timed out & MySQL server has gone away with innodb engine

I have created chat application which ping server every sec for messages. Currently I have done load test with httperf, with 500 request/sec. "Connection timed out & MySQL server has gone away ...
1
vote
0answers
72 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
251 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: https://gist.github.com/jonhatalla/...
1
vote
0answers
363 views

Records not getting replicate from Mysql 5.5.32 to MySQL 5.6

I have a MySQL 5.5.32 server (community edition) on one Linux server which is master. I have a MySQL 5.6 server (community edition) on another Linux server which is slave. I have installed various ...
1
vote
0answers
179 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 ...
1
vote
0answers
243 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 ...
1
vote
0answers
172 views

Master/Slave and Master/Master replication - MySQL

What is the difference between having a master-slave replication and having a master-master( where in the second master acting as hot-standby - active-passive) replication? Also, what are the issues ...
1
vote
0answers
363 views

How to find where an unauthenticated user connects from

We are seeing some "unauthenticated users" when I run the command show full processlist in mysql (v5.6). | Id | User | Host | db | Command | Time ...
1
vote
0answers
70 views

DatabaseRestart

I have strange problem, we are using circulation replication, between 2 different network with 5.6.25 and 5.6.22 version of MySQL and RAM is 64GB with 45GB innodb_buffer_pool Master Server is running ...
1
vote
0answers
30 views

prioritize one query over the other in mysql

Is it possible to prioritize one thread over the other in mysql. The scenario that I'm trying to address is as follows :- 2 threads T1 and T2 are both trying to acquire a lock on a table. T1 is a ...
1
vote
0answers
196 views

Unicode character replication MSSQL to MYSQL in Symmetric DS

I'm doing replication from MSSQL to MYSQL using symmetricds and it is working fine. Now , the problem is: In the SQL Server table , I have a column defined as NVARCHAR(20) which accepts unicode ...
1
vote
0answers
789 views

Facing Failed to read stream error - mysql_native_password error

I have been facing the following error intermittently on MySQL. Authentication to host '127.0.0.1' for user 'root' using method 'mysql_native_password' failed with message: Reading from the ...
1
vote
0answers
312 views

amazon rds logs all queries

I have enabled slow query log on Amazon RDS with following configuration. long_query_time = 0.5 general_log = 0 log_output = TABLE min_examined_row_limit = 1000 slow_query_log = 1 ...
1
vote
0answers
359 views

mysql upgrading from 5.1 --> 5.6 do I have to do mysqldump before upgrade?

I was reading this document: http://dev.mysql.com/doc/refman/5.5/en/upgrading-from-previous-series.html It says when upgrading from mysql 5.1 to do a mysqldump and then a reload. Is there anyway ...
1
vote
0answers
4k views

mysql 5.6 GTID replication 'Got fatal error 1236 from master when reading data from binary log'

I Checked SHOW SLAVE STATUS error is "'Got fatal error 1236 from master when reading data from binary log: ''The slave is connecting using CHANGE MASTER TO MASTER_AUTO_POSITION = 1, but the master ...
1
vote
0answers
500 views

Mysql 5.6 and install php5-mysql , mysql-common

I install Mysql 5.6 with this documentaion(in ubuntu 13.04) , now I need to install php5-mysql and mysql-common packages. can I install them with apt-get? I think they will install mysql5.5 compatible,...
0
votes
0answers
10 views

mysql error: Could not open or create the system

I am getting following error message in /var/log/mysql/error.log file. 2016-07-25 21:36:01 16376 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or ...
0
votes
0answers
5 views

TPC-H query-18 takes too much of time

TPC-H query-18 takes too much of time. How do i optimize it. No MY.CNF settings have been changed and no indexes have been applied . Please suggest on how to get better results on MYSQL 5.6
0
votes
0answers
9 views

downgrade mysql from 5.6 to 5.3/5.4

We have an issue in our server when we try to connect from A server using php v 5.6 to B server mysql 5.5 it throws an error saying " Failed to connect to MySQL: The server requested authentication ...
0
votes
0answers
21 views

Row replication and statement replication in the same topology?

Is it possible to set one master server replicate to one or more slaves using row-based replication and then one of the previous slaves act as master and replicate to another slave using statement ...
0
votes
0answers
67 views

MySQL: Log only 'select' queries executed on a specific set of tables of a database

I have a Magento site in which I want to log only SELECT queries(after SELECT it could be any column or all columns, in short all SELECT statements) executed on a specific set of tables, also as it's ...
0
votes
0answers
26 views

counting and sorting join mysql

i have table like bellow it store of amount of buys of each user +--------+----------+ | userid | amount | +--------+----------+ | 1 | 1000000 | | 2 | 80000000 | | 3 | 7000000 | | ...