Activity overview
Latest activity by bstewart
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...
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.
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.
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'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:
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).
Comparison keeps flagging index changes
I'm currently using a development database which is running the following MySQL version:
protocol_version;10
version;5.1.46-community
version_comment;MySQL Community Server (GPL)
version_compile_ma...
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...