Blog

SQLyog MySQL GUI 12.18 Released

  • peter_laursen
  • December 29th, 2015
  • Releases, SQLyog
  • SQLyog MySQL GUI 12.17 Released

  • peter_laursen
  • December 28th, 2015
  • Releases, SQLyog
  • Changes as compared to 12.16 include:

    Bug Fixes:

    * Fixed a memory leak as well as a crash in ‘session restore’ when writing a restore point. This  was reported by a number of users. We were never able to reproduce these issues ourselves but a number of affected users have tested and confirmed the fix.
    * The formatter could add trailing space after specific keywords occuring at the end of a line.
    * In CSV exports there was an additional comma after each row while exporting a table if the last column was not selected for export.

    Miscellaneous:

    While exporting a table having BLOB/TEXT type column(s) to ‘fixed length CSV’, a warning message is displayed that this may result in truncation of data and user is given the choice whether to continue or not.

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

    MONyog MySQL Monitor 6.51 Has Been Released

  • peter_laursen
  • December 11th, 2015
  • MONyog, Releases
  • Changes (as compared to 6.5) include:

    Features:

    * RDS log monitoring feature can now be configured using the MONyog API.

    Bug Fixes:

    * The query SHOW ENGINE INNODB STATUS fails for MySQL version less than 4.1.2. and resulted in a MONyog crash. Even though we don’t recommend MySQL 4.1 (and not at all such early beta of it), we should not crash.
    * Fixed JavaScript errors for Query Analyzer and Real Time tab in Internet Explorer 8 (WinXP, Win2003).
    * With MariaDB 10.1.x MONyog erroneously listed all user accounts as having no password.
    * The curl library used could crash, and thus crash MONyog, when resolving too many hostnames at the same time.
    * Monyog failed to send ‘stable alert’ when both “notify till stable” and “notify when stable” options were enabled and if different values were set for the “send notification when alertable” and “remind me after every ..”.
    * Fixed the height of the Processlist display for each server. Each server’s processlist window is now displayed as scrollable window of fixed height. This is a regression fix and a revert of the page design to that of older versions. With recent versions it was necessary to scroll the browser window.

    Miscellaneous:

    * Upgraded SQLite library to v3.9.1. This results in ~25% performance improvement on most environments.
    * Renamed the “Row Access Statistics” counter to “Queries Executed” as it actually uses the ‘queries’ status variable. The old term confused some users.

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

    Beware of ‘virtual columns’ – they may render your backups unusable.

  • peter_laursen
  • November 9th, 2015
  • MySQL
  • Virtual columns have existed in MariaDB since version 5.2 and were recently introduced in MySQL 5.7. The recent MySQL 5.7.9 GA release includes this feature.

    At first look the implementations in MariaDB and Oracle/MySQL do not seem much different. If you compare documentation here and here you will see only that MariaDB uses the keyword PERSISTENT whereas MySQL uses the keyword STORED for same. There are also some minor differences on how virtual columns may be used in indexes. Those are all the differences you will notice from comparing the documentation of each.

    But there is one more and much more important difference – and this simple example illustrates this:

    CREATE TABLE `vc_test`.`t1`(
    `id` INT NOT NULL,
    `id3` INT AS ( id*3 ) VIRTUAL);

    INSERT INTO `vc_test`.`t1` VALUES (1,3);

    Now .. what will happen is:
    1) MariaDB inserts the row and issues a warning “The value specified for computed column ‘id3′ in table ‘t1′ ignored”.
    2) MySQL returns an error and nothing is inserted to the table.
    (for completeness, the described behavior of MariaDB applies to ‘non-strict’ SQL-mode only – what I think makes little sense).

    Further Oracle changed ‘mysqldump’ so that it will now generate INSERT statements like

    INSERT INTO `t1` (`id`) VALUES (1);
    .. and not as before
    INSERT INTO `t1` VALUES (1, 3);

    .. so that a dump of tables with virtual columns from 5.7.9 can be restored. However that only applies to the ‘mysqldump’ version shipped with MySQL 5.7.9 – not earlier versions (and on a side-remark, I wonder how much it slows down ‘mysqldump’ to check for virtuality of every column).

    Also this behavior breaks ‘restorability’ of backups generated by common GUI tools – including our own SQLyog – with such tables. Probably also phpMyAdmin and similar are now broken. You should verify any backup tool you use, generating backups as SQL scripts, carefully, if you upgrade to MySQL 5.7 and if you plan to use virtual columns. If you are using virtual columns with MariaDB you should ensure that backup scripts generated have set a non-strict sql-mode on top of the script.

    I created a bug report about this at http://bugs.mysql.com/bug.php?id=79148. I got the reply that the Oracle solution is compliant with SQL standards. Maybe so, but I find it very thoughtless and unfortunate that MySQL breaks 3rd party tools without any notice to users and vendors and with no transition period.

    Is there any community-awareness left in Oracle’s MySQL team at all?

    MONyog MySQL Monitor 6.5 Has Been Released

  • peter_laursen
  • November 4th, 2015
  • MONyog, Releases
  • Changes (as compared to 6.4) include:

    Features:

    * On Amazon RDS and Aurora, MySQL log files (Slow Query Log, General Query Log and Error Log) can now be read by MONyog. So Error Log monitoring is now possible here, and the Query Analyzer does not require logging to tables anymore. For this the Amazon “REST” API (and not SFTP) is used. Client functionalities for this API have been integrated into MONyog.
    * Added monitors for Galera: “Presence of non-InnoDB tables” and “Tables without a primary/unique key”.

    Bug Fixes:

    * Monitors and Real-time page failed to load on Internet Explorer 8 (highest IE option on WinXP) due to javascript errors.
    * Fixed a rare crash when connected to MySQL 5.7.6+.
    * Accessing Realtime interface could cause a crash if connection to the server was not available.

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

    SQLyog MySQL GUI 12.16 Released

  • peter_laursen
  • November 3rd, 2015
  • Releases, SQLyog
  • Changes as compared to 12.15 include:

    Features:

    * Schema Designer may now optionally use ‘portrait’ or ‘landscape’ layout for printing. Before only ‘portrait’ was available. Also page breaks may now be previewed.

    Bug Fixes:

    * With ChallengeResponseAuthentication’ set to “YES” in SSHD configuration, SSH tunnel from SQLyog would fail. This was introduced in 12.13 with the PLINK update here.
    * On Wine the color palette used for customizing colors of the SQLyog interface did not open.
    * In the Connection Manager .. MySQL tab, pressing ALT+V moved cursor to “keep alive interval” setting (last control of the tab) and not “saved connections” (first control of the tab).

    Miscellaneous:

    * The Import External Data tool would create indexes on BLOB/TEXT columns with an index prefix length of (only) 6 characters. This has been raised to 255.
    * SQL Server “UNIQUEIDENTIFIER” and Access “REPLICATIONID” data types are now migrated to a CHAR(36) and not CHAR(50) as before. This is for compability with how various applications and environments – including and most notably MS EntityFramework – expect data length of a Unique Identifier.

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

    MONyog MySQL Monitor 6.4 Has Been Released

  • Chetan
  • October 8th, 2015
  • MONyog, Releases
  • Important notice: With the 6.32 release we changed registration keys. Please have your new key available when upgrading from a pre-6.32-version. As always you will get it from our Customer Portal.

    Features (as compared to 6.34) include:

    Performance Schema is now available in Realtime
    MONyog can now capture all queries and display it in realtime which was not possible earlier with SHOW FULL PROCESSLIST output. To view all queries in realtime, make sure Performance_schema and ‘statements_digest’ table is enabled. If not, MONyog will display the output of SHOW FULL PROCESSLIST in realtime.

    To enable Performance schema, you need to edit the MySQL configuration file and add performance-schema=on under the [mysqld] section. Performance_schema is available with MySQL 5.6.14 and above.

    To enable the statement digests table, execute this query :

    UPDATE performance_schema.setup_consumers 
    SET enabled = 'YES' 
    WHERE name = 'statements_digest’; 
    

    Bug fixes
    Users with MySQL v5.6.3+ will now see explain plan for Insert, Update and Delete queries in Wayback Machine and Query analyzer.

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

    SQLyog MySQL GUI 12.15 Released

  • kartik.grover
  • October 7th, 2015
  • Releases, SQLyog
  • Changes as compared to 12.14 include:

    Features:

    * The search for the connections and databases is now faster and simpler, as it lists all the connections and databases which contain the typed phrase.

    Bug Fixes:

    * Schema synchronisation tool now functions by creating dummy tables in cases where views are built on another views.
    * Earlier SQLyog updated connrestore.db file even when there were no changes in the current session. This is now fixed.

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

    5 DevOps Conferences You Should Consider Attending

  • Chetan
  • October 7th, 2015
  • MySQL
  • DevOps Conferences-AWS-Reinvent

    We love developer conferences, they are informative, fun and a great way to network with like minded people. The sessions can help you and your organization discuss and address technology challenges, learn how others are solving problems and exchange knowledge. Even if you can’t make it, most of these conferences are streamed online. Here are the 5 DevOp conferences you should consider attending.

    AWS re:Invent

    The annual cloud conference, by market leaders themselves, is an event which is jam-packed and sold out, months before the actual event. Amazon Web Services (AWS) knows the importance of educating and constantly innovating on the cloud and encourages organizations to migrate their IT infrastructure to embrace the cloud. AWS re:Invent 2015 has a mammoth 313 sessions with 491 speakers. This event should top any DevOp’s list.

    DevOpsDays

    DevOpsDays is a two-day conference organized by local teams in each participating country. The highlight of every DevOpsDays is great presentations, open sessions and many amazing conversations to get a grassroot level view of what is going on in big companies. This event has something for everyone, regardless of whether you’re a beginner or an expert.

    PuppetConf

    PuppetConf, hosted by Puppet Labs is an event that focuses on IT automation. It packs 5 days of keynotes, demos, trainings, track sessions, networking opportunities and a chance to meet, discuss and get hands-on training from industry experts.

    O’Reilly Velocity

    O’Reilly Velocity, hosted at 4 locations across the globe, focuses on hard-core web operations, performance, optimization and more to help you build a faster and stronger business. This conference covers the entire spectrum of skillsets a DevOp needs to have and will leave you with a zillion ideas to improve your business, thanks to the hands-on learning and practical advice you will get, to build resilient systems at scale.

    Cloud Expo

    Cloud Expo is all about Cloud Computing, Big Data, SDDC, WebRTC, DevOps, Internet of Things (IoT), offering a great selection of technical and strategic industry keynotes, breakout sessions, 100+ exhibitors which offer solutions and strategies, 175+ sessions by industry experts, demo sessions, special events, giveaways and much more.

    Yes, this list is not exhaustive as there are many more great conferences, happening out there, like Monitorama, Percona Live, DockerCon to name a few. As it’s impossible to attend conferences, throughout the year, we have only featured the best. Let us know your stories and experiences about any recent DevOp conferences we’ve missed out on in this list.

    MONyog MySQL Monitor 6.34 Has Been Released

  • peter_laursen
  • September 7th, 2015
  • MONyog, Releases
  • Important notice: With the 6.32 release we changed registration keys. Please have your new key available when upgrading from a pre-6.32-version. As always you will get it from our Customer Portal.

    Changes (as compared to 6.33) include:

    Features:

    * Added more monitors and charts for monitoring a galera cluster. By default, these monitors are hidden. To display these monitors in Monitors page you can enable “Galera” monitor group from Customize -> Manage Monitor Groups. Charts for these new monitors can be enabled from Customize – > Manage charts.
    * Optimized system charts for faster loading.

    Bug Fixes:

    * EXPLAIN option was not available in Wayback Machine.
    * In some rare cases, MONyog logged SQLite errors if deadlock details contained double quotes.
    * In Wayback Machine interface, MONyog showed wrong time in queries tab when a point was selected in the chart.

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

    Page 1 of 4712345...102030...Last »