I have a NAS installed MySQL with/from OptWare.

It works in some way ok, but now and then it goes down, both MySQL and
the NAS, no web, no SSH, no telnet, no sql.

Just power off the nas or i rare cases I have to disconnect the power,
not even reset button works.

Any idear about where this MySQL put log files ?

Had some try to upgrade the OptWare installed MySQL to version 5.0 and
maybe then up to present 5.2 ?

I just have ont database on then MySQL, and only one table, and the
table has a record with only one entery, a decimal number.

I fill in a lot of records (millions) with numbers between 1 and 10.
I can some times fill in more than 10 millinon record before it frezz
other times just som hundred.

This kind of use of a databse should not be a reason for stability
problems ? I can understand preformance problems.


/Hans

On Mon, 20 Sep 2010 19:18:54 +0400, Hans Kjaergaard wrote:
I would not expect MySQL to be causing problems to a NAS sufficient to
make the entire NAS fall over. Is the MySQL *server* code installed over
there, or is the server code running on a machine using the NAS for
storage? To be brutally honest, I would not try to run anything except
file service software on a NAS device, and would put the database on a
real server. The NAS is a fine place to put backups.

--
51. If one of my dungeon guards begins expressing concern over the
conditions in the beautiful princess' cell, I will immediately
transfer him to a less people-oriented position.
--Peter Anspach's list of things to do as an Evil Overlord

Hans Kjaergaard <hans.k2teknik (AT) post5 (DOT) tele.dk> wrote:
Do you mean NAS as in "a smallist box that exports a disk to the
network" and there is a MySQL running on it?

Could be anything. Hot candidate would be: running out of memory.

Depends on configuration. You should check the MySQL error log:

mysql> SHOW VARIABLES LIKE 'log_error';

Default is $DATADIR/$HOSTNAME.err

mysql> SHOW VARIABLES LIKE 'datadir';

There is no 5.2. Next version after 5.0 is 5.1, then 5.5.

Certainly not. But on small computer like cheap NASes you may hit
some resource bottleneck rather soon.


XL

On Mon, 20 Sep 2010 15:55:03 GMT, "Peter H. Coffin"
<hellsop (AT) ninehells (DOT) com> wrote:


to "pay" for stability on that cost.

I need to find a way to make my MySQL server more stabel on the cost
of preformance.
I think there must be some settings to do so.

I notist mysqld --safe-mode, and flush tables, maybe something to try
?


/Hans

On Tue, 21 Sep 2010 16:58:06 +0400, Hans Kjaergaard wrote:
The way to increase the stability for the application, though, is to
give the server a reasonable amount of resources to work with, so it can
return results promptly.

--safe-mode turns off some optimization options. It doesn't mean the
server uses less RAM. (For reference, my installation mostly manages
metadata for a picture gallery. Not exactly a stressful situation. It
uses about 75MB normally, and peaks at about 120MB of memory and swap.
Most NAS boxes have less than that for *the whole system*)

--
32. I will not fly into a rage and kill a messenger who brings me bad
news just to illustrate how evil I really am. Good messengers are
hard to come by.
--Peter Anspach's list of things to do as an Evil Overlord

On Tue, 21 Sep 2010 18:55:03 GMT, "Peter H. Coffin"
<hellsop (AT) ninehells (DOT) com> wrote:

that is present ?


When I look at the NAS resources when the sql server is reciving all I
can put into it, the use af ram is 7%, nothing to worry for I think ?

More interesting is to know when the use of ram is biggest, do it
depend om complex SELECT statements or something else ?


/Hans

On Mon, 20 Sep 2010 20:11:18 +0200, Axel Schwenke
<axel.schwenke (AT) gmx (DOT) de> wrote:


to get in contact when things go wrong, so nothing usefull in logfile
when I come it contact with it again.


MySQL (or the NAS) in a way that it will not happen again ?

If ram should be a problem, can I then use a USB stick as ram in any
way ?
I know the flash ram is slow and have limith life, but stability on
the cost of preformance is ok in this case.


/Hans

Hans Kjaergaard <hans.k2teknik (AT) post5 (DOT) tele.dk> wrote:
Are the logs deleted? You should put both MySQL error log and syslog
to disk. Another idea would be to instruct the NAS'es syslogd to
forward messages to some of your machines. And you can make MySQL log
to syslog too. If you have an old 5.0, it may be tricky. But look at
safe_mysqld where it redirects to the error log. There you should have
it pipe to logger. Newer versions can log to syslog directly.

Once you have a log, you might immediately see what the problem is.
Without a log it's just guessing.

No. USB sticks are no RAM, but Flash. But you could use the USB stick
to store logs, so you don't lose them after reboot.


XL