…would cause some random pieces of data and meta data to be lost. Not good for system running mySQL…would cause server to crash instead of continuing in half working mode throwing errors etc (depending on which filesystem became read only) To…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
… trivial way to crash MySQL to the user with basic privileges and asking me what to do. My answer to them is – there is nothing new to it… because they would both overload IO system and wipe off both MySQL and OS caches which can cause other users queries to perform order… users using MySQL lightly and not trying to crash/overtake it. Others constantly have to detect and restrict abusers. This is not to mention many…
Post: How Percona strives to remain neutral and independent
March 21, 2011 By Leave a Comment
…MySQL …could cause conflict….crashed on other simple queries is welcome to quote the benchmark results without mentioning the crashes…would not refer anyone to…what you could call an “informational” partnership. For example, we sometimes seek out or respond to requests from vendors who want to get to…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… what really caused the difference. It would be very interesting to see for example results on the same hardware just running PostgreSQL instead of MySQL… optimization. Such large logs typically will cause too long recovery time in case of crash so people settle on smaller log for…
Post: Magic Innodb Recovery self healing
May 22, 2007 By 2 Comments
… to be Innodb bug but Heikki currently could not find what could be causing… MySQL release will have this Innodb bug fixed) until today we got MySQL to crash…MySQL crashes during recovery lower values of innodb_force_recovery normally would not work. Reading Documentation one may think you need to…
Post: No more MySQL Crash Safe Replication in 5.0 ?
January 29, 2008 By 7 Comments
…crash recovery it would print position in master log files up to which replication was done: InnoDB: In a MySQL…-updates so you can see what last statement was executed before the crash and then find matching …amount of tables or your load pattern is to cause unacceptable stall if this lock is used. …
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
…0 (which could both cause different result set or make query not runnable in MySQL 5.0) …more likely it is to run on wide set of MySQL versions. Safe Approach So what if you …crash under your load as well s it scales well. There have been number of scalability bugs in MySQL history when issues would…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 116 Comments
…to work as MySQL DBAs or be involved with MySQL Performance in some way is to ask them what should be tuned in MySQL…to the disk but only flush it to OS cache. The log is still flushed to the disk each second so you normally would… MySQL Server crashes. Value 2 only cause data loss with full OS crash….
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…amount of concurrent writes to about 6 tables, what version of Innodb/MySQL would you recommend? I’… should we switch to Oracle? HT: You are right, bugs that cause data corruption, crashes, or … What would be really cool if someone would come up with “Persistent DRAM” memory device, which would …
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
…to the point what we’re comparing here – it is mainly DRBD to MySQL Replication based techniques (lets leave MySQL…to do transactional log recovery is invisible until you get a crash…would recommend to use DRBD with MySQL ? There some good reasons to use DRBD with MySQL…
