MySQL 5.6 : Latest Release of MySQL with improvements that enhance every functional area of the database kernel.

learn more… | top users | synonyms

2
votes
1answer
30 views

mysqldump --single-transaction, yet update queries are waiting for the backup

If I use mysqldump --single-transaction, according to the docs it should do flush tables with read lock to get a consistent state and then start a transaction and no writers should be waiting. ...
0
votes
1answer
35 views

How performance schema in mysql 5.6 improve performance?

Since MySQL 5.5 performance_schema database has been added likewise information_schema. As we know that tables in information_schema contains statistical information like tables, plugins, partitions, ...
0
votes
2answers
31 views

Seg faults in Percona Server 5.6.19

Trying to figure out what went wrong here. Any advice would be appreciated. This server is running a new installation of Percona Server 5.6.19 on CentOS 6.5 16:05:46 UTC - mysqld got signal 11 ; This ...
0
votes
0answers
12 views

Unable to install mysql 5.6.17and configure mysql on Win 7 -64 bit Os

Already seen this post but not my type of question as iam stuck in the installation itself I am trying to install MySQL 5.6.17 on Windows 7 64-bit Operating System. Everytime I try I am stuck in ...
0
votes
1answer
30 views

Optimizing large table in mysql

I'm running mysql 5.6 and I am trying to optimize a large table without mysql recreating it. As a dry run I ran the same command (optimize table) on a smaller table in the same DB and mysql insists on ...
0
votes
1answer
20 views

What is the difference between Com_xxx and handler_xxx?

Initially my com_delete variable and handler_xxx variables are nil. | Com_delete | 0 |+ | Handler_delete | 0 | +----------------+-------+ then I issued a delete query delete from gt ...
1
vote
1answer
22 views

Why didn't MySQL keep the innodb_file_format after loading a mysqldump

I was loading a mysql dump today when I ran into ERROR 1118 (42000) at line 279: Row size too large (> 8126) Which I thought was weird because I know I had turned on row compression and was ...
0
votes
2answers
59 views

mysql no longer defaulting to /tmp/mysql.sock

I was testing some software to see if it could connect to mysql correctly when mysql is not using /tmp/mysql.sock. I stopped mysql, editted /etc/my.cnf to add socket=/var/lib/mysql/mysql.sock ...
1
vote
1answer
38 views

How does the alter command work internally when adding a column?

Can anyone explain what the internal operations are that takes place when an alter command is issued? How is column modified? Does it use created_tmp_tables or created_tmp_files? As per my test, I ...
0
votes
1answer
41 views

What is default MySQL binlog retention in AWS RDS?

I tried to retrieve my MySQL RDS binlogs in order to run manual "rollback" for some SQLs. Unfortunately, I noticed that only 2 binlogs for the last 30 minutes are available. "call ...
0
votes
1answer
24 views

How to include a semicolon (“;”) in a MySQL pager command

I've just discovered the pager command in the MySQL command-line client, and I'm having a tonne of fun. This blog post is great: ...
0
votes
0answers
25 views

Not getting satisfactory performance improvement with NDB Cluster

Since last few days, I am trying to improve performance of MySQL NDB Cluster but can't figure out what I am missing/being mistaken in defining/tuning parameters. I have these configurations running ...
1
vote
3answers
79 views

Why query_cache_type is disabled by default start from MySQL 5.6?

We've upgraded to MySQL 5.6 and start seeing the loading of db server increased significantly, and finally found out the query_cache_type is defaulted to off start from 5.6. We enabled it again and ...
0
votes
1answer
19 views

MySQL still seems to be establishing a connection even when access is denied, causing aborted connects and instability

Lately the server's been going a bit haywire and we've spent several weeks chasing down leads to no avail. All we can tell is that when the websites go down (and come back up, and go down, and come ...
3
votes
1answer
130 views

Slower queries after upgrade from mysql-5.5 to mysql-5.6

There is lots written about how MySql 5.6 is faster than MySql 5.5 (e.g. http://dev.mysql.com/tech-resources/articles/mysql-5.6.html) but we upgraded our Amazon RDS instance (using the new upgrade ...
0
votes
0answers
11 views

Can queries containing deterministic user defined functions be cached in mysql query cache?

According to the mysql 5.6 docs: A query also is not cached under these conditions: ... It refers to user-defined functions (UDFs) or stored functions. However, I have seen claims that if ...
0
votes
0answers
61 views

How to set up MySQL 5.6 Master- Slave Replication step by step

I am new to Mysql replication. I want to have 2 MySQL servers, a Master and a Slave, running on two Ubuntu 14.04 Computers. Their IP addresses will be 10.0.0.1 (Master) and 1.0.0.02 (Slave). I need to ...
3
votes
2answers
86 views

SQL Question: Selecting different language versions based on availability

I have the following situation: I have a table that contains entries with language versions (German and English) as part of the key (the other part being a "name" field). However, not always both ...
0
votes
1answer
43 views

Find the last SQL statement executed for a given connection

MySQL running on Windows 7 64 bit. I'm trying to track down a leak of connections, I'm pretty sure the only ASP.NET app using the server is at fault here. We received the "Too many connections" ...
0
votes
0answers
57 views

MySQL Replication thread hangs on flush tables with read lock

I have a MySQL master/slave set up with row-based replication. At times of higher load we've been seeing replication halt and all slave thread activity commands just hang. STOP SLAVE, SHOW SLAVE ...
0
votes
1answer
82 views

Getting an error in MySQL Workbench: Cannot Open Administrator

I'm using local installation of MySQL CE on Windows 7 64-bit. Tried to use Administrator part for the first time. Here's the error I'm getting: I also see the following in the log: <object ...
1
vote
1answer
41 views

Migrating MyISAM tables from 5.5 => 5.6

I was wondering if anyone had any pointers on migrating MyIASM tables from mysql 5.5 to 5.6, specifically using Percona builds, via an rsync? Is this safe? I know we need to do a full ...
0
votes
1answer
45 views

MySQL Server 5.6 only runs when making swapfile

I am new to MySQL server and I have setup a dedicated MySQL server. I am aiming to install MySQL server version 5.6 and since version 5.6 is not available on the Ubuntu repository I have to upgrade it ...
0
votes
0answers
81 views

While Loops Don't Work in MySQL 5.6?

I'm trying to use a while loop in MySQL for the first time, and decided to create a simple example as a test: BEGIN SELECT 0 INTO @n; WHILE @n < 10 DO SELECT @n; SET @n := @n +1; ...
1
vote
1answer
46 views

MySQL update row cell with 0 value with value from closest row that does not have 0 value

I have a list of entries that has a time field where unix timestamp is stored. I recently discovered that some of the entries have that field value 0. I want to run an update that will update those ...
5
votes
1answer
217 views

Why does InnoDB table by default uses the UNIQUE constraint instead of the PRIMARY KEY?

In my MySQL database I have a table with 4 columns, the PRIMRAY KEY, two columns with a FOREIGN KEY CONSTRAINT and one UNIQUE index on all fields except for the PRIMARY KEY. The SHOW CREATE TABLE: ...
0
votes
0answers
28 views

RDS did not restore to a specific point-of-time on my MySQL instance. Why did that happen?

I'm using a MySQL 5.6.13 instance on RDS and accidentally wiped all the data in it (something like 2.5GB). I used the restore to point-in-time feature to recover all the data and it only recovered the ...
0
votes
1answer
31 views

MySQL: How to find MySQL 5.1 (with built-in InnoDB) or MySQL 5.1 (with InnoDB-plugin)?

My DB server has MySQL 5.1.58-community-log and I am planning to upgrade it to MySQL 5.6 with specific purpose of improving my system performance and removing the bottleneck issue. So, I have gone ...
1
vote
2answers
86 views

MySQL 5.5 to 5.6 Upgrade. Will data remain the same?

We are considering to upgrade to MySQL 5.6 this summer. I would like to know if our data will be changed in any way once we perform the upgrade? I've been reading and I found that mysql_upgrade ...
0
votes
1answer
73 views

Why is setting open_files_limit making MySQL slow?

We noticed that adding open_files_limit in /etc/my.cnf is making server slow. Reference : What variable(s) to look to maintain MySQL speed of scanning through all database tables while it starts?
0
votes
2answers
60 views

MySQL: Moving Database from Windows to Linux

I have a Windows based dedicated server have below configuration: Windows edition: Windows Server 2008 R2 Standard Service Pack 1 Processor: Intel(R) Xeon(R) CPU X5460 @3.16GHZ 3.16 GHZ (2 ...
0
votes
1answer
15 views

Force number of entries

My title probably isn't the best, but essentially I have a table that stores a host, vulnerability finding reference, and status. I am trying to query on those, but where I don't have an entry I want ...
2
votes
3answers
245 views

Amazon RDS - and binary log rotation

New to RDS (used to having my own server in my own data center). We are on MySQL 5.6 on RDS. when a slave gets behind in replication lag, the master ceases to rotate out its binary logs. It is, ...
1
vote
0answers
106 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 ...
0
votes
1answer
120 views

What is wrong with this a MySQL 5.6 procedure definition? Use a variable for table name [closed]

Just can't understand why it's throwing this error? Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use ...
0
votes
0answers
43 views

MySQL: Parallel Inserts and Primary key updates feedback

I want to get some feedback on MySQL on these particular subjects: Parallel insertions in a table by X java threads (~10 millions/20 hours) Partitioning on that table per day (partition by range) ...
2
votes
1answer
144 views

Optimize table and query, aggregate by date or date-hour

I have a table storing sensor data (100M rows currently) from stations from different sites. In my case, sites may have many stations. Create table statement is as follows: CREATE TABLE sensor_data ( ...
0
votes
0answers
54 views

Fast-Failover in Mysql

I need experts suggestion on this. I see fast-failover option is available from Mysql 5.6.5 onwards. I have a requirement asking to go for Mysql auto-failover of vip and database within Mysql itself. ...
1
vote
1answer
113 views

Can anyone offer an opinion on handlersocket vs memcached performance in MySQL 5.6

I must say I was a little mis(un)-informed about the MySQL Memcached plugin which offers the same NoSQL like access to InnoDB tables as HandlerSocket, I had only had experience with entirely ...
0
votes
1answer
218 views

Mysql Innodb as Key value store, performance

I read about NoSQL databases using Key value pairs (KVP) tables. So i wanted to find out if KVP tables would be faster than conventional relational tables (with multiple columns) in mysql with innodb ...
1
vote
1answer
959 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
1answer
105 views

New users not working on MySQL 5.6 in Amazon RDS

I'm using the CREATE USER and GRANT commands as mentioned here http://dev.n0ise.net/2012/09/amazon-rds-mysql-add-additional-users-with-limited-previledges/ When I try to connect I get this in MySQL ...
0
votes
1answer
631 views

Master - Master replication Duplicate entry

I've got a Master - Master replication setup and it worked fine for a couple of days but I keep getting: Duplicate entry errors after a few days... My setup is as follow: One server in The ...
1
vote
1answer
366 views

How to get MySQL to iterate a subquery in an aggregate select?

Because the vocabulary describing what I'd like to do can be so disparate, I haven't had any luck figuring out why MySQL 5.6 is doing what it does. Consider the following two simple queries: #1 ...
0
votes
2answers
3k views

Access denied for user 'root'@'localhost' (using password yes)

I was trying to install MySQL 5.6.15 to my computer and got this error: unable to update security settings. access denied for user 'root'@'localhost' (using password yes) I guess current root ...
1
vote
1answer
174 views

Data lost in MySQL InnoDB after crash

I found a 6-days rollback in a MySQL 5.6 community edition server installation. It seems that some logs were lost, and I cannot understand why. 2013-12-22 20:38:54 380 [Note] Plugin 'FEDERATED' is ...
0
votes
0answers
55 views

Inserting and updating on same table

I am currently working on a database that aims to provide information regarding the amount of time people stay in a company's car-park premises. This is done using a table called "tbl_stay" which has ...
3
votes
1answer
3k views

InnoDB: Error: Table “mysql”.“innodb_table_stats” not found after upgrade to mysql 5.6

I upgraded to mysql 5.6 from 5.5, and now my logs are littered with such messages on startup I found a possible solution here, but it does not seem official. ...
0
votes
0answers
39 views

Tips for improving my particular batch processing

I'm working with mail data from the USPS, which contains 10 related tables to make up a single mailing, as well as a single table containing all of the scans that each mail piece may receive. Once per ...
0
votes
0answers
16 views

What is the Impact of Performance_Schema when all instruments and cosumers are enabled?

With latest MySQL version Performance_Schema is enabled by default and you can enable Instruments and Consumers as well to gather all performance related metrics and which is very useful to see ...