 |
 |
Sleep and Databases?
|
|
|
|
|
Junior Member
Join Date: Apr 2002
Status:
Offline
|
|
I'm about to setup a MySQL database on a new Mac. Question, then:
How should I deal with day-to-day running of the machine? Shut it down each night? Let it sleep without worry about the database? Let is sleep, but stop the database at night, and start it again the next morning? Or, leave it running, but disable sleep?
This is obviously partly a hardware question, but more importantly about the relationship between sleep and unix processes.
|
|
|
| |
|
|
|
|
|
|
|
Registered User
Join Date: Aug 2002
Location: On my couch
Status:
Offline
|
|
As long as your not planning on running any overnight database stuff, I'd say just put the thing to sleep. Everything should stay in memory just fine and you should get the best performance overall.
I'm not familiar with MySQL but I'd imagine that it would run just fine with only a reboot once a month.
Remember to run MacJanitor's jobs regularly (ie: the daily job daily and the weekly job weekly etc...)
My .02
|
|
|
| |
|
|
|
|
|
|
|
Mac Enthusiast
Join Date: Jul 2002
Location: Leiden, Netherlands
Status:
Offline
|
|
Originally posted by khufuu:
I'm not familiar with MySQL but I'd imagine that it would run just fine with only a reboot once a month.
Why woul'd you need to reboot the damn machine once a Month ? There's no need to reboot the machine.
What should be done on a database : daily backups, and from time to time check it's integrity.
|
|
|
| |
|
|
|
|
|
|
|
Mac Enthusiast
Join Date: Jul 2002
Location: Leiden, Netherlands
Status:
Offline
|
|
Originally posted by BHD:
I'm about to setup a MySQL database on a new Mac.
What will your db be used for ?
Why MySQL ? what are the reasons for that choice ?
|
|
|
| |
|
|
|
|
|
|
|
Junior Member
Join Date: Apr 2002
Status:
Offline
|
|
Originally posted by Ludovic Hirlimann:
What will your db be used for ?
Why MySQL ? what are the reasons for that choice ?
I want to use it for RefDB, a bibliographic db:
http://refdb.sourceforge.net/
This system started with MySQL, has since added the option for PostgreSQL, and will soon have the ability to use SQLite.
What I want is something reliable and easy-to-maintain for a db newbie (me). MySQL seems to have better support in the OS X community. I can be convinced otherwise though.
I am also considering the SQLite route, because I understand it might have advantages if I want to take a copy of the database with me on my laptop...
|
|
|
| |
|
|
|
|
|
|
|
Registered User
Join Date: Aug 2002
Location: On my couch
Status:
Offline
|
|
Originally posted by Ludovic Hirlimann:
Why woul'd you need to reboot the damn machine once a Month ? There's no need to reboot the machine.
What should be done on a database : daily backups, and from time to time check it's integrity.
10 years of database experience tells me that a reboot everymonth is good for memory management. no memory management software is perfect.
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
 
|
|
|
Forum Rules
|
|
|
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
|
HTML code is Off
|
|
|
|
|
|
|
|
|
|
|
|
Top
