It's a good idea to run tests using the same database you're using in production, but MySQL ain't exactly a speed demon compared to memory-backed databases like Hypersonic, H2 or even Derby.
But wait - we can have our cake and eat it, too!
The trick is to tell MySQL to store its data files in memory; more specifically, the InnoDB files should be stored on a memory-backed filesystem like tmpfs.
So, create a directory somewhere (I use /var/lib/mysql/innodb) and mount tmpfs on it (
mount -t tmpfs none /var/lib/mysql/innodb
, or set it up in /etc/fstab).After that, tell MySQL to store the InnoDB files there by sticking the following lines in /etc/mysql/my.cnf:
innodb_data_home_dir=/var/lib/mysql/innodb innodb_log_group_home_dir=/var/lib/mysql/innodb
Now restart MySQL, and run your now-speedier tests!
72 comments:
Nice idea, do you have any figures on the actual speedup that you achieved?
It's not really scientific, but for one set of database-bound integration tests total runtime for the test set went from 48 to 31 seconds; that's a speedup of ~35%.
Great idea, thanks! The "tests" for the project I'm working on (Mifos) are also insanely database-intensive, and I was able to reduce test time by placing MySQL data on a tmpfs partition.
This was a very good thing and it is also a very interesting blog. I like your great post, Thanks for giving the valuable post. Do well!!!
Oracle DBA Training in Chennai
Oracle DBA Course in Chennai
Excel Training in Chennai
Oracle Training in Chennai
Spark Training in Chennai
Tableau Training in Chennai
Embedded System Course Chennai
Unix Training in Chennai
Oracle DBA Training in OMR
This post is really nice and informative. The explanation given is really comprehensive and informative..
Web Designing Course Training in Chennai | Web Designing Course Training in annanagar | Web Designing Course Training in omr | Web Designing Course Training in porur | Web Designing Course Training in tambaram | Web Designing Course Training in velachery
Awesome article with top quality information and found very interesting looking forward for next blog thank you.
Data Science Course in Hyderabad 360DigiTMG
Top quality blog with very informative information found very useful thanks for sharing and hopping for some more informative posts.
Data Analytics Course Online
I will very much appreciate the writer's choice for choosing this excellent article suitable for my topic. Here is a detailed description of the topic of the article that helped me the most. PMP Training in Hyderabad
Great article with valuable information found very resourceful and enjoyed reading it waiting for next blog updated thanks for sharing.
typeerror nonetype object is not subscriptable
I want to thank you for your efforts in writing this article. I look forward to the same best job from you in the future. PMP Certification in Hyderabad
Nice Information Your first-class knowledge of this great job can become a suitable foundation for these people. I did some research on the subject and found that almost everyone will agree with your blog.
Cyber Security Course in Bangalore
Writing in style and getting good compliments on the article is hard enough, to be honest, but you did it so calmly and with such a great feeling and got the job done. This item is owned with style and I give it a nice compliment. Better!
Cyber Security Training in Bangalore
I will very much appreciate the writer's choice for choosing this excellent article suitable for my topic. Here is a detailed description of the topic of the article that helped me the most.
unindent does not match any outer indentation level
I'm glad I found this blog! Occasionally, students want to know the keys to writing productive literary essays. Your first-class knowledge of this great job can become a suitable foundation for these people. Good
unindent does not match any outer indentation level python
Im really impressed by it.I am happy for sharing on this blog its awesome blog I really impressed. thanks for sharing. Great efforts. data science training
I've read this post and if I could I desire to suggest you some interesting things or suggestions. Perhaps you could write next articles referring to this article. I want to read more things about it!
data science training
I have to search sites with relevant information ,This is a
wonderful blog,These type of blog keeps the users interest in
the website, i am impressed. thank you.
Data Science Course in Bangalore
I have to search sites with relevant information ,This is a
wonderful blog,These type of blog keeps the users interest in
the website, i am impressed. thank you.
Data Science Training in Bangalore
Aivivu mua vé máy bay, tham khảo
vé máy bay đi Mỹ hạng thương gia
ve may bay tu my ve vietnam
vé giá rẻ đi đà nẵng
vé máy bay đi đà lạt bao nhiêu tiền
đặt vé máy bay phú quốc
i am glad to discover this page : i have to thank you for the time i spent on this especially great reading !! i really liked each part and also bookmarked you for new information on your site.
data science training in bangalore
Nice to be visiting your blog again, it has been months for me. Well this article that i've been waited for so long. I need this article to complete my assignment in the college, and it has same topic with your article. Thanks, great share.
เว็บแทงบอล
ufabet
ufa
พวงหรีด
โควิด
บาคาร่า
This article is increasing the interest to learn more about this topic. Continue sharing your new updates, regularly for my future.
คาสิโนออนไลน์
ufabet
ufa
เว็บบอล
relx
Movie-watching websites that are more than movie-watching websites Because we are the number 1 free movie site in Thailand for a long time, including new movies, Thai movies, Western movies, Asian movies, we have all kinds of ways for you Including new series Full of all stories without interstitial ads to keep annoying anymore. One place sa-movie.com.
Android and IOS operating systems. Watch online movies, Thai movies, Western movies, Asian movies, Cartoon movies, Netflix Movie, Action Movies, Comedy Movies, Crime Movies, Drama Movies, Horror Movies, Adventure Movies, Crash Movies and still have many new movies to watch. You can watch for free anytime, anywhere 24 hours a day at see4k.com.
GangManga read manga, read manga, read manga online for free, fast loading, clear images in HD quality, all titles, anywhere, anytime, on mobile, tablet, computer. Android and IOS operating systems. Read top comics, action dramas, comedy, adventure, horror and manga. New coming every day to watch many more. Can be read for free anytime anywhere 24 hours a day at gangmanga.com..
It is no secret that football is among the most popular and widely watched sports. Everybody who likes football tries to find the best platform for free soccer streaming. So, what are the best free sports streaming sites? We are going to answer this question. On this page, you can find a detailed overview of the most widespread soccer streaming websites. Keep on reading and make the best choice for you live24th.me.
The content is well acknowledged, so no one could allege that it is just one person's opinion yet it covers and justifies all the applicable points. I have read such a startling work after a long time!
Data Science Training in Hyderabad
Data Science Course in Hyderabad
Thanks for posting the best information and the blog is very helpful
Python Training in Hyderabad
Python Course in Hyderabad
Thanks for sharing an informative post. Keep on sharing such useful information.
UiPath Training In Bangalore | UiPath Online Training
AS400 Training In Bangalore | AS400 Online Training
Docker and Kubernetes Training In Bangalore | Docker and Kubernetes Online Training
Go Language Training In Bangalore | Go Language Online Training
Oracle Apps Technical Training In Bangalore | Oracle Apps Technical Online Training
UI UX Design Training In Bangalore | UI UX Design Online Training
Pyspark Training In Bangalore | Pyspark Online Training
React Native and Redux Training In Bangalore | API Online Training
Adobe Sitecatalyst Training In Bangalore | Adobe Sitecatalyst Online Training
Python with Django Training In Bangalore | Python with Django Online Training
great article!! sharing these type of articles is the nice one and i hope you will share an article on data science.By giving a institute like 360DigiTMG.it is one the best institute for doing certified courses
data science malaysia
I want to leave a little comment to support and wish you the best of luck.we wish you the best of luck in all your blogging enedevors.
data science in bangalore
With special privileges and services, UEFA BET offers opportunities for small capitalists. Together ufa with the best websites that collect the most games With a minimum deposit starting from just 100 baht, you are ready to enjoy the fun with a complete range of betting that is available within the website
ufabet , our one another option We are a direct website, not through an agent, where customers can have great confidence without deception The best of online betting sites is that our Ufa will give you the best price
หาคุณกำลังหาเกมส์ออนไลน์ที่สามารถสร้างรายได้ให้กับคุณ เรามีเกมส์แนะนำ เกมยิงปลา รูปแบบใหม่เล่นง่ายบนมือถือ คาสิโนออนไลน์ บนคอม เล่นได้ทุกอุปกรณ์รองรับทุกเครื่องมือ มีให้เลือกเล่นหลายเกมส์ เล่นได้ทั่วโลกเพราะนี้คือเกมส์ออนไลน์แบบใหม่ เกมยิงปลา
อีกทั้งเรายังให้บริการ เกมสล็อต ยิงปลา แทงบอลออนไลน์ รองรับทุกการใช้งานในอุปกรณ์ต่าง ๆ HTML5 คอมพิวเตอร์ แท็บเล็ต สมาทโฟน คาสิโนออนไลน์ และมือถือทุกรุ่น เล่นได้ตลอด 24ชม. ไม่ต้อง Downloads เกมส์ให้ยุ่งยาก ด้วยระบบที่เสถียรที่สุดในประเทศไทย
Amazing blog.Thanks for sharing such excellent information with us. keep sharing...
machine learning course in aurangabad
Wonderful blog. I delighted in perusing your articles. This is genuinely an incredible perused for me. I have bookmarked it and I am anticipating perusing new articles. Keep doing awesome!
best machine learning course in aurangabad
Probably the most genuine football betting UFABET that's beyond description Find fun, excitement and excitement with slot video games, hundred totally free recognition, quick withdrawal. If you desire to have fun slots for money No need to deposit a great deal, no minimum, no need to share, squander moment for the reason that UFABET is in fact reduced, given seriously, many great offers are waiting for you. Prepared to ensure pleasurable, regardless of whether it's Joker SlotXo fruit slot, we are able to phone it an internet slot website for you personally especially. Ready to have fun Like the support staff which is going to facilitate slot formulas as well as techniques of actively playing So you will be certain that each minute of fun and pleasure We will be there for one to give your customers the best appearance as well as fulfillment.
บาคาร่า
สล็อต
ufa
แทงบอล
Excellent Blog! I would like to thank for the efforts you have made in writing this post. I am hoping the same best work from you in the future as well. I wanted to thank you for this websites! Thanks for sharing. Great websites!
data scientist course in pune
Hi, Thanks for sharing huge content...
Python Training in Hyderabad
I am impressed by the information that you have on this blog. It shows how well you understand this subject.
digital marketing courses in hyderabad with placement
Great post! I am actually getting ready to across this information, It’s very helpful for this blog. Also great with all of the valuable information you have Keep up the good work you are doing well.
DevOps Training in Hyderabad
DevOps Course in Hyderabad
Great tips and very easy to understand. This will definitely be very useful for me when I get a chance to start my blog.
data scientist certification malaysia
Your blogs are amazing and I am glad to read them. Thanks for sharing.
AWS Training in Hyderabad
AWS Course in Hyderabad
This blog was really great, never seen a great blog like this before. I think I’m going to share this to my friends.
Data Science Training in Hyderabad
Data Science Course in Hyderabad
I was basically inspecting through the web filtering for certain data and ran over your blog. I am flabbergasted by the data that you have on this blog. It shows how well you welcome this subject. Bookmarked this page, will return for extra. data science course in jaipur
Really impressed! Everything is very open and very clear clarification of issues. It contains truly facts. Your website is very valuable. Thanks for sharing.
data science training
Extremely overall quite fascinating post. I was searching for this sort of data and delighted in perusing this one. Continue posting. A debt of gratitude is in order for sharing. data scientist course in delhi
Informative blog
best digital marketing institute in hyderabad
I am impressed by the information that you have on this blog. It shows how well you understand this subject.
data science course
Informative blog
ai training in hyderabad
I want to leave a little comment to support and wish you the best of luck.we wish you the best of luck in all your blogging enedevors.
iot training in hyderabad
Informative blog
Cloud Computing in hyderabad
I am browsing the website daily, and get good facts from here all the time... visa required for Turkey, the visa fee depends on how quickly you want to process your application. Here you can read all the details about Turkey visa eligibility rules, visa exemption guidelines, passenger locator form & visa fees. Visit Turkey evisa portal.
Informative blog
Data science course in pune
Very awesome!!! When I seek for this I found this website at the top of all blogs in search engine.
data science training
Thanks for posting the best information and the blog is very good.Cloud Computing course in Bangalore
Extraordinary post I should state and a debt of gratitude is in order for the data. Instruction is unquestionably a clingy subject. Be that as it may, is still among the main subjects within recent memory. I value your post and anticipate more.cyber security course in lucknow
A good blog always contains new and exciting information and as I read it I felt that this blog really has all of these qualities that make a blog. data scientist course in lucknow
Thanks for sharing this information. I really like your blog post very much. You have really shared a informative and interesting blog post .
data scientist course in malaysia
Nice article thank you for this. Check the Kenya visa requirements before you apply for the Kenya visa through online visa application. The e visa application offers the fast visa services. Thank you
Great article this is really informative and innovative: with new updates. with new updates. It was really valuable. Thanks a lot. Travelers can easily apply for Indian visa online. The Government of India has provided an easy-to-use method to apply for an Indian Visa.
Thanks for sharing this information, Keep it up.... South Africa tourist visa, The Government of South Africa has confirmed that South Africa's new e-Visa system will be implemented for 15 countries by March 2022.
Really nice and interesting post. I was looking for this kind of information and enjoyed reading this one.
full stack development course
I can't believe I've never been to this site before, but after going through some of the posts I realized it's new to me. Anyhow, I'm glad I found it and I'll be bookmarking and checking back often. You can fill your visa application form online within 5 to 10 minutes and pay your India visa cost once you complete the form. India evisa cost depends on your nationality and your visa type. cost of Indian visas are always submitted after form submission.
Hi! I thought I had been to this site before, but after looking through some of the posts, I realized it was new to me. Anyway, I'm glad I found it and I'll definitely be bookmarking it and checking back often. You can fill your visa application form online within 5 to 10 minutes and pay your India visa cost once you complete the form. India evisa cost depends on your nationality and your visa type. The cost of Indian visas is always credited after the submission of the form.
I want to leave a little comment to support and wish you the best of luck.we wish you the best of luck in all your blogging enedevors
data analytics course in varanasi
I want to leave a little comment to support and wish you the best of luck.we wish you the best of luck in all your blogging enedevors
data science course in varanasi
Thanks for your great article which is both informative and innovative: with the latest updates. It was highly invaluable. Travelers have the question: can US citizen travel to India? The answer is yes. You can apply directly for e-visas online. Therefore, the Indian government has developed an easy-to-use online Indian visa application form that makes it easy to apply for a visa.
Borgata Hotel Casino & Spa - JTR Hub
Located in Atlantic City, 토토 사이트 모음 Borgata Hotel Casino & Spa offers 출장마사지 the finest in amenities and entertainment. It also https://vannienailor4166blog.blogspot.com/ provides a seasonal 토토 사이트 outdoor swimming www.jtmhub.com
Hello all , Many people ask, What is the Indian visa photo size? You can get more info about India visa photo size via our Indian e page.
Informative blog
business analytics course in ludhiana
Hello everyone! Amazing post! Many people ask, ``How to apply for a e visa Turkey?Eligible travelers only need a good internet connection and a computer, laptop or tablet to complete and submit a visa application.
เล่นเกมต่างๆได้อย่างรวดเร็วทันใด สมัครPG ทำกำไรได้อย่างมากมายผ่านเว็บไซต์ PGSLOTGAMES เล่นได้อย่างมากมาย ทั้งสล็อตออนไลน์ คาสิโนออนไลน์ อาเขต และยิงปลา ทำกำไรได้ตลอด 24 ชั่วโมง
เล่นได้ ไม่ผิดหวัง บริการทุกๆท่านให้ได้เล่นมากมายกว่า 300 เกม กับเว็บไซต์ PGSLOTGAMES เล่นต่างๆได้ตลอด 24 ชั่วโมง มอบประสบการณ์การเล่นสุดแปลกใหม่ PG SLOT AUTO รวมไปถึงกิจกรรมต่างๆ ให้คุณได้สนุกสนานไปกับการปั่นสล็อต พร้อมรับเครดิตให้คุณได้ทำการเล่นมากถึง 70 เปอร์เซนต์
Helpful time saver
Your article is easy to read and understand. I would like to read more articles like this. Getting an e visa Turkey online is a hassle free process. It saves time and money as well.
I am also a specialist in this topic so I can understand your effort.Keep it up. Keep blogging. Looking to reading your next post.Very interesting to read this article.Actually Magnificent.
electric masturbator cup
water based lubricant.
Post a Comment