mysql> select sysdate() from dual; +---------------------+ | sysdate() | +---------------------+ | 2011-07-21 00:48:24 | +---------------------+ 1 row in set (0.00 sec) mysql> select version(); +------------+ | version() | +------------+ | 5.5.11-log | +------------+ 1 row in set (0.00 sec) mysql> show full processlist; +------+----------------+-------------------------------------------+--------------------+---------+-------+---------------------------------+-------------------------+ | Id | User | Host | db | Command | Time | State | Info | +------+----------------+-------------------------------------------+--------------------+---------+-------+---------------------------------+-------------------------+ | 10 | ACC_I_ACC_03 | lim-int1-acc-01.bluestarenergy.com:39388 | opentaps | Sleep | 17695 | | NULL | | 13 | ACC_I_ACC_03 | lim-int1-acc-01.bluestarenergy.com:54729 | opentaps | Sleep | 2863 | | NULL | | 14 | ACC_I_ACC_03 | lim-int1-acc-01.bluestarenergy.com:51257 | opentaps | Sleep | 8 | | NULL | | 80 | B2B_I_B2B_02 | lim-int1-b2b-01.bluestarenergy.com:57045 | bse_eis | Sleep | 41 | | NULL | | 82 | GISB_I_B2BG_02 | lim-int1-b2bg-01.bluestarenergy.com:47474 | bse_eis | Sleep | 1124 | | NULL | | 87 | B2BW_I_B2BW_02 | lim-int1-b2bw-01.bluestarenergy.com:36830 | bse_eis | Sleep | 44 | | NULL | | 88 | B2BW_I_B2BW_02 | lim-int1-b2bw-01.bluestarenergy.com:46426 | bse_eis | Sleep | 1124 | | NULL | | 89 | B2BW_I_B2BW_02 | lim-int1-b2bw-01.bluestarenergy.com:41714 | bse_eis | Sleep | 1124 | | NULL | | 91 | B2BW_I_B2BW_02 | lim-int1-b2bw-01.bluestarenergy.com:60081 | bse_eis | Sleep | 44 | | NULL | | 92 | B2BW_I_B2BW_02 | lim-int1-b2bw-01.bluestarenergy.com:60851 | bse_eis | Sleep | 1004 | | NULL | | 93 | B2BW_I_B2BW_02 | lim-int1-b2bw-01.bluestarenergy.com:33252 | bse_eis | Sleep | 44 | | NULL | | 123 | MSCP_I_SFAP_02 | lim-int1-sfap-01.bluestarenergy.com:39164 | bse_eis | Sleep | 20413 | | NULL | | 134 | B2B_I_B2B_02 | lim-int1-b2b-01.bluestarenergy.com:40137 | bse_eis | Sleep | 44 | | NULL | | 207 | B2B_I_B2B_02 | lim-int1-b2b-01.bluestarenergy.com:37892 | bse_eis | Sleep | 1124 | | NULL | | 343 | FWCB_I_FWCB_02 | lim-int1-fwcb-01.bluestarenergy.com:37726 | bse_eis | Sleep | 24522 | | NULL | | 514 | WTHC_I_WTHC_02 | lim-int1-wthc-01.bluestarenergy.com:37144 | bse_eis | Sleep | 25906 | | NULL | | 515 | WTHC_I_WTHC_02 | lim-int1-wthc-01.bluestarenergy.com:48154 | bse_eis | Sleep | 24270 | | NULL | | 516 | WTHC_I_WTHC_02 | lim-int1-wthc-01.bluestarenergy.com:57767 | bse_eis | Sleep | 25925 | | NULL | | 1382 | HUSP_I_HUSP_02 | lim-int1-husp-01.bluestarenergy.com:35706 | bse_eis | Sleep | 17322 | | NULL | | 1803 | root | localhost | bse_eis | Query | 13311 | Waiting for table metadata lock | truncate table zipcodes | | 1881 | root | localhost | information_schema | Query | 0 | NULL | show full processlist | | 3004 | BILN_I_BILN_02 | lim-int1-bila-01.bluestarenergy.com:37922 | bse_eis | Sleep | 4351 | | NULL | | 3024 | ACCE_I_ACCE_03 | lim-int1-acce-01.bluestarenergy.com:53279 | opentaps | Sleep | 824 | | NULL | | 3176 | WTH_I_WTH_02 | lim-int1-wth-01.bluestarenergy.com:43934 | bse_eis | Sleep | 2804 | | NULL | | 3177 | WTH_I_WTH_02 | lim-int1-wth-01.bluestarenergy.com:32881 | bse_eis | Sleep | 2864 | | NULL | | 3237 | ACCE_I_ACCE_03 | lim-int1-acce-01.bluestarenergy.com:54416 | opentaps | Sleep | 2462 | | NULL | | 3238 | ACCE_I_ACCE_03 | lim-int1-acce-01.bluestarenergy.com:39824 | opentaps | Sleep | 2462 | | NULL | | 3239 | ACCE_I_ACCE_03 | lim-int1-acce-01.bluestarenergy.com:49403 | opentaps | Sleep | 2462 | | NULL | | 3240 | ACCE_I_ACCE_03 | lim-int1-acce-01.bluestarenergy.com:57937 | opentaps | Sleep | 2462 | | NULL | | 3254 | USR_GLB_B2B | 10.3.50.67:3643 | bse_eis | Sleep | 349 | | NULL | | 3461 | ACCE_I_ACCE_03 | lim-int1-acce-01.bluestarenergy.com:57013 | opentaps | Sleep | 662 | | NULL | | 3462 | ACCE_I_ACCE_03 | lim-int1-acce-01.bluestarenergy.com:46610 | opentaps | Sleep | 662 | | NULL | | 3463 | ACCE_I_ACCE_03 | lim-int1-acce-01.bluestarenergy.com:43766 | opentaps | Sleep | 662 | | NULL | | 3464 | ACCE_I_ACCE_03 | lim-int1-acce-01.bluestarenergy.com:55417 | opentaps | Sleep | 224 | | NULL | | 3465 | ACCE_I_ACCE_03 | lim-int1-acce-01.bluestarenergy.com:46657 | opentaps | Sleep | 662 | | NULL | | 3525 | BILN_I_BILN_02 | lim-int1-bilx-01.bluestarenergy.com:35270 | bse_eis | Sleep | 165 | | NULL | | 3526 | BILN_I_BILN_02 | lim-int1-bilx-01.bluestarenergy.com:45444 | bse_eis | Sleep | 165 | | NULL | | 3527 | BILN_I_BILN_02 | lim-int1-bilx-01.bluestarenergy.com:60137 | bse_eis | Sleep | 165 | | NULL | | 3528 | BILN_I_BILN_02 | lim-int1-bilx-01.bluestarenergy.com:37258 | bse_eis | Sleep | 165 | | NULL | | 3529 | BILN_I_BILN_02 | lim-int1-bilx-01.bluestarenergy.com:42467 | bse_eis | Sleep | 165 | | NULL | | 3530 | BILN_I_BILN_02 | lim-int1-bilx-01.bluestarenergy.com:55857 | bse_eis | Sleep | 165 | | NULL | | 3531 | BILN_I_BILN_02 | lim-int1-bilx-01.bluestarenergy.com:50678 | bse_eis | Sleep | 165 | | NULL | | 3532 | BILN_I_BILN_02 | lim-int1-biln-01.bluestarenergy.com:47570 | bse_eis | Sleep | 154 | | NULL | | 3533 | BILN_I_BILN_02 | lim-int1-biln-01.bluestarenergy.com:42823 | bse_eis | Sleep | 154 | | NULL | | 3534 | BILN_I_BILN_02 | lim-int1-biln-01.bluestarenergy.com:48073 | bse_eis | Sleep | 154 | | NULL | | 3535 | BILN_I_BILN_02 | lim-int1-biln-01.bluestarenergy.com:44328 | bse_eis | Sleep | 154 | | NULL | | 3536 | BILN_I_BILN_02 | lim-int1-biln-01.bluestarenergy.com:36523 | bse_eis | Sleep | 154 | | NULL | | 3537 | BILN_I_BILN_02 | lim-int1-bilx-01.bluestarenergy.com:38484 | bse_eis | Sleep | 105 | | NULL | | 3538 | BILN_I_BILN_02 | lim-int1-bilx-01.bluestarenergy.com:38380 | bse_eis | Sleep | 105 | | NULL | | 3539 | BILN_I_BILN_02 | lim-int1-biln-01.bluestarenergy.com:57989 | bse_eis | Sleep | 94 | | NULL | | 3540 | BILN_I_BILN_02 | lim-int1-biln-01.bluestarenergy.com:49165 | bse_eis | Sleep | 94 | | NULL | | 3541 | BILN_I_BILN_02 | lim-int1-biln-01.bluestarenergy.com:46878 | bse_eis | Sleep | 94 | | NULL | | 3542 | BILN_I_BILN_02 | lim-int1-biln-01.bluestarenergy.com:41554 | bse_eis | Sleep | 94 | | NULL | | 3543 | BILN_I_BILN_02 | lim-int1-biln-01.bluestarenergy.com:60103 | bse_eis | Sleep | 94 | | NULL | | 3544 | BILN_I_BILN_02 | lim-int1-bilx-01.bluestarenergy.com:54397 | bse_eis | Sleep | 45 | | NULL | +------+----------------+-------------------------------------------+--------------------+---------+-------+---------------------------------+-------------------------+ 55 rows in set (0.00 sec) mysql> use bse_eis; 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 zipcodes\G; *************************** 1. row *************************** Table: zipcodes Create Table: CREATE TABLE `zipcodes` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `zipCode` varchar(5) DEFAULT NULL, `city` varchar(35) DEFAULT NULL, `state` varchar(2) DEFAULT NULL, `countyId` varchar(3) DEFAULT NULL, `primaryRecord` varchar(1) DEFAULT NULL, `areaCode` varchar(55) DEFAULT NULL, `cityType` varchar(1) DEFAULT NULL, `cityAliasAbbreviation` varchar(13) DEFAULT NULL, `cityAliasName` varchar(35) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_zipcodes` (`zipCode`,`city`,`state`) ) ENGINE=InnoDB AUTO_INCREMENT=80287 DEFAULT CHARSET=latin1 1 row in set (0.00 sec) ERROR: No query specified mysql> show engine innodb status\G; *************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 110721 0:52:43 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 34 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 21390 1_second, 21372 sleeps, 1996 10_second, 1472 background, 1471 flush srv_master_thread log flush and writes: 21425 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 10938, signal count 25547 Mutex spin waits 277592, rounds 461932, OS waits 3897 RW-shared spins 11853, rounds 193034, OS waits 5311 RW-excl spins 1475, rounds 62421, OS waits 1385 Spin rounds per wait: 1.66 mutex, 16.29 RW-shared, 42.32 RW-excl ------------ TRANSACTIONS ------------ Trx id counter AE102E Purge done for trx's n:o < AE0A60 undo n:o < 0 History list length 1310 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION ADFBB4, not started, process no 22803, OS thread id 139689579444496 MySQL thread id 3177, query id 4348683 lim-int1-wth-01.bluestarenergy.com 10.3.251.65 WTH_I_WTH_02 ---TRANSACTION ADFC16, not started, process no 22803, OS thread id 139689606600976 MySQL thread id 3176, query id 4352620 lim-int1-wth-01.bluestarenergy.com 10.3.251.65 WTH_I_WTH_02 ---TRANSACTION 0, not started, process no 22803, OS thread id 139689572522256 MySQL thread id 1881, query id 5287564 localhost root show engine innodb status ---TRANSACTION 0, not started, process no 22803, OS thread id 139689573320976 MySQL thread id 1803, query id 3487988 localhost root Waiting for table metadata lock truncate table zipcodes ---TRANSACTION 95DC93, not started, process no 22803, OS thread id 139689572256016 MySQL thread id 516, query id 172274 lim-int1-wthc-01.bluestarenergy.com 10.3.251.66 WTHC_I_WTHC_02 ---TRANSACTION 95EDBA, not started, process no 22803, OS thread id 139689605536016 MySQL thread id 515, query id 220011 lim-int1-wthc-01.bluestarenergy.com 10.3.251.66 WTHC_I_WTHC_02 ---TRANSACTION 95DC8B, not started, process no 22803, OS thread id 139689572788496 MySQL thread id 514, query id 172281 lim-int1-wthc-01.bluestarenergy.com 10.3.251.66 WTHC_I_WTHC_02 ---TRANSACTION 95EC98, not started, process no 22803, OS thread id 139689573054736 MySQL thread id 343, query id 214308 lim-int1-fwcb-01.bluestarenergy.com 10.3.251.70 FWCB_I_FWCB_02 ---TRANSACTION AE0F2C, not started, process no 22803, OS thread id 139689574119696 MySQL thread id 134, query id 5284134 lim-int1-b2b-01.bluestarenergy.com 10.3.251.25 B2B_I_B2B_02 ---TRANSACTION AE07D1, not started, process no 22803, OS thread id 139691440118032 MySQL thread id 207, query id 4460769 lim-int1-b2b-01.bluestarenergy.com 10.3.251.25 B2B_I_B2B_02 ---TRANSACTION AE07C5, not started, process no 22803, OS thread id 139691440384272 MySQL thread id 82, query id 4460034 lim-int1-b2bg-01.bluestarenergy.com 10.3.251.26 GISB_I_B2BG_02 ---TRANSACTION AE0FE7, not started, process no 22803, OS thread id 139689574652176 MySQL thread id 93, query id 5286788 lim-int1-b2bw-01.bluestarenergy.com 10.3.251.29 B2BW_I_B2BW_02 ---TRANSACTION AE089C, not started, process no 22803, OS thread id 139689574918416 MySQL thread id 92, query id 5043661 lim-int1-b2bw-01.bluestarenergy.com 10.3.251.29 B2BW_I_B2BW_02 ---TRANSACTION AE07CF, not started, process no 22803, OS thread id 139689575717136 MySQL thread id 89, query id 4461003 lim-int1-b2bw-01.bluestarenergy.com 10.3.251.29 B2BW_I_B2BW_02 ---TRANSACTION AE07BB, not started, process no 22803, OS thread id 139689604471056 MySQL thread id 88, query id 4459644 lim-int1-b2bw-01.bluestarenergy.com 10.3.251.29 B2BW_I_B2BW_02 ---TRANSACTION AE102B, not started, process no 22803, OS thread id 139689604737296 MySQL thread id 87, query id 5287427 lim-int1-b2bw-01.bluestarenergy.com 10.3.251.29 B2BW_I_B2BW_02 ---TRANSACTION AE0FD0, not started, process no 22803, OS thread id 139689575184656 MySQL thread id 91, query id 5286209 lim-int1-b2bw-01.bluestarenergy.com 10.3.251.29 B2BW_I_B2BW_02 ---TRANSACTION AE0FE2, not started, process no 22803, OS thread id 139689605269776 MySQL thread id 80, query id 5286670 lim-int1-b2b-01.bluestarenergy.com 10.3.251.25 B2B_I_B2B_02 ---TRANSACTION ADFC0D, not started, process no 22803, OS thread id 139689577580816 MySQL thread id 13, query id 4349274 lim-int1-acc-01.bluestarenergy.com 10.3.251.46 ACC_I_ACC_03 ---TRANSACTION AE102D, not started, process no 22803, OS thread id 139689577314576 MySQL thread id 14, query id 5287563 lim-int1-acc-01.bluestarenergy.com 10.3.251.46 ACC_I_ACC_03 ---TRANSACTION ACB670, not started, process no 22803, OS thread id 139689578379536 MySQL thread id 10, query id 3395282 lim-int1-acc-01.bluestarenergy.com 10.3.251.46 ACC_I_ACC_03 ---TRANSACTION AE0B77, ACTIVE 763 sec, process no 22803, OS thread id 139689570126096 MySQL thread id 3464, query id 5283367 lim-int1-acce-01.bluestarenergy.com 10.3.251.48 ACCE_I_ACCE_03 ---TRANSACTION ADFF73, ACTIVE 2545 sec, process no 22803, OS thread id 139689576249616 MySQL thread id 3254, query id 5273845 10.3.50.67 USR_GLB_B2B ---TRANSACTION ADF3F1, ACTIVE 4363 sec, process no 22803, OS thread id 139691440650512 MySQL thread id 3024, query id 5263342 lim-int1-acce-01.bluestarenergy.com 10.3.251.48 ACCE_I_ACCE_03 ---TRANSACTION ACB954, ACTIVE 17561 sec, process no 22803, OS thread id 139689571723536 MySQL thread id 1382, query id 3403939 lim-int1-husp-01.bluestarenergy.com 10.3.251.35 HUSP_I_HUSP_02 ---TRANSACTION 95BBAD, ACTIVE 31174 sec, process no 22803, OS thread id 139691439585552 MySQL thread id 123, query id 3297743 lim-int1-sfap-01.bluestarenergy.com 10.3.251.40 MSCP_I_SFAP_02 -------- FILE I/O -------- I/O thread 0 state: waiting for completed aio requests (insert buffer thread) I/O thread 1 state: waiting for completed aio requests (log thread) I/O thread 2 state: waiting for completed aio requests (read thread) I/O thread 3 state: waiting for completed aio requests (read thread) I/O thread 4 state: waiting for completed aio requests (read thread) I/O thread 5 state: waiting for completed aio requests (read thread) I/O thread 6 state: waiting for completed aio requests (write thread) I/O thread 7 state: waiting for completed aio requests (write thread) I/O thread 8 state: waiting for completed aio requests (write thread) I/O thread 9 state: waiting for completed aio requests (write thread) Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] , ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 679300 OS file reads, 110256 OS file writes, 59126 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 26, seg size 28, 1881 merges merged operations: insert 9082, delete mark 477, delete 182 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 2212673, node heap has 3634 buffer(s) 6.71 hash searches/s, 0.71 non-hash searches/s --- LOG --- Log sequence number 206183434842 Log flushed up to 206183434842 Last checkpoint at 206183434842 0 pending log writes, 0 pending chkp writes 54152 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 1098907648; in additional pool allocated 0 Dictionary memory allocated 10997799 Buffer pool size 65535 Free buffers 1 Database pages 61900 Old database pages 22829 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 777464, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 678344, created 4325, written 54260 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s LRU len: 61900, unzip_LRU len: 0 I/O sum[20]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 1 read views open inside InnoDB Main thread process no. 22803, id 139689589168400, state: sleeping Number of rows inserted 318311, updated 46346, deleted 47073, read 888755092 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 3.41 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ 1 row in set (0.00 sec) ERROR: No query specified