A few people have asked me how fast MySQL Table Checksum is. As with so many other things, it depends. This article shows how long it takes to checksum real data on a production server I help manage, which might give you a rough idea of how long it'll take on your servers.
OSDC is a grass-roots conference providing Open Source developers
with an opportunity to meet, share, learn, and of course
show-off. OSDC focuses on Open Source developers building
solutions directly for customers and other end users, anything
goes as long as the code or the development platform is Open
Source. Last year's conference attracted over 180 people, 60
talks, and 6 tutorials. Entry for delegates is kept easy by
maintaining a low registration fee (approx $300), which always
includes the conference dinner.
This year OSDC will be held in Brisbane from the 26th to the 29th
of November, with an extra dedicated stream for presentations on
Open Source business development, case studies, software process,
and project management. The theme for this year's conference is
"Success in Development & Business". If you are an Open Source
maintainer, developer or user we would encourage you to submit a
talk proposal on the open-source tools, …
Maybe this is obvious, but I post it anyway, just to remind myself should I need it again.
Recently I had to change a table that I had not completely thought through when I first created it. The structure was so simple, I did not think I could do anything wrong with it:
CREATE TABLE `parent` ( `par_id` bigint(20) NOT NULL, `somevalue` varchar(20) default NULL, PRIMARY KEY (`par_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `child` ( `x_parid` bigint(20) default NULL, `value` bigint(10) default NULL, KEY `fk_parid` (`x_parid`), CONSTRAINT `child_ibfk_1` FOREIGN KEY (`x_parid`) REFERENCES `parent` (`par_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
There is a 1:0..* relationship between parent and child. Some sample data:
mysql> select * from parent; +--------+--------------+ | par_id | somevalue | +--------+--------------+ | 1 | Parent No. 1 | | 2 | Parent No. 2 | | 3 | Parent …[Read more]
Maybe this is obvious, but I post it anyway, just to remind myself should I need it again.
Recently I had to change a table that I had not completely thought through when I first created it. The structure was so simple, I did not think I could do anything wrong with it:
CREATE TABLE `parent` ( `par_id` bigint(20) NOT NULL, `somevalue` varchar(20) default NULL, PRIMARY KEY (`par_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `child` ( `x_parid` bigint(20) default NULL, `value` bigint(10) default NULL, KEY `fk_parid` (`x_parid`), CONSTRAINT `child_ibfk_1` FOREIGN KEY (`x_parid`) REFERENCES `parent` (`par_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
There is a 1:0..* relationship between parent and child. Some sample data:
mysql> select * from parent; +--------+--------------+ | par_id | somevalue | +--------+--------------+ | 1 | Parent No. 1 | | 2 | Parent No. 2 | | 3 | Parent …[Read more]
Note: this "script" is a one liner really and not something meant
for general purpose use. It is very specific to my environment so
I take no responsibility of any kind. It is very raw so use at
YOUR OWN risk.
Last year at the MySQL camp, I heard about Paul Tuckfield's
script that pre-fetches relay logs to speed up replication. Since
then I got really interested in implementing it but never got the
time. This year at MySQL conference Paul's script got a lot of
attention again. Since it hasn't been released and I really need
to start testing this on my test server. So I started hacking on
creating a shell script to dig deeper into what's involved. Once
I have that I may work on porting it to other languages.
To make the process of writing this script easier for others in
their favorite languages I thought I will go through what's
involved in creating this script on my blog. That way when you
would like to write an …
I've written before about how to make MySQL replication reliable. One thing I think you need to do to make statement-based replication reliable is eliminate temporary tables. I found an elegant way to replace temporary tables with real tables in the systems I maintain. This article explains how.
A few people have asked me how fast MySQL Table Checksum is. As with so many other things, it depends. This article shows how long it takes to checksum real data on a production server I help manage, which might give you a rough idea of how long it’ll take on your servers. The server and workload This server is a replication master running MySQL 5.0.38. It is a Dell Poweredge 1800 series with dual Xeon 3.
By Tim O'Reilly
In today's article about new open source releases from Sun, Microsoft, and Adobe, Wired News quoted our very own Nat Torkington:
"Microsoft is in a new era. The Bill Gates cutthroat 'we win by killing' days are passing," says Nat Torkington, co-chair of the O'Reilly Open Source Convention. "Microsoft exists by making users happy. And sometimes -- just sometimes -- you make Microsoft users happy by giving them a technology that wasn't invented at Microsoft."
Nat sure is quotable (and you should definitely read the full text of his comments), but I'm not sure that he's entirely right, at least not about the industry as a whole. Yes, in an era of open standards and open source software, it's easier for users to …
[Read more]
So I have been doing quite a bit of benchmarking and while most
of my tests have been amazingly simple, I thought I would share
some of my findings. The following is the total time it took to
run a series of simple inserts over various threads and
engines:
Threads | MyISAM | PBXT | InnoDB | Memory | Archive | Blachole |
---|---|---|---|---|---|---|
1 | 11.16 | 13.65 | 39.51 | 9.92 | 10.54 | 9.82 |
2 | 7.86 | 8.59 | 20.60 | 6.36 | 6.17 | 5.35 |
You’ve heard me on the MySQL Podcast at http://www.technocation.org, now come work with me, the “She”-BA!
The company I work for is an online social networking/dating site. Our main product is for men seeking men in 87 countries throughout the world. We’re looking for another MySQL DBA, as designing schemas maintaining data integrity for our 1 million users (and growing fast!). The salary is dependent upon experience of course, but the company I work for pays on the high side of the industry standard for the Boston area.
Application Instructions
Please send cover letter, résumé and sample schema to work@online-buddies.com,
with “MySQL DBA” as your subject. The
sample schema should reflect your abilities, so if you send along
a schema you would like to see improved, include a description of
what you would love to do to that schema to make it better.
…
[Read more]