Comments
Sort by recent activity
Michael Christofides wrote:
Thanks all for your patience, this issue has now been fixed. You can get the latest versions by checking for updates within the tool or from our website here: http://downloads.red-gate.com/MySQLComparisonBundle.exe
I downloaded the latest version (1.0.0.425) and the issue appears to be resolved. Thanks for the update Michael. / comments
Michael Christofides wrote:
Thanks all for your patience, this issue has now been fixed. You can get the latest versions by checking for updates within the tool or from our website here:http://d...
Sorry, I should have mentioned the version number. 1.0.0.409 which should be the latest version (running on Win 7 Enterprise SP1 x64). / comments
Sorry, I should have mentioned the version number. 1.0.0.409 which should be the latest version (running on Win 7 Enterprise SP1 x64).
Another quick update here. I've noticed that queries involving the information_schema database on the server in question are very slow which would suggest the problem doesn't lie with MySQL compare. / comments
Another quick update here. I've noticed that queries involving the information_schema database on the server in question are very slow which would suggest the problem doesn't lie with MySQL compare.
Fixed:
And another update. I had a look at the server and innodb_stats_on_metadata was set to 1. I set this to 0 with the following: SET GLOBAL innodb_stats_on_metadata=0;
Or you could set it in your my.conf. Now when I run a comparison, it takes about 6 seconds to register a database on that server which is much faster than I was getting before. Credit to this post for details on the effect that setting has on information_schema query peformance: http://www.mysqlperformanceblog.com/2011/12/23/solving-information_schema-slowness/ / comments
Fixed:
And another update. I had a look at the server and innodb_stats_on_metadata was set to 1. I set this to 0 with the following:SET GLOBAL innodb_stats_on_metadata=0;
Or you could set it in y...
Michael Christofides wrote:
Hi, thank you for the details.
Very strange indeed. In terms of logging, there are instructions described for an equivalent product here: https://documentation.red-gate.com/disp ... +log+files
I assume you are using the same mode of transport (TCP/IP, Named Pie, or SSH) in each case, so that couldn't be the issue?
Best regards,
Michael
Hi Michael,
Yes, it's TCP/IP connections. I'll have a look at the logging link you sent. / comments
Michael Christofides wrote:
Hi, thank you for the details.
Very strange indeed. In terms of logging, there are instructions described for an equivalent product here:https://documentation.red-gat...
I should also note that my network connection to the server is generally good. Pings are always < 1ms and I can transfer a 900MB ISO file in < 20 seconds. / comments
I should also note that my network connection to the server is generally good. Pings are always < 1ms and I can transfer a 900MB ISO file in < 20 seconds.
I'm seeing this same problem. We have an internal MySQL server we use for development. The details of this server are as follows:
OS - Windows Server 2008 R2 (64-bit)
MySQL version - 5.1.46-community
That sits on the same network as my development machine. It has 57 databases on it but there are only about 10 of them being used in active development and even at that, there is a very light load on the server. For arguments sake, we'll call this Server A. If I have to use MySQL compare to compare the schema of a database on Server A to any other database, you're talking at least 80 seconds for MySQL compare to register that database. If you're comparing two databases on Server A then that minimum time would double. The complexity of the schema appears to have little effect on the length of time taken to register the database. Even if I create a test database which contains just a single table with two INT columns, it still takes > 80 seconds to register the db.
The strange thing is that with any other remote servers I've tried, the registering of a database is usually complete within 5 seconds. Is there any logging built into MySQL compare that I can switch on to try and work out why this is taking so long? / comments
I'm seeing this same problem. We have an internal MySQL server we use for development. The details of this server are as follows:
OS - Windows Server 2008 R2 (64-bit)
MySQL version - 5.1.46-communi...
Michael Christofides wrote:
Sorry for the delay, but the recent release should contain a fix for this issue. Please do let us know!
I downloaded the new version and this does seem to be fixed now. Thanks. / comments
Michael Christofides wrote:
Sorry for the delay, but the recent release should contain a fix for this issue. Please do let us know!
I downloaded the new version and this does seem to be fixed...
I'm still seeing this problem. I recently bough MySQL Compare using version 1.0.0.301 and appear to be up to date (running Help->Check For Updates says no updates available).
As a quick test, I created two databases - `db1` and `db2`. Now run this: CREATE TABLE `db1`.`test` (
`id` INT(10) NOT NULL AUTO_INCREMENT,
`name` VARCHAR(10) NULL,
`active` TINYINT NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB;
CREATE TABLE `db2`.`test` (
`id` INT(10) NOT NULL AUTO_INCREMENT,
`name` VARCHAR(10) NULL,
PRIMARY KEY (`id`)
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB;
Upon running a comparison of the two databases, it correctly identifies the new `active` column and shows it as:
`active` tinyint(4) NOT NULL DEFAULT 1,
Upon running the deployment I get a "No value specified for a NOT NULL column". Here I have to manually change the dropdown to "Specify custom value" and change the value to 1.
In a simple example like this, that's not too much of a hassle but when you're using this for larger deployments, this can become quite annoying if there are lots of new NOT NULL columns with DEFAULT values specified. / comments
I'm still seeing this problem. I recently bough MySQL Compare using version 1.0.0.301 and appear to be up to date (running Help->Check For Updates says no updates available).
As a quick test, I cre...