|
|
|
|
Menu |
|
|
Home |
| |
|
Discussions |
| |
|
Tools |
| |
|
Affiliates |
| |
|
Content |
| |
|
Info |
| | |
|
|
|
|
|
User Info |
|
Membership:
Latest: MichaelSnaRe
New Today: 0
New Yesterday: 0
Overall: 9144
People Online:
Visitors: 149
Members: 0
Total: 149
|
|
|
|
|
|
Full disclosure |
|
|
|
|
|
|
|
|
|
IT Security and Insecurity Portal |
|
|
about mysql |
|
Posted: Sat Jun 27, 2009 3:06 am |
|
|
earthquaker |
Advanced user |
|
|
Joined: Jun 02, 2008 |
Posts: 111 |
Location: q8 |
|
|
|
|
|
|
how much data is a mysql table capable of handling? and does it affect its speed when fetching?
can a table go over 200 GB ? and how fast/slow is it going to be ?
thanks in advance |
|
|
|
|
|
Re: about mysql |
|
Posted: Sat Jun 27, 2009 4:02 am |
|
|
BoboTiG |
Advanced user |
|
|
Joined: Jun 22, 2009 |
Posts: 66 |
|
|
|
|
|
|
|
earthquaker wrote: | how much data is a mysql table capable of handling? and does it affect its speed when fetching?
can a table go over 200 GB ? and how fast/slow is it going to be ?
thanks in advance |
In theory, the only limit is your hard disk, if you're in FAT32 it's 4Go per table, else it's 200Go if you've a 200Go disk.
Then it will as fast as possible if you "index" correctly. I mean the column which will be most asked have to or should be indexed. |
|
|
|
|
Posted: Sat Jun 27, 2009 4:17 am |
|
|
earthquaker |
Advanced user |
|
|
Joined: Jun 02, 2008 |
Posts: 111 |
Location: q8 |
|
|
|
|
|
|
well i'm kinda greedy and have alot of hd's, so if as u said it goes as much as my hd goes the it can also be > 1TB ? |
|
|
|
|
Posted: Sat Jun 27, 2009 6:03 am |
|
|
gibbocool |
Advanced user |
|
|
Joined: Jan 22, 2008 |
Posts: 208 |
|
|
|
|
|
|
|
Yep a 1TB database will be fine.. once you hit 2TB though you may start having problems |
|
|
|
|
www.waraxe.us Forum Index -> MySql
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
All times are GMT
Page 1 of 1
|
|
|
Powered by phpBB © 2001-2008 phpBB Group
|
|
|
|
|
|
|