Rozeboom [DAS]"
> To: mysql@lists.mysql.com
> Sent: Friday, 18 November, 2011 5:06:44 PM
> Subject: RE: ibdata1 and undo log
>
> Thanks for the response, Johan.
>
> It would really help if I could determine when the ballooning is
> occurring. Do you know of any way to
: mysql@lists.mysql.com
Subject: Re: ibdata1 and undo log
- Original Message -
> From: "Kay Rozeboom [DAS]"
>
> 1) Can anyone verify that the additional (presently unused)
> space was allocated for the undo log?
> 2) Are the many 1-page segments a leftove
- Original Message -
> From: "Kay Rozeboom [DAS]"
>
> 1) Can anyone verify that the additional (presently unused)
> space was allocated for the undo log?
> 2) Are the many 1-page segments a leftover from a large undo
> log?
I'm not too hot on the InnoDB internals, but yes, the
Sebastien,
On Wed, May 27, 2009 at 11:24 AM, Sebastien MORETTI
wrote:
Hi,
Your data is gone (unless you can undelete it from whatever filesystems
you're using).
I think it's too late for this, because the MySQL server has been
restarted.
You may be able to recover from the file system. So
Sebastien,
On Wed, May 27, 2009 at 11:35 AM, Sebastien MORETTI
wrote:
>>> I think it's too late for this, because the MySQL server has been
>>> restarted.
>>
>>
>> You may be able to recover from the file system. So long as you
>> haven't written lots of data to the file system since the loss th
Sebastien,
On Wed, May 27, 2009 at 11:24 AM, Sebastien MORETTI
wrote:
Hi,
Your data is gone (unless you can undelete it from whatever filesystems
you're using).
I think it's too late for this, because the MySQL server has been restarted.
You may be able to recover from the file system. So
Sebastien,
On Wed, May 27, 2009 at 11:24 AM, Sebastien MORETTI
wrote:
>> Hi,
>>
>> Your data is gone (unless you can undelete it from whatever filesystems
>> you're using).
>
> I think it's too late for this, because the MySQL server has been restarted.
You may be able to recover from the file
Hi,
Your data is gone (unless you can undelete it from whatever filesystems you're
using).
I think it's too late for this, because the MySQL server has been restarted.
You should be able to recover the schema from the directories and .frm files by
doing something like this hack:
1. Take a
Hi,
Your data is gone (unless you can undelete it from whatever filesystems you're
using).
You should be able to recover the schema from the directories and .frm files by
doing something like this hack:
1. Take a copy of your .frm files and keep them somewhere safe.
2. Create a database with t
* Undelete the file
* Restore from backup
* Apply the infinite monkey theorem
On Wed, May 27, 2009 at 8:41 AM, Sebastien MORETTI <
sebastien.more...@unil.ch> wrote:
> Hi,
>
> Is there a way to recover data and/or database schema when ibdata1 file has
> been removed (for InnoDB databases) ?
>
> (M
Hello.
>there, in fact, anything important in that ibdata1 file, or can I just
>shut down mySQL, move that file somewhere else, and then re-start mySQL?
Yes, this file contains important information.
>Is this possible, or am I stuck having my database server off-line for
>hours while the
At 15:12 -0500 12/14/05, Nathan Gross wrote:
Hi;
A while ago, I changed most of my myisam based tables over to innodb. Fine.
A while later, I noticed and implemented the option to keep the
files separate.
Now, weeks later, I still have a huge, 7 gig ibdata1, plus many *.ibd files.
Can I delete
Hello.
I don't think so. As I've understood InnoDB doesn't do it. See:
http://dev.mysql.com/doc/mysql/en/innodb-file-space.html
Eric Persson <[EMAIL PROTECTED]> wrote:
> Gleb Paharenko wrote:
>
>> Hello.
>>
>> Searching in the archives says you could get worse performance, bec
Gleb Paharenko wrote:
Hello.
Searching in the archives says you could get worse performance, because
of extending during transactions:
Yes, read a few of those, but how about the fix for this, will the data
rearrange itself automatically when I specify more files?
//Eric
--
MySQL General Mailing
Hello.
Searching in the archives says you could get worse performance, because
of extending during transactions:
http://lists.mysql.com/mysql/180037
http://lists.mysql.com/mysql/170946
Eric Persson <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I've been running a innodbdatabase for a wh
> -Original Message-
> From: joe collins [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 30, 2004 1:26 AM
> To: MySQL
> Subject: ibdata1 size
>
> HI,
>
> the ibdata1file in mysql\data has reached a size of 10Mb in just over a
> week, the database I have set up is quite limited, only 7
At 12:24 -0300 3/5/04, cytron wrote:
I lost my ibdata1 file, I don't have backup, and now my
tables InnoDB don't open.
Well, that's a problem.
If you've lost your data, and you have no backup, then ... you've lost your
data.
Possibly if your operating system allows some kind of undelete operation,
On Sun, 18 Jan 2004, Hassan Shaikh wrote:
> Hi,
>
> How do I resize (shrink & expand) InnoDB file?
>
You can read about the various InnoDB specific startup options here:
http://www.mysql.com/doc/en/InnoDB_start.html
cheers,
Tobias
--
MySQL General Mailing List
For list archives: http://lists.m
Hi!
- Original Message -
From: "walt" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Thursday, May 23, 2002 10:24 PM
Subject: Re: Ibdata1 file thats just too big...
> "Williamson, David" wrote:
>
> > Hi there,
> >
> > My
"Williamson, David" wrote:
> Hi there,
>
> My Ibdatafile is set too big (the disk is full to the point that nothing is
> executing properly) I am wondering is it safe to delete this file and then
> in the my.cnf file reset the size to something smaller... - how does the
> Ibdata file work in conj
I am keen to here a response to this as well!
TIA
Mike
- Original Message -
From: "Williamson, David" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, May 22, 2002 4:38 PM
Subject: Ibdata1 file thats just too big...
> Hi there,
>
> My Ibdatafile is set too big (the disk is
21 matches
Mail list logo
