Cache database SQLite3 and "Unable to execute statement: database is locked"

Started by Massl, October 03, 2019, 12:28:09 PM

Previous topic - Next topic

Massl

Hi, in the error log I find many:
2: SQLite3::query(): Unable to execute statement: database is locked
/home/public_html/Sources/CacheAPI-sqlite.php (Riga 83)


Is it a configuration problem?
I only activated the cache database SQLite3

SMF 2.1 RC2 with default theme without mods.

Thanks  :)

Arantor

Don't use it, your site is possibly too busy for it to be good for you. Use one of the others instead.


Massl

I have activated APCu from PHP (7.3) and selected the APCu cache, it seems very fast.

albertlast

i did a small test run on a mid size smf 2.1 (nighty from today) setup,
APCu cache came on read performance benchmark 10750 and
PostgresCache got 10643 reads
non cache got 9341.

the diff of 100 reads i would say are more or less equal.

Like always had in mind that this is a synthetic benchmark.

Massl

Thanks, very interesting :)

I'd like to know the results of other caches to make comparisons, do you know where I can find more information?

Advertisement: