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
19 views

MySQL Index Creation Internals

Right now there are two ways to build an index of a table in MySQL: Create the table structure first, then import the data and add indexes later. Create the table structure with indexes and then ...
1
vote
1answer
23 views

How to get row count from all tables of a schema ( without using information schema )

The query should collect data from table name , schema name from information.schema and row count should be taken from actual table.
0
votes
0answers
18 views

insert/update query running slow to specifi tables

I am monitoring MySQL client connections and queries run time. Found some insert/update queries to specific tables are slow than expected. I know the tables which are slow are big in size > 600K, i ...
1
vote
1answer
27 views

MySQL 5.6 Slaves Fail to Reconnect to older MySQL server when it goes down for backups

I have an existing replication setup with Masters and Slaves running MySQL 5.0. A long existing script runs at night which restarts MySQL on the master with skip-networking, runs a backup, and then ...
0
votes
0answers
14 views

mysql sharding techniques

I have developed one website for social network and I have used mysql for data storage. Now a days, many tables become a very huge (2-3 tables has 30 million records & 3-4 table has 300k records) ...
1
vote
1answer
21 views

Services don't have MySQL Server. How to run it?

I need to run MySQL Server on a new for me laptop. There's Windows 7. And MySQL have been installed on it. In order to verify this, I opened the Programs and Features window and saw it there: ...
0
votes
1answer
14 views

Change MySQL default installation directory in OS X

I install mysql in default installation directory /usr/local/mysql Is it possible to change mysql installation directory to another path? I am running OS X 10.10 & MySQL 5.6
0
votes
1answer
35 views

Unknown sticky Problem after MySQL upgrade

few weeks ago we upgraded mysql server from 5.5 to 5.6 on 1st server few days ago (5May) I reboot mysql server , after this customer reported that some database data table not load to their site . ...
0
votes
0answers
8 views

How to backup huge Mysql db containing both InnoDB & MyISAM tables in Aws RDS?

I am running a Mysql RDS with 150GB+ data. The DB size is growing very fast(But normal considering the application's nature) Till now we were having only InnoDB storage engine, so we were using the ...
0
votes
0answers
22 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 ...
0
votes
1answer
37 views

ndbcluster: Error: 1114, The table is full, when using table

I have searched for a while about this error. I have a MySQL cluster running with 2 data nodes. The cluster houses a few other databases. I have a dump of a database in --tab format from another ...
0
votes
1answer
58 views

mysql Lock wait timeout exceeded; try restarting transaction

we are running java application, running for ages, back end is db is MySQL, recently updated to mysql 5.6. Everything was running fine, past week started getting this error Lock wait timeout ...
0
votes
0answers
37 views

error 1067 process terminated unexpectedly

I am facing the following error while creating the Mysql instance from command line in Windows server 2012. Steps i follwed for creating a new Mysql Instance as a window service: I have stopped the ...
0
votes
1answer
35 views

Display the choices even if no rows found in associated table

I have the following 3 tables for a small voting/polling feature: CREATE TABLE IF NOT EXISTS `options` ( `option_id` tinyint(4) unsigned NOT NULL, `poll_id` mediumint(8) unsigned NOT NULL, ...
0
votes
3answers
79 views

Adding order by to a query is slowing down the query even after Indexing

While joining columns with huge data even after indexing the column order by is slowing down the query. Without order by query is executing within 2 secs. But with order by query is taking 145 secs. ...
1
vote
2answers
27 views

How to define partition according to Date?

I am currently using MySQL 5.6. In my database, I have a log table called paramlog_ems. It has 2M rows I want like to partition this log table according to Date. Here is the table structure: ...
0
votes
0answers
29 views

ERROR 1644 (HY000) at line 1852: Unexpected content found in the performance_schema database

I was upgrading MySQL from 5.1 to MySQL 5.6 on a Linux server installed with RHEL6. I already have 5.1 installed and running with about 300GB of database data, so I want to do a in-place upgrade to ...
2
votes
1answer
20 views

How do I change the config path for mysqld?

I want to change configuration file path from C:\ to E:\, but I can't find the way to do this. Alternatively, is there a way to start a new instance with the config file I want? I've done something ...
0
votes
0answers
57 views

Best way to restore 400GB+ worth of data in MySQL 5.6

So I'm trying to figure what the best/quickest way would be to refresh a massive amount of data. We're wanting to copy 3 months worth of data from a replication server to a QA server for product ...
2
votes
2answers
52 views

What are some known hazards with cyclical replication between two MySQL master servers?

If I were to set up cyclical replication between a MySQL 5.6 master server and a MySQL 5.1 master server, what are some things that could potentially go wrong? Also, the 5.6 MySQL does not have GTID ...
2
votes
3answers
64 views

Query 'optimizing' state is taking too long

I have a MySQL 5.6 on Amazon RDS that I'm using for testing some data archiving scripts. I'm removing oldest data based on a "updated_date" column and index. Curiously, after removing a few million ...
0
votes
0answers
26 views

manual data migration/rescue MySQL version: 5.6.23

MySQL died and could not be started. So I transferred my database files via rsync to another server and restore from back up. Now I am trying to access my data with my updated records. mysql> use ...
1
vote
1answer
33 views

percona cluster 5.6 - handshake with remote endpoint failed, but endpoint is not part of config

I set up a cluster of 3 database nodes using a percona 5.6 cluster. Everything works, all nodes are replicated. I configured SSL for state transfer. The cluster recently changed its topography, ...
1
vote
1answer
24 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
58 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
21 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
14 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
20 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
23 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
29 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
10 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 ...
1
vote
0answers
14 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
24 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
56 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
63 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
18 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
14 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
49 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
92 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
84 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
30 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
45 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
26 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
133 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
18 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
262 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, ...
0
votes
2answers
88 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
2answers
564 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 ...