I love dBlog!
Immagine
 Gentes... di Admin
 
"
La democrazia funziona quando a decidere sono in due e uno e' malato.

Winston Churchill
"
 
\\ MusoWeb Home Page : Articolo
MySQL is so slow on Windows 8 . . . . Really?
Di Muso (del 04/03/2013 @ 15:21:30, in Informatica, linkato 5930 volte)
taken from: mablomy

It was a standard installation of MySQL (typical install option) on plain Windows 8 Standard and the same for Windows 7. The test run was a batch of 500.000 INSERT commands in an SQL script. Runtime was 4 minutes on Win7 and 4 hours Win8.
Some tests later we found out that it was only bad on InnoDB. Finally we nailed the problem down to one parameter in MySQL:
innodb_flush_log_at_trx_commit
Each INSERT statement is a single transaction (autocommit mode). MySQL is configured very faithfully and ensures that each transaction is really stored on disk. This is necessary for ACID compliance. D in ACID stands for 'durability'. To store data durable, at least the log file has to be written physically. That's why MySQL when a transaction commits forces the operating system to flush its buffers and even forces the disk cache to flush its buffer. That's the meaning of flush_log_at_trx_commit = 1 in the my.ini or my.cnf file.
MSSQL is much more relaxed with your data. It writes the data to disk device. But it may stay in the disk cache, and MSSQL does not care. If you have a crash, your data is not up-to-date on the physical disk and you may lose data. This is definitely not ACID compliant. Microsoft documented this here:
  • By default, the disk cache is enabled. Use the 'Disk Properties', Hardware tab to access the 'Properties', 'Policy' tab to control the disk cache setting. (Note Some drives do not honor this setting. These drives require a specific manufacturer utility to disable cache.)
  • ...
  • Disk caching should be disabled in order to use the drive with SQL Server.
So to have a fair comparison beween MSSQL and MySQL either
  • set innodb_flush_log_at_trx_commit = 2
    This forces the flush to disk only once per second and brings good performance but data is not 100% safe on disk (unless you have a battery backed write cache)
  • disable the disk cache in Windows 8
    This will force MSSQL to write physically to disk. And then Win8 is 30 times slower than before. ; - )
If you need more info on the different cache levels for file IO here is a very good link:
Articolo Articolo  Storico Storico Stampa Stampa
 
# 1
Hi! I know this is kind of off topic but I was wondering if you knew where I could find a captcha plugin for my comment form? I'm using the same blog platform as yours and I'm having difficulty finding one? Thanks a lot!
Di  best watches  (inviato il 20/09/2014 @ 03:39:52)
# 2
earaerg [url=http://rthrt.com]srthsrh[/url]
Di  chanel replica  (inviato il 01/11/2014 @ 08:35:10)
# 3
f off topic but I was wondering if you knew where I could find a captcha plugin for my comment form? I'm using the same blog platfo
Di  gucci replica  (inviato il 01/11/2014 @ 08:35:55)
' Il seguente campo NON deve essere compilato.
Anti-Spam:
Testo (max 1000 caratteri)
Nome
e-Mail / Link


Disclaimer
L'indirizzo IP del mittente viene registrato, in ogni caso si raccomanda la buona educazione.


Blog ON-LINE dal 01/06/2007 
Sono state qui' 4396 persone
Sono state viste 6684 pagine
Oggi ho ricevuto 0 visite
Ieri ho ricevuto 0 visite
 
Locations of visitors to this page
 
Add to Technorati Favorites

Ci sono 574 persone collegate

< novembre 2017 >
L
M
M
G
V
S
D
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
     
             

Cerca per parola chiave
 

Titolo
Blogosfera (11)
Eventi (12)
Films (2)
Gossip Corner (4)
Informatica (51)
Lo sapevi che (49)
Personali (24)
Politica (39)
Racconti (16)
Recensioni (2)
Societa' (6)
società (11)
Spazio DIL (2)
Sport (8)
Tecnologia (21)
Top 5 (3)
Vendesi (4)

Gli interventi più cliccati

Ultimi commenti:
ciao, io sono SABRIN...
22/11/2017 @ 14:48:21
Di SABRINA BELLARDINI
Chiamo Marisa,li con...
21/11/2017 @ 05:17:29
Di Marisa Salzano
Chiamo Marisa, li co...
21/11/2017 @ 05:10:27
Di Marisa Salzano

Titolo
Eventi (16)
Header (7)
Informatica (3)
Personali (23)
Sport (14)
Vendesi (7)

Le fotografie più cliccate

Titolo
Ti piace questo blog?

 Fantastico!
 Carino...
 Così e così
 Bleah!

Titolo

Listening
Vasco
Ligabua
Doors
Caparezza
U2
Rolling Stones
Beatles

Reading
Franceschi - Fiabe della Bouna Notte
Ken Follett

Watching
Diamanti di Sangue - Blood Diamond
L'ombra del potere - The Good Shepherd



Errore Flickr RSS.




23/11/2017 @ 12:10:23
script eseguito in 1152 ms


Visitor locations