9/1/2023 0 Comments Sqlite vs postgresql![]() Though not sure whether this would be noticeable to the user. SQLite, however, is what is known as an embedded database. MySQL uses a database server to run on a network, which can then be accessed by the client. Next, we can take a look at how it runs or what it runs on. This may (notionally?) improve reliability, though performance-wise I guess it’s maybe somewhat of a toss-up? I’m in particular conscious that having all data be pulled from the DB over a network (rather than from local disk) may introduce some extra latency. While MySQL is managed by Oracle, SQLite’s code is available for both personal and commercial use in the public domain. We’re considering moving the datastore to a Postgres RDS instance in AWS. Which also bring to mind the possibility of on-disk data corruption. With the SQLite backend, I’m somewhat spooked by a a large number of messages like Apr 18 13:32:30 xxx grafana-server: t=T13:32:30+0000 lvl=info msg="Database table locked, sleeping then retrying" logger=sqlstore retry=1Īpr 18 13:32:30 xxx grafana-server: t=T13:32:30+0000 lvl=info msg="Database table locked, sleeping then retrying" logger=sqlstore retry=0Īpr 18 13:32:30 xxx grafana-server: t=T13:32:30+0000 lvl=info msg="Database table locked, sleeping then retrying" logger=sqlstore retry=2 Should we consider switching backend nonetheless? In a single-host environment, are there potential performance or reliability advantages to using an external PostgreSQL/MySQL store for Grafana’s database, instead of the on-disk SQLite database?Īn external database engine would obviously be required in order to run a multi-host HA environment - and while we may shift to that in the future, it’s not something we’re doing just yet. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |