[peterlaursen]

example:

I'm running a one-way sync from a-base to b-base. The sync lasts for ½ an hour.

Ten minutes aftes the sync has started (and while it's still in proces) some data are UPDATED (or DELETED or INSERTED) in a-base.

Then the Q is then: what will happen (of these three posibilities):

1) SJA will CERTAINLY write this change to b-base

2) SJA will NOT (ever) write this change to b-case

3) SJA will MAYBE write this change to b-base depending on circumstances.

possibility 3) is what I call “not predictable”.

[peterlaursen]

that's OK – that's a fair answer!

[peterlaursen]

Both target and server are 4.0.24 in this case.

I'll send the data later – right now I'm unable to change the PK of that table since since there is a job running with the database …

[peterlaursen]

I have never been working with ssh, but do you fill out BOTH the “server” and the “tunnel” tab for the connection ?

From the sqlyog-help:

To understand the setup better, let us connect to a MySQL server using a real life example.

E.g. Your website is hosted on 234.56.65.78. This server also has SSH server running and listening on port 22. Your MySQL server is located on server 234.56.65.79. This machine only allows connection from localhost or machine within the same network (e.g. 234.56.65.78). You publish your website on 234.56.65.78 using the username and password provided by your ISP. ex. the username and password provided is ssh_user and ssh_pwd respectively.

In this particular case you have to put in the following value for various options:

Server Tab

MySQL Host Address 234.56.65.79

Username Your mysql user name.

Password

Your mysql password.

Database

The database that you want to connect to. You can leave this field blank.

Port

The port MySQL is listening. By default it is 3306.

Tunnel Tab

Username

ssh_user

Password ssh_pwd

SSH Host 234.56.65.78

SSH Port 22

Local Host This is always localhost.

Local Port Any port that is unused on your local machine. If you dont have a MySQL running on your machine then you can provide 3306.

********************************************************************************

****'

“Access Denied Error for 'Root'@'server'” is a MySQL server error

“Could not connect to TARGET MySQL server” is a SQLyog error

I suspect that first you provide wrong/none password on the “server tab”, next you mismatch users for ssh and mysql ??

[peterlaursen]

BTW – that reminds me that in the above examples the eidtor does not recognize the concluding

“………. ; ”

of each statement.

However if I put in a linebreak like

“…….. <<< ;”

– it does.

That must be because each statements is one long line (it is a view definition copied from the objects-pane) and the parser within the editor stops parsing after character number somewhat in each line. No problem if you know it, but very annoying until you find out.

Of course you shouldn't write a statement like that, but when copying statements or using machine-generated statements that stuff occurs …

So just replace “for i= 1 to 256 do….” with “while not end of line do …. ” in the code or however it's expressed in the language/dialect used for the editor …

I learned that about 25 years ago …. 😀

[peterlaursen]

I just noted at http://www.mysql.com that 5.0.5 is just “not released” 5.0.6 is “not released yet”.

My interpretation is that they will skip distribution of the 5.0.5-binaries. So 5.0.6 must be very close. Hope that could help you!

[peterlaursen]

You got a point … I tested with a small base with a few hundred rows, and there is now problem.

But why must it take 50 or 100 times as much time (or more) to display 1000 rows the second time compared to the first time ?!

The code must be ineffective the second tme!

I experience the problem with two tables with respective 17000 and 37000 rows (both with some BLOBs in them) . But it's not the number of rows (I have another with also about 17000 rows, with only an integer-PK, a timestamp and one more number. Here is no problem).

But now I waited for about 10 minutes and the 17000-row table came back to the screen! The 37000-row table won't do in 20 minutes (and memory consumption keeps rising)- and that's with a DB on localhost. But I don't think the host matters here – the program calculates; it doesn't send or receive data. Table size (MYD-file) is about 8 MB and that's not a lot … There is an integer PK, so it should not have difficulty in sorting and filtering. And memory consumption keeps on rising. why must the program use +200 MB memory (physical + virtual) to work with 8 MB of data … ??

The use of resources (CPU + memory) by the MySQL server is completely normal … the problem is with SQLyog!

[peterlaursen]

Have you searched the forum for issues relating to yours ? There are lots of them! One of the latest:

http://www.webyog.com/forums/index.php?act…=ST&f=10&t=1339

And earlier this morning I wrote this one: http://www.webyog.com/forums/index.php?act…=ST&f=10&t=1423

Basically, in case the PK (or any other identification of the rows) are identical, the program needs af RULE to decide what to do. And that rule can only be described by a human. MySQL (or any Databaser Server) offers no mean to decide which of the rows are the “right one”. Timestamps are no good either since they with MySQL have only an “accuracy” of 1 (one) second. it's on the to do list at MySQL to introduce one ore more timestamp-formats with more accuracy (probably milliseconds)

You see that the SJA is constantly being discussed! But don't expect any computer program to do what a computer will never be able to do: to make human decisions and planning. It's your responsibily as a DB-Admin to organise data structure, procedures for updating the DB's etc.

As Ritesh wrote in the first thread: Any reasonable and practicable request can be implemented. What are your needs and your situation ?

[peterlaursen]

I guess I'll stick to the “latin1” character set! 😉

[peterlaursen]

There is a lot of bugfixes with each new release og Mysql ver. 5

http://dev.mysql.com/doc/mysql/en/news-5-0-4.html

http://dev.mysql.com/doc/mysql/en/news-5-0-5.html

http://dev.mysql.com/doc/mysql/en/news-5-0-6.html

With me Sqlyog works fine with MySQL 5.0.4. But it's not true what Ritesh writes, that SP-code can be executed fra the SQL-pane in SQLYOG. First: there is no support for DELIMITER command, second: the code is not recognized as SP-code (probably a problem with the library).

[peterlaursen]

I understand very well …

but I don't have access to the code og the program (and would not understand it anyway!). Ritesh hasn't been at the forum today, so he must be busy with something else. But I'm sure he will get himself involved ASAP 😉

[peterlaursen]

Hey – you could have said before that there was a proxy involved!

Probably Ritesh will answer here when he gets an opportunity. Probably he'll ask you for further details.

From “Notification Services” dialogue you can send a test-mail to check the SMTP-function. Does that work?

And do you get a mail with an error message or not ?

[peterlaursen]

It could very well be a time-out problem. I think Ritesh has promised that a user setting for the time-out interval or some other workaround will be added soon.

Do you experience trom time to time that connection establishes slowly with HTTP-tunnelling ? Basically I think it's a problem with some (mostly the very cheap) hosting providers, that database access has very low priority on their network.

[peterlaursen]

there still seems to be a problem with escape characters at this forum! 😮

Check if Check if your XML-file says (quotation)(bracket)columns all=(inner-quoatation)yes(end-of-inner-quotation) /(end-of-bracket)(end-of-quotation) even if you specify columns!

[peterlaursen]

there seems to be a porbelm with escape characters at this forum!

Check if Check if your XML-file says (quoatation)(end-of-quotation) even if you specify columns!

[Author]

Posts