| 1 |
count должен выполняться мгновенно
|
| 2 |
проц PII-733 mysql-3.23.59
|
| 3 |
|
| 4 |
mysql> select count(*) from logs;
|
| 5 |
+----------+
|
| 6 |
| count(*) |
|
| 7 |
+----------+
|
| 8 |
| 9989022 |
|
| 9 |
+----------+
|
| 10 |
1 row in set (0.00 sec)
|
| 11 |
|
| 12 |
Alexander Tratsevsky wrote:
|
| 13 |
|
| 14 |
>2x2.4Xeon 4Gb Mem |
| 15 |
> |
| 16 |
>load average: 7.12, 8.34, 8.36 |
| 17 |
>Cpu(s): 61.5% user, 25.3% system |
| 18 |
> |
| 19 |
>mysql> select count(*) from bbsann; |
| 20 |
>+----------+ |
| 21 |
>| count(*) | |
| 22 |
>+----------+ |
| 23 |
>| 17099 | |
| 24 |
>+----------+ |
| 25 |
>1 row in set (2.33 sec) |
| 26 |
> |
| 27 |
>Это нормальная скорость, или нужно как-то настройками MySQL поиграть? |
| 28 |
> |
| 29 |
> |
| 30 |
> |
| 31 |
|
| 32 |
|
| 33 |
--
|
| 34 |
KN0L3DG3 i$ a P0W3R...
|
| 35 |
u$3 y0uR P0W3R iN G00D, N07 3ViL
|
| 36 |
|
| 37 |
(ASM&&sploits)?1(q#ZeAOeA:/dev/null
|
| 38 |
|
| 39 |
|
| 40 |
--
|
| 41 |
gentoo-user-ru@g.o mailing list |
Archives