…the process when using pvcreate to initialize disk for LVM use, the two options you are interested in are…are not aligned. Now it may be interesting to see what are real life effects of misalignment, my benchmark results are in the…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 11 Comments
… systems. Provide data to “external triggers” such as Gearman jobs. CDC tools usually operate in one of the following … it a HUP signal. The script will drop a .pid file so you know what process to HUP. $ ./consumer_…11 fv$server_id: 999 c1: 1 c2: 1 3 rows in set (0.00 sec) As you can see, there are…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…what the operating parameters are. Can we suggest upgrades, rewriting queries, or whatnot? Sometimes there are rigid constraints on what…are the lowest common denominator. We often use tools to gather a lot of the data for us and speed the process, when possible, but the… 2.00GHz stepping : 11 cpu MHz…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…the splitter. It is multi-threaded(actually multi-process) and is able to hash split up to 50GB/hour of input data…what airline offered those flights and the flight number of the flight. Some data…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
…are created by FlexCDC. The refresh algorithm computes changes in multiple transactions. After each transaction it must wait for FlexCDC to process…what the COMPLETE refresh method does during its operation. It also takes care of atomically* replacing the new contents of the view with the…
Post: Compression for InnoDB backup
March 16, 2009 By 19 Comments
…data having some new information. In current multi-core word the compression utility should utilize several CPU to speedup operation…1 and -5 for other tools) The raw results are available here http://spreadsheets…. but the speed of processing is too slow. What is interesting on Level 5 the …
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 22 Comments
…data, compressed to about 2GB total data. then spread over six servers). Due to ICE limitations, the data was split before loading. The splitting/loading process…the from clause” are used. There are benefits with both “scale-up” and “scale-out”, but once again, the “scale-out” results are the…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… can use Innodb_data_reads , Innodb_data_writes, Innodb_os… system time consumed by the process. Collecting these at regular…operation per second which takes 4ms which adds up pretty well. We can also see what the…0 # pages distin 65 11.43M 1 18 6… ms. The queries which are in 100us range are ones where…
Post: Evaluating IO subsystem performance for MySQL Needs
March 5, 2008 By 23 Comments
… of what you should expect from the system. What …are synchronous IO operation database performance which typically have rather close data…Operations performed: 773835 Read, 0 Write, 0 Other = 773835 Total Read 11.808Gb Written 0b Total transferred 11…see only 1 blocked process all the time which does…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
…operation systems. Veritas File System can do it for Solaris. Most SAN systems would work as well. What…Data . You should specify enough of undo space to hold modifications during backup process…
