X-Git-Url: https://git.sur5r.net/?a=blobdiff_plain;f=docs%2Fmanuals%2Fen%2Fcatalog%2Fcatmaintenance.tex;h=ee0be08cdd96fbe99f499a1dc98d94c8f392ad2c;hb=6ff73189a102731a6937d8955cab1b6b579bf3a5;hp=3766c7aebfac380d66360dceaf535f861147d524;hpb=24e05aa8d80f9adc703a73d8cd9fd9f38032f02a;p=bacula%2Fdocs

diff --git a/docs/manuals/en/catalog/catmaintenance.tex b/docs/manuals/en/catalog/catmaintenance.tex
index 3766c7ae..ee0be08c 100644
--- a/docs/manuals/en/catalog/catmaintenance.tex
+++ b/docs/manuals/en/catalog/catmaintenance.tex
@@ -271,6 +271,32 @@ the MySQL documentation, which can be found at:
 \elink{http://dev.mysql.com/doc/refman/5.0/en/gone-away.html}
 {http://dev.mysql.com/doc/refman/5.0/en/gone-away.html}
 
+\section{MySQL Temporary Tables}
+When doing backups with large numbers of files, MySQL creates some
+temporary tables.  When these tables are small they can be held in
+system memory, but as they approach some size, they
+spool off to disk.  The default location for these temp tables is
+/tmp.  Once that space fills up, Bacula daemons such as the Storage
+daemon doing spooling can get strange errors. E.g.
+
+\footnotesize                                 
+\begin{verbatim}
+Fatal error: spool.c:402 Spool data read error.
+Fatal error: backup.c:892 Network send error to SD. ERR=Connection reset by
+peer
+\end{verbatim}
+\normalsize
+
+What you need to do is setup MySQL to use a different (larger) temp
+directory, which can be set in the /etc/my.cnf with these variables
+set:
+
+\footnotesize                                 
+\begin{verbatim}
+  tmpdir=/path/to/larger/tmpdir
+  bdb_tmpdir=/path/to/larger/tmpdir
+\end{verbatim}
+\normalsize
 
 \label{RepairingPSQL}
 \section{Repairing Your PostgreSQL Database}