|
1548.4.108
by Zimin
add support for reading '/proc/cpuinfo', it's a enhanced support for reading /proc/meminfo. it has multiple sections. |
1 |
DROP TABLE IF EXISTS t1; |
|
1786.3.2
by Monty Taylor
Cleaned up the initial pass at this. It's not perfect, but it does work. |
2 |
CREATE TABLE t1 (a int) ENGINE=FILESYSTEM,FILE="../../filesystem_ln/select_cpuinfo.data",FORMAT="KEY_VALUE",COL_SEPARATOR=":"; |
|
1548.4.108
by Zimin
add support for reading '/proc/cpuinfo', it's a enhanced support for reading /proc/meminfo. it has multiple sections. |
3 |
SELECT * FROM t1; |
4 |
address sizes apicid bogomips cache size cache_alignment clflush size core id cpu MHz cpu cores cpu family cpuid level flags fpu fpu_exception initial apicid model model name physical id power management processor siblings stepping vendor_id wp |
|
5 |
36 bits physical, 48 bits virtual 0 5999.27 6144 KB 64 64 0 2000.000 2 6 13 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 syscall nx lm constant_tsc arch_perfmon pebs bts rep_good nopl pni monitor ds_cpl vmx smx est tm2 ssse3 cx16 xtpr sse4_1 lahf_lm yes yes 0 23 Intel(R) Core(TM)2 Duo CPU E8400 @ 3.00GHz 0 NULL 0 2 10 GenuineIntel yes |
|
6 |
36 bits physical, 48 bits virtual 1 5999.08 6144 KB 64 64 1 2000.000 2 6 13 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 syscall nx lm constant_tsc arch_perfmon pebs bts rep_good nopl pni monitor ds_cpl vmx smx est tm2 ssse3 cx16 xtpr sse4_1 lahf_lm yes yes 1 23 Intel(R) Core(TM)2 Duo CPU E8400 @ 3.00GHz 0 NULL 1 2 10 GenuineIntel yes |
|
7 |
SHOW CREATE TABLE t1; |
|
8 |
Table Create Table |
|
9 |
t1 CREATE TABLE `t1` ( |
|
|
1743.5.2
by LinuxJedi
Alter many test cases for the new SHOW CREATE TABLE output |
10 |
`address sizes` VARCHAR(34), |
11 |
`apicid` VARCHAR(2), |
|
12 |
`bogomips` VARCHAR(8), |
|
13 |
`cache size` VARCHAR(8), |
|
14 |
`cache_alignment` VARCHAR(3), |
|
15 |
`clflush size` VARCHAR(3), |
|
16 |
`core id` VARCHAR(2), |
|
17 |
`cpu MHz` VARCHAR(9), |
|
18 |
`cpu cores` VARCHAR(2), |
|
19 |
`cpu family` VARCHAR(2), |
|
20 |
`cpuid level` VARCHAR(3), |
|
21 |
`flags` VARCHAR(249), |
|
22 |
`fpu` VARCHAR(4), |
|
23 |
`fpu_exception` VARCHAR(4), |
|
24 |
`initial apicid` VARCHAR(2), |
|
25 |
`model` VARCHAR(3), |
|
26 |
`model name` VARCHAR(48), |
|
27 |
`physical id` VARCHAR(2), |
|
28 |
`power management` VARCHAR(1), |
|
29 |
`processor` VARCHAR(2), |
|
30 |
`siblings` VARCHAR(2), |
|
31 |
`stepping` VARCHAR(3), |
|
32 |
`vendor_id` VARCHAR(13), |
|
33 |
`wp` VARCHAR(4) |
|
|
1786.3.2
by Monty Taylor
Cleaned up the initial pass at this. It's not perfect, but it does work. |
34 |
) ENGINE=FILESYSTEM FILE='../../filesystem_ln/select_cpuinfo.data', FORMAT='KEY_VALUE', COL_SEPARATOR=':' COLLATE = utf8_general_ci |
|
1548.4.108
by Zimin
add support for reading '/proc/cpuinfo', it's a enhanced support for reading /proc/meminfo. it has multiple sections. |
35 |
DROP TABLE t1; |