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

learn more… | top users | synonyms

0
votes
0answers
19 views

MySQL 5.6.18 got signal 11

My MySQL Server 5.6.18 got signal 11 today very randomly. Has not happened before. This is the stack trace : stack_bottom = 7fdb9bcb1e0f thread_stack 0x40000 ...
0
votes
0answers
14 views

MySQL Delayed Replication - Reading events

Given MySQL is setup for master-slave replication, when delayed replication is set on the slave, does the slave still read the binlog while it is waiting for the delay period to pass? From MySQL ...
0
votes
1answer
47 views

MySQL optimizer difference between 5.6.27 and 5.5

We've just updated the MySQL version of the database of one of our clients from the 5.5 to the 5.6, everything is working fine except one simple query which is causing us troubles. Having the ...
0
votes
0answers
31 views

cannot install_db after deleting /var/db/mysql

I am trying to reset mysql5.6-server back to its installation defaults and blowout/nuke all the databases to start off fresh and clean. [root@yoda:~] # rm -fr /var/db/mysql [root@yoda:~] # mkdir ...
0
votes
0answers
39 views

ndb_restore issue

I'm facing following issue while trying to restore backup in mysql cluster. It will be great help for me if some body can share idea on these Backup Id = 2 Nodeid = 4 backup path = ./ Opening file ...
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
31 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
27 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
1answer
64 views

Store Mysql Index in separate .Ibd file?

Is there any option to store table index in separate .ibd file? something like file_per_table mode? Becuase my table is growing more than 200gb. Table .ibd file have index for that table also. so If ...
1
vote
2answers
55 views

cannot login to MySQL remotely

users and root can log in locally with no problems. No user can login from a remote connection though from remote: [root@yoda:~] # mysql -v --host=r2d2.er.com --user=power --password='burp' power ...
1
vote
0answers
21 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
1answer
40 views

how could select more than 14 column

Not able to select morethan 14 columns in the list please find the link for reference, http://sqlfiddle.com/#!9/bb7a66/3 CREATE TABLE tbl_staff_details (`name` varchar(45), `FK_int_emp_id` int, ...
0
votes
1answer
206 views

Got fatal error 1236 Slave has more GTIDs than the master has, using the master's SERVER_UUID

We are testing replication using GTID's on two servers running MySQL 5.6. Replication was running fine, but now it is not functioning. When I run show slave status\G on the slave, I get the following ...
2
votes
1answer
177 views

Mysql Server 5.6 high memory consumption

I have a problem with my mySQL server. It consumes 9.7 GB ram. I have only a very limited amount of data on it (13 mb) I have been searching the internet and seval places a solution like this one ...
3
votes
2answers
49 views

How to handle temporal datatype columns when doing upgrade from 5.5 to 5.6

I want to upgrade my MySQL 5.5.40 server to 5.6.28. But as per the documentation we need to alter the tables having columns which are using date or datetime or timestamp data types as storage ...
0
votes
1answer
64 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 ...
2
votes
1answer
33 views

Mysql RDS migration problem

I'm trying to migrate my MySQL RDS to a different machine. The reason is that I need smaller disk, and you can't make disks smaller for RDS servers, only bigger. I'm trying to migrate with this ...
1
vote
2answers
51 views

With MySQL 5.6, Is there any way to keep a replication slave X seconds behind_the_master?

It'd be really nice for disaster recovery to be able to set this up. We are doing snapshots, but this seems like it'd be a really nice backup to have. For example, I'd like to always keep a ...
0
votes
0answers
2k 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 ...
0
votes
1answer
38 views

Point in time restore MySQL

I want to perform a point in time restore on MySQL. I want to change log_bin value and ensure that log files are created. I am following this article and am working on a Windows platform. Log ...
2
votes
1answer
227 views

Convert MySQL database from latin1 to utf8mb4 - and take care of German umlauts

I am using 5.6.28 MySQL Community Server to host WordPress + ProPhoto blog in German language at CentOS 6.7 Linux server: mysql> show tables; +-----------------------+ | Tables_in_blog | ...
3
votes
2answers
71 views

MySQL for Oracle DBA

I am a newbie to MySQL, but understand Oracle databases well. I need a quick help to understand the architectural differences. Currently I am working on a Windows platform. 1) In Oracle we have to ...
1
vote
0answers
35 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 ...
0
votes
2answers
61 views

MySQL Change in execution plan after upgrade

We upgraded the MySQL 5.0 to MySQL 5.6 last week. After the upgrade most of the DMLs are very slow. Especially the inserts and updates using JOINs. There is a difference in execution plan of these ...
1
vote
3answers
114 views

why in explain in mysql row count is very high

i am using mysql, here is query- mysql> select count(*) from payments as Payment WHERE `Payment`.`fordate` BETWEEN '2015-11-28 00:00:00' AND '2015-12-31 23:59:59'; +----------+ | count(*) | ...
1
vote
1answer
141 views

How to set slow query log in MariaDB my.cnf?

It should be easy, but when I put these lines: log_slow_queries = 1 long_query_time = 1 log-slow-queries = /var/log/mysql/slow_query.log log_queries_not_using_indexes in [mysqld], MariaDB fails to ...
0
votes
0answers
102 views

“mysqld got signal 11” error

I have a MySQL 5.6.22 InnoDB database and just now, suddenly out of nowhere, when I try to start it up using /etc/init.d/mysqld start, I see this error in the error log and the server won't start up : ...
1
vote
1answer
32 views

Can I use table aliases in a MySQL DELETE statement?

This does not work: DELETE FROM topics AS t , posts AS p USING t INNER JOIN p WHERE t.id=p.topic_id AND t.id = '5599'; whereas this does: DELETE FROM topics, posts USING topics INNER JOIN posts ...
3
votes
1answer
37 views

Data truncated for column - return fatal error

I get this error in my error log. Warning: 1265 Data truncated for column ... How to configure mysql to return a fatal error on this kind of warnings? Mysql 5.6.27 cnf sql_mode ...
2
votes
1answer
36 views

Changing system time on MySQL server

I've discovered that my MySQL server is 10 minutes behind the current time because NTP was not running for some reason. It is a single node and running MySQL version 5.6.15-56. I know that ...
2
votes
1answer
42 views

Is DETERMINISTIC NO SQL function which returns the same value always a good alternative for using as a constant in MySQL?

MySQL does not support declaring constants which can be used between many stored procedures. For me, it seems that a deterministic no sql function can be used as an alternative for a constant. ...
1
vote
1answer
31 views

mysql logical ranking based on score

I have a table like this that keeps a total score of a history exam for students. +----+---------------+-------+---------+- | id | name | history | rank | ...
0
votes
1answer
91 views

How to optimize MySQL SUM query even after adding index

The below query is taking 11 min to return the result set even after adding indexes and changing the table row format to Compressed. The 2 tables in the below query each have Table ...
0
votes
1answer
82 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
42 views

How move MySql table to another disk?

According to this it is impossible to use alter table for moving tables. So if I understand correctlly - to move table it is neccessary to do: Create new table Copy all row from old one drop old ...
0
votes
0answers
61 views

Why MySQL is still “using temporary” when update by primary key?

I have a partitioned mysql table, table size is about 100M rows: CREATE TABLE `nearby` ( `id` int(10) unsigned NOT NULL, `nearby_1` varchar(750) NOT NULL DEFAULT '', `nearby_2` varchar(750) NOT NULL ...
0
votes
2answers
37 views

MySQL show all grants

I have over 100 system and admin users in my db server. Does anyone know how to show their grants by running a single query? Thank you very much.
0
votes
0answers
22 views

Semi synchronous Replication passes no data

My master is running MySql 5.6.19, one slave is 5.6.27 and the other is 5.6.21. Everything seems to indicate that replication is running properly, but data on the slaves is not updated. My status ...
0
votes
1answer
153 views

Syntax error with concat in trigger near signal statement

Please help me with syntax for MySQL 5.6. For some reason I get the error: ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version ...
1
vote
1answer
134 views

MySQL 5.6 - Creating an event inside a stored procedure

I am trying to create a procedure which create an event in MySQL. For example, something similar to this: delimiter // CREATE PROCEDURE schedule_my_db_job() BEGIN CREATE EVENT MY_DB_JOB ...
0
votes
1answer
77 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
60 views

MySQL lower_case_table_names - Tables vs Views

I've set lower_case_table_names=2 in my.ini. When I create tables, the case is respected. However, when creating views, everything is changed to lower case. Also, when I generate my scripts using ...
0
votes
0answers
44 views

Can i install mysqlbinlog 3.4 standalone?

I'm running several Linux servers (RHEL & Debian families) with Mysql 5.5 which ships with mysqlbinlog 3.3. I'd like to utilize the new --raw and --stop-never features of mysqlbinlog 3.4 without ...
1
vote
2answers
121 views

wordpress site kills mysql

I move client wordpress sites from one VPS to another, it all went smooth until I moved a site that kills mysql (and, consequently, all other wp sites). It used to work fine on the previous VPS. ...
0
votes
1answer
22 views

MySQL Replication Query

Imagine I have three servers. x.x.x.31 - master x.x.x.32 - slave x.x.x.33 - slave If I run a simple update in master. What does the slave servers done. run the update command or copy the updated data ...
0
votes
1answer
46 views

Very slow query, not sure if MySQL index is being used

I have a query which includes a join and I have an index on the tables: SELECT e.entry, e.user_id from entries e left join users u on e.user_id=u.user_id where e.tenant_id=? AND u.active=1 AND ...
1
vote
1answer
77 views

Slow MySQL searching from millions record

My table looks like this. id | hash | date I've an index on hash which is in binary mode. I have about 3 million rows right now. But if I query with the following query, it takes about 4 seconds. ...
2
votes
2answers
92 views

Query with WHERE NOT and NOT IN with subquery

MySQL Version: 5.6.27 I am using the following two tables TABLE: oc_product product_id int(11) model varchar(64) tax_class_id int(11) and TABLE: oc_product_to_category ...
0
votes
1answer
21 views

Problem With Loading txt File in mySql 5.6 Command Line Client

I have run this to enable local infile: SHOW GLOBAL VARIABLES LIKE 'local_infile'; SET GLOBAL local_infile = 'ON'; SHOW GLOBAL VARIABLES LIKE 'local_infile'; And indeed after that the local infile ...
1
vote
1answer
43 views

Not able to connect to local MySql database “only” when connected to VPN on VM [closed]

Setup: MySql installed on my Mac using Xammp VM installed using VMware Fusion running win XP. I am able to connect to the mysql database through my VM normally. As soon as I connect to a VPN it ...