I'd like to put the new sqlite overview into service. Is there any
timeline for the 2.7 release at this point?
I'd like to put the new sqlite overview into service.
In article <s9j341$2rvp$1@842ffb22-07e1-11e5-a459-00266cf00584.csiph.com>,
Kevin Bowling <kevin.bowling@kev009.com> wrote:
I'd like to put the new sqlite overview into service.
Ah, egoboo! :-P
/Bo Lindbergh
On 6/11/21 3:21 PM, Bo Lindbergh wrote:
In article <s9j341$2rvp$1@842ffb22-07e1-11e5-a459-00266cf00584.csiph.com>, >> Kevin Bowling <kevin.bowling@kev009.com> wrote:
I'd like to put the new sqlite overview into service.
Ah, egoboo! :-P
/Bo Lindbergh
I've revived the inn-CURRENT port on FreeBSD so it is ready to use :)
https://cgit.freebsd.org/ports/tree/news/inn-CURRENT
In article <sa1g9p$1jum$1@842ffb22-07e1-11e5-a459-00266cf00584.csiph.com>, >Kevin Bowling <kevin.bowling@kev009.com> wrote:
On 6/11/21 3:21 PM, Bo Lindbergh wrote:
In article <s9j341$2rvp$1@842ffb22-07e1-11e5-a459-00266cf00584.csiph.com>, >>> Kevin Bowling <kevin.bowling@kev009.com> wrote:
I'd like to put the new sqlite overview into service.
Ah, egoboo! :-P
/Bo Lindbergh
I've revived the inn-CURRENT port on FreeBSD so it is ready to use :)
Can you update for daily snapshots?
https://cgit.freebsd.org/ports/tree/news/inn-CURRENT
--
Member - Liberal International This is doctor@@nl2k.ab.ca Ici doctor@@nl2k.ab.ca
Yahweh, Queen & country!Never Satan President Republic!Beware AntiChrist rising!
Look at Psalms 14 and 53 on Atheism https://www.empire.kred/ROOTNK?t=94a1f39b >God did not fall silent; frauds multiplied. -unknown
In article <sa26ku$inq$55@gallifrey.nk.ca>,
The Doctor <doctor@doctor.nl2k.ab.ca> wrote:
In article <sa1g9p$1jum$1@842ffb22-07e1-11e5-a459-00266cf00584.csiph.com>, >> Kevin Bowling <kevin.bowling@kev009.com> wrote:
On 6/11/21 3:21 PM, Bo Lindbergh wrote:
In article <s9j341$2rvp$1@842ffb22-07e1-11e5-a459-00266cf00584.csiph.com>, >>>> Kevin Bowling <kevin.bowling@kev009.com> wrote:
I'd like to put the new sqlite overview into service.
Ah, egoboo! :-P
/Bo Lindbergh
I've revived the inn-CURRENT port on FreeBSD so it is ready to use :)
Can you update for daily snapshots?
https://cgit.freebsd.org/ports/tree/news/inn-CURRENT
Please use https://archives.eyrie.org/software/inn/snapshots/
are source of daily updates.
Forgot about that.
--
Member - Liberal International This is doctor@@nl2k.ab.ca Ici doctor@@nl2k.ab.ca
Yahweh, Queen & country!Never Satan President Republic!Beware AntiChrist rising!
Look at Psalms 14 and 53 on Atheism https://www.empire.kred/ROOTNK?t=94a1f39b
God did not fall silent; frauds multiplied. -unknown
On 6/12/21 4:46 AM, The Doctor wrote:
In article <sa26ku$inq$55@gallifrey.nk.ca>,AntiChrist rising!
The Doctor <doctor@doctor.nl2k.ab.ca> wrote:
In article <sa1g9p$1jum$1@842ffb22-07e1-11e5-a459-00266cf00584.csiph.com>, >>> Kevin Bowling <kevin.bowling@kev009.com> wrote:
On 6/11/21 3:21 PM, Bo Lindbergh wrote:
In article <s9j341$2rvp$1@842ffb22-07e1-11e5-a459-00266cf00584.csiph.com>,
Kevin Bowling <kevin.bowling@kev009.com> wrote:
I'd like to put the new sqlite overview into service.
Ah, egoboo! :-P
/Bo Lindbergh
I've revived the inn-CURRENT port on FreeBSD so it is ready to use :)
Can you update for daily snapshots?
https://cgit.freebsd.org/ports/tree/news/inn-CURRENT
Please use https://archives.eyrie.org/software/inn/snapshots/
are source of daily updates.
Forgot about that.
--
Member - Liberal International This is doctor@@nl2k.ab.ca Ici >doctor@@nl2k.ab.ca
Yahweh, Queen & country!Never Satan President Republic!Beware
Look at Psalms 14 and 53 on Atheism https://www.empire.kred/ROOTNK?t=94a1f39b
God did not fall silent; frauds multiplied. -unknown
I was asked to rename it to inn-current >https://archives.eyrie.org/software/inn/snapshots/
One outstanding issue seems to be the the snapshots are generated daily.
That seems to cause them to flush quickly and unnecessarily. Will
need Russ or Julien to fix that to only generate them if something changes.
Regards,
Kevin
In article <saqgtj$1lio$1@842ffb22-07e1-11e5-a459-00266cf00584.csiph.com>, Kevin Bowling <kevin.bowling@kev009.com> wrote:
On 6/12/21 4:46 AM, The Doctor wrote:
In article <sa26ku$inq$55@gallifrey.nk.ca>,doctor@@nl2k.ab.ca
The Doctor <doctor@doctor.nl2k.ab.ca> wrote:
In article <sa1g9p$1jum$1@842ffb22-07e1-11e5-a459-00266cf00584.csiph.com>, >>>> Kevin Bowling <kevin.bowling@kev009.com> wrote:
On 6/11/21 3:21 PM, Bo Lindbergh wrote:
In article <s9j341$2rvp$1@842ffb22-07e1-11e5-a459-00266cf00584.csiph.com>,
Kevin Bowling <kevin.bowling@kev009.com> wrote:
I'd like to put the new sqlite overview into service.
Ah, egoboo! :-P
/Bo Lindbergh
I've revived the inn-CURRENT port on FreeBSD so it is ready to use :) >>>>>
Can you update for daily snapshots?
https://cgit.freebsd.org/ports/tree/news/inn-CURRENT
Please use https://archives.eyrie.org/software/inn/snapshots/
are source of daily updates.
Forgot about that.
--
Member - Liberal International This is doctor@@nl2k.ab.ca Ici
AntiChrist rising!Yahweh, Queen & country!Never Satan President Republic!Beware
Look at Psalms 14 and 53 on Atheism https://www.empire.kred/ROOTNK?t=94a1f39b
God did not fall silent; frauds multiplied. -unknown
I was asked to rename it to inn-current
https://archives.eyrie.org/software/inn/snapshots/
One outstanding issue seems to be the the snapshots are generated daily.
That seems to cause them to flush quickly and unnecessarily. Will
need Russ or Julien to fix that to only generate them if something changes. >>
Depends. I just compile daily and check for flaws myself.
Regards,
Kevin
On 6/21/21 1:07 PM, The Doctor wrote:
In article <saqgtj$1lio$1@842ffb22-07e1-11e5-a459-00266cf00584.csiph.com>, >> Kevin Bowling <kevin.bowling@kev009.com> wrote:
On 6/12/21 4:46 AM, The Doctor wrote:
In article <sa26ku$inq$55@gallifrey.nk.ca>,doctor@@nl2k.ab.ca
The Doctor <doctor@doctor.nl2k.ab.ca> wrote:
In article <sa1g9p$1jum$1@842ffb22-07e1-11e5-a459-00266cf00584.csiph.com>,
Kevin Bowling <kevin.bowling@kev009.com> wrote:
On 6/11/21 3:21 PM, Bo Lindbergh wrote:
In article ><s9j341$2rvp$1@842ffb22-07e1-11e5-a459-00266cf00584.csiph.com>,
Kevin Bowling <kevin.bowling@kev009.com> wrote:
I'd like to put the new sqlite overview into service.
Ah, egoboo! :-P
/Bo Lindbergh
I've revived the inn-CURRENT port on FreeBSD so it is ready to use :) >>>>>>
Can you update for daily snapshots?
https://cgit.freebsd.org/ports/tree/news/inn-CURRENT
Please use https://archives.eyrie.org/software/inn/snapshots/
are source of daily updates.
Forgot about that.
--
Member - Liberal International This is doctor@@nl2k.ab.ca Ici
AntiChrist rising!Yahweh, Queen & country!Never Satan President Republic!Beware
Look at Psalms 14 and 53 on Atheism >https://www.empire.kred/ROOTNK?t=94a1f39b
God did not fall silent; frauds multiplied. -unknown
I was asked to rename it to inn-current
https://archives.eyrie.org/software/inn/snapshots/
One outstanding issue seems to be the the snapshots are generated daily. >>> That seems to cause them to flush quickly and unnecessarily. Will
need Russ or Julien to fix that to only generate them if something changes. >>>
Depends. I just compile daily and check for flaws myself.
That's some unnecessary compiles, check the commit logs for inn it's not
like Linux or something that changes on a daily basis.
If you are on FreeBSD you only need to recompile when a dep or a commit
to inn-CURRENT itself happens to perform very thorough QA of
inn-CURRENT. poudriere makes it easy to curate your own package set
with all these deps handled in a holistic way, check this article out >https://danschmid.de/en/blog/poudriere-guide
I'd just like the snapshots to be generated if something has changed so
I don't need to bump the port so often (or, if I do, it's because things
are actually changing :)).
Regards,
Kevin
In article <sarvjk$2snl$1@842ffb22-07e1-11e5-a459-00266cf00584.csiph.com>, Kevin Bowling <kevin.bowling@kev009.com> wrote:
On 6/21/21 1:07 PM, The Doctor wrote:
In article <saqgtj$1lio$1@842ffb22-07e1-11e5-a459-00266cf00584.csiph.com>, >>> Kevin Bowling <kevin.bowling@kev009.com> wrote:<s9j341$2rvp$1@842ffb22-07e1-11e5-a459-00266cf00584.csiph.com>,
On 6/12/21 4:46 AM, The Doctor wrote:
In article <sa26ku$inq$55@gallifrey.nk.ca>,
The Doctor <doctor@doctor.nl2k.ab.ca> wrote:
In article <sa1g9p$1jum$1@842ffb22-07e1-11e5-a459-00266cf00584.csiph.com>,
Kevin Bowling <kevin.bowling@kev009.com> wrote:
On 6/11/21 3:21 PM, Bo Lindbergh wrote:
In article
https://www.empire.kred/ROOTNK?t=94a1f39bdoctor@@nl2k.ab.caKevin Bowling <kevin.bowling@kev009.com> wrote:
I'd like to put the new sqlite overview into service.
Ah, egoboo! :-P
/Bo Lindbergh
I've revived the inn-CURRENT port on FreeBSD so it is ready to use :) >>>>>>>
Can you update for daily snapshots?
https://cgit.freebsd.org/ports/tree/news/inn-CURRENT
Please use https://archives.eyrie.org/software/inn/snapshots/
are source of daily updates.
Forgot about that.
--
Member - Liberal International This is doctor@@nl2k.ab.ca Ici
AntiChrist rising!Yahweh, Queen & country!Never Satan President Republic!Beware
Look at Psalms 14 and 53 on Atheism
God did not fall silent; frauds multiplied. -unknown
I was asked to rename it to inn-current
https://archives.eyrie.org/software/inn/snapshots/
One outstanding issue seems to be the the snapshots are generated daily. >>>> That seems to cause them to flush quickly and unnecessarily. Will
need Russ or Julien to fix that to only generate them if something changes.
Depends. I just compile daily and check for flaws myself.
That's some unnecessary compiles, check the commit logs for inn it's not
like Linux or something that changes on a daily basis.
If you are on FreeBSD you only need to recompile when a dep or a commit
to inn-CURRENT itself happens to perform very thorough QA of
inn-CURRENT. poudriere makes it easy to curate your own package set
with all these deps handled in a holistic way, check this article out
https://danschmid.de/en/blog/poudriere-guide
Hopefully there is a starter's section.
I'd just like the snapshots to be generated if something has changed so
I don't need to bump the port so often (or, if I do, it's because things
are actually changing :)).
Any diff published about inn?
Regards,
Kevin
In article <s9j341$2rvp$1@842ffb22-07e1-11e5-a459-00266cf00584.csiph.com>,
Kevin Bowling <kevin.bowling@kev009.com> wrote:
I'd like to put the new sqlite overview into service.
Ah, egoboo! :-P
/Bo Lindbergh
Just a followup, it took several days to rebuild the overview DB (I
think some of this is ZFS' "fault", it throws things to a condition
variable (which enters a sleep queue) when data is not immediately
available. makehistory could help that with a bit more file read
parallelism in the future.
It went from about 6GB (ZFS lz4 compression) tradoverview to 17GB with
ZFS compression disabled and application level zlib.
Hi Kevin,
Just a followup, it took several days to rebuild the overview DB (I
think some of this is ZFS' "fault", it throws things to a condition
variable (which enters a sleep queue) when data is not immediately
available. makehistory could help that with a bit more file read
parallelism in the future.
It went from about 6GB (ZFS lz4 compression) tradoverview to 17GB with
ZFS compression disabled and application level zlib.
With ovsqlite+zlib compression, for a 1,12 GB resulting database with 3,278,095 overview records, overview rebuild took 36 mn on my slow Intel
Atom CPU N2800 1.86GHz with 2GB RAM running Debian.
Strange that it took several days for you for a resulting 17 GB
database. Lots of sleeps from ZFS then...
expireover runs in 5:20 mn.
With ovsqlite+zlib compression, for a 1,12 GB resulting database with
3,278,095 overview records, overview rebuild took 36 mn on my slow
Intel Atom CPU N2800 1.86GHz with 2GB RAM running Debian.
Thanks for the numbers, it's definitely intriguing enough I will go
looking into why ZFS struggles with this workload, it might be a
regression.
sqlite> select count(*) from artinfo;
52397838
Strange that it took several days for you for a resulting 17 GBTo learn from your experience, are you running your server on flash?
database. Lots of sleeps from ZFS then...
expireover runs in 5:20 mn.
This is on a hybrid array of two mirrored HDD pairs with a SLOG (flash
fsync fastpath) and L2ARC (flash read cache).
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 307 |
Nodes: | 16 (2 / 14) |
Uptime: | 67:14:43 |
Calls: | 6,915 |
Files: | 12,379 |
Messages: | 5,431,811 |