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
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
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
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
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
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
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
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
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