[ERROR] /usr/sbin/mysqld: unknown option '--ndbcluster'
Dear All, Can anyone brief me about this error. I am unable to start the mysql so please suggest me work around on how to fix this error. I am installing "mysql Ver 14.14 Distrib 5.1.38, for pc-linux-gnu (i686) using readline 5.1" [ERROR] /usr/sbin/mysqld: unknown option '--ndbcluster' -- Manoj M. Burande, Artificial Machines Pvt Ltd, System Administrator. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Unable to configuring multiple Management nodes.
2009-08-31 13:02:41 [MgmSrvr] INFO -- NDB Cluster Management Server. mysql-5.1.34 ndb-7.0.6 2009-08-31 13:02:42 [MgmSrvr] INFO -- Reading cluster configuration from '/var/lib/mysql-cluster/config.ini' 2009-08-31 13:02:42 [MgmSrvr] WARNING -- at line 44: Cluster configuration warning: arbitrator with id 1 and db node with id 3 on same host 192.168.1.107 arbitrator with id 2 and db node with id 4 on same host 192.168.1.125 Running arbitrator on the same host as a database node may cause complete cluster shutdown in case of host failure. After that I did on "host:192.168.1.107" the following : -- [r...@ns mysql-cluster]# ndb_mgm -e show Connected to Management Server at: 192.168.1.107:1186 ERROR Message: The cluster configuration is not yet confirmed by all defined management servers. This management server is still waiting for node 2 to connect. Could not get configuration * 4012: Failed to get configuration *The cluster configuration is not yet confirmed by all defined management servers. This management server is still waiting for node 2 to connect. and on "host:192.168.1.125": -- [r...@test mysql-cluster]# ndb_mgm -e show Connected to Management Server at: 192.168.1.125:1186 ERROR Message: The cluster configuration is not yet confirmed by all defined management servers. This management server is still waiting for node 1 to connect. Could not get configuration * 4012: Failed to get configuration *The cluster configuration is not yet confirmed by all defined management servers. This management server is still waiting for node 1 to connect. Please help me. I am working on the same since 2 days but the proper solution is not getting from everywhere. I am stucked on this issue. So please provide me the proper steps to configure multiple management nodes with respect to the above mentioned scenario. -- Manoj M. Burande, Artificial Machines Pvt Ltd, System Administrator. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
store timezone
Hi All, Is it possible to store the timezone with datetime data type in mysql or any other approach available to achieve this in mysql. Looking for your help. Thanks, Manoj
Re: Is Temporary table right approach
Hi All, Thanks for your valuable input. I have decided to use temporary table approach. Since I am using it for the first time and this has to be done in the production server. Do I need to consider some facts before using this such as setting some parameters in my.cnf etc or the MYSQL will handle all. Actually I want to know if any one has faces issues practically when implementing temporary tables. Waiting for your suggestion. Thanks, Manoj On Fri, Apr 17, 2009 at 8:21 AM, Moon's Father wrote: > Use temporary table can be a good idea. But I think you performance would > be boost so much if you can do something else to replace the temporary > table. > On Wed, Apr 15, 2009 at 2:03 PM, Manoj Singh wrote: > >> Hi All, >> >> I have a query which returns the large number of ids which i am using in >> other queries. I am doing this in PHP. Now the first query can return >> unlimited number of ids which might create problem in PHP. I want to store >> this ids in MYSQL through temporary table so that i can access that ids in >> other queries directly. >> >> Do you think the approach is right or there is any other good approach? >> >> Please suggest. >> >> Regards, >> Manoj >> > > > > -- > I'm a MySQL DBA in china. > More about me just visit here: > http://yueliangdao0608.cublog.cn >
Is Temporary table right approach
Hi All, I have a query which returns the large number of ids which i am using in other queries. I am doing this in PHP. Now the first query can return unlimited number of ids which might create problem in PHP. I want to store this ids in MYSQL through temporary table so that i can access that ids in other queries directly. Do you think the approach is right or there is any other good approach? Please suggest. Regards, Manoj
Re: Non-linear degradation in bulk loads?
Not sure but given that you suffer from non-linear degradation in performance;my guess is you might be extending your ibdata file every too frequently during the batch load process. Check the ibdata_data_file_path variable in my.cnf for more details. Cheers Manoj On 10/11/05, Jon Frisby <[EMAIL PROTECTED]> wrote: > Everyone, > > We're trying to do some bulk data loads on several different tables (on > several different machines, using several different techniques) and > seeing dramatically worse-than-linear performance. > > We've tried the bulk-INSERT syntax, and the LOAD DATA INFILE syntax. > We've done ALTER TABLE ... DISABLE KEYS, SET FOREIGN_KEY_CHECKS=0 (where > appropriate), and so forth. > > The one that is the most immediate concern is a table of the form: > > CREATE TABLE `test` ( > `email` varchar(255) NOT NULL default '', > `when_happened` datetime NOT NULL default '-00-00 00:00:00', > UNIQUE KEY `email` (`email`), > KEY `when_happened` (`when_happened`) > ) TYPE=InnoDB; > > I'm loading data using LOAD DATA INFILE with chunks containing 3.4m rows > each (~135MB files). The first chunk was very quick (about 1.5 > minutes), but the tenth chunk has taken 22.6 hours and is still going. > (It's been getting progessively slower with each chunk...) > > The database is our main sites database but we've dramatically reduced > the load on that machine over the past couple months through careful > optimization of our code. The box is a dual, dual-core Opteron, 8GB of > RAM running a 32-bit Linux 2.4 kernel and MySQL 4.0.20 (32-bit of > course). We have 1GB allocated to the buffer pool, and our usual 1GB * > 3 log files. 8 I/O threads. > > Load on the box sits at around 6-7, with a large (>50%) amount of time > spent in wait state, but actual disk throughput to our software RAID > array (No longer on a SAN...) is quite low -- 6-9k blocks/s out, 1-6k > blocks/s in. > > Something *has* to be wrong here, but we're not sure what we've missed. > We've restored larger data sets from a mysqldump in the past in > dramatically less time on far inferior hardware. (A superset of this > same data to a schema which is also a superset, PLUS a bunch of other > rather large tables -- all in ~8 hours on a 3Ware RAID array on a dual > Xeon w/ 4GB of RAM) > > We're inclined to believe that this is a configuration problem, as > opposed to a driver or hardware problem given the non-linear nature of > the performance degradation. This implies we're doing something truly > stupid with our loads. What could cause this kind of strangeness? > > -JF > > -- > 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]
Key Buffer Size
Greetings, In my database, all the tables use innodb engine. Since I don't use MYISAM, Is it safe to make the key_buffer size to 8 MB? To give you an idea of my database, I use Linux box with 6GB ram, MySQL version 4.0.15. Most of my configuration is in lines with my-huge.cnf. Thanks in advance for your help. Cheers Manoj -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Question on Join
Dear All, I am trying to join two tables say a & b. Both tables have a set of dates. I want to join the tables in such a fashion that I retrieve all dates from table A. If table b has corresponding data (for that date) then it will display it or else will display null. I am pretty sure that I can solve this using left outer join but am not able to get it working hence any help would be appreciated! Cheers Manoj -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Question on Indices
Greetings, I am trying to get a feel of how MySQL would handle certain types of situation, mainly concerning the usage of indices. Say I have two exactly identical table structures namely table A & B. For table A, I just have one composite primary key on (Code, Date1 & Date2). For table B, I just have composite primary key on (Code, Date1 & Date2) and two non-unique keys on Date1 & Date2. Question is, Will I find any performance improvement with table B, If all my queries start with Code field ? In other words : Will there be any noticiable difference in speed for query "Select * from tableB where code = cd and dt1 > $one_year_ago" over the same query on tableA ? Kindly note that we might have 1000 or more records for each code. When I tried to do an explain, it suggested in both the cases (on tableA & on tableB) that It will use composite primary key (mainly because left most field in the primary index is avaliable)suggesting that the non-unique indices are pretty much a waste of space...Is that really the case? Woudln't it be "optimal" to use primary key + non-unique key combination to narrow down the search? I would greatly appreciate your insight in this issue. TIA Manoj -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Innodb Performance Measurement
Greetings, I am using MySQL 4.0.24 and all my tables use InnoDB as default engine. I was interested in finding out the performance of my Buffer space. How can i do it?. If I were to use MyISQM tables, I could have looked at the parameters Key_read_request & key_reads to find out the hit rate but am not aware of how to do the same for Innodb hence any help would be appreciated. Cheers Manoj -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
(Fine) Tuning Server Parameters
Dear All, I am trying to tweak some server parameters to fine tune my MySQL (4.0.15) server on a linux box (with 6GB of ram) All my tables/databases use InnoDB. My question is : What is the InnoDB equivalent of the server parameters "Key_read_request & key_reads". I had a look at show innodb status to get an idea of these parameters but got lost in all the information provided by show innodb status, hence would appreciate any pointers! My entire my.cnf is as below for reference/additional comments that would be useful in fine-tuning server parameters. Thanks for your help in advance. Cheers Manoj -- [client] port=3306 socket=/tmp/mysql.sock [mysqld] user=mysql port=3306 key_buffer=256M table_cache=512 sort_buffer=8M join_buffer_size=8M read_buffer_size=8M read_rnd_buffer_size=6M max_connection=30 max_allowed_packet= 16M binlog_cache_size = 4M default-table-type=innodb log_slow_queries=/home/mysql/log/slow.query.log log_error=/home/mysql/log/mysqld.err.log log_long_format long_query_time = 10 query_cache_size = 256M query_cache_limit = 16M tmp_table_size = 400M thread_cache = 8 thread_concurrency = 8 # innodb_options innodb_data_home_dir=/usr/local/mysql/ibdata/ innodb_data_file_path=ibdata1:5G;ibdata2:1G:autoextend innodb_mirrored_log_groups=1 innodb_log_group_home_dir=/usr/local/mysql/ibdata/log innodb_log_arch_dir=ibdata/log innodb_log_files_in_group=2 innodb_log_file_size=1500M innodb_log_buffer_size=16M innodb_buffer_pool_size=1500M innodb_additional_mem_pool_size=4M innodb_flush_log_at_trx_commit=0 innodb_flush_method=O_DIRECT -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
might be a cilly question to u -execuse me.
Hello Friends, i am new to mysql and plz don't treat my question as a cilly as i am just getting into mysql. my problem is: when i am executing the following query i am getting the error. whats wrong with the query? "desc" of table "accounting" and "user" and contents of them are also listed below. mysql version is : mysql Ver 11.18 Distrib 3.23.54, for redhat-linux-gnu (i386) mysql> select *from accounting where uid = (select uid from user wher gid="apswan"); ERROR 1064: You have an error in your SQL syntax near 'select uid from user wher gid="apswan")' at line 1 mysql> mysql> desc user; +---+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-+---+ | uid | varchar(20) | | PRI | | | | gid | varchar(20) | YES | | NULL| | | comment | text| YES | | NULL| | | password | varchar(35) | YES | | NULL| | | enable| varchar(35) | YES | | NULL| | | gpassword | varchar(35) | YES | | NULL| | | arap | varchar(35) | YES | | NULL| | | pap | varchar(35) | YES | | NULL| | | chap | varchar(35) | YES | | NULL| | | mschap| varchar(35) | YES | | NULL| | | expires | datetime| YES | | NULL| | | b_author | varchar(20) | YES | | NULL| | | a_author | varchar(20) | YES | | NULL| | | svc_dflt | int(4) | YES | | NULL| | | maxsess | int(4) | YES | | NULL| | | user | int(1) | YES | | NULL| | | acl_id| int(4) | YES | | NULL| | | sess | int(4) | YES | | NULL| | +---+-+--+-+-+---+ 18 rows in set (0.05 sec) mysql> desc accounting; +--+--+--+-+-+---+ | Field| Type | Null | Key | Default | Extra | +--+--+--+-+-+---+ | date | datetime | | MUL | -00-00 00:00:00 | | | nas | varchar(16) | | MUL | | | | uid | varchar(20) | | MUL | | | | terminal | varchar(20) | YES | | NULL | | | client_ip| varchar(16) | | MUL | | | | type | varchar(20) | YES | | NULL | | | service | varchar(20) | YES | | NULL | | | priv_lvl | int(2) | YES | | NULL | | | cmd | varchar(255) | YES | | NULL | | | elapsed_time | int(6) | YES | | NULL | | | bytes_in | int(10) | YES | | NULL | | | bytes_out| int(10) | YES | | NULL | | +--+--+--+-+-+---+ 12 rows in set (0.00 sec) mysql> mysql> select * from user; +--+++++---+--+--+--++-+--+--+--+-+--++--+ | uid | gid| comment| password | enable | gpassword | arap | pap | chap | mschap | expires | b_author | a_author | svc_dflt | maxsess | user | acl_id | sess | +--+++++---+--+--+--++-+--+--+--+-+--++--+ | apswan || network admins | $1$.bJrxNDv$1JDyhV/kOwglyU7wVB1MH1 || NULL | | | || 2003-10-26 18:36:44 | | |0 | 0 |2 | 0 | NULL | | manoj| apswan | DNC Chittoor | $1$F6D75fPB$Mgu8OzHUZqzxzWsDSPoAT1 || NULL | | | || 2003-10-25 18:43:22 | | |0 | 0 |1 | 0 | NULL | | dncchitt | apswan | DNC Chittoo| $1$2pAHLzKV$qakvoD.PpZjWZh5u9TMiu. || NULL | | | || 2003-10-25 19:00:46 | welcome | bye bye |0 | 0 |1 | 0 | NULL | | snc | apswan | SNC Engineer | $1$rqG.1CUi$mkPT6tEMMtRrCcXbMH7Sp1 || NULL | | | || 2003-10-25 19:01:28 | | |0 | 0 |1 | 0 | NULL | +--+++++---+--+--+--++-+--+--+--+
Problem in Transaction handling
Hi, We are using MySQL database for our project, first time. We are facing some problem. Which are described below. * How to handle the transaction in MySQL. Presently when we are passing the autocommit as false, it gives error saying it is not allowed, in MySQL. We are not able to understand whether it is problem of configuration or there is some other way to handle the autocommit problem. * Not able to connect MySQL database server from remote client. Please tell us how we can handle this. Any suggestion on the above issues will be welcomed, because we are new to the MySQL environment. Hope to get some reply. Regards, Manoj Kumar * Disclaimer: The information in this e-mail and any attachments is confidential / privileged. It is intended solely for the addressee or addressees. If you are not the addressee indicated in this message, you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply email. Please advise immediately if you or your employer does not consent to Internet email for messages of this kind. * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL for Mac OS X Beta
I would like to know where I can get the MySQL build for Mac OS X Beta? Or, if anyone has built it from the source? Thanks, Manoj - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
