Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Forum Replies Created

Viewing 15 posts - 2,971 through 2,985 (of 7,398 total)
  • Author
    Posts
  • in reply to: #26461
    peterlaursen
    Participant

    I understand it like you request a two-level authentication – as 'admin' and 'user' (and the 'user' may (if 'admin' configures it so) even connect without password. Correct?

    in reply to: #26460
    peterlaursen
    Participant

    yes ..

    You can only use the keyword “CURRENT_TIMESTAMP” (and synonyms like “now()”, “localtimestamp” etc.) for a TIMESTAMP once in a table definition. To SET it now() from an application, one way is to declare it NOT NULL and insert NULL from the application. As NULL is not allowed due to definition it will become now()!

    DATETIMES only accept datetime string constants like 'yyyy-mm-dd hh:mm:ss' as defaults, Not sure if DATETIMES support the NOT NUL/NULL trick, but you can easily test that!

    in reply to: #26458
    peterlaursen
    Participant

    relevant FAQs:

    http://webyog.com/faq/content/8/159/en/how…light=timestamp

    http://webyog.com/faq/content/8/116/en/can…light=functions

    http://webyog.com/faq/content/8/99/en/does…ghlight=keyword

    To support functions – like now() – in the grid you will need a recent version!

    What version is your 'probably old version' ?

    But simplest is to create a TIMESTAMP field (not a DATETIME) and define it like:

    NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP

    A trigger in MySQL cannot 'act upon' the table ON which it is declared. It is a MySQL restriction – not a SQLyog restriction.

    PS: yes, cheap, right? 🙂

    in reply to: #26424
    peterlaursen
    Participant

    1) Does *local* mean local machine or local network?

    2) Are both databases on the same server?

    3) Can you attach the my.ini/my.cnf for that/those server installation(s)?

    4) It would be nice if we could have the exact structure as you have. Then we can be 100% sure that our measurements are comparable. For instance it may be important if ENGINE is MyISAM or INNODB.

    5) As you have “a dual – dual core zeon (ie 4 cores) machine” I would gues that you have quite a lot of RAM too? (but MySQL does not scale well for multi-cores if there is only the server and a single connection running (and that is also ENGINE dependent).

    6) I think I will not have to ask you to test while no other connections add significant load and no otehr programs are disk intensive at test time?

    Actually with this server you have query profiling. So you can try as described here:

    http://dev.mysql.com/doc/refman/5.0/en/show-profiles.html

    First “SET profiling = 1” , next run Structure Sync and finally “SHOW PROFILES” and “SHOW PROFILE FOR QUERY “.

    Actually we should do this too, now this option is there! I think we will be able to see what statements take time, and we should then try to aviod those as much as possible!

    Also you posted this in the MONyog category. I will move you to the SQLyog category!

    BTW: Did you try MONyog? Maybe it will point to some server configuration problems …

    in reply to: #26422
    peterlaursen
    Participant

    You noticed yourself that there is very little load on the computer where SQLyog runs.

    So slowness may be due to server configurations or due to the connection.

    I think SQLyog is waiting for data to 'arrive' most of the time!

    Please tell:

    *Are one or more servers remote servers?

    *Are you in control of server configuarations or are one or more servers at an ISP where configuration is not accessible for users?

    *Do you have other type of objects than tables (like Stored Procedures)? (if we need to query Information_Schema some server versions – early 5.0.x in particular – are very slow!)

    * What are EXACT server versions?

    * What is the SQLyog version you are using now?

    We are rewriting Structure Sync for SQLyog version 7.0. If there is something we can do we will do it now. We need a structure-only dump (no data) from both databases to work with. Can you create those, zip into one file and attach? You may create a support ticket if you want privacy or if file size is larger than what this Forums allows for. It is important the you ZIP – both because of the file size but also because .sql files are rejected here (to project other users against malicious users).

    Also you can try yourself (if not already the case) to import both the structure dumps to two different databses on a local server and experiment with server configuration (use the various configuration file templates shipped with the server).

    in reply to: #26419
    peterlaursen
    Participant

    did you read this FAQ?

    http://webyog.com/faq/content/16/4/en/do-i…with-mysql.html.

    I do not understand “Can I use any of the PHP commands to do things …”. You use SQL commands, not PHP commands to read or manipulate the database. SQL commmands may be embedded in any language that can connect to MySQL. Not Only PHP, but ASP(.NET), RUBY, PERL, C/C++, JAVA, Delphi(Pascal). The 'parent' language does not really matter – it is the SQL that does.

    Am I missing something?

    1)

    To select the no. of rows:

    With Notification service you can “SELECT COUNT(*) FROM a_table” or “SELECT COUNT(some_column) FROM a_table”

    2)

    This “Any way to list all rows added to a table since the last time the notification was run”. You can have a strings column and notifcation can exectute basically 2 statements

    SELECT … FROM a_table WHERE some_column <> 'seen_before'.

    UPDATE a_table SET string_column = 'seen_before' {WHERE string_column <> 'seen_before'

    (don't forget to mail the results of the SELECT statement)

    But you will have to tlet the Nofofications job wirte to the database You may also use a TIMESTAMP column a similar ways

    All those questions are SQL questions basically if I understand correctly.

    in reply to: #25557
    peterlaursen
    Participant

    Our test case is 500,000+ rows … and it works fine for us with every hardware/driver combination we have tried.

    But let us try if we can use this additonal information somehow!

    in reply to: #26417
    peterlaursen
    Participant

    We do plan to highlight the active row (the one where cursor is selected). Probably by using a light background color for that row. Maybe even 'light green' if no changes need to be save and 'light red' if some changes need to be saved.

    You find a similar request here:

    http://www.webyog.com/forums//index.php?showtopic=3765

    The entry in our issue tracker is here:

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

    One developer has been assigned with this and – I would guess – around 20-30 – similar small but important usability issues that will take each around 4-16 hours to complete.

    in reply to: #26416
    peterlaursen
    Participant

    'smart keywords/functions/defaults handling' must be enabled in 'preferences'.

    If you set to NULL from the context menu of a cell the string “(NULL)” will simply by inserted in the grid. And if 'smart keywords/functions/defaults handling' is disabled what would insert the literal string '(NULL)' and not NULL. That is the reason that we 'grey out' if 'smart keywords/functions/defaults handling' is OFF.

    in reply to: #25555
    peterlaursen
    Participant

    First try here with a Logitech mouse did not reproduce the problem.

    Can you please tell the exact mouse model and the driver version?

    Did you check if there is an updated driver here: http://www.logitech.com/index.cfm/support_…oads/downloads/

    I assume you are using a Logitech driver to support additional 'smart' features of the mouse. Anyway the basic features of the mouse may work with the native mouse driver of the OS. Could you try?

    in reply to: #26415
    peterlaursen
    Participant

    This is a SQLyog question – not a MONyog question.

    I am moving you to the correct category!

    Also you should always tell the SQLyog version!

    Anyway to get the list of tables of a database from the server, SQLyog sends this SQL:

    Code:
    show table status from `the_database` where engine is not NULL;

    Try executing that statement yourself with current user and privileges. I think it will fail to return the list of tables too?

    If the server won't tell there is nothing we can do!

    We had similar reports before and it was always a privilege issue on the server/a mistake when installing or upgrading MySQL.

    The server administrator will have to solve this.

    in reply to: #25887
    peterlaursen
    Participant

    hello ..

    We have improved SJA data sync wiht BIGINT PK is the 6.53 RC2 release.

    We also built the Linux SJA.

    You can take from here:

    http://www.webyog.com/downloads/betas/not_…d/sja653.tar.gz

    We would appreciate if you would evaluate it.

    in reply to: #26409
    peterlaursen
    Participant

    If you are connecting to localhost then MESSAGES and HISTORY may be the same with very fast queries as there is no significant connection 'overhead'. First, second and third TIMESTAMP could be the same millisecond. Does this explain?

    I tried executing a 'not-trivial' query to localhost (changing a table from MyIsam to InnoD:cool::

    Code:
    alter table mytable engine = innodb

    now

    HISTORY displays

    /*[13:21:27][ 374 ms]*/ alter table mytable engine = innodb ;”

    and MESSAGES:

    (515 row(s)affected)

    (0 ms taken)

    So here the MySQL server requiered almost 0.4 second to write data to the InnoDB tablespace, delete the MyIsam files and update whatever system tables and logs needed to be updated. HISTORY tells. MESSAGES tell that communication overhead between server and client is neglible with this connection.

    As regards the Formatting request:

    We have not had a team assembly since your first post but you can tell if you think it would be sufficient to do this formatting/calculation in the Status Bar?

    in reply to: #25554
    peterlaursen
    Participant

    Ok — then I think we will need to check against some Logitech hardware and driver.

    in reply to: #26407
    peterlaursen
    Participant

    this FAQ explains what we are doing currently:

    http://webyog.com/faq/content/8/147/en/how…light=execution

    We display the execution time for individual statements, not for 'batches' …

Viewing 15 posts - 2,971 through 2,985 (of 7,398 total)