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

learn more… | top users | synonyms

1
vote
1answer
8 views

MySQL 5.6 upgrade - reducing code changes / developer burden

Does anyone know the key things that should be done when moving to MySQL 5.6 to reduce the amount of code changes required? I found that new installations of it have STRICT_TRANS_TABLES set for ...
0
votes
1answer
12 views

MySQL Install on Windows 8.1 hangs at server restart

I have a 64-bit Windows 8.1 machine and would like to install a local database to host some helper application databases. I have attempted this several times with this version of MySQL (5.6.25 GA) but ...
0
votes
1answer
16 views

Not all MySQL processes are killed when restarting

We have a MySQL 5.6 server running on Ubuntu 12.04 using the MySQL 5.6 PPA. The service comes up fine when rebooting the box, but whenever we restart the MySQL process via /etc/init.d/mysql restart, ...
0
votes
0answers
10 views

Percona Toolkit pt-archiver doesn't work with --bulk-insert option

I'm running pt-archiver like this: pt-archiver --source ... --dest .. --where "last_updated BETWEEN '2015-01-26 00:00:00' AND '2015-02-01 23:59:59'" --ignore --no-check-columns --no-ascend ...
0
votes
1answer
19 views

MySQL max_connctions+1

I experienced an incident that my connections are full. Even I as an administrator I cannot log to MySQL due to "too many connections.". Does anybody knows how to setup this max_connections+1? I use ...
0
votes
1answer
17 views

Ubuntu broken need to recover mysql db

With a recent Ubuntu upgrade it has broken my system. I now only have access to the filesystem through a live CD. I had a MySQL database on the system with many objects and views I would hate to lose. ...
0
votes
2answers
23 views

MySQL slow query log file time elapse

Does anybody know when the mysql slow log file delete slow query records? based on my daily observation. The log file starts at 7am. I have searched for this but nothing answers me clearly. My server ...
0
votes
0answers
9 views

The same timestamp in different MySQL versions

I read in mysql 5.6 SQL changes following text: TIMESTAMP columns not explicitly declared with the NULL attribute are assigned the NOT NULL attribute. (Columns of other data types, if not ...
0
votes
0answers
6 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 ...
0
votes
0answers
11 views

Amazon rds read-replica, use as archive database

I have hosted my database (MySql) on Amazon RDS service and also created read-replica in the same availability zone. I have send my read queries on that read-replica. Now a days my database is become ...
0
votes
1answer
38 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
2answers
56 views

User, host, and privileges

In a MySQL 5.6 database I found one user 'foo'@'10.0.0.2' with ALL PRIVILEGES. I also discovered an user 'foo'@'10.0.0.3' granted only USAGE privileges. Does this second user definition make sense? ...
0
votes
0answers
16 views

Does MySQL Backup Restore affect Master-Master Replication

Hello I got some problems with a MySQL shemas and it seems that the schemas got deleted for an unknown reason. I try to find in the binlog for more information of this but I didn't find the way to see ...
0
votes
0answers
9 views

Using java functions in mysql

Can we use JAVA user defined functions in mysql5.6? I am stuck with data which is encrypted using java code and need to query the data on particular criterias but the data is encrypted. Please ...
1
vote
2answers
37 views

MySQL 5.6 Slave Stops Processing Binlog on Master Restart

I have a pair of Debian 7 servers with MySQL 5.6.23. The slave server is a clone of the master (but the uuid has been regenerated on the slave). For some reason, whenever MySQL is restarted on the ...
0
votes
1answer
60 views

Can't Delete Orphaned MySQL Temp Table

One of my servers had a hick-up yesterday and decided to leave temporary table while (while running alter table add indexes). ls -l sql -rw-rw---- 1 mysql mysql 8570 Mar 13 12:05 #sql-ib32694.frm ...
0
votes
2answers
36 views

mysql does not start: error 13 on bin file (permissions are set correctly)

I just renamed the hostname and rebooted the server and now mysql 5.6 wont start. (debian 7 + dotdeb) 150312 20:40:15 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql.mnt ...
0
votes
0answers
25 views

adding rules to MySQL user to have prefix when they created database

I am working on a project that combine multiple MySQL ports under the same port; each port has a shared databases with names (database name and tables), so I though of the following idea. if I created ...
1
vote
1answer
36 views

'accidentally' set 'CHANGE MASTER TO' on wrong server

while setting up the replication I accidentally did the 'CHANGE MASTER TO' on the master server instead the slave. When I noticed the mistake I just did a 'STOP SLAVE' on the master and setup the ...
1
vote
1answer
39 views

MySQL Master not sending events to another Master

We have Master-Master Replication and it is configured correctly as it transmit data for certain period of time and after that it does not send further events till we stop/start slave on both nodes. ...
0
votes
0answers
23 views

How to find Deleted and Updated record tables in MYSQL database?

I have scenario like below. I need to find Deleted records and updated records effected tables in mysql. Ex: I update my Name or Email Id in UI that is effected in some tables either one table or ...
0
votes
1answer
93 views

Large MySQL operations slowing down SELECT queries on unrelated tables

On a fairly busy SQL server, we sometimes need to do large index-building operations (after importing ~6GB tables). The indexes are built using the more efficient "Repair by sorting" method, rather ...
0
votes
0answers
14 views

mysqlfailover utility not ablt to connect

mysqlfailover tool not able to connect to myserver: mysqlfailover --master=test@localhost --discover-slaves-login=root --candidates=root@192.168.2.8:3306 WARNING: Using a password on the command line ...
0
votes
0answers
9 views

tune MySQL with results from mysqltuner? [duplicate]

So someone recommended a few suggestion and I don't think it did me any good since I am now using almost 100% of my swap (that's never good). [OK] Logged in using credentials from debian maintenance ...
0
votes
1answer
143 views

Deadlock caused by INSERT trigger - thread looking for lock it already has?

Using MySQL 5.6.17. I have a table with an INSERT trigger that reads values from that table and 4 other tables, combines the results and writes that to a sixth table. Ever since I added this trigger, ...
-1
votes
2answers
57 views

Mysql query not working

CREATE DATABASE `menu`; USE menu; DROP TABLE IF EXISTS `fish`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `fish` ( `ID` int(11) NOT NULL ...
0
votes
1answer
357 views

unable to insert utf8mb4 characters in mysql 5.6

recently i was facing problem in inserting emoji and other 4 bytes character in my mysql database then i found that my mysql version was 5.1 and it does not support utf8mb4 so i upgraded to mysql 5.6 ...
0
votes
1answer
96 views

DELIMITER issue in MySQL 5.6

Drop procedure if EXISTS rotatepjp; DELIMITER // CREATE PROCEDURE rotatepjp() BEGIN DECLARE u_id, settingval, pjp_userid, pjp_beatid, u_frequency INT; DECLARE u_pjpstartdate, pjp_fordate, ...
0
votes
1answer
85 views

mysql multiple column index Cardinality order

How does Multiple-Column Indexes work in MySQL? How is it stored internally? consider a table with Multiple-Column Indexes on two columns (X,Y). If X has High-cardinality than Y i.e., X is less ...
1
vote
1answer
44 views

MySQL replication slave of slave not receiving updates

I have 4 servers: A, B, C and D. A and B are in a master-master setup. C is a slave to B and D is a slave to C. Changes on A or B get to all nodes other than D. I need them to get to D Changes ...
0
votes
0answers
29 views

MySQL JDBC Driver puts transaction in read only. Why?

Using the MySQL JDBC connector with a MySQL 5.6.22 data source defaults the transaction mode to read only. Anyone know why?
0
votes
0answers
18 views

Set variable if variable didn't initialized

I'm creating alternate of uuid_short() function named custom_uuid_short. DELIMITER $$ CREATE DEFINER=`root`@`localhost` FUNCTION `custom_short_uuid`() RETURNS bigint(20) unsigned BEGIN declare ...
0
votes
0answers
15 views

MySQL Socket exclusively

I've disabled TCP by using skip-networking in my /etc/my.cnf file I've deleted all users (mysql.user) that have other Host than localhost Now I went through the other tables in the mysql database ...
0
votes
0answers
46 views

MySQL Socket connections and SSL

I'm currently running over some final tweaks and security measures for my MySQL server deployments. Mainly I'm running Google's Golang and connect to the MySQL database through a Socket connection. ...
1
vote
1answer
31 views

Differences between Authentication Types in MySQL Users and Privileges

I noticed that when I create a new account, that there are three different Authentication Typesavailable to choose from in MySQL Users and Privilegeswindow. What I am wondering is: What is the ...
0
votes
1answer
416 views

Best way to create materialized view in mysql

I am using mysql 5.6, I am not being able to create materialized view here like oracle. I got one or two solution like flexview and all... Can anybody tell me best way to create materialized view in ...
2
votes
3answers
190 views

How can I make MySQL client read password from mylogin.cnf?

I'm trying to make the mysql client connect to a mysql server without requiring the password to be given interactively. Steps taken: 1) First create a mylogin.cnf file $ mysql_config_editor set ...
0
votes
1answer
75 views

MySQL 5.6 Datetime Range

According to MySQL 5.6 doc, the supported range for datetime data type is '1000-01-01 00:00:00' to '9999-12-31 23:59:59'. But when I tried inserting values that are earlier than '1000-01-01 00:00:00', ...
1
vote
1answer
97 views

'DROP TABLE mysql.failover_console;' replicates to slaves, but 'Use mysql; DROP TABLE failover_console;' does not

I am currently looking to setup automatic failover for my MySQL 5.6.21 Master on CentOS 6.6. I have mysqlfailover set up in my lab, and it is working well enough. My question is not about that, but ...
0
votes
2answers
72 views

Aggregating sum day by day from multiple joins returns unexpected results

I'm trying to make a table where the task hours and group hours are aggregated day by day. I'm able to get the wanted result for both tasks and groups, but when I try to get them in the same query, I ...
0
votes
0answers
54 views

mysqldbcompare showing AUTO_INCREMENT differences but there are no missing records

I am encountering a strange issue when using mysqldbcompare to compare two MySQL DBs(one is a master, the other its slave). I noticed that the tool notes that the AUTO_INCREMENT values of this ...
0
votes
1answer
281 views

Blob datatype issue with log file

I am getting continuously below error message in mysqld.log [ERROR] InnoDB: The total blob data length (10152274) is greater than 10% of the redo log file size (3072). Please increase ...
0
votes
0answers
167 views

MySQL won't start - e44 InnoDB: Assertion failure in thread 3652 in file fil0fil.cc line 5594

MySQL 5.6 is installed on my Windows 2008 server. The service is refusing to start. The error log reported: 2014-12-02 20:27:16 1664 [Note] Plugin 'FEDERATED' is disabled. 2014-12-02 20:27:16 634 ...
0
votes
0answers
53 views

Mysql Multi master replication - auto_increment for tables with natural primary key?

I am thinking about using Master-Master replication using Mysql 5.6.19 with InnoDB as the engine. From what I have been reading, looks like I should be using auto_increment_offset and ...
0
votes
1answer
65 views

ALTER TABLE blocking in MySQL 5.6

I have a question with a MySQL 5.6 master-slave setup. If I were to modify the master's schema with an ALTER TABLE SQL query, then when the slave tries to execute that ALTER TABLE statement too, would ...
0
votes
1answer
55 views

Question on turning on GTID for MySQL master and slaves

I came across the interesting article by Facebook's Engineering team where they were able to deploy GTID in MySQL at a large scale : ...
0
votes
0answers
21 views

Sudden (and drastic) decrease in commands/second on replicated slave

On a slave that uses statement-based replication from a failover of master (all running mysql 5.6), the number of queries executed per minute has suddenly decreased from ~20k during peak traffic to ...
0
votes
1answer
250 views

Mysql Server 5.6 Mysqld high memory consumption

I have MySQL Server 5.6 installed in a development machine with these specs: RAM: 4 GB Windows 7 Professional 64 bits Intel Pentium CPU G630 @ 2.70 GHZ Since I installed the MySQL Server, the ...
1
vote
3answers
145 views

Question on having a MySQL 5.1 replicate from a MySQL 5.6 DB

I have a question in regards of what potential issues that might happen with a MySQL 5.1 DB that replicates from a MySQL 5.6 DB. I know the risks involved based on resources such as ...
0
votes
1answer
32 views

How do I add databases from a crashed MySQL 5.1 server to a new MySQL 5.6 server

I was running MySQL 5.1 on a personal web server that recently died. The system drive is non-operational, but I have my second hard disk where I had installed all of my programs. This drive has my ...