multiple instances in win 7 -- any idea
I'm trying to install multiple instances of mysql on windows 7, 64bit. 3hrs into the job, I'm not making progress. Does anyone have an idea? This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
RE: Myisam won't support replication in an MySQL Cluster environment
Hello Mr Reindl, Interestingly, over the years, I've been reading your postings and threads - without a doubt you're a major contributor. You've been very resourceful and helpful to your peers. We may never know what caused you to violently snap this time. However, I would encourage you to continue to be nice and respectful to others -- particularly others you don't know. While this forum provides an excellent opportunity for us to exchange and share our experiences in MySQL, yet we expect everyone to conduct themselves politely and restrain from ideological overtures. The thought that an intelligent individual like you would bring himself this low flies in the face of all rational behavior. Best regards, -Original Message- From: Reindl Harald [mailto:h.rei...@thelounge.net] Sent: Friday, May 04, 2012 3:23 AM To: mysql@lists.mysql.com Subject: Re: Myisam won't support replication in an MySQL Cluster environment Am 04.05.2012 06:45, schrieb Brown: > Does anyone have idea or experienced in MySQL Cluster configured for > bi-directional replication. Please advise me if you have to use NDBcluster > engine in order to get replication between the data nodes. I'm using MYISAM > on several tables that will not replicate. whould you please start to read DOCUMENTATIONS instead open permanently new threads for the same problem which has the root cause that it seems you are doing a job without any qualification for it you can not expectz a mailing-list to replace documentation and education in your job - really this is not the intention of a mailinglist and yes, if you still do not know how to act after reading docs hire somebody who knows and pay him money This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you.
Myisam won't support replication in an MySQL Cluster environment
Does anyone have idea or experienced in MySQL Cluster configured for bi-directional replication. Please advise me if you have to use NDBcluster engine in order to get replication between the data nodes. I'm using MYISAM on several tables that will not replicate. This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you.
Myisam won't support replication in an MySQL Cluster environment
Does anyone have idea or experienced in MySQL Cluster configured for bi-directional replication. Please advise me if you have to use NDBcluster engine in order to get replication between the data nodes. I'm using MYISAM on several tables that will not replicate. This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you.
Myisam won't support replication
I noticed that my replication stopped working after migrating to MySQL cluster. My current engine is myisam. Does anyone have an idea why repl won't work. Do I have to use the ndbengine? This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: mixing and matching mysql & mssql whileloop within an if case
Sent from my iPhone On May 3, 2012, at 1:02 PM, "Haluk Karamete" wrote: > Please take a look at the following code and tell me if there is a way > around it. > > if ($current_server_is_mysql): >while ($row = mysql_fetch_assoc($RS)) { > else: >while( $row = sqlsrv_fetch_array( $RS, SQLSRV_FETCH_ASSOC)){ > endif: > Depending on the server I'm working with, I'd like to compile my > records into the $RS recordset the proper/native way. If I can get > pass this part, the rest should be all right cause both mysql and > mssql $row can be tapped into the same way. For example, > $row['fieldname'] will give me the field value whether the row was a > mysql or mssql resource. So it all boils down to the above snippet > failing. > > The error I get points to the else: part in the above snippet. > > Parse error: syntax error, unexpected T_ELSE in > D:\Hosting\5291100\html\blueprint\pages\populate_migration_table.php > on line 415 > I can understand why I am getting this error. > > But, I'm hoping you guys can offer a work-around it without me > resorting to duplicate the entire while loop she-bang. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql > This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
master BIN-LOG maintenace
Hi Gurus, I would like to set BIN-LOG maintenance procedure for my master. The master is on a windows platform. I’m all for make it simple and clean therefore I’ve been leaning toward the automatic BIN-LOG removal “expire-logs-days=7”. The problem is for this option to work, it should be preceded by a “BIN-LOG FLUSH” command. Okay, where do I go from here in order to make this work. Please help me. Thanks This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you.
RE: using the bin-log approach on the master side, how can I accomplish my replication objectives
Hello Nitin, Please give Nitin a prize. What a quiet genius she is. Now, I get it. Now, I can see clearly. I’ve tried it and it worked. Thanks so much. From: Nitin Mehta [mailto:ntn...@yahoo.com] Sent: Wednesday, May 02, 2012 11:25 PM To: Brown, Charles Cc: mysql@lists.mysql.com Subject: Re: using the bin-log approach on the master side, how can I accomplish my replication objectives Hi Charles, I believe you would already have bin-log configured, is that right? If not, you need to. Secondly, If you think the bin-log generated for the entire stack of databases/schemas is too big, you may want to restrict it using "binlog-do-db" BUT that may create problem if you have any DMLs which run in the below manner: mysql> use db1; mysql> update db2.tb2 You may be surprised to find that this update will not be recorded in master's bin-log if you have set "binlog-do-db=db2". To sum it up, if you're not very sure, simply enable bin-log on master and use "replicate-do-table" on slave. So in one word response to your question, no! Hope that helps! Also, please reply to all so the people, helping you, know about the status of your problem. Regards, From: "Brown, Charles" mailto:cbr...@bmi.com>> To: Nitin Mehta mailto:ntn...@yahoo.com>> Sent: Thursday, May 3, 2012 9:27 AM Subject: RE: using the bin-log approach on the master side, how can I accomplish my replication objectives Hello Nitin, Help Me! Using your approach, do I have to put anything on the master “my.cnf”. Thanks From: Nitin Mehta [mailto:ntn...@yahoo.com] Sent: Wednesday, May 02, 2012 10:51 PM To: Brown, Charles; Rick James; a.sm...@ukgrid.net<mailto:a.sm...@ukgrid.net>; mysql@lists.mysql.com<mailto:mysql@lists.mysql.com> Subject: Re: using the bin-log approach on the master side, how can I accomplish my replication objectives I guess, it only makes things even more simple. You should use "replicate-do-table=db1.tb1" and so one in slave's cnf to ensure that only this particular table gets replicated. However, all the databases on master will get bin-logged and you may or may not want to do that. So making it even simpler: on the slave: replicate-do-table=db1.tb1 replicate-do-table=db2.tb2 replicate-do-table=db3.tb3 You might want to have a look at : http://dev.mysql.com/doc/refman/5.5/en/replication-options-slave.html#option_mysqld_replicate-do-table http://dev.mysql.com/doc/refman/5.5/en/replication-rules.html Hope this helps! From: "Brown, Charles" mailto:cbr...@bmi.com>> To: Rick James mailto:rja...@yahoo-inc.com>>; "a.sm...@ukgrid.net<mailto:a.sm...@ukgrid.net>" mailto:a.sm...@ukgrid.net>>; "mysql@lists.mysql.com<mailto:mysql@lists.mysql.com>" mailto:mysql@lists.mysql.com>> Sent: Thursday, May 3, 2012 8:51 AM Subject: using the bin-log approach on the master side, how can I accomplish my replication objectives Hello Rick, I think I'll go with your recommendations - but help me here a little bit. Because all look fuzzy like a brain surgery. So make it simple and clean for me. For the sake of simplicity, here is what my master has: Database: db1 Tables: db1tb1, db1tb2, db1tb3 Database: db2 Tables: db2tb1, db2tb2, db2tb3 Database: db3 Tables: db3tb1, db3tb2, db3tb3 Now, I would like to replicate only these tables that belong to respective databases: db1tb1, db2tb2, and db3tb3 My question is: using the bin-log approach on the master side, how can I accomplish my replication objectives? Help me Best regards and thanks This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you.
using the bin-log approach on the master side, how can I accomplish my replication objectives
Hello Rick, I think I'll go with your recommendations - but help me here a little bit. Because all look fuzzy like a brain surgery. So make it simple and clean for me. For the sake of simplicity, here is what my master has: Database: db1 Tables: db1tb1, db1tb2, db1tb3 Database: db2 Tables: db2tb1, db2tb2, db2tb3 Database: db3 Tables: db3tb1, db3tb2, db3tb3 Now, I would like to replicate only these tables that belong to respective databases: db1tb1, db2tb2, and db3tb3 My question is: using the bin-log approach on the master side, how can I accomplish my replication objectives? Help me Best regards and thanks This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you.
RE: Can the mysql replication limited to one database
Hello Rick, What goes into your my.cnf slave ? Given dbname1 and dbname2 -Original Message- From: Rick James [mailto:rja...@yahoo-inc.com] Sent: Wednesday, May 02, 2012 12:05 PM To: Brown, Charles Cc: mysql@lists.mysql.com Subject: RE: Can the mysql replication limited to one database Yes, doable. In my.cnf on master: Binlog-do-database = dbname1 Binlog-do-database = dbname2 Would replicate those two dbs only. There are many other combinations using binlog/replicate-do/ignore-db/table/wild. See the manual on replication, and especially the flowchart on how those interact (sometimes in unexpected ways). > -Original Message- > From: Brown, Charles [mailto:cbr...@bmi.com] > Sent: Wednesday, May 02, 2012 8:44 AM > To: Rick James > Cc: mysql@lists.mysql.com > Subject: Can the mysql replication limited to one database > > Hi Gurus, > > Can the mysql replication limited to selected schema or database? I've > been asked to set up mysql for only 1 out 5 databases exist in > production. Please advise if this is doable > > Thanks > > > This message is intended only for the use of the Addressee and may > contain information that is PRIVILEGED and CONFIDENTIAL. > > If you are not the intended recipient, you are hereby notified that > any dissemination of this communication is strictly prohibited. > > If you have received this communication in error, please erase all > copies of the message and its attachments and notify us immediately. > > Thank you. > This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: engine is now innoDB instead of MyISAM.
Well said. Thanks so much. Sent from my iPhone On Apr 29, 2012, at 8:02 AM, "Reindl Harald" wrote: > > > Am 29.04.2012 14:50, schrieb Brown: >> is a complain I received from one of my developer that after following our >> MySQL >> Cluster migration, tables are now defaulting to innodb (how can he tell) > > as already said: > > the builtin default has changed an you have to configure MyISAM > as default yourself with "default-storage-engine = myisam" > > and yes, InnoDB can be a big problem if your application is only > tested against MyISAM because it works completly different inside > > This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
RE: engine is now innoDB instead of MyISAM.
Hello Claudio, Thanks for quick response and the whitepaper. What precipitated my research and questions is a complain I received from one of my developer that after following our MySQL Cluster migration, tables are now defaulting to innodb ( how can he tell) and performance is poor. I'm very much concerned worried because my cnf doesn't reflect any parameter changes or tuning opportunities for innodb - I'm using all defaults since we are not using innodb storage engine. Our MySQL implementation is very simple and limited. Ours model most large IT shops meaning it provides nothing but a nice, fancy glossary front end ( meaning placed outside the cooperate fire wall). Inside this cooperate firewall resides myriads of industry strength databases and data structures. The white paper warns not to expect much from MySQL Cluster until it's optimized. Very little was said about Myisam. Most of the discussions were centered on innordb and NDB. Thus my objective is clearly laid out. I may have to convert all tables back to MyISAM or invest time in tuning. Your thoughts ? Lastly, can I bring over old performance parameters found in my.cnf. These are parameters that have sustain me over the years. Now, I'm doing MySql Cluster are they any more relevant. Best regards, From: Claudio Nanni [mailto:claudio.na...@gmail.com] Sent: Sunday, April 29, 2012 4:29 AM To: Brown, Charles Cc: mysql@lists.mysql.com Subject: Re: engine is now innoDB instead of MyISAM. Charles, the pleasure is all mine in meeting such a kind person as you are. To reply to your question, I would recommend to read frst a basic document about MySQL Cluster, like the whitepaper (http://kae.li/iiisv) so that you have an overview of the infrastructure. Consider that only the SQL node(that is just a regular MySQL instance) and the Management console have a client command to access the node and the command is different, the regular 'mysql' client command is used to access the SQL node (which as said is just a regular MySQL instance with added NDB support), and to access the management console the command is 'ndb_mgm'. You cannot access the Data nodes with a client command, those nodes communicate with other cluster nodes but not with the user. Please feel free to ask any further question. Thanks Claudio 2012/4/29 Brown, Charles mailto:cbr...@bmi.com>> Hello Claudio, In all honesty, the chances of coming into contact with an individual like you who has a grounded knowledge and an ability to articulate thoughts is perhaps a once in a life time experience. However, I meant "MySQL Cluster as a product" . How can one identify these three different types of nodes. Are there any useful diagnostics command that I can issue in order to identify which node is Data, Management or SQL node. Please assist me. See below for the logon messages Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 374141 Server version: 5.5.19-ndb-7.2.4-gpl MySQL Cluster Community Server (GPL) Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> From: Claudio Nanni [mailto:claudio.na...@gmail.com<mailto:claudio.na...@gmail.com>] Sent: Saturday, April 28, 2012 2:48 PM To: Brown, Charles Cc: mysql@lists.mysql.com<mailto:mysql@lists.mysql.com> Subject: Re: engine is now innoDB instead of MyISAM. Charles, first, my opinion is that if you are paying Oracle you should get answers from them about this, and then of course is good to have a second opinion here. Related to your specific question you should specify what you mean with 'clustering' which is a generic term, if with it you mean "MySQL Cluster" product then you have to know that this implementation of database cluster is based on a specific storage engine called Network DataBase (NDB), so you can't choose another engine for it. The default storage engine in the SQL nodes of a MySQL Cluster can be any storage engine and whether it be MyISAM, InnoDB, NDB and it's a design decision, but only NDB tables will benefit from the clustering capabilities. I hope I got your question right and that this shed a bit more light for you. Cheers Claudio 2012/4/28 Brown, Charles mailto:cbr...@bmi.com>> The question is, is it advisable to change the default engine of a cluster setting to Myisam? Does anyone have an opinion or experience on this issue? Do I have choice when it comes to clustering on which type engine supports clustering. Thanks -Original Message- From: Reindl Harald [mailto:h.rei...@thelounge.net<mailto:h.rei...@thelounge.net>] Sent:
RE: engine is now innoDB instead of MyISAM.
The question is, is it advisable to change the default engine of a cluster setting to Myisam? Does anyone have an opinion or experience on this issue? Do I have choice when it comes to clustering on which type engine supports clustering. Thanks -Original Message- From: Reindl Harald [mailto:h.rei...@thelounge.net] Sent: Saturday, April 28, 2012 3:01 AM To: mysql@lists.mysql.com Subject: Re: engine is now innoDB instead of MyISAM. Am 28.04.2012 09:00, schrieb Brown: > We recently switched from MySQL community to Mysql clustered using Oracle > supported MySQl. The problem is, during our testing phase, we observed the > default engine is now innoDB instead of MyISAM. Any thoughts on that? We're > not getting the performance that we expected - any thoughts or advices out > there will be greatly appreciated. my.cnf: default-storage-engine = myisam you cann not compare MyISAm and InnoDB for the same workloads that's why my.cnf exists and we usually define each known setting to prevent chnages in the behavior of applications by software-updates the same for "php.ini" This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
engine is now innoDB instead of MyISAM.
Hello all, We recently switched from MySQL community to Mysql clustered using Oracle supported MySQl. The problem is, during our testing phase, we observed the default engine is now innoDB instead of MyISAM. Any thoughts on that? We're not getting the performance that we expected - any thoughts or advices out there will be greatly appreciated. Thanks This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
RE: One inst has 39 columns- the other 40
Thanks all -- it was a version problem. My sysprog person is going to re down load from Oracle. Thanks again for all the wonderful help. -Original Message- From: Reindl Harald [mailto:h.rei...@thelounge.net] Sent: Thursday, March 22, 2012 4:25 AM To: mysql@lists.mysql.com Subject: Re: One inst has 39 columns- the other 40 Am 22.03.2012 05:41, schrieb Brown: > Look man, there has to be someone out there that can tell me why one > user table has 5 extra columns. Is it version related or my sysprog > person missed out on a step. Its hard to believe that this problem is unique > to my site. logically is it version-dependent that is why you have to run "mysql_upgrade -u root -p" after updates > pluginchar(64)YES exists only on recent mysql versions as example This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
RE: One inst has 39 columns- the other 40
Look man, there has to be someone out there that can tell me why one user table has 5 extra columns. Is it version related or my sysprog person missed out on a step. Its hard to believe that this problem is unique to my site. Hostchar(60)NO PRI Userchar(16)NO PRI Passwordchar(41)NO Select_priv enum('N','Y') NO N Insert_priv enum('N','Y') NO N Update_priv enum('N','Y') NO N Delete_priv enum('N','Y') NO N Create_priv enum('N','Y') NO N Drop_priv enum('N','Y') NO N Reload_priv enum('N','Y') NO N Shutdown_priv enum('N','Y') NO N Process_privenum('N','Y') NO N File_priv enum('N','Y') NO N Grant_priv enum('N','Y') NO N References_priv enum('N','Y') NO N Index_priv enum('N','Y') NO N Alter_priv enum('N','Y') NO N Show_db_privenum('N','Y') NO N Super_priv enum('N','Y') NO N Create_tmp_table_priv enum('N','Y') NO N Lock_tables_privenum('N','Y') NO N Execute_privenum('N','Y') NO N Repl_slave_priv enum('N','Y') NO N Repl_client_privenum('N','Y') NO N Create_view_privenum('N','Y') NO N Show_view_priv enum('N','Y') NO N Create_routine_priv enum('N','Y') NO N Alter_routine_priv enum('N','Y') NO N Create_user_privenum('N','Y') NO N Event_priv enum('N','Y') NO N Trigger_privenum('N','Y') NO N Create_tablespace_priv enum('N','Y') NO N ssl_typeenum('','ANY','X509','SPECIFIED') NO ssl_cipher blobNO x509_issuer blobNO x509_subjectblobNO max_questions int(11) unsignedNO 0 max_updates int(11) unsignedNO 0 max_connections int(11) unsignedNO 0 max_user_connectionsint(11) unsignedNO 0 plugin char(64)YES authentication_string textYES Hostchar(60)NO Userchar(16)NO Passwordchar(41)NO Select_priv enum('N','Y') NO N Insert_priv enum('N','Y') NO N Update_priv enum('N','Y') NO N Delete_priv enum('N','Y') NO N Create_priv enum('N','Y') NO N Drop_priv enum('N','Y') NO N Reload_priv enum('N','Y') NO N Shutdown_priv enum('N','Y') NO N Process_privenum('N','Y') NO N File_priv enum('N','Y') NO N Grant_priv enum('N','Y') NO N References_priv enum('N','Y') NO N Index_priv enum('N','Y') NO N Alter_priv enum('N','Y') NO N Show_db_privenum('N','Y') NO N Super_priv enum('N','Y') NO N Create_tmp_table_priv enum('N','Y') NO N Lock_tables_privenum('N','Y') NO N Execute_privenum('N','Y') NO N Repl_slave_priv enum('N','Y') NO N Repl_client_privenum('N','Y') NO N Create_view_privenum('N','Y') NO N Show_view_priv enum('N','Y') NO N Create_routine_priv enum('N','Y') NO N Alter_routine_priv enum('N','Y') NO N Create_user_privenum('N','Y') NO N ssl_typeenum('','ANY','X509','SPECIFIED') NO ssl_cipher blobNO x509_issuer blobNO x509_subjectblobNO max_questions int(11) unsignedNO 0 max_updates int(11) unsignedNO 0 max_connections int(11) unsignedNO 0 max_user_connectionsint(11) unsignedNO 0 -Original Message- From: Rik Wasmus [mailto:r...@grib.nl] Sent: Wednesday, March 21, 2012 5:0
tables do not have the same number of columns.
I have two mysql instances in my mysql cluster. I noticed that their MysSQL.user tables do not have the same number of columns. See below for their attributes. Is anyone out there has any idea why these tables are not the same? Can someone help me. Hostchar(60)NO Userchar(16)NO Passwordchar(41)NO Select_priv enum('N','Y') NO N Insert_priv enum('N','Y') NO N Update_priv enum('N','Y') NO N Delete_priv enum('N','Y') NO N Create_priv enum('N','Y') NO N Drop_priv enum('N','Y') NO N Reload_priv enum('N','Y') NO N Shutdown_priv enum('N','Y') NO N Process_privenum('N','Y') NO N File_priv enum('N','Y') NO N Grant_priv enum('N','Y') NO N References_priv enum('N','Y') NO N Index_priv enum('N','Y') NO N Alter_priv enum('N','Y') NO N Show_db_privenum('N','Y') NO N Super_priv enum('N','Y') NO N Create_tmp_table_priv enum('N','Y') NO N Lock_tables_privenum('N','Y') NO N Execute_privenum('N','Y') NO N Repl_slave_priv enum('N','Y') NO N Repl_client_privenum('N','Y') NO N Create_view_privenum('N','Y') NO N Show_view_priv enum('N','Y') NO N Create_routine_priv enum('N','Y') NO N Alter_routine_priv enum('N','Y') NO N Create_user_privenum('N','Y') NO N ssl_typeenum('','ANY','X509','SPECIFIED') NO ssl_cipher blobNO x509_issuer blobNO x509_subjectblobNO max_questions int(11) unsignedNO 0 max_updates int(11) unsignedNO 0 max_connections int(11) unsignedNO 0 max_user_connectionsint(11) unsignedNO 0 Another user table Hostchar(60)NO PRI Userchar(16)NO PRI Passwordchar(41)NO Select_priv enum('N','Y') NO N Insert_priv enum('N','Y') NO N Update_priv enum('N','Y') NO N Delete_priv enum('N','Y') NO N Create_priv enum('N','Y') NO N Drop_priv enum('N','Y') NO N Reload_priv enum('N','Y') NO N Shutdown_priv enum('N','Y') NO N Process_privenum('N','Y') NO N File_priv enum('N','Y') NO N Grant_priv enum('N','Y') NO N References_priv enum('N','Y') NO N Index_priv enum('N','Y') NO N Alter_priv enum('N','Y') NO N Show_db_privenum('N','Y') NO N Super_priv enum('N','Y') NO N Create_tmp_table_priv enum('N','Y') NO N Lock_tables_privenum('N','Y') NO N Execute_privenum('N','Y') NO N Repl_slave_priv enum('N','Y') NO N Repl_client_privenum('N','Y') NO N Create_view_privenum('N','Y') NO N Show_view_priv enum('N','Y') NO N Create_routine_priv enum('N','Y') NO N Alter_routine_priv enum('N','Y') NO N Create_user_privenum('N','Y') NO N Event_priv enum('N','Y') NO N Trigger_privenum('N','Y') NO N Create_tablespace_priv enum('N','Y') NO N ssl_typeenum('','ANY','X509','SPECIFIED') NO ssl_cipher blobNO x509_issuer blobNO x509_subjectblobNO max_questions int(11) unsignedNO 0 max_updates int(11) unsignedNO 0 max_connections int(11) unsignedNO 0 max_user_connectionsint(11) unsignedNO 0 plugin char(64)YES authentication_string textYES This message is
RE: One inst has 39 columns- the other 40
I have two mysql instances in my mysql cluster. I noticed that their MysSQL.user tables do not have the same number of columns. Their USER table attributes are not the same. One instance has 39 columns while the other has 42 columns. Can someone please help me here. Could it be because I'm running mysql cluster? Can someone help me. Thanks This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
One inst has 39 columns- the other 40
I have two mysql instances in my mysql cluster. I noticed that their MysSQL.user tables do not have the same number of columns. Their USER table attributes are not the same. One instance has 39 columns while the other has 42 columns. Can someone please help me here. Could it be because I'm running mysql cluster? Can someone help me. Thanks This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
One inst has 39 columns- the other 40
I have two mysql instances in my mysql cluster. I noticed that their MysSQL.user tables do not have the same number of columns. Their USER table attributes are not the same. One instance has 39 columns while the other has 42 columns. Can someone please help me here. Could it be because I'm running mysql cluster? Can someone help me. Thanks This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
RE: how to sync mysql.user table between to two mysql instances
Hello johan Here is what did the trick for me: 1. in mysql-inst1, I created like table called test.user 2. I used mysqldump to pipe test.user table from mysql-inst1 to mysql-inst2 3. in mysql-inst2, I did insert into mysql.user select from test.user We are migrating from master-slave replication to mysql cluster. My sysprog person has been doing all the work. I was told in a clustered environment, replication should happen automatically -- I'm still waiting for my mysql.user table to automatically syncs itself. A long wait it has been. Thanks -Original Message- From: Johan De Meersman [mailto:vegiv...@tuxera.be] Sent: Friday, March 16, 2012 5:00 PM To: Baron Schwartz Cc: MySql Subject: Re: how to sync mysql.user table between to two mysql instances - Original Message - > From: "Baron Schwartz" > > 1. With mysqldump. mysqldump -hmysql-inst1 mysql | mysql > -hmysql-inst2 mysql And then, of course, issue a FLUSH PRIVILEGES on mysql-inst2 :-) -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
RE: how to sync mysql.user table between to two mysql instances
Hello David, Precisely, that's what my problem is. The users found in mysqlinst1 are not in mysqlinst2. There are about 30 users defined in inst1 and only 4 in inst2. I would like to sync these tables. How do you do it in short of creating 26 accounts in mysqlinst2 one at a time - too tedious. Help me I'm running out of time. -Original Message- From: David Lerer [mailto:dle...@us.univision.com] Sent: Friday, March 16, 2012 1:36 PM To: Baron Schwartz; MySql; Brown, Charles Subject: RE: how to sync mysql.user table between to two mysql instances As a follow up question, will it be ok to do the following: 1. mysqldump -hmysql-inst2 mysql 2. Backup mysql-inst1 and use the backup to restore to mysql-inst2 3. mysql -hmysql-inst2 mysql This way I hope to be able to refresh a DEV instance from a PROD database, but preserve the permissions, users, passwords, etc (Assuming of course that the schemas are identical on the two instances). Thanks, David. -Original Message- From: baron.schwa...@gmail.com [mailto:baron.schwa...@gmail.com] On Behalf Of Baron Schwartz Sent: Friday, March 16, 2012 2:20 PM To: MySql Subject: Re: how to sync mysql.user table between to two mysql instances Charles, 1. With mysqldump. mysqldump -hmysql-inst1 mysql | mysql -hmysql-inst2 mysql 2. With pt-table-sync from Percona Toolkit if you need something more sophisticated. On Fri, Mar 16, 2012 at 1:27 PM, Brown, Charles wrote: > Can someone instruct me on how to sync mysql.user table between to two mysql > instances. > In other words, I wouild like to copy mysql.user from mysql-inst1 to > mysql-inst2 + -- Baron Schwartz Win free MySQL conference tickets! http://goo.gl/mvZ4W -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql The information contained in this e-mail and any attached documents may be privileged, confidential and protected from disclosure. If you are not the intended recipient you may not read, copy, distribute or use this information. If you have received this communication in error, please notify the sender immediately by replying to this message and then delete it from your system. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
how to sync mysql.user table between to two mysql instances
Can someone instruct me on how to sync mysql.user table between to two mysql instances. In other words, I wouild like to copy mysql.user from mysql-inst1 to mysql-inst2 + Thanks This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you.
RE: need help with -- unknown variable
Hello ~ Thanks Andrew - it worked. It worked after I commented it out on my.cnf file. Any idea what's the purpose of that statement. I inherited this system. Thanks all for quick response [mysqld] server-id=2 relay-log=naxbmisq04-relay-bin set-variable=max_connect_error=100 max_allowed_packet=1048576000 thread_cache_size=16 max_connections=200 query_cache_type=1 query_cache_size=32768000 table_cache=800 max_heap_table_size=32768000 [mysqldump] max_allowed_packet=1048576000 #datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid From: Andrew Moore [mailto:eroomy...@gmail.com] Sent: Monday, June 13, 2011 11:13 AM To: Brown, Charles Cc: mysql@lists.mysql.com Subject: Re: need help with -- unknown variable Check if this is in the [mysqldump] section of your my.cnf file(s). Of course it might not be a valid option in mysqldump...I haven't checked... On 13 Jun 2011 17:00, "Brown, Charles" mailto:cbr...@bmi.com>> wrote: > Hello All ~ I attempted to do a mysqldump when I got this message -- see > below: > > mysqldump: unknown variable 'datadir=/var/lib/mysql' > > Please can someone help me. > > Thanks > > > > > > > This message is intended only for the use of the Addressee and > may contain information that is PRIVILEGED and CONFIDENTIAL. > > If you are not the intended recipient, you are hereby notified > that any dissemination of this communication is strictly prohibited. > > If you have received this communication in error, please erase > all copies of the message and its attachments and notify us > immediately. > > Thank you. > This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you.
need help with -- unknown variable
Hello All ~ I attempted to do a mysqldump when I got this message -- see below: mysqldump: unknown variable 'datadir=/var/lib/mysql' Please can someone help me. Thanks This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you.
RE: high load averages on mysql server ...
Hello All ~ I'm experiencing some high load averages on mysql server between the hrs 9am - noon. We don't have the MySQL optimal performance monitor. I'm wondering whether if there's a log or an area that I should be looking at to get an idea of what the problem going on with MySQL. Thanks This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
high load averages on mysql server ...
Hello All ~ I'm experiencing some high load averages on mysql server between the hrs 9am - noon. We don't have the MySQL optimal performance monitor. I'm wondering whether if there's a log or an area that I should be looking at to get an idea of what the problem going on with MySQL. Thanks This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
mysqld_safe
Hello All. when I issued this command: ps -e | grep, I noticed that mysqld_safe was up running in my system. My question is: what is mysqld_safe and why was it running. Please help. [sp...@naxbmisq03 ~]$ ps -e | grep -i mysql 11989 ?00:00:00 mysqld_safe 12025 ?13:28:39 mysqld This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
host variables
Can someone help me. I am trying to make calls to Mysql from VBscript via ASP But I'm experiencing difficulties with passing host variables to mysql See examples below isbn =34373 sql= "select isbn, book_title, publisher_name FROM cs443.books_available where isbn= " &isbn The above works but the below doesn't return any thing Dim pubname Pubname = "Bantam Books" sql= "select isbn, book_title, publisher_name FROM cs443.books_available where publisher_name =" &pubname This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
with passing host variables to mySQL
Can someone help me. I am trying to make calls to Mysql from VBscript via= =20ASP But I'm experiencing difficulties with passing host variables to my SQL=20 See example below isbn =3D 717192=20 sql=3D "select isbn, book_title, publisher_name FROM cs443.books_availabl= e where isbn=3D " &isbn The above works but the below doesn't return any thing Dim pubname Pubname =3D "Bantam Books" sql=3D "select isbn, book_title, publisher_name FROM cs443.books_availabl= e where publisher_name =3D " &pubname=20 This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: cannot find my.cnf file
Please look in /etc/my.cnf If not found create one. Of cause, MySQL can start and run without a 'my.cnf' file that’s why you couldn't find one. In the absence of the my.cnf file, MySQL will use default for every parameter . Charles, -Original Message- From: walter harms [mailto:wha...@bfs.de] Sent: Friday, November 13, 2009 2:44 AM To: Sydney Puente Cc: mysql@lists.mysql.com Subject: Re: cannot find my.cnf file Sydney Puente schrieb: > Hello, > I want to log all sql queries made against a mysql db. > Googled and found I should add a line to my.cnf. > > However I cannot find a my.cnf file > [r...@radium init.d]# ps -ef | grep mysql > root 13614 1 0 Sep24 ?00:00:00 /bin/sh /usr/bin/mysqld_safe > --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/object01.pid > mysql13669 13614 0 Sep24 ?00:21:40 /usr/sbin/mysqld --basedir=/ > --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/object01.err > --pid-file=/var/lib/mysql/object01.pid > root 23050 22746 0 19:05 pts/000:00:00 grep mysql > [r...@radium init.d]# locate cnf > /usr/share/doc/MySQL-server-community-5.1.39/my-huge.cnf > /usr/share/doc/MySQL-server-community-5.1.39/my-innodb-heavy-4G.cnf > /usr/share/doc/MySQL-server-community-5.1.39/my-large.cnf > /usr/share/doc/MySQL-server-community-5.1.39/my-medium.cnf > /usr/share/doc/MySQL-server-community-5.1.39/my-small.cnf > /usr/share/man/man8/cnfsheadconf.8.gz > /usr/share/man/man8/cnfsstat.8.gz > /usr/share/ssl/openssl.cnf > /usr/share/mysql/my-large.cnf > /usr/share/mysql/my-huge.cnf > /usr/share/mysql/my-innodb-heavy-4G.cnf > /usr/share/mysql/my-medium.cnf > /usr/share/mysql/my-small.cnf > Any ideas? > I might add i did not install mysql and I did not start it and the guy who > did is in holiday! > Systemwide config files are always in /etc/ (see: man hier). re, wh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=cbr...@bmi.com This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you.
RE: socket '/tmp/mysql.sock' (2)
From: Brown, Charles Sent: Tuesday, November 03, 2009 2:54 PM To: Ramsey, Robert L; mysql@lists.mysql.com Subject: socket '/tmp/mysql.sock' (2) Hello All, I desperately need your help. I migrated from version 5.0.27 To version 5.0.77 Here is the command I used to migrate my databases: mysqldump -ux -px --all-databases --master-data | mysql -h88.88.89.889 -ur -px Problem: after the migration, I have been getting these messages: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) My question is, is it possible that I have destroyed ( clobbered) the MYSQL catalog via my migration process? Can someone please help me This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
socket '/tmp/mysql.sock' (2)
Hello All, I desperately need your help. I migrated from version 5.0.27 To version 5.0.77 Here is the command I used to migrate my databases: mysqldump -ux -px --all-databases --master-data | mysql -h88.88.89.889 -ur -px Problem: after the migration, I have been getting these messages: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) My question is, is it possible that I have destroyed ( clobbered) the MYSQL catalog via my migration process? Can someone please help me This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: MYSQL slow query log in table.
Hello. Thanks for quick response. I'm running Mysql 5.0. We have no plans to upgrade to 5.1 that supports slow-log table. Do you know of any work around to get my slow query into a table -- just wondering. Desperate for a resolution or circumvention. -Original Message- From: Jaime Crespo Rincón [mailto:jcre...@warp.es] Sent: Thursday, October 08, 2009 10:17 AM To: Brown, Charles Cc: Daevid Vincent; mysql@lists.mysql.com Subject: Re: MYSQL slow query log in table. 2009/10/7 Brown, Charles : > Hello All. I would like to implement MYSQL slow query log in table. Can > someone kindly assist me with the table definition and implementation. SHOW CREATE TABLE mysql.slow_log; <http://dev.mysql.com/doc/refman/5.1/en/log-tables.html> -- Jaime Crespo MySQL & Java Instructor Warp Networks <http://warp.es> This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you.
MYSQL slow query log in table.
Hello All. I would like to implement MYSQL slow query log in table. Can someone kindly assist me with the table definition and implementation. Thanks so much in advance This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Questions on un-index searches and slow-query-log
Questions Folks: (1) What do you about un-index searches. How can one report and monitor them? (2) What do you do with the slow-query log. Are there any utilities or scripts out there to filter and manage this log? Thanks This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Failed to initialize the master info structure
Can someone tell me why I am getting this message whenever I issued a "CHANGE MASTER" command? @4000489f38462d0bedd4 080810 13:49:32 [ERROR] Failed to initialize the master info structure Thanks This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: can some please help me -- REPLICATION
Here is what I'm getting mysql> change master to master_host = 'naxbmisq01.bmi.com', master_user = 'repl', master_password = 'repl'; ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in the MySQL error log mysql> reset slave; Query OK, 0 rows affected (0.00 sec) mysql> change master to master_host = 'naxbmisq01.bmi.com', master_user = 'repl', master_password = 'repl'; ERROR 29 (HY000): File './naxbmisq02-relay-bin.000157' not found (Errcode: 2) mysql> -Original Message- From: David Giragosian [mailto:[EMAIL PROTECTED] Sent: Sunday, August 10, 2008 12:54 PM To: mysql@lists.mysql.com Subject: Re: can some please help me -- REPLICATION On 8/10/08, Jim Lyons <[EMAIL PROTECTED]> wrote: > > you should probably just resync your slave. If it hasn't run for over a > month then there's not a lot of point in trying to start it up. Even if > you > did start the slave (which seems doubtful) you'd have over a month's worth > of commands to make up. > > > You can tell mysql to not keep relay logs that have already been used. What's the command or setting for this action? --David. This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: can some please help me -- REPLICATION
Re: You can tell mysql to not keep relay logs that have already been used. What command does this -Original Message- From: David Giragosian [mailto:[EMAIL PROTECTED] Sent: Sunday, August 10, 2008 12:54 PM To: mysql@lists.mysql.com Subject: Re: can some please help me -- REPLICATION On 8/10/08, Jim Lyons <[EMAIL PROTECTED]> wrote: > > you should probably just resync your slave. If it hasn't run for over a > month then there's not a lot of point in trying to start it up. Even if > you > did start the slave (which seems doubtful) you'd have over a month's worth > of commands to make up. > > > You can tell mysql to not keep relay logs that have already been used. What's the command or setting for this action? --David. This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
can some please help me -- REPLICATION
The background: We are doing replication. The file-system containing the SLAVE's relay-log got filled to capacity. Later on, I noticed replication has not been working for the last month or more. My Action: I deleted the 2 oldest relay-log then attempted to restart SLAVE. Now, the SLAVE will not start. Replication will not start. The SLAVE continues to request for those logs. My Question: What instructions/command can I issue to the SLAVE so it can ignore relay-logs not found? See below for msg I have been getting from the SLAVE -- for all attempts to restart. 080809 2:09:23 [ERROR] Failed to open the relay log 'FIRST' (relay_log_pos 4) 080809 2:09:23 [ERROR] Could not open log file 080809 2:13:58 [ERROR] Error reading master configuration 080809 2:29:49 [ERROR] Error reading master configuration 080809 7:31:40 [ERROR] Error reading master configuration 080809 7:57:32 [ERROR] Failed to open log (file './naxbmisq02-relay-bin.000157', errno 2) 080809 7:57:32 [ERROR] Failed to open the relay log 'FIRST' (relay_log_pos 4) 080809 7:57:32 [ERROR] Could not open log file 080809 8:01:27 [ERROR] Error reading master configuration 080809 8:11:42 [ERROR] Error reading master configuration This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Could not initialize master info structure;
Could not initialize master info structure; Can someone help me. I am getting the above message This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
relay-bin.000157' not found
Please advise me on how to restart MYSQL slave instance. All efforts have failed. When I issued the "START SLAVE" command it came back with an error -- see below. ERROR 29 (HY000): File './naxbmisq02-relay-bin.000157' not found (Errcode: 2 I inadvertently deleted this file. Thanks This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you.
'mysql.servers' doesn't exist
Hey Folks. I'm getting this error -- I need your input or help. 080320 15:02:16 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist 080320 15:02:16 [Note] Event Scheduler: Loaded 0 events 080320 15:02:16 [Note] E:\Apps\Standard\HPRUM\MYSQL\bin\mysqld: ready for connections. Version: '5.1.23-rc-community' socket: '' port: 3306 MySQL Community Server (GPL) This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Security overrides in mysql.cnf
I inherited a mysql server database. Stuff are not documented. My question is: Are there any security work-arounds in mysql. I have access to the cnf file. I need to get in and dump the database. I was told that the cnf file allows security over rides. Please help I have tried mysql -uroot. It didn't work This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Are user privileges included in MYSQLDUMP
Using mysqldump, I'm about to dump all databases and import to another instance - new . My question is do I need to define all security and users in the new mysql or the security definitions and privileges will be included in the dump file created by mysqldump. What is the function of mysql_fix_privilege_tables after importing the dumpfile. I am confused here - Please help me! Please help me! This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you.
RE: mysql privileges
Here is a follow-up question: Using mysqldump, I'm about to dump all databases and import to another instance - new . My question is do I need to define all security and users in the new mysql or the security definitions and privileges will be included in the dump file created by mysqldump. Please help me! -Original Message- From: Sebastian Mendel [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 19, 2008 1:24 AM To: mysql@lists.mysql.com Subject: Re: mysql privileges Malka Cymbalista schrieb: > Thanks for your reply. When I do show grants, I get back > > GRANT SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES ON *.* TO 'super' @ 'localhost' ( mailto:super'@ 'localhost' ) identified by password... > > So it looks like super doesn't have rights to select from the hr table. But why not? According to the tables_priv table, super should have right to select. did you export/import your data, or just copied the data files from your old to the new MySQL? did you reload privileges after changes? FLUSH PRIVILEGES; -- Sebastian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
If I downgrade MySQL from ver-5 to ver-4.
Hello. Can someone tell me if I will run into any problems? 1. If I downgrade MySQL from ver-5 to ver-4. 2. If I run replication between version 4 and version 5 of the software. Meaning slave is version 4 and the master is version 5. Some back ground: We have replication implemented. Currently, both are running version 5.0.29. My management wants one of these servers to run version 4. (Don't ask me why). Will there be any repercussions. Please help me. I need to provide an answer before 8am Monday. Thanks My management suggests we down grade to RHEl 4 of mySQl -Original Message- From: Paolo Amodio [mailto:[EMAIL PROTECTED] Sent: Friday, February 08, 2008 3:09 PM To: MySQL Subject: Re: Where are actual databases stored? Il giorno 08/feb/08, alle ore 21:55, Riccardo Perotti ha scritto: > Hi all: > > Our sistem crashed and we're trying to recover our data. The disc is > fine but the OS is gone, so I'm trying to get at the actual mysql > databases document. Does anybody know where to look for them in a > *nix system? > > Thanks, > > Riccardo > > -- > [EMAIL PROTECTED] > www.riccardoperotti.com > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql? > [EMAIL PROTECTED] > > Usually in /usr/local/mysql/data but it'snt a standard. What's your distro? See you Paolo Amodio [EMAIL PROTECTED] www.dixienet.it -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
show slave status
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 often, I would logon to MySQl and issue this command: "SHOW SLAVE STATUS". I would like to automate this process. I would like to parse the output of this command and look pertinent info such as "seconds_behind_master" < 10. If it greater than 10, then I'll send out an email saying replication is in error. Charles This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you.
RE: executing query from the command line -- need help
thanks -Original Message- From: obed [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 23, 2008 10:49 PM To: Jay Blanchard Cc: Brown, Charles; mysql@lists.mysql.com Subject: Re: executing query from the command line -- need help On Jan 23, 2008 2:36 PM, Jay Blanchard <[EMAIL PROTECTED]> wrote: > [snip] > Hello Jay. Thanks for your reply but where is your solution to my > problem. I'm lost here. Help me -- please > > Thx > > > -Original Message- > From: Jay Blanchard [mailto:[EMAIL PROTECTED] > Sent: Wednesday, January 23, 2008 11:29 AM > To: Brown, Charles; mysql@lists.mysql.com > Subject: RE: executing query from the command line -- need help > > [snip] > SELECT SYS_ID, SYS_LOCATION, SYS_IP FROM PROD_SERVER; > > UPDATE TEST_SERVER > SET SYS_ID = &value passed from above > SYS_LOCATION = &value passed from above >SYS_IPADDRESS = &value passed from above; > > [/snip] > > And here http://dev.mysql.com/doc/refman/5.1/en/user-variables.html > [/snip] > > Always reply to all so that this goes back to the list. I found this in > my junk folder. > > When you retrieve the value from the first query assign that value to a > variable which can then be used in the second query. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > I'm going to propose you a horrible solution: mysql> select * from table1; +--+--+ | id | text | +--+--+ |1 | one | |2 | two | +--+--+ 2 rows in set (0.00 sec) mysql> select * from table2; +--+--+ | id | text | +--+--+ |1 | one | +--+--+ 1 row in set (0.00 sec) mysql> update table2 set id=(select id from table1 where id=2), text=(select text from table1 where id=2) where id=1; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql> select * from table2; +--+--+ | id | text | +--+--+ |2 | two | +--+--+ 1 row in set (0.00 sec) Take care, greetings. -- http://www.obed.org.mx This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
executing query from the command line -- need help
Hello All. I'm new to mysql. I would like to issue a query from the command line and pass the result to an update done on the command line within the same script. See below. My question is how can I run a select from the command line and pass the values to an update SELECT SYS_ID, SYS_LOCATION, SYS_IP FROM PROD_SERVER; UPDATE TEST_SERVER SET SYS_ID = &value passed from above SYS_LOCATION = &value passed from above SYS_IPADDRESS = &value passed from above; Thanks This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql error
Hello all. I noticed that the last entry in mysql error log was two weeks ago. Can some one tell me why mysql is not writing to this log This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
max_connect_errors
Hello, Does MySQL store a current error count (for each host?) internally that I can enquire on? I did not find this information in the MySQL manual. If the current error count is available, so that I can monitor it for specific hosts and issue a alert when it crosses a threshold. Please help! Thanks This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you.
Show command for max_connection_errors. Any ?
Hello All. Is there a way to monitor the max_connection_errors. I'm asking because we had a problem the other day in MYSQL when slowed down and stopped accepting connections from one of the boxes. To resolve this problem, I issued FLUSH HOST and the problem went away. Is there a SHOW command that I can issue that can show the max-error-connections before it hits the high water mark. This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
General Query Log -- No Timestamp
The MYSQL general query log does not include timestamp of queries that it logs because queries are logged many many seconds before they are executed. Can someone help me associated queries found in the query log with wall clock? I am trying to get a list of queries that were executed within a given timeslot. I would like to get the description of these queries so that I can give to my webmaster. Based on the description of these queries, he will be able to determine which area the application is causing this on going looping problem that generates 5000 request in 5 mins. Our normal request volume is about 50/min. Can someone help me? Without the timestamp, I wouldn't be able track or identify the queries that came in during the problem time frame. With all things considered, MySQL should be able to append timestamp as it writes these General query records -- I would think. Thanks This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
batch mode
Because I am running on batch mode therefore I'm trying to direct my session output to a file -- meaning stdout. But I'm having a problem. For instance this input: "use test_db" gave me no output but this input "show tables" gave me an output. What is missing, what's the trick. Help me Y'all. Thx. This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
an't connect to local MySQL -- Help me!
I am getting this message from mysql. We had our binlog directory full. What is the resolution? Error 2002 (HY000) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
My bin.log directory is getting full
Hello All. My bin.log directory is getting full with bin.log files. We are running out of space. What can I do in the short term? Is there a command that I can issue that will get rid of old bin log files not needed? This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
IBM, MySQL team up on database software
IBM, MySQL team up on database software BOSTON (Reuters) - International Business Machines Corp. plans to start selling products from smaller rival MySQL AB, a developer of an open-source database that is used to help run Web sites, Executives at IBM, the world's No. 2 software maker, and MySQL told Reuters they will announce a technology and marketing partnership on Wednesday at a MySQL users' conference in Santa Clara, California. MySQL AB is a privately held company that develops standardized versions of the open-source MySQL database. It makes money by selling service agreements that cover upgrades, technical support and maintenance of those programs. MySQL is one of the most popular types of open source software after Linux, the popular computer operating system. It competes with products from Oracle Corp. The agreement calls for IBM and MySQL to develop software that will make MySQL compatible with programs that run IBM's System i line of business computers, including IBM's i5 operating system DB2 database. IBM will also sell MySQL's service products. This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Stopping Replication
Re: "webserver2-relay-bin.{some#}" Because you've deleted the master.info file found in the SLAVE server therefore these files( relay logs) are no longer needed. Mind you, you will not be able resume or restart replication. Replication at your site will have to be setup from 'scratch'. Thanks -Original Message- From: Jesse [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 24, 2007 4:26 PM To: Brown, Charles; Michael Dykman; Gerald L. Clark Cc: MySQL List Subject: Re: Stopping Replication Thanks, I've removed these files. Also, there are a BUNCH of files named "webserver2-relay-bin.{some#}" in the data folder. Can I delete all of these (including the .index file)? Thanks, Jesse ----- Original Message - From: "Brown, Charles" <[EMAIL PROTECTED]> To: "Michael Dykman" <[EMAIL PROTECTED]>; "Gerald L. Clark" <[EMAIL PROTECTED]> Cc: "Jesse" <[EMAIL PROTECTED]>; "MySQL List" Sent: Tuesday, April 24, 2007 4:31 PM Subject: RE: Stopping Replication (Read ref manual: 6.4) Here's the best kept secret: The Slave has two files called master. info and relay-log.info. The slave uses these two files to keep track of how much of the master's binary log it has processed and all pertinent info about the master( i.e userid, password, hostname) are all documented in the master.info file. Did you say you would like to stop replication - PERIOD! Delete these files or use "CHANGE MASTER TO" statement to change replication parameters. Why: The contents of master.info overrides some of the server options specified on the command line or in my.cnf. (Read ref manual: 6.4) -Original Message- From: Michael Dykman [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 24, 2007 2:35 PM To: Gerald L. Clark Cc: Jesse; MySQL List Subject: Re: Stopping Replication you mill also do well to eliminate the master.nfo file from your data directory. On 4/24/07, Gerald L. Clark <[EMAIL PROTECTED]> wrote: > Jesse wrote: > > I'm trying to stop replication between two servers that I've got here. > > I set it up originally, to play with it and see how it works. However, > > I now want to use these two servers separately. > > > > I have edited the my.ini file on both the server and slave machines, and > > removed the server-id from them. I have also executed a stop slave on > > the slave server. However, it appears that when I stop and re-start the > > server that was the slave, it tries to re-start replication again, > > because I get the error, "Failed to create slave threads" in the event > log. > > > > What else do I need to do to stop the replication process? > > > > Thanks, > > Jesse > > > You have to remove the master information from the slave's my.ini file. > > -- > Gerald L. Clark > Supplier Systems Corporation > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Stopping Replication
(Read ref manual: 6.4) Here's the best kept secret: The Slave has two files called master. info and relay-log.info. The slave uses these two files to keep track of how much of the master's binary log it has processed and all pertinent info about the master( i.e userid, password, hostname) are all documented in the master.info file. Did you say you would like to stop replication - PERIOD! Delete these files or use "CHANGE MASTER TO" statement to change replication parameters. Why: The contents of master.info overrides some of the server options specified on the command line or in my.cnf. (Read ref manual: 6.4) -Original Message- From: Michael Dykman [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 24, 2007 2:35 PM To: Gerald L. Clark Cc: Jesse; MySQL List Subject: Re: Stopping Replication you mill also do well to eliminate the master.nfo file from your data directory. On 4/24/07, Gerald L. Clark <[EMAIL PROTECTED]> wrote: > Jesse wrote: > > I'm trying to stop replication between two servers that I've got here. > > I set it up originally, to play with it and see how it works. However, > > I now want to use these two servers separately. > > > > I have edited the my.ini file on both the server and slave machines, and > > removed the server-id from them. I have also executed a stop slave on > > the slave server. However, it appears that when I stop and re-start the > > server that was the slave, it tries to re-start replication again, > > because I get the error, "Failed to create slave threads" in the event > log. > > > > What else do I need to do to stop the replication process? > > > > Thanks, > > Jesse > > > You have to remove the master information from the slave's my.ini file. > > -- > Gerald L. Clark > Supplier Systems Corporation > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Querying large table
Just for heck of it, I did a Big-O-notation for its efficiency -- as you predicted, it will take longer. I also factored-in the SORT required by the 'GROUP BY' -- say there are 64,000 categories therefore mysql may have to do 64,000 SORTs -- that's not cheap. My gut feelings are its doing a T/B scan on items because there isn't an index define for ctg on the items TABLE. Again, just one man's thought. -Original Message- From: Michael Gargiullo [mailto:[EMAIL PROTECTED] Sent: Thursday, March 29, 2007 6:10 PM To: Shadow; mysql@lists.mysql.com Subject: RE: Querying large table Do you need a count for all and run one at a time? If so, try. Select ctg as catagory,count(*) as count from items group by catagory. It will take a little while to run, but return all of your counts. Does the items table have an index in ctg? Sent by Good Messaging (www.good.com) -Original Message- From: Shadow [mailto:[EMAIL PROTECTED] Sent: Thursday, March 29, 2007 07:00 PM Eastern Standard Time To: mysql@lists.mysql.com Subject:Querying large table Hey, guys. I have 2 tables: categories and items. COUNT(*) categories = 63 833 COUNT(*) items = 742 993 I need to get number of items in a specific category, so I use SELECT COUNT(*) FROM items WHERE ctg='' But each query takes ~ 10seconds. Its really slow. Can anybody propose some optimization? Thanks. - Finding fabulous fares is fun. Let Yahoo! FareChase search your favorite travel sites to find flight and hotel bargains. This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
information_schema not found
Hi all. I just finished installing mysql on a new server. I noticed that database information_schema wasn't found. Can someone help me. This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Database replication -- switch role
Hello All. We have replication setup thus:- Master A --> Slave B. Now, the data center will like to implement ca-unicenter on server-A and do some testings for automation purpose. You've guessed it, Mysql-A will be up-and-down for the next couple weeks. To provide business continuity, I have been asked to switch replication role on these Mysql. Meaning -- make Mysql-A the slave and Mysql-B the master. My question: Is this change do-able? What is it that I should watch out for as I switch roles in these mysqls? What are the gotcha -- are there any? Can someone please give me step-by-step fool proof guidelines on how to implement this major change? I can't thank y'all enough. This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
a Linux -csh script to refresh test with production
Hello all. Does anyone out there (in mysql world) have a Linux -csh script to refresh test with production data. My developers would like their test database to be refreshed nightly with production data. The production and test mysql servers do not run in the same box. They run on different boxes. Therefore there is some ftp or scp required Thanks This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: function based index
Hello Dan. Try it and see if you can: mysql> create index indx101 on tab101(min(c1),c2) ; Answer: Its not supported. -Original Message- From: Dan Nelson [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 13, 2007 9:10 AM To: Ananda Kumar Cc: mysql@lists.mysql.com Subject: Re: function based index In the last episode (Mar 13), Ananda Kumar said: > Is it possible to create function based index in mysql as available > in oracle. Please point me to any documentation on this. Sorry; mysql doesn't have function-based indexes. The closest you can get in mysql is if you add another column and an UPDATE trigger that populates it with the results of your function, then index that column. -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
copy data from prod to test - when database name is not the same name
Hello All, We have two mysql environment PROD and TEST. I would like to copy data from PROD to TEST. The PROD database name is Mysql_prod and the TEST database name is mysql_TEST. Using mysqldump or any applicable utility can someone show me how to migrate my production data from prod to test. The only thing that is different is the database name. The tables are all the same. Thanks in advance This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
max mysql under windows
Hello All. Is it possible to setup two instances of MySQL under windows? I am wondering because I would like to setup and test replication Thanks Charles This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you.
MYSQL under windows -- Max number of instances
Hello All. Is it possible to setup two instances of MySQL under windows? I am wondering because I would like to setup and test replication Thanks Charles This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MYSQL on windows -- Max number
Hello All. Is it possible to setup two instances of MySQL under windows? I am wondering because I would like to setup and test replication Thanks Charles This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Replication & LOAD DATA INFILE
During Replication the SLAVE reads data from its MASTER's log. Chances are LOAD DATA gets no logging -- I won't be surprised. -Original Message- From: Jesse [mailto:[EMAIL PROTECTED] Sent: Friday, February 02, 2007 9:44 AM To: MySQL List Subject: Replication & LOAD DATA INFILE I've just performed a LOAD DATA INFILE on the master server, and I've waited a while now, and the data has not shown up in the SLAVE. Does Replication not handle LOAD DATA INFILE? Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Questions about delete and optimize
Re: I can't say that I've tried this, It works like a champ we do every day in Oracle, DB2 and MySQL. It takes less time because you're bypassing logging thus reduce I/O and locking, etc. -Original Message- From: Jerry Schwartz [mailto:[EMAIL PROTECTED] Sent: Thursday, February 01, 2007 3:36 PM To: 'Ian Barnes'; mysql@lists.mysql.com Subject: RE: Questions about delete and optimize Another way to do it would be to select the data you want to keep into a table on another file system, truncate the existing table, optimize it, then reload it with the data you saved. I can't say that I've tried this, and have no idea how long it would take or even if it would work. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 > -Original Message- > From: Ian Barnes [mailto:[EMAIL PROTECTED] > Sent: Thursday, February 01, 2007 4:23 PM > To: mysql@lists.mysql.com > Subject: Questions about delete and optimize > > Hi, > > We are looking at various methods that we can effectively and > efficiently > delete lots of rows from a database and then optimize it. Our > main concern > is disk space - the partition we are working with is only > 12gigs small and > our database vary in size from 1gig (not a problem) to 11gig. > In the example > below I will use one whos .MYD is 6.5 Gig and the .MYI is > 2.7Gig. There are > around 28,900,000 rows in the database. > > Once a month we run an automated program that deletes rows > older than X > months and then we attempt the optimize the table in > question. The delete > query we use is: > DELETE FROM table WHERE date<(current_date - interval 2 month). Now my > questions surrounding this are: > > 1.) Is it quicker to do a query where we say something like: > DELETE FROM > table WHERE date <= '2006-11-01' instead of where date<(current_date)? > 2.) Does the current way we do it use a tmp table that is > written to disk ? > > Then, we run the simple optimize command: OPTIMIZE TABLE > tablename and that > is normally where we come into the problem that mysql tries > to create a tmp > file while optimizing and it runs out of space, and then > corrupts the main > table. We need to run the optimize because after deleting all > those rows, > the space isnt freed up until we run the optimize. So my > other question is > can we do an optimize a different way, or is there some way > that we can > insert and delete rows that would require less optimization? > > Thanks in advance, > Ian > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Password hash should be a 41-digit hexadecimal number
Try this: GRANT USAGE ON *.* TO 'openpne'@'locahost' IDENTIFIED BY 'openpne' ; Or try this: create user 'openpne'@'localhost' identified by password 'openpne'; - Spell domain correctly - there was a typo - put quote around userid and domain -Original Message- From: Padmanabhan G [mailto:[EMAIL PROTECTED] Sent: Friday, February 02, 2007 3:18 AM To: mysql@lists.mysql.com Subject: Password hash should be a 41-digit hexadecimal number hi Issuing the grant command yields an error: mysql> create user [EMAIL PROTECTED] identified by password 'openpne'; Error 1372: Password hash should be a 41-digit hexadecimal number -- With Thanks & Regards G. Padmanabhan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: WHERE (NOT) EXISTS problem
Hello Michael. Here is the query you wanted - you were almost there. SELECT DISTINCT NAME FROM PEOPLE WHERE ID IN (SELECT PID FROM PEOPLE_CITY_MAP WHERE CID = 1) Thanks. -Original Message- From: Michael Fischer [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 31, 2007 11:53 PM To: mysql@lists.mysql.com Subject: WHERE (NOT) EXISTS problem Having a very bad time with the subject sorts of queries. Here is a simple reproduction of the problem for me. Perhaps I'm blind/stupid while looking at the docs, or there's a bug... mysql version 5.0.24-standard simple schema: mysql> desc people; +---+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-++ | id| int(11) | NO | PRI | NULL| auto_increment | | name | varchar(255) | YES | | NULL|| +---+--+--+-+-++ mysql> desc cities; +---+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-++ | id| int(11) | NO | PRI | NULL| auto_increment | | name | varchar(255) | YES | | NULL|| +---+--+--+-+-++ mysql> desc people_city_map; +---+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-+---+ | pid | int(11) | NO | | | | | cid | int(11) | NO | | | | +---+-+--+-+-+---+ mysql> select * from people; ++-+ | id | name| ++-+ | 1 | michael | | 2 | daniel | | 3 | glenn | | 4 | susan | | 5 | lisa| | 6 | reggie | ++-+ mysql> select * from cities; ++--+ | id | name | ++--+ | 1 | new york | | 2 | boston | | 3 | chicago | ++--+ mysql> select * from people_city_map; +-+-+ | pid | cid | +-+-+ | 1 | 1 | | 2 | 1 | | 5 | 3 | | 6 | 3 | +-+-+ Now, not that this is the best way to do things generally, but, after all, this is a simplification of a more complex real app in development, so... mysql> SELECT distinct name > FROM people WHERE EXISTS > (select * from people_city_map where cid = 1); +-+ | name| +-+ | michael | | daniel | | glenn | | susan | | lisa| | reggie | +-+ Huh? Shouldn't that be limited to the people mapped to New York (michael, daniel)? Conversely: mysql> SELECT distinct name > FROM people WHERE EXISTS > (select * from people_city_map where cid = 1); Empty set (0.00 sec) *blink* Shouldn't that produce susan and glenn, who are not in the map table at all? Very confused. "Normal" joins across the tables work as expected. Am I overlooking something, or is there sign of a bug? I'll admit, I'm perplexed over the bit in the docs which says "Traditionally, an EXISTS subquery starts with SELECT *, but it could begin with SELECT 5 or SELECT column1 or anything at all. MySQL ignores the SELECT list in such a subquery, so it makes no difference." Thanks in advance Michael -- Michael Fischer Happiness is a config option. [EMAIL PROTECTED]Recompile and be happy. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Database Layout (Design) Question
Hello, I think your major contributing problem is the database engine that you are using, MYISAM. For this type of processing, I would highly recommend you use INNODB to allow maximum concurrency and minimize your outage. With all things considered, your processing by all estimates, whether you are on DB2 Mainframe or Oracle or IMS. Deleting 2 gig of data from a table via an SQL is considered massive. Having said that, there are other methods of completing this task of purging/archiving data from a table with fewer outages. Here is what you do: 1. Unload the table into two flat files. The records that are less 14 days go into one flat file while records older than 14 days go into another. 2. At the completion of the unload process. LOAD REPLACE data using flat file that contains data less than 14days. Please email me if you need help with SQL statements, UNLOAD, or LOAD data into the table. -Original Message- From: Kishore Jalleda [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 31, 2007 8:51 AM To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: Re: Database Layout (Design) Question The delete would definitely depend upon the size of the record set being deleted, anyway assuming I comprehended your situation correctly ,I would suggest using the Merge storage engine for your needs , and keep every single day of data in a seperate MyISAM table, and merge all those tables together into a single merge table, so when you want to do any maintenance on any data older than x days just alter the table and take that table out of the merge table , delete it compress it, do anyhting with it and then just add a other one (you could easily run a nightly cron job for this) Please look at http://dev.mysql.com/doc/refman/5.0/en/merge-storage-engine.html Kishore Jalleda On 1/31/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > I'm trying to wrap my head around a performance problem our institution is > having on our Mysql Server which hosts all of our logs from around campus. > > Specifically our MailLogs tables. > > What I'm having a hard time with is we have metadata such as: > > CREATE TABLE mail00 ( >host varchar(32) default NULL, >fromMTA varchar(44) default NULL, >nextMTA varchar(44) default NULL, >messageID varchar(44) default NULL, >messageID2 varchar(44) default NULL, >sender varchar(80) default NULL, >recipient varchar(120) default NULL, >recipient2 varchar(120) default NULL, >date date default NULL, >time time default NULL, >program varchar(44) default NULL, >ACTION varchar(44) default NULL, >detail varchar(120) default NULL, >msg text, >seq int(10) unsigned NOT NULL auto_increment, >PRIMARY KEY (seq), >KEY host (host), >KEY sender (sender), >KEY recipient (recipient), >KEY MessageID (messageID), >KEY seq (seq), >KEY time (time), >KEY date (date), >KEY ACTION (ACTION), >KEY messageID2 (messageID2), >KEY fromMTA (fromMTA) > ) TYPE=MyISAM MAX_ROWS=9900; > > We might end up storing two to three gigs of logging data per day from our > mail servers. > > When we had the process setup to purge data out of this table that is > older > than 14 days, it would lock and take great deal of time process the > request. > > My question is, is the structure of my table the problem or is it just the > size of the data that is just going to take that long due to Disk IO? > > This isn't a table structure that I came up with, I'm just looking to > optimize the performance of the server. > > Currently around midnight the sysadmin currently drops table 13, then > moves > 12 -> 13, 11 -> 12, etc... and creates a 00. > > All of this is because it takes to long to purge out one days worth of > data > . This will eventually cause a problem when we try to develop a program > to > scan the logs, it will need to scan through all 14 tables instead of just > one. > > Is there a better way that mitigates the performance and flexibility? > > Or just a better way in general? > > Thanks, > > -Tyler > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]