使用外部硬盘写入和存储 mysql 数据库 [英] Using an external HD to write to and store a mysql Database

问题描述

我已经设置了 mysql 数据库在我的 Mac 上使用 java 和 eclipse 运行，它运行得很好，但现在我将生成大约 43 亿行数据，这些数据将占用大约 64GB 的数据，我正在存储一个大数据关于密钥和加密值，我有一个 1TB 的外部我想用作存储位置，我首先想我可以将 mysql 重新安装到外部，但没有运气，因为它显然没有运行 mac osx，无论如何我可以指出mysql 在外部存储数据库，我已经进行了一些搜索，但还没有找到答案.

I have set up mysql database to run with java and eclipse on my Mac, it is running great, but now I will generate aprox 4.3billion rows of data which will take up approx 64gbs of data, I'm storing a large about of keys and encrypted values, I have a 1TB external i would like to use as a storage location, i first thought i could reinstall mysql onto the external but it no luck as it obviously isnt running mac osx, Is there anyway i Can point mysql to store a database on the external, i have done some searching but have not come across an answer yet.

我正在运行 Java 来构建和查询数据库和表，如果这起作用的话.

I am running Java to build and query the databse and Table if this comes into play.

谢谢.

推荐答案

找到您的 mysql 配置文件(通常称为 my.cnf).更改数据库路径.

Find your mysql config file (typically called my.cnf). Change the database path.

http://dev.mysql.com/tech-resources/文章/mysql_intro.html#SECTION0001500000

这篇关于使用外部硬盘写入和存储 mysql 数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！