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
InnoDB
tables. -
Stop the server.
-
Remove all the existing tablespace files, including the
ibdata
andib_log
files. 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
.frm
files forInnoDB
tables. -
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 ...
the ammonia uptake and nitrate uptake phases were marked by a decreasing pH trend and an increasing pH trend, respectively. Further, we find the product yield per unit carbon substrate to be greatly ...
cache entries may become stale, thus decreasing the freshness of served results. In this work, we first argue that the real problem in today’s caching for large-scale search engines is not eviction ...
The decreasing hardware cost and, therefore, the increasing de- ployment of cameras have opened a wide application field for video analytics. Several monitoring objectives such as congestion, traffic ...
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 ...
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 second part of the thesis is dedicated to decreasing the simulation time. The most computationally complex part of the simulator is offloaded to an FPGAbased hardware accelerator by using hardware...
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 ...
It has the following advantages: managing science, improving utilization rate of the equipment and decreasing the work force of administrative personnel. This paper introduces the design of the ...
increasing size and decreasing detail, centred around the viewpoint. We implemented the geometry clipmaps algorithm, and present aspects of our implementation, such as the maximum number of clipmap ...
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 ...
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, ...
by aggressively decreasing the number of system processes that run as root. In addition to these exploit mitigations, recent versions of Android have introduced major new security features such as ...
performance and decreasing price of embedded processors are opening many doors for developers to design highly sophisticated solutions for different end applications. The complexities of these systems...
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 ...
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 ...