MYSQL Adminitration.
Greetings, This could be something basic that I missed, or discussed before. Is there a way to look somewhere for logs that give a clue of how many simultaneous connections, and which user did connect at what time and other error logs, if any? I see hostname.err That has something like this. 040216 12:56:44 mysqld started 040216 12:56:44 InnoDB: Started /usr/local/mysql/bin/mysqld: ready for connections. Version: '4.0.17-standard-log' socket: '/tmp/mysql.sock' port: 3306 040223 0:44:37 /usr/local/mysql/bin/mysqld: Normal shutdown But I also see a large file with hostname.log After checking it, it seems to be simply logging each user's queries. Any suggestions? Server is running MySQL version 4.0.17 installed from the binary distribution, Red Hat Linux 7.2 Linux. Thank you for your help/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: getting off list
On Tue, 16 Mar 2004 09:45:46 -0800, "T Si" <[EMAIL PROTECTED]> wrote: >Hello. How do I get removed from the mysql e-mail list? It's at the bottom of each email you receive from the list. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Server Behavior.
Seeking opinions on this. Server is Dual Pentium Xeon 2.8, 6 GB RAM, running RedHat Linux 7.2, MySQL 4.0.17, all installed and tested with no problems. I had a small database for testing purposes, and then dropped it, leaving the default installation databases, mysql and test. If I run top from shell I get the following: >19683 root 9 0 956 956 772 S 0.0 0.0 0:00 mysqld_safe >19716 mysql 9 0 12960 12M 1612 S 0.0 0.2 0:00 mysqld >19718 mysql 9 0 12960 12M 1612 S 0.0 0.2 0:00 mysqld >19719 mysql 9 0 12960 12M 1612 S 0.0 0.2 0:00 mysqld >19720 mysql 9 0 12960 12M 1612 S 0.0 0.2 0:00 mysqld >19721 mysql 9 0 12960 12M 1612 S 0.0 0.2 0:00 mysqld >19722 mysql 9 0 12960 12M 1612 S 0.0 0.2 0:00 mysqld I checked the connections to the server and there are absolutely none. No one else is on a shell session except me. This is going on for the last 48 hrs. Is this normal? Do I need to do anything about this? If so, please point me to the right direction. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Installation Query
Greetings. If these questions were answered before I apologize in advance. I am trying to install MySQL on a new server that I got. Server is Red Hat 7.2 (not my choice), Dual P4 Xeon 2.8, 6 GB, 36GB Raid 5. Few questions I have: 1. What installation is recommended on such system. Binary, RPM, or compile from the source? If I compile from the source, will the compiled binary recognize and take advantage of the dual CPUs or I am just wasting my time? Also once installing from the source do I need to download and install the client, libraries and developer package just like I need in the RPM installation? Does that apply also to the binary installation. 2. I tried installing using the rpms, for some reason I get. DBI: connection failed cannot find mysql.sock (2) in web min. Checked that all the Perl modules are installed properly. After doing some research it seems that ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock Corrected it. And I have to apply. ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock Every time I stop and restart the MySQL server. Can anyone suggest how to correct this? I may be missing something basics, any pointers will be greatly appreciated. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Mirroring.
My Message was in English. Thank you for your help. On Wed, 4 Jun 2003 00:33:10 +0100 , Andrew Braithwaite <[EMAIL PROTECTED]> wrote: >Assuming that you speak english - you can do the following... > >http://www.mysql.com/doc/en/Replication.html > >Cheers, > >Andrew > >-Original Message- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >Sent: Wednesday 04 June 2003 00:24 >To: [EMAIL PROTECTED] >Subject: MySQL Mirroring. > > >Hi, > >Please excuse me if this question has been discussed before. > >Is there a way to securely setup 2 MySQL Servers to be in sync with each >other? > >Let's say that I have server A at home and Server B at my work and I want >server be to mirror exactly what I do on Server A. > >Can this be done? >Is there a commercial package or provider that does something like this? > >Your help will be appreciated. > >Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Mirroring.
Hi, Please excuse me if this question has been discussed before. Is there a way to securely setup 2 MySQL Servers to be in sync with each other? Let's say that I have server A at home and Server B at my work and I want server be to mirror exactly what I do on Server A. Can this be done? Is there a commercial package or provider that does something like this? Your help will be appreciated. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]