- Board index Free Download Manager General forum
- Search
-
- It is currently Sat Sep 14, 2024 9:19 am
- All times are UTC
too much ram/memory usage in background
too much ram/memory usage in background
Postby lilaholic » Sun Oct 17, 2021 2:40 pm
I've downloaded latest FDM yesterday from the official site. The software itself is great. But it has a big issue. even in background idle mode after the startup, FDM uses ~110MB RAM with no torrenting, no active downloading. Can I have insight why? or is it normal? I used IDM before. But it was nowhere near 100MB. I'm on Windows 10 64bit with Ryzen 5 2600 and 8Gigs of RAM
Re: too much ram/memory usage in background
Postby gentlish » Sun Jan 16, 2022 12:59 am
Did you ever figure out what was causing this high RAM usage?
My FDM uses over 700MB of memory - even after a fresh restart of Windows 11.
My FDM uses over 700MB of memory - even after a fresh restart of Windows 11.
Re: too much ram/memory usage in background
Postby Alex » Sun Jan 16, 2022 5:21 pm
gentlish wrote:Did you ever figure out what was causing this high RAM usage?
My FDM uses over 700MB of memory - even after a fresh restart of Windows 11.
Hello,
How many downloads do you have in your list? What version of FDM do you use?
Alex,
FDM development team
FDM development team
Re: too much ram/memory usage in background
Postby gentlish » Mon Jan 17, 2022 5:54 pm
Hi,
I have no active downloads, but there are 348 completed that I left in the list. I am using Version: 6.15.3.4236 (4731f7d).
Screenshot:
I have no active downloads, but there are 348 completed that I left in the list. I am using Version: 6.15.3.4236 (4731f7d).
Screenshot:
Re: too much ram/memory usage in background
Postby Alex » Wed Jan 19, 2022 12:41 am
Hello,
What is the size of your FDM's database file? It's located here:
%localappdata%\softdeluxe\free download manager\db.sqlite
What is the size of your FDM's database file? It's located here:
%localappdata%\softdeluxe\free download manager\db.sqlite
Alex,
FDM development team
FDM development team
Re: too much ram/memory usage in background
Postby gentlish » Sun Jan 23, 2022 2:57 pm
My db.sqlite file is 544MB.
Re: too much ram/memory usage in background
Postby Alex » Sun Jan 23, 2022 6:29 pm
gentlish wrote:My db.sqlite file is 544MB.
Hello,
This explains it. Now we need to understand why it's so large.
Can you please do the following steps?
1. Download this archive: https://www.sqlite.org/2022/sqlite-tool ... 370200.zip
2. Extract sqlite3_analyzer.exe file into the same folder where the database is located.
3. Launch the following command:
sqlite3_analyzer.exe db.sqlite >dbstats.txt
4. Post this generated dbstats.txt file's contents here.
Alex,
FDM development team
FDM development team
Re: too much ram/memory usage in background
Postby gentlish » Sat Jan 29, 2022 7:59 pm
Hi,
Below, I have pasted the file that was generated from following your steps. NOTE: It was 9000 characters over the permitted limit, so I cut out the following 4 sections, which stated 0% of total database: (1) the definitions section; (2) "Table TAGS"; (3) "Index SQLITE_AUTOINDEX_SSLCERTIFICATES_1 of table SSLCERTIFICATES"; and (4) "Table SSLCERTIFICATES w/o any indices" and "Table SSLCERTIFICATES and all its indices"
Below, I have pasted the file that was generated from following your steps. NOTE: It was 9000 characters over the permitted limit, so I cut out the following 4 sections, which stated 0% of total database: (1) the definitions section; (2) "Table TAGS"; (3) "Index SQLITE_AUTOINDEX_SSLCERTIFICATES_1 of table SSLCERTIFICATES"; and (4) "Table SSLCERTIFICATES w/o any indices" and "Table SSLCERTIFICATES and all its indices"
- [+] Disk-Space Utilization Report For db.sqlite
- Page size in bytes................................ 4096
Pages in the whole file (measured)................ 124873
Pages in the whole file (calculated).............. 124873
Pages that store data............................. 124873 100.0%
Pages on the freelist (per header)................ 0 0.0%
Pages on the freelist (calculated)................ 0 0.0%
Pages of auto-vacuum overhead..................... 0 0.0%
Number of tables in the database.................. 24
Number of indices................................. 9
Number of defined indices......................... 0
Number of implied indices......................... 9
Size of the file in bytes......................... 511479808
Bytes of user payload stored...................... 509450436 99.60%
*** Page counts for all tables with their indices *****************************
PREVIEWS.......................................... 124446 99.66%
DOWNLOADS......................................... 391 0.31%
DOWNLOADSPREVIEWS................................. 4 0.003%
SQLITE_SCHEMA..................................... 3 0.002%
SETTINGS.......................................... 2 0.002%
UPDATES........................................... 2 0.002%
UPDATESMANAGERS................................... 2 0.002%
DOWNLOADSMODULES.................................. 2 0.002%
MISCDATA.......................................... 2 0.002%
NETWORKPASSWORDS.................................. 2 0.002%
PATHBYURLHASH..................................... 2 0.002%
SOUNDNOTIFICATIONS................................ 2 0.002%
SSLCERTIFICATES................................... 2 0.002%
DOWNLOADSAUTORETRIES.............................. 1 0.0%
DOWNLOADSLOCKS.................................... 1 0.0%
DOWNLOADSMISCFLAGS................................ 1 0.0%
DOWNLOADSSCHEDULERECORDS.......................... 1 0.0%
DOWNLOADSTAGS..................................... 1 0.0%
DOWNLOADSTAGSDETAILS.............................. 1 0.0%
DOWNLOADSWITHMISSINGFILESSTATS.................... 1 0.0%
MOVEDOWNLOADSFILESTASKS........................... 1 0.0%
MOVEFILESTASKS.................................... 1 0.0%
PATHBYFILETYPE.................................... 1 0.0%
TAGS.............................................. 1 0.0%
*** Page counts for all tables and indices separately *************************
PREVIEWS.......................................... 124446 99.66%
DOWNLOADS......................................... 391 0.31%
DOWNLOADSPREVIEWS................................. 4 0.003%
SQLITE_SCHEMA..................................... 3 0.002%
SETTINGS.......................................... 1 0.0%
UPDATES........................................... 1 0.0%
UPDATESMANAGERS................................... 1 0.0%
DOWNLOADSAUTORETRIES.............................. 1 0.0%
DOWNLOADSLOCKS.................................... 1 0.0%
DOWNLOADSMISCFLAGS................................ 1 0.0%
DOWNLOADSMODULES.................................. 1 0.0%
DOWNLOADSSCHEDULERECORDS.......................... 1 0.0%
DOWNLOADSTAGS..................................... 1 0.0%
DOWNLOADSTAGSDETAILS.............................. 1 0.0%
DOWNLOADSWITHMISSINGFILESSTATS.................... 1 0.0%
MISCDATA.......................................... 1 0.0%
MOVEDOWNLOADSFILESTASKS........................... 1 0.0%
MOVEFILESTASKS.................................... 1 0.0%
NETWORKPASSWORDS.................................. 1 0.0%
PATHBYFILETYPE.................................... 1 0.0%
PATHBYURLHASH..................................... 1 0.0%
SOUNDNOTIFICATIONS................................ 1 0.0%
SQLITE_AUTOINDEX_SETTINGS_1....................... 1 0.0%
SQLITE_AUTOINDEX_UPDATESMANAGERS_1................ 1 0.0%
SQLITE_AUTOINDEX_UPDATES_1........................ 1 0.0%
SQLITE_AUTOINDEX_DOWNLOADSMODULES_1............... 1 0.0%
SQLITE_AUTOINDEX_MISCDATA_1....................... 1 0.0%
SQLITE_AUTOINDEX_NETWORKPASSWORDS_1............... 1 0.0%
SQLITE_AUTOINDEX_PATHBYURLHASH_1.................. 1 0.0%
SQLITE_AUTOINDEX_SOUNDNOTIFICATIONS_1............. 1 0.0%
SQLITE_AUTOINDEX_SSLCERTIFICATES_1................ 1 0.0%
SSLCERTIFICATES................................... 1 0.0%
TAGS.............................................. 1 0.0%
*** All tables and indices ****************************************************
Percentage of total database...................... 100.0%
Number of entries................................. 3172
Bytes of storage consumed......................... 511479808
Bytes of payload.................................. 509456446 99.60%
Bytes of metadata................................. 1028431 0.20%
Average payload per entry......................... 160610.48
Average unused bytes per entry.................... 467.61
Average metadata per entry........................ 324.22
Average fanout.................................... 222.00
Maximum payload per entry......................... 3467918
Entries that use overflow......................... 1436 45.3%
Index pages used.................................. 6
Primary pages used................................ 1351
Overflow pages used............................... 123516
Total pages used.................................. 124873
Unused bytes on index pages....................... 13861 56.4%
Unused bytes on primary pages..................... 1423035 25.7%
Unused bytes on overflow pages.................... 46355 0.009%
Unused bytes on all pages......................... 1483251 0.29%
*** All tables ****************************************************************
Percentage of total database...................... 99.993%
Number of entries................................. 3122
Bytes of storage consumed......................... 511442944
Bytes of payload.................................. 509455196 99.61%
Bytes of metadata................................. 1028209 0.20%
Average payload per entry......................... 163182.32
Average unused bytes per entry.................... 463.76
Average metadata per entry........................ 329.34
Average fanout.................................... 220.00
Maximum payload per entry......................... 3467918
Entries that use overflow......................... 1436 46.0%
Index pages used.................................. 6
Primary pages used................................ 1342
Overflow pages used............................... 123516
Total pages used.................................. 124864
Unused bytes on index pages....................... 13861 56.4%
Unused bytes on primary pages..................... 1387643 25.2%
Unused bytes on overflow pages.................... 46355 0.009%
Unused bytes on all pages......................... 1447859 0.28%
*** All indices ***************************************************************
Percentage of total database...................... 0.007%
Number of entries................................. 50
Bytes of storage consumed......................... 36864
Bytes of payload.................................. 1250 3.4%
Bytes of metadata................................. 222 0.60%
Average payload per entry......................... 25.00
Average unused bytes per entry.................... 707.84
Average metadata per entry........................ 4.44
Maximum payload per entry......................... 48
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 9
Overflow pages used............................... 0
Total pages used.................................. 9
Unused bytes on primary pages..................... 35392 96.0%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 35392 96.0%
*** Table SETTINGS and all its indices ****************************************
Percentage of total database...................... 0.002%
Number of entries................................. 72
Bytes of storage consumed......................... 8192
Bytes of payload.................................. 2008 24.5%
Bytes of metadata................................. 268 3.3%
Average payload per entry......................... 27.89
Average unused bytes per entry.................... 82.17
Average metadata per entry........................ 3.72
Maximum payload per entry......................... 53
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 2
Overflow pages used............................... 0
Total pages used.................................. 2
Unused bytes on primary pages..................... 5916 72.2%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 5916 72.2%
*** Table SETTINGS w/o any indices ********************************************
Percentage of total database...................... 0.0%
Number of entries................................. 36
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 1065 26.0%
Bytes of metadata................................. 152 3.7%
B-tree depth...................................... 1
Average payload per entry......................... 29.58
Average unused bytes per entry.................... 79.97
Average metadata per entry........................ 4.22
Maximum payload per entry......................... 53
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 2879 70.3%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 2879 70.3%
*** Index SQLITE_AUTOINDEX_SETTINGS_1 of table SETTINGS ***********************
Percentage of total database...................... 0.0%
Number of entries................................. 36
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 943 23.0%
Bytes of metadata................................. 116 2.8%
B-tree depth...................................... 1
Average payload per entry......................... 26.19
Average unused bytes per entry.................... 84.36
Average metadata per entry........................ 3.22
Maximum payload per entry......................... 48
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 3037 74.1%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 3037 74.1%
*** Table UPDATES and all its indices *****************************************
Percentage of total database...................... 0.002%
Number of entries................................. 2
Bytes of storage consumed......................... 8192
Bytes of payload.................................. 70 0.85%
Bytes of metadata................................. 23 0.28%
Average payload per entry......................... 35.00
Average unused bytes per entry.................... 4049.50
Average metadata per entry........................ 11.50
Maximum payload per entry......................... 45
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 2
Overflow pages used............................... 0
Total pages used.................................. 2
Unused bytes on primary pages..................... 8099 98.9%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 8099 98.9%
*** Table UPDATES w/o any indices *********************************************
Percentage of total database...................... 0.0%
Number of entries................................. 1
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 45 1.1%
Bytes of metadata................................. 12 0.29%
B-tree depth...................................... 1
Average payload per entry......................... 45.00
Average unused bytes per entry.................... 4039.00
Average metadata per entry........................ 12.00
Maximum payload per entry......................... 45
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 4039 98.6%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 4039 98.6%
*** Index SQLITE_AUTOINDEX_UPDATES_1 of table UPDATES *************************
Percentage of total database...................... 0.0%
Number of entries................................. 1
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 25 0.61%
Bytes of metadata................................. 11 0.27%
B-tree depth...................................... 1
Average payload per entry......................... 25.00
Average unused bytes per entry.................... 4060.00
Average metadata per entry........................ 11.00
Maximum payload per entry......................... 25
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 4060 99.12%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 4060 99.12%
*** Table UPDATESMANAGERS and all its indices *********************************
Percentage of total database...................... 0.002%
Number of entries................................. 0
Bytes of storage consumed......................... 8192
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 16 0.20%
Average payload per entry......................... 0.0
Average unused bytes per entry.................... 0.0
Average metadata per entry........................ 0.0
Maximum payload per entry......................... 0
Entries that use overflow......................... 0
Primary pages used................................ 2
Overflow pages used............................... 0
Total pages used.................................. 2
Unused bytes on primary pages..................... 8176 99.80%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 8176 99.80%
*** Table UPDATESMANAGERS w/o any indices *************************************
Percentage of total database...................... 0.0%
Number of entries................................. 0
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 8 0.20%
B-tree depth...................................... 1
Average payload per entry......................... 0.0
Average unused bytes per entry.................... 0.0
Average metadata per entry........................ 0.0
Maximum payload per entry......................... 0
Entries that use overflow......................... 0
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 4088 99.80%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 4088 99.80%
*** Index SQLITE_AUTOINDEX_UPDATESMANAGERS_1 of table UPDATESMANAGERS *********
Percentage of total database...................... 0.0%
Number of entries................................. 0
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 8 0.20%
B-tree depth...................................... 1
Average payload per entry......................... 0.0
Average unused bytes per entry.................... 0.0
Average metadata per entry........................ 0.0
Maximum payload per entry......................... 0
Entries that use overflow......................... 0
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 4088 99.80%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 4088 99.80%
*** Table DOWNLOADS ***********************************************************
Percentage of total database...................... 0.31%
Number of entries................................. 774
Bytes of storage consumed......................... 1601536
Bytes of payload.................................. 1234761 77.1%
Bytes of metadata................................. 10856 0.68%
B-tree depth...................................... 2
Average payload per entry......................... 1595.30
Average unused bytes per entry.................... 459.84
Average metadata per entry........................ 14.03
Average fanout.................................... 386.00
Non-sequential pages.............................. 1 0.26%
Maximum payload per entry......................... 5441
Entries that use overflow......................... 4 0.52%
Index pages used.................................. 1
Primary pages used................................ 386
Overflow pages used............................... 4
Total pages used.................................. 391
Unused bytes on index pages....................... 1004 24.5%
Unused bytes on primary pages..................... 354915 22.4%
Unused bytes on overflow pages.................... 0 0.0%
Unused bytes on all pages......................... 355919 22.2%
*** Table DOWNLOADSAUTORETRIES ************************************************
Percentage of total database...................... 0.0%
Number of entries................................. 0
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 8 0.20%
B-tree depth...................................... 1
Average payload per entry......................... 0.0
Average unused bytes per entry.................... 0.0
Average metadata per entry........................ 0.0
Maximum payload per entry......................... 0
Entries that use overflow......................... 0
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 4088 99.80%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 4088 99.80%
*** Table DOWNLOADSLOCKS ******************************************************
Percentage of total database...................... 0.0%
Number of entries................................. 0
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 8 0.20%
B-tree depth...................................... 1
Average payload per entry......................... 0.0
Average unused bytes per entry.................... 0.0
Average metadata per entry........................ 0.0
Maximum payload per entry......................... 0
Entries that use overflow......................... 0
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 4088 99.80%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 4088 99.80%
*** Table DOWNLOADSMISCFLAGS **************************************************
Percentage of total database...................... 0.0%
Number of entries................................. 0
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 8 0.20%
B-tree depth...................................... 1
Average payload per entry......................... 0.0
Average unused bytes per entry.................... 0.0
Average metadata per entry........................ 0.0
Maximum payload per entry......................... 0
Entries that use overflow......................... 0
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 4088 99.80%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 4088 99.80%
*** Table DOWNLOADSMODULES and all its indices ********************************
Percentage of total database...................... 0.002%
Number of entries................................. 0
Bytes of storage consumed......................... 8192
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 16 0.20%
Average payload per entry......................... 0.0
Average unused bytes per entry.................... 0.0
Average metadata per entry........................ 0.0
Maximum payload per entry......................... 0
Entries that use overflow......................... 0
Primary pages used................................ 2
Overflow pages used............................... 0
Total pages used.................................. 2
Unused bytes on primary pages..................... 8176 99.80%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 8176 99.80%
*** Table DOWNLOADSMODULES w/o any indices ************************************
Percentage of total database...................... 0.0%
Number of entries................................. 0
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 8 0.20%
B-tree depth...................................... 1
Average payload per entry......................... 0.0
Average unused bytes per entry.................... 0.0
Average metadata per entry........................ 0.0
Maximum payload per entry......................... 0
Entries that use overflow......................... 0
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 4088 99.80%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 4088 99.80%
*** Index SQLITE_AUTOINDEX_DOWNLOADSMODULES_1 of table DOWNLOADSMODULES *******
Percentage of total database...................... 0.0%
Number of entries................................. 0
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 8 0.20%
B-tree depth...................................... 1
Average payload per entry......................... 0.0
Average unused bytes per entry.................... 0.0
Average metadata per entry........................ 0.0
Maximum payload per entry......................... 0
Entries that use overflow......................... 0
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 4088 99.80%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 4088 99.80%
*** Table DOWNLOADSPREVIEWS ***************************************************
Percentage of total database...................... 0.003%
Number of entries................................. 773
Bytes of storage consumed......................... 16384
Bytes of payload.................................. 6847 41.8%
Bytes of metadata................................. 3917 23.9%
B-tree depth...................................... 2
Average payload per entry......................... 8.86
Average unused bytes per entry.................... 7.27
Average metadata per entry........................ 5.07
Average fanout.................................... 3.00
Non-sequential pages.............................. 1 33.3%
Maximum payload per entry......................... 9
Entries that use overflow......................... 0 0.0%
Index pages used.................................. 1
Primary pages used................................ 3
Overflow pages used............................... 0
Total pages used.................................. 4
Unused bytes on index pages....................... 4068 99.32%
Unused bytes on primary pages..................... 1552 12.6%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 5620 34.3%
*** Table DOWNLOADSSCHEDULERECORDS ********************************************
Percentage of total database...................... 0.0%
Number of entries................................. 0
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 8 0.20%
B-tree depth...................................... 1
Average payload per entry......................... 0.0
Average unused bytes per entry.................... 0.0
Average metadata per entry........................ 0.0
Maximum payload per entry......................... 0
Entries that use overflow......................... 0
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 4088 99.80%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 4088 99.80%
*** Table DOWNLOADSTAGS *******************************************************
Percentage of total database...................... 0.0%
Number of entries................................. 0
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 8 0.20%
B-tree depth...................................... 1
Average payload per entry......................... 0.0
Average unused bytes per entry.................... 0.0
Average metadata per entry........................ 0.0
Maximum payload per entry......................... 0
Entries that use overflow......................... 0
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 4088 99.80%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 4088 99.80%
*** Table DOWNLOADSTAGSDETAILS ************************************************
Percentage of total database...................... 0.0%
Number of entries................................. 0
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 8 0.20%
B-tree depth...................................... 1
Average payload per entry......................... 0.0
Average unused bytes per entry.................... 0.0
Average metadata per entry........................ 0.0
Maximum payload per entry......................... 0
Entries that use overflow......................... 0
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 4088 99.80%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 4088 99.80%
*** Table DOWNLOADSWITHMISSINGFILESSTATS **************************************
Percentage of total database...................... 0.0%
Number of entries................................. 57
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 399 9.7%
Bytes of metadata................................. 293 7.2%
B-tree depth...................................... 1
Average payload per entry......................... 7.00
Average unused bytes per entry.................... 59.72
Average metadata per entry........................ 5.14
Maximum payload per entry......................... 7
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 3404 83.1%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 3404 83.1%
*** Table MISCDATA and all its indices ****************************************
Percentage of total database...................... 0.002%
Number of entries................................. 26
Bytes of storage consumed......................... 8192
Bytes of payload.................................. 902 11.0%
Bytes of metadata................................. 113 1.4%
Average payload per entry......................... 34.69
Average unused bytes per entry.................... 276.04
Average metadata per entry........................ 4.35
Maximum payload per entry......................... 141
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 2
Overflow pages used............................... 0
Total pages used.................................. 2
Unused bytes on primary pages..................... 7177 87.6%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 7177 87.6%
*** Table MISCDATA w/o any indices ********************************************
Percentage of total database...................... 0.0%
Number of entries................................. 13
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 620 15.1%
Bytes of metadata................................. 66 1.6%
B-tree depth...................................... 1
Average payload per entry......................... 47.69
Average unused bytes per entry.................... 262.31
Average metadata per entry........................ 5.08
Maximum payload per entry......................... 141
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 3410 83.3%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 3410 83.3%
*** Index SQLITE_AUTOINDEX_MISCDATA_1 of table MISCDATA ***********************
Percentage of total database...................... 0.0%
Number of entries................................. 13
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 282 6.9%
Bytes of metadata................................. 47 1.1%
B-tree depth...................................... 1
Average payload per entry......................... 21.69
Average unused bytes per entry.................... 289.77
Average metadata per entry........................ 3.62
Maximum payload per entry......................... 30
Entries that use overflow......................... 0 0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 3767 92.0%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 3767 92.0%
*** Table MOVEDOWNLOADSFILESTASKS *********************************************
Percentage of total database...................... 0.0%
Number of entries................................. 0
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 8 0.20%
B-tree depth...................................... 1
Average payload per entry......................... 0.0
Average unused bytes per entry.................... 0.0
Average metadata per entry........................ 0.0
Maximum payload per entry......................... 0
Entries that use overflow......................... 0
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 4088 99.80%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 4088 99.80%
*** Table MOVEFILESTASKS ******************************************************
Percentage of total database...................... 0.0%
Number of entries................................. 0
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 8 0.20%
B-tree depth...................................... 1
Average payload per entry......................... 0.0
Average unused bytes per entry.................... 0.0
Average metadata per entry........................ 0.0
Maximum payload per entry......................... 0
Entries that use overflow......................... 0
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 4088 99.80%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 4088 99.80%
*** Table NETWORKPASSWORDS and all its indices ********************************
Percentage of total database...................... 0.002%
Number of entries................................. 0
Bytes of storage consumed......................... 8192
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 16 0.20%
Average payload per entry......................... 0.0
Average unused bytes per entry.................... 0.0
Average metadata per entry........................ 0.0
Maximum payload per entry......................... 0
Entries that use overflow......................... 0
Primary pages used................................ 2
Overflow pages used............................... 0
Total pages used.................................. 2
Unused bytes on primary pages..................... 8176 99.80%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 8176 99.80%
*** Table NETWORKPASSWORDS w/o any indices ************************************
Percentage of total database...................... 0.0%
Number of entries................................. 0
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 8 0.20%
B-tree depth...................................... 1
Average payload per entry......................... 0.0
Average unused bytes per entry.................... 0.0
Average metadata per entry........................ 0.0
Maximum payload per entry......................... 0
Entries that use overflow......................... 0
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 4088 99.80%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 4088 99.80%
*** Index SQLITE_AUTOINDEX_NETWORKPASSWORDS_1 of table NETWORKPASSWORDS *******
Percentage of total database...................... 0.0%
Number of entries................................. 0
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 8 0.20%
B-tree depth...................................... 1
Average payload per entry......................... 0.0
Average unused bytes per entry.................... 0.0
Average metadata per entry........................ 0.0
Maximum payload per entry......................... 0
Entries that use overflow......................... 0
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 4088 99.80%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 4088 99.80%
*** Table PATHBYFILETYPE ******************************************************
Percentage of total database...................... 0.0%
Number of entries................................. 0
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 8 0.20%
B-tree depth...................................... 1
Average payload per entry......................... 0.0
Average unused bytes per entry.................... 0.0
Average metadata per entry........................ 0.0
Maximum payload per entry......................... 0
Entries that use overflow......................... 0
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 4088 99.80%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 4088 99.80%
*** Table PATHBYURLHASH and all its indices ***********************************
Percentage of total database...................... 0.002%
Number of entries................................. 0
Bytes of storage consumed......................... 8192
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 16 0.20%
Average payload per entry......................... 0.0
Average unused bytes per entry.................... 0.0
Average metadata per entry........................ 0.0
Maximum payload per entry......................... 0
Entries that use overflow......................... 0
Primary pages used................................ 2
Overflow pages used............................... 0
Total pages used.................................. 2
Unused bytes on primary pages..................... 8176 99.80%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 8176 99.80%
*** Table PATHBYURLHASH w/o any indices ***************************************
Percentage of total database...................... 0.0%
Number of entries................................. 0
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 8 0.20%
B-tree depth...................................... 1
Average payload per entry......................... 0.0
Average unused bytes per entry.................... 0.0
Average metadata per entry........................ 0.0
Maximum payload per entry......................... 0
Entries that use overflow......................... 0
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 4088 99.80%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 4088 99.80%
*** Index SQLITE_AUTOINDEX_PATHBYURLHASH_1 of table PATHBYURLHASH *************
Percentage of total database...................... 0.0%
Number of entries................................. 0
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 8 0.20%
B-tree depth...................................... 1
Average payload per entry......................... 0.0
Average unused bytes per entry.................... 0.0
Average metadata per entry........................ 0.0
Maximum payload per entry......................... 0
Entries that use overflow......................... 0
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 4088 99.80%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 4088 99.80%
*** Table PREVIEWS ************************************************************
Percentage of total database...................... 99.66%
Number of entries................................. 1436
Bytes of storage consumed......................... 509730816
Bytes of payload.................................. 508206699 99.70%
Bytes of metadata................................. 1012506 0.20%
B-tree depth...................................... 3
Average payload per entry......................... 353904.39
Average unused bytes per entry.................... 696.33
Average metadata per entry........................ 705.09
Average fanout.................................... 311.00
Non-sequential pages.............................. 0 0.0%
Maximum payload per entry......................... 3467918
Entries that use overflow......................... 1432 99.72%
Index pages used.................................. 3
Primary pages used................................ 931
Overflow pages used............................... 123512
Total pages used.................................. 124446
Unused bytes on index pages....................... 4812 39.2%
Unused bytes on primary pages..................... 948764 24.9%
Unused bytes on overflow pages.................... 46355 0.009%
Unused bytes on all pages......................... 999931 0.20%
*** Table SOUNDNOTIFICATIONS and all its indices ******************************
Percentage of total database...................... 0.002%
Number of entries................................. 0
Bytes of storage consumed......................... 8192
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 16 0.20%
Average payload per entry......................... 0.0
Average unused bytes per entry.................... 0.0
Average metadata per entry........................ 0.0
Maximum payload per entry......................... 0
Entries that use overflow......................... 0
Primary pages used................................ 2
Overflow pages used............................... 0
Total pages used.................................. 2
Unused bytes on primary pages..................... 8176 99.80%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 8176 99.80%
*** Table SOUNDNOTIFICATIONS w/o any indices **********************************
Percentage of total database...................... 0.0%
Number of entries................................. 0
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 8 0.20%
B-tree depth...................................... 1
Average payload per entry......................... 0.0
Average unused bytes per entry.................... 0.0
Average metadata per entry........................ 0.0
Maximum payload per entry......................... 0
Entries that use overflow......................... 0
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 4088 99.80%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 4088 99.80%
*** Index SQLITE_AUTOINDEX_SOUNDNOTIFICATIONS_1 of table SOUNDNOTIFICATIONS ***
Percentage of total database...................... 0.0%
Number of entries................................. 0
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 0 0.0%
Bytes of metadata................................. 8 0.20%
B-tree depth...................................... 1
Average payload per entry......................... 0.0
Average unused bytes per entry.................... 0.0
Average metadata per entry........................ 0.0
Maximum payload per entry......................... 0
Entries that use overflow......................... 0
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 4088 99.80%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 4088 99.80%
*** Table SQLITE_SCHEMA *******************************************************
Percentage of total database...................... 0.002%
Number of entries................................. 32
Bytes of storage consumed......................... 12288
Bytes of payload.................................. 4760 38.7%
Bytes of metadata................................. 279 2.3%
B-tree depth...................................... 2
Average payload per entry......................... 148.75
Average unused bytes per entry.................... 226.53
Average metadata per entry........................ 8.72
Average fanout.................................... 2.00
Non-sequential pages.............................. 1 50.0%
Maximum payload per entry......................... 753
Entries that use overflow......................... 0 0.0%
Index pages used.................................. 1
Primary pages used................................ 2
Overflow pages used............................... 0
Total pages used.................................. 3
Unused bytes on index pages....................... 3977 97.1%
Unused bytes on primary pages..................... 3272 39.9%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 7249 59.0%
*/
BEGIN;
CREATE TABLE space_used(
name clob, -- Name of a table or index in the database file
tblname clob, -- Name of associated table
is_index boolean, -- TRUE if it is an index, false for a table
is_without_rowid boolean, -- TRUE if WITHOUT ROWID table
nentry int, -- Number of entries in the BTree
leaf_entries int, -- Number of leaf entries
depth int, -- Depth of the b-tree
payload int, -- Total amount of data stored in this table or index
ovfl_payload int, -- Total amount of data stored on overflow pages
ovfl_cnt int, -- Number of entries that use overflow
mx_payload int, -- Maximum payload size
int_pages int, -- Number of interior pages used
leaf_pages int, -- Number of leaf pages used
ovfl_pages int, -- Number of overflow pages used
int_unused int, -- Number of unused bytes on interior pages
leaf_unused int, -- Number of unused bytes on primary pages
ovfl_unused int, -- Number of unused bytes on overflow pages
gap_cnt int, -- Number of gaps in the page layout
compressed_size int -- Total bytes stored on disk
);
INSERT INTO space_used VALUES('sqlite_schema','sqlite_schema',0,0,33,32,2,4760,0,0,753,1,2,0,3977,3272,0,1,12288);
INSERT INTO space_used VALUES('miscData','miscData',0,0,13,13,1,620,0,0,141,0,1,0,0,3410,0,0,4096);
INSERT INTO space_used VALUES('sqlite_autoindex_miscData_1','miscData',1,0,13,13,1,282,0,0,30,0,1,0,0,3767,0,0,4096);
INSERT INTO space_used VALUES('Settings','Settings',0,0,36,36,1,1065,0,0,53,0,1,0,0,2879,0,0,4096);
INSERT INTO space_used VALUES('sqlite_autoindex_Settings_1','Settings',1,0,36,36,1,943,0,0,48,0,1,0,0,3037,0,0,4096);
INSERT INTO space_used VALUES('previews','previews',0,0,2366,1436,3,508206699,505364749,1432,3467918,3,931,123512,4812,948764,46355,0,509730816);
INSERT INTO space_used VALUES('networkPasswords','networkPasswords',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('sqlite_autoindex_networkPasswords_1','networkPasswords',1,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('sslCertificates','sslCertificates',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('sqlite_autoindex_sslCertificates_1','sslCertificates',1,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('downloadsModules','downloadsModules',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('sqlite_autoindex_downloadsModules_1','downloadsModules',1,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('downloadsLocks','downloadsLocks',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('downloads','downloads',0,0,1159,774,2,1234761,16368,4,5441,1,386,4,1004,354915,0,1,1601536);
INSERT INTO space_used VALUES('pathByUrlHash','pathByUrlHash',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('sqlite_autoindex_pathByUrlHash_1','pathByUrlHash',1,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('pathByFileType','pathByFileType',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('tags','tags',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('downloadsTags','downloadsTags',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('downloadsTagsDetails','downloadsTagsDetails',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('downloadsScheduleRecords','downloadsScheduleRecords',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('downloadsAutoRetries','downloadsAutoRetries',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('downloadsMiscFlags','downloadsMiscFlags',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('downloadsWithMissingFilesStats','downloadsWithMissingFilesStats',0,0,57,57,1,399,0,0,7,0,1,0,0,3404,0,0,4096);
INSERT INTO space_used VALUES('downloadsPreviews','downloadsPreviews',0,0,775,773,2,6847,0,0,9,1,3,0,4068,1552,0,1,16384);
INSERT INTO space_used VALUES('moveFilesTasks','moveFilesTasks',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('moveDownloadsFilesTasks','moveDownloadsFilesTasks',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('soundNotifications','soundNotifications',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('sqlite_autoindex_soundNotifications_1','soundNotifications',1,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('UpdatesManagers','UpdatesManagers',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('sqlite_autoindex_UpdatesManagers_1','UpdatesManagers',1,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096);
INSERT INTO space_used VALUES('Updates','Updates',0,0,1,1,1,45,0,0,45,0,1,0,0,4039,0,0,4096);
INSERT INTO space_used VALUES('sqlite_autoindex_Updates_1','Updates',1,0,1,1,1,25,0,0,25,0,1,0,0,4060,0,0,4096);
COMMIT;
Re: too much ram/memory usage in background
Postby Alex » Sun Jan 30, 2022 4:42 pm
Hello,
Thank you for the report! We need a bit more information from you. What is your settings values from Scale and layout section inside of Windows' Settings | System | Display (e.g. 100% and 1980x1080)?
This is caused by your downloads' previews images stored in the database.
We'll try to fix this issue in one of the next updates. Unfortunately, for now there is no work around except removing downloads from the FDM's downloads list.
Thank you for the report! We need a bit more information from you. What is your settings values from Scale and layout section inside of Windows' Settings | System | Display (e.g. 100% and 1980x1080)?
This is caused by your downloads' previews images stored in the database.
We'll try to fix this issue in one of the next updates. Unfortunately, for now there is no work around except removing downloads from the FDM's downloads list.
Alex,
FDM development team
FDM development team
Re: too much ram/memory usage in background
Postby gentlish » Wed Feb 02, 2022 2:42 am
Hello,
My settings values from Scale and layout section inside of Windows' Settings | System | Display is 350% and 3840x2160.
Sounds good and thank you!
My settings values from Scale and layout section inside of Windows' Settings | System | Display is 350% and 3840x2160.
Sounds good and thank you!
Re: too much ram/memory usage in background
Postby Alex » Wed Feb 23, 2022 3:13 pm
Hello,
Should be fixed in the next update (6.16.1+).
Once it released, please consider to update and let us know if it fixed the issue for you.
Should be fixed in the next update (6.16.1+).
Once it released, please consider to update and let us know if it fixed the issue for you.
Alex,
FDM development team
FDM development team
Re: too much ram/memory usage in background
Postby gentlish » Fri Dec 02, 2022 1:35 am
Hello, sorry for delay. Yes the issue is fixed! Thanks so much.
Jump to
Who is online
Users browsing this forum: No registered users and 11 guests