On Wednesday, March 20, 2013 7:59:23 PM UTC-7, Razvan Musaloiu-E. wrote:
--May I ask what was the issue? :P-- Razvan MEOn Wed, Mar 20, 2013 at 6:47 PM, Carl Schroeder <schroede...@gmail.com> wrote:
I think I have it sorted, thanks for the help. ;)
On Wednesday, March 20, 2013 6:37:00 PM UTC-7, Carl Schroeder wrote:--Process list shows 3 sleeping processes.===================================== 130321 1:33:37 INNODB MONITOR OUTPUT===================================== Per second averages calculated from the last 50 seconds-----------------BACKGROUND THREAD-----------------srv_master_thread loops: 444 1_second, 444 sleeps, 40 10_second, 44 background, 44 flushsrv_master_thread log flush and writes: 446----------SEMAPHORES----------OS WAIT ARRAY INFO: reservation count 40, signal count 40Mutex spin waits 33, rounds 96, OS waits 0RW-shared spins 40, rounds 1200, OS waits 40RW-excl spins 0, rounds 0, OS waits 0Spin rounds per wait: 2.91 mutex, 30.00 RW-shared, 0.00 RW-excl------------TRANSACTIONS------------Trx id counter BFF5APurge done for trx's n:o < BFF5A undo n:o < 0History list length 2388LIST OF TRANSACTIONS FOR EACH SESSION:---TRANSACTION 0, not startedMySQL thread id 56, OS thread handle 0x7f8303f4e700, query id 737 localhost rootSHOW ENGINE INNODB STATUS---TRANSACTION BFF58, not startedMySQL thread id 52, OS thread handle 0x7f8304011700, query id 712 localhost root---TRANSACTION BFF56, not startedMySQL thread id 51, OS thread handle 0x7f8303d36700, query id 705 localhost root---TRANSACTION BFF54, not startedMySQL thread id 50, OS thread handle 0x7f8303d77700, query id 698 localhost root---TRANSACTION BFF52, not startedMySQL thread id 49, OS thread handle 0x7f8303e3a700, query id 691 localhost root---TRANSACTION BFF50, not startedMySQL thread id 48, OS thread handle 0x7f8303df9700, query id 684 localhost root---TRANSACTION BFF4E, not startedMySQL thread id 47, OS thread handle 0x7f8303bb0700, query id 677 localhost root---TRANSACTION BFF4C, not startedMySQL thread id 46, OS thread handle 0x7f8303db8700, query id 670 localhost root---TRANSACTION BFF4A, not startedMySQL thread id 45, OS thread handle 0x7f8303c73700, query id 662 localhost root---TRANSACTION BFF48, not startedMySQL thread id 44, OS thread handle 0x7f8303c32700, query id 655 localhost root---TRANSACTION BFF46, not startedMySQL thread id 43, OS thread handle 0x7f8303cf5700, query id 648 localhost root---TRANSACTION BFF44, not startedMySQL thread id 42, OS thread handle 0x7f8303bf1700, query id 641 localhost root---TRANSACTION BFF42, not startedMySQL thread id 41, OS thread handle 0x7f8303e8b700, query id 634 localhost root---TRANSACTION BFF40, not startedMySQL thread id 40, OS thread handle 0x7f8303ecc700, query id 627 localhost root---TRANSACTION BFF36, not startedMySQL thread id 35, OS thread handle 0x7f8304052700, query id 740 localhost root--------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 (read thread)I/O thread 4 state: waiting for i/o request (read thread)I/O thread 5 state: waiting for i/o request (read thread)I/O thread 6 state: waiting for i/o request (write thread)I/O thread 7 state: waiting for i/o request (write thread)I/O thread 8 state: waiting for i/o request (write thread)I/O thread 9 state: waiting for i/o request (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: 0Pending flushes (fsync) log: 0; buffer pool: 0395 OS file reads, 201 OS file writes, 123 OS fsyncs0.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 0, seg size 2, 0 mergesmerged operations:insert 0, delete mark 0, delete 0discarded operations:insert 0, delete mark 0, delete 0Hash table size 796937, node heap has 1 buffer(s)0.00 hash searches/s, 0.00 non-hash searches/s---LOG---Log sequence number 3752258Log flushed up to 3752258Last checkpoint at 37522580 pending log writes, 0 pending chkp writes89 log i/o's done, 0.00 log i/o's/second----------------------BUFFER POOL AND MEMORY----------------------Total memory allocated 415236096; in additional pool allocated 0Dictionary memory allocated 43152Buffer pool size 24575Free buffers 24190Database pages 384Old database pages 0Modified db pages 0Pending reads 0Pending writes: LRU 0, flush list 0, single page 0Pages made young 0, not young 00.00 youngs/s, 0.00 non-youngs/sPages read 384, created 0, written 1210.00 reads/s, 0.00 creates/s, 0.00 writes/sNo buffer pool page gets since the last printoutPages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/sLRU len: 384, unzip_LRU len: 0I/O sum[0]:cur[0], unzip sum[0]:cur[0]--------------ROW OPERATIONS--------------0 queries inside InnoDB, 0 queries in queue1 read views open inside InnoDBMain thread id 140200693815040, state: waiting for server activityNumber of rows inserted 1, updated 40, deleted 0, read 5310.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s----------------------------END OF INNODB MONITOR OUTPUT============================
On Wednesday, March 20, 2013 6:26:27 PM UTC-7, Razvan Musaloiu-E. wrote:I don't see anything unusual with your instance. Are you doing any queries that grab the same locks? Can you investigate using SHOW PROCESSLIST and SHOW ENGINE INNODB STATUS using the command line tool?-- Razvan MEOn Wed, Mar 20, 2013 at 6:17 PM, Carl Schroeder <schroede...@gmail.com> wrote:
lemurspot-project:lemur-prime is the instance name
On Wednesday, March 20, 2013 5:57:51 PM UTC-7, Razvan Musaloiu-E. wrote:Can you tell us your instance name?-- Razvan MEOn Wed, Mar 20, 2013 at 5:48 PM, Carl Schroeder wrote:
Error 1205: Lock wait timeout exceeded; try restarting transactionJust started getting these this afternoon. This is in the Google APIs console "SQL Prompt" window on deletes and updates.I am 82MB into my 100GB limit.Using python from app engine fails silently when trying to update. Very distressing.Anyone have any ideas?--
--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com .
For more options, visit https://groups.google.com/groups/opt_out .
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com .
For more options, visit https://groups.google.com/groups/opt_out .
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
No comments:
Post a Comment