Meta tags:
Headings (most frequently used words):
popular, blog, linux, tipps, fixes, more, all, time, this, month, links, you, might, also, like, my, list, archive, labels, speeding, up, your, owncloud, on, small, systems, such, as, the, raspberry, pi, with, sqlite, no, comments, post, comment,
Text of the page (most frequently used words):
the (45), and (23), for (22), with (22), your (19), you (18), #owncloud (15), linux (15), this (11), may (11), pragma (11), video (10), how (9), sqlite (9), february (8), march (8), april (8), www (8), source (7), not (7), open (7), ubuntu (7), july (7), august (7), more (7), using (6), performance (6), power (6), september (6), november (6), december (6), january (6), such (6), free (6), avchd (6), post (6), will (6), that (6), setting (6), args (6), but (6), vaapi (5), poulsbo (5), android (5), june (5), october (5), help (5), out (5), interlaced (5), tweaks (5), comments (5), these (5), https (5), org (5), html (5), getconnection (5), executeupdate (5), database (5), sqlite3 (5), fixes (4), development (4), from (4), small (4), blog (4), cron (4), every (4), quality (4), set (4), all (4), some (4), fps (4), 5000 (4), settings (4), php (4), hardware (3), files (3), memory (3), backup (3), msi (3), wind (3), u110 (3), news (3), script (3), software (3), links (3), tipps (3), speeding (3), systems (3), via (3), guide (3), old (3), new (3), list (3), use (3), display (3), directory (3), getting (3), last (3), drop (3), recordings (3), might (3), also (3), following (3), make (3), have (3), found (3), high (3), transcoding (3), ffmpeg (3), accelerated (3), can (3), mencoder (3), please (3), journal_mode (3), wal (3), var (3), haven (3), raspberry (3), phone (3), note (2), google (2), mobile (2), pictures (2), bling (2), servers (2), control (2), regex (2), system (2), advanced (2), latency (2), videos (2), shell (2), privacy (2), benchmark (2), kernel (2), intel (2), does (2), anywhere (2), internet (2), drivers (2), tips (2), fix (2), howto (2), bugs (2), labels (2), change (2), public (2), switch (2), 2015 (2), 2017 (2), click (2), just (2), laptop (2), because (2), life (2), cheap (2), code (2), nvidia (2), nvk (2), vulkan (2), driver (2), dlss (2), now (2), usually (2), cern (2), only (2), home (2), external (2), boot (2), xrandr (2), understanding (2), rights (2), decoding (2), search (2), view (2), top (2), one (2), reduce (2), consumption (2), root (2), cpu (2), need (2), efficient (2), any (2), situation (2), very (2), nice (2), problem (2), svn (2), sync (2), are (2), necessary (2), gma500 (2), karmic (2), much (2), camera (2), find (2), progressive (2), x264 (2), kde4 (2), bug (2), flickering (2), fixing (2), popular (2), into (2), side (2), less (2), during (2), playback (2), updated (2), file (2), atom (2), subscribe (2), related (2), temp_store (2), cache_size (2), synchronous (2), sensitive (2), include (2), add (2), should (2), think (2), data (2), journal (2), sure (2), significantly (2), most (2), higher (2), tool (2), improve (2), mostly (2), speed (2), had (2), already (2), picture, window, theme, powered, blogger, webpage, analytics, address, used, geo, location, purposes, version, vorbis, udev, synaptics, scanning, programming, off, topic, malware, irda, health, gproftpd, getlibs, fuse, ftp, ffm, favorites, eink, reader, devices, booting, stories, skype, remote, p2p, intellectual, property, fstab, ebooks, downloads, compilation, chmod, bios, tutorial, tests, saving, money, permissions, libraries, cli, printing, netbooks, kindle, ideas, dbus, codecs, closed, 32bit, sound, mobility, flamewar, features, storage, media, learners, deutsch, random, access, plasma, games, 64bit, windows, graphics, wine, websites, fit, thoughts, funny, reviews, politics, xorg, management, security, network, browsers, kde, 215, 2008, 2009, 133, 2010, 2011, 2012, 2013, 2014, volume, active, lock, scree, two, ways, download, picasaweb, accessing, shares, webdav, ultimate, setup, sys, dynamically, between, uniprocessor, 2016, 2019, archive, librenix, kerneltrap, viewlike, famed, race, horse, classic, book, don, throw, away, banged, little, even, seems, give, projects, lifehacker, sourcery, merged, today, mesa, devel, capable, handling, deep, learning, super, sampling, supports, phoronix, european, laboratory, particle, physics, called, birthplace, world, wide, web, large, hadron, migration, path, centos, debian, lwn, net, ssh, agent, scripts, keychain, ultravnc, single, testing, ext3, ext4, partitions, optimized, raid5, tiny, rsync, automatically, connected, floppy, disk, images, grub, complete, browser, like, wolfram, alpha, traces, unix, commands, liners, generator, computer, license, game, wikipedia, online, radio, favorite, common, problems, glasnost, test, isp, shaping, traffic, catalog, kernels, explain, tuner, completely, app, actually, solution, definition, got, checkout, fast, pal, encoding, avhcd, mpeg4, under, slightly, outdated, repositories, originall, ever, wondered, deliver, helps, encodes, disappointed, causes, latencies, second, here, caused, freezing, month, putting, group, processes, jail, first, steps, groups, create, bottom, imagemagick, converting, alternate, frame, sequencing, watt, audio, pulseaudio, interrupt, alsa, example, gma, 500, extend, battery, cpufreq, governor, usb, issues, samsung, other, tvs, invalid, time, feed, magazine, about, older, newer, appreciate, feel, write, anything, wish, selected, questions, published, comment, posts, feedback, benchmarks, welcome, inform, developers, linking, case, report, after, solving, inmemorydb, tempfiles, pragma_temp_store, pragma_synchronous, pragma_cache_size, case_sensitive_like, casesensitivelike, true, false, function, postconnect, connectioneventargs, users, patch, enable, tuning, modify, lib, private, sqlitesessioninit, lines, update, cleans, morning, line, checked, whether, something, similar, doesn, vacuum, finally, recommend, another, job, nightly, cleanup, repeats, cache, improves, incorporates, entire, size, roughly, they, well, spent, important, good, way, there, further, them, stick, default_cache_size, directly, insert, writing, information, calendar, telling, check, filesystem, changes, useful, tools, works, filesystem_check_changes, config, seriously, considered, server, pretty, same, capabilities, cyanogen, has, wifi, flash, space, included, opted, installations, was, great, easy, seen, else, assuming, than, sudo, apt, get, install, before, start, opcache, usual, friday, self, desk, selection, tutorials, howtos,
Text of the page (random words):
linux tipps fixes more speeding up your owncloud on small systems such as the raspberry pi with sqlite linux tipps fixes more your linux self help desk a selection of mostly linux related tutorials howtos fixes news and more speeding up your owncloud on small systems such as the raspberry pi with sqlite friday may 15 2015 i had seriously considered to use a raspberry pi system for setting up my owncloud server but the old pi had pretty much the same capabilities as my old mobile phone with cyanogen and the phone has wifi and some flash space already included so i opted for the phone as with most pi installations the performance was not great but i found some easy tweaks i haven t seen anywhere else to significantly improve the performance i m assuming you re already using the usual tweaks such as opcache this will usually help more than the following tweaks and using cron php please backup your owncloud db before you start you will need the sqlite3 tool sudo apt get install sqlite3 in your config php you can include these settings for more speed sqlite journal_mode wal works with owncloud 8 and higher filesystem_check_changes 0 the journal setting should improve mostly the speed for writing new information such as during a calendar sync telling not to check the filesystem for changes is useful if you only change files via owncloud not via external tools some more settings we will directly insert into the database with the sqlite3 tool sqlite3 var www owncloud data owncloud db pragma journal_mode wal pragma cache_size 5000 pragma default_cache_size 5000 this repeats the journal setting i m not sure if that s necessary the cache setting significantly improves the performance i set it to 5000 because that incorporates the entire database size for me that will be up to roughly 5 mb of memory but i think they re well spent it might be the most important setting but i haven t found a good way to benchmark this there are further settings for higher performance such as temp_store synchronous 1 but i m not sure how to make them stick in the database finally i recommend to add another cron job for a nightly database cleanup 0 3 nice sqlite3 var www owncloud data owncloud db vacuum this cleans up the database every morning at 3 am it should all go in one line i haven t checked whether cron php does something similar but i think it doesn t update for the advanced users you can patch the code to include these settings to enable all sqlite tuning modify the file var www owncloud lib private db sqlitesessioninit php to add these lines public function postconnect connectioneventargs args sensitive this casesensitivelike true false args getconnection executeupdate pragma case_sensitive_like sensitive args getconnection executeupdate pragma synchronous 1 args getconnection executeupdate pragma journal_mode wal args getconnection executeupdate pragma cache_size 5000 args getconnection executeupdate pragma temp_store 2 https www sqlite org pragma html pragma_cache_size https www sqlite org pragma html pragma_synchronous https www sqlite org pragma html pragma_temp_store https www sqlite org tempfiles html https www sqlite org inmemorydb html feedback and benchmarks welcome if you find bugs please note that in the comments also please inform the developers you re using these tips by linking to this post in case you report a bug after using these tweaks it may help with solving a problem related posts no comments post a comment i appreciate comments feel free to write anything you wish selected comments and questions will be published newer post older post home subscribe to post comments atom about me and this blog magazine view search this blog subscribe to the atom news feed or to labels all time popular make your android power efficient in any situation for free how to set up x and vaapi accelerated hd video on the msi wind u110 gma500 poulsbo and ubuntu karmic 9 10 fixing usb playback issues for video files on lg samsung and other tvs e g invalid file updated 2017 reduce power consumption extend battery life of your android with cpufreq governor tweaks setting up vaapi hardware accelerated video decoding for ubuntu 10 04 example intel poulsbo gma 500 understanding directory rights in linux 0 4 watt less during audio playback updated power performance pulseaudio interrupt less alsa create side by side or top bottom 3d video with ffmpeg and imagemagick or mencoder by converting alternate frame sequencing 3d video putting a group of processes into a cpu and memory jail first steps with control groups in linux transcoding 50 fps interlaced avchd to 50 fps progressive x264 with mencoder getting every last drop of quality out of your interlaced avchd recordings popular this month fixing xrandr caused high latency with kde4 display flickering freezing videos if you re using kde4 you might be disappointed by a bug that causes high latencies and or a flickering second display here s a re transcoding 50 fps interlaced avchd to 50 fps progressive x264 with mencoder getting every last drop of quality out of your interlaced avchd recordings have you ever wondered how much quality your hd camera can deliver this script helps you to find it out if you have a camera that encodes i how to set up x and vaapi accelerated hd video on the msi wind u110 gma500 poulsbo and ubuntu karmic 9 10 the following guide is now slightly outdated as ubuntu 10 04 is out and new drivers are necessary also some of the repositories i originall fast pal hd video encoding in sync with ffmpeg svn from avhcd to mpeg4 under linux i have actually found a very very nice solution to the high definition video avchd transcoding problem i got the ffmpeg svn checkout from make your android power efficient in any situation for free in the following post i will explain how to use cpu tuner a completely free and open source app for android all you need is root and so links cheap root servers development kernels for ubuntu free software catalog glasnost test if your isp is shaping your traffic how to fix common linux problems my favorite software online radio directory open source game list wikipedia open source license list reduce computer power consumption regex generator shell commands top one liners unix help view your internet traces wolfram alpha search z more links you might also like complete guide to browser privacy howto set up vaapi hardware video decoding for poulsbo getting every last drop of quality out of your interlaced avchd recordings how to boot floppy disk images with grub understanding directory rights in linux automatically switch to connected external display on boot with xrandr a tiny backup script with rsync ext3 and ext4 partitions optimized for raid5 help linux development by testing the development kernel in ubuntu ultravnc single click and linux use your ssh agent for cron scripts with keychain my blog list lwn net cern s migration path from centos linux to debian the european laboratory for particle physics usually just called cern is not only the birthplace of the world wide web it is home to the large hadron phoronix open source nvidia nvk vulkan driver now supports dlss with the code merged today to mesa 26 2 devel the open source nvidia nvk vulkan driver is capable of handling deep learning super sampling dlss with m lifehacker open sourcery give an old laptop new life with cheap or free projects click to viewlike a famed race horse or a classic book you don t just throw away a laptop because it s banged up a little even if it seems ou kerneltrap librenix blog archive 2019 2 september 1 august 1 2017 3 july 3 2016 4 july 1 may 2 february 1 2015 20 august 2 june 1 may 6 how to dynamically switch between uniprocessor and the ultimate setup guide for owncloud on small sys accessing public owncloud shares via webdav speeding up your owncloud on small systems such as two ways to download your pictures from picasaweb how to change the volume with an active lock scree april 4 march 6 february 1 2014 22 december 1 november 1 september 1 may 7 april 2 march 1 january 9 2013 31 december 2 november 2 october 2 june 5 may 7 april 4 march 2 february 2 january 5 2012 25 december 3 november 2 october 3 september 1 august 1 july 1 may 3 april 3 march 3 february 3 january 2 2011 72 october 4 september 4 august 7 july 8 june 15 may 17 april 7 march 2 february 1 january 7 2010 133 december 11 november 19 october 20 september 16 august 24 july 6 june 12 may 3 april 4 march 7 february 2 january 9 2009 84 december 7 november 6 august 3 july 1 may 8 april 8 march 27 february 10 january 14 2008 215 december 20 november 47 october 33 september 35 august 16 july 16 june 30 may 3 april 2 march 2 february 11 labels tipps links linux bugs howto video ubuntu kde software open source browsers network security google development power management fix android script xorg tips politics reviews funny performance thoughts drivers internet news does not fit anywhere msi wind u110 intel kernel poulsbo websites wine benchmark backup graphics privacy windows 64bit games fixes plasma random access memory deutsch files for linux learners storage media vaapi features flamewar hardware mobility sound 32bit closed source codecs dbus ideas kindle netbooks printing shell videos cli latency libraries linux advanced permissions saving money system tests tutorial bios chmod compilation downloads ebooks fstab intellectual property owncloud p2p regex remote control servers skype stories 11 3d bling bling booting c eink reader devices favorites ffm ftp fuse getlibs gproftpd health irda malware off topic pictures programming scanning synaptics udev vorbis mobile version note this webpage is using google analytics and your ip address is used for geo location purposes picture window theme powered by blogger
|
