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

learn more… | top users | synonyms

0
votes
0answers
6 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
0answers
5 views

Dropping a corrupt table in innodb_force_recovery 6

As often happens in mysterious shutdowns during large queries, things ran afowl with InnoDB on my XAMPP MySQL installation (Windows 7 x64). I rebooted and ran Startup Repair, then loaded MySQL to ...
0
votes
0answers
11 views

Multi Source replication on single slave having multiple instances MySQL

i had 1 instance of mysql 5.6 on one server A (Slave S) 1 Mysql installed on server B ( Master M1) 1 MySql installed on server C ( Master M2 ) At Slave end : I have created one more instance by ...
0
votes
1answer
11 views

For multiple mysql instance , fresh download required when one exist?

i need multiple instances of Mysql on same server. I had been through many links , but i confused here : What i have : MySQL 5.6 is already installed on my windows server A. Installed at : ...
3
votes
0answers
39 views

How can I copy the MySQL EXPLAIN result into a table?

I'd like to archive the results of a series of query EXPLAIN plans into a table for later analysis. I created a table that contains all the fields from an EXPLAIN result, but I can't figure out how ...
0
votes
2answers
15 views

How to check innodb history list length?

The output for show engine innodb status has the history list length as a number, but that output is hard to parse, and there's just too much data when all you want is a single value. Is the value ...
3
votes
1answer
97 views
+50

MySQL loading NULLs in numeric columns

MySQL 5.6.23, InnoDB I am loading tables from character delimited text files using the LOAD DATA INFILE commnd and I would like every field with a \N, which is the NULL character in this setting, to ...
1
vote
1answer
54 views

How to select second last row from table?

Table Name :- ModelParam_EMS Primary Key :- ParameterID No of Rows :- 500 want to select 499th row from table only. Note :- No. of rows can be less or more but not fixed. Create Table :- ...
1
vote
1answer
53 views

How to select max value faster from large size table

I have query SELECT max(ParameterID) FROM modelparam_ems Table Name: modelparam_ems No Of Rows: 9000 It takes time to retrieve max value of parameterId, ParameterId in Unique value. Output Time ...
2
votes
3answers
58 views

Updating/Inserting 2000 entries takes over 12 hours to complete

I have three tables of around 10 million rows each in MySQL on Amazon RDS and I am finding the insert/update performance to be VERY slow. Each table contains unrelated data. Each table is regularly ...
1
vote
2answers
38 views

mysql master slave replication scenario

We are creating a new mysql slave, but for dump we are taking from a backup server which is a slave of current master. Now to enable replication we want to connect it with the master so should I take ...
0
votes
2answers
28 views

MySQL Upgrade on Windows

I am having MySQL 5.1 installed on windows box. Now I would like to upgrade to latest MySQL 5.6 version. I am planning to install MySQL 5.6 in the same server with same port 3306. After installation, ...
0
votes
1answer
24 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
0answers
17 views

Replicating from MySQL 5.1 master to 5.6 slave failing because 'INSERT … VALUES (NOW())' results in 'Error_code: 1062'

I am migrating away from some old MySQL 5.1 servers to some new MySQL 5.6 servers. During this process, I'm creating a new MySQL 5.6 slave from an existing MySQL 5.1 slave, using the procedure in the ...
1
vote
1answer
237 views

ERROR 1054 (42S22): Unknown column 'plugin' in 'mysql.user'

I am trying to grant privileges for a user to a new database mysql> grant all on db_test.* to 'user_test'@'localhost' identified by 'usersexistingpassword'; I get the following error ERROR 1054 ...
0
votes
1answer
69 views

Cross Join and Left Join within a query

I have query which has a cross join and also a left join which produces an error Unknown column 'a.hour' in 'on clause' simplified version of query is like this SELECT b.*,a.hour,c.datetime FROM ...
-1
votes
0answers
11 views

Does version MySQl 5.6.24 not support the none object orientated code of previous versions? [migrated]

I have the following code that works fine in other versions of Mysql but not in 5.6.24. Its on a testing server and not live. It works fine on the on-line server, which uses a version lower. 5. $con ...
0
votes
0answers
43 views

Column based replication in mysql 5.6

I want to do column based replication which means: In my server, I have table T1 in which columns are A, B, C, D, E I want to replicate this table on different server in mysql 5.6 only, but with ...
1
vote
2answers
38 views

MySQL connection timeout on connection spike

I have a little bit difficult problem, whenever a spike of connection occurs our MySQL server, connecting from all sources to the MySQL is practically impossible, the max_connections setting is not ...
0
votes
0answers
13 views

InnodDB - is a long running SELECT query when command is “Creating Sort Index” a likely cause of “Lock wait timeout exceeded”

I'm having recurring problems with lock wait timeout errors. These persist and build up until the database drops connections with "Too many connections". It has so far happened when I have been away ...
1
vote
3answers
49 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 : ...
0
votes
0answers
28 views

DB Design for Mobile App Clients

Hello I am new to designing DB for Mobile App where speed is the Key. My Mobile App will request to WebAPI and WebAPI will get data from MySQL. I have designed my tables in MySQL as per relational ...
2
votes
1answer
38 views

Optimizing a 3 table join query

SELECT job.id_job, job.fk_company, job.fk_user, job.fk_job_category, job.fk_job_type, job.fk_place, job.job_identifier, job.external_job_id, job.title, job.short_description, job.status, ...
0
votes
1answer
42 views

Optimize Wordpress Mysql Query that take 5 seconds to execute

Here is my original post: http://wordpress.stackexchange.com/questions/189736/optimize-wordpress-query-that-take-5-seconds-to-execute I have a large wordpress mysql database (Server version: 5.6.22): ...
0
votes
1answer
42 views

how to use a specific column for a day

CREATE TABLE `csptargets` ( `id` int(11) NOT NULL AUTO_INCREMENT, `start_date` datetime NOT NULL, `end_date` datetime NOT NULL, `cspcode` varchar(11) NOT NULL, `vol`decimal(20,3) NOT NULL ...
1
vote
1answer
40 views

Why is MariaDB 10 refusing to use my index on a date field?

I have the following table definition: CREATE TABLE `bets` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `id_mp` bigint(20) NOT NULL DEFAULT '0', `coin` char(3) COLLATE utf8_unicode_ci NOT NULL, ...
0
votes
0answers
23 views

table design approach for a rental application with several one to many relationships

I'm trying to go about designing a database/tables for the following situation I'm being presented. I'm developing a rental web application with MySQL as db engine. It is for a nonprofit organizations ...
1
vote
2answers
103 views

SQL Error (2027): Malformed packet

I have a mysql database (Version 5.6.23-log running on windows) that is set up for use with Teamcity. When running a command against it using HeidiSQL I am getting an error: SQL Error (2027): ...
0
votes
0answers
25 views

mysqldbcompare does not recognize DEFAULT value

I'm trying to implement a DB Versioning Process. I've got some Developer DBs and one Staging DB. On one Developer DB the DEFAULT Value of one Column has changed from NULL to ''. The DDL has therefore ...
0
votes
1answer
22 views

MySQL “SLEEP” command throws syntax error

The 'SLEEP' command in MySQL is throwing a syntax error: mysql> sleep(5); ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version ...
0
votes
0answers
26 views

AWS RDS Constant cpu (20%) utilisation

I have a RDS instance that has workload at specific time window, however, cpu utilisation is a constant 20% even outside this window. There is no replication configured. Can't find a solution for ...
2
votes
2answers
89 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
48 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
28 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
58 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
23 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
26 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
17 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
37 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
19 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
94 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
63 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
175 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
61 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
39 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
83 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
33 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
49 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
24 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
62 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 ...