Hello,
First, sorry the lengthy post. I have a couple of questions that are very
important for me to get answered. I we moved from using MS Access to MySQL
for our Point of Sale app. We do the transaction rollbacks, commits in the
application layer so the fact that MySQL lacks this functionality is no
problem especially when compared to the speed that we get from the DB.
We would very much like to run MySQL on a Linux box, but when our customers
(many lack even basic Windows skills) hear the word Linux, they run for
cover. They obviosly don't know how stable it is, only that Windows gives
them a nice fuzzy warm feeling. So, we are deploying the Windows Version
of MySQL running on Win2K Prof or Server depending on how many POS stations
will be hitting the DB. We're using MyODBC to talk to the server with ADO
from VB60 apps running on Win98 Clients.
Last night, I had a customer whose DB went down and got very corrupted.
It's only got 128 MB RAM on it and in addition to running the MySQL NT
service, it's spooling a lot of print jobs to remote receipt printers for
the kitchen/bar, etc and running the Credit Card Payment software too. I
warned them that I thought 128 MB RAM was not enough and that is my guess
as to why it went down (plus the server had not been rebooted in about a
week).
At any rate, I have 2 very important questions that I really need to get
answered and am grateful for any responses.
# 1:
Considering that we have an average of 3-5 clients hitting the database
with SELECTS, INSERTS and UPDATES sometimes pretty heavily, would 256 MB
RAM suffice on a LAN?
# 2:
What, if any, parameters should I setup in the MySQL server for maximum
efficiency?
# 3:
If we start the MySQL server with update logging, I see the files that it
creates each time it is started. In the case of a crash, how would I go
about restoring the database from the logs on Win2K? I've looked in the
manual, but don't quite understand the syntax to do this or even if it's
the same for Windows. Could someone please give me the Romper Room level
lowdown on doing that?
Again, I don't look forward to having another all-nighter like last night
so I would be very, very grateful for help on these things. I like MySQL
and the support found here in the list and very much want to keep using it.
Again, thank you in advance.
Lee
