Decreasing the Size of the InnoDB Tablespace
Currently, you cannot remove a data file from the tablespace. To decrease the size of your tablespace, use this procedure:
-
Use mysqldump to dump all your
InnoDBtables. -
Stop the server.
-
Remove all the existing tablespace files, including the
ibdataandib_logfiles. If you want to keep a backup copy of the information, then copy all theib*files to another location before the removing the files in your MySQL installation. -
Remove any
.frmfiles forInnoDBtables. -
Configure a new tablespace.
-
Restart the server.
-
Import the dump files.
相关推荐
Table of Contents ...Increasing and decreasing the size of a cluster 15 Combining sharding and replication 17 Various sharding solutions 18 PostgreSQL-based sharding 19 Summary 19 www.allitebooks.
The environmental perturbation on atoms is a key factor restricting the performance of atomic frequency standards, especially in the long-term scale. In this Letter, we perform a real-time noise ...
Robert lays out 24 patterns of thought and design that tend to produce faster, more reliable, and easier to maintain code without noticeably increasing the difficulty or decreasing the speed of coding...
The test results and analysis indicate that this algorithm has a great advantage in the aspects of decreasing EMS memory consumption and improving calculation accuracy, and its computational ...
Decreasing "obscene" language of behaviorally disordered children through the use of a DRL schedule DECREASING “OBSCENE” LANGUAGE OF BEHAVIORALLY DISORDERED CHILDREN THROUGH THE USE OF A DRL ...
The median of two sequences is defined to be the median of the non-decreasing sequence which contains all the elements of both sequences. For example, the median of S1 and S2 is 13. Given two ...
to the inherent complexity of the domain and accidental complexity of the low-level tools provided by modern operating systems. The Boost.Asio library is aimed at reducing accidental complexity by ...
* decrease / decline / drop / fall：表示数量的减少趋势，例如：“The number of students has been decreasing over the past few years.” * dip：表示数量的突然减少，例如：“The number of students dipped ...
The postoperative ICP in the early surgery group showed a trend of slowly increasing and then decreasing, with higher values on the 3rd and 5th days after surgery compared to the 1st day, reaching ...
The mobile internet traffic is surging, while the ARPU is flat or even decreasing slowly, which impacts the ability to build out the networks and offer services in a timely fashion.. To maintain ...
Causes the next filter in the chain to be invoked, or if the calling filter is the last filter in the chain, causes the resource at the end of the chain to be invoked. doFilter(ServletRequest, ...
Moreover, the decreasing cost and increasing sophistication of hardware and software opens up the possibility of deploying a large number of devices or systems to solve real-world problems. Each one ...
the archived file, and the offset of the first difference is reported. The decompressor requires as much memory as was used to compress. There is no option. It is not possible to add, remove, or ...
ing management is a systematic process, involving multi-department and multi-platform collaboration, reflecting the overall progress of various project phases. The issue of progress runs through the ...
locations in order of decreasing saliency. The system breaks down the complex problem of scene understanding by rapidly selecting, in a computationally efficient manner, conspicuous locations to be ...
Inductance Principle #3: When the Number of Field Line Loops Around a Conductor Changes, There Will Be a Voltage Induced Across the Ends of the Conductor Section 6.6. Partial Inductance Section 6.7. ...
Given \( \theta \geq \max(D) \), the likelihood function is decreasing with respect to \( \theta \), and thus the maximum likelihood estimate of \( \theta \) is the maximum value in the dataset: ...
This can be done by increasing the width, but also by decreasing the height. Both will make the movie 'more landscape' giving long tags more room. = Some characters are not showing up = Because of ...
"Introduction to Algorithms, the 'bible' of the field, is a comprehensive textbook covering the full spectrum of modern algorithms: from the fastest algorithms and data structures to polynomial-time ...