… on servers for backup purpose, boxes with 64 300GB SAS drives, 3 raid controllers and 192GB of RAM. These servers will run…, maybe it is related to better raid controller write cache use. Even the fairly slow gzip-1 mode works well. The tpcc…, the storage will still be working. Also, instead of having 1 or 2 spare drives per controller, I have 2 for…
Comment: State of the art: Galera - synchronous replication for InnoDB
April 23, 2013 By 15 Comments
… on it that I have seen when running mysql 5.1 or mariadb 5.5 on the same hardware in a…,000 queries in about 50-60 seconds to mysql 5.1 and in about 6-9 seconds on mariadb 5.5…. This is all on centos 6.4, adaptec raid controller with six 300G SAS drives in a raid10 for the database and…-queries=100000 MariaDB-Galera-server-5.5.29-1.x86_64 mysql-5.1.67-1.el6_3.x86_64 MariaDB-server-5…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…Size ############################# sda | [deadline] 128 # RAID Controller ############################################ Controller | LSI Logic MegaRAID SAS Model | MegaRAID SAS 8704EM2, PCIE interface, 8 ports …. There were couple interesting surprised I faced: 1. After I got (what I thought was) …
Post: Looking for RAID Controller without Battery Learning problems ?
January 5, 2012 By 11 Comments
…1 LD Controllers found: 1 ———————————————————————- Logical device information ———————————————————————- Logical device number 0 Logical device name : RAID10-A RAID…
Post: RAID vs SSD vs FusionIO
May 1, 2009 By 17 Comments
… two previous posts) I managed to setup all three devices (RAID was on board; Intel X25-E SSD connected to HighPoint… parameter. Here is my very rough calculation: For RAID 10 we use 8 73GB SAS 2.5″ 15K RPM disks, with price… I can get 32GB card for 390$, which is ~12.1$ per GB For FusionIO I really not sure what is…
Comment: When would you use SAN with MySQL ?
March 11, 2009 By 18 Comments
… involved with, MySQL is fine with 6 SAS/SCSI disks in RAID 5 or RAID 10 before it needs to scale out. Though… find surprising is quite often people dedicate 2 disks in RAID-1 just for OS while OS uses these just to boot… nice from operations standpoint i.e. you can work with RAID online – format it, move disks around, but really how often…
Comment: Cache Performance Comparison
January 24, 2007 By 74 Comments
… dell PowerEdgeTM 1950 2 giga of memory, 2 disks SAS 140 giga in RAID 1 I obtain the following results: Array Cache Time….shm_prune_period=”0″ eaccelerator.shm_only=”0″ eaccelerator.compress=”1” eaccelerator.compress_level=”9″ eaccelerator.keys = “shm” eaccelerator.sessions = “shm” eaccelerator.content = “shm” apc.enabled=1 apc.shm_size=250 apc.optimization=0 apc.num_files…
Comment: When would you use SAN with MySQL ?
March 11, 2009 By 18 Comments
…Aurimas, The reasoning behind RAID 1 for OS is not performance at all, it’s just … OS (Used to be 36GB, nowdays 72GB is minimum for SAS). With regard to disk space: I’m working with companies…
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?
Post: Benchmarks of Intel 320 SSD 600GB
February 22, 2012 By 2 Comments
… SAS hard drives. System specification Dell PowerEdge R610 Memory: 48GB CPU: Intel(R) Xeon(R) CPU X5650 RAID controller: Perc H800 RAID configuration: RAID 5 over 11 disks + 1 hot spare. RAID 5 is chosen for space…. Graphical result: Tabular: Tables HDD SDD Ratio 32 1226 1644 1.340946 64 140 571 4.078571 96 101 506 5…
