… not expect it to beat MySQLi in speed. It is however bad idea to use mysql_ functions directly as well – I would… little work and formating, so database connection may become the issue. Caching should be good help in this case though. About… by people with traditional database background. Things are different with MySQL. There are many successful applications, using tens of thousands of…
Post: Sphinx 2.0.2 Beta is released, Sphinx Users Conference in December
November 17, 2011 By 6 Comments
… connect to Sphinx as if it were MySQL Server with more advanced connectors which issue such commands when they set up connection…. Another thought – with Innodb Full Text Search coming up in MySQL 5.6 and Claimed to be faster than MyISAM’s… many cases people use Sphinx not because it is faster – speed might not be the main thing on smaller collections but…
Post: MySQL Partitioning - can save you or kill you
December 11, 2010 By 45 Comments
…for a while to write about using MySQL Partitioning for Performance Optimization and I just got … fewer level in BTREE is not that significant issue. So lets see at example: CREATE TABLE `tbl` ( `… table recently. Using this trip replication could be speed up about 10 times as couple of partitions…
Post: Is your server's performance about to degrade?
May 18, 2010 By 13 Comments
… in the 50 to 100 microsecond range. At such speeds, how would you know if your server froze for… I feel really hopeful that Oracle will solve these issues, and it won’t be a moment too soon…. about it — and that’s where improvements to the MySQL source code are necessary. But in many cases something…
Post: More on dangers of the caches
September 23, 2010 By 5 Comments
…is so bad the speed of populating cache with new items is lower than speed with which items…it tries to put too much load on MySQL as MySQL load stabilizes increasing number of connections higher…can learn from this, besides cache design related issues I mentioned in the previous post. Include …
Post: Content delivery system design mistakes
February 11, 2007 By 9 Comments
…helped dealing with performance problems (part MySQL related and part related to LAMP in general…, dynamic content has some of its own issues which need different treatment. DNS TTL Settings… bit of difference especially on slower connection speeds. Forgetting to set expire Static content rarely …
Post: How much overhead DRDB could cause ?
June 2, 2008 By 4 Comments
I was working with the customer today investigating MySQL over DRBD performance issues. His basic question was why there is so much… (depending on file system and configuration) more synchronous IO operations – MySQL binary logs are not preallocated as Innodb logs are which… settings. So overhead can vary a lot depending on the speed of the disk subsystem and network. If you do not…
Comment: MySQL Quality of old and new features
October 5, 2007 By 24 Comments
… To be honest it’s embarrassing. Two years ago, corruption issues would have a special revision and a hosted download of… mySQL itself will not cause data-corruption. Any updates are to fix non-serious bugs or improve performance. The people want SPEED and Reliability, they will pay for that! To feel confident that mySQL will not cause corruption is…
Post: table_cache negative scalability
November 16, 2009 By 23 Comments
… (such as memory). With MySQL common sense however does not always works – we’ve seen performance issues with large query_cache_size… which is almost 8500 tables/sec which is a great speed. We can note significant writes to the disk during this… problem is not fixed in MySQL 5.1, lets see how MySQL 5.4 behaves. MySQL 5.4.2 MySQL 5.4.2 has…
Comment: To pack or not to pack - MyISAM Key compression
November 2, 2012 By 4 Comments
…. That is when I became confused about the introduction of MySQL, saying it will be faster for reading, which is what… my database, maybe there is very few string indexes, the speed declining is also not obvious). Then I search and find… 4MB), will there be any solution to combat with this issue?
