Xaprb

ASUS-UL30A-X5

I’ve had an ASUS-UL30A-X5 for about two weeks now. This is the nicest laptop I’ve ever owned (and I was a laptop owner before that was cool). I’m absolutely thrilled.

I used a Dell Inspiron 1501 for the last 4 years, the AMD model. Everything was a pain due to poor Linux compatibility. I blamed some of it on other things. For example, I thought my external monitor was low quality because all the pixels crawled like ants. I got this laptop and immediately everything I’d had a problem with was a non-issue. Skype audio — works great. Suspend and resume — works great. Everything. I didn’t know how much pain I was in until I got this laptop.

I also considered buying an HP Pavilion DM-3 and a Toshiba Satellite T135, both very nice machines also, and much in the same class as far as size, weight, and battery life. I physically drove around to a bunch of stores and saw them, picked them up, etc. In the end, I think they are all great laptops, but after watching multiple YouTube reviews of all of them, it became clear that ASUS had built a killer machine.

Main selling points for me are the size, the weight, and the battery life. Those were what I was shopping for. In more detail:

• Small and light. Nice size for travel. 13.3 inch screen, really a perfect size.
• Long battery life. They claim 12 hours. They’re really not kidding, I’ve gotten about 9 hours of honest work on a single charge, and I’m not clocking the CPUs down. I’m not exactly running compilers the whole time, but I’m talking on Skype, running an external monitor, using the wireless, running CPU-intensive things like LaTeX builds, and so on.
• Nice display! It’s LED-backed, very bright, very white (makes my old laptop look dirty yellow/green in comparison).
• Nice keyboard!
• Fast. This is not a gerbil-pusher running an Atom processor, it is fast, and the chip has the virtualization features that help a lot when I’m running VirtualBox. It’s much more powerful than my old laptop, more than powerful enough for OpenOffice.org to be snappy. DDR3 memory too. Definitely a high performance laptop.
• 4GB of memory, and more hard drive space than I’ll ever use. I can’t believe how big the drives are these days.
• Cool running — almost cold. Quiet too.
• Did I mention that it works flawlessly with Linux? (The stock Fedora 12 install has a flaky wireless driver; just ‘yum update’ to get a new kernel, and you’re golden.)

Downsides? Not many. The touchpad is a bit too sticky. The display doesn’t open flat, it only opens back to about 120 degrees.

I did a lot of research and brought myself up to speed on the latest hardware. One thing I learned that surprised me: you have to be careful with the Intel chips these days. The model numbers make it hard to tell what you’re getting. You have to go to the Intel website and use their comparator. I also learned what you probably know already: most of these computers come in an Intel flavor, and an AMD flavor that typically has ATI graphics and other components. The differences are manifold: the AMD machines are typically $100 cheaper, have half the battery life, and have all kinds of problems with weak driver support in Linux.

My wife can tell you how much I agonized over this. Should I buy a new laptop? Ehhh… my old one got the job done, I felt guilty about hurting the environment by paying for another computer to be built, I did’t want to spend money… blah blah blah. I should have gotten off the fence ages ago and just bought it. Actually I take that back, it’s only been available for 6 months or so.

I bought mine from Amazon, which was actually the best deal on the web, even after researching dealnews and other sites. None of the stores I visited had it in stock; they only had the AMD model.

It has no internal optical disk drive, which is actually a good thing for me — I probably pop a disc in once every two months, if that. So I bought an external DVD burner, pictured at left, which is also quite nice. It works great to boot from it. I promptly booted from it to a Fedora CD and wiped the whole drive to install a real operating system.

We have an early draft of a new tool available for you to use and test. It uses heuristics to find problems in SQL. Please use it and give feedback! Here’s how:

$ wget http://www.maatkit.org/trunk/mk-query-advisor
$ perl mk-query-advisor /var/log/mysql/slow.log

By default it consumes a log file in MySQL’s slow query log format, but it can also parse the general-log format, and if you have any other kind of log you can feed it through mk-query-digest to transform the log into something it can recognize. Tell me if you’d be able to spot the mixture of join styles and use of leading % wildcards in the following query without help:

# Query ID 0x643E813A9ABDA151 at byte 2001701
# CRIT JOI.001 Mixing comma and ANSI joins.
# WARN ARG.001 Argument with leading wildcard.
SELECT `rhubarb_series_title`.`id`, `rhubarb_series_title`.`series_id`,
`rhubarb_series_title`.`title`, `rhubarb_series_title`.`url`,
`rhubarb_series_title`.`type`, `rhubarb_series`.`id`, `rhubarb_series`.`title`,
`rhubarb_series`.`alt_title`, `rhubarb_series`.`url`, `rhubarb_series`.`aka`,
`rhubarb_series`.`author`, `rhubarb_series`.`artist`,
`rhubarb_series`.`summary`, `rhubarb_series`.`logo`,
`rhubarb_series`.`logo_updated`, `rhubarb_series`.`us_publisher`,
`rhubarb_series`.`jp_publisher`, `rhubarb_series`.`start_date`,
`rhubarb_series`.`official_website`, `rhubarb_series`.`create_time`,
`rhubarb_series`.`modify_time`, `rhubarb_series`.`poster_id`,
`rhubarb_series`.`note`, `rhubarb_series`.`status`,
`rhubarb_series`.`status_note`, `rhubarb_series`.`suspended`,
`rhubarb_series`.`licensed`, `rhubarb_series`.`warning`,
`rhubarb_series`.`no_ads`, `rhubarb_series`.`orientation`,
`rhubarb_series`.`gen_js`, `rhubarb_series`.`image_pre`,
`rhubarb_series`.`views`, `rhubarb_series`.`rank`,
`rhubarb_series`.`last_chapter`, `rhubarb_series`.`last_updated`,
`rhubarb_series`.`bookmark_count`, `rhubarb_series`.`ad_pre`, `auth_user`.`id`,
`auth_user`.`username`, `auth_user`.`first_name`, `auth_user`.`last_name`,
`auth_user`.`email`, `auth_user`.`password`, `auth_user`.`is_staff`,
`auth_user`.`is_active`, `auth_user`.`is_superuser`, `auth_user`.`last_login`,
`auth_user`.`date_joined` FROM `rhubarb_series_title` INNER JOIN
`rhubarb_series` AS `rhubarb_series_title__series` ON
`rhubarb_series_title`.`series_id` = `rhubarb_series_title__series`.`id` ,
`rhubarb_series`,  `auth_user` WHERE (`rhubarb_series_title__series`.`suspended`
= 0 AND `rhubarb_series_title__series`.`author` LIKE '%onetwo%' AND
`rhubarb_series_title__series`.`author` LIKE '%threefour%') AND
`rhubarb_series_title`.`series_id` = `rhubarb_series`.`id` AND
`rhubarb_series`.`poster_id` = `auth_user`.`id`

Yes, that’s a real query, slightly obfuscated.

If you find bugs, report them. If you find a “bad query” that doesn’t trigger any heuristic, report that too. We’re only getting started, but I feel sure that this tool will become a sort of best-practices advisor as we make it more capable. The Google Code issue tracker has a full initial spec, and the wiki has a roadmap.

I’ve submitted a Birds of a Feather session for Maatkit at the upcoming MySQL conference. It’s not on the public schedule yet, but it has been accepted and scheduled for 19:00 on 13 Apr 2010. See you there!