[peterlaursen]

Why don't you use a one way sync for this? Two way sync won't delete.  

Though not brand new anymore, this article:

http://webyog.com/en/whitepapers/Using_SQL…L_Databases.pdf

.. will give you an idea of how the SYNC JOB is handled internally.

[peterlaursen]

We still cannot reproduce.  Can you tell the Server versions involved?

You say 'couple of occasions'. that means that it happens only sometimes? Can you help in identifying the circumstances?

[peterlaursen]

baiscally we think MySQL Ab should fix that soon.

The silly thing is the the original formatting is stored in the .frm file, but MySQL does not use it!

[peterlaursen]

What your are requesting is a engine specific parameter. I think we will concentrate on parameters and metrics that are not engine specific. Basically because at this moment (with the introduction of the Falcon engine and 3rd party engines) it is very uncertain what engines would 'normally' would be used as storage engine(s) with MySQL (MyIsam, InnoDB, Falcon, Solid, pbxt) in the future.

At least

* authentication

* notifications and alerts

* trend analysis

.. should be introduced first in my opinion.

For those storage engines (Innodb, Solid) that use a 'table space' not controlled by the file system but by the code of the storage engine itself it is not easy to tell the size of individual tables and databases. They simply are (normally) not individual files.

Why do you need this feature?

[peterlaursen]

We have reproduced this now.  

Reason is a GDI leak in 'the basic GRID code'.

Often reproducing is the toughest thing.  So we expect to fix this soon now!

[peterlaursen]

I was informed that one repainting issue was fixed between RC1 and RC2 (a GDI leak fixed)

If it happens again a screenshot of SQLyog in TASK MANAGER (showing the 'GDI Objects' column) could be useful.

Enable display of GDI Objects from Task Manager menu 'view .. select columns'

Did you ever see a similar thing in a recent 5.x version (if you have been using 5.x recently)?

[peterlaursen]

It is unlikely that there is any change between RC1 and RC2 that would make any difference here.

Of course we always 'clean up' in the code when we see something that could need it, but we have not been working explicitly with this after RC1. We have not been aware of any such issue in RC1.

An ALTER TABLE taking 20 minuts to complete. Why that much? Could you post (here or in a ticket) a structure_only dump (and possibly an ALTER TABLE statement) to reproduce with?

I also think I remember that you use HTTP connection?

[peterlaursen]

This is an issue with MySQL and not SQLyog.

There are dozens or hundreds of complaints in MySQL Forums and bugs.mysql.com that the MySQL server 'garbles' the formatting of VIEWs.  We can only display what we retrieve from MySQL!

[peterlaursen]

Using SHIFT works for me (version 6.0 RC2)

What is the program version you are using?

[peterlaursen]

is it a Linux server?

System info is currently supported on Linux (may work with different unix'es too), and not Windows.

We connect to the system using SSH what is not supported on Windows. We plan to add support for system info for Windows servers using WMI.

[peterlaursen]

No. Unfortunately it is currently not possible.

[peterlaursen]

You will have to use the Migration Tool.  the sync tools are for MySQL-mySQL sync only.

The Migration toll lets you do 'incremental import –  Refer to the -faq at

http://webyog.com/faq/17_79_en.html

.. and the article linked to from our homepage

[peterlaursen]

please tell: will you be more happy if I answer 'yes' or 'no' to your question? How will it help you to know if other people experienced this.  I do not understand why you ask this question! 🙂

Please always tell the program version (and please always try latest available version if possible) before reporting an issue.  We cannot fix issues in old versions really!

But this issue has been fixed I believe! I think about 9 months ago!

However if you still experience this with a recent version we would like to know how to reproduce it!  In that case please attach a structure-only dump of a table to reproduce with!

[peterlaursen]

The Linux version has been 'lagging a little behind' after the release of 0.16. We will soon 'catch up' again.

[peterlaursen]

yes .. and CREATE/ALTER TABLE too and a few more.

it is on our TODO, and I also think we shoul give priority to this once 6.0 FINAL is out.   Some users still use a laptop with 800*600 display and some work with a 3000*2000 plasma screen TV-set as their Monitor!!

[Author]

Posts