Members   Search   Help    Register    Login   Home

Show: Today's Messages  :: Show Polls :: Message Navigator

what is the purpose of ibdata1,ib_logfile0,ib_logfile1 [message #1437] Mon, 18 June 2007 01:29  julian Messages: 13 Registered: March 2007 Junior Member Hi I'm new to mysql. In /var/lib/mysql directory I'm creating databases. I'm using InnoDB storage engine. In this directory three files namely ibdata1,ib_logfile0,ib_logfile1 created automatically. What is the use of these files and it contains any information? If I deleted these files what happens? Any one answer for this doubt. Report message to a moderator

	what is the purpose of ibdata1,ib_logfile0,ib_logfile1 By: julian on Mon, 18 June 2007 01:29
	Re: what is the purpose of ibdata1,ib_logfile0,ib_logfile1 By: babuno5 on Mon, 18 June 2007 02:23
	Re: what is the purpose of ibdata1,ib_logfile0,ib_logfile1 By: julian on Mon, 18 June 2007 02:58
	Re: what is the purpose of ibdata1,ib_logfile0,ib_logfile1 By: sterin on Mon, 18 June 2007 03:23
	Re: what is the purpose of ibdata1,ib_logfile0,ib_logfile1 By: noqlew2 on Tue, 26 June 2007 10:39
	Re: what is the purpose of ibdata1,ib_logfile0,ib_logfile1 By: sterin on Tue, 26 June 2007 10:57
	Re: what is the purpose of ibdata1,ib_logfile0,ib_logfile1 By: TheCowGod on Wed, 27 June 2007 16:31

Previous Topic:	Tuning server for very large (250GB) data sets
Next Topic:	InnoDB's compact row format

Goto Forum:

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [ ]