June 19, 2013

Comment: Site was down today, support and web hosting.

I’m running my own linux distribution on a Hetzner-Server (German Hosting) without any problems … 100MBit/sec-GB) I’m using a mdadm-software-raid (because the onboard-raids are software too) but if you need a real hardware-raid you can get one from hetzner. http://www.hetzner.de/…

Post: Review of Virident FlashMAX MLC cards

… the OS, and the user needs to use a software RAID. For Virident all 1400GB shows up as one single drive so no software RAID is necessary. To compare performances I ran sysbench oltp and… used in benchmarks include: Server: Cisco UCS C250, running Oracle Linux 6.1 and Percona Server 5.5.15 Client: HP…

Comment: 5.0.83-build17 Percona binaries

… 3) Make sure you use software raid. Raid cards these days are rarely as good as linux in maximising throughput, even the PCI…

Post: Beware: ext3 and sync-binlog do not play well together

… sync-binlog=1 is enabled, even though the system with RAID and BBU were expected to have much better performance. The… expect it to drop ether. To ensure this is not RAID controller related we repeated the run on the in memory… it is by far the most common file system for Linux. It is also worth to investigate if something can be…

Comment: Review of Virident FlashMAX MLC cards

Bob, That’s good information. I am always somewhat hesitant about linux software raid. Even Linux is incredible popular, it feels it is still not mature enough in many areas, including IO.

Comment: Linux schedulers in tpcc like benchmark

Vadim, fair enough, RAID 10 + BBU is probably the most common and natural choice … was based on the (very naive and unverified) believing that Linux I/O schedulers do reorder based on kernel’s page… to the recent work on cgroups and containers resources control, Linux got a lot of refining in order to expose and…

Post: Living with backups

… than any disk access, even with the fastest drives or RAID configurations, the performance gains are quite clear. Now going back…. This is unfortunately not something you can do with standard Linux tools like cp, scp or tar. However for example rsync… proper location (where would we be without one-liners) On Linux there is also a utility called ionice. It allows to…

Post: Choosing innodb_buffer_pool_size

…. On Windows you do not need to do anything. On Linux, FreeBSD, Solaris you need to set innodb_flush_method=O… niche case when it hurts – when you do not have RAID with BBU and your workload is very write intensive but… happening ie your VMSTAT “si/so” columns are zero on Linux. Couple of swaps per minute would not hurt bad but…

Post: MyISAM concurrent insert

… get from my UC2006 talk, in short on main platforms (Linux, Solaris, Windows) rw-locks have a bad implementation and too… waste of CPU in user-space (Solaris) or kernel-space (Linux). Some results for MyISAM table, query SELECT id FROM sbtest…) XEON(TM) MP CPU 2.00GHz, 4GB of RAM, SATA RAID 10 The results in queries per sec (more is better…

Post: My Innodb Feature wishes

… use RAID and forget about tablespaces by spreading the load, but you often can do it better manually :) I/O On Linux… for it existed for years) is Async IO support in Linux. It should be very helpful with direct IO as well…