Tag: database

Optimize Firefox's sqlite databases

Here’s a handy one-liner to tune a bit your Firefox: 1for file in ~/.mozilla/firefox/*/*.sqlite; do sqlite3 $file ‘VACUUM;’;done What this does ie optimize every sqlite database in your account’s profiles. You can even add this line to a script to…

MariaDB vs MySQL short benchmark

Considering switching from MySQL to MariaDB? Me too. I wanted to see if I can look towards any performance improvements (or drops). I don’t have high level needs, I’m sure more comprehensive tests exist. This is simple run-all-tests.pl from sql-bench…