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

learn more… | top users | synonyms

0
votes
1answer
26 views

Review the Design of My RDBMS (MySQL 5.6)

I am developing a web application for conducting Phishing Awareness testing (Github Repo). I have been getting tons of feedback on CR.SE to this project. It can be referenced if you want to get a more ...
1
vote
1answer
112 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 ...
-1
votes
1answer
12 views

How can we migrate Data with MySQL 5.1 - MyISAM to another server with MySQL 5.6 - InnoDB

Currently we have a MySQL 5.1 - MyISAM database on a physical server. We need to move it to another server with MySQL 5.6 - InnoDB at another location. DB size is quite large - 210GB Can someone ...
0
votes
1answer
15 views

Mysqldump failing while restoring database - MySQL 5.6

I have dumped one of my databases of size 5-6GB. I'm trying to restore to another instance but the same is getting failed after sometime with the following error: ERROR 2013 (HY000) at line 12006: ...
3
votes
1answer
109 views

Null instead '0000-00-00 00:00:00' in mysql 5.7

Before: mysql 5.6. One of the columns in the table is created as follows: `f_stamp` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' When i view this field in mysql client or using DataGrip, this ...
0
votes
0answers
9 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
1answer
138 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, ...
4
votes
2answers
10k views

How to do While Loops?

How can we use while loops in MySQL? My test script: BEGIN SELECT 0 INTO @n; WHILE @n < 10 DO SELECT @n; SET @n := @n +1; END WHILE; END; But it has syntax errors. I'm ...
2
votes
1answer
238 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
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
1
vote
2answers
2k views

Mysql closing immediately after new installation

I am using mysql as an backend for my webapp ,the software ran without any glitch but today it gave unexpectedly ERROR:2003 i tried many solution on the internet but none worked. so reinstalled the ...
0
votes
2answers
128 views

how to create 'root'@'localhost', after disappearing

for some unknown reason my 'root'@'localhost' account has disappeared from MySQL server. So in order to recreate it, I used my command line and logged in with a user called 'john91'. First, I checked ...
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 ...
1
vote
1answer
27 views

MySQL usage suddenly hitting through the roof

We have a site with MySQL DB running properly for more than 2 years. However, 2 weeks ago we noticed a sudden spike in load. We started the MySQL service and load normalized. We assumed the issue was ...
0
votes
1answer
16 views

MYSQL inner join , if not match try another table

I've got a very quick issue here, how can i join a table with two other tables in a way if one's info doesnt match, it goes try another one. something like: $properties = $mysqli->query("SELECT *...
0
votes
2answers
36 views

Checksum of data imported from mysqldump not equal to the original checksum?

I'm tring to create a mysql replication instance. So I mysqldump --complete-insert --skip-dump-date -uuser -ppass db table > master.sql. Also I've imported the master.sql to the slave instance ...
1
vote
1answer
40 views

Mysql became unresponsive

All of the sudden mysql became unresponsive we are not sure of the reason, when we check mysql error log we find following, but for us it is hard to interpret it, can anybody help to understand it and ...
0
votes
1answer
1k 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
vote
1answer
26 views

Getting Error : [Err] 1615 - Prepared statement needs to be re-prepared with MySQL 5.6.30

Problem/Issue : Getting Error : [Err] 1615 - Prepared statement needs to be re-prepared I have a Stored Procedure which contains a Prepared Statement and a view DROP PROCEDURE IF EXISTS `sampleProc`...
1
vote
1answer
19 views

MySQL 5.6 InnoDB doesn't work

We have been having issues with one of our Windows environments. It uses MySQL and has been running on MyISAM only. We need to create a few InnoDB tables but the engine won't start. We tried changing ...
1
vote
5answers
434 views

Replication in same server within different databases. Mysql 5.6

What I have : a windows machine with one instance of MySQL 5.6 Server. two database named test and test2. Test database has a table called activity with columns id and class What I need : ...
2
votes
1answer
216 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, ...
0
votes
1answer
139 views

MySQL user privileges lost on reboot

On occasion our MySQL 5.6 server loses some user privileges when restarted. The CREATE USER and GRANT commands are run through phpMyAdmin and function for as long as the server is running. After a ...
0
votes
1answer
18 views

MySQL - Upgrading from 5.5 to 5.6

I have MySQL community version 5.5.50 running in linux having 4-5 databases on it. Requirement is to upgrade to Percona Server 5.6.31-77.0. What are the pre-requisites that I need to check before ...
0
votes
1answer
21 views

Moving log files & data in MySQL

Is it possible to separate out data files and log files of MySQL from one drive to another? For eg: Data (actual database data and system tablespace ibdata) in one partition, say /data and log files ...
0
votes
1answer
190 views

Subquery on timestampdiff only allows for 1 result, how do I scale this for all results?

I'm currently writing up a query which is meant to output data to show curves of power profiles, and I'm facing a slight problem. So far, I've managed to do this: select datetime, PLANT_STATUS, ...
0
votes
1answer
153 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
1answer
307 views

How to suppress specific warnings in mysql error log when ignoring a table to replicate

Is there a way to make the mysql error log less chatty with certain warnings? I just threw in the replicate-ignore-table option in my.cnf so our health check table doesn't get replicated. However now ...
1
vote
1answer
46 views

Performance of BINARY vs CAST AS BINARY in MySQL

Using MySQL 5.6.23, I recently changed a prepared statement from: SELECT * FROM table WHERE BINARY column = :boundValue to: SELECT * FROM TABLE WHERE CAST(column AS BINARY) = :boundValue ...
1
vote
1answer
1k 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
1answer
113 views

MySQL - Force replication to statement for INSERT to a table to fire trigger on slave

We have a PROD DB which replicates into a slave DB using mixed replication. We want to add a trigger so that a row is added to our DW when a row is INSERTed into table_a (on master). The issue is that ...
0
votes
1answer
24 views

Doubts on Setting up Master-Master replication (Percona)

I have two 5.6 Percona servers in which I'm planning to setup Active master- Passive master replication. Secondary master will be in read-only mode. Caveat is that the servers in which i'm going to ...
5
votes
2answers
56 views

enable query log for single database

I am having many database schema in mysql 5.6 server, now the problem over here is that I want to catch the queries for one schema only. I can not enable query log for entire server as one of my ...
1
vote
1answer
26 views

Syinc databases mySQL to Oracle

I'm new in "databaase administration" the problem I am facing is that I want to have an exact copy of a table, from MySQL database (website database) to oracle database (a local one). What I've done ...
1
vote
2answers
3k views

add column without metadata lock in mysql 5.6

I am using MySQL Server version: 5.6.15 Homebrew. I need to add new null column. alter table requires no metadata lock. In order to avoid this MySQL 5.6 introduced algorithm=inplace. Here is the ...
0
votes
1answer
162 views

How to Upgrade Master Slave MySQL on AWS RDS?

I already have Master Slave configuration on AWS RDS. We want to upgrade 5.5 to 5.6.23. ..What should be correct sequence to Upgrade ? 1. Upgrade Master ( Using Modify Instance ) --> Upgrade Slave 2. ...
0
votes
1answer
316 views

Table partition in aws MYSQL RDS master slave setup

we are looking to do a table partition in MYSQL RDS running 5.6, table size is large and takes around 6 hours to partition. Can we partition on rds slave and then later promote it to master. is this ...
0
votes
1answer
179 views

how to Use old mysql database after reinstall mysql in RHEL 6?

I was getting problem in starting and login mysql server so I backuped /var/lib/mysql folder and reinstalled mysql server. Now I want to use old database files like: ibdata1 and database folder /var/...
0
votes
1answer
43 views

MySQL - Persistent values in my.cnf

I have a small doubt regarding making variables persistent in Percona Server 5.6 in Linux. I need to make log-bin-trust-function-creators persistent so that I need not make it to true everytime on ...
0
votes
1answer
118 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
12 views

help me to migrate single myslq5.6 server to mysql5.6 Cluster, follow this error! [closed]

I try to migrate a single myslq5.6 server to mysql5.6 Cluster. I do not understand why I get the follow this error: ERROR 1297 (HY000) at line 1 in file: 'load_dept_emp.dump': Got temporary error ...
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 ...
1
vote
1answer
52 views

MySQL Load Balancing what do i need Replication or Cluster?

So My MySQL database server is reaching it's limits with the number of queries selects, updates, inserts etc it can concurrently take resulting in high CPU usage more than what a single machine can ...
7
votes
2answers
96 views

MySQL Innodb_row_lock_current_waits is 2^64 - 1

I have a MySQL 5.6 server which we monitor using Nagios. Over the weekend, it's started complaining about the Innodb_row_lock_current_waits, which currently has a value of 18446744073709551615, yes, ...
1
vote
1answer
57 views

MySQL – BLObs Hitting Performance

One of my tables contains seven BLObs. Six of these refer to raw data and are typically 1.0 – 1.5Mb each. The seventh is the result of processing this data and can be nearly equal in size to the sum ...
1
vote
1answer
35 views

Mysql will no longer start after DB import and password change

I'm running Mysql5.6 on RHEL 7. I had managed to get the mysql service up and running, and imported a database into it with no issues. However, after attempting to reset a user's password, the ...
0
votes
2answers
55 views

how to deal with mysql 500 million data per month?

this is a interview question a telecom billing system, there is a internet flow table (phone_number,start_time,stop_time,time_lasting,fare),500 million records per month(2G),every record size is 300K,...
0
votes
1answer
143 views

MySQL CONVERT_TZ returns null

MySQL CONVERT_TZ returns null, if timezone value is in plus. example: select CONVERT_TZ(now(),SUBSTRING(timediff(now(),convert_tz(now(),@@session.time_zone,'+00:00')),1,5),'+00:00'); it returns ...
8
votes
1answer
792 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: ...
2
votes
1answer
226 views

Mysql high cpu usage - cpanel

After an update from whm, I see a high CPU usage from MySQL (5.6). my.cfg: [mysqld] slow_query_log=1 slow_query_log_file="/var/lib/mysql/slow-query.log" long_query_time=1 skip_name_resolve ...