I’ve just been pointed to the nice tool which I was waiting for years to see. It is fincore – little perl script… not work. The fincore looks more like proof of concept tool – it is a bit simplistic, however being written in Perl… cache. This function is actually the real meat here – the tool is simplistic but it shows how to use the function…
Post: Death match! EBS versus SSD price, performance, and QoS
February 21, 2011 By 54 Comments
… per year. What do we get for that? Let’s look at some second-by-second output of the diskstats tool during… guess that this database server is in pretty severe trouble, waiting 230 milliseconds for the disk to respond. Indeed it is… $17k to run per year, plus about $1500 per year in disk cost (up to $3000 per year now that they’ve added…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
… to the MySQL server developers. The Valgrind Memcheck tool, which is synonymous with Valgrind itself, is …going to win any Cleanest Feature of the Year awards, but hey, this is MTR we …(sync0sync.ic:150) ==9090== by 0x6B34515: fil_aio_wait (fil0fil.c:4512) ==9090== by 0x6BC58E0: io_handler…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…KEY (`date_id`), KEY `FlightDate` (`FlightDate`), KEY `Year` (`Year`,`Quarter`,`Month`,`DayOfWeek`), KEY `Quarter` (`Quarter`,`… su – # cat hosts.internal | ~ec2-user/tools/mkhosts >> /etc/hosts # ping shard20 PING…transaction-isolation=READ-COMMITTED user=mysql wait-timeout=86400 To be continued …
Post: Predicting Performance improvements from memory increase
August 7, 2008 By 6 Comments
… size. Some threads which would be safely sleeping waiting on IO completion are now finding their data … is the true challenge becomes because MySQL has no tools to analyze working set (we have per query … you say have data for 10 years and load data for 5 years only to compare performance you may …
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
… major change was completed at the beginning of last year with the implementation of full-durability. In doing …thread to do recovery asynchronously. So the thread can wait for the LOCK_plugin to be unlocked before … thing because it provides DBA’s with the tools they need. My goal for PBXT in this …
Post: Rendundant Array of Inexpensive Servers
August 21, 2008 By 15 Comments
… once per couple of years for many evolving systems there is very high chance the old automation tools may not work well…” and have limited set of purchased configurations which are reviewed yearly (on other regular interval) rather than finding different best configuration… Monday-Friday is good enough for you – you’re not waiting for support for production anyway just fall back to another…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
…lot of users with monitoring systems over the years, and everyone says that they get a …overly full. Too many deadlocks. Deadlocks (and lock wait timeouts, covered in another plugin) are frequent … conjunction with Percona Toolkit’s pt-deadlock-logger tool. Open but deleted filehandles. It’s quite …
Post: Three ways that the poor man's profiler can hurt MySQL
December 2, 2011 By 19 Comments
Over the last few years, Domas’s technique of using GDB as a profiler has become a key tool in helping us… others at Facebook and beyond, have developed a variety of tools that can help them get stack traces less intrusively. I… less intrusive they can be. Of course, I’m really waiting for MySQL 5.6 and the improved Performance Schema that…
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
… computation I maintain another open source tool called Flexviews which supports incrementally maintaining materialized…Computation is massively parallel. Shard-Query simply waits for all the queries to finish, … dim_date.date_id where dim_date.Year IN (2008,2009) group by 1; –PARALLEL OPTIMIZATIONS…
