Re: Innodb buffer pool size

2010-05-25 Thread Baron Schwartz
Machiel, I'm going to disagree strongly with the previous advice you got. You should NOT configure the buffer pool to be larger than the amount of RAM you have. If part of the buffer pool is swapped out, then swapping it back in is MUCH worse than re-fetching the page. InnoDB doesn't know the d

Re: source backup.sql - troubleshoot

2010-05-25 Thread Rob Wultsch
On Tue, May 25, 2010 at 2:39 PM, Sydney Puente wrote: > Hello, > > I have a mysqldump file created by AutoMySQLBackup. > And it hangs when I do a > mysql > source backup.sql > It is 32 MB - it creates 4 tables and after creation of each table it > populates it. > Actually it only creates the 1st

RE: source backup.sql - troubleshoot

2010-05-25 Thread Daevid Vincent
Use something like SQLYog, load your .sql file into the editor, run all the commands one at a time, or in bulk. Look at the "info" window for what line failed. > -Original Message- > From: Sydney Puente [mailto:sydneypue...@yahoo.com] > Sent: Tuesday, May 25, 2010 2:39 PM > To: mysql@lis

source backup.sql - troubleshoot

2010-05-25 Thread Sydney Puente
Hello, I have a mysqldump file created by AutoMySQLBackup. And it hangs when I do a mysql > source backup.sql It is 32 MB - it creates 4 tables and after creation of each table it populates it. Actually it only creates the 1st table before hanging. My first thought is it would be nice to echo e

RE: Security issues

2010-05-25 Thread Jerry Schwartz
Back when this was a day-to-day concern of mine, I used to check CERT's website (the section now known as their "Vulnerability Notes Database", http://www.kb.cert.org/vuls). Unfortunately, I see that the last entry for MySQL is from years ago. Regards, Jerry Schwartz Global Information Incorpo

Re: Mysql Schema design & Rollback necessity Question

2010-05-25 Thread Shawn Green
Hello Lightingale, Lightingale wrote: Hi there, I am new to using mysql. I want to prepare an application for my employer. The application will be accessed by staff from as many as 10 different departments such as sales, marketing, admin, finance etc. The users will be using DML commands on t

RE: Security issues

2010-05-25 Thread Martin Gainty
Good Morning Rob- I agree with you that security is a very serious topic and should be addressed as such Please read security alert page listed at tech-resources http://dev.mysql.com/tech-resources/articles/security_alert.html I hope this addresses your question, Martin Gainty __