… controllers and 192GB of RAM. These servers will run a few slave instances each of production database servers …server can easily handle the write load of all the MySQL instances. The original idea was to … contains a lot of random data that doesn’t compress well showed a compression ration of 1.70 …
Comment: ZFS on Linux and MySQL
June 8, 2013 By 17 Comments
… from Linux to illumos ZFS by giving up 10% total ram for metadata caching, but it is just the price you…-1 costs a lot. So OmniOS should only be used as MySQL read slaves behind a pair of Linux based MySQL Masters using Pacemaker. Maybe you guys can get Galera working on OmniOS to solve our lack of clustering…
Comment: Virident vCache vs. FlashCache: Part 1
May 17, 2013 By 3 Comments
…of RAM, but that isn’t really going to help me when I need to start writing massive amounts of…lot faster than regular spinning disk, a PCIe flash card is still massively faster than an SSD, both in terms of…, but there’s a comparison in TPCC-MySQL performance between that card and a traditional SSD…
Comment: SimCity outages, traffic control and Thread Pool for MySQL
March 21, 2013 By 16 Comments
…being integrated as it is. I remember hearing a lot of hype about it years ago but it seemed …– that reminds be of a client I supported and designed their MySQL infrastructure (now an acquired subsidiary of a larger entity…per day on a 8-core DL380 with 32GB RAM. Back in 2006 I recall that being an …
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
… to this take by accident so there is not a lot of science in coming up with it but I think it… 4*7200RPM SATA hard drives in RAID10. It has 8GB of RAM and I’m running Percona Server 5.5.28-29…: What this tells me is there is a lot of untapped potential in MySQL IO as I think we should be getting very…
Post: InnoDB memory allocation, ulimit, and OpenSUSE
August 23, 2010 By 7 Comments
….12-0.2-desktop x86_64 Â with 96 GB RAM when the innodb_buffer_pool_size was set to anything… in ut_malloc_low(), so to get an idea of the pattern of requested allocations I added a debugging fprintf() to tell… of the buffer pool. This can become significant in the proper innodb_buffer_pool_size estimations when the system has a lot of RAM…
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
…on these questions actually depend on a lot of things, some of which we’ll try to cover… higher like 32 cores and 128G of RAM it is going to be dis proportionally…of course not the only option. There are variety of companies on he market offering services around MySQL and LAMP and MySQL is one of…
Post: Disaster: MySQL 5.5 Flushing
September 18, 2011 By 27 Comments
… as typical nowadays. Hardware: HP ProLiant DL380 G6, with 72GB of RAM and RAID10 on 8 disks. I took sysbench multi-tables… to have a lot of modified pages in buffer pool. Let’s try it: Well, stability and absolute value of throughput are far… suitable for modern hardware with a lot of memory. I hope there is work in progress for MySQL 5.6. Scripts and raw…
Post: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
… MemSQL is an in-memory database, you can get a lot of speed improvement because you’re searching data without touching the…/share set of disk? The test machine I used is a Windows 7 tower with an Intel i3 processor, 8GB of RAM, and two SSD drives: one for the Windows partition, and one for the MySQL data partition. I…
Post: Filling the tmp partition with persistent connections
August 6, 2012 By 14 Comments
… of on-disk temporary tables. Servers usually have less RAM than disk space so those kind of … lot of files in deleted status that are filling the partition. The fourth column is the size of those… most likely killing system in the end. Conclusion MySQL can creates temporary files even thought those …
