We have one developer assinged with fixing suability issues like this. Around 30 of those (but I do not think the ones you reprot here) will be fixed in version 7.0 beta1 to be released in a few days. And we plan to continue having resources allocated to this for yet some time with priority on:
1. ability to stop long-running task (where not possible today)
It looks wierd, but I will let the MONyog team comment tomorrow.
Anyway 2.06 stable and 2.5 beta 2 have been released. I think you should consideer an upgrade. I don't know if this is an issue that has been fixed though! For me 2.5 beta2 works fine, but I do not have the same data!
I think it is coincidental that you notice the change now. There was no/should not be any change since 6.5
My best guess is that this slowness occurs with databaes having large INNODB tables? It is a know INNODB issue/bug that SHOW TABLE STATUS statement is slow then. Can you confirm this?
.. I described a 'workaround': defining the PK as a multicolumn PK including a column with a host-specific constant.
another solution is to use a auto_increment_increment and auto_increment_offset settings in configuration if the MySQL server supports it (even numbers for one host, odd number for the other (if there are only two)). Refer to:
I do not know what is going on! This is not reproducable for us.
Those operatins start a new connection however. Maybe the server 'connections pool' is filled upd and not more connectiosn are allowed. Can you check this, please? or you may restart the MySQL server (if you have privileges to do so).
Alternatively please try to describe in details how to reproduce this.
Important information could be:
1. What type of connection whether direct, http or ssh connection?
2. How large are the databases?
Also if you have both versions installed at the same time, is this probelm reproducable with latest only?
What kind of file are you referrring to? a SQL file?
Also I do not think that MSSQL (the server) does anything like that. It must be some client that does!
You find similar functionality in cetain text editors like PSPAD for instance. This is no bad request. Actaully we only need to compare the timestamp of the file when it was opened with the current timestamp from filesystem I think.
It seems that the MySQL user running this job does not have some required privileges on the database you import to!
Please try (from SQLyog ..tools .. user manager .. manage permissions) to check all checkboxes for the combination of user and database. Also be sure that you grant privileges for user with the correct host descriptor (like if there is both a user@localhost and a user@% user!).
To see current privileges execute “SHOW GRANTS FOR 'user'@'host'”
One guess could be that you let the Migration Toll create tables onand user does not have CREATE privilege for that database.
Alos note that if the MySQL database is located at an ISP, you may not be able to use SQLyog User Management, but may need to use a web-based Control Panel application to manage user privileges.
Actually if you have more query tabs each has it's own set of result (and messages) tabs. Try this:
Open two query tabs. In the first execute
Code:
select 1;
select 2;
in the second execute
Code:
select 'a';
select 'b';
now switch between the two query tabs .. If that was not what 1st point was about I do not understand!
2)
You request that a query tab with all its children can be undocked (using my term) and even positioning on another monitor?
3)
We are considering modality (for CREATE/ALTER table, wizards etc). It is a major code change and it wil take some time but it is also a prerequisite for reziability what we realise that we need to solve to support both small and large monitor resolutions properly.
I think the developement environment that we use do not allow for it. SQLyog is pure WIN32 API C++ programming.
We want to
* stick to C/C++ to avoid wrapper code when connecting to MySQL
* stick to the API (and no WFC for instance) for several reasons (performance, compactness and Wine/Linux compability).
* and VB, Delphi, JAVA and whatever depends on 3rd party runtimes/virtual machines is out of question here. In the very long term it is not impossible that C#/Mono will find its way into SQLyog. But that is also all I can imagine!
Anyway .. any other common program that you can refer to? (I know 'Chessbase' myself that can dock/undock panes in every user defined position – but that is a reather special program).
1) the 'scheduled backup' ('power')tool (included in Enterprise version only) has more more options than the 'export' tool, like
* file-per-table option
* select encoding for DUMP
* use timestamp for naming files
* export 'all databases' and 'all user databases'
* can be (but need not be) scheduled
* finally is XML-driven and can be executed (and even configured) from another application, script and batch file.
2) paste UPDATE and DELETE templates will be added in version 7.0 beta 1 (it is in our internal test build already). How could you propose a template for ALTER (TABLE). I think it is not really possible to have a meaningfull template here. And DROP is just plain DROP.
I think what DQ writes applies to any auto_increment key .. whether PK or not!
But if another type of column (like a string column) is used as the PK, then it will not necessarily be 'unique in system life time'.
In practical life and in 99% of cases the auto_increment key will be the PK too. Renumbering can be done (if there are no Foreing Keys on it of course), but only if and when the upper value limit for the column type has been reached and if there a 'holes' in the numbering there is normally any reason to do.
Also, I do no want to interfere in your discussion on this, however there is one other important difference between a PK and a Unique Key: A Unique Key may have NULL values and even more rows may have a NULL value for a Unique Key column. So a Unique Key is actually non-unique for rows containing such NULL values (I think that applies from MySQL 4.1 only .. and is similar to UK implementation in most other RDBMS (but I have been told that SQL standards are ambigous on this actually!)).
Author
Posts
Viewing 15 posts - 2,911 through 2,925 (of 7,398 total)