I’ve been browsing some mailing lists and so on (it doesn’t matter which ones) and came across the Great 32-Bit Debate afresh. The debate always starts with someone saying “I need 32-bit support” or “this doesn’t work on 32-bit systems,” and someone else raising an objection to that, saying that nobody uses 32-bit systems anymore and anyone who does is doing something wrong.
Why would anyone use a 32-bit OS in the year 2012? I can think of a few very good reasons.
How do you connect to and converse with your database of choice (MySQL, in my case)? Chances are it’s largely formed by the programming language you choose. I’ve worked with a variety of programming languages. Anytime I begin learning a new one, I am reminded again that there’s more than one way to skin a cat.
Did you just run an UPDATE against your 10 million row users table without a WHERE clause? Did you know that in MySQL 5.5 that sometimes you can recover from a bad UPDATE statement? This is possible if you are running in binlog_format=ROW !
Imagine this scenario:
CREATE TABLE `t1` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` varchar(10) NOT NULL,
PRIMARY KEY (`c1`)
INSERT INTO `t1` (`c2`) VALUES ('michael'), ('peter'), ('aamina');
We run an accidental UPDATE statement that changes a row:
Percona has offered Training for years, and I have personally delivered my share of Public and Private training. Below are my thoughts on the different training delivery options and how to choose the one that fits your needs.