Shulou(Shulou.com)06/01 Report--

How big is the query database setting in MYSQL, how much is the remaining space (transfer) [@ more@] how to query the database setting in MYSQL, and how much is the remaining space? Can you find out from the table? engine is innodb.

Innodb is based on the concept of space, for example, in my.cnf, innodb_data_file_path = ibdata1:10M means to use a 10MB-sized disk file ibdata1 as the space for innodb, then N innodb tables are created in this space. If this space is full, the operation of the innodb table fails, even if you have a lot of remaining space on other disks.

So you can set this up a little bit, or you can set up several file spaces. The last file is usually followed by: autoextend parameter to indicate that the file size can be automatically expanded.

If you want to see how much space is left, you can show table status like the 'your InnoDB Datasheet name' G command in mysql. How much will there be in the end?

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.