Reply
MySQL DB Size Limits?
Old 02-06-2008, 06:56 PM MySQL DB Size Limits?
downliner's Avatar
Extreme Talker

Posts: 159
Name: Will
Location: Scotland
Is there a limit (either recommended or forced) for mysql databases?

One of my db's sql dumps is now over 100Mb so I'm wondering if large databases have any negative effect on a sites performance? I haven't noticed any yet but would rather start planning something now if it's about to implode

100Mb may not even be that much but still better to ask just incase
__________________
Recent Work : Buy discount wallpaper and designer wallpaper
downliner is offline
Reply With Quote
View Public Profile Visit downliner's homepage!
 
When You Register, These Ads Go Away!
     
Old 02-06-2008, 07:11 PM Re: MySQL DB Size Limits?
tripy's Avatar
Fetchez la vache!

Posts: 1,851
Name: Thierry
Location: In the void
The limitation is inherent to the system the DB engine run.
Or to be more precise, the file system format the DB datas files are placed.

The more common file systems and their max file size:
http://en.wikipedia.org/wiki/Exabyte

reiserfs 3/4: 8Tb
Ext2/3: 2 to 64 Tb
Xfs: 8 Exabytes (Holly smokes !!!!)

So, no, 100 Mb is not a so big DB in comparison.
I used to handle a DB that had reached 18 Go after 5 years (for a dating site).
__________________
Listen to the ducky: "This is awesome!!!"

tripy is offline
Reply With Quote
View Public Profile
 
Reply     « Reply to MySQL DB Size Limits?
 

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off




   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML

 


Page generated in 0.11632 seconds with 13 queries