Shulou(Shulou.com)05/31 Report--

Editor to share with you how to configure MySQL's BDB table on Red Hat 7.0. I believe most people don't know much about it, so share this article for your reference. I hope you will gain a lot after reading this article. Let's learn about it together.

MySQL configure the BDB table on Red Hat 7. 0 [@ more@] Note: this article is still in the Beta version!

One of the biggest misunderstandings about MySQL is the transaction capabilities of MySQL.

The BDB table type has been supported since MySQL 3.23, but BDB support needs to be compiled first, while compilation on Red Hat 7.0has always been a problem. It just seems to be compiled successfully.

> show table status

It also shows that the table type is BDB, but if you use the begin statement to define the transaction, the next rollback statement cannot roll back the transaction.

The conclusion drawn by the author in practice is that it is necessary to install the db*devel.rpm package in RH7.0. We know that the versions of RPM 4 and above use the latest BDB db3 format to store the package information, and the BDB database package is related to these software on some library functions. Therefore, we suspect that this problem is related to the package related to BDB in RH7. Sure enough, after we installed db1-devel.rpm and db3-devel.rpm, recompiled MySQL, and the transaction was normal.

First compile BDB (the downloaded version is db3.2.9h.tar.gz on the MySQL website, the software package downloaded directly from the Berkeyley DB website cannot be used, and there will be errors when compiling MySQL):

Cd build-unix

.. / dist/configure

Make

Make install

Then compile MySQL:

/ configure-- prefix=/usr/local/mysql-- with-berkeley-db=/usr/local/BerkeyleyDB3.2-- with-tcp-port=9999-- withmysqld-user=mysql-- with-charset=gb2312-- with-extra-charsets=latin1

It is important to note that MySQL has built-in BDB since 3.23.35, so we can omit the previous process of compiling BDB, but we need to change the-- with-berkeley-db part to:

-- with-berkeley-db=./bdb

At the same time, starting from this release, Innobase, another database type that supports transaction processing, is also supported. All we have to do is specify in my.cnf:

..

You can use a database of type innobase.

From the configuration process, it looks like a large database such as Sybase.

It seems that MySQL will go further in terms of function.

The above is all the contents of the article "how to configure the BDB table of MySQL on Red Hat 7.0. thank you for reading!" I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.