Emergency

Search Results for: large database

Tokutek and PalominoDB Partner to Bring Scale, Performance to Database Deployments

by:

MySQL storage engine provider joins forces with leading database consultants to deliver support for growing number of MySQL and MariaDB customers Lexington, MA – (May 2, 2012) – Tokutek, the leader in high-performance and agile …

Read More
 

Which Linux distribution for a MySQL database server? A specific point of view.

One of the more common questions I get asked is which Linux distribution I would use for a MySQL database server. Bearing the responsibility for someone else’s success means I should advise something that is …

Read More
 

Challenges of Big Databases with MySQL – OOW11 Presentation

Many database management tasks become difficult as you move from millions of rows and gigabytes of data to billions of rows and terabytes of data. Such tasks include ingesting data while maintaining indexes; changing schemas …

Read More
 

Ask What Your Database Can Do for Your Country

by:

One of President John Kennedy’s most memorable phrases is “ask not what your country can do for you –  ask what can you do for your country”.  I got to thinking about this over lunch …

Read More
 

Database Insights from Archimedes to the Houston Rockets

by:

According to a recent MIT Sloan Management Review study, top performing organizations use analytics 5 times more than lower performers. That’s pretty astounding. And while we all know about the ocean/lake/waves/(your favorite water analogy) of …

Read More
 

Checking for a live database connection considered harmful

It is very common for me to look at a customer’s database and notice a lot of overhead from checking whether a database connection is active before sending a query to it. This comes from …

Read More
 

MongoDB Approach to database synchronization

I went to MongoSF today – quite an event, and I hope to have a chance to write more about it. This post is about one replication problem and how MongoDB solves it. If you’re …

Read More
 

When should you store serialized objects in the database?

A while back Friendfeed posted a blog post explaining how they changed from storing data in MySQL columns to serializing data and just storing it inside TEXT/BLOB columns. It seems that since then, the technique …

Read More
 

Fractal Trees May Be Useful for Making Energy-Efficient Databases

On April 9-10 the National Science Foundation hosted the Workshop on the Science of Power Management (SciPM 2009), where I gave an invited talk. Here I give a brief summary of my talk along with …

Read More
 

Finding out largest tables on MySQL Server

Finding largest tables on MySQL instance is no brainier in MySQL 5.0+ thanks to Information Schema but I still wanted to post little query I use for the purpose so I can easily find it …

Read More