Tera-WURFL 2.1.5 Administration
Loaded WURFL: 2.3.5, db.scientiamobile.com - 2013-10-09 14:25:49


<< Back to main page

Database Table Statistics
MERGE
TeraWurflMerge		 Rows: 22222
Actual Devices: 9161
Table Size: 10.68 MB
Purpose:
The MERGE table holds all the data from the WURFL file, whether it be local, remote or remote CVS, whenever a new WURFL is loaded, it is loaded into this table first, then it is filtered through all the UserAgentMatchers and split into many different tables specific to each matching technique. This MERGE table is retained for a last chance lookup if the UserAgentMatchers and INDEX table are unable to provide a conclusive match.
INDEX
TeraWurflIndex		 Rows: 22257
Table Size: 643.54 KB
Purpose:
The INDEX table acts as a lookup table for WURFL IDs and their respective UserAgentMatchers.
CACHE
TeraWurflCache		 Rows: 86
Table Size: 1.42 MB
Purpose:
The CACHE table stores unique user agents and the complete capabilities and device root that were determined when the device was first identified. Unlike version 1.x, the CACHE table stores every device that is detected permanently. When the device database is updated, the cached devices are also redetected and recached. This behavior is configurable.
User Agent Matchers
Purpose:
The User Agent Matchers store similar user agents. Tera-WURFL sorts all the devices into the most appropriate UserAgentMatcher table to make lookups faster and perform different matching hueristics on certain groups of devices.
UserAgentMatcher: terawurfl_alcatel
Rows: 232
Table Size: 212.10 KB
UserAgentMatcher: terawurfl_android
Rows: 5129
Table Size: 1.54 MB
UserAgentMatcher: terawurfl_aol
Rows: 0
Table Size: 0 B
UserAgentMatcher: terawurfl_apple
Rows: 210
Table Size: 16.45 KB
UserAgentMatcher: terawurfl_benq
Rows: 83
Table Size: 41.06 KB
UserAgentMatcher: terawurfl_blackberry
Rows: 411
Table Size: 172.28 KB
UserAgentMatcher: terawurfl_bot
Rows: 30
Table Size: 0 B
UserAgentMatcher: terawurfl_catchall
Rows: 4091
Table Size: 1.90 MB
UserAgentMatcher: terawurfl_chrome
Rows: 41
Table Size: 2.26 KB
UserAgentMatcher: terawurfl_docomo
Rows: 463
Table Size: 230.43 KB
UserAgentMatcher: terawurfl_firefox
Rows: 35
Table Size: 0 B
UserAgentMatcher: terawurfl_grundig
Rows: 6
Table Size: 3.57 KB
UserAgentMatcher: terawurfl_htc
Rows: 908
Table Size: 278.15 KB
UserAgentMatcher: terawurfl_kddi
Rows: 416
Table Size: 256.79 KB
UserAgentMatcher: terawurfl_konqueror
Rows: 4
Table Size: 0 B
UserAgentMatcher: terawurfl_kyocera
Rows: 90
Table Size: 41.02 KB
UserAgentMatcher: terawurfl_lg
Rows: 1071
Table Size: 937.19 KB
UserAgentMatcher: terawurfl_mitsubishi
Rows: 39
Table Size: 8.23 KB
UserAgentMatcher: terawurfl_motorola
Rows: 1246
Table Size: 632.98 KB
UserAgentMatcher: terawurfl_msie
Rows: 13
Table Size: 1.71 KB
UserAgentMatcher: terawurfl_nec
Rows: 90
Table Size: 45.71 KB
UserAgentMatcher: terawurfl_nintendo
Rows: 8
Table Size: 5.20 KB
UserAgentMatcher: terawurfl_nokia
Rows: 2181
Table Size: 876.86 KB
UserAgentMatcher: terawurfl_opera
Rows: 24
Table Size: 10.21 KB
UserAgentMatcher: terawurfl_operamini
Rows: 59
Table Size: 8.52 KB
UserAgentMatcher: terawurfl_panasonic
Rows: 87
Table Size: 66.23 KB
UserAgentMatcher: terawurfl_pantech
Rows: 126
Table Size: 132.24 KB
UserAgentMatcher: terawurfl_philips
Rows: 143
Table Size: 93.05 KB
UserAgentMatcher: terawurfl_portalmmm
Rows: 251
Table Size: 89.60 KB
UserAgentMatcher: terawurfl_qtek
Rows: 14
Table Size: 5.91 KB
UserAgentMatcher: terawurfl_safari
Rows: 54
Table Size: 11.88 KB
UserAgentMatcher: terawurfl_sagem
Rows: 261
Table Size: 144.66 KB
UserAgentMatcher: terawurfl_samsung
Rows: 2197
Table Size: 1.70 MB
UserAgentMatcher: terawurfl_sanyo
Rows: 91
Table Size: 74.30 KB
UserAgentMatcher: terawurfl_sharp
Rows: 108
Table Size: 63.31 KB
UserAgentMatcher: terawurfl_siemens
Rows: 378
Table Size: 146.87 KB
UserAgentMatcher: terawurfl_sonyericsson
Rows: 1079
Table Size: 679.06 KB
UserAgentMatcher: terawurfl_spv
Rows: 81
Table Size: 23.36 KB
UserAgentMatcher: terawurfl_toshiba
Rows: 6
Table Size: 7.95 KB
UserAgentMatcher: terawurfl_vodafone
Rows: 110
Table Size: 97.90 KB
UserAgentMatcher: terawurfl_windowsce
Rows: 356
Table Size: 252.32 KB



Tera-WURFL Settings
Installation Directory: C:\LaboratorySite\www\demo\terawurfl

-- Database options --
DB_HOST localhost , database server hostname or IP
DB_USER wup_connection , database username (needs SELECT,INSERT,DELETE,DROP,CREATE)
DB_PASS ********, database password
DB_SCHEMA wup , database schema (database name)
DB_CONNECTOR MySQL5 , database type (MySQL4, MySQL5, MSSQL2005, etc...);
TABLE_PREFIX TeraWurfl , prefix to be used for all table names

-- General options --
WURFL_DL_URL http://downloads.sourceforge.net/project/wurfl/WURFL/latest/wurfl-latest.zip , full URL to the current WURFL
WURFL_CVS_URL http://wurfl.cvs.sourceforge.net/%2Acheckout%2A/wurfl/xml/wurfl.xml , full URL to development (CVS) WURFL
DATADIR data/ , where all data is stored (wurfl.xml, temp files, logs)
CACHE_ENABLE true, enables or disables the cache
PATCH_ENABLE true , enables or disables the patch
PATCH_FILE custom_web_patch.xml;web_browsers_patch.xml, optional patch file for WURFL. To use more than one, separate them with semicolons
WURFL_FILE wurfl.xml , path and filename of wurfl.xml
WURFL_LOG_FILE wurfl.log , defines full path and filename for logging
LOG_LEVEL LOG_WARNING , desired logging level. Use the same constants as for PHP logging
OVERRIDE_MEMORY_LIMIT true , override PHP's default memory limit
MEMORY_LIMIT 768M , the amount of memory to allocate to PHP if OVERRIDE_MEMORY_LIMIT is enabled
SIMPLE_DESKTOP_ENGINE_ENABLE true , enable the SimpleDesktop Detection Engine to increase performance
CAPABILITY_FILTER: 

false
the capability filter that is used to determine which capabilities are available

 

Log File (last 30 lines)
Sun, 19 May 2024 01:29:12 +0000 [GIOVE 1268][rebuildCacheTable] WARNING: Rebuilt cache table, existing table was empty - this is very unusual.
Sat, 18 May 2024 23:23:33 +0000 [GIOVE 1268][Tera-WURFL] WARNING: Loading patch: web_browsers_patch.xml
Sat, 18 May 2024 23:23:33 +0000 [GIOVE 1268][Tera-WURFL] WARNING: Loading patch: custom_web_patch.xml
Sat, 18 May 2024 16:37:30 +0000 [GIOVE 1268][rebuildCacheTable] WARNING: Rebuilt cache table, existing table was empty - this is very unusual.
Thu, 16 May 2024 17:47:46 +0000 [GIOVE 1268][Tera-WURFL] WARNING: Loading patch: web_browsers_patch.xml
Thu, 16 May 2024 17:47:46 +0000 [GIOVE 1268][Tera-WURFL] WARNING: Loading patch: custom_web_patch.xml
Tue, 14 May 2024 06:54:41 +0000 [GIOVE 30160][Tera-WURFL] WARNING: Loading patch: web_browsers_patch.xml
Tue, 14 May 2024 06:54:41 +0000 [GIOVE 30160][Tera-WURFL] WARNING: Loading patch: custom_web_patch.xml
Mon, 13 May 2024 04:37:26 +0000 [GIOVE 30160][rebuildCacheTable] WARNING: Rebuilt cache table, existing table was empty - this is very unusual.
Sun, 12 May 2024 20:01:26 +0000 [GIOVE 30160][Tera-WURFL] WARNING: Loading patch: web_browsers_patch.xml
Sun, 12 May 2024 20:01:26 +0000 [GIOVE 30160][Tera-WURFL] WARNING: Loading patch: custom_web_patch.xml
Sun, 12 May 2024 19:17:39 +0000 [GIOVE 30160][Tera-WURFL] WARNING: Loading patch: web_browsers_patch.xml
Sun, 12 May 2024 19:17:39 +0000 [GIOVE 30160][Tera-WURFL] WARNING: Loading patch: custom_web_patch.xml
Mon, 29 Apr 2024 12:54:20 +0000 [GIOVE 30160][rebuildCacheTable] WARNING: Rebuilt cache table, existing table was empty - this is very unusual.
Mon, 29 Apr 2024 12:54:20 +0000 [GIOVE 30160][rebuildCacheTable] WARNING: Rebuilt cache table, existing table was empty - this is very unusual.
Tue, 23 Apr 2024 23:41:49 +0000 [GIOVE 30160][rebuildCacheTable] WARNING: Rebuilt cache table, existing table was empty - this is very unusual.
Tue, 23 Apr 2024 16:30:44 +0000 [GIOVE 30160][rebuildCacheTable] WARNING: Rebuilt cache table, existing table was empty - this is very unusual.
Sat, 20 Apr 2024 04:35:15 +0000 [GIOVE 76968][rebuildCacheTable] WARNING: Rebuilt cache table, existing table was empty - this is very unusual.
Tue, 16 Apr 2024 17:18:49 +0000 [GIOVE 76968][Tera-WURFL] WARNING: Loading patch: web_browsers_patch.xml
Tue, 16 Apr 2024 17:18:49 +0000 [GIOVE 76968][Tera-WURFL] WARNING: Loading patch: custom_web_patch.xml
Thu, 11 Apr 2024 16:42:05 +0000 [GIOVE 76968][rebuildCacheTable] WARNING: Rebuilt cache table, existing table was empty - this is very unusual.
Thu, 11 Apr 2024 16:39:23 +0000 [GIOVE 76968][Tera-WURFL] WARNING: Loading patch: web_browsers_patch.xml
Thu, 11 Apr 2024 16:39:23 +0000 [GIOVE 76968][Tera-WURFL] WARNING: Loading patch: custom_web_patch.xml
Wed, 10 Apr 2024 23:26:25 +0000 [GIOVE 76968][Tera-WURFL] WARNING: Loading patch: web_browsers_patch.xml
Wed, 10 Apr 2024 23:26:25 +0000 [GIOVE 76968][Tera-WURFL] WARNING: Loading patch: custom_web_patch.xml
Mon, 01 Apr 2024 01:19:50 +0000 [GIOVE 76968][rebuildCacheTable] WARNING: Rebuilt cache table, existing table was empty - this is very unusual.
Sat, 23 Mar 2024 18:08:17 +0000 [GIOVE 76968][Tera-WURFL] WARNING: Loading patch: web_browsers_patch.xml
Sat, 23 Mar 2024 18:08:17 +0000 [GIOVE 76968][Tera-WURFL] WARNING: Loading patch: custom_web_patch.xml
Sat, 23 Mar 2024 14:19:44 +0000 [GIOVE 76968][Tera-WURFL] WARNING: Loading patch: web_browsers_patch.xml
Sat, 23 Mar 2024 14:19:44 +0000 [GIOVE 76968][Tera-WURFL] WARNING: Loading patch: custom_web_patch.xml
Sat, 23 Mar 2024 14:19:42 +0000 [GIOVE 76968][rebuildCacheTable] WARNING: Rebuilt cache table, existing table was empty - this is very unusual.