Subject Odp: [firebird-support] Decrease disk IO
Author liviuslivius@poczta.onet.pl
Post date 2013-09-19T14:25:33Z
Hi,

Saying that my advice is incorrect is wrong. If your db fit RAM then also with bad queries you get small disk IO or at best 0 disk IO.

I dont say that RAM must be bigger then db to work fast but no surprise if db have many concurrent users looking for different data in db then without big RAM well written queries will use big disk IO

Regards,
Karol Bieniaszewski

----- Reply message -----
Od: "Alexey Kovyazin (ak)" <ak@...>
Do: <firebird-support@yahoogroups.com>
Temat: Odp: [firebird-support] Decrease disk IO
Data: czw., wrz 19, 2013 07:27


 

Hi Karol,

According to your advice, there should be no database which work fast and wity size greater than RAM. :)
Your answer is incorrect.

Correct advice will be: analyze statistics for queries and optimize them with indices or rewriting.

Regards,
Alexey Kovyazin
IBSurgeon

19.09.2013 9:20 пользователь "liviuslivius@..." <liviuslivius@...> написал:
 

Hi,

You need RAM size>=db file size + 2 GB for system. And then you must configure defoultdbcache size in fb config to value >=dbfilesizeInBytes/dbpagesizeInBytes

Regards,
Karol Bieniaszewski

----- Reply message -----
Od: sopranoeli@...
Do: <firebird-support@yahoogroups.com>
Temat: [firebird-support] Decrease disk IO
Data: czw., wrz 19, 2013 02:19


 

Hello everybody!
I'm running Firebird SuperServer 2.5 at Debian. My disk is HDD and some times fbserver process waiting for IO at 99%!
How can I decrease disk IO? (other than buying SSD disk)
Thanks!
Vanina