Re: MySQL 5.0.41 performance on FreeBSD 7.0-RC1 AMD64
Have you checked this? http://www.slideshare.net/sim303/7020-preview/ http://www.freebsd.org/features.html On Jan 22, 2008 4:05 AM, Mikhail Berman <[EMAIL PROTECTED]> wrote: > Hi everyone, > > Is anyone has experience running MySQL 5.0.41 on FreeBSD 7.0-RC1 AMD64? > > If you do would you be able to comment on MySQL performance, possible > advantages and problems? > > Regards, > -- > Mikhail Berman > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: The Use database command is too slow
It is a hosting solution, so users create databases for themselves if they want. On Feb 3, 2008 4:44 AM, Eric Bergen <[EMAIL PROTECTED]> wrote: > I think a better question is why do you have one database per user? > > -Eric > > > On 2/2/08, imad <[EMAIL PROTECTED]> wrote: > > I am not connecting through MySQL. I am connecting through PHP. How > > can I speed it up? > > > > > > > > > > On Feb 3, 2008 12:20 AM, Saravanan <[EMAIL PROTECTED]> wrote: > > > Hi, > > > > > > when you connect using mysql auto-rehash is enabled as default. It will > > > read and open the tables in the database when you try to use the > > > database. It may take time for database with many tables. use mysql with > > > -A or --no-auto-rehash. > > > > > > shell> mysql -uroot -A > > > shell> mysql -uroot --skip-auto-rehash > > > > > > Saravanan > > > MySQL DBA > > > > > > > > > --- On Sat, 2/2/08, imad <[EMAIL PROTECTED]> wrote: > > > > > > > From: imad <[EMAIL PROTECTED]> > > > > Subject: The Use database command is too slow > > > > To: mysql@lists.mysql.com > > > > Date: Saturday, February 2, 2008, 6:14 AM > > > > > > > Hello, > > > > > > > > I have like 50K databases on my server, one for every user. > > > > I am experience delay in the command 'use database' > > > > which is issued by > > > > every user when he connects to the database. > > > > > > > > Can anyone here tell me what is my problem and how can I > > > > speed it up. > > > > > > > > thanks > > > > > > > > -- > > > > MySQL General Mailing List > > > > For list archives: http://lists.mysql.com/mysql > > > > To unsubscribe: > > > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > > > > > > > Be a better friend, newshound, and > > > know-it-all with Yahoo! Mobile. Try it now. > > > http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ > > > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > -- > high performance mysql consulting. > http://provenscaling.com > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: The Use database command is too slow
I think a better question is why do you have one database per user? -Eric On 2/2/08, imad <[EMAIL PROTECTED]> wrote: > I am not connecting through MySQL. I am connecting through PHP. How > can I speed it up? > > > > > On Feb 3, 2008 12:20 AM, Saravanan <[EMAIL PROTECTED]> wrote: > > Hi, > > > > when you connect using mysql auto-rehash is enabled as default. It will > > read and open the tables in the database when you try to use the database. > > It may take time for database with many tables. use mysql with -A or > > --no-auto-rehash. > > > > shell> mysql -uroot -A > > shell> mysql -uroot --skip-auto-rehash > > > > Saravanan > > MySQL DBA > > > > > > --- On Sat, 2/2/08, imad <[EMAIL PROTECTED]> wrote: > > > > > From: imad <[EMAIL PROTECTED]> > > > Subject: The Use database command is too slow > > > To: mysql@lists.mysql.com > > > Date: Saturday, February 2, 2008, 6:14 AM > > > > > Hello, > > > > > > I have like 50K databases on my server, one for every user. > > > I am experience delay in the command 'use database' > > > which is issued by > > > every user when he connects to the database. > > > > > > Can anyone here tell me what is my problem and how can I > > > speed it up. > > > > > > thanks > > > > > > -- > > > MySQL General Mailing List > > > For list archives: http://lists.mysql.com/mysql > > > To unsubscribe: > > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > > Be a better friend, newshound, and > > know-it-all with Yahoo! Mobile. Try it now. > > http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- high performance mysql consulting. http://provenscaling.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: show slave status
High Performance MySQL ch 7 provides one of the solutions on that. Look for check_repl. http://dev.mysql.com/books/hpmysql-excerpts/ch07.html On Feb 3, 2008 2:58 AM, Brown, Charles <[EMAIL PROTECTED]> wrote: > Can someone please tell me what is the most effective or preferred > method for monitoring replication in MySQL. Recently, my replication > stopped as a result of duplicate row found in the slave. Therefore, I > would like to monitor and send out an email or alert whenever it is > down. > > > > Every so often, I would logon to MySQl and issue this command: "SHOW > SLAVE STATUS". I would like to automate this process. I would like to > parse the output of this command and look pertinent info such as > "seconds_behind_master" < 10. If it greater than 10, then I'll send out > an email saying replication is in error. > > > > Charles > > > > This message is intended only for the use of the Addressee and > may contain information that is PRIVILEGED and CONFIDENTIAL. > > If you are not the intended recipient, you are hereby notified > that any dissemination of this communication is strictly prohibited. > > If you have received this communication in error, please erase > all copies of the message and its attachments and notify us > immediately. > > Thank you. > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: The Use database command is too slow
I am not connecting through MySQL. I am connecting through PHP. How can I speed it up? On Feb 3, 2008 12:20 AM, Saravanan <[EMAIL PROTECTED]> wrote: > Hi, > > when you connect using mysql auto-rehash is enabled as default. It will read > and open the tables in the database when you try to use the database. It may > take time for database with many tables. use mysql with -A or > --no-auto-rehash. > > shell> mysql -uroot -A > shell> mysql -uroot --skip-auto-rehash > > Saravanan > MySQL DBA > > > --- On Sat, 2/2/08, imad <[EMAIL PROTECTED]> wrote: > > > From: imad <[EMAIL PROTECTED]> > > Subject: The Use database command is too slow > > To: mysql@lists.mysql.com > > Date: Saturday, February 2, 2008, 6:14 AM > > > Hello, > > > > I have like 50K databases on my server, one for every user. > > I am experience delay in the command 'use database' > > which is issued by > > every user when he connects to the database. > > > > Can anyone here tell me what is my problem and how can I > > speed it up. > > > > thanks > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > Be a better friend, newshound, and > know-it-all with Yahoo! Mobile. Try it now. > http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: The Use database command is too slow
Hi, when you connect using mysql auto-rehash is enabled as default. It will read and open the tables in the database when you try to use the database. It may take time for database with many tables. use mysql with -A or --no-auto-rehash. shell> mysql -uroot -A shell> mysql -uroot --skip-auto-rehash Saravanan MySQL DBA --- On Sat, 2/2/08, imad <[EMAIL PROTECTED]> wrote: > From: imad <[EMAIL PROTECTED]> > Subject: The Use database command is too slow > To: mysql@lists.mysql.com > Date: Saturday, February 2, 2008, 6:14 AM > Hello, > > I have like 50K databases on my server, one for every user. > I am experience delay in the command 'use database' > which is issued by > every user when he connects to the database. > > Can anyone here tell me what is my problem and how can I > speed it up. > > thanks > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
The Use database command is too slow
Hello, I have like 50K databases on my server, one for every user. I am experience delay in the command 'use database' which is issued by every user when he connects to the database. Can anyone here tell me what is my problem and how can I speed it up. thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
show slave status
Can someone please tell me what is the most effective or preferred method for monitoring replication in MySQL. Recently, my replication stopped as a result of duplicate row found in the slave. Therefore, I would like to monitor and send out an email or alert whenever it is down. Every so often, I would logon to MySQl and issue this command: "SHOW SLAVE STATUS". I would like to automate this process. I would like to parse the output of this command and look pertinent info such as "seconds_behind_master" < 10. If it greater than 10, then I'll send out an email saying replication is in error. Charles This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you.
Re: Error in /index.php: Access denied for user 'apache'@'localhost' (using password: NO)
My guess is that you have the privileges set on your local box that allow connections with those credentials but the same privileges are not set up on your clients machines. Although using apache as a user without a password is quite a security risk. And then mailing those details to a public mailing list is probably madness. I would suggest using a different username and setting a password and then using those details to connect to the database. Then set the same privileges on your client's machine -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]