… 100GB EBS volumes. EBS currently lists at $0.10 per GB-month of provisioned storage, which I calculate should cost $100… 3.9 8% 0 3.0 {10} 5.8 0.8 42.0 2.1 0.1 6.5 16% 0 …snip… 20.2 {10} 2.6… 16.0 0.0 0.0 3.5 3% 0 25.2 sdj1 0.2 0.1 9.4 0.1 0.0 2.8 2% 0 26.2 sdj1 0.2 0.1 13…
Post: Virident tachIOn: New player on Flash PCI-E cards market
June 15, 2010 By 19 Comments
…series motherboard 2 x Xeon E5520 (2.27GHz) processors w/HT enabled (16 cores)…8-16 threads and with response time below 3.1ms (for 8 threads) and 3.8ms (16… ( 25% space reservation -> 25% increase $/GB). In conclusion I can highlight:…question for log related activity in MySQL) I am looking forward to…
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
…a 1/2 ratio of buffer_pool_size to data. For the initial tests, I used MySQL 5.5.8 (the… checkpoint age – This is a value in MB or GB and shows what amount of the space in …2000M innodb_log_files_in_group = 2 innodb_read_io_threads = 16 innodb_write_io_threads = 16 innodb_purge_threads=1 innodb…
Post: Review of Virident FlashMAX MLC cards
November 10, 2011 By 14 Comments
…However, I have yet to determine how this affects MySQL workloads. Virident has provided the following price list: M1000… (1400GB Usable) – $18,200 This amounts to $13/GB Second, it is important to compare the performance … in each run: Card / Threads / tps 1 2 4 8 16 32 64 128 256 512 1024 1 Fusion-…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 18 Comments
…3/4 – mke2fs -b 4096 -E stride=16,stripe-width=80 /dev/ice (some… fdisk -ul Disk /dev/sda: 1198.0 GB, 1197998080000 bytes 255 heads, 63 sectors/track…’s what I got on Ubuntu 8.04 using defaults (you would get…2048s 19531775s 19529728s primary ext4 boot 2 19531776s 27920383s 8388608s primary linux-swap(…
Post: Finding out largest tables on MySQL Server
February 4, 2008 By 27 Comments
…MySQL instance is no brainier in MySQL 5.0+ thanks to Information Schema…| art116.article116 | 10.49M | 12.52G | 3.65G | 16.18G | 0.29 | | art84.article84 | 10.10M |…| 9.82G | 2.51G | 12.33G | 0.26 | | art91.article91 | 8.66M | 9.17G | 2.66G | 11…and data and index size in GB so I can save on counting …
Post: Make your file system error resilient
August 24, 2011 By 8 Comments
…group: 128 RAID stride: 8 RAID stripe width: 80 Flex block group size: 16 Filesystem created: Mon …2 Maximum mount count: -1 Last checked: Wed Aug 24 00:01:56 2011 Check interval: 0 () Lifetime writes: 54 GB…not needed for partition you store MySQL data on, as chances are MySQL server is only one …
Comment: Box for some tests anyone ?
March 16, 2007 By 7 Comments
I just ordered a 8 core (2 x X5355), 16 GB, 6x15K SAS (RAID 10) server. I would be very interested in finding out which version of MySql does best on this platform. The server will not be online for 1-2 weeks from now. How long would your tests take?
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
…Current MYSQL Config as below. Could you please provide us suggestions to improve the performance. Hardware: 32 GB …2 innodb_flush_log_at_trx_commit=1 innodb_flush_method=O_DIRECT innodb_thread_concurrency=16…home/mysqld/sys/5.5.8/share/mysql/charsets [mysqld] port=3323 server-id=2 socket=/tmp/mysqld_…
Post: Setting up XFS on Hardware RAID -- the simple edition
December 16, 2011 By 9 Comments
… 8-16G for Swap — 10-20G for the OS (/) Possibly 10G+ for /tmp (note you could also point mysql‘… this: #fdisk -ul Disk /dev/sda: 438.5 GB, 438489317376 bytes 255 heads, 63 sectors/track, 53309 cylinders… is a common default. In this case 64K = 2^16 = 65536 bytes. Get your sector size from fdisk. …
