MySQL ODBC Connector - Advice Required

Author

Advice Required

Vinayak Mahadevan

2005-09-27, 7:23 am

I am creating an application in Visual Basic 6.0 which will require a
centralised database server. All this while I had been planning to use
MS-Access. But then I found out that MS-Access is ok to be a desktop
rdbms but not for an enterprise level rdbms. So I am planning to use
MySQL as the backend for the application. What should be the minimum
system requirement to run the database on.

Regards
Vinayak

--
Vinayak Mahadevan
Systems Engineer
Magtorq Pvt. Ltd.
58-C, Sipcot Industrial Complex
Hosur - 635-126
Mobile: 98 94 90 61 61

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Sujay Koduri

2005-09-27, 7:23 am

What are specifications of your DB. How much of data you have. How mant
transactions you will be getting daily.
Without these details it will be difficult to answer ur question.

But for a centralised database server, I guess 1G RAM and 2CPU will be a
good configuration to start with.

sujay

-----Original Message-----
From: Vinayak Mahadevan & #91;mailto:vmd@magto
rq.org]
Sent: Tuesday, September 27, 2005 9:25 AM
To: mysql@lists.mysql.com
Subject: Advice Required

I am creating an application in Visual Basic 6.0 which will require a
centralised database server. All this while I had been planning to use
MS-Access. But then I found out that MS-Access is ok to be a desktop rdbms
but not for an enterprise level rdbms. So I am planning to use MySQL as the
backend for the application. What should be the minimum system requirement
to run the database on.

Regards
Vinayak

--
Vinayak Mahadevan
Systems Engineer
Magtorq Pvt. Ltd.
58-C, Sipcot Industrial Complex
Hosur - 635-126
Mobile: 98 94 90 61 61

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=sujayk@andale.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Alec.Cawley@Quantel.Com

2005-09-27, 7:23 am

Vinayak Mahadevan <vmd@magtorq.org> wrote on 27/09/2005 04:55:13:

> I am creating an application in Visual Basic 6.0 which will require a
> centralised database server. All this while I had been planning to use
> MS-Access. But then I found out that MS-Access is ok to be a desktop
> rdbms but not for an enterprise level rdbms. So I am planning to use
> MySQL as the backend for the application. What should be the minimum
> system requirement to run the database on.

MySQL can run on almost nothing. The question is not what system you need,
but what performance you want. I think you *could* run MySQL on a P200,
Win 98, 128Mb ram, 40Mb disc. But the performance you would get would be
seriously disappointing.

You need to think what size of database you want, how many queries and
updates per second you will need, and how complex your queries will be.

However, since MySQL is freely available, why not just download it,
install it on your development machine, and run a few tests. The only real
measurement of performance is actual tests: predictions often err, both
high and low.

Alec

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Vinayak Mahadevan

2005-09-27, 7:23 am

Alec.Cawley@Quantel.Com wrote:

>Vinayak Mahadevan <vmd@magtorq.org> wrote on 27/09/2005 04:55:13:
>
>
>
>
>MySQL can run on almost nothing. The question is not what system you need,
>but what performance you want. I think you *could* run MySQL on a P200,
>Win 98, 128Mb ram, 40Mb disc. But the performance you would get would be
>seriously disappointing.
>
>You need to think what size of database you want, how many queries and
>updates per second you will need, and how complex your queries will be.
>
>
>
>
>
>
>
>
Thanks for the response
I am planning to run it on a x205 series IBM Server which right now has
256 mb ram but will be upgraded to 1 gb. And the maximum number of
connections at any point of time will be say around 10

Regards
Vinayak

--
Vinayak Mahadevan
Systems Engineer
Magtorq Pvt. Ltd.
58-C, Sipcot Industrial Complex
Hosur - 635-126
Mobile: 98 94 90 61 61

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Alec.Cawley@Quantel.Com

2005-09-27, 7:23 am

Vinayak Mahadevan <vmd@magtorq.org> wrote on 27/09/2005 11:28:51:

> Alec.Cawley@Quantel.Com wrote:
>
[color=darkred]
need,[color=darkred]

[color=darkred]
be[color=darkred]
> Thanks for the response
> I am planning to run it on a x205 series IBM Server which right now has
> 256 mb ram but will be upgraded to 1 gb. And the maximum number of
> connections at any point of time will be say around 10

That sounds reasonably competent hardware. But it is not the number of
connections that matters, it is the number and complexity of queries. One
connection can generate a massive query which will lock out others; idle
connections consume a small amount of memory but no other resources.

I can only suggest you try to set up a representative test load and see if
the performance is adequate for you. If performance is not adequate, after
having examined your slow queries carefully and checked your indexing,
extra ram is the first hardware upgrade to do. However, I think newcomers
to MySQL are frequently surprised by its performance once properly
indexed; don't spend money on extra ram until you have tried out a real
(or simulated) test.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Sponsored Links