0
votes
1answer
7 views

Accuracy of mysqldbcompare vs other tools like pt-table-checksum

I was curious to hear what everyone's experiences are with using mysqldbcompare vs pt-table-checksum( from Percona Toolkit ) to find the differences between two MySQL databases. I have heard that ...
0
votes
0answers
6 views

mysqldbcompare shows checksum fail but row differences passes

I have started to try using mysqldbcompare to help me compare two databases that are each about 5 gigs with lots of tables. When the tool runs, I am noticing many results like this : # TABLE ...
0
votes
1answer
16 views

Using pt-table-checksum to compare a slave's DB to another slave

I understand that pt-table-checksum can do checksum compares between a master's DB and a slave's DB easily. However, let's say your master has two slaves replicating from it for the same DB, i.e. ...
0
votes
0answers
16 views

Using partitioned table, and dealing with auto_increment PK

I have a big table (>100 million rows) that tracks user's activities. It has an ID, which is PK and has auto_increment property. This is the only unique key. Table also has userid and datetime column. ...
1
vote
0answers
38 views

innodb slower much slower than expected

Trying to figure this one out and I apologize for not providing a lot of information from the start (if you need further let me know and I can try to provide it). Query is performing very poorly - it ...
1
vote
1answer
61 views

Any known issues upgrading from MySQL 5.1.73 to 5.6.21?

I am planning my MySQL DB ver5.1.73 running on a CentOS 6.5 machine to MySQL 5.6.21. I understand the basic procedure for this based on what I have read on StackOverflow, but I was curious if anyone ...
0
votes
1answer
26 views

I noticed that my MySQL slave's DB size is smaller than the Master's DB

I have a very simple setup of a master MySQL DB with one slave MySQL DB replicating from it. Initially, when setting up the slave, I used mysqldump to get an initial DB dump from the master like ...
0
votes
0answers
37 views

MySQL has gone away with two connections

I'm using MySQL 5.6.19 on OSX 10.9.5 (DMG installation from mysql.com) and I'm receiving the infamous MySQL has gone away when I try to open two connections to this server. If I try connecting from ...
1
vote
1answer
10 views

Why MySQL init_connect variable gets updated after rebooting?

After SET GLOBAL init_connect=''; query everything works fine. However after rebooting the server or restarting the MySQL service it updates the init_connect value to some random value (OÇÿOÇÖ). Do I ...
0
votes
0answers
33 views

How can I speed up MySQL Workbench in a SQL Server to MySQL conversion? [closed]

I am using MySQL Workbench to convert a 9GB SQL Server database (2012) to MySQL 5.6 on the same AWS Windows machine. (It's an r3.2x large, 8 vCPUn, 26 ECU, 61 GB RAM). It has been running for about ...
1
vote
1answer
38 views

MySQL service stops after trying to grant privileges to a user

I am using MySQL 5.6, I was trying to create a super user for specific database but I got ERROR 1396 (HY000): Operation CREATE USER failed for 'superuser'@'%' Then I thought maybe there is already ...
0
votes
1answer
41 views

Calculating difference between consecutive timestamps. Error when i reach the hour mark

I am using MySQL I have a table that contains among other things an id a time in the format date:time (YYYYhhmmss) and a readingvalue. The difference between each reading value is 300 seconds but ...
0
votes
0answers
35 views

Create separate temporary table/view and variables for every query

How can I create something similar to VIEW or TEMPORARY TABLE for every query separately? I have 1 process, it creates and holds one connection (doesn't destroy connection after request, so doesn't ...
1
vote
1answer
35 views

Innodb issue is preventing MySQL from starting

For some reason mysqld refused to start after I rebooted my server. Now when I try to start it I will get the following error: [root@vps1 ~]# service mysqld restart ERROR! MySQL server PID file ...
-1
votes
0answers
33 views

How does MYSQL Bin Log work?

I notice once I enable mysql bin log and do a restart on mysql service, there is a log file generated namely "mysql-bin.000001". So I did a quick test to modify database entries and eventually the ...
3
votes
1answer
59 views

Is it mandatory to enable --log_slave_updates with MySQL Replication using GTID? [duplicate]

I'm setting up 5.6 Percona Mysql, in order to enable GTID should I have to enable log_slave_update on both Master and Slave ? If I should enable log_slave_update, then I'm counting this to CONS for ...
0
votes
2answers
41 views

MySQL excessive tmp disk tables after Upgrade to 5.6

After upgrading two MySQL-Servers which run Master-Slave replication from Percona MySQL 5.5 to Percona MySQL 5.6 an excessive amount of temporary Tables gets created on the slave. The Master seems to ...
0
votes
2answers
65 views

mysql - query records to fetch by time stamp

I've a MySql 5.6 DB with a simple table (MyISAM) . | UniqueKey | TimeStamp | ------------------------- | 1 | 1024125412 | | 2 | 1024125413 | | 3 | 1024125414 | My table ...
0
votes
1answer
21 views

How can I move a MySQL database from 5.1 to 5.6?

I have pretty big database, like with 5 000 000 rows in total. It is located in a remote server. I want to copy this database to my personal computer, for testing purposes. However I don't know the ...
1
vote
1answer
412 views

MySQL does not start - Ubuntu 14.04 LTS after migration to new disk

I have installed in a Virtualbox VM a 64-bit desktop version of Ubuntu 14.04 LTS and MySQL Server 5.6. I had some databases in the machine's main virtual hard disk but then I was going to open a SQL ...
10
votes
2answers
171 views

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, ...
0
votes
1answer
28 views

InnoDB compression: memory usage

InnoDB offers table compression for Barracuda-type tables and the recommendation seems to be to "adjust" buffer_pool_size. The documentation is rather vague about the definite impact of compression on ...
1
vote
1answer
79 views

MySQL 5.6.17 running out of memory when opening table with many partitions

We are currently setting up a MySQL database (version 5.6.17) on an Amazon db.m1.large RDS instance for storing time series data. Each time series property of an object is stored in a separate InnoDB ...
0
votes
1answer
29 views

How to restore data after MySQL Upgrade?

I upgraded from MySQL 5.5 to 5.6 by uninstalling 5.5 and then installing MySQL 5.6. Now that MySQL 5.6 is running, none of my DBs or data is present/visible in MySQL Workbench. I also see that I ...
1
vote
1answer
34 views

Change column without interrupting service

We need to change the data type of a column in a large table (~1.7 GiB) from VARCHAR(1024) to VARCHAR(512) in order to be able to create a secondary index over two columns. We're using MySQL 5.6 with ...
1
vote
1answer
56 views

MySQL InnoDB table accepts Non-Existent Foreign Key

Using EasyPHP 14.1 VC11 and phpMyAdmin (4.1.4) to create a website project in my home computer. The MySQL version is 5.6.15 according to the EasyPHP administration page. Working on Windows 7 64-bit. ...
0
votes
0answers
86 views

Why Percona MySQL is crashing again and again

We have Percona MySQL Cluster running with three nodes on CentOS. Server : Percona-XtraDB-Cluster-server-56-5.6.19-25.6.824.el6.x86_64 One node is crashing repeatedly. Thread pointer: 0x18910ba30 ...
0
votes
1answer
83 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 ...
2
votes
1answer
94 views

InnoDB: “Only one log file found” after binary import

My first one on DBA... After successful upgrading a master MySQL server 5.5 to 5.6.17 (CentOS 6 VPS serer), I done and moved my binary backups to a slave server (same version 5.6.17 but different ...
0
votes
1answer
30 views

Loading the databases from previous installation mysql

My Windows OS crashed today. Now I have recovered all the files in Program files/MySQL folder.(I don't have the exported .sql file) With the new installation of MySQL 5.6(same as before), can I get ...
1
vote
1answer
104 views

MySQL crashes frequently on a Windows server

I have been facing an issue with MySQL crashes since last week. I don't know what exactly is happening. When I look at the Windows logs, I see the following error message: Faulting application name: ...
0
votes
1answer
20 views

Where mysql writes its log seqeunce numbers and last checkpoint at?

I'm working on developing mysql log collecting system. To do that, I have to collect log sequence numbers from mysql LSN and last checkpoint location. But I have no idea where should Which log file ...
0
votes
0answers
40 views

Why does Amazon RDS memory utilization drop and disk space utilization rises?

I encountered a problem with my Amazon RDS(db.m2.2xlarge) where DB connections spiked up and my website started responding slowly. On looking up the metrics I was not sure why my freeable memory shot ...
0
votes
1answer
95 views

Is it possible to uninsall MySQL-5.6 and install MySQL-5.1 on RHEL 5

I have installed MySQL-5.6.x community edition on RHEL5. It was running fine. Since, it is my testing server. To find the differences in execution timing, I have to install the MySQL-5.1 community ...
1
vote
1answer
93 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 ...
2
votes
2answers
292 views

mysqldump --single-transaction, yet update queries are waiting for the backup

If I use mysqldump --single-transaction, according to the docs it should do flush tables with read lock to get a consistent state and then start a transaction and no writers should be waiting. ...
0
votes
1answer
126 views

How performance schema in mysql 5.6 improve performance?

Since MySQL 5.5 performance_schema database has been added likewise information_schema. As we know that tables in information_schema contains statistical information like tables, plugins, partitions, ...
0
votes
1answer
26 views

What is the difference between Com_xxx and handler_xxx?

Initially my com_delete variable and handler_xxx variables are nil. | Com_delete | 0 |+ | Handler_delete | 0 | +----------------+-------+ then I issued a delete query delete from gt ...
1
vote
1answer
68 views

Why didn't MySQL keep the innodb_file_format after loading a mysqldump

I was loading a mysql dump today when I ran into ERROR 1118 (42000) at line 279: Row size too large (> 8126) Which I thought was weird because I know I had turned on row compression and was ...
0
votes
2answers
743 views

mysql no longer defaulting to /tmp/mysql.sock

I was testing some software to see if it could connect to mysql correctly when mysql is not using /tmp/mysql.sock. I stopped mysql, editted /etc/my.cnf to add socket=/var/lib/mysql/mysql.sock ...
1
vote
1answer
47 views

How does the alter command work internally when adding a column?

Can anyone explain what the internal operations are that takes place when an alter command is issued? How is column modified? Does it use created_tmp_tables or created_tmp_files? As per my test, I ...
0
votes
2answers
182 views

What is default MySQL binlog retention in AWS RDS?

I tried to retrieve my MySQL RDS binlogs in order to run manual "rollback" for some SQLs. Unfortunately, I noticed that only 2 binlogs for the last 30 minutes are available. "call ...
0
votes
1answer
48 views

How to include a semicolon (“;”) in a MySQL pager command

I've just discovered the pager command in the MySQL command-line client, and I'm having a tonne of fun. This blog post is great: ...
2
votes
3answers
585 views

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 ...
0
votes
1answer
23 views

MySQL still seems to be establishing a connection even when access is denied, causing aborted connects and instability

Lately the server's been going a bit haywire and we've spent several weeks chasing down leads to no avail. All we can tell is that when the websites go down (and come back up, and go down, and come ...
0
votes
0answers
28 views

Can queries containing deterministic user defined functions be cached in mysql query cache?

According to the mysql 5.6 docs: A query also is not cached under these conditions: ... It refers to user-defined functions (UDFs) or stored functions. However, I have seen claims that if ...
0
votes
0answers
108 views

How to set up MySQL 5.6 Master- Slave Replication step by step

I am new to Mysql replication. I want to have 2 MySQL servers, a Master and a Slave, running on two Ubuntu 14.04 Computers. Their IP addresses will be 10.0.0.1 (Master) and 1.0.0.02 (Slave). I need to ...
3
votes
2answers
96 views

SQL Question: Selecting different language versions based on availability

I have the following situation: I have a table that contains entries with language versions (German and English) as part of the key (the other part being a "name" field). However, not always both ...
0
votes
0answers
116 views

MySQL Replication thread hangs on flush tables with read lock

I have a MySQL master/slave set up with row-based replication. At times of higher load we've been seeing replication halt and all slave thread activity commands just hang. STOP SLAVE, SHOW SLAVE ...
0
votes
1answer
243 views

Getting an error in MySQL Workbench: Cannot Open Administrator

I'm using local installation of MySQL CE on Windows 7 64-bit. Tried to use Administrator part for the first time. Here's the error I'm getting: I also see the following in the log: <object ...