…to set up a relay master (it can be on the same machine if you use the BLACKHOLE storage engine…to determine when it’s not responsive? A: The easiest way to do this is to simply connect to it and attempt to…
Post: Open Source, the MySQL market (and TokuDB in particular)
May 10, 2013 By 13 Comments
…makes a connection between …to have a successful business. There are two examples: First, the PBXT storage engine from PrimeBase – even with an open source engine, the company eventually could not fund further development, and this engine…
Post: Talking MySQL to Sphinx
April 19, 2009 By 4 Comments
… but it is still fun to play with. A thing to mention – unlike MySQL Storage Engines, some of which as… –port 3307 Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1…, it also could not parse some queries for no reason though I expect these things to be polished in…
Post: MongoDB Approach to Availability
April 30, 2010 By 2 Comments
…to NDB Storage engine does not normally mean commit to disk, but rather commit to network it does not mean commit to…connect to replication set you connect to set of server not one of them and if one server fails driver fails over to…
Comment: Add an option to Fail on Innodb Initialize failure, Please ?
October 18, 2007 By 9 Comments
… now it will not even start accepting connections until storage engines are initialized which is better. Accepting them but refusing queries to say Innodb tables with “Recovery In Progress” or staling them on table lock could be an option…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
…will drive server to 10% of theoretical memory consumptions others only to 1%. So what could you do instead… adding up to 6GB, so you have 2GB left for your threads. Each thread connecting to MySQL… with many storage engines being released for MySQL by various parties. I do not pretend this to be …
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… but there is very long way to go before you could do any significant functionality ourside of storage engines as plugins. Two aspects why… is asynchronous. To offer great performance on distributed systems, especially if they are connected via not very fast network you need to come up…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 64 Comments
…to coarse invalidation is not as efficient as it could be. These are however mostly due to…to use local memory, Memcache or for example local flash storage for storage. Compression You can see it as a property of Storage Engine…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…storage-engine‘ ‘–with-archive-storage-engine‘ ‘–with-blackhole-storage-engine‘ ‘–with-example-storage-engine‘ ‘–with-federated-storage-engine…to the log. Note: this feature will fail to work well if your application uses some kind of connection…
Post: Using MyISAM in production
June 17, 2006 By 36 Comments
…could be bad memory OS or MySQL bugs but corruption may happen and go for long unnoticed with MyISAM storage engine…not inclusive and every system has its own risk tolerance factor and performance requirements, not to mention different load: Log tables. Now Archive storage engine…
