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

1015 questions
53
votes
6 answers

How to update 10 million+ rows in MySQL single table as Fast as possible?

Using MySQL 5.6 with InnoDB storage engine for most of the tables. InnoDB buffer pool size is 15 GB and Innodb DB + indexes are around 10 GB. Server has 32GB RAM and is running Cent OS 7 x64. I have one big table which contains around 10 millions +…
user16108
45
votes
2 answers

InnoDB: Error: Table "mysql"."innodb_table_stats" not found after upgrade to mysql 5.6

I upgraded to mysql 5.6 from 5.5, and now my logs are littered with such messages on startup I found a possible solution here, but it does not seem official. http://forums.mysql.com/read.php?22,578559,579891#msg-579891 2013-12-06 21:08:00…
giorgio79
  • 1,407
  • 7
  • 19
  • 19
42
votes
5 answers

MySQL: How to create Column if not exists?

I am trying to create a Column for my table only if it does not exist. I have researched a lot but I could not find any solution yet. Is this really possible to conditionally create Column ?
zzzzz
  • 523
  • 1
  • 4
  • 5
38
votes
2 answers

MySQL - Difference between using count(*) and information_schema.tables for counting rows

I want a fast way to count the number of rows in my table that has several million rows. I found the post "MySQL: Fastest way to count number of rows" on Stack Overflow, which looked like it would solve my problem. Bayuah provided this…
Programster
  • 533
  • 1
  • 4
  • 10
36
votes
2 answers

mysql Lock wait timeout exceeded; try restarting transaction

we are running java application, running for ages, back end is MySQL, recently updated to MySQL 5.6. Everything was running fine, past week started getting this error: Lock wait timeout exceeded; try restarting transaction which looks like never…
JAVAC
  • 471
  • 1
  • 4
  • 6
33
votes
4 answers

Best way to create a materialized view in MySQL

I am using MySQL 5.6. I am not being able to a create materialized view like I can in Oracle. I have seen one or two solutions like Flexview. Can anybody tell me best way to create a materialized view in MySQL (auto refresh like in Oracle ) with the…
Bhupendra Pandey
  • 579
  • 3
  • 8
  • 16
30
votes
3 answers

Why query_cache_type is disabled by default start from MySQL 5.6?

We've upgraded to MySQL 5.6 and start seeing the loading of db server increased significantly, and finally found out the query_cache_type is defaulted to off start from 5.6. We enabled it again and see the loading decrease, why this value is being…
Yoga
  • 549
  • 3
  • 8
  • 15
19
votes
9 answers

How can I make MySQL client read password from mylogin.cnf?

I'm trying to make the mysql client connect to a mysql server without requiring the password to be given interactively. Steps taken: 1) First create a mylogin.cnf file $ mysql_config_editor set --user= --password --host= Enter…
Lefteris Koutsoloukas
  • 368
  • 1
  • 3
  • 9
19
votes
5 answers

Cannot open table mysql/innodb_index_stats

After a fresh install of XAMPP and import from my linux live db that is working to the windows Dev-stage, I started encountering problems with INSERT. Everything else seems to work well. The errors I get in the mysql_error.log are: 2013-08-15…
Mike
  • 315
  • 1
  • 2
  • 7
15
votes
2 answers

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 WHERE topics.id=posts.topic_id AND topics.id =…
codecowboy
  • 265
  • 1
  • 2
  • 8
15
votes
1 answer

Decimal or Point Data Type for storing Geo location data in MySQL

I want to store Geo location for each Address in my MySQL(Innodb) "tblAddress" table and I think I have 2 Options: 1) 2 columns for Each Address: Latitude DECIMAL(10, 8), Longitude DECIMAL(11, 8) 2) One Column for Each Address: GeoLocation…
Prabhat
  • 337
  • 2
  • 4
  • 15
14
votes
3 answers

How can I force MySQL to IGNORE ALL indexes?

I have read articles about FORCE index, but how can I force MySQL to IGNORE ALL indexes? I tried SELECT * FROM tbl IGNORE INDEX(*), but I was not successful. As for why I (and others) need to do this: For example, I needed to summarize referers…
mvorisek
  • 428
  • 1
  • 5
  • 20
13
votes
4 answers

MySql Gap Lock Deadlock on Inserts

I'm getting Deadlocks from gap locks on a table when inserting into it frequently from multiple sources. Here is an overview of my processes. START TRANSACTION UPDATE vehicle_image SET active = 0 WHERE vehicleID = SOMEID AND active = 1 …
Brian Sizemore
  • 191
  • 1
  • 1
  • 12
13
votes
1 answer

MySQL Commited data not seen to select query

Context: The framework used is Spring and all queries are run with JdbcTemplate. Mysql Server version is 5.6.19. The table is an InnoDB table and defaults like auto commit and isolation level repeatable-read is set. Problem: An Insert happens…
Ahmed Aeon Axan
  • 131
  • 1
  • 7
12
votes
3 answers

MySQL instance stalling "doing SYNC index"

Problem An instance of MySQL 5.6.20 running (mostly just) a database with InnoDB tables is exhibiting occasional stalls for all update operations for the duration of 1-4 minutes with all INSERT, UPDATE and DELETE queries remaining in "Query end"…
syneticon-dj
  • 495
  • 10
  • 26
1
2 3
…
67 68