| DB storage problems [message #30220] |
Sat, 11 February 2006 23:50  |
willy
Messages: 24
Registered: March 2005
Karma:
|
Junior Member |
|
|
Hello,
I testing 2.7.4 DB storage, but this have some problem with this.
I never understand why better filesystem storage for fudforum, and this new db storage method make me happy:)
File storage weeknes:
If only one character loss from message file, all offsets will be wrong.
SQL server is needed... file storage is not dependency reduce way.
PHP fopen model not a secure way.
Fulltext indexing is faster, more space saver,maintaince cost smaller than separate index table. (i understand this is can't used parallel with current file storage method)
DB storage good way.
But, 2.7.4 relese has some bugs:
Private message db handling is very strange, pmsg length field used to link pmsg body(in the msg_store table) to pmsg table. This is works, some minor problems appeared:
pmsg_view and pmsg check DB storage at read_pmsg_body if DB storage activated, check offset != 1 but if pmsg stored in DB offset is always -1 (check write_pmsg_body)
This problem correcting is simple in the code. (make offset check
to == -1)
But have another problem:
pmsg folder size checker summarize pmsg $length (it is contains ralations to msg_store table) this cause 34141% space usage.
Patch not simple, need to rewrite relations pmsg and msg_store table.
Another problem, if i try rebuild search index(needed), rebuild failed with following reason:
/html/adm/indexdb.php:75
) 1100: Table 'fud_msg_store' was not locked with LOCK TABLES
Query: SELECT data FROM fud_msg_store WHERE id=281792
Have any idea how to solve this problem?
Thanks,
Willy
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]