Date: Fri, 21 Aug 1998 11:50:21 +0200 (CEST) From: Didier Derny <didier@omnix.net> To: hackers@FreeBSD.ORG Cc: support@yard.de Subject: Re: Yard/FreeBSD problem (fwd) Message-ID: <Pine.BSF.3.96.980821114024.4540A-100000@omnix.net>
next in thread | raw e-mail | index | archive | help
Hi,
I still have many problems with Yard/FreeBSD.
I sent my programs / database to Yard last wednesday.
they did some testing on their version (FreeBSD 2.1.6)
It worked really fine except for a few slow down.
(for him 350 seconds on a pentium 133)
For me on 3.0-980594-SNAP and FreeBSD-2.2.5-STABLE
it's still unusable (I stopped the program after
25 minutes on a Pentium II 333).
We are writing some application that we are planning to
bundle with the Yard SQL engine.
I can't imagine that I would have to tell my clients that
to run our applications they have to install the FreeBSD
source code and modify the kernel and rebuild it.
do you have any idea on how we could definitively solve this
problem for 2.2.X and 3.X versions of FreeBSD ?
--
Didier Derny
didier@omnix.net
---------- Forwarded message ----------
I ran your program on our system and it shows a similar behaviour as you
describe. Below is the vmstat output, which indicates the hanging moments with
an idle time of > 50%. But these moments don't seem to be that awful.
In total your program took 350 seconds on a 133 MHz Pentium.
If the reason for this behaviour is in fact the 100 byte problem mentioned by
one the FreeBSD guys, the only possible way to solve it would be to
set ack_delayed=1 (in the kernel?). Anything we at YARD can do?
Regards
Thomas Schonhoven
PS.: I'll be back in office on Friday.
$ vmstat 2 200
procs memory page disks faults cpu
r b w avm fre flt re pi po fr sr s0 s1 c0 f0 in sy cs us sy id
3 0 0 79484 34224 9 1 0 0 6 0 2 0 0 0 233 54 13 1 0 98
2 0 0 83792 34088 19 9 0 0 0 0 21 0 0 0 350 4815 1618 66 29 5
1 0 0 83956 33924 21 4 0 0 0 0 3 0 0 0 341 5120 1736 67 31 1
2 0 0 84096 33772 22 18 0 0 0 0 3 0 0 0 333 4983 1686 72 26 2
1 0 0 80028 33620 21 2 0 0 0 0 3 0 0 0 343 5048 1714 67 32 2
2 0 0 80176 33472 23 10 0 0 0 0 3 0 0 0 332 4954 1667 72 26 2
1 0 0 71404 33324 19 3 0 0 0 0 4 0 0 0 336 5048 1714 63 34 2
1 0 0 71552 33176 20 2 0 0 0 0 3 0 0 0 337 5032 1717 66 32 2
1 0 0 71692 33036 19 11 0 0 0 0 5 0 0 0 334 5015 1677 66 33 1
1 0 0 71844 32884 20 1 0 0 0 0 6 0 0 0 340 4991 1693 66 32 2
1 0 0 63400 32736 20 6 0 0 0 0 5 0 0 0 335 5042 1684 71 28 0
2 0 0 59372 32584 20 0 0 0 0 0 5 0 0 0 336 4998 1700 66 32 2
2 0 0 59520 32436 19 8 0 0 0 0 6 0 0 0 335 4992 1677 66 33 2
2 0 0 59664 32292 19 0 0 0 0 0 5 0 0 0 338 5019 1722 68 30 2
2 0 0 59812 32144 19 6 0 0 0 0 7 0 0 0 337 4974 1660 69 29 2
1 0 0 64140 32000 19 0 0 0 0 0 4 0 0 0 340 5102 1745 66 33 1
2 0 0 72720 31848 149 9 0 0 110 0 10 0 0 0 338 4937 1637 68 30 2
2 0 0 72868 31700 19 2 0 0 0 0 8 0 0 0 339 4962 1683 66 31 3
1 0 0 73012 31556 19 3 0 0 0 0 4 0 0 0 344 5021 1721 62 37 1
1 0 0 73084 31484 13 8 0 0 0 0 38 0 0 0 316 2615 840 32 18 50
2 0 0 73164 31400 15 0 0 0 0 0 1 0 0 0 283 2546 874 37 13 50
1 0 0 73308 31256 19 0 0 0 0 0 3 0 0 0 337 5040 1718 64 35 1
2 0 0 73456 31108 19 6 0 0 0 0 3 0 0 0 336 4908 1647 66 33 1
1 0 0 73604 30960 19 0 0 0 0 0 3 0 0 0 339 5021 1705 72 27 0
2 0 0 73748 30816 19 5 0 0 0 0 3 0 0 0 333 4968 1674 70 30 1
2 0 0 69716 30664 20 0 0 0 0 0 3 0 0 0 337 5045 1719 67 32 1
1 0 0 61428 30520 19 3 0 0 0 0 3 0 0 0 333 4982 1673 72 27 1
1 0 0 61580 30368 20 0 0 0 0 0 3 0 0 0 336 5081 1739 67 31 1
3 0 0 61728 30220 19 0 0 0 0 0 3 0 0 0 336 4990 1681 67 32 2
1 0 0 61876 30072 19 4 0 0 0 0 3 0 0 0 334 5000 1658 71 28 1
0 0 0 66124 30004 10 0 0 0 0 0 31 0 0 0 310 2339 751 29 14 57
0 0 0 70376 29928 10 0 0 0 0 0 21 0 0 0 304 2542 868 34 16 50
2 0 0 70464 29840 12 3 0 0 0 0 1 0 0 0 290 2858 952 42 16 43
2 0 0 70608 29696 19 0 0 0 0 0 4 0 0 0 341 5064 1718 68 31 1
2 0 0 70760 29544 20 3 0 0 0 0 2 0 0 0 334 4973 1654 69 30 1
2 0 0 70908 29396 19 0 0 0 0 0 3 0 0 0 337 5005 1697 69 30 1
2 0 0 71056 29248 19 0 0 0 0 0 3 0 0 0 336 4996 1701 72 27 1
2 0 0 71200 29104 19 3 0 0 0 0 2 0 0 0 333 4980 1668 70 30 1
1 0 0 71348 28956 19 0 0 0 0 0 3 0 0 0 337 5041 1721 66 33 1
2 0 0 71500 28804 20 5 0 0 0 0 3 0 0 0 334 4979 1678 69 30 1
1 0 0 67456 28664 18 0 0 0 0 0 3 0 0 0 333 5044 1715 66 33 0
2 0 0 63436 28504 21 1 0 0 0 0 4 0 0 0 338 4949 1650 67 31 2
2 0 0 63580 28360 19 0 0 0 0 0 3 0 0 0 336 5033 1708 66 33 1
2 0 0 63724 28216 19 4 0 0 0 0 6 0 0 0 337 4964 1659 69 29 1
2 0 0 63880 28060 20 0 0 0 0 0 3 0 0 0 334 5016 1700 63 35 2
2 0 0 68204 27920 18 1 0 0 0 0 3 0 0 0 335 4988 1671 72 27 1
1 0 0 76784 27772 21 0 0 0 1 0 12 0 0 0 344 5016 1695 70 30 1
1 0 0 76932 27624 19 0 0 0 0 0 7 0 0 0 343 4980 1683 65 33 2
1 0 0 77072 27484 18 3 0 0 0 0 5 0 0 0 340 4868 1626 64 33 4
1 0 0 77224 27332 20 0 0 0 0 0 4 0 0 0 340 5035 1697 67 32 1
2 1 0 77368 27188 19 5 0 0 0 0 7 0 0 0 336 4907 1654 72 27 2
0 0 0 77372 27184 1 0 0 0 0 0 39 0 0 0 275 397 81 3 2 95
1 0 0 77516 27040 19 0 0 0 0 0 3 0 0 0 332 4789 1605 66 29 5
1 0 0 77664 26892 19 2 0 0 0 0 4 0 0 0 339 4928 1648 68 31 1
2 0 0 77808 26748 19 0 0 0 0 0 4 0 0 0 337 5024 1709 63 36 1
1 0 0 73772 26600 19 5 0 0 0 0 2 0 0 0 334 4977 1666 68 30 2
2 0 0 65492 26448 20 0 0 0 0 0 3 0 0 0 337 5028 1703 63 36 1
--
///!! ///!! //!! ////////////!! ///////////!!
///!! ///!! ////!! ///!! ///!! ///!! ///!!
///!! ///!! //////!! ///!! ///!! ///!! ///!!
///!! ///!! ///!////!! ///////////!! ///!! ///!!
///!! ///!! ///!! ////!! //////////!! ///!! ///!!
//////!! ///!! ////!! ///!! ///!! ///!! ///!!
////!! //////////////!! ///!! ///!! ///!! ///!!
////!! ////!! ////!! ///!! ///!! ///////////!!
YARD Software GmbH YARD Software Ltd.
Wikingerstr. 18 - 20 Wikingerstr. 18 - 20
51107 Koeln 51107 Cologne
Tel.: +4922198664-0
FAX.: +4922198664-99 E-Mail: support@yard.de
FTP : ftp.yard.de
WWW : http://www.yard.de
To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-hackers" in the body of the message
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?Pine.BSF.3.96.980821114024.4540A-100000>