I'm using Apache TVM do benchmark DL models - this is long story, but I want to preview GPU usage of TVM. On Android device I have runing APK, which spawn 1-2 processes, which use GPU. I have turned on "GPU Profiling", and I dumped logs via adb shell dumpsys gfxinfo. But I'm not sure how to properly read it? Example of TVM process is below. My questions: 1. do you know any tutorial/instruction for reading and understanding following stats? how to interpret it? 2. I do not care about jank frames, I need information about GPU usage, GPU memory usage

** Graphics info for pid 14811 [org.apache.tvm.tvmrpc:RPCProcess] **

Stats since: 5644930627488ns
Total frames rendered: 1
Janky frames: 1 (100.00%)
50th percentile: 97ms
90th percentile: 97ms
95th percentile: 97ms
99th percentile: 97ms
Number Missed Vsync: 0
Number High input latency: 0
Number Slow UI thread: 1
Number Slow bitmap uploads: 0
Number Slow issue draw commands: 1
Number Frame deadline missed: 1
HISTOGRAM: 5ms=0 6ms=0 7ms=0 8ms=0 9ms=0 10ms=0 11ms=0 12ms=0 13ms=0 14ms=0 15ms=0 16ms=0 17ms=0 18ms=0 19ms=0 20ms=0 21ms=0 22ms=0 23ms=0 24ms=0 25ms=0 26ms=0 27ms=0 28ms=0 29ms=0 30ms=0 31ms=0 32ms=0 34ms=0 36ms=0 38ms=0 40ms=0 42ms=0 44ms=0 46ms=0 48ms=0 53ms=0 57ms=0 61ms=0 65ms=0 69ms=0 73ms=0 77ms=0 81ms=0 85ms=0 89ms=0 93ms=0 97ms=1 101ms=0 105ms=0 109ms=0 113ms=0 117ms=0 121ms=0 125ms=0 129ms=0 133ms=0 150ms=0 200ms=0 250ms=0 300ms=0 350ms=0 400ms=0 450ms=0 500ms=0 550ms=0 600ms=0 650ms=0 700ms=0 750ms=0 800ms=0 850ms=0 900ms=0 950ms=0 1000ms=0 1050ms=0 1100ms=0 1150ms=0 1200ms=0 1250ms=0 1300ms=0 1350ms=0 1400ms=0 1450ms=0 1500ms=0 1550ms=0 1600ms=0 1650ms=0 1700ms=0 1750ms=0 1800ms=0 1850ms=0 1900ms=0 1950ms=0 2000ms=0 2050ms=0 2100ms=0 2150ms=0 2200ms=0 2250ms=0 2300ms=0 2350ms=0 2400ms=0 2450ms=0 2500ms=0 2550ms=0 2600ms=0 2650ms=0 2700ms=0 2750ms=0 2800ms=0 2850ms=0 2900ms=0 2950ms=0 3000ms=0 3050ms=0 3100ms=0 3150ms=0 3200ms=0 3250ms=0 3300ms=0 3350ms=0 3400ms=0 3450ms=0 3500ms=0 3550ms=0 3600ms=0 3650ms=0 3700ms=0 3750ms=0 3800ms=0 3850ms=0 3900ms=0 3950ms=0 4000ms=0 4050ms=0 4100ms=0 4150ms=0 4200ms=0 4250ms=0 4300ms=0 4350ms=0 4400ms=0 4450ms=0 4500ms=0 4550ms=0 4600ms=0 4650ms=0 4700ms=0 4750ms=0 4800ms=0 4850ms=0 4900ms=0 4950ms=0
50th gpu percentile: 4950ms
90th gpu percentile: 4950ms
95th gpu percentile: 4950ms
99th gpu percentile: 4950ms
GPU HISTOGRAM: 1ms=0 2ms=0 3ms=0 4ms=0 5ms=0 6ms=0 7ms=0 8ms=0 9ms=0 10ms=0 11ms=0 12ms=0 13ms=0 14ms=0 15ms=0 16ms=0 17ms=0 18ms=0 19ms=0 20ms=0 21ms=0 22ms=0 23ms=0 24ms=0 25ms=0 4950ms=0
Font Cache (CPU):
  Size: 2.66 kB 
  Glyph Count: 2 
CPU Caches:
GPU Caches:
  Other:
    Other: 988.00 bytes (1 entry)
  Shadow Gaussian Falloff:
    Texture: 128.00 bytes (1 entry)
  Scratch:
    Buffer Object: 48.00 KB (1 entry)
    Texture: 2.00 MB (1 entry)
Other Caches:
                         Current / Maximum
  Layers Total           0.00 KB (numLayers = 0)
Total GPU memory usage:
  2147420 bytes, 2.05 MB (128.00 bytes is purgeable)


Pipeline=Skia (OpenGL)
Profile data in ms:

	org.apache.tvm.tvmrpc/org.apache.tvm.tvmrpc.RPCActivity/android.view.ViewRootImpl@a9f6eba (visibility=0)
	Draw	Prepare	Process	Execute

Window: org.apache.tvm.tvmrpc/org.apache.tvm.tvmrpc.RPCActivity
Stats since: 5644998711873ns
Total frames rendered: 1
Janky frames: 1 (100.00%)
50th percentile: 97ms
90th percentile: 97ms
95th percentile: 97ms
99th percentile: 97ms
Number Missed Vsync: 0
Number High input latency: 0
Number Slow UI thread: 1
Number Slow bitmap uploads: 0
Number Slow issue draw commands: 1
Number Frame deadline missed: 1
HISTOGRAM: 5ms=0 6ms=0 7ms=0 8ms=0 9ms=0 10ms=0 11ms=0 12ms=0 13ms=0 14ms=0 15ms=0 16ms=0 17ms=0 18ms=0 19ms=0 20ms=0 21ms=0 22ms=0 23ms=0 24ms=0 25ms=0 26ms=0 27ms=0 28ms=0 29ms=0 30ms=0 31ms=0 32ms=0 34ms=0 36ms=0 38ms=0 40ms=0 42ms=0 44ms=0 46ms=0 48ms=0 53ms=0 57ms=0 61ms=0 65ms=0 69ms=0 73ms=0 77ms=0 81ms=0 85ms=0 89ms=0 93ms=0 97ms=1 101ms=0 105ms=0 109ms=0 113ms=0 117ms=0 121ms=0 125ms=0 129ms=0 133ms=0 150ms=0 200ms=0 250ms=0 300ms=0 350ms=0 400ms=0 450ms=0 500ms=0 550ms=0 600ms=0 650ms=0 700ms=0 750ms=0 800ms=0 850ms=0 900ms=0 950ms=0 1000ms=0 1050ms=0 1100ms=0 1150ms=0 1200ms=0 1250ms=0 1300ms=0 1350ms=0 1400ms=0 1450ms=0 1500ms=0 1550ms=0 1600ms=0 1650ms=0 1700ms=0 1750ms=0 1800ms=0 1850ms=0 1900ms=0 1950ms=0 2000ms=0 2050ms=0 2100ms=0 2150ms=0 2200ms=0 2250ms=0 2300ms=0 2350ms=0 2400ms=0 2450ms=0 2500ms=0 2550ms=0 2600ms=0 2650ms=0 2700ms=0 2750ms=0 2800ms=0 2850ms=0 2900ms=0 2950ms=0 3000ms=0 3050ms=0 3100ms=0 3150ms=0 3200ms=0 3250ms=0 3300ms=0 3350ms=0 3400ms=0 3450ms=0 3500ms=0 3550ms=0 3600ms=0 3650ms=0 3700ms=0 3750ms=0 3800ms=0 3850ms=0 3900ms=0 3950ms=0 4000ms=0 4050ms=0 4100ms=0 4150ms=0 4200ms=0 4250ms=0 4300ms=0 4350ms=0 4400ms=0 4450ms=0 4500ms=0 4550ms=0 4600ms=0 4650ms=0 4700ms=0 4750ms=0 4800ms=0 4850ms=0 4900ms=0 4950ms=0
50th gpu percentile: 4950ms
90th gpu percentile: 4950ms
95th gpu percentile: 4950ms
99th gpu percentile: 4950ms
GPU HISTOGRAM: 1ms=0 2ms=0 3ms=0 4ms=0 5ms=0 6ms=0 7ms=0 8ms=0 9ms=0 10ms=0 11ms=0 12ms=0 13ms=0 14ms=0 15ms=0 16ms=0 17ms=0 18ms=0 19ms=0 20ms=0 21ms=0 22ms=0 23ms=0 24ms=0 25ms=0 4950ms=0


---PROFILEDATA---
Flags,IntendedVsync,Vsync,OldestInputEvent,NewestInputEvent,HandleInputStart,AnimationStart,PerformTraversalsStart,DrawStart,SyncQueued,SyncStart,IssueDrawCommandsStart,SwapBuffers,FrameCompleted,DequeueBufferDuration,QueueBufferDuration,GpuCompleted,
1,5645013569772,5645013569772,9223372036854775807,0,5645014148949,5645014150180,5645014151103,5645081986026,5645084159488,5645092585719,5645092703796,5645118001873,5645120370719,0,1326769,0,
8,5645030205523,5645113538858,9223372036854775807,0,5645125786949,5645125790103,5645125954565,5645126136103,5645126148565,5645126504257,0,0,0,0,0,0,
---PROFILEDATA---


View hierarchy:

  org.apache.tvm.tvmrpc/org.apache.tvm.tvmrpc.RPCActivity/android.view.ViewRootImpl@a9f6eba
  14 views, 26.56 kB of render nodes


Total ViewRootImpl   : 1
Total attached Views : 14
Total RenderNode     : 26.56 kB (used) / 97.82 kB (capacity)

And this is log only for Apk:

Applications Graphics Acceleration Info:
Uptime: 6901736 Realtime: 6901736

** Graphics info for pid 12574 [org.apache.tvm.tvmrpc] **

Stats since: 500523944950ns
Total frames rendered: 439
Janky frames: 23 (5.24%)
50th percentile: 6ms
90th percentile: 10ms
95th percentile: 19ms
99th percentile: 61ms
Number Missed Vsync: 1
Number High input latency: 69
Number Slow UI thread: 12
Number Slow bitmap uploads: 0
Number Slow issue draw commands: 5
Number Frame deadline missed: 13
HISTOGRAM: 5ms=199 6ms=39 7ms=45 8ms=72 9ms=21 10ms=20 11ms=7 12ms=5 13ms=1 14ms=3 15ms=4 16ms=0 17ms=1 18ms=0 19ms=1 20ms=0 21ms=0 22ms=0 23ms=0 24ms=3 25ms=1 26ms=0 27ms=1 28ms=1 29ms=3 30ms=0 31ms=1 32ms=3 34ms=0 36ms=0 38ms=0 40ms=1 42ms=2 44ms=0 46ms=0 48ms=0 53ms=0 57ms=0 61ms=1 65ms=0 69ms=0 73ms=1 77ms=0 81ms=0 85ms=1 89ms=0 93ms=0 97ms=0 101ms=0 105ms=0 109ms=0 113ms=0 117ms=0 121ms=0 125ms=0 129ms=0 133ms=0 150ms=0 200ms=1 250ms=1 300ms=0 350ms=0 400ms=0 450ms=0 500ms=0 550ms=0 600ms=0 650ms=0 700ms=0 750ms=0 800ms=0 850ms=0 900ms=0 950ms=0 1000ms=0 1050ms=0 1100ms=0 1150ms=0 1200ms=0 1250ms=0 1300ms=0 1350ms=0 1400ms=0 1450ms=0 1500ms=0 1550ms=0 1600ms=0 1650ms=0 1700ms=0 1750ms=0 1800ms=0 1850ms=0 1900ms=0 1950ms=0 2000ms=0 2050ms=0 2100ms=0 2150ms=0 2200ms=0 2250ms=0 2300ms=0 2350ms=0 2400ms=0 2450ms=0 2500ms=0 2550ms=0 2600ms=0 2650ms=0 2700ms=0 2750ms=0 2800ms=0 2850ms=0 2900ms=0 2950ms=0 3000ms=0 3050ms=0 3100ms=0 3150ms=0 3200ms=0 3250ms=0 3300ms=0 3350ms=0 3400ms=0 3450ms=0 3500ms=0 3550ms=0 3600ms=0 3650ms=0 3700ms=0 3750ms=0 3800ms=0 3850ms=0 3900ms=0 3950ms=0 4000ms=0 4050ms=0 4100ms=0 4150ms=0 4200ms=0 4250ms=0 4300ms=0 4350ms=0 4400ms=0 4450ms=0 4500ms=0 4550ms=0 4600ms=0 4650ms=0 4700ms=0 4750ms=0 4800ms=0 4850ms=0 4900ms=0 4950ms=0
50th gpu percentile: 3ms
90th gpu percentile: 6ms
95th gpu percentile: 11ms
99th gpu percentile: 24ms
GPU HISTOGRAM: 1ms=0 2ms=56 3ms=192 4ms=100 5ms=16 6ms=17 7ms=6 8ms=0 9ms=1 10ms=2 11ms=10 12ms=6 13ms=4 14ms=1 15ms=0 16ms=0 17ms=0 18ms=0 19ms=0 20ms=0 21ms=1 22ms=0 23ms=2 24ms=5 25ms=0 4950ms=0
Font Cache (CPU):
  Size: 17.38 kB 
  Glyph Count: 5 
CPU Caches:
GPU Caches:
  Other:
    Other: 0.00 bytes (1 entry)
  Shadow Gaussian Falloff:
    Texture: 128.00 bytes (1 entry)
  Image:
    Texture: 54.45 KB (3 entries)
  Scratch:
    Buffer Object: 48.00 KB (1 entry)
    Texture: 2.00 MB (1 entry)
Other Caches:
                         Current / Maximum
  Layers Total           0.00 KB (numLayers = 0)
Total GPU memory usage:
  2202192 bytes, 2.10 MB (54.58 KB is purgeable)


Pipeline=Skia (OpenGL)
Profile data in ms:

	org.apache.tvm.tvmrpc/org.apache.tvm.tvmrpc.MainActivity/android.view.ViewRootImpl@1038509 (visibility=8)
	Draw	Prepare	Process	Execute

View hierarchy:

  org.apache.tvm.tvmrpc/org.apache.tvm.tvmrpc.MainActivity/android.view.ViewRootImpl@1038509
  27 views, 38.25 kB of render nodes


Total ViewRootImpl   : 1
Total attached Views : 27
Total RenderNode     : 38.25 kB (used) / 38.25 kB (capacity)

My thoughts about it:

Total frames rendered - Number of frames created to render
Janky Frames - Number of dropped frames
50th percentile: 6ms - 50% of frames was rendered in or under 6ms
90th percentile: 10ms - 90% of frames was rendered in or under 10ms
95th percentile: 19ms - 95% of frames was rendered in or under 19ms
99th percentile: 61ms - 99% of frames was rendered in or under 61ms
Number Missed Vsync - vsync is complex mechnism for syncronizing frames from GPU and frames displayed
Number High input latency - Input latency or lag refers to the amount of time it takes from when it receives a signal (when you press a button on your controller or move your mouse) to when that action occurs on the screen.
Number Slow UI thread: ???
Number Slow bitmap uploads: ???
Number Slow issue draw commands: ???
Number Frame deadline missed: ???
HISTOGRAM - histogram of what? ms is time from this moment?
GPU HISTOGRAM - histogram of GPU usage? in what units?

--edit-- I was trying to look for gfxinfo and dumpsys in AOSP, but I haven't found anything interesting. There is parser of gfxinfo written in java, just parses few things. In dumpsys I cannot find reference to gfxinfo service (https://cs.android.com/android/platform/superproject/+/master:frameworks/native/cmds/dumpsys/dumpsys.cpp)

So one night I got crazy and installed tons of apps that have background processing on my galaxy tab 8.0, they were draining its battery really fast. Android itself suggested to limit some of them to improve my battery life on the notifications tab, I tapped on that notification and limited some of them. Now 2 weeks later I've found that my individual alarm app that I use doesn't ring anymore, I need to get access to that limiting feature again to see if I have limited my alarm app or not, but I don't seem to find it anywhere in the settings. Googling doesn't help either because it only finds those articles that are advertising some background process limiting app indirectly. I know uninstalling and reinstalling my alarm app or some other usual routines can fix the problem, but I need to know what exactly is causing its alarms to not go off to prevent it in the future, I can lose my job if I oversleep again. Update : I've found out that it's a Samsung feature called "App optimisation", I'm guessing tab 8.0 isn't supposed to have that feature, so they have removed its shortcut from the settings, but not the actual feature from the os, and they forgot to disable the notification alert whenever there are a lot of apps with background processing, so that's why I had access to this feature earlier. Now my question is, are there any other ways to access "app optimisation" other than through settings under the battery tab? Because it's not there for me. Update #2:It alerted me again so I took a screenshot before closing it.I haven't found any other way to get access to this feature yet.

My phone is Xiaomi Redmi Note 9, how can I restore the screen size of my phone after turning off the MIUI optimization even if I turned it back on? Before i have small screen size and small fonts 'coz it's what i prefer and now they got bigger. Please help i don't know what to do.

They aren't just reset after every restart / upgrade but even without running any update or restarting. One problem that results from this beyond having to change the settings after update is that firewall apps can get disabled. After every update the NetGuard firewall was disabled which may be caused by this or be a separate issue. Additionally, nonessential things/apps like "Facebook Services" can't be set to "Optimize". For example, "Analytics" is constantly set back to "Don't Optimize", simply overriding my decision to disable it. How to persist the battery optimization settings?

I wonder how one can turn off incoming videos in Google Hangouts. I.e., disabling all videos for anybody else in the call when in a videoconference. The motivation is to reduce the network usage. E.g. in Bluejeans:

I am trying to measure the time it takes to launch an App (cold startup) on Android. As the official documentation states, that the startup time will be displayed in the logcat:

ActivityManager: Displayed com.android.myexample/.StartupTiming: +3s534ms

The problem I currently have is that startup times vary greatly. I tested on three different days à 10 times. These are the results: - Day 1: - ~1100ms - Day 2: - ~900ms - Day 3: - ~350ms **My Question:** Does Android perform any optimization in the background for the App startup? Is there a way to reliably measure the startup time? I haven't done any changes to the App in these three days. Before the testing, the phone was at 100% battery capacity and was cold to the touch (to eliminate the possibility of thermal throttling). On day 2 and 3, I deleted the App, restarted the phone, reinstalled the App and tested again with the same results (day 2 was again ~900ms and on day 3: ~350ms). Maybe it has something to do with the ART (Android RunTime) using JIT (just-in-time) and AOT (ahead-of-time) compiler?! The app does not perform any network actions. At startup it only ready about 100 pictures from the internal storage and displays them in a Recycler View . I used a Google Pixel 2 running on Android 9. The app is written in Java.

While troubleshooting a problem with the stock Android Phone app, I was thinking to let the phone app bypass battery optimization and see if that made any difference. I notice that in the battery optimization list there are two listings for "Phone" with similar blue handset icons in the battery optimization list (as well as one with a green robot icon, and a "Phone Services" and "Phone and Messaging Storage" and "Call Management" all with similar blue handset icons). Why do I have the apparent duplicate Phone app (with similar, not identical, icons) and how do I find out what the other, phone-related apps do? I have UNrooted Android 7.0 Nougat on a Motorola Droid Turbo 2. FWIW, I also see duplicate entries (including identical icons) for "Motorola Settings", "Photos" (with Google Photos icon), and "Setup Wizard". Thanks, Rebeccah

I have a Lenovo Tab3 8 Tablet that had been working fine until about five-six months ago. Then I got this Optimizing app 1 of 1 message one day, when I had to restart the tablet, which basically made the device useless. I have been trying to fix it ever since, but every time I do the emmc factory reset from the boot menu it lasts only until the next reboot. That is, however, only when I update the device over GooglePlay before rebooting. If I reboot without updating, it doesn't show the Optimizing app message, and I can log in my profile, but then the first time I have to use GooglePlay to add a new app or autoupdate the system, the same issue reappears and I have to do the reset all over again. This seems to be due to some faulty GooglePlay update routine involving preinstalled apps. It's extremely frustrating. Anybody with the same problem on this device, or similar model/OS version? Anything is welcome! Here's all the system info I managed to get from the sys menu of the tablet: Model number: Lenovo TB3-850M Android version: 6.0 Kernel version: 3.18.19 Build number: TB3-850M_S100036_171214_ROW Software version: TB3-850M_160509

Every time I boot my Kindle fire 10 7th gen, it does this. Sometimes displaying "Optimizing Storage and applications" with progress bar for up to 10 minutes. The flippin thing runs out of battery while unattended often so this issue keeps arising. Does anyone know what its actually doing? Common usage is: View a web page or two. Watch a YouTube video. Rarely do I Install new apps or download data. There isn't much new on the drive to optimize between reboots! If there are some logs to review, Id love to know which ones and I could post snippets here.

I was recently given a roverpad tesla 10.1 tablet : (https://www.imei.info/phonedatabase/16842-roverpad-tesla-101/) It is total garbage as a tablet but I would like to use as a controller for a mini robot via an android app (via bluetooth). So in order to get a better experience I would like to remove all the unused features (multi apps ? multi screens ? logging screens). Right now even after doing a 'one click root' = KingRoot (but it is not a total root, so I can delete apps but cannot change the OS) and deleting all the non system apps from the tablet it is still quite laggy (but battery life is way better). Would you have some advice on how I can optimize it for one single usage (running an app to control a robot via bluetooth) without routing it (well if someone knows a way to root this poor soul, that would be quite awesome). Thank you in advance, Artiom

I have xiaomi mi max 32gb -Multirom 8.4.26 I make all my apps "battery optimized" except these apps: (Greenify+amplify+powernap+Launcher+Appops+Magisk+ Xposed). But after rebooting my mobile, apps returns non-optimized. So I need to make all my apps optimized after every reboot. This task is tiring and wastes my time. **My Question:** Can you help me batch optimize all apps after every reboot, please? By using tasker or terminal commands or adb commands or mod or anything Please help me

I am not challenging Android's memory management technique (like killers do). I just want to give an app higher priority even when it's not in foreground or visible (with notification). *AutoKiller Memory Optimizer* is able to do it on rooted device, but the change lasts for few seconds if I multi-task. I want to do this permanently: perhaps running a background daemon to do change continuously should work. How to do this?

**My question is the following:** Not long ago I was moving apk, data and .dex files to the directories / data, and they did not show the applications I had manually installed, if not until I rebooted on the device and a message appeared saying "optimize the system" from the moment I was curious about this. My purpose is to learn what happens in this process and to know how to be able to repeat it manually. If you know anything about this, I'll be happy to hear your comments and answers.

After each OTA Android upgrade, I get a message saying "Optimizing app x of xxx" that takes a while. The last time I upgraded, the battery ran out during the optimization process (not during the upgrade itself, which I know it's dangerous). After rebooting the phone the "optimization" process didn't carry on. So, how can I start that process by itself without upgrading anything? (my Android is already up to date).

I was reading about best system optimisation app for android, and this thought came into my mind as what's the difference if you optimise through a 3rd party app or the system app. So let's say I am using X app (3rd Part) and I clean the space other app are using. It shows me how much memory it was using and shows me available space that I get after performing that action. Now if use the android system app to the same action, it shows some that there was some space that was realised hence allowing me to optimise . If both do the same whats the difference ?? In using 3rd party app and System app. !!! Confused

I have a Kyocera Hydro View. Every time I restart my phone, it tells me that Android is optimizing apps. This takes anywhere from 5 to 15 minutes, and sometimes prevents me from using the phone when I need to use it. What is Android doing, and why does it need to do it so often?

I received from my phone carrier, Vodafone IT, the official OTA Google update to Android Ice Cream Sandwich 4.0.4 on my Nexus S. When automatically rebooting for the first time after the update, the system displayed a notice stating that it was optimizing the installed apps. What kind of optimization does Android 4.0+ do at the first reboot?

What is exactly com.android.keyguard? Is it just handling the lockscreen? If I set my device not to lock when screen is turned off, can I safely freeze/remove com.android.keyguard? I'm using a galaxy nexus with cyanogenmod 11 (kitkat), trying to lower RAM usage.

I've found that this cache folders take 1,5GiB of my 16GB Nexus 5: store_00010001/Pictures/cache/com.google.android.googlephotos/picasa--{0,1,2...} Is it cache of some app, which I can easily remove from phone level? (App settings -> clear data/cache?) Or do I have to clear it from computer periodically?

I would like to vacuum all my database files under /data, to achieve somewhat better performance so I ran the following script: for i in $(find /data -iname "*.db"); do #echo $(basename $i); sqlite3 $i 'VACUUM;'; resVac=$? if [ $resVac == 0 ]; then resVac="SUCCESS"; else resVac="ERRCODE-$resVac"; fi; sqlite3 $i 'REINDEX;'; resIndex=$? if [ $resIndex == 0 ]; then resIndex="SUCCESS"; else resIndex="ERRCODE-$resIndex"; fi; echo "Database $i: VACUUM=$resVac REINDEX=$resIndex" | tee -a /data/vacuum.log done As you can see this script vacuums and reindexes each database file under /data. REINDEX works fine, but VACUUM does not. **It returns "Error: unable to open database file". (error code 14)** I am dealing with /data. So, it can't be a mount problem.