System News
back2 3 4 5 6 7 8 9 10 11 12 next
Archived MySQL Articles
29 Dec 2016
open to premium members only
Percona Live Featured Tutorial with Oystein Grovlen - How to Analyze and Tune MySQL Queries for Better Performance [59320]
Percona, December 29th, 2016

"Welcome to another post in the series of Percona Live featured tutorial speakers blogs! In these blogs, we'll highlight some of the tutorial speakers that will be at this year's Percona Live conference. We'll also discuss how these tutorials can help you improve your database environment. Make sure to read to the end to get a special Percona Live 2017 registration bonus!

In this Percona Live featured tutorial, we'll meet Oystein Grovlen, Senior Principal Software Engineer at Oracle. His tutorial is on How to Analyze and Tune MySQL Queries for Better Performance. SQL query performance plays a big role in application performance. If some queries execute slowly, these queries or the database schema may need tuning. I had a chance to speak with Oystein and learn a bit more about the MySQL query tuning:.."
(Get More Information . .)

29 Dec 2016
open to premium members only
MSSQL To MySQL Data Migration Using MySQL Workbench 6.3 [59324]
By LALIT, December 29th, 2016

LALIT blogs, "Recently I was testing data migration from MSSQL to MySQL using MySQL Workbench. My aim was to include data with all datatype available in MSSQL for migration. In this following blog post will see data migration prerequisites, migration steps and few common errors..."
(Get More Information . .)

27 Dec 2016
open to premium members only
How to Perform Efficient Backup for MySQL and MariaDB [59326]
By Ashraf Sharif, December 27th, 2016

"All backup methods have their pros and cons. They also affect database workloads differently. Your backup strategy will depend upon the business requirements, the environment you operate in and resources at your disposal. Backups are usually planned according to your restoration requirement. Data loss can be full or partial, and you do not always need to recover the whole dataset. In some cases, you might just want to do a partial recovery by restoring missing tables or rows. In this case, you will need a combination of Percona Xtrabackup, mysqldump and binary logs to cover the different cases..."
(Get More Information . .)

21 Dec 2016
open to premium members only
MySQL on AWS: RDS vs EC2 [59157]
By Gabriel Ciciliani, December 21st, 2016

"When moving your MySQL instances to AWS, you would probably have to deal with this decision. This article will highlight some of the key factors that need to be considered in order to help you determine which is the most cost-effective solution for serving your data..."
(Get More Information . .)

20 Dec 2016
open to premium members only
The Choice of MySQL Storage Engine and Its Impact on Backup Procedures [59162]
By Ashraf Sharif, December 20th, 2016

"MySQL offers multiple storage engines to store its data, with InnoDB and MyISAM being the most popular ones. Each storage engine implements a more specific set of features required for a type of workload, and as a result, works differently from other engines. Since data is stored inside the storage engine, we need to understand how the storage engines work to determine the best backup tool. In general, MySQL backup tools perform a special operation in order to retrieve a consistent data - either lock the tables or establish a transaction isolation level that guarantees data read is unchanged..."
(Get More Information . .)

19 Dec 2016
open to premium members only
Binary Log Growth Handling in MySQL [59164]
By Andrew Grimo, December 19th, 2016

"So today we look at an aspect of capacity management or planning and how it relates to MySQL and its Logging. For this blog I'm primarily going to look at MySQL's binary logs. They have a tendency to grow, and will continue to if not held in check. Happily, they tend to be easy to manage. Let's look..."
(Get More Information . .)

 
back2 3 4 5 6 7 8 9 10 11 12 next