SQL Zone | The social network for developers

Peter Zaitsev02/28/13
758 views
0 replies

MySQL optimizer: ANALYZE TABLE and Waiting for table flush

Before running an ANALYZE table or any other command listed before, check the running queries.

Peter Zaitsev02/28/13
1439 views
0 replies

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

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.

Peter Zaitsev02/27/13
1323 views
0 replies

Why do we care about MySQL Performance at High Concurrency?

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.

Peter Zaitsev02/25/13
593 views
0 replies

CentOS 5 users: your UTF-8 data is in peril with Perl MySQL

CentOS 5.8 and earlier use Perl module DBD::mysql v3.0007 which has a bug that causes Perl not to flag UTF-8 data as being UTF-8.

Peter Zaitsev02/25/13
659 views
0 replies

Solving RPM installation conflicts

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

Peter Zaitsev02/22/13
816 views
0 replies

MySQL 5.5 and 5.6 default variable values differences

As the part of analyzing surprising MySQL 5.5 vs 5.6 performance results I’ve been looking at changes to default variable values. To do that I’ve loaded the values from MySQL 5.5.30 and 5.6.10 to the different tables and ran the query:

Mitch Pronschinske02/22/13
4110 views
0 replies

DZone Links You Don't Want To Miss (2/22/13)

The JDK 8 dev preview is pushed back and Riak 1.3 is released. Plus, some uncommon opinions about the Agile Manifesto and Write Once, Run Everywhere.

Peter Zaitsev02/21/13
1042 views
0 replies

Mystery Performance Variance with MySQL Restarts

Based on a lot of surprising comments about my MySQL 5.5 vs 5.6 performance post I decided to perform deeper investigation to see where my results could go possibly wrong.

Mitch Pronschinske02/21/13
2890 views
0 replies

DZone Links You Don't Want To Miss (2/21/13)

Hadoop had a new alpha release and a new JDK managing tool for the command line is out. Plus, more war stories from the developer who worked at Blizzard games, and 18 API business models.

Giorgio Sironi02/20/13
2226 views
0 replies

Isolation in MongoDB

One of the properties put in question is isolation of operations from each other: while iterating on cursors, it's not a given. If you use MongoDB in production, you have to improve your knowledge of the database properties or write migration scripts that corrupt your data.

Oliver Hookins02/20/13
1345 views
0 replies

Asynchronous MySQL Queries with Non-Blocking Readiness Checks

I decided to automate a small part of some data analysis I’ve had to do a few times, starting with the database queries themselves.

Peter Zaitsev02/20/13
1190 views
0 replies

Using MySQL Sandbox with Percona Server

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.

Peter Zaitsev02/19/13
2069 views
0 replies

Get Real Data from the Semantic Web

Why I'm Leaving Heroku

Ubuntu is Coming to Smartphones: What Could You Use It For?

The 12 Best Books I Read in 2012