Hi !
Please notice:
Internationalization support is lacking right now; UTF8 support planned first half of 2009.
So the article is rather old and outdated.
50 billion is the limit today
not quite:
Server version: 5.1.14-log build number (revision)=IB_3.3.0_r6457_6503(iee - commercial)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> select count(*) as records,
-> cast(count(*)/1000000 as unsigned) as millions,
-> cast(count(*)/1000000000 as unsigned) as billions,
-> cast(count(*)/1000000000000 as unsigned) as trillions
-> from nines;
+---------------+----------+----------+-----------+
| records | millions | billions | trillions |
+---------------+----------+----------+-----------+
| 1000000000000 | 1000000 | 1000 | 1 |
+---------------+----------+----------+-----------+
1 row in set (1.53 sec)
greatly depends on the data row size
I’ve never heard about it and I cannot confirm that
.. and datatypes used
Indeed, for some string columns their metadata can grow so much that a memory manager will have troubles allocating large memory chunks for them. One can construct such a case. Also, one can avoid it.
