Blog

MONyog MySQL Monitor 6.3 Has Been Released

  • peter_laursen
  • May 20th, 2015
  • MONyog, Releases
  • Changes (as compared to 6.27) include:

    Features:
    * a log of long running queries can now be generated and downloaded as CSV in Sniffer interface (applies only to Processlist mode of sniffer).
    * Real-Time is optimized and loading a session is much faster now. Further it shows only data from top 200 open tables and databases.
    * Wayback Machine now includes user and host information as well.
    * Queries in Wayback Machine can now be exported as CSV.
    * MONyog can now send long running query notification to specific selected users only.
    * Wildcard filtering using the “*” character as wildcard for user and host is introduced in Sniffer (applies only to Processlist mode of sniffer).
    * Same wildcard filtering implementation is also introduced for Ignore user and host in Long running query option in Sniffer (applies only to Processlist mode of sniffer).
    * MONyog now logs which user killed a thread in Processlist tab.
    * SQLite library bundled in MONyog is now upgraded to the latest version. This results in performance improvement for sniffer in particular where it can be up to ~50%.

    Bug Fixes:
    * In some cases, MONyog logged SQLite errors when CSOs (Custom SQL Objects) were enabled even when the CSO worked as expected
    * Small UI fixes.

    Downloads: https://www.webyog.com/product/downloads
    Purchase: https://www.webyog.com/shop

    SQLyog MySQL GUI 12.12 Released

  • peter_laursen
  • May 19th, 2015
  • Releases, SQLyog
  • Changes as compared to 12.11 include: 

    Features:
    * XML files can now be imported from GUI controls in table menu/context menu provided that details of the XML follows one of the three supported XML-schemes supported by MySQL LOAD DATA XML syntax. This includes XML files generated with SQLyog and mysqldump.

    Bug fixes:
    * Server name in object browser was displaying wrong in some cases.
    * JSON export added in version 12.11 could add an extra delimiter what could cause an error in the environment where the JSON was used.
    * Profiler tab was getting focus instead of Messages tab in some cases if query was executed by placing cursor inside query and if more queries appeared in the Query tab and queries were executed ‘one by one’ (it did not happen when highlighting the query).
    * In ‘Export as’ dialog, SQLyog did not remember the escape character used if escape character was defined as “\\”. It would then replace “\\” with “\”.
    * In some cases SQLyog wasn’t displaying warnings for the query executed. Most common case was when a function was used with an argument of incorrect type causing server-side truncation of the argument (example: “SELECT ABS(‘a’);”)

    Miscellaneous:
    * Increased the dialog and column sizes for index and foreign key popup dialogs for better usability.

    Downloads: https://www.webyog.com/product/downloads
    Purchase: https://www.webyog.com/shop

    Life of a DBA in GIFs

  • Chetan
  • May 11th, 2015
  • MySQL
  • A Database Administrator experiences a wide range of emotions. It could be one those endless meetings, friendly disagreements with fellow developers, getting something approved from managers or preparing your junior DBAs for bigger battles. Each day is a challenging one. We’ve tried to compile a list of GIFs which every DBA will be able to relate to.

    5 minutes before deployment
    Life-of-a-DBA-GIFs-typing-fast

    Writing the most epic answer Stack Exchange has ever seen and press F5 to “Submit” and end up refreshing the page
    DBA-reactions-stack-exchange-refresh

    When a DBA.StackExchange answer gets 500+ upvotes!
    When-a-DBA.StackExchange-answer-gets-500-upvotes

    Slightly “re-factoring” the developers’ code after a code review
    re-factoring-the-developers-code-after-a-code-review

    Training the junior DBA
    Training-the-junior-DBA

    The junior DBA trying to figure out the production cluster
    The-junior-DBA-trying-to-figure-out-the-production-cluster

    When you unknowingly fix the client’s problem
    When-you-unknowingly-fix-the-client’s-problem

    When the project manager starts questioning my work estimates
    When-the-project-manager-starts-questioning-my-work-estimates

    When asked why I’m allowed to query all the databases?
    When-asked-why-I’m-allowed-to-query-all-the-databases

    When a developer says he made few changes to the database
    when-a-developer-says-he-made-few-changes-to-the-database

    When I shut off the marketing team’s access to run reports on the production server
    When-I-shut-off-the-marketing-team’s-access-to-run-reports-on-the-production-server

    PS: Don’t forget to visit DBA Reactions for a daily dose of GIFs chronicling the highs and lows of a DBAs life.

    If you’re not a DBA, make sure you share it with one and watch them nod their head in approval. If you have anything to share, feel free to use the comments section below.

    Rockstar DBA: An Interview with Manojit Paul

  • Karthik Suroju
  • April 30th, 2015
  • MONyog, MySQL, Rockstar DBA
  • Rockstardba
    This article is a part of our Rockstar DBA initiative, a platform for thought leaders to share their knowledge and make a positive contribution towards the database management community.

    Manojit Paul, with more than 19 years of professional DBA experience in enterprise database solutions, especially Sybase product set and database infrastructure is our first Rockstar DBA.

    Let’s hear from Manojit about how he manages MySQL databases, why he loves MONyog, his advice to young DBA’s and more.

    How do you manage your MySQL databases?
    We presently have 9 MySQL servers in production trading environment, all being managed via a host of automated scripts which I’ve created and manual intervention when issues are reported. We deploy MONyog for managing 5 of these critical MySQL instances.

    What are your biggest challenges when dealing with MySQL databases?
    MySQL is not real enterprise class (evident from Gartner Reports omissions) and the rest of our database infrastructure relies on Sybase ASE and replication platform used for actual trading and logistics. We do have selective schema replication in MySQL but lack of proper scaling and optimization is a challenge.

    How does MONyog help you? What’s your favorite feature?
    We deploy MONyog for the MySQL monitoring and its web based dashboard helps with quicker problem identification and resolution. What I really like about MONyog is the dashboard with real-time statistics along with the charts displaying the overall performance metrics.

    Do you use other tools to manage your MySQL servers?
    We do not use any other MySQL related tools except the dbadmin scripts I have written.

    According to you, what is the future of MySQL?
    I want MySQL to compete with Percona/MariaDB and keep up with the feature sets that are still missing, like object level replication and online database backups and more support for the community version too.

    What blogs/forums/magazines do you follow regularly?
    Gartner reports related to database technology
    DatabaseJournal
    DBTA
    SQLMAG
    ISUG (sybase)

    What advice can you offer to young enthusiasts who want to pursue a career as DBA?
    I personally follow these basic rules. Not sure who gave these to me, they are helping me all along my professional life.

    1. Assume nothing
    2. Have contingencies
    3. Simplify
    4. Plan and Execute with precision
    5. Strive for Zero Defect work

    We are thankful to Manojit Paul for sharing his thoughts with us. We would love to hear your feedback as comments about our Rockstar DBA initiative.

    Sharing is caring. If you are a DBA who has something significant to offer to the community, we welcome you to be our next Rockstar DBA. Just send an email to us at support@webyog.com

    SQLyog MySQL GUI 12.11 Released

  • peter_laursen
  • April 27th, 2015
  • Releases, SQLyog
  • Important notes: .
    This release requires that user re-enters his registration key. Please have it available when upgrading. The key itself is the same as used by previous 12.x versions.
    * This release includes a new HTTP tunneler script. Functions deprecated in recent PHP versions are not used anymore and the script now also follows PHP strict standards. Users using HTTP tunnel must replace the script on their server(s).

    Other changes as compared to 12.1 include: 

    Features:
    * Added option to export table data and result sets as JSON.

    Bug fixes:
    * On Windows systems using a recent wininet.dll, setting the HTTP timeout higher than 30 seconds had no effect and SQLyog would fire same query 3 times if HTTP tunneling was used and query executed on server for more than 30 seconds.
    * Fixed a performance regression with “execute SQL script”.

    Miscellaneous:
    The new icons and other graphics introduced in 12.1 now have slightly darker and brighter colors.  As a result the UI is now ‘less pastel’ than before.
    Changes in 12.1 to the ‘twilight’ theme (default before 12.1) have mostly been reverted due to user requests.
    * Visual Data Compare UI now has the same 12.1 -style overall look as the main program window etc. has.

    SQLite  was updated to version 3.8.8.3. This will result in performance enhancement of up to 80% for Autocomplete with large local SQLite databases.

    Downloads: https://www.webyog.com/product/downloads
    Purchase: https://www.webyog.com/shop

    MONyog MySQL Monitor 6.27 Has Been Released

  • peter_laursen
  • April 16th, 2015
  • MONyog, Releases
  • Changes (as compared to 6.26) include:

    Bug fixes:
    * MONyog no longer prompts the user to re-type the admin password while upgrading on Windows.
    * In Edit Server page it was possible to retrieve the MySQL password by inspecting JSON with browser’s javascript debugging module/plugin.
    * MONyog was not able to authenticate a user from LDAP group consisting of linked users (i.e. users with membership of more than one group).
    * Monitors page failed to load in case an empty group (with no counters) existed.
    * Replication tab failed to load after restart of a server when monitoring a master-master replication setup.

    Downloads: https://www.webyog.com/product/downloads
    Purchase: https://www.webyog.com/shop

    Introducing SQLyog 12.1 with a fresh modern design

  • Chetan
  • March 26th, 2015
  • MySQL, SQLyog
  • Rolling out a major design refresh to the most powerful manager, admin and GUI tool for MySQL and MariaDB. The aim of this release is to deliver a modern look and improve the overall SQLyog experience.

    With the redesigned SQLyog, you’ll get a fresh GUI without the need to relearn anything. Every pixel of the app has been retouched to improve both form and functionality.

    SQLyog with a fresh modern design

    We hope these little enhancements will make you fall in love with SQLyog all over again.

    Existing customers can download SQLyog 12.1 from Customer Area. To evaluate SQLyog 12.1, please download a 14-day trial.

    We are really excited about this update and we hope you enjoy the new look of your favorite MySQL GUI tool. Please feel free to share your feedback.

    Cheers,
    Team SQLyog

    15 Time-saving SQLyog keyboard shortcuts you need to know

  • Chetan
  • March 26th, 2015
  • MySQL, SQLyog
  • Developer’s best kept secret – learn to type really fast. If we could extend this secret a little further, a great developer should also add keyboard shortcuts to his repertoire to get work done at insane levels of speed. After all, we are typists first, programmers second.

    SQLyog supports a plethora of shortcuts. But, we’ve curated the most important ones that you need to memorize to become a SQLyog expert.

    Time-saving SQLyog keyboard shortcuts you need to know

    So, go ahead, download the cheat sheet, print it and have it in your workstation.

    Cheers,
    Team SQLyog

    MONyog MySQL Monitor 6.26 Has Been Released

  • peter_laursen
  • March 19th, 2015
  • MONyog, Releases
  • Changes (as compared to 6.25) include:

    Bug fixes:
    * When monitoring MySQL 5.6.3 and higher, MONyog reported false notification alert for ‘innodb_thread_sleep_delay’ when notifications for change in server configuration was enabled.
    * Replication page failed to show data if SHOW SLAVE STATUS on one server was hanging.
    * Server Config page was not always showing proper data when “show only changed values” is selected.
    * In some rare cases Monitors page was not displaying data after editing SSH tunnel details.
    * MONyog 32 bit build was not accepting port beyond 16-bit limit (> 2^16 – 1). This limit has been increased to handle full 32-bit range (up to 2^32 – 1).

    Miscellaneous:
    * Email Alerts in MONyog now contain Tag(s) and MySQL host of the corresponding server.

    Downloads: https://www.webyog.com/product/downloads
    Purchase: https://www.webyog.com/shop

    SQLyog MySQL GUI 12.09 Released

  • peter_laursen
  • March 2nd, 2015
  • Releases, SQLyog
  • Important note: With the 12.0 release we changed registration keys. The new key is available for registered users from our Customer Portal. Users upgrading from a pre-12.0 version should have the new key available before installing. Until SQLyog 12.x is registered with the proper key, it will only display the registration dialog.

    Bug fixes:
    * Fixed a crash on ALTER TRIGGER introduced in 12.08. This crash was due to unavailability of SHOW CREATE TRIGGER (in MySQL server before 5.1 or due to a MySQL Bug). The patch in 12.08 failed on such environments. We will now revert to old logic if SHOW CREATE TRIGGER is not available or returns an error or an empty string.
    * Same problem as listed above could cause a crash in Schema Sync.
    * Import External Data would map a MS SQL varchar(max) datatype to a MySQL ‘varchar’. The ODBC driver for MS SQL would then return an empty string for varchar(max) columns. We now map MS SQL varchar(max) to a MySQL ‘TEXT’ datatype as default.
    * On batch execution of queries the Query Profiler will now be disabled. Earlier SQLyog EXPLAINed first explainable statement in batch execution. This arbitrary choice has caused confusion, and in cases where the batch executed a DROP TABLE it could result in an error when a table referenced in EXPLAIN did not exist anymore.
    * SQLyog restricted user from entering a table comment of more than 60 characters. Now if user is using MySQL server >5.5.3+ he/she will be able to enter table comments up to 2048 characters.
    * Fixed a crash on “copy database to different host”. Only SQLyog Community was affected. This bug was introduced in SQLyog 11.52.

    Miscellaneous:
    * Fixed the Korean translation with patches contributed by a Korean user.

    Downloads: https://www.webyog.com/product/downloads
    Purchase: https://www.webyog.com/shop

    Page 1 of 4512345...102030...Last »