Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
Home » Performance » MySQL » Some tablespace understanding
Some tablespace understanding [message #719] Wed, 14 February 2007 10:53 Go to next message
newtomysql is currently offline newtomysql
Messages: 30
Registered: February 2007
Member
Dear All,
I am new to innodb. So I am curios to learn about innodb tablespace. Ok now I look into my my.ini and find this line innodb_data_file_path=ibdata1:10485760:autoextend. So it means I have ibdata1 file of size 10MB rite. So once my ibdata1 goes beyong 10MB what exactly happens ? I dont understand what does it mean by file size limitationt to 4GB. How can I monitor that my ibdata is reaching 4GB and how to overcome this problem. I really wanna get a good understanding of innodb as I plan to use it for huge data and not get into some crash and errors. Hope someone can shed some light to me. Thanks is advance.
Report message to a moderator
Re: Some tablespace understanding [message #720 is a reply to message #719 ] Wed, 14 February 2007 12:58 Go to previous messageGo to next message
Peter is currently offline Peter
Messages: 405
Registered: August 2006
Senior Member
Super Guru
Quite Simple,

This means tablespace is 10GB initial and will growth automatically as needed.

4GB file size limit does not exist on most operation systems for years now.

Peter Zaitsev, MySQL Performance Expert
MySQL Performance Blog - http://www.mysqlperformanceblog.com
MySQL Consulting http://www.mysqlperformanceblog.com/mysql-consulting/
Report message to a moderator
Re: Some tablespace understanding [message #723 is a reply to message #720 ] Wed, 14 February 2007 19:25 Go to previous messageGo to next message
newtomysql is currently offline newtomysql
Messages: 30
Registered: February 2007
Member
Dear Peter,
Thanks but then why most articles are speaking of this limitations. Does xp or red hat have this limitations ? Another thing is that how will I know wat is exactly my size of my ibdata1 as I am adding on data. This why I am asking is that if it overflow my current hard disk then I would need another hard disk to join rite ? How to do that ya ?
Report message to a moderator
Re: Some tablespace understanding [message #724 is a reply to message #723 ] Thu, 15 February 2007 04:09 Go to previous messageGo to next message
Peter is currently offline Peter
Messages: 405
Registered: August 2006
Senior Member
Super Guru
As you do not mention the articles themselves I do not know what is about them - they might just be outdated.

Recent Linux does not have this problem, Windows should not have too.

you can have multiple innodb tablespace files if you will need to extend it over multiple hard drives or you can have file system volume spanning across several drives, but it is best to use RAID in such cases for best performance as Innodb simply concatenates tablespaces.

Peter Zaitsev, MySQL Performance Expert
MySQL Performance Blog - http://www.mysqlperformanceblog.com
MySQL Consulting http://www.mysqlperformanceblog.com/mysql-consulting/
Report message to a moderator
Re: Some tablespace understanding [message #725 is a reply to message #724 ] Thu, 15 February 2007 10:18 Go to previous messageGo to next message
newtomysql is currently offline newtomysql
Messages: 30
Registered: February 2007
Member
Dear Peter,
I agree that article might be out dated. But according to the mysql manual it says that NTFS limitation is 2TB which I think is big enough rite. What I am curios is like now in the begining I have a ibdata1 of size 10Mb rite and the rest is autoextend. So how can I monitor that my ibdata1 has across 10MB ? After it across 10MB where will the rest of my data will be stored ? I am very curios to know how can i monitor the growth of my database space and also know wat is exactly my database size. Thanks peter.
Report message to a moderator
Re: Some tablespace understanding [message #726 is a reply to message #725 ] Thu, 15 February 2007 11:07 Go to previous messageGo to next message
Peter is currently offline Peter
Messages: 405
Registered: August 2006
Senior Member
Super Guru
Just look at file size.

Peter Zaitsev, MySQL Performance Expert
MySQL Performance Blog - http://www.mysqlperformanceblog.com
MySQL Consulting http://www.mysqlperformanceblog.com/mysql-consulting/
Report message to a moderator
Re: Some tablespace understanding [message #727 is a reply to message #726 ] Thu, 15 February 2007 11:12 Go to previous message
newtomysql is currently offline newtomysql
Messages: 30
Registered: February 2007
Member
Dear Peter,
I mean like in the begining my ibdata1 is 10MB but I am sure is not even 10MB data in it rite and why is it already 10MB ? What I am asking is how to know how big is my data size ? So once it acrosses 10MB what will be the next file name will be ? So is there any special settings to it. Thanks.
Report message to a moderator
Previous Topic:How to tune query if the execution plan already looks perfect
Next Topic:To normalise or not to normalise?
Goto Forum:
  

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

Current Time: Mon Jul 6 21:06:27 EDT 2009

Total time taken to generate the page: 0.03167 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 2.7.7.
Copyright ©2001-2007 FUD Forum Bulletin Board Software

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.