新的mysql要求 [英] New to mysql requirements

问题描述

我是mysql数据库的新手，我在microsoft sql server上工作了很长时间，但在ms sql server中，免费数据库限制为10GB，我现在正在医院的一个需要保存数据的项目上工作比如（10）年。我听说mysql是无限的，或者至少达到了2TB的免费数据库大小等等。第一个问题：这是真的吗？我想直接回答一下，c＃WinFormsApp使用的mysql数据库大小（免费）的最大值是多少？第二：在ms sql server我需要设置sqlserver express和sql server管理工作室（数据库设计环境）并在客户端pc上设置sqlserver express。怎么样的mysql？我需要在开发者电脑上设置什么以及在客户端电脑上设置什么？



我尝试了什么：



当我搜索mysql时发现了很多让我迷失的标题，下载Mysql安装程序，下载Mysql服务器，下载Mysql工作台，下载Mysql Connectors。我想知道我需要在开发者电脑（我的电脑）上下载什么以及在客户端电脑上安装什么来运行我的程序，例如当我在医院电脑上设置我的应用程序时，数据库要求或引擎是什么必须安装？

I'm new to mysql databases ,i worked on microsoft sql server for long time but in ms sql server the free database is limited to 10GB, and i working now on a project of a hospital that needs to save the data up to (10) years for example. and i heard that mysql is unlimited or at least reaches a 2TB free database size and more. first question: is that true? i want a direct answer please, what is the maximum of mysql database size(free) that used by a c# WinFormsApp? second: in ms sql server i need to setup the sqlserver express and sql server management studio(database design environment) and setup sqlserver express only on the client pc. what about mysql? what i need to setup on developer pc and what to setup on the clients pc?

What I have tried:

when i searched for mysql i found a lot of titles that made me lost, download Mysql installer, download Mysql server, download Mysql workbench, download Mysql Connectors. i want to know what exactly i need to download on the developer pc(my pc) and what to install on the client pc to run my program for example when i setup my application on the hospital PCs, what is the database requirements or engines that must be installed?

推荐答案

好像，你回答了你的第一个问题...

MySql Server和MS Sql Server的比较在这里： Microsoft SQL Server与MySQL比较 [ ^ ]

排名：

Seems, you answered your first question...
A comparision of MySql Server and MS Sql Server is here: Microsoft SQL Server vs. MySQL Comparison[^]
Ranking:

Rank	DBMS			Database Model		Score
1.		Oracle 			Relational DBMS		1341.94	
2.		MySQL 			Relational DBMS		1299.71	
3.		MS SQL Server 	Relational DBMS		1148.07	

至于其他人......

As to the others...

Quote：

我想知道我需要在开发者电脑（我的电脑）上下载什么以及在客户端电脑上安装什么来运行我的程序

i want to know what exactly i need to download on the developer pc(my pc) and what to install on the client pc to run my program

1. MySQL服务器 [ ^ ]

2. MySQL连接器之一[ ^ ]

1. MySQL Server[^]
2. one of MySQL connectors[^]

引用：

必须安装的数据库要求或引擎是什么？

what is the database requirements or engines that must be installed?

与上面相同，但是MySQL服务器应该安装一次并连接到每个工作站（客户端）上的独立可执行应用程序。

The same as above, but MySQL server should be installed once and connector with your standalone executable application on every workstation (client).

如果这是一个真正的医院，然后他们需要支付适当的健壮和支持的数据库系统。 Microsoft SQL服务器将是一个更好的选择。并与经验丰富的数据库设计师一起帮助你。

If this is a real hospital then they need to pay for a proper robust and supported database system. Microsoft SQL server would be a much better choice. And get together with an experienced database designer to help you.

引用：

我想直接回答请问，ac＃WinFormsApp使用的mysql数据库大小（免费）的最大值是多少？

i want a direct answer please, what is the maximum of mysql database size(free) that used by a c# WinFormsApp?

根据MySQL 5.7参考手册附录C.10 [ ^ ]，

Quote：

MySQL的有效最大表大小数据库通常由文件大小的操作系统约束决定，而不是由MySQL内部限制决定。

The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal limits.

这意味着在Windows 8或更高版本上，单个表的大小最多可达256TB，数据库的总大小仅受磁盘容量的限制。

This means that a single table can be up to 256TB in size on Windows 8 or later, the total size of a database is only limited by disk capacity.

这篇关于新的mysql要求的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！