<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/loose.dtd"> <HTML ><HEAD ><TITLE >Miscellaneous</TITLE ><META NAME="GENERATOR" CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK REL="HOME" TITLE="The Cacti Manual" HREF="index.html"><LINK REL="UP" TITLE="Debugging" HREF="debugging.html"><LINK REL="PREVIOUS" TITLE="Check rrdtool graph statement" HREF="check_rrd_graph.html"><LINK REL="NEXT" TITLE="RPM Installation?" HREF="debug_rpm_installation.html"><LINK REL="STYLESHEET" TYPE="text/css" HREF="manual.css"></HEAD ><BODY CLASS="SECT1" BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#0000FF" VLINK="#840084" ALINK="#0000FF" ><DIV CLASS="NAVHEADER" ><TABLE SUMMARY="Header navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TH COLSPAN="3" ALIGN="center" >The Cacti Manual</TH ></TR ><TR ><TD WIDTH="10%" ALIGN="left" VALIGN="bottom" ><A HREF="check_rrd_graph.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="80%" ALIGN="center" VALIGN="bottom" >Chapter 21. Debugging</TD ><TD WIDTH="10%" ALIGN="right" VALIGN="bottom" ><A HREF="debug_rpm_installation.html" ACCESSKEY="N" >Next</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><DIV CLASS="SECT1" ><H1 CLASS="SECT1" ><A NAME="DEBUG_MISCELLANEOUS" >Miscellaneous</A ></H1 ><P >Up to current cacti 0.8.6h, table <KBD CLASS="USERINPUT" >poller_output</KBD > may increase beyond reasonable size.</P ><P >This is commonly due to php.ini's memory settings of 8MB default. Change this to at least 64 MB.</P ><P >To check this, please run following sql from mysql cli (or phpmyadmin or the like)</P ><PRE CLASS="SCREEN" >select count(*) from poller_output;</PRE ><P >If the result is huge, you may get rid of those stuff by</P ><PRE CLASS="SCREEN" >truncate table poller_output;</PRE ><P >As of current SVN code for upcoming cacti 0.9, I saw measures were taken on both issues (memory size, truncating poller_output).</P ></DIV ><DIV CLASS="NAVFOOTER" ><HR ALIGN="LEFT" WIDTH="100%"><TABLE SUMMARY="Footer navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" ><A HREF="check_rrd_graph.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="index.html" ACCESSKEY="H" >Home</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" ><A HREF="debug_rpm_installation.html" ACCESSKEY="N" >Next</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >Check rrdtool graph statement</TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="debugging.html" ACCESSKEY="U" >Up</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >RPM Installation?</TD ></TR ></TABLE ></DIV ></BODY ></HTML >