343 revisions after the 7.0 release follows the new 8.0 release
of HeidiSQL now.
Get it from the download page.
Here are the most noticable changes:
- Available in 23 languages now. Thanks to all translators and
Transifex hereby!
- Database tree: Introduce optional folders for tables, views,
routines etc.
- Introduce session folders in session manager.
- Make routine editor work on MS SQL servers.
- Support search and replace in data and query results.
- Add support for microseconds in temporal datatypes of MariaDB
5.3+ and MySQL 5.6.
- Introduce a query history, available in the right side helpers
box. Can be turned off.
- Implement grid export as PHP array.
- Host > Variables: Add "Global" column, and highlight values
different to their session pendant
- Add …
343 revisions after the 7.0 release follows the new 8.0 release
of HeidiSQL now.
Get it from the download page.
Here are the most noticable changes:
- Available in 23 languages now. Thanks to all translators and
Transifex hereby!
- Database tree: Introduce optional folders for tables, views,
routines etc.
- Introduce session folders in session manager.
- Make routine editor work on MS SQL servers.
- Support search and replace in data and query results.
- Add support for microseconds in temporal datatypes of MariaDB
5.3+ and MySQL 5.6.
- Introduce a query history, available in the right side helpers
box. Can be turned off.
- Implement grid export as PHP array.
- Host > Variables: Add "Global" column, and highlight values
different to their session pendant
- Add …
343 revisions after the 7.0 release follows the new 8.0 release
of HeidiSQL now.
Get it from the download page.
Here are the most noticable changes:
- Available in 23 languages now. Thanks to all translators and
Transifex hereby!
- Database tree: Introduce optional folders for tables, views,
routines etc.
- Introduce session folders in session manager.
- Make routine editor work on MS SQL servers.
- Support search and replace in data and query results.
- Add support for microseconds in temporal datatypes of MariaDB
5.3+ and MySQL 5.6.
- Introduce a query history, available in the right side helpers
box. Can be turned off.
- Implement grid export as PHP array.
- Host > Variables: Add "Global" column, and highlight values
different to their session pendant
- Add menu item for launching mysql.exe …
343 revisions after the 7.0 release follows the new 8.0 release
of HeidiSQL now.
Get it from the download page.
Here are the most noticable changes:
- Available in 23 languages now. Thanks to all translators and
Transifex hereby!
- Database tree: Introduce optional folders for tables, views,
routines etc.
- Introduce session folders in session manager.
- Make routine editor work on MS SQL servers.
- Support search and replace in data and query results.
- Add support for microseconds in temporal datatypes of MariaDB
5.3+ and MySQL 5.6.
- Introduce a query history, available in the right side helpers
box. Can be turned off.
- Implement grid export as PHP array.
- Host > Variables: Add "Global" column, and highlight values
different to their session pendant
- Add …
Early this year Oracle released MySQL 5.6 - Best MySQL Release Ever. This
release delivered not only quality, but also quantity in terms of
number of features. See a comprehensive list here . The blogs below also refer to the massive
changes introduced in 5.6
http://www.mysqlperformanceblog.com/2013/01/27/mysql-5-6-improvements-in-the-nutshell/
http://www.flamingspork.com/blog/2013/03/05/mysql-code-size/
It is no mean task to deliver so many features with high quality
that too for a feature rich product like MySQL. This was made …
Now that I'm back doing just database stuff, I've come to realize I've gotten a little sloppy about doing my homework. Homework's never been my favorite thing in the world, but it often reduces stress when your under the gun during an outage or upgrade...
We had a MySQL database server that's been slow on DML changes, and based on the slowest statements being 'COMMIT', we had a good mind
Percona is glad to announce the release of Percona XtraBackup 2.1.2 for MySQL on May 18, 2013. Downloads are available from our download site here and Percona Software Repositories.
This release fixes number of high-priority bugs since version 2.1 became GA. It’s advised to upgrade your latest 2.1 version to 2.1.2. This release is the latest stable release in the 2.1 series.
Bugs Fixed:
- Using Perl’s
DBD::MySQLpackage for server communication instead of spawning the MySQL command line client …
This week we explain performance_schema a bit deeper. In Ear Candy, we talk about max_binlog_cache_size and At the Movies presents Max Mether of SkySQL talking about "High Availability Solutions for MySQL".
Events
DB Hangops -
every other Wednesay at noon Pacific time
Upcoming MySQL events
The red carpet has been laid down at this Log Buffer Edition, and
you can witness and cheer the cat-walking blog posts from Oracle,
SQL Server, and MySQL. Every one of them is chic, elegant, and
sensual in its own right. Enjoy.
Oracle:
Create colored heat maps in SQL*Plus with Kyle Hailey.
Here’s a quick and dirty script to create a procedure (in the SYS schema – so be careful) to check the Hakan Factor for an object.
Connor has a good post about default null for collection parameter.
This is yet another blogpost on …
[Read more]
2013 is on it's initial months and we already have 5.6 GA and the
first release of 5.7, 5.7.1 DMR with lots of exciting new features, future is promising!
A new feature added in replication was the NONBLOCKING option to
SHOW SLAVE STATUS command.
In the past if we stop slave during a big transaction, until the
transaction was applied we cannot execute SHOW SLAVE STATUS to
see the slave progress. The latter operation would block until
the former finish, this would disable all external monitoring or
third-party applications that need a immediate response from
server.
To solve this problem, NONBLOCKING option was added to SHOW SLAVE STATUS, when it is used we can
obtain immediate response from server about slave progress. As a …