Everything MySQL

A great place to be!

Getting together and talking about everything MySQL!

Events

Latest Activity

Mark R commented on Chris's blog post 'Fast restore one database from a dump of ALL databases'
That is extremely useful, I wish I'd known this recently (did a full restore which took *ages* to recover just one column in one table)
on Wednesday
Chris added a blog post
There have been times that I needed to restore one database from a dump file that contains all of the databases from the server. There are a few ways to accomplish this goal. One way would be to grep through the entire file for the table schema an...
on Wednesday
rcs is now a member of Everything MySQL
Welcome Them!
November 14
Chris added a blog post
A can do method to consolidate table spaces without a full dump out and reload is to use cat. At first I did not think this would work in all cases, and am still not certain for ALL cases; however, I set up a quick and easy test just to see. Exam...
November 13
Gabe Tucker and Åke mellin joined Everything MySQL
November 13
A blog post by Chris was featured
It has been the responsibility of the DBA to implement a security strategy, at least on the database level. All DBAs should take action, if not already, by taking a proactive approach to this crucial part of database administration. For this post ...
November 12
A blog post by Sarah Sproehnle was featured
Over and over I see customers that don't understand what int(11) really means. Their confusion is understandable. Many know what defining a char(10) means (a fixed-sized character string that allows up to 10 characters). However, ints are differen...
November 12
Chris left a comment for Mahendra Pratap
November 12
Mahendra Pratap the curiosity to know everything about MySQL brought me to everythingMySQL!
November 12
Mahendra Pratap and anmol prakash gautam joined Everything MySQL
November 12
Jonathan Levin is now a member of Everything MySQL
Welcome Them!
November 10
Chris added a blog post
A very interesting problem came up a while back when testing a rebuild and failover procedure. I had just run a rebuild of a slave server with InnoDB Hot Backup from the master. After the failover, one query on three tables in three different data...
November 9
Sarah Sproehnle commented on Sarah Sproehnle's blog post 'Partitioning by dates: the quick how-to'
FYI, there was a bug (fixed in the upcoming release of 5.1.41) that caused bad execution plans because the index statistics of only the first partition were used: http://bugs.mysql.com/bug.php?id=44059
November 9
Sarah Sproehnle left a comment for Glynn Durham
November 7
Chris left a comment for Daniel Brehm
November 6
Daniel Brehm is now a member of Everything MySQL
Welcome Them!
November 6

Members

  • Stephen Sproehnle
  • Roland Bouman
  • LinuxJedi
  • Keri
  • Andree Bryan
  • Mark R
  • Chris
  • CentDev
  • hyland
  • Wendy Johnson
  • Emmy Owens
  • Sheeri Cabral
  • Tom Whiteley
  • Daniel Brehm
  • Gabe Tucker
  • Olaf Stein
 

Blog Posts

Chris

Fast restore one database from a dump of ALL databases

There have been times that I needed to restore one database from a dump file that contains all of the databases from the server. There are a few ways to accomplish this goal. One way would be to grep through the entire file for the table schema and insert statements. There are some problems with this method in some environments. For example, what if a table name in the targeted databases had the same name in another database on the same instance? The logic for grep now gets increasingly more com… Continue

Posted by Chris on November 18, 2009 at 1:09pm — 1 Comment

Chris

Consolidate Table Spaces with CAT

A can do method to consolidate table spaces without a full dump out and reload is to use cat. At first I did not think this would work in all cases, and am still not certain for ALL cases; however, I set up a quick and easy test just to see.

Example 1 below shows how to create a test table, create a multi-line insert file then insert the data. From there I shutdown MySQL cat the 4 table spaces into one file and restart MySQL.

-- Example 1

Table space allocation:
innodb_data_file_path=d… Continue

Posted by Chris on November 13, 2009 at 10:00am

Chris

Broken Index from InnoDB Hot Backup

A very interesting problem came up a while back when testing a rebuild and failover procedure. I had just run a rebuild of a slave server with InnoDB Hot Backup from the master. After the failover, one query on three tables in three different databases was not performing as it should. This was very odd to me given that the same table in all three databases was acting up. Below is the table structure and example query:

mysql> show create table plx_async_job\G
**************************… Continue

Posted by Chris on November 9, 2009 at 1:44pm

Sarah Sproehnle

Data type confusion: what is an int(11)?

Over and over I see customers that don't understand what int(11) really means. Their confusion is understandable. Many know what defining a char(10) means (a fixed-sized character string that allows up to 10 characters). However, ints are different.

First of all, there are 5 types of integer. They are all fixed size.












Type # of bytes
tinyint 1
smallint 2
med
… Continue

Posted by Sarah Sproehnle on October 30, 2009 at 8:04pm — 1 Comment

Forum

Lisa Phillips

Seattle Based Casual Gaming company looking for a Senior MySQL DBA to join team

Big Fish Games is a global leader and innovator in the online games industry, producing and delivering the world’s best games and game experiences. Big Fish Games Studios develops and publishes the...

Tagged: gaming, scalability, dba, mysql

Started by Lisa Phillips in Job Postings Nov 5.

Paula Kvarnberg

Seeking Lead MySQL DBA Rockstar for a growing internet company in Florida. GREAT COMPANY AND PEOPLE!

Seeking Lead MySQL DBA Rockstar for a growing internet company in Florida. GREAT PEOPLE AND ENVIRONMENT! Full-time permanent position. Salary to $125K plus bonuses and relocation. Referral fee offe...

Started by Paula Kvarnberg in Job Postings Oct 29.

arun

HElP!!!!!!!!!CANT LOGIN!!!! 5 Replies

i am a complete newbie to mysql and linux.what happened is i installed mysql and did this: SET PASSWORD FOR 'arun'@'localhost' = PASSWORD('pass'); GRANT ALL PRIVILEGES ON *.* TO 'arun'@'localhost' ...

Started by arun in MySQL Help. Last reply by Chris Oct 29.

Marie Badger

Seeking a MySQL Database Administrator for Raleigh, NC

Direct Hire position, Raleigh, NC The DBA will administer, maintain, develop and implement policies and procedures for ensuring the security and integrity of the company database. The DBA will cre...

Started by Marie Badger in Job Postings Oct 21.

Photos

Loading…
 
 

About

Chris Chris created this social network on Ning.

Create your own social network!

Badge

Loading…

Get Badge

Notes

Oracle, Microsoft, MySQL... Duck, Duck, Goose.

Oracle's intentions?  I think this might be where databases go to die!  

http://news.cnet.com/8301-13505_3-10365128-16.html

Created by Chris Oct 1, 2009 at 11:50am. Last updated by Chris Oct 1.

Notes Home

Welcome! To view all notes, click here.

Created by Chris Sep 6, 2009 at 8:37pm. Last updated by Chris Sep 7.

 

© 2009   Created by Chris on Ning.   Create Your Own Social Network

Badges  |  Report an Issue  |  Privacy  |  Terms of Service

Sign in to chat!