… for my everyday use. For example, SUN published their Solaris vs RedHat stuff based on sysbench’s results (Peter and me… allows to test: file I/O performance scheduler performance memory allocation and transfer speed POSIX threads implementation performance database server performance First…
Page: Presentations
May 3, 2006 By
…for content stored in database focusing on delivering high performance for large databases. We look … benchmarked on different platforms – hardware operation systems, file systems etc. Large number of benchmarks …pretty quickly. Download MySQL Performance 5.0 vs 4.1 MySQL Users Conference 2006, Santa…
Post: Quick comparison of MyISAM, Infobright, and MonetDB
September 29, 2009 By 30 Comments
… databases. The first thing I tried doing was loading the data with SQL statements. I wanted to see how fast MyISAM vs… MonetDB in an hour, I believe it uses memory-mapped files to hold the data in-memory. If this is true…’m not quite sure it’s useful for “general-purpose” database use — there are a number of limitations (concurrency, for one…
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
…if you look at In Memory storage engines vs Distributed ones. Trying to handle all different …on MySQL side, such as .frm files and binary log files has to be synchronized with storage engine… WITH READLOCK” and hoping nobody is touching “mysql” database any more. Single Storage Engine server would be…
Comment: High-Performance Click Analysis with MySQL
December 23, 2008 By 13 Comments
…if you happen to use MyISAM. 2) Real time vs delayed. I think for many applications semi-real …can be close to efficiency to storing to the database (MyISAM surely will be bound by sequential disk writes) …to move things around boxes (physical copy, just as files) and if you use full table scan MERGE …
Comment: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
December 5, 2008 By 15 Comments
…results. It is important to clarify that the Barracuda file format only ENABLES new features that require an …wouldn’t make sense anyway with an in-memory database, since compression is a way to trade off … no difference in the density of the index vs. the traditional way indexes are created. Do you …
