![]() T12:57:35.879979Z 0 Shutting down plugin 'PERFORMANCE_SCHEMA' T12:57:35.879867Z 0 InnoDB: Removed temporary tablespace data file: "ibtmp1" T12:57:29.288209Z 0 InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool T12:57:29.186491Z 0 Shutting down plugin 'INNODB_BUFFER_POOL_STATS' T12:57:29.186473Z 0 Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' ![]() T12:57:29.186430Z 0 Shutting down plugin 'INNODB_SYS_TABLESTATS' T12:57:29.186367Z 0 Shutting down plugin 'INNODB_SYS_TABLESPACES' 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. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |