… changed from storing data in MySQL columns to serializing data and just storing it inside TEXT/BLOB columns. It seems that since… of data in a very large blob, the effort MySQL has to go to is greatly increased. The second downside I would mention… not optional. In practical terms I would expect this increases the size of a working set since more data must be kept…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
… would not swap out MySQL out of memory. MySQL Innodb Settings The most important ones are: innodb_buffer_pool_size 70-80% of…_log_buffer_size=4M 4M is good for most cases unless you’re piping large blobs to Innodb in this case increase it… about tuning other options here or read one of our MySQL Presentations. Application tuning for Innodb Especially when coming from MyISAM…
Comment: Finding your MySQL High-Availability solution – The questions
October 18, 2009 By 36 Comments
… to the actual size of the data set after being imported into NDB. Of particular note is that blob/text columns (for… massive (with admitidly a giant test suite). The list of MySQL Certified Cluster DBA* is ~100 people, many from Sun. This… nodes to increase capacity can easily decrease performance. 2.8 Security. Most communication is in the clear. 2.9 The MySQL database…
Post: Commodity Hardware, Commodity Software and Commodity People
June 15, 2007 By 9 Comments
…database size. Now, for a smaller projects even if you happened to have smart MySQL guy…increasing complication will mean more services will come to us for Consulting Services Do I see MySQL…run on top of MySQL or other databases. Other interesting development is Scalable Blob Streaming. This projects…
