Usando o exemplo do FB again,
Os caras processam 13Milhoes de queries por segundo (QPS) com o MySQL
(http://highscalability.com/blog/2010/11/4/facebook-at-13-million-queries-per-second-recommends-minimiz.html)
Claro que tudo tem um custo, a infra deles eh algo absurto, porem nao
vejo limitacao no SGBD.
Marcelo Altmann
On 18/04/13 15:37, Marcelo Altmann wrote:
Tenho que descordar dos demais novamente.
MySQL eh tudo uma questao de configurar, se tu usa versao que vem
default no debian squeeze tens que ativar o innodb plugin.
Tenho tabelas com 20+ milhoes e tenho resultados instantaneos fazendo
busca por key:
mysql> SELECT TABLE_ROWS FROM INFORMATION_SCHEMA.tables WHERE
TABLE_SCHEMA='------' AND TABLE_NAME='cookies'\G
*************************** 1. row ***************************
TABLE_ROWS: 27399118
1 row in set (0.00 sec)
mysql> SELECT SQL_NO_CACHE * FROM cookies WHERE cookieID = 123452;
+----------+-------------+---------------------+----------------------+
| cookieID | containerID | dtCreated | lastSelectedLanguage |
+----------+-------------+---------------------+----------------------+
| 123452 | 8 | 2010-05-27 09:09:28 | english |
+----------+-------------+---------------------+----------------------+
1 row in set (0.00 sec)
mysql>
Marcelo Altmann
On 18/04/13 15:25, [email protected] wrote:
um e
--
To UNSUBSCRIBE, email to [email protected]
with a subject of "unsubscribe". Trouble? Contact [email protected]
Archive: http://lists.debian.org/[email protected]
