Re: [mysar-support] Out of disk space when using mysar

[Cassiano M. <cas...@at...>]

Well, I dont have any problems with databases, and I'm using the default
keep days of mysar, which is 32. I'm running the binary version, and It
does the cleanup of older records, and optimize the tables automatically
too.

My tables are more or less the same size, and  I have
no slowdowns at all. and of course, my database is located on another
machine. :-)

> Is there a more space-efficient way to
re-balance the index trees other
> than
> what currently
seems to be a "create new "-->"destroy old"?  To
me, this
> seems like the biggest gun to use when all else
fails... - but I only
> touch
> MySQL very
occasionally.
> My squid regularly stops on a Friday at midnight -
presumably due to the
> index rebuild. I have 2.6GB of free space
in the partitioon that
> mysql/squidlogs share.  The Traffic db is
2GB & the Traffic index is
> 600MB.
> The total of all
other indexes less than 50MB.
> --
> Greg
> 
>> -----Original Message-----
>> From: José
Queiroz [mailto:ze...@gm...]
>> Sent: Tuesday, 21 August
2007 01:43
>> To: mysar support mailing list
>>
Subject: Re: [mysar-support] Out of disk space when using mysar
>>
>>
>> Check out the type of database
you're using, also; MYISAM is faster,
>> but less secure than
INNODB. MySAR can use any of them.
>>
>> About the
lack of space, after disabling binary log, keep monitoring
>>
free space, as SQUID will abend if the /var/log/squid directory run
>> out of space. Consider rotation of squid logs in a regular
basis.
>>
>> 2007/8/20, blacky zero
<bla...@ya...>:
>> >
>> >
Hello,
>> >
>> > Firstly, thanks for
publishing your mysar product, it's
>> really useful.
>> >
>> > Then, I got a big trouble with mysar.
It always fill up my
>> disk space after
>> > run
about 2-3 days (more than 10GB  free space and there
>> are 400
users).
>> > After used about 2 days, i have to delete the
database by hand, then
>> > re-create again with new fresh
database in order to access
>> to mysar page
>> >
normally. If not, i can not access due to very slow loading :(
>> >
>> > I investigated that there are many
files as
>> "mysql-bin.00000x" appear in
>> > /var/mysql/ hierrachy, they are with high capacity
(more
>> than 2GB after 2
>> > days used
mysar).
>> >
>> > How can i run mysar without
taking mysql generate files as
>> >
"mysql-bin.00000x", it just appends new data into only
>> mysar database?
>> > And how can i speed up
accessing to mysar page?
>> >
>> > Thank you
very much.
>> > Regards,
>> >
>>
> --
>> > ppham
>> >
>> > 
________________________________
>> > Building a website is
a piece of cake.
>> > Yahoo! Small Business gives you all
the tools to get online.
>> >
>>
--------------------------------------------------------------
>> -----------
>> > This SF.net email is sponsored
by: Splunk Inc.
>> > Still grepping through log files to
find problems?  Stop.
>> > Now Search log events and
configuration files using AJAX
>> and a browser.
>>
> Download your FREE copy of Splunk now >> 
http://get.splunk.com/
>> >
_______________________________________________
>> >
mysar-support mailing list
>> >
mys...@li...
>> >
https://lists.sourceforge.net/lists/listinfo/mysar-support
>>
>
>> >
>>
>>
--------------------------------------------------------------
>> -----------
>> This SF.net email is sponsored by:
Splunk Inc.
>> Still grepping through log files to find
problems?  Stop.
>> Now Search log events and configuration
files using AJAX and
>> a browser.
>> Download your
FREE copy of Splunk now >>  http://get.splunk.com/
>>
_______________________________________________
>>
mysar-support mailing list
>>
mys...@li...
>>
https://lists.sourceforge.net/lists/listinfo/mysar-support
>>
> The information transmitted is intended only for the
person or entity to
> which it is addressed and may contain
confidential and/or privileged
> material. Any review,
retransmission, dissemination or other use of, or
> taking of any
action in reliance upon, this information by persons or
> entities
other than the intended recipient is prohibited. If you received
>
this in error, please contact the sender and delete the material from
any
> computer.
> 
>
-------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still
grepping through log files to find problems?  Stop.
> Now Search
log events and configuration files using AJAX and a browser.
>
Download your FREE copy of Splunk now >>  http://get.splunk.com/
> _______________________________________________
>
mysar-support mailing list
>
mys...@li...
>
https://lists.sourceforge.net/lists/listinfo/mysar-support
>