Xibo

Database Log Files is to large (300 mb) and stat (250mb)

Asked by marlon

Hi,

today i have problem when i want to upload some video file (18 mb). usually i upload more that that (128 mb) can. i'm wait for upload process until some login process come up. i don't know also to make the time more longer for this session user login, coz i already tried ask the Hosting server provider to make it long, but they can't coz this their policy company not to make long time user login. And also i saw when i download sql database with table log (300 mb) and stat (250 mb) is it normal ?...

any want know this problem ?..

Thank in advance. :)

Question information

Language:
English Edit question
Status:
Solved
For:
Xibo Edit question
Assignee:
No assignee Edit question
Solved by:
marlon
Solved:
Last query:
Last reply:
Revision history for this message
Alex Harrington (alexharrington) said : 		#1

You need to setup the maintenance script to run periodically and clean out
your log and stats table. It's all documented in the wiki.

Revision history for this message
marlon (marlz-alcatraz) said : 		#2

Thanks Alex,

for my first question , how make upload process take too long ?.. usually i upload more than 17 Mb, is very fast (coz i use fast Connection internet from ISP), but now i want to upload 17mb, the process took 15 minutes more, until the session time out and ask login password.

Revision history for this message
Dan Garner (dangarner) said : 		#3

Can you run through the report fault wizard so we can see if there are any errors being thrown when you try to upload a file. If the log in box appears it usually means the file upload has failed.

Revision history for this message
marlon (marlz-alcatraz) said : 		#4

is it from Advanced menu, then report fault , then what shoud i choose ?

thanks.

Revision history for this message
Dan Garner (dangarner) said : 		#5

Hi Marlon,

I've looked through the log file you sent me and cannot see anything related to an error with file uploading - just a bunch of client log files (you might want to turn off logging on your clients so reduce this traffic).

The only thing I can really suggest is to try 1.5.1 and see if that improves things - there is a new file uploader.

Revision history for this message
marlon (marlz-alcatraz) said : 		#6

thank's a lot Dan :)