We can do drop table but it takes long time
mysql> DROP table erp;We should enable innodb file per table in my.cnf first
innodb_file_per_table = 1The reason that make delete table slow is because we have large .ibd file
ls -l /data/mysql/mytest/
-rw-r----- 1 mysql mysql 9023 8 18 05:21 erp.frm
-rw-r----- 1 mysql mysql 2356792000512 8 18 05:21 erp.ibd1.Create a hard link to ibd file
ln /data/mysql/mytest/erp.ibd /data/mysql/mytest/erp.ibd.hdlk
ls -l /data/mysql/mytest/
-rw-r----- 1 mysql mysql 9023 8 18 05:21 erp.frm
-rw-r----- 2 mysql mysql 2356792000512 8 18 05:21 erp.ibd
-rw-r----- 2 mysql mysql 2356792000512 8 18 05:21 erp.ibd.hdlk 2.Now we can drop table
mysql> drop table erp;
Query OK, 0 rows affected (0.99 sec)3.Remove the real file erp.ibd.hdlk on OS
We could directly do rm on it but it cost high disk I/O
alternatively, we could use TRUNCATE
#!/bin/bash
TRUNCATE=/usr/local/bin/truncate
for i in `seq 2194 -10 10 `;
do
sleep 2
$TRUNCATE -s ${i}G /data/mysql/mytest/erp.ibd.hdlk
done
rm -rf /data/mysql/mytest/erp.ibd.hdlk ;
cialis 5mg prix http://andere.strikingly.com/
This is nicely said. .
cialis 5mg prix https://gpefy8.wixsite.com/pharmacy/post/optimal-frequency-setting-of-metro-services-within-the-age-of-covid-19-distancing-measures
Amazing quite a lot of amazing data.
tadalafil 5mg https://telegra.ph/How-Has-The-COVID-19-Pandemic-Changed-Our-Lives-Globally-02-24
You’ve made the point.
cialis uk https://kertvbs.webgarden.com/
Incredible loads of valuable material.
cialis generico https://kernyusa.estranky.sk/clanky/risk-factors-linked-to-anxiety-disorders-differ-between-women-and-men-during-the-pandemic.html
Superb info. Thanks.
northwest pharmacy canada https://weruybsd.fireblogz.com/39575666/four-issues-to-do-immediately-about-online-pharmacies
Nicely put. Thanks.
buy viagra online usa https://keuybc.estranky.sk/clanky/30-facts-you-must-know–a-covid-cribsheet.html
Beneficial knowledge. Kudos!
tadalafil tablets https://gwertvb.mystrikingly.com/
Whoa plenty of valuable knowledge!
cialis from canada https://telegra.ph/Is-It-Safe-To-Lift-COVID-19-Travel-Bans-04-06
Appreciate it. Quite a lot of material.
cialis 20mg https://graph.org/The-Way-To-Get-Health-Care-At-Home-During-COVID-19—Health–Fitness-04-07
Awesome data. Kudos.
cialis 20mg https://chubo3.wixsite.com/canadian-pharmacy/post/what-parents-must-find-out-about-kids-and-covid-19
Whoa a good deal of beneficial knowledge!
cialis canadian pharmacy https://canadian-pharmacies0.yolasite.com/
Thanks a lot! I like this.
tadalafil tablets https://pharmacy-online.yolasite.com/
With thanks. An abundance of forum posts.
buy generic cialis https://kevasw.webgarden.com/
You actually revealed it very well.
Canadian Pharmacy USA https://62553dced4718.site123.me/
Nicely put. Appreciate it.
prescriptions from canada without https://seketu.gonevis.com/high-10-tips-with-order-medicine-online-1/
This is nicely put! !
cialis tablets https://site128620615.fo.team/
Wonderful content, Cheers!
cialis online https://625a9a98d5fa7.site123.me/blog/age-dependence-of-healthcare-interventions-for-covid-19-in-ontario-canada
You mentioned that adequately.
top rated online canadian pharmacies https://hernswe.gonevis.com/scientists-model-true-prevalence-of-covid-19-throughout-pandemic/
Good facts. Cheers!
tadalafil 20mg https://selomns.gonevis.com/a-modified-age-structured-sir-model-for-covid-19-type-viruses/
Nicely put. Thanks!
cialis tablets https://fwervs.gumroad.com/
You have made your point quite clearly.!
purchasing cialis on the internet https://trosorin.mystrikingly.com/
Really a good deal of superb material.
cialis 20mg https://sasnd0.wixsite.com/cialis/post/impotent-victims-can-now-cheer-up-try-generic-tadalafil-men-health
You actually explained that perfectly!
cialis 5mg prix https://626106aa4da69.site123.me/blog/new-step-by-step-roadmap-for-tadalafil-5mg
With thanks! Good information.
generic for cialis https://generic-cialis-20-mg.yolasite.com/
Kudos! I enjoy it!
cialis generico online https://hsoybn.estranky.sk/clanky/tadalafil-from-india-vs-brand-cialis—sexual-health.html
Wonderful forum posts. Thanks a lot.
online cialis https://skuvsbs.gonevis.com/when-tadalafil-5mg-competitors-is-good/
Kudos! I like this.
tadalafil without a doctor’s prescription https://hemuyrt.livejournal.com/325.html
Nicely put, Kudos.
tadalafil https://site373681070.fo.team/
Amazing all kinds of great facts!
cialis without a doctor’s prescription https://sehytv.wordpress.com/
Thanks a lot. I appreciate this.
no 1 canadian pharcharmy online https://ghswed.wordpress.com/2022/04/27/he-final-word-information-to-online-pharmacies/
Seriously many of wonderful advice.
top rated online canadian pharmacies https://kerbgsw.mystrikingly.com/
Reliable data. Appreciate it!
Cialis tadalafil https://kuebser.estranky.sk/clanky/supereasy-methods-to-study-every-part-about-online-medicine-order-discount.html
Nicely put, With thanks!
buy generic cialis https://kewertyn.wordpress.com/2022/04/27/expect-more-virtual-house-calls-out-of-your-doctor-thanks-to-telehealth-revolution/
Appreciate it. Loads of stuff.
cialis 5 mg https://kerbiss.wordpress.com/2022/04/27/14/
Nicely put. Many thanks.
cialis without a doctor’s prescription https://heswcxc.wordpress.com/2022/04/30/online-medicine-tablets-shopping-promotion-one-hundred-and-one/
Incredible all kinds of helpful data!
prescriptions from canada without https://sernert.estranky.sk/clanky/confidential-information-on-online-pharmacies.html
Regards. I like it!
tadalafil 10 mg https://kertubs.mystrikingly.com/
Nicely put, Thanks!
cialis lowest price https://626f977eb31c9.site123.me/blog/how-google-is-changing-how-we-approach-online-order-medicine-1
Seriously loads of excellent data!
medication without a doctors prescription https://canadian-pharmaceuticals-online.yolasite.com/
Nicely put, With thanks.
cialis tablets https://online-pharmacies0.yolasite.com/
You suggested that effectively.
canada pharmacy https://6270e49a4db60.site123.me/blog/the-untold-secret-to-mastering-aspirin-in-just-7-days-1
With thanks! Loads of knowledge!
cialis prices https://deiun.flazio.com/
Wow all kinds of good knowledge.
canada viagra https://kertyun.flazio.com/
Very good facts. Appreciate it!
cialis 5mg https://kerntyas.gonevis.com/the-mafia-guide-to-online-pharmacies/
Kudos! I appreciate it.
online prescriptions without a doctor https://kerbnt.flazio.com/
Kudos! Plenty of posts.
generic cialis http://nanos.jp/jmp?url=http://cialisonlinei.com/
Many thanks. I like this!
tadalafil generic http://ime.nu/cialisonlinei.com
Regards! I value this.
cialis without a doctor’s prescription https://womed7.wixsite.com/pharmacy-online/post/new-ideas-into-canada-pharmacies-never-before-revealed
This is nicely said! .
Canadian Pharmacy USA https://kerntyast.flazio.com/
With thanks, I enjoy this!