|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
mysql max capacity
Hi
I have been using Mysql for sometime and it has been a great DB for my applications all the while esp when combined with PHP. I am wondering what is the maximum data it can hold ? Can the tables be thousands with hundreds of thousand of data ? thanks
__________________
Rathaur ====================== Knowledge is Power |
|
#2
|
|||
|
|||
|
The short answer: the complete database must be smaller than 8 million terabytes. I doubt you'll have this much data.
The long answer: http://www.mysql.com/doc/en/Table_size.html Hadley |
|
#3
|
|||
|
|||
|
thanks, in case of a table with thousands of rows , how can we shorten the query time of the script ?
|
|
#4
|
|||
|
|||
|
It really depends on your query. Have you read http://www.mysql.com/doc/en/MySQL_Optimisation.html ?
Hadley |
![]() |
| Viewing: Dev Articles Community Forums > Databases > MySQL Development > mysql max capacity |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|