![]() T12:57:29.171455Z 0 Forcefully disconnecting 1 remaining clients T12:57:27.170952Z 0 Giving 1 client threads a chance to die gracefully (flushed=0 and evicted=8004, during the time (flushed=0 and evicted=8192, during the time (flushed=0 and evicted=7932, during the time I don't see anything interesting in the mysql.log, but I'm gonna dump my error.log in case I've missed something. The query its running ALTER TABLE tx_out2ĭROP COLUMN indexOut, DROP COLUMN scriptPubKey +-+-+Ĭount of records mysql> select count(*) from tx_out2 ![]() Table structure mysql> show create table tx_out2 I'm using the default config file, except I have updated innodb-buffer-pool-size = 54G since my system has 64GB RAM. It sat like this for over an hour, then I cancelled the query and tried it again, now its been stuck at the same point for a while. ![]() After creating a (journal?) file called something similar to #sql-ib43-1640985772.ibd, which grows to about the same size as the table, the file sizes stop changing and nothing seems to be happening, even though I still see high CPU and disk writes about 10MB/s from mysqld, though absolutely 0B/s in reads. I'm trying to drop a few columns from a fairly large table in my database (about 110GB) and it seems like the server is freezing. (crosspost from here after being advised this is not a programming question) ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |