You searched for having mysql - Page 2 of 29

MySQL Backup tools used by Percona Remote DBA for MySQL

March 13, 2013 By Ryan Huddleston 8 Comments

As part of Percona Remote DBA for MySQL service we recognize that reliable backups are one of the most important things we can bring to the table. In my experience handling emergencies, the single worst thing that can happen is finding out you don’t have backups available when some sort of data loss or catastrophic [...]

Filed Under: Cloud and NoSQL, Insight for DBAs, Insight for Developers, MySQL Tagged With: Amazon S3, data loss, database outage, database performance, MySQL, MySQL Backup tools, Percona Remote DBA, Percona XtraBackup, Rryan Huddleston

MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark

March 11, 2013 By Justin Swanhart 7 Comments

So far most of the benchmarks posted about MySQL 5.6 use the sysbench OLTP workload. I wanted to test a set of queries which, unlike sysbench, utilize joins. I also wanted an easily reproducible set of data which is more rich than the simple sysbench table. The Star Schema Benchmark (SSB) seems ideal for this. [...]

Filed Under: MySQL Tagged With: InnoDB plugin, Justin Swanhart, MySQL 5.5, MySQL 5.6, Star Schema Benchmark (SSB), sysbench

InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By Ernie Souhrada 7 Comments

This is part 2 in a 3 part series. In part 1, we took a quick look at some initial configuration of InnoDB full-text search and discovered a little bit of quirky behavior; here, we are going to run some queries and compare the result sets. Our hope is that the one of two things [...]

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: Ernie Souhrada, FTS, FullText Search, InnoDB, MyISAM, MySQL 5.6

Percona Server on the Nexus 7: Your own MySQL Database Server on an Android Tablet

February 28, 2013 By Vadim Tkachenko 11 Comments

Following Roel’s post, Percona Server on the Raspberry Pi: Your own MySQL Database Server , I thought what other crazy gadget can I run Percona Server on? And having an Asus Nexus 7 Android tablet I decided to give it a try. Anything below contains a risk that you break your tablet if you do [...]

Filed Under: MySQL, Percona Software Tagged With: Android Tablet, Linux, MySQL Database Server, Nexus 7, Percona Server, Percona XtraDB Cluster, Vadim Tkachenko

InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By Ernie Souhrada 1 Comment

I’ve never been a very big fan of MyISAM; I would argue that in most situations, any possible advantages to using MyISAM are far outweighed by the potential disadvantages and the strengths of InnoDB. However, up until MySQL 5.6, MyISAM was the only storage engine with support for full-text search (FTS). And I’ve encountered many [...]

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: Ernie Souhrada, FTS, FullText Search, InnoDB, MyISAM, MySQL 5.6

Why do we care about MySQL Performance at High Concurrency?

February 26, 2013 By Peter Zaitsev 9 Comments

In many MySQL Benchmarks we can see performance compared with rather high level of concurrency. In some cases reaching 4,000 or more concurrent threads which hammer databases as quickly as possible resulting in hundreds or even thousands concurrently active queries. The question is how common is it in production ? The typical metrics to use [...]

Filed Under: Insight for DBAs, MySQL Tagged With: High Concurrency, MySQL Performance, Peter Zaitsev, Threads_Running

Solving RPM installation conflicts in CentOS 5 and CentOS 6

February 21, 2013 By Ignacio Nin 6 Comments

Lately we’ve had many reports of the RPM packages for CentOS 5 (mostly) and CentOS 6 having issues when installing different combinations of our products, particularly with Percona Toolkit for MySQL. Examples of bugs related to these issues are lp:1031427 and lp:1051874. These problems arise when trying to install a package from the distribution that [...]

Filed Under: MySQL Tagged With: CentOS 5, CentOS 6, Ignacio Nin, lp:1031427, lp:1051874, RPM installation conflicts, RPM packages

Percona MySQL University comes to Toronto on March 22

February 18, 2013 By Peter Zaitsev 2 Comments

Following our events in Raleigh, Montevideo, Buenos Aires, Percona MySQL University comes to Toronto on March 22nd. This is going to our most dense event yet, absolutely packed with information. Even though we have just 1 track we have 12 talks and 11 speakers. We had unique opportunity this time because Percona’s Consulting, Support, RemoteDBA, [...]

Filed Under: Events and Announcements, MySQL, Percona MySQL University Tagged With: MySQL Clustering, MySQL High Availability, MySQL Replication, Percona MySQL University, Peter Zaitsev, Toronto

Is MySQL 5.6 slower than MySQL 5.5?

February 18, 2013 By Peter Zaitsev 23 Comments

There have been a number reports/benchmarks showing MySQL 5.6 to be slower than MySQL 5.5 on variety of workloads. There are many possible reasons and I believe we will learn about many of them in the next few weeks and months as MySQL 5.6 is starting to get production battle-tested and there is inflow of [...]

Filed Under: MySQL Tagged With: MySQL 5.5, MySQL 5.6, MySQL 5.6 Optimizer, Peter Zaitsev

Using MySQL Sandbox with Percona Server

February 16, 2013 By Peter Zaitsev 3 Comments

One of the most useful tools if you’re working with multiple versions of MySQL Servers is MySQL Sandbox which allows you to maintain many different versions of MySQL, Percona Server, MariaDB. If you’re just working with single sandbox you can just use MySQL Sandbox in its most basic way and it will work:

root@smt2:~/sandboxes# make_sandbox /tmp/Percona-Server-5.5.29-rel29.4-401.Linux.x86_64.tar.gz
unpacking /tmp/Percona-Server-5.5.29-rel29.4-401.Linux.x86_64.tar.gz
Executing low_level_make_sandbox --basedir=/tmp/5.5.29 \
        --sandbox_directory=msb_5_5_29 \
        --install_version=5.5 \
        --sandbox_port=5529 \
        --no_ver_after_name \
        --my_clause=log-error=msandbox.err
...
no_run                         =
no_show                        =
do you agree? ([Y],n) Y
loading grants
... sandbox server started
Your sandbox server was installed in $HOME/sandboxes/msb_5_5_29

root@smt2:~/sandboxes# make_sandbox /tmp/Percona-Server-5.5.29-rel29.4-401.Linux.x86_64.tar.gz

unpacking /tmp/Percona-Server-5.5.29-rel29.4-401.Linux.x86_64.tar.gz

Executing low_level_make_sandbox --basedir=/tmp/5.5.29 \

--sandbox_directory=msb_5_5_29 \

--install_version=5.5 \

--sandbox_port=5529 \

--no_ver_after_name \

--my_clause=log-error=msandbox.err

...

no_run =

no_show =

do you agree? ([Y],n) Y

loading grants

... sandbox server started

Your sandbox server was installed in $HOME/sandboxes/msb_5_5_29

However [...]

Filed Under: MySQL Tagged With: MariaDB, MySQL Sandbox, Percona Server

MySQL Backup tools used by Percona Remote DBA for MySQL

MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark

InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

Percona Server on the Nexus 7: Your own MySQL Database Server on an Android Tablet

InnoDB Full-text Search in MySQL 5.6 (part 1)

Why do we care about MySQL Performance at High Concurrency?

Solving RPM installation conflicts in CentOS 5 and CentOS 6

Percona MySQL University comes to Toronto on March 22

Is MySQL 5.6 slower than MySQL 5.5?

Using MySQL Sandbox with Percona Server

Search

Top Searches

Percona Webinars

ABOUT PERCONA

Percona MySQL Training

Percona Careers

SOFTWARE FROM PERCONA

SERVICES FOR MYSQL USERS

ABOUT THIS BLOG AND PERCONA