Am 21.06.2016 um 09:41 schrieb Götz Reinicke - IT Koordinator:
we recently had a software bug who wrote gigs of data to our database in
a loop and finally filled the whole system.
O.K. we could serverside use a separate partition/storage for the
database directory, but I was wondering is mysql
Hi,
we recently had a software bug who wrote gigs of data to our database in
a loop and finally filled the whole system.
O.K. we could serverside use a separate partition/storage for the
database directory, but I was wondering is mysql has a feature/option to
set some sort of "minimum disk free"
Hi All
I use mysqldump to take the backup of the entire DB. I want to know if
there is way to find out how much disk space would mysqldump require to
take the backup of the entire DB in .sql file.
Currently what we are doing is to check the size of the
/var/lib/mysql/data directory and
>>>> 2013/12/18 11:07 -0500, Anthony Ball >>>>
I ran across a curious issue, I'd call it a bug but I'm sure others would
call it a feature.
I have a csv file with space between the " and , and it causes MySQL to eat
that field and the field after it as a sin
(1)
yes it is an issue even i faced. for the remedy i search the {(" ,) (",)}
values of " , space between " and , & replaced by ", in .csv itself.
(2)
The other way is, if all the values are like space between " , then you can
use space and , in fields term
I ran across a curious issue, I'd call it a bug but I'm sure others would
call it a feature.
I have a csv file with space between the " and , and it causes MySQL to eat
that field and the field after it as a single field. Is there a setting I
can use to remedy this or do I just ha
the SHOW CREATE TABLE? Some of this smells bad.
>> * It is almost always bad to split day/month/year into multiple fields.
>> * Often a "fact" table, which this sounds like, should not have extra
>> indexes.
>> * Is each datatype as small as is practical?
&g
On 2013-06-27 01:27, nixofortune wrote:
Now importing with Keys in place. It takes longer, much longer but at
least the server is working and customers do not complaint.
Schema design is awful, agree. I try to understand the process so will
redesign it soon, but any suggestions are welcome.
I'
year into multiple fields.
* Often a "fact" table, which this sounds like, should not have extra indexes.
* Is each datatype as small as is practical?
* Are any of the fields VARCHAR, and could be 'normalized'?
I would expect this to the fastest way to convert (assuming you have the
fields VARCHAR, and could be 'normalized'?
I would expect this to the fastest way to convert (assuming you have the disk
space):
CREATE TABLE new LIKE old;
ALTER TABLE new DROP (all indexes), ADD PRIMARY KEY (either autoincrement
or a 'natural' compound PK), ENGI
2013/06/26 17:31 +0100, nixofortune
ALTER TABLE `new_innodb`
ADD KEY `idx1` (`col1`,`col2`),
ADD KEY `idx2` (`col1`,`col2`,`col3`);
Is it really seemly for one index to be a leading part of another?
(or maybe I am really thinking of something else)
--
MySQL General Mailing Li
You can't actually move innodb tables around until 5.6 where you have
transpotable tablespaces.
I suggest having a good hard look at pt-online-schema-change or whatsitcalled.
Jay Ess wrote:
>On 2013-06-26 18:31, nixofortune wrote:
>> What would be the best way to convert BIG MyISAM table into I
On 25/06/13 23:55, Rick James wrote:
Switch to InnoDB so you won't have to repair after crashes.
Caution: InnoDB takes 2x-3x the disk space per table. Be sure to use
innodb_file_per_table=1.
" Repair by sort." is usually much faster than "repair by keycache"; you pro
On 2013-06-26 18:31, nixofortune wrote:
> What would be the best way to convert BIG MyISAM table into InnoDB? We do not
> have SLAVE.
I would do it on another computer. Then copy the table to the server and then
add the data that has been added from the original table.
And/or i would experiment w
Switch to InnoDB so you won't have to repair after crashes.
Caution: InnoDB takes 2x-3x the disk space per table. Be sure to use
innodb_file_per_table=1.
" Repair by sort." is usually much faster than "repair by keycache"; you
probably got 'sort
On 24/06/13 19:57, Reindl Harald wrote:
Am 24.06.2013 18:47, schrieb Johan De Meersman:
- Original Message -
From: "nixofortune"
Hi guys,
any suggestions? I just repaired 90G MyISAM table with REPAIR TABLE
command. the space on the hard drive gone down from 165 Gig to
Oops, totally missed that, thanks.
Reindl Harald wrote:
>
>
>Am 24.06.2013 18:47, schrieb Johan De Meersman:
>> - Original Message -
>>> From: "nixofortune"
>>>
>>> Hi guys,
>>> any suggestions? I just repaired 90G MyISAM tab
Am 24.06.2013 18:47, schrieb Johan De Meersman:
> - Original Message -
>> From: "nixofortune"
>>
>> Hi guys,
>> any suggestions? I just repaired 90G MyISAM table with REPAIR TABLE
>> command. the space on the hard drive gone down from 165
- Original Message -
> From: "nixofortune"
>
> Hi guys,
> any suggestions? I just repaired 90G MyISAM table with REPAIR TABLE
> command. the space on the hard drive gone down from 165 Gig to 70
> Gig. I understand that during repair process MySQL creates tem
Hi guys,
any suggestions? I just repaired 90G MyISAM table with REPAIR TABLE
command. the space on the hard drive gone down from 165 Gig to 70 Gig. I
understand that during repair process MySQL creates temp file and remove
it after the job done. Or removal process executes on the server
Sorry, I can't address your specific question, but I have several other tips,
some of which may save a lot of space...
USING HASH -- ignored; presumably BTree is used instead.
What Version of MySQL? 5.5(?) can drop an InnoDB (only?) index live.
BTrees sometimes grow after any sort of
Am 09.04.2013 08:36, schrieb a bv:
> What is the best way and steps to add new disk or SAN to a LVM setuped
> mysql/linux box?.
>
> If there are slots is it better to add a physical one or a SAN space? How
> would add that at linux /lvm. What to do at the current mysql database?
Hi,
What is the best way and steps to add new disk or SAN to a LVM setuped
mysql/linux box?.
If there are slots is it better to add a physical one or a SAN space? How
would add that at linux /lvm. What to do at the current mysql database?
Kernel is 2.6.x.x , any storage size restriction for
tuses:
| Open_files | 5421 |
| Open_table_definitions | 2669 |
| Open_tables | 3913 |
| Opened_table_definitions | 493857 |
| Opened_tables | 638469 |
In the space of five minutes, opened_table_definitions grows about 24 and
opened_tables about 30; while there is still room in both caches. I'v
;>>> 2011/11/22 12:44 -0800, Sean Sidelko >>>>
We just moved a large amount of data off one of our db servers to another one
(75gb of data). One thing I've noticed is that over the last couple days the
free innodb space has been decreasing by over 2.5 gb a day while w
We just moved a large amount of data off one of our db servers to another one
(75gb of data). One thing I've noticed is that over the last couple days the
free innodb space has been decreasing by over 2.5 gb a day while we've only
been adding 400 mb of data a day to the db server.
To: Rozeboom, Kay [DAS]
Cc: mysql@lists.mysql.com
Subject: Re: Reusing "ibdata1" space
- Original Message -
> From: "Kay Rozeboom [DAS]"
>
> I realize that this would not return the unused space to the operating
> system. But would it return it to M
- Original Message -
> From: "Prabhat Kumar"
> I wonder, if there could be any method to regain InnoDB space other
> than dump the whole database and reimport.
Very simple answer to that: no.
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt,
I wonder, if there could be any method to regain InnoDB space other than
dump the whole database and reimport.
Thanks,
On Thu, Nov 10, 2011 at 12:44 AM, Johan De Meersman wrote:
> - Original Message -
> > From: "Nick Khamis"
> >
> > I should mention that
- Original Message -
> From: "Nick Khamis"
>
> I should mention that we have deleted the ib_* files in the past.
I hope that was an accident, because if you thought that was a good idea I'm
sending someone over with the spiked cluebat.
Luckily for you, the solution to that particular p
Hello Reindl, I just noticed that I misspelled your name. Sorry about that!
Cheers,
Nick.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
y growing. I understand that to return
>> the unused space to the operating system, we must delete and recreate
>> "ibdata1" and its associated ".frm" files. I am wondering if we could do
>> the following instead:
>>
>> 1) Let "ibdata1
Thanks to everyone who replied to my question.
Kay Rozeboom
Information Technology Enterprise
Iowa Department of Administrative Services
Telephone: 515.281.6139 Fax: 515.281.6137
Email: kay.rozeb...@iowa.gov
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To u
- Original Message -
> From: "Kay Rozeboom [DAS]"
>
> I realize that this would not return the unused space to the
> operating system. But would it return it to MySQL so that it could
> be re-used for subsequent inserts, instead of extending "ibdata1&quo
Kay,
There's no way to regain InnoDB space.
I can suggest some techniques but no magic.
1. dump the whole database and reimport
2. setup a brand new slave ,sync and switch to it
Cheers
Claudio
2011/11/1 Rozeboom, Kay [DAS]
> We are running MySQL 5.0.77, and using I
eturn
> the unused space to the operating system, we must delete and recreate
> "ibdata1" and its associated ".frm" files. I am wondering if we could do the
> following instead:
>
> 1) Let "ibdata1" grow for a while.
> 2) Rebuild the tables
We are running MySQL 5.0.77, and using INNODB in production for the first time.
The production database has a lot of inserts and deletes, and the shared
"ibdata1" file is continually growing. I understand that to return the unused
space to the operating system, we must delete an
- Original Message -
> From: "a bv"
>
> I have a phpsyslog-ng box with different tables and disk usage is
I assume that means you have a syslog service that logs to a MySQL database?
> growing so fast nearly no space left. How must i move the old
> files? I
Hi,
I have a phpsyslog-ng box with different tables and disk usage is
growing so fast nearly no space left. How must i move the old files
? Is it ok to move just like an ordinary file or do something on
mysql?
Regards
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
n, 1/17/11, Eric Bergen wrote:
From: Eric Bergen
Subject: Re: Innodb table space questions
To: "Angela liu"
Cc: mysql@lists.mysql.com
Date: Monday, January 17, 2011, 10:09 PM
reply inline
On Mon, Jan 17, 2011 at 9:30 PM, Angela liu wrote:
> Folks :
>
> two questions:
>
>
reply inline
On Mon, Jan 17, 2011 at 9:30 PM, Angela liu wrote:
> Folks :
>
> two questions:
>
> 1. can Innodb create per database table space , not per table table space?
No. The only available options are creating a global tablespace which
can be many files or a file per tabl
Folks :
two questions:
1. can Innodb create per database table space , not per table table space?
2. can we store table on specific tablespace like Oracle or DB2 when creating
table?
Many thanks.
> I'm new to MySQL, and I hope somebody can help me.
> I have a 3.7G database and a 10G tmpdir.
> Sometimes the tmpdir runs out of space, and I get the following message on
> the logs:
> [ERROR] /usr/libexec/mysqld: Incorrect key file for table
> '/tmp/tmpdir/#sql_2
Hello, everybody!
I'm new to MySQL, and I hope somebody can help me.
I have a 3.7G database and a 10G tmpdir.
Sometimes the tmpdir runs out of space, and I get the following message on
the logs:
[ERROR] /usr/libexec/mysqld: Incorrect key file for table
'/tmp/tmpdir/#sql_22f_33.MYI'
On 9/2/2010 1:39 PM, neutron wrote:
Hello Johan,
Thanks for the reply.
On Thu, Sep 2, 2010 at 3:34 AM, Johan De Meersman wrote:
I suspect he is talking about the Temp Tablespace concept from Oracle, which
is different from a temporary table or a memory table.
MySQL will allocate a memory tab
h RAM and
>> DISK
>> based)
>>
>> http://dev.mysql.com/doc/refman/5.1/en/create-table.html
>>
>> Look at:
>>
>> TABLESPACE
>> PARTITIONS
>> ENGINE
>>
>> > -Original Message-
>> > From: neutron [mail
able.html
>
> Look at:
>
> TABLESPACE
> PARTITIONS
> ENGINE
>
> > -Original Message-
> > From: neutron [mailto:neutronsh...@gmail.com]
> > Sent: Wednesday, September 01, 2010 6:05 PM
> > To: mysql@lists.mysql.com
> > Subject: Does innodb have
tronsh...@gmail.com]
> Sent: Wednesday, September 01, 2010 6:05 PM
> To: mysql@lists.mysql.com
> Subject: Does innodb have a temp table space?
>
> Hi all,
>
> As far as I know, some DB has a separate table space to store temp
> data (such as for external sort).
>
> M
Hi all,
As far as I know, some DB has a separate table space to store temp
data (such as for external sort).
My questions are:
1. Does innodb also has a separate temp-tablespace?
2. If I don't use "innodb_file_per_table", where is innodb's
temporary tablespace？ Is it in t
I am no sure you are taking about cluster table space or innodb table space.
Just check :
http://dev.mysql.com/doc/refman/5.1/en/create-tablespace.html
http://dev.mysql.com/doc/refman/5.0/en/innodb-configuration.html
On Wed, Jul 14, 2010 at 2:52 PM, alba.albetti wrote:
> Is it possible
Is it possible in MySQL to define the initial space that the table is going to
use and the space for its growth? I usually work on Oracle where the syntax is:
create table MYTABLE
(...fields...)
tablespace MYTABLESPACE
(initial 2M
next 1M);
that means Oracle reserves a data block of 2Mb for
On Fri, 25 Jun 2010 06:31:11 -0500, Jim Lyons
wrote:
> I think you're confusing table size with data base size. The original
post
> grouped by schema so it appears the question concerns database size. I
> don't believe mysql imposes any limits on that. Is there a limit on the
> number of
ri, Jun 25, 2010 at 4:13 AM, Johan De Meersman wrote:
> On Fri, Jun 25, 2010 at 7:11 AM, Prabhat Kumar wrote:
>
>> In case MyISAM it will grow up to space on your data drive or the Max size
>> of file limited by OS..
>>
>
>
> Not entirely correct. There is some kind
On Fri, Jun 25, 2010 at 7:11 AM, Prabhat Kumar wrote:
> In case MyISAM it will grow up to space on your data drive or the Max size
> of file limited by OS..
>
Not entirely correct. There is some kind of limit to a MyISAM file that has
to do with pointer size - I've encountered it
and-table.html>
How can I increase the size of a database?
>
Its depend upon the how have you configured my.cnf and the type of engine
you are using.
In case MyISAM it will grow up to space on your data drive or the Max size
of file limited by OS..
and In case of Innodb it will also grow up to
t;) to another
filesystem and symlink it. You can also store individual tables and table
files on other file systems and symlink those. Either way, you have the
total collection of disk space available to you. This assumes a Linux OS.
If your innodb tables are being restricted, you need to s
what is the innodb file size that u have specified in my.cnf.
If the last file is autoextend, that this will grow to the size of the disk
space avaliable.
regards
anandkl
On Thu, Jun 24, 2010 at 7:43 PM, Sarkis Karayan wrote:
> I feel like I am missing something, because I am not able to f
I feel like I am missing something, because I am not able to find the
answer to this simple question.
How can I increase the size of a database?
I am using the following query to check the available space and notice
that it is time to increase.
SELECT
table_schema AS 'Db Name',
/storage-requirements.html
2009/9/30 John Dove
Hi!
I need to figure out how much disk space an arbitrary number of rows in a
table take up. For example
SELECT DISK_SPACE(*) FROM ORDERS WHERE CREATED_AT BETWEEN x AND y
I know i could do something like a mysqldump with conditions and
-requirements.html
2009/9/30 John Dove
>
>
>
>
>
>
> Hi!
>
> I need to figure out how much disk space an arbitrary number of rows in a
> table take up. For example
>
>
> SELECT DISK_SPACE(*) FROM ORDERS WHERE CREATED_AT BETWEEN x AND y
>
>
> I know i could do someth
Hi!
I need to figure out how much disk space an arbitrary number of rows in a table
take up. For example
SELECT DISK_SPACE(*) FROM ORDERS WHERE CREATED_AT BETWEEN x AND y
I know i could do something like a mysqldump with conditions and analyze the
output file but i'd like to
Hi!
I need to figure out how much disk space an arbitrary number of rows in a table
take up. For example
SELECT DISK_SPACE(*) FROM ORDERS WHERE CREATED_AT BETWEEN x AND y
I know i could do something like a mysqldump with conditions and analyze the
output file but i'd like to
OK, I found the answer. The binary log files were filling up (/usr/
local/mysql/data on OS X/mysql-bin.x). Easy fix:
mysql> reset master;
And all the disk space is recovered
On 15-Mar-09, at 10:47 AM, René Fournier wrote:
It seems MySQL isn't releasing disk space on m
It seems MySQL isn't releasing disk space on my laptop after I copy a
database from one machine to it. From the server, I'm running
something like this:
gzip -dc /Backup/Latest/alba2_2009-03-10_00h45m.Tuesday.sql.gz
| mysql -h 192.168.0.224 -u root -p alba2
...every night. And the
How can I remove a table space from the internal data dictionary? The
documentation doesn't help at all.
Even after a fresh installation and importing all dumps of the databases
from scratch, I get these errors:
Attempting backtrace. You can use the following information to find out
Hi Martin,
The easiest way to restore context in this conversation is to go to the
MySQL home page (www.mysql.com), then go to "Community", then "Lists", then
to look at the archives of the main MySQL mailing list (this one).
I believe at this point that Chris and Stut answered my question
decisi
Dave is trying to establish an algorithm which would fit your requirement
I can see column q is auto-increment which makes sense as you retain the
capability to generate a unique row but jumping into the middle of a
conversation without knowing the prior discussionWhat is/was/will be the
purpos
David T. Ashley wrote:
Hi Chris,
OK, I will try that. Thanks for the help.
My assumption in reading your original post was that you didn't understand
what I wanted to do (but you did).
In order for me to use the solution you have proposed, in addition to
working, this behavior would have to
On 11/25/07, Chris W <[EMAIL PROTECTED]> wrote:
>
> Stut wrote:
> >
> > insert into test1 set p = 2, q = (select max(q) + 1 from test1 as tmp
> > where p = 2)
> >
> > Probably not very efficient, but it works.
> >
> > -Stut
> >
> Auto increment is much easier to do. If your primary key is made up
Stut wrote:
insert into test1 set p = 2, q = (select max(q) + 1 from test1 as tmp
where p = 2)
Probably not very efficient, but it works.
-Stut
Auto increment is much easier to do. If your primary key is made up of
two fields and one of them is Auto Increment, then it will have the
desir
David T. Ashley wrote:
On 11/25/07, Stut <[EMAIL PROTECTED]> wrote:
David T. Ashley wrote:
I have a table with two integer fields (call them p and q).
When I insert a record with a known p, I want to choose q to be one
larger
than the largest q with that p.
What is the best and most effici
On 11/25/07, Stut <[EMAIL PROTECTED]> wrote:
> David T. Ashley wrote:
> > I have a table with two integer fields (call them p and q).
> >
> > When I insert a record with a known p, I want to choose q to be one
> larger
> > than the largest q with that p.
> >
> > What is the best and most efficient
David T. Ashley wrote:
I have a table with two integer fields (call them p and q).
When I insert a record with a known p, I want to choose q to be one larger
than the largest q with that p.
What is the best and most efficient way to do this?
For example, let's say the table contains (p,q):
1,
David T. Ashley wrote:
I have a table with two integer fields (call them p and q).
When I insert a record with a known p, I want to choose q to be one larger
than the largest q with that p.
What is the best and most efficient way to do this?
For example, let's say the table contains (p,q):
I have a table with two integer fields (call them p and q).
When I insert a record with a known p, I want to choose q to be one larger
than the largest q with that p.
What is the best and most efficient way to do this?
For example, let's say the table contains (p,q):
1,1
1,2
1,3
2,1
2,2
2,3
2.4
:500M;datafile7:500M
and datafile is created as per the configuration in the disk.
My Question is how to find the exact free space avaliable in these datafile.How
much data is occupied in the disk.
Use SHOW TABLE STATUS on any InnoDB table.
--
MySQL General Mailing List
For list archives: http
datafile is created as per the configuration in the disk.
My Question is how to find the exact free space avaliable in these datafile.How
much data is occupied in the disk.
Get easy, one-click access to
e expected that the size
can be decreased if 50% (135 GB) but the ibdata was the same value than
before "clean"...
How can I force to save this space?
You must dump your data to files,
Why not change the table type to MyISAM instead of dumping to a file?
If you have a bunch of indexes
Eric Frazier wrote:
Andrew Carlson wrote:
If you do what Baron suggests, you may want to set Innodb to create a
file-per-table - that way, in the future, you could save space when
tables
are dropped, or you could recreate innodb tables individually to save
space,
not have to dump all your
0% (135 GB) but the ibdata was the same value than
before "clean"...
How can I force to save this space?
You must dump your data to files,
Why not change the table type to MyISAM instead of dumping to a file?
If you have a bunch of indexes on the table, you're creating the indexes
Andrew Carlson wrote:
If you do what Baron suggests, you may want to set Innodb to create a
file-per-table - that way, in the future, you could save space when tables
are dropped, or you could recreate innodb tables individually to save space,
not have to dump all your innodb tables at one time
; mysql@lists.mysql.com
Subject: Re: Saving space disk (innodb)
Hi Tiago,
Tiago Cruz wrote:
> Thank you guys!!
>
> I have a lot of MyISAM and a lot of InnoDB on this database.
>
> I did one little "for" to run one "OPTIMIZE TABLE" in each table that
I
> have, o
the ibdata was the same value than
before "clean"...
How can I force to save this space?
You must dump your data to files,
Why not change the table type to MyISAM instead of dumping to a file?
shut down MySQL, delete your current InnoDB tablespace and log files,
reconfigure the serve
Hi Tiago,
Tiago Cruz wrote:
Thank you guys!!
I have a lot of MyISAM and a lot of InnoDB on this database.
I did one little "for" to run one "OPTIMIZE TABLE" in each table that I
have, on my database.
If this step don't save enough disk space, I'll do the B
Thank you guys!!
I have a lot of MyISAM and a lot of InnoDB on this database.
I did one little "for" to run one "OPTIMIZE TABLE" in each table that I
have, on my database.
If this step don't save enough disk space, I'll do the Baron suggestion.
Thank you all!
- T
Dan Rogart wrote:
OPTIMIZE TABLE should reclaim that space, but be aware that it could
take a while to run (locking your table all the while) since it just
maps to an ALTER TABLE statement which creates a new copy of the table.
Depends on how big your tables are.
Doc: http://dev.mysql.com/doc
He's using 4.0, it's not an option in that version :-(
Andrew Carlson wrote:
If you do what Baron suggests, you may want to set Innodb to create a
file-per-table - that way, in the future, you could save space when tables
are dropped, or you could recreate innodb tables individual
If you do what Baron suggests, you may want to set Innodb to create a
file-per-table - that way, in the future, you could save space when tables
are dropped, or you could recreate innodb tables individually to save space,
not have to dump all your innodb tables at one time.
On 10/10/07, Baron
OPTIMIZE TABLE should reclaim that space, but be aware that it could
take a while to run (locking your table all the while) since it just
maps to an ALTER TABLE statement which creates a new copy of the table.
Depends on how big your tables are.
Doc: http://dev.mysql.com/doc/refman/4.1/en
ore "clean"...
How can I force to save this space?
You must dump your data to files, shut down MySQL, delete your current
InnoDB tablespace and log files, reconfigure the server, restart MySQL
and let InnoDB create new (empty) files. Then reload the data.
You should probably save y
can I force to save this space?
set-variable= innodb_buffer_pool_size=500M
set-variable= innodb_additional_mem_pool_size=100M
set-variable= innodb_log_files_in_group=5
set-variable= innodb_log_file_size=150M
set-variable= innodb_log_buffer_size=8M
set-variable= innodb_flush
leted during the usage and administration, so my doubt is: how
> can
> I compact the records to remove those blank spaces and save space, lets
> say "defragment" the database file so data is continuous and contiguous?
>
> This task should be performed just once or twice a month, so no m
Hello
I have a database with variable-size fields, some of them may be
modified/deleted during the usage and administration, so my doubt is: how can
I compact the records to remove those blank spaces and save space, lets
say "defragment" the database file so data is continuous and
h'
> command is showing 0 bytes available in /.
>
> Dan
>
>
> On 8/13/07, Michael Habashy <[EMAIL PROTECTED]> wrote:
> >
> > I am using debian 4.0 and mysql-server-5.0 package.
> > My server will not start because it states that there is not enough
el Habashy <[EMAIL PROTECTED]> wrote:
>
> I am using debian 4.0 and mysql-server-5.0 package.
> My server will not start because it states that there is not enough
> spaceCan someone assist?
>
> rider:~# df -h
> FilesystemSize Used Avail Use% Moun
I am using debian 4.0 and mysql-server-5.0 package.
My server will not start because it states that there is not enough
spaceCan someone assist?
rider:~# df -h
FilesystemSize Used Avail Use% Mounted on
/dev/mapper/vg_house-lv_root
493G 468G 0 100
necessary for data replication and sometimes
for
data recovery.
you can read about it here:
http://dev.mysql.com/doc/refman/5.0/en/binary-log.html
> Or can you tweak it somehow so that it won't' take some much disk space?
you can bzip old logs if you need them but don't want
; take some much disk space?
you can bzip old logs if you need them but don't want them to take so much
space :)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
server
--
Thanks, it works. I also had to comment: expire_logs_days and
max_binlog_size.
One question about this, is it safe to turn of log_bin? Or can you tweak it
somehow so that it won't' take some much disk space?
--
MySQL General Mailing List
For list archives: http://lists
> What can I do to stop this kind of behavior? and is
> its safe to delete all the files with a cronjob? and witch files are
> recommend to delete if so?
just commet log-bin option of [mysqld] section in your my.cnf file
(/etc/my.cnf)
you can also remove these files manually -- it will not affect
1 - 100 of 363 matches
Mail list logo
