Emergency

Search Results for: e=t

Compression Benchmarking: Size vs. Speed (I want both)

I’m creating a library of benchmarks and test suites that will run as part of a Continuous Integration (CI) process here at Tokutek. My goal is to regularly measure several aspects of our storage engine …

Read More
 

Scalr and MNPP

Good news for all Percona Software users out there. There are more ways how you can get access to Percona Software. If you’re using Scalr (See also Scalr Project on Google Code) you might be …

Read More
 

How to debug long-running transactions in MySQL

Among the many things that can cause a “server stall” is a long-running transaction. If a transaction remains open for a very long time without committing, and has modified data, then other transactions could block …

Read More
 

Hip To Be Square

by:

As Huey Lewis once noted, sometimes it’s “Hip To Be Square.” Apparently, occasionally, someone even pays attention to you when you are. Xconomy just featured “10 Boring Boston-Area Tech Companies That Are Actually Interesting” and …

Read More
 

Tokutek CEO talks to Wikibon about Big Data and MySQL

by:

John Partridge, President and CEO of Tokutek, sits down to talk about MySQL performance and scalability with the Wikibon Project’s Dave Vellante at last week’s MassTLC Big Data Summit. http://siliconangle.tv/video/tokutek-ceo-discusses-big-data-and-scaling-mysql

Read More
 

Logging MySQL queries from the client instead of the server

The “slow query log” is the single most valuable way to examine query execution on your MySQL server. Queries are logged with timing information, and in the case of Percona Server, a great deal of …

Read More
 

Scenarios where TokuDB’s Loader is Used

TokuDB’s loader uses the available multicore computing resources of the machine to presort and insert the data. In the last couple of posts (here and here), Rich and Dave presented performance results of TokuDB’s loader. …

Read More
 

Loading Tables with TokuDB 4.0

by:

Often, the first step in evaluating and deploying a database is to load an existing dataset into the database. In the latest version, TokuDB makes use of multi-core parallelism to speed up loading (and new …

Read More
 

Attempting to Quantify Fragmentation Effects

by:

We often hear from customers and MySQL experts that fragmentation causes problems such as wasting disk space, increasing backup times, and degrading performance. Typical remedies include periodic “optimize table” or dump and re-load (for example, …

Read More
 

Better Primary Keys, a Benefit to TokuDB’s Auto Increment Semantics

In our last post, Bradley described how auto increment works in TokuDB. In this post, I explain one of our implementation’s big benefits, the ability to combine better primary keys with clustered primary keys. In …

Read More