On 08/19/2014 11:00 AM, sqlite-users-requ...@sqlite.org wrote:
10. Re: Long time to drop tables. (Jonathan Moules)
12. Re: Long time to drop tables. (Simon Slavin)
----------------------------------------------------------------------
Long time for me too!
This was run on an 11.7GB database where the dropped table is about 50%
of total size. CPU is AMD AM3+ X4 4.2Ghz
sqlite> select count(*) from fvall;
count(*)
----------
6524250
CPU Time: user 0.248015 sys 13.084817
sqlite> pragma auto_vacuum;
auto_vacuum
-----------
0
CPU Time: user 0.000000 sys 0.000000
sqlite> drop table fvall;
While running...
top - 20:51:16 up 11 days, 10:58, 2 users, load average: 1.97, 1.10, 0.62
Tasks: 178 total, 2 running, 175 sleeping, 0 stopped, 1 zombie
Cpu0 : 0.7%us, 5.3%sy, 0.0%ni, 90.1%id, 3.8%wa, 0.0%hi, 0.1%si,
0.0%st
Cpu1 : 0.8%us, 2.1%sy, 0.0%ni, 93.8%id, 3.2%wa, 0.0%hi, 0.0%si,
0.0%st
Cpu2 : 0.8%us, 3.2%sy, 0.0%ni, 90.9%id, 4.9%wa, 0.0%hi, 0.2%si,
0.0%st
Cpu3 : 2.2%us, 8.7%sy, 0.0%ni, 50.8%id, 36.7%wa, 0.0%hi, 1.6%si,
0.0%st
Mem: 4031760k total, 3911436k used, 120324k free, 160704k buffers
Swap: 3664892k total, 57932k used, 3606960k free, 2657068k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
10400 gelmjw 20 0 41064 6580 1876 D 22 0.2 0:34.91 sqlite3
10430 root 20 0 0 0 0 S 1 0.0 0:00.26 kworker/0:0
Sure looks I/O bound. Why so much I/O?
CPU Time: user 13.744859 sys 79.016938
What is the above in milliseconds of real time?
sqlite>
voyager finviz # hdparm -t /dev/sda
/dev/sda:
Timing buffered disk reads: 582 MB in 3.01 seconds = 193.48 MB/sec
voyager finviz # hdparm -t /dev/sda
/dev/sda:
Timing buffered disk reads: 584 MB in 3.00 seconds = 194.49 MB/sec
voyager finviz # hdparm -t /dev/sda
/dev/sda:
Timing buffered disk reads: 582 MB in 3.01 seconds = 193.53 MB/sec
voyager finviz #
Is my disk slow?
John Gelm
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
