|Subject||RE: Odp: [firebird-support] Decrease disk IO|
Thanks Karol and Alexey!
Since I can't add more RAM, I'll focus in optimize queries.
--- In firstname.lastname@example.org, <liviuslivius@...> wrote: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
Karol Bieniaszewski----- Reply message -----
Od: "Alexey Kovyazin (ak)" <ak@...>
Temat: Odp: [firebird-support] Decrease disk IO
Data: czw., wrz 19, 2013 07:27
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.
IBSurgeon19.09.2013 9:20 пользователь "liviuslivius@..." <liviuslivius@...> написал:
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
----- Reply message -----
Temat: [firebird-support] Decrease disk IO
Data: czw., wrz 19, 2013 02:19
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)