‘MySQL’ Category

Kill long sleeping connections

I have many servers that have applications that do not close connections properly or that use a connection pool. Sometimes I get a lot ...
Post on 31st of January 2010
Continue Reading...

What is “ACID “ Compliant?

Atomicity. In a transaction involving two or more discrete pieces of information, either all of the pieces are committed or none are. Consistency. A transaction either ...
Post on 20th of October 2009
Continue Reading...

Fast rebuild of a MySQL slave server.

We had to rebuild a slave, that mysteriously had the slave reset?!?! This environment is a single master and a single slave. The slave was ...
Post on 21st of September 2009
Continue Reading...

Memory Usage

These formula's will determine the total memory used. Used MySQL memory: key_buffer + max_connections * (join_buffer + record_buffer + sort_buffer + thread_stack + tmp_table_size) If innodb is enabled. max ...
Post on 10th of September 2009
Continue Reading...

Transferring large files between servers

In some of my environments I have to deal with large data sets that are well over 300GB. In this test I have a ...
Post on 1st of September 2009
Continue Reading...

What is MySQL

MySQL is a relational database management system. A relational database stores data in separate tables rather ...
Post on 25th of August 2009
Continue Reading...

Archives
- July 2010 (2)
- June 2010 (1)
- April 2010 (1)
- March 2010 (1)
- February 2010 (10)
- January 2010 (3)
- October 2009 (1)
- September 2009 (3)
- August 2009 (1)

Log In

Username
Password
	Remember Me Lost your password? Register

Translator
LinkedIn

Designed by: MySQL How 2

Switch to our mobile site