[Mahesh]

1) Please zip and attach source and target table with sample data where this issue is reproducible along with JOB file?

OR

2) Is it possible to have temporary access to the source and target Database?

You can create a ticket from here for privacy

http://www.webyog.com/support/ttx.cgi

[Mahesh]

When you update to a new version of MySQL, you should update your system tables as well to make sure that their structure is up to date.

For more information, please visit – http://dev.mysql.com/doc/refman/5.1/en/mysql-upgrade.html

[Mahesh]

Attached .sql dump “imports successfully” at our end we have checked against 5.x as well as 4.x servers.

Please provide a sample testcase to reproduce those errors mentioned in above post, then only we can do some progress.

Thanks

[Mahesh]

Please zip and attach .sql dump file here, we will analyze and let you know the status.

[Mahesh]

1) Are you sure that you are running sync over two different database and having difference in number of rows for table(s)?

2) Can you please attach a job file here (you can remove password and server details if you want? )

[Mahesh]

Yes !!

Current Linux SJA works fine on 64 bit platforms too.

[Mahesh]

Also tell ,

1) How many servers you are monitoring?

2) How many servers are monitoring OS details ( SSH enabled) ?

3) How many servers have Sniffer enabled?

[Mahesh]

Issue Confirmed as Described,

Thanks for reporting

[Mahesh]

Hi,

We have tried to improve the performance in this build v 8.1 Beta1 ( not_released) build.

To Download

http://www.webyog.com/downloads/betas/not_…Lyog81n1Ent.exe

Please verify and send us the feedback whether performance improved at your end too.

So, we will look into a better solution for this issue.

Thanks,

Mahesh

[Mahesh]

This is a known issue recorded here ,

http://code.google.com/p/sqlyog/issues/detail?id=1039

We will look into this.

[Mahesh]

Hi,

This is really waird ! we do not have any reports like this one.

1) How much time you waited for the process to complete?

2) If you can give us a source and target table with data will be really helpful ?

Please create a support ticket from here to keep data confidential ,

http://www.webyog.com/support/ttx.cgi

[Mahesh]

No.. we dont have SJA Agent ( linux) release notes separately, we have release notes for SQLyog this includes SJA changes too.

You can see the changelogs for SQLyog from here,

http://www.webyog.com/blog/category/sqlyog/

[Mahesh]

You can download SJA v 6.56 from here,

http://www.webyog.com/downloads/oldies/sja656.tar.gz

Also, you can download latest SJA from here,

http://www.webyog.com/en/downloads.php

[Mahesh]

we have tried with larger queries at our end for example,

Quote:

SELECT

t.TABLE_SCHEMA AS `db`

, t.TABLE_NAME AS `table`

, s.INDEX_NAME AS `inde name`

, s.COLUMN_NAME AS `field name`

, s.SEQ_IN_INDEX `seq in index`

, s2.max_columns AS `# cols`

, s.CARDINALITY AS `card`

, t.TABLE_ROWS AS `est rows`

, ROUND(((s.CARDINALITY / IFNULL(t.TABLE_ROWS, 0.01)) * 100), 2) AS `sel %`

FROM INFORMATION_SCHEMA.STATISTICS s

INNER JOIN INFORMATION_SCHEMA.TABLES t

ON s.TABLE_SCHEMA = t.TABLE_SCHEMA

AND s.TABLE_NAME = t.TABLE_NAME

INNER JOIN (

SELECT

TABLE_SCHEMA

, TABLE_NAME

, INDEX_NAME

, MAX(SEQ_IN_INDEX) AS max_columns

FROM INFORMATION_SCHEMA.STATISTICS

WHERE TABLE_SCHEMA != 'mysql'

GROUP BY TABLE_SCHEMA, TABLE_NAME, INDEX_NAME

) AS s2

ON s.TABLE_SCHEMA = s2.TABLE_SCHEMA

AND s.TABLE_NAME = s2.TABLE_NAME

AND s.INDEX_NAME = s2.INDEX_NAME

WHERE t.TABLE_SCHEMA != 'mysql' /* Filter out the mysql system DB */

AND t.TABLE_ROWS > 10 /* Only tables with some rows */

AND s.CARDINALITY IS NOT NULL /* Need at least one non-NULL value in the field */

AND (s.CARDINALITY / IFNULL(t.TABLE_ROWS, 0.01)) < 1.00 /* Selectivity < 1.0 b/c unique indexes are perfect anyway */ ORDER BY `sel %`, s.TABLE_SCHEMA, s.TABLE_NAME /* Switch to `sel %` DESC for best non-unique indexes */ LIMIT 10;

Please give us,

1) Sample query which causes the problem?

2) MySQL server version?

[Mahesh]

Hi,

Current SJA version is 8.05, which will support Data Sync operation from MySQL server v 4.1.1,

If either of your MySQL server is less than 4.1.1 then you need to use SJA v6.56.

[Author]

Posts