Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [mysql-5.6]

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

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

http://dev.mysql.com/doc/refman/5.6/en/index.html

1028 questions
10
votes
2 answers

MySQL - maximum of sum over different months with ties over multiple years

This question was inspired by this one [closed] and is virtually identical to this one but using different RDBMS's (PostgreSQL vs. MySQL). Suppose I have a list of tumours (this data is simulated from real data): CREATE table illness…
Vérace
  • 29,825
  • 9
  • 70
  • 84
7
votes
1 answer

Upgrading 5.6 to 5.7 without losing any data

I want to upgrade MySQL from 5.6 to 5.7 but I already have the existing databases and tables. How should I upgrade without losing any data?
Prasanna Khanna
  • 71
  • 1
  • 1
  • 2
6
votes
1 answer

Prevent mysql process being killed by OOM killer

I need to protect mysql process so that it won't be killed when system runs out of memory, we have a bunch of adhoc job run on the server from time to time, so I would prefer the adhoc jobs being killed rather than mysql. I know I can adjust the…
Jialun Liu
  • 183
  • 2
  • 8
2
votes
1 answer

Very low table cache hit rates

I have been trying to tune my MysSQL databases, but always having a very low cache hit rate. I suspect partially because I run a sitemap crawler that is crawling 1.3 million pages. But, besides that, the most site traffic is on a dozen of those…
soaring eagle
  • 31
  • 4
1
vote
1 answer

returning the number of columns in a row that are zero in mysql

I have a table that contains amongst other things a datetime column, and 4 other columns that contain either a zero or a number. I would like to return how many columns in a row contain a zero in mysql. for example 1_datetime 0 2 5 0…
srh
  • 25
  • 1
  • 4
1
vote
1 answer

MySQL 5.6 "temporal columns" upgrade - datetime etc.

I upgraded from MySQL 5.1 to 5.6.17. Now in Wordpress plugins some of my timestamp columns have started behaving strangely. MySQL documentation on this very critical feature enhancement (decimals in timestamp fields) is sloppy. SO one relies on…
PKHunter
  • 113
  • 4
1
vote
1 answer

Optimizing large table in mysql

I'm running mysql 5.6 and I am trying to optimize a large table without mysql recreating it. As a dry run I ran the same command (optimize table) on a smaller table in the same DB and mysql insists on a recreate+analyze instead. Note that I'm using…
Ram
  • 218
  • 3
  • 9
1
vote
2 answers

How to store user selected value, single choice or all choices

I have a form where a user is able to select a single value from a dropdown. The first option in the dropdown is "All", followed by all of the individual options that they can pick. So, they can either pick an individual thing, or they can pick…
Isaac Fife
  • 113
  • 4
1
vote
2 answers

Does Grant on MySQL overwrite previous permissions?

I ran the following command per AWS Aurora's documentation to give my user permissions to write to S3: GRANT SELECT INTO S3 ON *.* TO 'user'@'domain-or-ip-address'. Unfortunately, it revoked permissions to do anything, so I couldn't even run a basic…
simplycoding
  • 173
  • 6
1
vote
0 answers

Importing SQL File in mySQL no errors

I logged into the mysql from the command line using the following command and in addition to that I was trying to import the sql file into the database as follows in the same line: [username@abc-xyz web_app]$ mysql -u root -pmypassword -Dtestdb <…
John
  • 163
  • 3
  • 11
1
vote
1 answer

reduce network traffic for MySQL queries

As part of a hobby-project I have a number of servers on my network that measure various parameters (both system statistics and domotica) and store the results (mostly as 5-minute averages) in various tables in a MySQL database running on one of the…
Mausy5043
  • 93
  • 8
1
vote
0 answers

Differences between MySQL DESCRIBE, SHOW COLUMNS FROM, SHOW CREATE TABLE and query to information_schema table

I have always checked table definitions through DESCRIBE, but today I came across something weird. Another guy told me the DEFAULT value shown for a column through SHOW CREATE TABLE was different from what I got from DESCRIBE. I checked…
Andrés Botero
  • 111
  • 1
1
vote
1 answer

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

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 233 'Out of operation records in transaction…
eten
  • 11
  • 2
1
vote
0 answers

MySQL - Find bookings free time slot

I am trying to find free time blocks on a day between the business hours (08:00 to 18:00) of a service station. The schema of the database is as below, CREATE TABLE IF NOT EXISTS `Bookings` ( `id` int(11) NOT NULL, `date` date NOT NULL, …
SQL Starter
  • 11
  • 3
1
vote
1 answer

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 what problem it is reflecting. InnoDB: Warning:…
Harshdeep Khatri
  • 11
  • 1
1
2 3