Relay or Master Binary Lod Corruption.
Hi all, Last week I got this message below.. 040829 19:38:43 Slave SQL thread: I/O error reading event(errno: -1 cur_log-e rror: 11)/usr/local/mysql/bin/mysqld: ready for connections. Version: '4.0.18-standard-log' socket: '/tmp/mysql.sock' port: 3306 040829 19:38:43 Error reading relay log event: Aborting slave SQL thread becaus e of partial event read 040829 19:38:43 Slave: Could not parse relay log event entry. The possible reas ons are: the master's binary log is corrupted (you can check this by running 'my sqlbinlog' on the binary log), the slave's relay log is corrupted (you can check this by running 'mysqlbinlog' on the relay log), a network problem, or a bug in the master's or slave's MySQL code. If you want to check the master's binary lo g or slave's relay log, you will be able to know their names by issuing 'SHOW SL AVE STATUS' on this slave. Error_code: 0 040829 19:38:43 Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with SLAVE START. We stopped at log 'www-bin .005' position 633703721 I have 2 mysql daemons running in slave mode and I got his message on only one of them. So I thought that the corruption was based on the relay.. So What I did was to CHANGE MASTER TO an after possition that the problem occur. So I tried some values but nothing changed. So As a solution I shut down the master (I was not willing to do this but I had to) and take a snapshot and rebuild the master again.. Ans started the slave from the new master binary log created.. So this solved my problem but Actually What should I do in a situation like this if it happens again? Best Regards, Cemal Dalar a.k.a Jimmy System Administrator Web Developer http://www.dalar.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Database export
I used to check, optimize and repair tables, tar the database directory and copy it simply. :) For me this is the simpliest way. Best Regards, Cemal Dalar a.k.a Jimmy System Administrator Web Developer http://www.dalar.net - Original Message - From: Edd Dawson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 16, 2004 1:39 PM Subject: Database export I have a 4GB database which i need to move to another hosting company. The source and destination databases are mysql so there is no conversion issue. My question is has anyone any recomendations on which is the best method for doing this. I am aware of doing a database dump and then importing into the new server. But i want to know if there are any issues with the file size. i.e. will carrying out an import time out with the file size being so large. I have also come across mysqlhotcopy, will this do? Any thoughts on this will be much appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL eats 100% CPU on a quad CPU system...
It depends on lots of things. But as an estimate.. Probably you need to add some indexes.. Which type of queries you are using? which database type? Other things.. what about database size? maybe you need more RAM etc.. Best Regards, Cemal Dalar a.k.a Jimmy System Administrator Web Developer http://www.dalar.net - Original Message - From: Fahr o Mavastradioz [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 16, 2004 3:48 PM Subject: MySQL eats 100% CPU on a quad CPU system... Hello people, I'm currently configuring a quad CPU system as a standalone MySQL server. The machine runs nothing except for MySQL and some trivial things like SSH and iptables. A second server acts as a webserver and is connected to this one though an internal LAN connection. Using top or ps, it shows that MySQL eats over 99% of all the available CPU. Using slmon, it shows that indeed all 4 CPUs are fully in use. Still, it appears to be terribly slow and I don't think MySQL should eat over 99% CPU on a quad CPU system... The machine runs mysqld 4.0.18 on Debian Sarge. A stripped down my.cnf is included below (I merely removed the comments). Could anyone tell me what can cause this problem? Thanks, - Fahr ===my.cnf=== [client] port= 3306 socket = /var/run/mysqld/mysqld.sock [mysqld_safe] err-log = /var/log/mysql/mysql.err socket = /var/run/mysqld/mysqld.sock open_files_limit = 8192 [mysqld] user= mysql pid-file= /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port= 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp language= /usr/share/mysql/english skip-locking thread_stack= 128K skip-innodb max_connections = 500 key_buffer = 150M myisam_sort_buffer_size = 64M join_buffer_size = 1M read_buffer_size = 1M sort_buffer_size = 1M table_cache = 1500 thread_cache_size = 128 wait_timeout = 14400 connect_timeout = 10 max_allowed_packet = 16M max_connect_errors = 10 query_cache_limit = 1M query_cache_size = 32M query_cache_type = 1 [mysqldump] quick max_allowed_packet = 16M [mysql] [isamchk] key_buffer = 64M sort_buffer = 64M read_buffer = 16M write_buffer = 16M -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Indexes
mysql show index from urun; +---++--+--+-+-- -+-+--++--++-+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | +---++--+--+-+-- -+-+--++--++-+ | urun | 0 | PRIMARY |1 | urun_id | A | 108725 | NULL | NULL | | BTREE | | | urun | 0 | UC_urun_id |1 | urun_id | A | 108725 | NULL | NULL | | BTREE | | | urun | 1 | IDX_urun_urun_id |1 | urun_id | A | 108725 | NULL | NULL | | BTREE | | | urun | 1 | ktgr |1 | ktgr| A | 512 | NULL | NULL | | BTREE | | +---++--+--+-+-- -+-+--++--++-+ 4 rows in set (0.00 sec) Also my show create table urun looks like this.. .. PRIMARY KEY (`urun_id`), UNIQUE KEY `UC_urun_id` (`urun_id`), KEY `IDX_urun_urun_id` (`urun_id`), KEY `ktgr` (`ktgr`) ) TYPE=MyISAM | Isn't this KEY `IDX_urun_urun_id` (`urun_id`), and UNIQUE KEY `UC_urun_id` (`urun_id`), indexes are unnecessary? Best Regards, Cemal Dalar a.k.a Jimmy System Administrator Web Developer http://www.dalar.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Auto Increment Column
Keep in mind that it is not a ood idea to get (not sure how to get the last value for auto_increment column) last id with a statement like SHOW TABLE STATUS. Because this will return allways the some for different connections which might create problems for you. My point is. last_insert_id() returns the ID generated last according to the connecttion you used. For example if you make two different connections and insert two different records you will NOT get the same last_insert_id() value.. But at your case they will be probably the same.. Best Regards, Cemal Dalar a.k.a Jimmy System Administrator Web Developer http://www.dalar.net - Original Message - From: Naresh Sadhnani [EMAIL PROTECTED] To: Rhino [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, August 12, 2004 3:35 PM Subject: RE: Auto Increment Column Well actually I want it in a stored procedure. However due to a bug in version 5.0.0 alpha (posted on the bugs database by me ID 5017) I cannot get the LAST_INSERT_ID() in the stored procedures. So I want an alternate way of getting LAST_INSERT_ID(). I thought auto_increment column of SHOW table status should get me that... However it is proving difficult as well. I even tried using MAX on the table which also has a bug when called from a stored procedure (I have not reported this as yet). So any ideas? Cheers Naresh -Original Message- From: Rhino [mailto:[EMAIL PROTECTED] Sent: 12 August 2004 13:25 To: Naresh Sadhnani; [EMAIL PROTECTED] Subject: Re: Auto Increment Column | Subject: Auto Increment Column | | Hi, | | Does anyone know how to extract only the Auto_Increment column from | the command results of SHOW TABLE STATUS Do you mean that you want a command that will run on the command line that will show the value of the Auto_Increment column? Or are you trying to determine how to read the value via programming statements in an application? If you prefer the latter, what programming language are you using? Rhino -- This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the originator of the message. This footer also confirms that this email message has been scanned for the presence of computer viruses. Any views expressed in this message are those of the individual sender, except where the sender specifies and with authority, states them to be the views of DA Group. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Importing from plain text?
make you text file format same as the table format . then use mysqlimport database_name table_name.txt by default mysqlimport need tab delimited text. if you need ; or other use --fields-terminated-by= http://dev.mysql.com/doc/mysql/en/mysqlimport.html Best Regards, Cemal Dalar a.k.a Jimmy System Administrator Web Developer http://www.dalar.net - Original Message - From: Robin Lynn Frank [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, August 11, 2004 8:02 PM Subject: Importing from plain text? -BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 My apologies for so basic a question, but I am just getting started with mysql. I have a text file that looks like this: text other text text2 othertext2 [...] I want the text in the left column in one field and the text in the righ column in the other field. I've been looking thru the docs, but am unsure of what I am seeing. Can someone point me to an example? TIA. - -- Robin Lynn Frank Director of Operations Paradigm-Omega, LLC == A bug in the code is worth two in the documentation. -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (GNU/Linux) Comment: Sed quis custodiet ipsos custodes? iD8DBQFBGlEko0pgX8xyW4YRAxmkAJ9lEM6RNUMrKvU3p8MwpKXbV/JJ1ACeJMfc RRUmJEs6tw2h65IagfylVHQ= =Cw38 -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Changing Fulltext defaults in Win32
put a line like below to your my.cnf file under [mysqld] section ft_min_word_len=2 Best Regards, Cemal Dalar a.k.a Jimmy System Administrator Web Developer http://www.dalar.net - Original Message - From: leegold [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, August 11, 2004 8:12 PM Subject: Changing Fulltext defaults in Win32 I'm using MYSQL 4.x on Win2k. I want to change the default smallest word size from the default (4 chars I think) to 2chars. Any links, how-to's appreciated. Thanks, Lee G. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Changing Fulltext defaults in Win32
for sure :) Best Regards, Cemal Dalar a.k.a Jimmy System Administrator Web Developer http://www.dalar.net - Original Message - From: leegold [EMAIL PROTECTED] To: Cemal Dalar [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, August 11, 2004 8:32 PM Subject: Re: Changing Fulltext defaults in Win32 On Wed, 11 Aug 2004 20:29:54 +0300, Cemal Dalar [EMAIL PROTECTED] said: put a line like below to your my.cnf file under [mysqld] section ft_min_word_len=2 I assume I should shutdown-restart MYSQL after I do that ? Thanks, Lee G. snip -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Table and indexes
Is this normal to have a index like below.. As I know there is no need to have KEY and UNIQUE for a PRIMARY KEY PRIMARY KEY (`urun_id`), UNIQUE KEY `UC_urun_id` (`urun_id`), KEY `IDX_urun_urun_id` (`urun_id`), KEY `ktgr` (`ktgr`) ) TYPE=MyISAM Best Regards, Cemal Dalar a.k.a Jimmy System Administrator Web Developer http://www.dalar.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Enum or Int
There was a discussion about this topic at past. Check the previous posts.As a simple answer they are technically the same. Use what ever you want.. Best Regards, Cemal Dalar a.k.a Jimmy System Administrator Web Developer http://www.dalar.net - Original Message - From: Salzgeber Olivier [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, July 30, 2004 12:48 PM Subject: Enum or Int Hello all I have a table with a field which needs to hold a yes/no or 1/0 value. Which field type is best for this ? Should i create a ENUM field with yes or no values or is it better to create an Int field for this ? What would you recommend ? Best regards Olivier Salzgeber -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Daemons
Hi all, I'm administrating a LAMPhp system and have there values below.. Session Count : 6437 (find /tmp -name \sess*\ | wc -l) (session timeout is 30 mins.) MySQL Daemon Count : 85 (ps -ef | grep mysql | wc -l) Apache Daemon Count : 106 (ps -ef | grep httpd | wc -l) As you can see I have lots of mysql daemons running which are mostly on sleep. I don't want these daemons to use RAM. Can you offer any solutions? Also are the above values seems ok? Thanks. Best Regards, Cemal Dalar a.k.a Jimmy System Administrator Web Developer http://www.dalar.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Take a look at this http://dev.mysql.com/doc/mysql/en/Can_not_connect_to_server.html Best Regards, Cemal Dalar a.k.a Jimmy System Administrator Web Developer http://www.dalar.net - Original Message - From: Laurent [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 19, 2004 12:46 PM Subject: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Hello! I'm new to MySQl and I have sevral problems to get the Mysql-server going. First of all, when trying to connect (in mysqlcc) I get the following error message: [MySQL] ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Hoe can I get this working? Laurent -- Linux is like an Indian tent: no Windows, no Gates, and an Apache inside! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Replication stopping
Ok. better check .err files in /usr/local/mysql/data/hostname.err for any errors.. It seems that there isn't any problems on slave but from my experience there can be problem on the slave like auth. For example when replica user can not login to master then 'show slave status' doesn't give any error messages but writes some lines to .err file.. Check those files both in master and in slave.. Best Regards, Cemal Dalar a.k.a Jimmy System Administrator Web Developer http://www.dalar.net - Original Message - From: Nico Sabbi [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 14, 2004 2:15 PM Subject: Re: Replication stopping Il lun, 2004-07-12 alle 13:45, Cemal Dalar ha scritto: To debug the problem. Make SHOW SLAVE STATUS in the slave and check for the error number.. Best Regards, Cemal Dalar a.k.a Jimmy System Administrator Web Developer http://www.gittigidiyor.com http://www.dalar.net - Original Message - From: Nico Sabbi [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 12, 2004 6:08 PM Subject: Replication stopping Hi, it happened again just now, this is the status: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 55463 to server version: 4.0.18-Max-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show slave status \G *** 1. row *** Master_Host: master Master_User: replica Master_Port: 3306 Connect_retry: 60 Master_Log_File: db-bin.3323 Read_Master_Log_Pos: 437183883 Relay_Log_File: server-relay-bin.005 Relay_Log_Pos: 228252575 Relay_Master_Log_File: db-bin.3323 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_do_db: Replicate_ignore_db: mysql Last_errno: 0 Last_error: Skip_counter: 0 Exec_master_log_pos: 437183883 Relay_log_space: 228252575 1 row in set (0.00 sec) Nico -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Replication stopping
To debug the problem. Make SHOW SLAVE STATUS in the slave and check for the error number.. Best Regards, Cemal Dalar a.k.a Jimmy System Administrator Web Developer http://www.gittigidiyor.com http://www.dalar.net - Original Message - From: Nico Sabbi [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 12, 2004 6:08 PM Subject: Replication stopping Hi, often my slave suddenly stops, reporting these the logs: 040712 12:19:00 Slave I/O thread exiting, read up to log 'db-bin.3323', position 197564621 040712 12:19:10 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'db-bin.3323' at position 197564621 040712 13:48:22 Slave I/O thread exiting, read up to log 'db-bin.3323', position 208931388 040712 13:48:25 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'db-bin.3323' at position 208931388 this is the configuration of the slave: [mysqld] log-bin server-id=20 master-host=master master-port=3306 master-user=replica master-password=*** replicate-ignore-db=mysql replicate-wild-do-table=db1.prc replicate-wild-do-table=db2.provincia_rc replicate-wild-do-table=db3.tc replicate-wild-do-table=prc.% master-connect-retry=60 slave-skip-errors=all How can I understand exactly what is stopping the replication? Thanks, Nico -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Shutdown in progress error on Slaves.
What is the procedure for altering tables in MASTER in a master, slave replication configuration. For example I made some test and I see that if I made a change in a table on master I got an error like Shutdown in progress on SLAVES. I also tested to make slave stop and make the change.. At this time no error occurred when I do slave start.. Also when I do slave stop;slave start after the error occurs.. I starts working without any errors. Why this happens? Thanks, Best Regards, Cemal Dalar a.k.a Jimmy System Administrator Web Developer http://www.gittigidiyor.com http://www.dalar.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ENUM vs TINYINT
Hi all, I need a boolean column and at to this time I always used ENUM('Y','N') for this. I'am wondering that will there be a performance difference between using ENUM('Y','N') and TINYINT(1) or BOOLEAN?. And put 0 or 1 to TINYINT column. Best Regards, Cemal Dalar a.k.a Jimmy System Administrator Web Developer http://www.dalar.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ODBC error
You should check your privileges in mysql server. Look at the Host field in mysql.user table. Probably that is the problem and change the value to the Windows IP address. And don't forget to make FLUSH PRIVILEGES.. Ref: http://dev.mysql.com/doc/mysql/en/User_Account_Management.html Best Regards, Cemal Dalar a.k.a Jimmy System Administrator Web Developer http://www.gittigidiyor.com http://www.dalar.net - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 18, 2004 12:51 PM Subject: ODBC error From a Windows2000 machine, I use ODBC Data Source Administrator to connect to mysql server on RedHat ES 3. I got the following message. [MySQL][ODBC 3.51 Driver] Host 'IP_address' is not allowed to connect to this MySQL server Any idea? Thanks, Joseph -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Web Clustering...
Go for a simple MySQL master - slave configuration. I'm runing 1 master 3 slaves for performance issues and doesn't have any problem at all for 1 year.. Of course in this case you should change some code in your webservers to direct SELECT queries to slave machine to gain performance on the master. I will also keep in touch with MySQL Cluster development and probably go for this in the near future. Best Regards, Cemal Dalar a.k.a Jimmy System Administrator Web Developer http://www.gittigidiyor.com http://www.dalar.net - Original Message - From: Roy Nasser [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 18, 2004 4:58 PM Subject: MySQL Web Clustering... Hi All, We have recently acquired some new machines for our ASP service, and I am investigating different options and setups to optimize everything. We currently have one large DB server, with RAID5, etc, running mysql and a few smaller servers for web applications, and e-mail. These smaller servers arent all identical in their software, and they run different services. We currently have reached a certain limit in the DB as well as in some of our applications on the webservers, hence the need for something expandable. I have read slightly about MySQLCluster, as well as some other solutions such as openMosix, Mosix and LVS. I was wondering if you guys have experience, and what you would recommend for the DB and for the webservers. I still want to maintain them separate, even if I end up having 2 different clusters, I prefer to keep the DB away from the application for security reasons. Thanks! Roy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How to monitor that slave is not working because of user rights?
Hi all, I'm running a mysql master - slave configuration. My Slave server is on a dynamic IP address and I restricted the access to master only from specific IP address for security. I am getting backups through slave server and writted a small java application to monitor the slave status by checking Slave_SQL_Running in SHOW SLAVE STATUS. Everything works fine. But for about once a week my IP address on slave server changes and even if slave does not run and gives the following error on host.err file it doesn't return No in both Slave_SQL_Running and Slave_IO_Running. I don't exactly know that this is a bug or not but I need a solution for now. Thanks for all replies. Best Regards, Cemal Dalar a.k.a Jimmy System Administrator Web Developer http://www.dalar.net smime.p7s Description: S/MIME cryptographic signature
Re: starting mysql server
Check your log file for details. Probably because of file permissions of data folder. Best Regards, Cemal Dalar a.k.a Jimmy System Administrator Web Developer http://www.gittigidiyor.com http://www.dalar.net - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, June 17, 2004 12:47 PM Subject: starting mysql server Hello all, I have installed mysql and in one of the tutorials it has told me to do the following: You can start the MySQL server with the following command: shell ./bin/mysqld_safe --user=mysql However when I did this I got the following: --- linskull:/home/mikem/local/mysql # ./bin/mysqld_safe --user=mysql Starting mysqld daemon with databases from /home/mikem/local/mysql/data 040617 10:37:40 mysqld ended --- As you can see the shell just goes idle. Is this what is supposed to happen or what am I doing wrong? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to monitor that slave is not working because of user rights?
My point was this situation should affect on Slave_SQL_Running value.. but in real it is NOT.. Best Regards, Cemal Dalar a.k.a Jimmy System Administrator Web Developer http://www.gittigidiyor.com http://www.dalar.net - Original Message - From: gerald_clark [EMAIL PROTECTED] To: Cemal Dalar [EMAIL PROTECTED] Cc: Group MySQL List [EMAIL PROTECTED] Sent: Thursday, June 17, 2004 4:30 PM Subject: Re: How to monitor that slave is not working because of user rights? Cemal Dalar wrote: Hi all, I'm running a mysql master - slave configuration. My Slave server is on a dynamic IP address and I restricted the access to master only from specific IP address for security. I am getting backups through slave server and writted a small java application to monitor the slave status by checking Slave_SQL_Running in SHOW SLAVE STATUS. Everything works fine. But for about once a week my IP address on slave server changes and even if slave does not run and gives the following error on host.err file it doesn't return No in both Slave_SQL_Running and Slave_IO_Running. I don't exactly know that this is a bug or not but I need a solution for now. Thanks for all replies. Best Regards, Cemal Dalar a.k.a Jimmy System Administrator Web Developer http://www.dalar.net Get a static IP address. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to monitor that slave is not working because of user rights?
Actually. I am talking about a machine which is at office. And inside office we're connecting using ADSL which gets dynamic Ip address. The slave server's IP address actully doesn't change. It doesn't have a real ip address only the ADSL has. Simply saying we are using NAT. What I have in mind is to monitor the Read_Master_Log_Pos, Exec_master_log_pos with the master server and only allow small differences like ~1. And also checking the other Slave_* values. At this point I'm not trying to fix this on fly. May be later :) I want to be sure that my slave server is working fine.. Also I think that I should this situation in SHOW SLAVE STATUS that slave is not working properly. Best Regards, Cemal Dalar a.k.a Jimmy System Administrator Web Developer http://www.gittigidiyor.com http://www.dalar.net - Original Message - From: [EMAIL PROTECTED] To: Cemal Dalar [EMAIL PROTECTED] Cc: gerald_clark [EMAIL PROTECTED]; Group MySQL List [EMAIL PROTECTED] Sent: Thursday, June 17, 2004 5:15 PM Subject: Re: How to monitor that slave is not working because of user rights? Cemal, If the connection between your master and your slave is somehow proxied, then your slave may never know it's address changed. If your slave doesn't know it's broke, how can it fix itself? How is this Dynamic IP actually being performed? (specifics please) Shawn Green Database Administrator Unimin Corporation - Spruce Pine Cemal Dalar [EMAIL PROTECTED]To: gerald_clark [EMAIL PROTECTED] cc: Group MySQL List [EMAIL PROTECTED] 06/17/2004 09:44 Fax to: AM Subject: Re: How to monitor that slave is not working because of user rights? My point was this situation should affect on Slave_SQL_Running value.. but in real it is NOT.. Best Regards, Cemal Dalar a.k.a Jimmy System Administrator Web Developer http://www.gittigidiyor.com http://www.dalar.net - Original Message - From: gerald_clark [EMAIL PROTECTED] To: Cemal Dalar [EMAIL PROTECTED] Cc: Group MySQL List [EMAIL PROTECTED] Sent: Thursday, June 17, 2004 4:30 PM Subject: Re: How to monitor that slave is not working because of user rights? Cemal Dalar wrote: Hi all, I'm running a mysql master - slave configuration. My Slave server is on a dynamic IP address and I restricted the access to master only from specific IP address for security. I am getting backups through slave server and writted a small java application to monitor the slave status by checking Slave_SQL_Running in SHOW SLAVE STATUS. Everything works fine. But for about once a week my IP address on slave server changes and even if slave does not run and gives the following error on host.err file it doesn't return No in both Slave_SQL_Running and Slave_IO_Running. I don't exactly know that this is a bug or not but I need a solution for now. Thanks for all replies. Best Regards, Cemal Dalar a.k.a Jimmy System Administrator Web Developer http://www.dalar.net Get a static IP address. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]