linux-debian-1:~# uptime
19:25:22 up 3 days, 10:35, 1 user, load average: 0.19, 0.20, 0.12
linux-debian-1:~# /etc/init.d/mysql stop
Stopping MySQL database server: mysqld^[[A.
linux-debian-1:~# /etc/init.d/mysql start
Starting MySQL database server: mysqld.
Checking for corrupt, not cleanly closed and upgrade needing tables..
linux-debian-1:~# mysql -u su1234
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 67
Server version: 5.0.51a-24+lenny4 (Debian)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use test;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show create table `count_test`\G
*************************** 1. row ***************************
Table: count_test
Create Table: CREATE TABLE `count_test` (
`a` int(10) NOT NULL auto_increment,
`b` int(10) NOT NULL,
`c` int(10) NOT NULL,
`d` varchar(32) NOT NULL,
PRIMARY KEY (`a`),
KEY `bc` (`b`,`c`)
) ENGINE=MyISAM AUTO_INCREMENT=10000001 DEFAULT CHARSET=cp1251
1 row in set (0.01 sec)
mysql> SELECT SQL_NO_CACHE * FROM count_test WHERE b = 666 ORDER BY c LIMIT 5;
+-------+-----+---+----------------------------------+
| a | b | c | d |
+-------+-----+---+----------------------------------+
| 19667 | 666 | 0 | 2d40f027dc7db2e6860f88994ac7a265 |
| 20667 | 666 | 0 | 6ac37313e074d4fa4c73335747f35fa1 |
| 34667 | 666 | 0 | 8a45da3f21ea12d7948abeaf346c5bd1 |
| 41667 | 666 | 0 | 3a7c2a3144427d8921928f3ab3112bf7 |
| 44667 | 666 | 0 | aae92066b9e2a57287b442383d7b88b6 |
+-------+-----+---+----------------------------------+
5 rows in set (0.73 sec)
mysql> SELECT SQL_NO_CACHE * FROM count_test WHERE b = 666 ORDER BY c LIMIT 5;
+-------+-----+---+----------------------------------+
| a | b | c | d |
+-------+-----+---+----------------------------------+
| 19667 | 666 | 0 | 2d40f027dc7db2e6860f88994ac7a265 |
| 20667 | 666 | 0 | 6ac37313e074d4fa4c73335747f35fa1 |
| 34667 | 666 | 0 | 8a45da3f21ea12d7948abeaf346c5bd1 |
| 41667 | 666 | 0 | 3a7c2a3144427d8921928f3ab3112bf7 |
| 44667 | 666 | 0 | aae92066b9e2a57287b442383d7b88b6 |
+-------+-----+---+----------------------------------+
5 rows in set (0.00 sec)
mysql> SELECT SQL_NO_CACHE count(*) FROM count_test WHERE b = 666;
+----------+
| count(*) |
+----------+
| 10000 |
+----------+
1 row in set (0.01 sec)
mysql> SELECT SQL_NO_CACHE SQL_CALC_FOUND_ROWS * FROM count_test WHERE b = 666 ORDER BY c LIMIT 5;
+-------+-----+---+----------------------------------+
| a | b | c | d |
+-------+-----+---+----------------------------------+
| 19667 | 666 | 0 | 2d40f027dc7db2e6860f88994ac7a265 |
| 20667 | 666 | 0 | 6ac37313e074d4fa4c73335747f35fa1 |
| 34667 | 666 | 0 | 8a45da3f21ea12d7948abeaf346c5bd1 |
| 41667 | 666 | 0 | 3a7c2a3144427d8921928f3ab3112bf7 |
| 44667 | 666 | 0 | aae92066b9e2a57287b442383d7b88b6 |
+-------+-----+---+----------------------------------+
5 rows in set (1.12 sec)
mysql> SELECT SQL_NO_CACHE SQL_CALC_FOUND_ROWS * FROM count_test WHERE b = 666 ORDER BY c LIMIT 5;
+-------+-----+---+----------------------------------+
| a | b | c | d |
+-------+-----+---+----------------------------------+
| 19667 | 666 | 0 | 2d40f027dc7db2e6860f88994ac7a265 |
| 20667 | 666 | 0 | 6ac37313e074d4fa4c73335747f35fa1 |
| 34667 | 666 | 0 | 8a45da3f21ea12d7948abeaf346c5bd1 |
| 41667 | 666 | 0 | 3a7c2a3144427d8921928f3ab3112bf7 |
| 44667 | 666 | 0 | aae92066b9e2a57287b442383d7b88b6 |
+-------+-----+---+----------------------------------+
5 rows in set (0.02 sec)
mysql> SELECT FOUND_ROWS();
+--------------+
| FOUND_ROWS() |
+--------------+
| 10000 |
+--------------+
1 row in set (0.00 sec)
linux-debian-1:~# cd /var/lib/mysql/test
linux-debian-1:/var/lib/mysql/test# ls -lah | grep count
-rw-rw---- 1 mysql mysql 8,5K Дек 3 20:18 count_test.frm
-rw-rw---- 1 mysql mysql 494M Дек 13 19:33 count_test.MYD
-rw-rw---- 1 mysql mysql 282M Дек 13 19:39 count_test.MYI
linux-debian-1:/var/lib/mysql/test# cat /proc/cpuinfo
processor : 0
vendor_id : GenuineIntel
cpu family : 15
model : 6
model name : Intel(R) Celeron(R) D CPU 3.06GHz
stepping : 4
cpu MHz : 3059.138
cache size : 512 KB
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 6
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe nx lm constant_tsc up pebs bts pni monitor ds_cpl cid cx16 xtpr lahf_lm
bogomips : 6125.09
clflush size : 64
power management:
linux-debian-1:/var/lib/mysql/test# cat /proc/meminfo
MemTotal: 507148 kB
MemFree: 59768 kB
Buffers: 6900 kB
Cached: 322212 kB
SwapCached: 0 kB
Active: 322784 kB
Inactive: 88700 kB
HighTotal: 0 kB
HighFree: 0 kB
LowTotal: 507148 kB
LowFree: 59768 kB
SwapTotal: 1477940 kB
SwapFree: 1477272 kB
Dirty: 716 kB
Writeback: 0 kB
AnonPages: 82392 kB
Mapped: 17492 kB
Slab: 28864 kB
SReclaimable: 14260 kB
SUnreclaim: 14604 kB
PageTables: 1144 kB
NFS_Unstable: 0 kB
Bounce: 0 kB
WritebackTmp: 0 kB
CommitLimit: 1731512 kB
Committed_AS: 712716 kB
VmallocTotal: 516088 kB
VmallocUsed: 4228 kB
VmallocChunk: 511800 kB
HugePages_Total: 0
HugePages_Free: 0
HugePages_Rsvd: 0
HugePages_Surp: 0
Hugepagesize: 4096 kB
linux-debian-1:/var/lib/mysql/test#