Return-Path: X-Original-To: apmail-cloudstack-issues-archive@www.apache.org Delivered-To: apmail-cloudstack-issues-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 9A8DB10B73 for ; Fri, 2 Aug 2013 10:15:51 +0000 (UTC) Received: (qmail 92100 invoked by uid 500); 2 Aug 2013 10:15:50 -0000 Delivered-To: apmail-cloudstack-issues-archive@cloudstack.apache.org Received: (qmail 92054 invoked by uid 500); 2 Aug 2013 10:15:49 -0000 Mailing-List: contact issues-help@cloudstack.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@cloudstack.apache.org Delivered-To: mailing list issues@cloudstack.apache.org Received: (qmail 92031 invoked by uid 500); 2 Aug 2013 10:15:48 -0000 Delivered-To: apmail-incubator-cloudstack-issues@incubator.apache.org Received: (qmail 92024 invoked by uid 99); 2 Aug 2013 10:15:48 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 02 Aug 2013 10:15:48 +0000 Date: Fri, 2 Aug 2013 10:15:48 +0000 (UTC) From: "Sailaja Mada (JIRA)" To: cloudstack-issues@incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Closed] (CLOUDSTACK-3729) Management Server stopped responding in a Multinode Management Setup MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/CLOUDSTACK-3729?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sailaja Mada closed CLOUDSTACK-3729. ------------------------------------ > Management Server stopped responding in a Multinode Management Setup > -------------------------------------------------------------------- > > Key: CLOUDSTACK-3729 > URL: https://issues.apache.org/jira/browse/CLOUDSTACK-3729 > Project: CloudStack > Issue Type: Bug > Security Level: Public(Anyone can view this level - this is the default.) > Components: Management Server > Affects Versions: 4.2.0 > Reporter: Sailaja Mada > Assignee: Alena Prokharchyk > Priority: Critical > Fix For: 4.2.0 > > Attachments: apilog.log, cloud-backup.dmp, management-server.log, MS2-apilog.log, MS2-management-server.log > > > Setup : Adv Configuration with VMWARE (Stadard vSwitch with 2 clusters ) & Zone wide Primary storage > Steps: > 1. Configure Multinode Management setup (MS1 & MS2) > 2. Enable agent.lb.enabled to true > 3. DB is available locally to MS1 > 4. Create new accounts and deployed VM's > Observation: > 1. Tried to access Management server (MS1/MS2 ). Both servers are very slow to respond and finally they stopped to respond > 2. Restarting Management servers also did not help here : > DB Statistics : > mysql> SHOW STATUS WHERE `variable_name` = 'Threads_connected'; > +-------------------+-------+ > | Variable_name | Value | > +-------------------+-------+ > | Threads_connected | 38 | > +-------------------+-------+ > 1 row in set (0.00 sec) > mysql> show status like '%onn%'; > +--------------------------+-------+ > | Variable_name | Value | > +--------------------------+-------+ > | Aborted_connects | 6 | > | Connections | 1461 | > | Max_used_connections | 41 | > | Ssl_client_connects | 0 | > | Ssl_connect_renegotiates | 0 | > | Ssl_finished_connects | 0 | > | Threads_connected | 38 | > +--------------------------+-------+ > 7 rows in set (0.00 sec) > [root@ec2 management]# mysqladmin -u root -ppassword processlist > +------+-------+----------------------+-------------+---------+------+-------+------------------+ > | Id | User | Host | db | Command | Time | State | Info | > +------+-------+----------------------+-------------+---------+------+-------+------------------+ > | 35 | cloud | localhost:32999 | cloud | Sleep | 708 | | | > | 40 | cloud | localhost:33004 | cloud | Sleep | 708 | | | > | 43 | cloud | localhost:33007 | cloudbridge | Sleep | 715 | | | > | 81 | cloud | localhost:33310 | cloud_usage | Sleep | 872 | | | > | 959 | cloud | 10.102.192.117:48041 | cloud | Sleep | 11 | | | > | 965 | cloud | 10.102.192.117:48049 | cloud | Query | 0 | | commit | > | 1015 | cloud | 10.102.192.117:48294 | cloud_usage | Sleep | 186 | | | > | 1406 | cloud | localhost:60220 | cloud | Sleep | 725 | | | > | 1410 | cloud | 10.102.192.117:54646 | cloud | Sleep | 93 | | | > | 1412 | cloud | 10.102.192.117:54648 | cloud | Sleep | 173 | | | > | 1413 | cloud | localhost:60352 | cloud | Sleep | 725 | | | > | 1415 | cloud | 10.102.192.117:54704 | cloud | Sleep | 133 | | | > | 1418 | cloud | localhost:60445 | cloud | Sleep | 709 | | | > | 1419 | cloud | localhost:60463 | cloud | Sleep | 853 | | | > | 1420 | cloud | localhost:60467 | cloud | Sleep | 851 | | | > | 1421 | cloud | localhost:60468 | cloud | Sleep | 820 | | | > | 1422 | cloud | 10.102.192.117:54799 | cloud | Sleep | 35 | | | > | 1423 | cloud | localhost:60472 | cloud | Sleep | 846 | | | > | 1424 | cloud | localhost:60473 | cloud | Sleep | 725 | | | > | 1425 | cloud | localhost:60474 | cloud | Sleep | 733 | | | > | 1426 | cloud | localhost:60475 | cloud | Sleep | 852 | | | > | 1427 | cloud | localhost:60476 | cloud | Sleep | 734 | | | > | 1429 | cloud | localhost:60478 | cloud | Sleep | 725 | | | > | 1430 | cloud | localhost:60479 | cloud | Sleep | 780 | | | > | 1431 | cloud | localhost:60480 | cloud | Sleep | 733 | | | > | 1432 | cloud | localhost:60481 | cloud | Sleep | 851 | | | > | 1433 | cloud | localhost:60482 | cloud | Sleep | 851 | | | > | 1434 | cloud | localhost:60483 | cloud | Sleep | 725 | | | > | 1435 | cloud | localhost:60484 | cloud | Sleep | 729 | | | > | 1436 | cloud | localhost:60485 | cloud | Sleep | 845 | | | > | 1437 | cloud | 10.102.192.117:54800 | cloud | Sleep | 2 | | | > | 1438 | cloud | localhost:60486 | cloud | Sleep | 708 | | | > | 1439 | cloud | localhost:60487 | cloud | Sleep | 733 | | | > | 1440 | cloud | localhost:60488 | cloud | Sleep | 733 | | | > | 1441 | cloud | 10.102.192.117:54850 | cloud | Sleep | 1 | | | > | 1442 | cloud | 10.102.192.117:54851 | cloud | Sleep | 13 | | | > | 1443 | cloud | 10.102.192.117:54852 | cloud | Sleep | 183 | | | > | 1445 | cloud | 10.102.192.117:55057 | cloud | Sleep | 53 | | | > | 1446 | cloud | 10.102.192.117:55058 | cloud | Sleep | 183 | | | > | 1449 | root | localhost | | Query | 0 | | show processlist | > +------+-------+----------------------+-------------+---------+------+-------+------------------+ > [root@ec2 management]# mysqladmin -u root -ppassword processlist | grep cloud | wc > 39 585 3822 > [root@ec2 management]# mysqladmin -u root -ppassword processlist | grep cloud | wc -l > 39 > [root@ec2 management]# netstat -nat | grep 3306 | grep -i ESTABLISHED > tcp 0 0 10.102.192.207:3306 10.102.192.117:48049 ESTABLISHED > tcp 0 0 127.0.0.1:3306 127.0.0.1:60476 ESTABLISHED > tcp 0 0 127.0.0.1:3306 127.0.0.1:60478 ESTABLISHED > tcp 0 0 10.102.192.207:3306 10.102.192.117:54850 ESTABLISHED > tcp 0 0 127.0.0.1:3306 127.0.0.1:60352 ESTABLISHED > tcp 0 0 127.0.0.1:3306 127.0.0.1:60220 ESTABLISHED > tcp 0 0 10.102.192.207:3306 10.102.192.117:55867 ESTABLISHED > tcp 0 0 127.0.0.1:3306 127.0.0.1:60467 ESTABLISHED > tcp 0 0 10.102.192.207:3306 10.102.192.117:55663 ESTABLISHED > tcp 0 0 127.0.0.1:3306 127.0.0.1:60486 ESTABLISHED > tcp 0 0 127.0.0.1:3306 127.0.0.1:60445 ESTABLISHED > tcp 0 0 127.0.0.1:3306 127.0.0.1:60479 ESTABLISHED > tcp 0 0 127.0.0.1:3306 127.0.0.1:60474 ESTABLISHED > tcp 0 0 10.102.192.207:3306 10.102.192.117:48041 ESTABLISHED > tcp 0 0 127.0.0.1:3306 127.0.0.1:60481 ESTABLISHED > tcp 0 0 127.0.0.1:3306 127.0.0.1:33007 ESTABLISHED > tcp 0 0 127.0.0.1:3306 127.0.0.1:33310 ESTABLISHED > tcp 0 0 127.0.0.1:3306 127.0.0.1:60488 ESTABLISHED > tcp 0 0 127.0.0.1:3306 127.0.0.1:33004 ESTABLISHED > tcp 0 0 127.0.0.1:3306 127.0.0.1:60483 ESTABLISHED > tcp 0 0 127.0.0.1:3306 127.0.0.1:60485 ESTABLISHED > tcp 0 0 10.102.192.207:3306 10.102.192.117:56272 ESTABLISHED > tcp 0 0 10.102.192.207:3306 10.102.192.117:56271 ESTABLISHED > tcp 0 0 10.102.192.207:3306 10.102.192.117:54800 ESTABLISHED > tcp 0 0 127.0.0.1:3306 127.0.0.1:60480 ESTABLISHED > tcp 0 0 127.0.0.1:3306 127.0.0.1:32999 ESTABLISHED > tcp 0 0 127.0.0.1:3306 127.0.0.1:60487 ESTABLISHED > tcp 0 0 10.102.192.207:3306 10.102.192.117:48294 ESTABLISHED > tcp 0 0 127.0.0.1:3306 127.0.0.1:60473 ESTABLISHED > tcp 0 0 127.0.0.1:3306 127.0.0.1:60472 ESTABLISHED > tcp 0 0 10.102.192.207:3306 10.102.192.117:54852 ESTABLISHED > tcp 0 0 127.0.0.1:3306 127.0.0.1:60468 ESTABLISHED > tcp 0 0 10.102.192.207:3306 10.102.192.117:56068 ESTABLISHED > tcp 0 0 127.0.0.1:3306 127.0.0.1:60484 ESTABLISHED > tcp 0 0 ::ffff:127.0.0.1:33004 ::ffff:127.0.0.1:3306 ESTABLISHED > tcp 0 0 ::ffff:127.0.0.1:60488 ::ffff:127.0.0.1:3306 ESTABLISHED > tcp 0 0 ::ffff:127.0.0.1:60467 ::ffff:127.0.0.1:3306 ESTABLISHED > tcp 0 0 ::ffff:127.0.0.1:60468 ::ffff:127.0.0.1:3306 ESTABLISHED > tcp 0 0 ::ffff:127.0.0.1:60445 ::ffff:127.0.0.1:3306 ESTABLISHED > tcp 0 0 ::ffff:127.0.0.1:60481 ::ffff:127.0.0.1:3306 ESTABLISHED > tcp 0 0 ::ffff:127.0.0.1:60352 ::ffff:127.0.0.1:3306 ESTABLISHED > tcp 0 0 ::ffff:127.0.0.1:60487 ::ffff:127.0.0.1:3306 ESTABLISHED > tcp 0 0 ::ffff:127.0.0.1:60479 ::ffff:127.0.0.1:3306 ESTABLISHED > tcp 0 0 ::ffff:127.0.0.1:33007 ::ffff:127.0.0.1:3306 ESTABLISHED > tcp 0 0 ::ffff:127.0.0.1:33310 ::ffff:127.0.0.1:3306 ESTABLISHED > tcp 0 0 ::ffff:127.0.0.1:60484 ::ffff:127.0.0.1:3306 ESTABLISHED > tcp 0 0 ::ffff:127.0.0.1:60472 ::ffff:127.0.0.1:3306 ESTABLISHED > tcp 0 0 ::ffff:127.0.0.1:60474 ::ffff:127.0.0.1:3306 ESTABLISHED > tcp 0 0 ::ffff:127.0.0.1:60485 ::ffff:127.0.0.1:3306 ESTABLISHED > tcp 0 0 ::ffff:127.0.0.1:60476 ::ffff:127.0.0.1:3306 ESTABLISHED > tcp 0 0 ::ffff:127.0.0.1:32999 ::ffff:127.0.0.1:3306 ESTABLISHED > tcp 0 0 ::ffff:127.0.0.1:60220 ::ffff:127.0.0.1:3306 ESTABLISHED > tcp 0 0 ::ffff:127.0.0.1:60483 ::ffff:127.0.0.1:3306 ESTABLISHED > tcp 0 0 ::ffff:127.0.0.1:60473 ::ffff:127.0.0.1:3306 ESTABLISHED > tcp 0 0 ::ffff:127.0.0.1:60486 ::ffff:127.0.0.1:3306 ESTABLISHED > tcp 0 0 ::ffff:127.0.0.1:60478 ::ffff:127.0.0.1:3306 ESTABLISHED > tcp 0 0 ::ffff:127.0.0.1:60480 ::ffff:127.0.0.1:3306 ESTABLISHED > [root@ec2 management]# netstat -nat | grep 3306 | grep -i ESTABLISHED | wc -l > 57 > [root@ec2 management]# > Cloud process statistics : > [root@ec2 management]# top -p 3323 > top - 13:50:58 up 4 days, 16 min, 5 users, load average: 26.92, 28.20, 15.50 > Tasks: 1 total, 0 running, 1 sleeping, 0 stopped, 0 zombie > Cpu(s): 6.1%us, 3.0%sy, 0.0%ni, 0.0%id, 85.9%wa, 2.3%hi, 2.7%si, 0.0%st > Mem: 785484k total, 727832k used, 57652k free, 1968k buffers > Swap: 1572856k total, 1335760k used, 237096k free, 15088k cached > PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND > 3323 cloud 20 0 5038m 375m 2500 S 11.7 48.9 105:08.63 java > Mysqld : > top - 13:52:17 up 4 days, 17 min, 5 users, load average: 15.43, 24.26, 15.16 > Tasks: 1 total, 0 running, 1 sleeping, 0 stopped, 0 zombie > Cpu(s): 1.4%us, 0.8%sy, 0.0%ni, 92.4%id, 4.0%wa, 0.9%hi, 0.3%si, 0.0%st > Mem: 785484k total, 741076k used, 44408k free, 2972k buffers > Swap: 1572856k total, 1333312k used, 239544k free, 15716k cached > PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND > 2357 mysql 20 0 692m 32m 3188 S 1.8 4.2 98:57.49 mysqld > mysql> SHOW ENGINE INNODB STATUS\G ; > *************************** 1. row *************************** > Type: InnoDB > Name: > Status: > ===================================== > 130723 13:57:58 INNODB MONITOR OUTPUT > ===================================== > Per second averages calculated from the last 7 seconds > ---------- > SEMAPHORES > ---------- > OS WAIT ARRAY INFO: reservation count 39333, signal count 38645 > Mutex spin waits 0, rounds 81686, OS waits 3537 > RW-shared spins 68861, OS waits 34420; RW-excl spins 1443, OS waits 1376 > ------------------------ > LATEST FOREIGN KEY ERROR > ------------------------ > 130719 13:50:13 Error in dropping of a foreign key constraint of table "cloud"."baremetal_pxe_devices", > in SQL command > ALTER TABLE baremetal_pxe_devices DROP FOREIGN KEY fk_external_pxe_devices_physical_network_id > Cannot find a constraint with the given id "fk_external_pxe_devices_physical_network_id". > ------------ > TRANSACTIONS > ------------ > Trx id counter 0 3618750 > Purge done for trx's n:o < 0 3618480 undo n:o < 0 0 > History list length 39 > LIST OF TRANSACTIONS FOR EACH SESSION: > ---TRANSACTION 0 3618620, not started, process no 2357, OS thread id 140486500669184 > MySQL thread id 1472, query id 18528732 localhost 127.0.0.1 cloud > ---TRANSACTION 0 3618579, not started, process no 2357, OS thread id 140486496405248 > MySQL thread id 1470, query id 18528479 localhost 127.0.0.1 cloud > ---TRANSACTION 0 3618577, not started, process no 2357, OS thread id 140486495872768 > MySQL thread id 1473, query id 18528477 localhost 127.0.0.1 cloud > ---TRANSACTION 0 3618562, not started, process no 2357, OS thread id 140486499071744 > MySQL thread id 1469, query id 18528390 localhost 127.0.0.1 cloud > ---TRANSACTION 0 3618538, not started, process no 2357, OS thread id 140486837835520 > MySQL thread id 1471, query id 18528255 localhost 127.0.0.1 cloud > ---TRANSACTION 0 0, not started, process no 2357, OS thread id 140486495606528 > MySQL thread id 1474, query id 18529490 localhost root > SHOW ENGINE INNODB STATUS > ---TRANSACTION 0 3618625, not started, process no 2357, OS thread id 140486498539264 > MySQL thread id 1468, query id 18528753 localhost 127.0.0.1 cloud > ---TRANSACTION 0 3618703, not started, process no 2357, OS thread id 140486496671488 > MySQL thread id 1466, query id 18529253 localhost 127.0.0.1 cloud > ---TRANSACTION 0 3618610, not started, process no 2357, OS thread id 140486704576256 > MySQL thread id 1467, query id 18528674 localhost 127.0.0.1 cloud > ---TRANSACTION 0 3618745, not started, process no 2357, OS thread id 140486498006784 > MySQL thread id 1465, query id 18529466 localhost 127.0.0.1 cloud > ---TRANSACTION 0 3618714, not started, process no 2357, OS thread id 140486500402944 > MySQL thread id 1463, query id 18529300 localhost 127.0.0.1 cloud > ---TRANSACTION 0 3618532, not started, process no 2357, OS thread id 140486499870464 > MySQL thread id 1462, query id 18528224 10.102.192.117 cloud > ---TRANSACTION 0 3618410, not started, process no 2357, OS thread id 140486498805504 > MySQL thread id 1461, query id 18527587 10.102.192.117 cloud > ---TRANSACTION 0 3618526, not started, process no 2357, OS thread id 140486839965440 > MySQL thread id 1459, query id 18528175 10.102.192.117 cloud > ---TRANSACTION 0 3618568, not started, process no 2357, OS thread id 140486704043776 > MySQL thread id 1458, query id 18528404 10.102.192.117 cloud > ---TRANSACTION 0 3618411, not started, process no 2357, OS thread id 140486838101760 > MySQL thread id 1457, query id 18527578 10.102.192.117 cloud > ---TRANSACTION 0 3618158, not started, process no 2357, OS thread id 140486496941824 > MySQL thread id 1439, query id 18527968 localhost 127.0.0.1 cloud > ---TRANSACTION 0 3618735, not started, process no 2357, OS thread id 140486839432960 > MySQL thread id 1440, query id 18529427 localhost 127.0.0.1 cloud > ---TRANSACTION 0 3618632, not started, process no 2357, OS thread id 140486499604224 > MySQL thread id 1436, query id 18528788 localhost 127.0.0.1 cloud > ---TRANSACTION 0 3618739, not started, process no 2357, OS thread id 140486500935424 > MySQL thread id 1427, query id 18529442 localhost 127.0.0.1 cloud > ---TRANSACTION 0 3618570, not started, process no 2357, OS thread id 140486499337984 > MySQL thread id 1431, query id 18528424 localhost 127.0.0.1 cloud > ---TRANSACTION 0 3618336, not started, process no 2357, OS thread id 140486497474304 > MySQL thread id 1434, query id 18529306 localhost 127.0.0.1 cloud > ---TRANSACTION 0 3618695, not started, process no 2357, OS thread id 140486839699200 > MySQL thread id 1429, query id 18529332 localhost 127.0.0.1 cloud > ---TRANSACTION 0 3618700, not started, process no 2357, OS thread id 140486497740544 > MySQL thread id 1435, query id 18529247 localhost 127.0.0.1 cloud > ---TRANSACTION 0 3618618, not started, process no 2357, OS thread id 140486498273024 > MySQL thread id 1432, query id 18528728 localhost 127.0.0.1 cloud > ---TRANSACTION 0 3618635, not started, process no 2357, OS thread id 140486501201664 > MySQL thread id 1430, query id 18528805 localhost 127.0.0.1 cloud > ---TRANSACTION 0 3618749, not started, process no 2357, OS thread id 140486838634240 > MySQL thread id 1437, query id 18529489 10.102.192.117 cloud > ---TRANSACTION 0 3618697, not started, process no 2357, OS thread id 140486837569280 > MySQL thread id 1424, query id 18529234 localhost 127.0.0.1 cloud > ---TRANSACTION 0 3618740, not started, process no 2357, OS thread id 140486497208064 > MySQL thread id 1425, query id 18529446 localhost 127.0.0.1 cloud > ---TRANSACTION 0 3618629, not started, process no 2357, OS thread id 140486703245056 > MySQL thread id 1423, query id 18528782 localhost 127.0.0.1 cloud > ---TRANSACTION 0 3618539, not started, process no 2357, OS thread id 140486496139008 > MySQL thread id 1421, query id 18528251 localhost 127.0.0.1 cloud > ---TRANSACTION 0 3618699, not started, process no 2357, OS thread id 140486838368000 > MySQL thread id 1420, query id 18529246 localhost 127.0.0.1 cloud > ---TRANSACTION 0 3602499, not started, process no 2357, OS thread id 140486840497920 > MySQL thread id 1418, query id 18508239 localhost 127.0.0.1 cloud > ---TRANSACTION 0 3618607, not started, process no 2357, OS thread id 140486702978816 > MySQL thread id 1413, query id 18528671 localhost 127.0.0.1 cloud > ---TRANSACTION 0 3618715, not started, process no 2357, OS thread id 140486838900480 > MySQL thread id 1406, query id 18529311 localhost 127.0.0.1 cloud > ---TRANSACTION 0 3616468, not started, process no 2357, OS thread id 140486703777536 > MySQL thread id 1015, query id 18516644 10.102.192.117 cloud > ---TRANSACTION 0 2505627, not started, process no 2357, OS thread id 140486837036800 > MySQL thread id 959, query id 18528771 10.102.192.117 cloud > ---TRANSACTION 0 3615045, not started, process no 2357, OS thread id 140486837303040 > MySQL thread id 81, query id 18508421 localhost 127.0.0.1 cloud > ---TRANSACTION 0 3613913, not started, process no 2357, OS thread id 140486704310016 > MySQL thread id 43, query id 18502143 localhost 127.0.0.1 cloud > ---TRANSACTION 0 7638, not started, process no 2357, OS thread id 140486840231680 > MySQL thread id 35, query id 18527805 localhost 127.0.0.1 cloud > ---TRANSACTION 0 3618746, COMMITTED IN MEMORY, process no 2357, OS thread id 140486500136704 committing > , undo log entries 1 > MySQL thread id 965, query id 18529471 10.102.192.117 cloud > commit > ---TRANSACTION 0 3618741, COMMITTED IN MEMORY, process no 2357, OS thread id 140486839166720 committing > , undo log entries 1 > MySQL thread id 40, query id 18529451 localhost 127.0.0.1 cloud > commit > ---TRANSACTION 0 3618565, ACTIVE 5 sec, process no 2357, OS thread id 140486703511296 > MySQL thread id 1438, query id 18529295 localhost 127.0.0.1 cloud > -------- > FILE I/O > -------- > I/O thread 0 state: waiting for i/o request (insert buffer thread) > I/O thread 1 state: waiting for i/o request (log thread) > I/O thread 2 state: waiting for i/o request (read thread) > I/O thread 3 state: waiting for i/o request (write thread) > Pending normal aio reads: 0, aio writes: 0, > ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 > Pending flushes (fsync) log: 1; buffer pool: 0 > 3945 OS file reads, 1095705 OS file writes, 759430 OS fsyncs > 0.00 reads/s, 0 avg bytes/read, 0.71 writes/s, 0.71 fsyncs/s > ------------------------------------- > INSERT BUFFER AND ADAPTIVE HASH INDEX > ------------------------------------- > Ibuf: size 1, free list len 0, seg size 2, > 18 inserts, 18 merged recs, 8 merges > Hash table size 17393, node heap has 4 buffer(s) > 46.99 hash searches/s, 88.27 non-hash searches/s > --- > LOG > --- > Log sequence number 0 189051814 > Log flushed up to 0 189051218 > Last checkpoint at 0 189043028 > 1 pending log writes, 0 pending chkp writes > 622265 log i/o's done, 0.71 log i/o's/second > ---------------------- > BUFFER POOL AND MEMORY > ---------------------- > Total memory allocated 25657658; in additional pool allocated 1048320 > Dictionary memory allocated 2388320 > Buffer pool size 512 > Free buffers 1 > Database pages 507 > Modified db pages 9 > Pending reads 0 > Pending writes: LRU 0, flush list 0, single page 0 > Pages read 4232, created 1244, written 442699 > 0.00 reads/s, 0.00 creates/s, 0.00 writes/s > Buffer pool hit rate 1000 / 1000 > -------------- > ROW OPERATIONS > -------------- > 0 queries inside InnoDB, 0 queries in queue > 1 read views open inside InnoDB > Main thread process no. 2357, id 140486717187840, state: flushing log > Number of rows inserted 5365, updated 545505, deleted 464, read 11099941 > 0.00 inserts/s, 3.29 updates/s, 0.00 deletes/s, 80.13 reads/s > ---------------------------- > END OF INNODB MONITOR OUTPUT > ============================ > 1 row in set (0.26 sec) > ERROR: > No query specified -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira