List:Internals« Previous MessageNext Message »
From:sasha Date:November 15 2000 6:35pm
Subject:Re: FW: mysql 3.22.32 + Redhat 6.2 - Strange behavior
View as plain text  
Serge Sozonoff wrote:
> 
> Hello all,
> 
> System
> ------
> RedHat 6.2 / Intel
> 256Mb RAM
> 
> Apache
> PHP
> Mysql 3.22.32
> 
> I have been experiencing some very strange behavior from mysql that make me
> a little uneasy at the moment.
> I just brought up a db driven website using Apache+PHP+mysql and mysql has
> started acting a bit strange.
> 
> Over time, I seem to be losing data as far as querying the mysql database is
> 
> concerned. All of a sudden queries to the database return no data!
> When I looked at my latest backup done with mysqldump, it was over 50%
> smaller
> in file size.  Yikes!! When I did some db queries that normally return
> results, no results
> were returned!
> 
> I shutdown apache and mysql and then restarted the daemons.
> 
> All my data came back! I quickly did a backup again and file size of the
> backed-up db was
> back to what I had expected.
> 
> Has anyone else experienced this?
> 
> Is there some sort of memory leak in the mysql daemon that could be causing
> this?
> 
> The symptoms apeared after about a 1-2weeks of uptime.
> 
> I also run a backup script every night that looks like this:
> 
> --- cut ---
> echo "Backing up FreezeFotoz database..."
> /usr/local/bin/mysqldump -l --opt -uxxxxx -pxxxxx skiphotos \
>         |gzip > /disk2/db-backups/freezedb-backup_`date "+%Y%m%d"`.gz
> 
> echo "Checking all the databases ..."
> /usr/local/bin/isamchk -s /usr/local/var/*/*.ISM
> 
> echo "Removing old FreezeFotoz backups..."
> find /disk2/db-backups -mtime +14 -exec rm -f {} \;
> 
> echo "Backing up all FreezeFotoz images ......"
> tar -cz /skiphotos/images > /disk2/image-backups/images-backup_`date
> "+%Y%m%d"`.tar.gz
> 
> echo "Removing old FreezeFotoz image backups..."
> find /disk2/image-backups -mtime +14 -exec rm -f {} \;
> 
> echo "Done!"
> 

3.22.32 has a number of rare bugs (mostly in the locking code) that have been
discovered and fixed in the 3.23 branch. However, what you are describing sounds
like bad hardware, RAM in particular. We have never heard of this problem before
with any version of MySQL.

-- 
MySQL Development Team
   __  ___     ___ ____  __ 
  /  |/  /_ __/ __/ __ \/ /   Sasha Pachev <sasha@stripped>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, http://www.mysql.com/
/_/  /_/\_, /___/\___\_\___/  Provo, Utah, USA
       <___/
Thread
FW: mysql 3.22.32 + Redhat 6.2 - Strange behaviorSerge Sozonoff15 Nov
  • Re: FW: mysql 3.22.32 + Redhat 6.2 - Strange behaviorsasha15 Nov