Xibo site very slow

How big are your log and stat tables in the database.

If you've got debug or audit or stats switched on then those tables will
probably be groaning.

You can safely truncate them both.

Alex

madal <email address hidden> wrote:

New question #107923 on Xibo:
https://answers.launchpad.net/xibo/+question/107923

Hello all,

I don´t know if this a problem with xibo server or with apache server. My
server hardware is quite good and worked fine month ago with good
response. Now all of sudden when i open my xibo interface it takes about
5-6 seconds to open the login page. There has not been any changes in
security and network.

Can anybody put some inputs in this ? or perhaps i will need to tune
apache - please fill me in.

M

--
You received this question notification because you are a member of Xibo
Developers, which is an answer contact for Xibo.

This email carries a disclaimer, a copy of which may be read at http://learning.longhill.org.uk/disclaimer

Hello Alex,

In fact you those debug and audit are enabled. How can i get rid of those pilled up logs and stats from the database. if that is making slower access of xibo server.

Thanks,

Madal

Firstly disable debug and audit. They shouldn't be enabled for normal use.

Then in the database issue the following commands:
truncate log;
truncate stat;

Alex

madal <email address hidden> wrote:

Question #107923 on Xibo changed:
https://answers.launchpad.net/xibo/+question/107923

    Status: Answered => Open

madal is still having a problem:
Hello Alex,

In fact you those debug and audit are enabled. How can i get rid of
those pilled up logs and stats from the database. if that is making
slower access of xibo server.

Thanks,

Madal

--
You received this question notification because you are a member of Xibo
Developers, which is an answer contact for Xibo.

This email carries a disclaimer, a copy of which may be read at http://learning.longhill.org.uk/disclaimer

alex,

I run those commands you mentioned. But performance doesn´t improve.

I have now disabled debug and audit.

Madal

OK. Well xibo isn't resource hungry. I think you need to look elsewhere.

Alex

This email carries a disclaimer, a copy of which may be read at http://learning.longhill.org.uk/disclaimer

Hello Alex,

Thanks for your input. I noticed one thing though, when i issue the truncate log and truncate stat, it clears up all the data inside the table but it also fills up very quickly. And my settings with Error - debug (OFF), Audit (OFF) and server_more (production). could it be those setting not in effect ?

M

Which table fills up quickly?

madal <email address hidden> wrote:

Question #107923 on Xibo changed:
https://answers.launchpad.net/xibo/+question/107923

    Status: Answered => Open

madal is still having a problem:
Hello Alex,

Thanks for your input. I noticed one thing though, when i issue the
truncate log and truncate stat, it clears up all the data inside the
table but it also fills up very quickly. And my settings with Error -
debug (OFF), Audit (OFF) and server_more (production). could it be those
setting not in effect ?

M

--
You received this question notification because you are a member of Xibo
Developers, which is an answer contact for Xibo.

This email carries a disclaimer, a copy of which may be read at http://learning.longhill.org.uk/disclaimer

log and stat table

M

If you're not using stats then in the client options turn stats off on
each client.

If its still sending stats then some older versions have a bug where stats
aren't disabled correctly. Upgrade to 1.0.6 server and 1.0.7 client.

A few logs is to be expected. Make sure you don't have auditing enabled on
any of your displays in the management menu.

Alex

madal <email address hidden> wrote:

Question #107923 on Xibo changed:
https://answers.launchpad.net/xibo/+question/107923

    Status: Answered => Open

madal is still having a problem:
log and stat table

M

--
You received this question notification because you are a member of Xibo
Developers, which is an answer contact for Xibo.

This email carries a disclaimer, a copy of which may be read at http://learning.longhill.org.uk/disclaimer

Hello Alex,

I recently installed Xibo server into new machine due to old is retiring. Here are few question that came during my moving process. I installed the new xibo server and copied all the data from old server. After I dump the data base into new one the site became very slow again !! And, I truncate the log and stat table and that worked - site became faster. It looks like log tables is filling up whenever error occurs like this one;

<scriptname>/xibo/lib/app/responsemanager.class.php</scriptname>
<scriptlinenum>206</scriptlinenum>
  /index.php?ajax=true 130.208.137.219 2 Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.9.2.8) Gecko/20100722 Firefox/3.6.8 (.NET CLR 3.5.30729) 0 0 0 0
 4 9/5/2010 11:37:05 AM error schedule <errormsg>Undefined offset: 0</errormsg>
<errornum>8</errornum>
<errortype>Notice</errortype>
<scriptname>/xibo/lib/app/kit.class.php</scriptname>
<scriptlinenum>195</scriptlinenum>

I have not yet re-register all the display yet. What is the good practice to move database from one machine to another as well as xibo server. Re-doing all is certainly not a good idea !!

PS: one think i also noticed is that none of the tables has INDEX, is that the reason why the site became slow - i am not sure.

Thanks
MADAL

You need to dump the database with something like mysqldump that understands constraints. You can then setup that database on a new server, grant permissions etc and then import your data from file with the "source" command.

Errors going in to the log are normal. 1.2.0 series servers have a maintenance script to purge old errors periodically.

Alex

Thanks for your response. I use the mysqldump xibo >dump.txt from old machine then use the mysql -u username -p xibo<dump.txt. That bought back all the data into the databases. I am still concern about site slowing reason. I will let you know if this still exists when i re-register the screens!

M

> then use the mysql -u username -p xibo<dump.txt. That bought
> back all the data into the databases.

I've not tested it in a long time but doing that didn't used to work
because it would try and enter data before all the tables and
constraints were setup. If you don't have the constraints in the
database, you will find Xibo breaks.

The way we suggest is to do

mysql -u username -p xibo
source dump.txt

Alex

This email carries a disclaimer, a copy of which may be read at http://learning.longhill.org.uk/disclaimer

> I am still concern about site
> slowing reason. I will let you know if this still exists when i re-
> register the screens!

If you have tens of thousands of records in the log table it's not
suprising that it slows. Once we release 1.2.0 and you upgrade and setup
the maintenance script, it will by default delete anything older than 24
hours - so this becomes a non-issue.

Alex

This email carries a disclaimer, a copy of which may be read at http://learning.longhill.org.uk/disclaimer