… and below. I do not have enough space on this SSD to run this experiment that long. So there we see… easily fill TokuDB tables with 1bln of rows on this SSD, and projected InnoDB performance on this size will be the….30-rel30.2-500.Linux.x86_64/lib/mysql/libjemalloc.so [mysqld] gdb datadir=/mnt/data/mysql #for SSD innodb_flush_neighbor…
Post: Fast storage: 8 SSD Intel X-25M 80GB benchmarks
January 18, 2010 By 15 Comments
… point for research, I think there some serialization in Linux software raid or Linux scheduler or on Adaptec hardware level. 2. Cards…: – For sequential reads you can get pretty decent results from SSD (230MB/sec on 4+ threads) – Cards connected in hardware raid… single FusionIO card, however there is important point that with SSD you may “hot”remove and insert cards, while for FusionIO…
Post: ext4 vs xfs on SSD
March 15, 2012 By 26 Comments
… filesystem for many modern Linux system, I am getting a lot of question if this is good for SSD, or something else… to share earlier results what I have. I use STEC SSD drive 200GB SLC SATA (my thanks to STEC for providing… 5.1 and 5.5), InnoDB uses “asynchronous” IO in Linux. Let’s test “async” mode in sysbench, and now we…
Post: MLC SSD card lifetime and write amplification
November 15, 2011 By 8 Comments
… are some facts that can help you to estimate. On Linux you can look into the /proc/diskstats file, which shows… Amplification, which is very well described on WikiPedia, but basically SSD cards, due an internal organization, write more data than it… what your throughput will be when you put workload on SSD. (function() { var po = document.createElement(‘script’); po.type = ‘text/javascript…
Post: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 25, 2012 By 12 Comments
… pricing point our customers are looking for cheaper alternatives. SATA SSD is an options. There is many products based on MLC… it appears there is no a reliable way in the Linux asynchronous IO library to get time metrics for particular IO… results for Intel 320). If you are interested more in SSD and MySQL questions – I will be giving a webinary “MySQL…
Post: Testing STEC SSD MACH16 200GB SLC
April 25, 2012 By 9 Comments
… it appears there is no a reliable way in the Linux asynchronous IO library to get time metrics for particular IO… 4 STEC MACH16 cards. If you are interested more in SSD and MySQL questions – I will be giving a webinary “MySQL and SSD” on May-9. It will be the same as my…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… algorithm. I’m also wondering if you would recommend using SSD for this purpose, and how much performance gain there might… the amount of system memory. We just deployed a new Linux/Mysql server for a client, upgrading their main database (from… that should be implemented on larger servers? HT: I think Linux often likes to use about 20 % of the available RAM…
Comment: Write performance on Virident tachIOn card
October 11, 2011 By 10 Comments
… we previously used the whole disk for a partition in Linux, then delete the partition,and over-provision with a smaller… know if the Linux ‘gdisk’ command will issue a TRIM command to free up the remaining 25% to the SSD controller? I… plenty of free space. I believe that’s why enterprise SSDs are over-provisioned transparently, but vanilla ones are not, or…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 18 Comments
… System /dev/sda1 * 2048 19531775 9764864 83 Linux /dev/sda2 19531776 27920383 4194304 82 Linux swap / Solaris Partition 2 does not end… 19535039 9767488+ 83 Linux /dev/sda2 19535040 27342629 3903795 82 Linux swap / Solaris /dev/sda3 27342630 2339835119 1156246245 8e Linux LVM sda1 and… in 512-bytes internally. This however gets more complicated with SSD drives which often operate in 4kbyte units, though this is…
Post: btrfs - probably not ready yet
May 22, 2012 By 17 Comments
… that will solve all our problems, improve overall performance and SSD in particular, and it is a saviour. Of course it… is quite easy if you are on CentOS/RedHat/Oracle Linux 6.2. Oracle provides Unbreakable Enterprise Kernel, which includes btrfs… format btrfs with default options, and mount it with -o ssd,nobarrier options. Throughput results: We can see that btrfs not…
