System News
back9 10 11 12 13 14 15 16 17 18 19 next
Articles for the keywords: MySQL
06 Jan 2017 Millions of Queries per Second: PostgreSQL and MySQL's Peaceful Battle at Today's Demanding Workloads [59469]
Percona, January 6th, 2017

Anastasia Raspopina and Sveta Smirnova blogs, "This blog compares how PostgreSQL and MySQL handle millions of queries per second.

Anastasia: Can open source databases cope with millions of queries per second? Many open source advocates would answer 'yes.' However, assertions aren't enough for well-grounded proof. That's why in this blog post, we share the benchmark testing results from Alexander Korotkov (CEO of Development, Postgres Professional) and Sveta Smirnova (Principal Technical Services Engineer, Percona). The comparative research of PostgreSQL 9.6 and MySQL 5.7 performance will be especially valuable for environments with multiple databases.

The idea behind this research is to provide an honest comparison for the two popular RDBMSs. Sveta and Aleksander wanted to test the most recent versions of both MySQL and PostgreSQL with the same tool, under the same challenging workloads and using the same configuration parameters (where possible). However, because both PostgreSQL and MySQL ecosystems evolved independently, with standard testing tools (pgbench and SysBench) used for each database, it wasn't an easy journey..."
(Get More Information . .) open to premium members only

04 Jan 2017 SQL vs. MySQL: Which Relational Database is Right for You? [59416]
Business 2 Community, January 4th, 2017

"Structured query language (SQL) is the language of relational databases. Several database platforms use SQL, but a slight variation on it - each tend to have a slightly different syntax. Microsoft SQL and MySQL are two of the most common database platforms on the web. Once you go with one, it can be very difficult to switch to the other. That's because the database platform you choose will end up being the core of your dynamic content moving forward. It stores, secures, and retrieves all the data for your applications.

It's an important decision to make, and will likely hinge on a few things. If you're having a hard time deciding which one is right for your project, here's a look at some similarities and differences between the two, SQL and MySQL..."
(Get More Information . .) open to premium members only

29 Dec 2016 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 . .) open to premium members only

29 Dec 2016 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 . .) open to premium members only

21 Dec 2016 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 . .) open to premium members only

back9 10 11 12 13 14 15 16 17 18 19 next

!-- end archive_section.tpl -->