parameter being overwritten
im trying to setup mysql slave but the things is it wont start because of this errror: -- ERROR 1200 (HY000): The server is not configured as slave; fix in config file or with CHANGE MASTER TO after some testing.. i saw the server-id = 0 through show variables like 'server_id' went to check server-id parameter in /etc/my.cnf grep server-id /etc/my.cnf #server-id = 2 server-id = 2 -- its good.. ls -l ~/my.cnf -- file not found.. print_defaults mysqld result --server-id=2 -- its good but again show variables like server_id is showing 0 what i had to do is set global parameter in mysqld cli w/c is not a good thing.. additional info: Default options are read from the following files in the given order: /etc/my.cnf ~/.my.cnf /etc/my.cnf is there anyway to trace why server-id = 0?
Re: mysql-bin maintenance
i tried this one PURGE { BINARY | MASTER } LOGS { TO '*log_name*' | BEFORE *datetime_expr* } but for some reason it didn't purge any bin file.. so i tried our expired... on the my.cnf waited for a while and it was deleted... is there a requirement to use purge i have 5.0.51a-0.rhel4 running on my test box. On Mon, May 11, 2009 at 10:15 PM, edb...@edberg-online.com wrote: On Mon, May 11, 2009 6:41 pm, Rilawich Ango wrote: Hi, In the master database, there are plenty of mysql-bin.X. It occupied almost all the disk space. As I know, the files should be removed by issuing reset master. Below are my questions. -Do I need to stop replication before issuing reset master? If yes, do I need to rebuild the replication after reset master? If no, does the existing replication broken after reset master? ango See http://dev.mysql.com/doc/refman/5.0/en/purge-binary-logs.html (or the relevant URL for your language/version). And you can use the expire_logs_days system variable to have MySQL automatically purge old logs. - steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=jerom...@gmail.com
Re: Weird connection timed-out
On Tuesday 15 May 2007 02:56, Dan Buettner wrote: Hi JM - Can you send us a few things? 1 - the exact error message you get the error code it produced is (110) which according to perror is connection time out.. 2 - the output of SHOW VARIABLES; from a mysql session +-++ | Variable_name | Value | +-++ | auto_increment_increment| 1 | | auto_increment_offset | 1 | | automatic_sp_privileges | ON | | back_log| 50 | | basedir | / | | bdb_cache_size | 8388600 | | bdb_home| /var/lib/mysql/ | | bdb_log_buffer_size | 614400 | | bdb_logdir | | | bdb_max_lock| 1 | | bdb_shared_data | OFF | | bdb_tmpdir | /tmp/ | | binlog_cache_size | 32768 | | bulk_insert_buffer_size | 8388608 | | character_set_client| latin1 | | character_set_connection| latin1 | | character_set_database | latin1 | | character_set_filesystem| binary | | character_set_results | latin1 | | character_set_server| latin1 | | character_set_system| utf8 | | character_sets_dir | /usr/share/mysql/charsets/ | | collation_connection| latin1_swedish_ci | | collation_database | latin1_swedish_ci | | collation_server| latin1_swedish_ci | | completion_type | 0 | | concurrent_insert | 1 | | connect_timeout | 10 | | datadir | /var/lib/mysql/ | | date_format | %Y-%m-%d | | datetime_format | %Y-%m-%d %H:%i:%s | | default_week_format | 0 | | delay_key_write | ON | | delayed_insert_limit| 100 | | delayed_insert_timeout | 300 | | delayed_queue_size | 1000 | | div_precision_increment | 4 | | engine_condition_pushdown | OFF | | expire_logs_days| 0 | | flush | OFF | | flush_time | 0 | | ft_boolean_syntax | + -()~*:| | | ft_max_word_len | 84 | | ft_min_word_len | 4 | | ft_query_expansion_limit| 20
Re: unauthenticated user
Would it be possible to prevent reverse lookup? Im using the latest GA version.. thanks, On Wednesday 21 February 2007 23:12, Nils Meyer wrote: Hi JM, JM wrote: i got this results from show processlist | 11186 | unauthenticated user | 192.168.1.106:36198 | | Connect | | NULL | login | | | 11187 | unauthenticated user | 192.168.1.106:36200 | | Connect | | NULL | login | | That's just fine. The user is in login state, so he/she/it is not yet authenticated. There might be a DNS issue slowing down login, you might check if you can reverse lookup the hostnames of the connecting users. regards Nils Mailing-List -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Please I need inputs on Lost connection to MySQL server during query
On Thursday 01 September 2005 20:41, Pooly wrote: Hi, what is the error in your error log ? im using MySQL-client-4.1.12-1 binary from mysql website i got this.. 050901 14:50:44 [Warning] Asked for 196608 thread stack, but got 126976 -- im trying to fix this by adding set-variable thread_stack=192K but everytime I restart the server i still get the warning.. 050901 14:50:45 InnoDB: Started; log sequence number 0 43951 050901 14:50:45 [Warning] mysql.user table is not updated to new password format; Disabling new password usage until mysql_fix_privilege_tables is run if ill be doing what the log file says execute mysql_fix_privilege_tables .. would there be any draw backs or problems that ill be encountering.. Does your server crash for every query it makes ? Or only some ? the server doesnt crash i check the uptime for the DB and its up fror 12 days.. Are you using the official binary from MySQL or the one used for you distro vendor ? no i downloaded the binary from mysql website.. Are you using UDF ? no ... We need more inputs ;-) 2005/9/1, JM [EMAIL PROTECTED]: Hi all, Ive read this link http://dev.mysql.com/doc/mysql/en/gone-away.html; hoping this has something to do with the error... Ive already checked based on the page the list of roots of error to produce gone-away.. w/c i hope leads to Lost connection to MySQL server during query and non of it is present. One thing Ive noticed. When I tried connecting using mysql client from web server to my DB box its takes time before mysql console shows-up after giving the password. Client and Server are connected through a LAN. Based on ping an average of .1 ms reply.. tia, -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Pooly Webzine Rock : http://www.w-fenec.org/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Please I need inputs on Lost connection to MySQL server during query
On Thursday 01 September 2005 22:14, [EMAIL PROTECTED] wrote: JM [EMAIL PROTECTED] wrote on 09/01/2005 06:01:57 AM: Hi all, Ive read this link http://dev.mysql.com/doc/mysql/en/gone-away. html hoping this has something to do with the error... Ive already checked based on the page the list of roots of error to produce gone-away.. w/c i hope leads to Lost connection to MySQL server during query and non of it is present. One thing Ive noticed. When I tried connecting using mysql client from web server to my DB box its takes time before mysql console shows-up after giving the password. Client and Server are connected through a LAN. Based on ping an average of .1 ms reply.. tia, OK, we have the error message (good). We know what you have looked at to solve the error (also good). What we don't have is what you did to create the error in the first place. the error is somehow unpredictable.. sometimes when i access the first page.. its works.. trying refreshing it.. after sometime its works. trying to do it every once so often then i encounter the problem... Please describe what you are doing to create the error, the data you are doing it with, and the tools involved in both ends of the process. Then we can understand your problem. Thanks! Shawn Green Database Administrator Unimin Corporation - Spruce Pine -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]