… is in part due to limits on the number of drive bays that have been present in servers, which has tended… it not beneficial to put logs on different drives compared to using the same drives to speed up other things as well…, not have large amounts of it unusable but still using RAM and disk space. For common production systems, the goal tends…
Post: A piece of Sun/MySQL Marketing
February 27, 2008 By 7 Comments
… about UltraSparc beating Xeon we get configuration with 48 hard drives which is of course far from what you would see… box which typically would have very little if any hard drives. There is also another trap which is hardware/software configuration… get 2*Quad Core Xeon box w 32G RAM and 8 2.5″ hard drives for about 10K from Dell. This would…
Comment: What CPU Architecture do you prefer for running MySQL In production
December 15, 2012 By 13 Comments
…, etc.), usually 8-64Gb of RAM or more. Usually batter-backed PERC raid on 15K SAS drives, of course. For CPUs we… price. New R420s with 24 HT cores, 128-256GB of RAM, 8TB of disk are cheap and powerful machines for MySQL…
Comment: Measuring the amount of writes in InnoDB redo logs
October 8, 2012 By 4 Comments
… adjust this. People with SSDs who want to improve their drive lifetime should pay particular attention to this, ensuring that they… OS will typically want to cache the log files in RAM so it is useful to tune so they aren’t… poor trade off for saving a little disk space or RAM. Views are my own, for an official Oracle opinion consult…
Post: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
… to increase innodb_buffer_pool_size to 50% of my RAM, and then when I tested MyISAM FT index, I reallocated… 7 tower with an Intel i3 processor, 8GB of RAM, and two SSD drives: one for the Windows partition, and one for…
Post: Is there benefit from having more memory ?
November 19, 2010 By 10 Comments
… then 128GB of memory? If we use fast solid state drive, should we still be looking to increase memory, or that… with 120GB ( as if you have system with 128GB of RAM) and 250GB Buffer_poolread-only, tpsread-write, tps 120GB1866.872547… memory, and it is possible as nowadays systems with 300GB+ RAM already available.
Comment: FlashCache: tpcc workload with FusionIO card as cache
June 4, 2010 By 20 Comments
… how much RAM you have you still have to do writes which can be expensive. I think 15K hard drives you’re… you need more space at lower cost larger slower hard drives will do it for you.
Comment: FlashCache: tpcc workload with FusionIO card as cache
June 3, 2010 By 20 Comments
… some servers are clearly not going to take 80G of ram, but I think if you’re at a price point… RAM for under $5k retail (sure it’ll be more like $6500 when you drop a second CPU and some decent drives…
Comment: Linux schedulers in tpcc like benchmark
January 30, 2009 By 19 Comments
… may be even more favouring noop if you used SSD drives. I mean, chances are that those results are somehow hardware… the merit to be a quite typical setup). How much RAM do you have on this PERC6 (I think Dell as… the way, did someone already benchmarked how the quantity of RAM in the controler do impact some I/O bound loads…
Comment: Big Iron for tests anyone ?
August 8, 2008 By 10 Comments
hi. i could offer access to a sun starfire (64gig ram/64 cpus) and a fsc primepower 192cpu’s and 256gig ram. storage would be a dedicated symetrix with 128 disk drives. maybe a bit late but if u r interested. tassilo
