System News
back1 2 3 4 5 6 7 8 9 10 11 next
Archived MySQL Articles
13 Jan 2017
open to premium members only
The Impact of Swapping on MySQL Performance [59684]
By Peter Zaitsev , January 13th, 2017

Peter blogs, "In this blog, I'll look at the impact of swapping on MySQL performance.

It's common sense that when you're running MySQL (or really any other DBMS) you don't want to see any I/O in your swap space. Scaling the cache size (using innodb_buffer_pool_size in MySQL's case) is standard practice to make sure there is enough free memory so swapping isn't needed.

But what if you make some mistake or miscalculation, and swapping happens? How much does it really impact performance? This is exactly what I set out to investigate..."
(Get More Information . .)

10 Jan 2017
open to premium members only
MySQL Connector/C 6.1.9 GA has been released [59685]
By Piotr Obrzut, January 10th, 2017

Piotr blogs, "A new GA (general availability) version of MySQL Connector/C has been made available: MySQL Connector/C 6.1.9 GA. The MySQL Connector/C provides a C API for connecting client applications to the MySQL Server 5.5 or newer...

MySQL Connector C (Commercial) will be available for download on the My Oracle Support (MOS) website. This release will be available on eDelivery (OSDC) in next month's upload cycle..."
(Get More Information . .)

10 Jan 2017
open to premium members only
What MySQL 8.0.1 means to you as a Developer [59686]
By Gabriela D'Avila, January 10th, 2017

Gabriela blogs, "Oracle released the development version of MySQL 8.0.0-dmr on September 12th of 2016. Since then, the team have been working on the 8.0.1 development milestone. You can find the partial change list here.

The objective here is try to explain how this will have any real world impact for you from 8.0.1. Please remember though, that any changes made to this version will not be final until the General Availability (date not currently set).

These topics are aimed at the Software Engineering side and not DBA and this is why Replication, for instance, is not covered here..."
(Get More Information . .)

10 Jan 2017
open to premium members only
MySQL Connector/C 6.1.9 GA has been released [59688]
By Piotr Obrzut, January 10th, 2017

Piotr blogs, "A new GA (general availability) version of MySQL Connector/C has been made available: MySQL Connector/C 6.1.9 GA. The MySQL Connector/C provides a C API for connecting client applications to the MySQL Server 5.5 or newer...

MySQL Connector C (Commercial) will be available for download on the My Oracle Support (MOS) website. This release will be available on eDelivery (OSDC) in next month's upload cycle.

We have improved the driver since the last GA release. Please see the documentation and the CHANGES file in the source distribution for a detailed description of bugs that have been fixed. Bug descriptions are also listed below..."
(Get More Information . .)

06 Jan 2017
open to premium members only
Easy-To-Use Perl Scripts To Backup Your MySQLl Database With Mysqldump And Ftp The Files To A Remote Server [59468]
By Tony Darnell, January 6th, 2017

Tony writes, "Most users of MySQL utilize the mysqldump utility to backup their database. While mysqldump is handy and easy-to-use (and free), if you have data which is important to your business, then you should take a look at the MySQL Enterprise Edition - and use MySQL Enterprise Backup instead. The MySQL Enterprise Backup allows you to backup your database without the table locking you get with mysqldump. And, it is extremely fast - especially when you have to restore your database. Here is a sample speed comparison between MySQL Enterprise Backup and using mysqldump:..."
(Get More Information . .)

06 Jan 2017
open to premium members only
Using MySQL to Output JSON [59470]
By Dave Stokes, January 6th, 2017

Dave, "MySQL has had a JSON data type since version 5.7 was released way back in '15. But did you know you could produce JSON output from non-JSON columns? It is very simple and saves a lot of time over trying to format it in your application.

World Database

We will be using the good old World database that MySQL has used for years in documentation, examples, and in the classroom. Starting with a simple query we will build up to something more complex..."
(Get More Information . .)

 
back1 2 3 4 5 6 7 8 9 10 11 next