October 31
Seven times faster commit speed in Windows?
Trackbacks
Trackback specific URI for this entry
No Trackbacks
Comments
Display comments as
(Linear | Threaded)
MySQL WTF - I love the name, it fits the MySQL philosophy. Just not to create confusion, it always has to be accompanied by its explanation, which by the way defeats the purpose of the acronym.
On the other hand, what exactly would you expect from a piece of crap RDBMS?! To be faster on ACID compliant mode than Oracle? MySQL strengths are running in non-ACID mode way faster than its competitors. But what am I saying here?! MySQL has no competitors for non-ACID running mode, because there's no other RDBMS that doesn't care of its data integrity. The living proof is the so-called storage engine myisam, a total p.o.s. flop.
Dude, get real and start using any other database that has data integrity features built-in.
Cheers!
On the other hand, what exactly would you expect from a piece of crap RDBMS?! To be faster on ACID compliant mode than Oracle? MySQL strengths are running in non-ACID mode way faster than its competitors. But what am I saying here?! MySQL has no competitors for non-ACID running mode, because there's no other RDBMS that doesn't care of its data integrity. The living proof is the so-called storage engine myisam, a total p.o.s. flop.
Dude, get real and start using any other database that has data integrity features built-in.
Cheers!
In the Bug Report #31876 you wrote:
"MS Knowlegebase entry
http://support.microsoft.com/kb/332023 suggests that FLAG_FILE_WRITE_THROUGH is necessary and makes the FLUSH calls redundant."
But this KB Article tells us:
"... Write Through command, which is only available for SCSI disk devices, is implemented by issuing a WRITE command to the disk with the ForceUnitAccess (FUA) bit set. [...] Support for the FUA bit is optional, and only some SCSI and Fiber Channel (FC) devices, typically individual drives (as opposed to RAID arrays), implement this functionality."
So if this method will be implemented, it must be selectable as an alternative by a parameter, e.g. in my.ini
With best regards, Roland.
"MS Knowlegebase entry
http://support.microsoft.com/kb/332023 suggests that FLAG_FILE_WRITE_THROUGH is necessary and makes the FLUSH calls redundant."
But this KB Article tells us:
"... Write Through command, which is only available for SCSI disk devices, is implemented by issuing a WRITE command to the disk with the ForceUnitAccess (FUA) bit set. [...] Support for the FUA bit is optional, and only some SCSI and Fiber Channel (FC) devices, typically individual drives (as opposed to RAID arrays), implement this functionality."
So if this method will be implemented, it must be selectable as an alternative by a parameter, e.g. in my.ini
With best regards, Roland.
True, it's almost like comparing apples and oranges. It's just not relevant.
- Shelon Padmore
- Shelon Padmore
Quicksearch
Comments
about An InnoDB tutorial
Mon, 21.07.2008 11:13
I have a problem in deleting t he child table row from my app lication using unique id. when I am using the command [...]
Mon, 21.07.2008 11:13
I have a problem in deleting t he child table row from my app lication using unique id. when I am using the command [...]
about Nermalisation
Sat, 05.07.2008 16:08
The point is that you have the option to not do, but then yo u'll be in a world of pain. Th e point is also to show [...]
Sat, 05.07.2008 16:08
The point is that you have the option to not do, but then yo u'll be in a world of pain. Th e point is also to show [...]
about Nermalisation
Fri, 04.07.2008 15:40
Nice little article, and I lik e how you've used cats in your examples :) I am a little unclear what the point h [...]
Fri, 04.07.2008 15:40
Nice little article, and I lik e how you've used cats in your examples :) I am a little unclear what the point h [...]
about Salmiakki - the official MySQL Drink
Sun, 08.06.2008 11:34
150g of liquorice are enough t o get the original Salmiakki t aste.... you can add some more , anyway
Sun, 08.06.2008 11:34
150g of liquorice are enough t o get the original Salmiakki t aste.... you can add some more , anyway
about phpvikinger.org: Things that have no name
Sun, 11.05.2008 06:34
In reply to "stuff with no nam es":very informative and succi nct. I am retired and need to learn to build a website [...]
Sun, 11.05.2008 06:34
In reply to "stuff with no nam es":very informative and succi nct. I am retired and need to learn to build a website [...]
about What is the difference between MySQL and Postgres?
Wed, 30.04.2008 14:08
what is the difference between MySql and PostgreSql?
Wed, 30.04.2008 14:08
what is the difference between MySql and PostgreSql?
about Fortune Cookie
Wed, 09.04.2008 21:46
What a random fortune, who kno ws what it means. My favorite random fortune cookie note rea ds "you will make a good [...]
Wed, 09.04.2008 21:46
What a random fortune, who kno ws what it means. My favorite random fortune cookie note rea ds "you will make a good [...]
Categories
Community (12)- DBA
- DBA Tools (2)
- I18N (2)
- Monitoring and Merlin (2)
- Operating System (5)
- Replication (1)
- Scaleout and Tuning (8)
- Security (2)
- SQL (9)
- Strangeness (5)
- Development
- Bugs (3)
- Building (1)
- Devtools (1)
- Features (2)
- Releases (8)
- Engines
- InnoDB (3)
- Memory
- MyISAM and Maria
- Languages
- LUA
- PHP (7)
- Ruby (1)
- Miscellaneous (5)
- MySQL Proxy
- Working for MySQL (7)
Syndicate This Blog
Blog Administration
Disclaimer
All examples, code-snippets, advice, trivia, etc. are supplied in the hope that they are useful, but no warranty of any kind is given. Use of trademarks is not intended as a challenge to them.
Impressum
Copyright 2005-2007 bei den jeweiligen Autorinnen der Beiträge. Die Infrastruktur von MySQL-dump wird betrieben von:
Azundris, Immanuelkirchstraße 18, 710405 Berlin, Germany