In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-01-28 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)05/31 Report--
This article mainly explains "what to do when MySQL fails to start after adding skip-innodb". Interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn "what if MySQL fails to start after adding skip-innodb"!
On VPS with small memory, children's shoes (including me) generally like to do the so-called "optimization". In the optimization for MySQL, there are three parameters:
Skip-innodb / skip-bdb / skip-locking
In particular, the first parameter is said to save memory after opening it, so I filled in these three parameters in my.cnf after installing MySQL, but unfortunately, in the subsequent service mysqld restart, the startup failed. Is that all right?! So I hurriedly asked Google for advice, but sadly, under the current situation of "copying articles all over the world" on the domestic Internet, it was not easy to find an accurate answer through personal practice, and my problem was not solved in the end.
Later, I thought of taking a look at my MySQL version. I found a skip-external-locking parameter in my.cnf at the same time. After consulting Google, I learned that skip-external-locking is the new version of skip-locking,skip-locking. Moreover, in the new version of MySQL, the parameter skip-bdb has been abolished! At this point, the problem is basically solved. Now that skip-locking has changed, maybe skip-innodb has changed too! Finally, I found this sentence in the MySQLd document:
If InnoDB hasn't been built,the option-skip-innodb isn't available. We prefix with 'loose'to allow the option to be used at all times.
At this point, I believe you have a deeper understanding of "what to do when MySQL fails to start after adding skip-innodb". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!
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.
Views: 218
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
What is a Wait Event? During the normal functioning of a database, an Oracle process will occasional
© 2024 shulou.com SLNews company. All rights reserved.