|
Planet MySQL
|
Planet MySQL - http://www.planetmysql.org/
|
-
Celebrating 10 years with MySQL – releasing SQLyog 10.0 GA
Hello,
We are delighted to announce the release of SQLyog 10.0. The version number makes this release very special. We must say the journey from SQLyog 1.0 to 10.0 was very exciting and rewarding. SQLyog was first released in 2002 as a MySQL GUI. Now we are a decade away from the first release. During the course of time, we have introduced tons of features taking SQLyog beyond the definition of a GUI. We couldn’t have done it without your encouragement and patronage. A big thank you for being with us in this endeavour.
Listed below are the features and enhancements introduced in this release:
Refreshing modern looks. We redesigned the user interface with a soothing color palette. We call it Twilight. You can also design your own themes and there is an option to switch to your default desktop theme as well.
The data tab is now moved to the upper pane. With this, all important tabs are in the upper pane and you can see more of what you want to see, and more than one table data can be opened under the same connection.
Schema synchronization logic is optimized and now it is up to 100 times faster for large schemas.
Introduced many keyboard shortcuts for power users.
Added an option for multi-column sorting and filtering of table data.
Many more usability enhancements and bug fixes.
Please refer to the version history for detailed release notes.
SQLyog customers can download SQLyog 10.0 GA from the Customer Area. Please make sure to get the new registration keys for SQLyog 10.0 from the Customer Area.
To evaluate SQLyog 10.0 GA please download a 30-day Trial.
We are very excited about this release, and hope that you will like it. We would love to hear from you!
Cheers,
Team SQLyog
Tweet
-
Intel Xeon E5-2670 gives 56% higher throughput than Intel Xeon X5670
Intel provided us with a chance to try out the new Intel Xeon E5-2670 in a large cluster set-up to compare it against the previous Intel generation, the Intel Xeon X5670. We compared two similar set-ups for MySQL Cluster with 4 data nodes, each node was configured in a realistic production set-up. With Intel Xeon X5670 we achieved 9.77M reads per second in this set-up and with Intel Xeon E5-2670 we achieved 15.2M reads per second. A healthy 56% speedup.The speedup comes from three factors. The first factor is that the Intel Xeon E5-2670 have 33% more cores (8 vs. 6). The second factor is that more cores gives us greater flexibility in configuring MySQL Cluster and we can actually configure 50% more threads per data node. The third factor is that each Intel Xeon E5-2670 core is actually faster than the Intel Xeon X5670 cores although they execute on a lower clock frequency.
-
Debugging MySQL Stored Routines with Hopper: preview video!
After releasing the first versions of Hopper for Firebird and Hopper for InterBase, the work on Hopper for MySQL continues.
Hopper is our Stored Routine debugger available for Firebird, InterBase and MySQL. With Hopper you'll be able to debug Stored Procedures, Functions and Triggers.
Click here for a preview video of Hopper for MySQL or here for the Hopper website.
-
Galera Cluster Support and Consulting Services from CAPSiDE
-
Manage hierarchical data with MySQL stored procedures
Below you will find all code to create the table and the stored procedures to manage hierarchical trees in MySQL. All code is documented and can be downloaded in a zip file.
|
