Re: MySQL 5 Application Error
Mulugeta Maru [EMAIL PROTECTED] wrote: I am using MySQL 5 issuing the following query when the application died on me three times.Query: Select name, year_of_birth from players where year_of_birth = ALL(select year_of_birth from players) Note: If I only use the first part of the query (i.e. without the subquery) it runs no problem. I do not think it is because of the subquery, becuase I have used a number of subqueries with this verision and they run fine. Did you get this error every time you run the above query? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Replication broken after upgrade from 4 to 4.1
Hi everybody, I have three mysql servers doing a circular replication. They (still) run Redhat 7.3. I started with Mysql 3.23, upgraded to 4 and yesterday I tried 4.1. I'm using official mysql rpms. Now the replication is broken. One server always says Connecting to master. The error log says: 040304 19:11:58 Slave I/O thread: error connecting to master '[EMAIL PROTECTED] 47.62:3306': Error: 'Lost connection to MySQL server during query' errno: 2013 retry-time: 60 retries: 86400 The server which is supposed to replicate fromt this server says: Waiting for master to send event. The log says: 040304 16:47:59 Got fatal error 1236: 'Could not find first log file name in binary log index file' from master when reading data from binary log The third replication finally seems to work. I did not change anything in configuration, passwords etc. It's all the same. Something to note: The two servers able to replicate are in the same network, the one which makes trouble is in another, firewall protected network. Port 3306 is open in both firewalls and it always worked. Does anybody have any tips? Thanks a lot (I'm really desparate) Stefan -- Stefan Kuhn M. A. Cologne University BioInformatics Center (http://www.cubic.uni-koeln.de) Zlpicher Str. 47, 50674 Cologne Tel: +49(0)221-470-7428 Fax: +49 (0) 221-470-7786 My public PGP key is available at http://pgp.mit.edu -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: sub-query
Lorderon [EMAIL PROTECTED] wrote: Since I don't use MySQL 4.1, is this query OK? SELECT SQL_CALC_FOUND_ROWS * FROM ((SELECT * FROM t1 WHERE id100 GROUP BY country) UNION ALL (SELECT * FROM t2 WHERE id150 GROUP BY country) LIMIT 0,10); I want this to return all the rows of the UNION sub-query there.. the reason I used it as sub-query is that I want to count the rows, and then use: SELECT FOUND_ROWS(); to get the number of rows supposed to be retuned without using the LIMIT.. Is all above correct? First of all your subqueries are illegal, because you select columns that are not in the GROUP BY clause. Since 4.1 you can write: SELECT SQL_CALC_FOUND_ROWS * FROM ( SELECT country FROM t1 WHERE id100 GROUP BY country UNION ALL SELECT country FROM t2 WHERE id150 GROUP BY country) as union_table LIMIT 0,10; But the following query gives you the same result: (SELECT SQL_CALC_FOUND_ROWS country FROM t1 WHERE id100 GROUP BY country) UNION ALL (SELECT country FROM t2 WHERE id5 GROUP BY country) LIMIT 0,10; -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
An doubt about mysql version 4.0.x agains 4.1.x
Dear Friend an friend of mine told that the follow line bellow dont work with mysql version 4.0.x * Support for subqueries and derived tables This mean query like : SELECT A.* FROM (SELECT * FROM TESTE WHERE X = Y) A WHERE COL1 = 3 is this true, or mysql version 4.0.x work properly with this Regards Luiz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
locking issues
Hi Group, A question about locking. In my code (delphi but that doesn't much matter) I fire ad-hoc queries (select). Before the query i fire a locking query (read) for that particular tables. Something like this: lock tables tab1 a read, tab2 b read (execute) select * from tab1 a, tab2 b where. (execute) In this case I get an error: tab1 is not locked using LOCK TABLES. If I change the locking query to: lock tables tab1 read, tab2 b read The first times I didn't get any error. But after some times of running my app the error: a is not locked using LOCK TABLES occur!?!? Ok finally I use the statement: lock tables tab1 read, tab1 a read, tab2 b read en everything works fine. The strangest thing about this is that sometimes it doesn't go wrong (locking using the lock statement with only the table aliases), other times it goes. When I execute the locking and the select query from my SQL explorer (borland) nothing is going wrong (makes no sense whatever you lock). It makes no difference I use version 4.0/4.1/5.0 (on suse linux). Anybody who has seen this before? Okay the workaround is simple: don't use table aliases or use the above showed locking statement, but it makes me angry something like this errors are raised on unexpected moments in my production environment,. Thanks for help Hans -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: An doubt about mysql version 4.0.x agains 4.1.x
Luiz Rafael Culik Guimaraes [EMAIL PROTECTED] wrote: Dear Friend an friend of mine told that the follow line bellow dont work with mysql version 4.0.x * Support for subqueries and derived tables This mean query like : SELECT A.* FROM (SELECT * FROM TESTE WHERE X = Y) A WHERE COL1 = 3 is this true, or mysql version 4.0.x work properly with this It's true. The above SELECT statement will work only from 4.1. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: msSQL - MySQL (exhanging data between the two)
I haven't tried, but it seems quite difficult, for one thing, both sql engines are very differents. So the short answer would be a plain no. Now trying something exotic would be making a odbc bridge between the two dbs and then use some scripted solution it would be possible, something like java or c# or even vb(.net), even perl or php could be used, but again it is something that you should find out for your self. When deciding about what programming language one key comoponent should be that the language has native access to both server (php? perl?) so type coneversion would be easy to manage. But again it's just a thought... My two cents! =) maybe someone else here could have better ideas-options Best Regards On Thu, 2004-03-04 at 16:26, Daniel Ek wrote: Once more - Dear list, I am doing some research on a CRM-tool which my company bought that uses msSQL. The setup looks something like this User -- CRM -- MsSQL } User -- Webform -- MySQL } The same data entered What would be optimal is if would be possible, that when a user requests data through the CRM that it actually uses MySQL connections. Unfortunately I speaked to the software vendor about it and they said that it was not an option at the moment. My question then is if MySQL could replicate data with MsSQL as master as following setup: User - CRM - MsSQL ()-- MySQL -- Apps that relies on MySQL data I would be thankful to any comments and/or suggestions I can get Regards Daniel Ek -- |...| | _ _|Victor Medina M | |\ \ \| | _ \ / \ |Linux - Java - MySQL | | \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria EPA | | / / / |___| __/ ___ \ |[EMAIL PROTECTED] | |/_/_/|_|_| /_/ \_\|ext. 325 - Tél: +58-241-8507325 | ||geek by nature - linux by choice | |...|
Re: Drop and Add Functions in Mysql 4
You could try MySQL 5(it is in alpha state), which comes with stored procedures, mixing stored procedures and prepered statements could be a possibility. About Sybex's book, haven't read it, but Paul's book (Oreilly's) is very nice. IMHO Best Regards On Thu, 2004-03-04 at 23:23, [EMAIL PROTECTED] wrote: Hi there, i happened to be peering into the Sybex book on Mysql4 , it was pretty expensive about 100 AUD is it a good one ? Anyway i had reference to be able to compile c code into Mysql to add functions into it. Is there anyway posible to avodi doing this and add it using queries ? Let me know thanks. -- |...| | _ _|Victor Medina M | |\ \ \| | _ \ / \ |Linux - Java - MySQL | | \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria EPA | | / / / |___| __/ ___ \ |[EMAIL PROTECTED] | |/_/_/|_|_| /_/ \_\|ext. 325 - Tél: +58-241-8507325 | ||geek by nature - linux by choice | |...|
Re: Innodb table space getting filled up without any increase in actual rows!!
Thanks for your valuable suggestions. I'm committing transactions, but not all. Only the transactions which do insert/delete, commit and not all. So I think the better solution for me is to switch to Read Committed isolation mode, since I don't require Repeatable Read Isolation for my application. Do you think this will address my issue (tables don't get filled up until they have rows) ? Thanks, Sp.Raja Original Message From: Sp.Raja [EMAIL PROTECTED] To: K Perinbam [EMAIL PROTECTED] Cc: R Narayanan [EMAIL PROTECTED] Date: Fri, Mar-5-2004 9:14 AM Subject: Re: Innodb table space getting filled up without any increase in actual rows!! - Looks like can be fixed. FYI. Sp. Raja, you have 3 dangling transactions that have been active for almost 2 hours. They prevent purge from removing those delete-marked rows. ---TRANSACTION 0 832338, ACTIVE 6027 sec, OS thread id 65 MySQL thread id 41, query id 1036449 localhost root Trx read view will not see trx with id = 0 832339, sees 0 832214 ---TRANSACTION 0 832337, ACTIVE 6027 sec, OS thread id 57 MySQL thread id 42, query id 1036436 localhost root Trx read view will not see trx with id = 0 832338, sees 0 832214 ---TRANSACTION 0 832214, ACTIVE 6055 sec, OS thread id 110 MySQL thread id 51, query id 1036076 localhost root Trx read view will not see trx with id = 0 832215, sees 0 832215 You should commit these transactions. Best regards, Heikki Innobase Oy http://www.innodb.com InnoDB - transactions, row level locking, and foreign keys for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables Register now for the 2004 MySQL Users Conference! http://www.mysql.com/events/uc2004/index.html - Alkuper??inen viesti - L??hett??j??: Sp.Raja [EMAIL PROTECTED] Vastaanottaja: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED] L??hetetty: Thursday, March 04, 2004 4:38 PM Aihe: Re: Innodb table space getting filled up without any increase in actual rows!! Heikki, Thanks for your reply. As you said I have attached trace collected for SHOW INNODB STATUS. Please point me the things which are going wrong. Do you mean I have to use auto-commit transactions? What changes should I do (or) take care when using MySQL through ODBC to avoid old transactions ? To be more specific my client does a lot of inserts/deletes using a ODBC connection maintaining number of rows to be between 60 and 70. Thanks, Sp.Raja Original Message From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Date: Thu, Mar-4-2004 1:30 AM Subject: Re: Innodb table space getting filled up without any increase in actual rows!! Sp. Raja, please check with SHOW INNODB STATUS\G if purge is still running and removing delete-marked rows. Also check that you do not have old, dangling transactions, which can prevent purge from running, as those old transactions could still see the delete-marked rows. Best regards, Heikki Innobase Oy http://www.innodb.com InnoDB - transactions, row level locking, and foreign keys for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables Register now for the 2004 MySQL Users Conference! http://www.mysql.com/events/uc2004/index.html Preferably, you should test the problem using the latest stable or development version of MySQL Server before postin1 List:MySQL General Discussion Previous MessageNext Message From:Sp.RajaDate:March 3 2004 8:48am Subject:Fw: Innodb table space getting filled up without any increase in actual rows!! I missed attaching the trace file! Sorry !! Regards, Sp.Raja Original Message From: Sp.Raja [EMAIL PROTECTED] To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] Date: Wed, Mar-3-2004 1:13 PM Subject: Innodb table space getting filled up without any increase in actual rows!! Hi List, My tablespace is getting filled up so quick when no. of transactions increase without number of rows increasing considerably. I have a test client which adds and deletes row dynamically maintaining number of rows at any instant between 20 and 60. When I run this test client, after some time the client emits the following error: [MySQL][ODBC 3.51 Driver][mysqld-4.0.15a-debug]The table 'axactivealarmtbl' is full. I was confused on seeing this. So ran the test again but this time monitoring table status. I noticed that Rows, Data_length and Index_length column increased monotonically and InnoDB free decreased. I was not able to reason why ? But when I used select count(*) from tablename it consistently gave me numbers between 20 and 60 I have attached output of show table status(trace.txt) as I observed taken at increasing time. Any Pointers/Ideas on this to help me resolve this issue??
SV: Querying serveral databases (Views?)
No I did not. Thank you very much! Regards Daniel -Ursprungligt meddelande- Från: Jeff Mathis [mailto:[EMAIL PROTECTED] Skickat: den 5 mars 2004 00:48 Till: Daniel Ek Kopia: [EMAIL PROTECTED] Ämne: Re: Querying serveral databases (Views?) in case someone hasn't answered you yet.. do you know that you can specify a database.tablename.column syntax in your queries to go across multiple databases? Daniel Ek wrote: Dear list, I wish to know if anyone have any experience in querying several databases at the same time. Today the company that I work for have about three different databases and I really feel that's fine because of the logic around it. We have one Customer database with customerData table, CustomerProducts table and so on, and two other Productspecific ones. I feel the information logic in having multiple databases are obvious but are there any way to use like pgsql views over several databases in Mysql? If not, can anyone please advice me to either when such a function will be implemented, or other solutions to the problem? And with that I don't mean the make more connections fix, since I don't feel it's a neat way to solve it. Thanks in advance Regards Daniel Ek -- Jeff Mathis, Ph.D. 505-955-1434 The Prediction Company [EMAIL PROTECTED] 525 Camino de los Marquez, Ste 6http://www.predict.com Santa Fe, NM 87505 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Innodb table space getting filled up without any increase in actual rows!!
Sp. Raja, - Alkuperäinen viesti - Lähettäjä: Sp.Raja [EMAIL PROTECTED] Vastaanottaja: Heikki Tuuri [EMAIL PROTECTED] Kopio: mysql [EMAIL PROTECTED] Lähetetty: Friday, March 05, 2004 2:28 PM Aihe: Re: Innodb table space getting filled up without any increase in actual rows!! Thanks for your valuable suggestions. I'm committing transactions, but not all. Only the transactions which do insert/delete, commit and not all. So I think the better solution for me is to switch to Read Committed isolation mode, since I don't require Repeatable Read Isolation for my application. Do you think this will address my issue (tables don't get filled up until they have rows) ? I think not. Best to run those SELECT transactions with AUTOCOMMIT=1. In transactional databases it is a good practice always to take care that your transactions are committed quickly. Do not leave them dangling. Thanks, Sp.Raja Best regards, Heikki Innobase Oy http://www.innodb.com InnoDB - transactions, row level locking, and foreign keys for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables Register now for the 2004 MySQL Users Conference! http://www.mysql.com/events/uc2004/index.html Original Message From: Sp.Raja [EMAIL PROTECTED] To: K Perinbam [EMAIL PROTECTED] Cc: R Narayanan [EMAIL PROTECTED] Date: Fri, Mar-5-2004 9:14 AM Subject: Re: Innodb table space getting filled up without any increase in actual rows!! - Looks like can be fixed. FYI. Sp. Raja, you have 3 dangling transactions that have been active for almost 2 hours. They prevent purge from removing those delete-marked rows. ---TRANSACTION 0 832338, ACTIVE 6027 sec, OS thread id 65 MySQL thread id 41, query id 1036449 localhost root Trx read view will not see trx with id = 0 832339, sees 0 832214 ---TRANSACTION 0 832337, ACTIVE 6027 sec, OS thread id 57 MySQL thread id 42, query id 1036436 localhost root Trx read view will not see trx with id = 0 832338, sees 0 832214 ---TRANSACTION 0 832214, ACTIVE 6055 sec, OS thread id 110 MySQL thread id 51, query id 1036076 localhost root Trx read view will not see trx with id = 0 832215, sees 0 832215 You should commit these transactions. Best regards, Heikki Innobase Oy http://www.innodb.com InnoDB - transactions, row level locking, and foreign keys for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables Register now for the 2004 MySQL Users Conference! http://www.mysql.com/events/uc2004/index.html - Alkuper??inen viesti - L??hett??j??: Sp.Raja [EMAIL PROTECTED] Vastaanottaja: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED] L??hetetty: Thursday, March 04, 2004 4:38 PM Aihe: Re: Innodb table space getting filled up without any increase in actual rows!! Heikki, Thanks for your reply. As you said I have attached trace collected for SHOW INNODB STATUS. Please point me the things which are going wrong. Do you mean I have to use auto-commit transactions? What changes should I do (or) take care when using MySQL through ODBC to avoid old transactions ? To be more specific my client does a lot of inserts/deletes using a ODBC connection maintaining number of rows to be between 60 and 70. Thanks, Sp.Raja Original Message From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Date: Thu, Mar-4-2004 1:30 AM Subject: Re: Innodb table space getting filled up without any increase in actual rows!! Sp. Raja, please check with SHOW INNODB STATUS\G if purge is still running and removing delete-marked rows. Also check that you do not have old, dangling transactions, which can prevent purge from running, as those old transactions could still see the delete-marked rows. Best regards, Heikki Innobase Oy http://www.innodb.com InnoDB - transactions, row level locking, and foreign keys for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables Register now for the 2004 MySQL Users Conference! http://www.mysql.com/events/uc2004/index.html Preferably, you should test the problem using the latest stable or development version of MySQL Server before postin1 List:MySQL General Discussion Previous MessageNext Message From:Sp.RajaDate:March 3 2004 8:48am Subject:Fw: Innodb table space getting filled up without any increase in actual rows!! I missed attaching the trace file! Sorry !! Regards, Sp.Raja Original Message From: Sp.Raja [EMAIL PROTECTED] To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] Date: Wed, Mar-3-2004 1:13 PM Subject: Innodb table space getting filled up without any increase in actual rows!! Hi List, My tablespace is getting filled up so quick when no. of transactions increase without number of rows increasing considerably. I have a test client which adds and deletes row
RE: MySQL 5 Application Error
Yes. I tried it at least three times and MySQL crashes i.e. I get disconnected. I do use Windows 2000 to run MySQL. -Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED] Sent: Friday, March 05, 2004 5:02 AM To: [EMAIL PROTECTED] Subject: Re: MySQL 5 Application Error Mulugeta Maru [EMAIL PROTECTED] wrote: I am using MySQL 5 issuing the following query when the application died on me three times.Query: Select name, year_of_birth from players where year_of_birth = ALL(select year_of_birth from players) Note: If I only use the first part of the query (i.e. without the subquery) it runs no problem. I do not think it is because of the subquery, becuase I have used a number of subqueries with this verision and they run fine. Did you get this error every time you run the above query? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] VisionTV proudly celebrates 15 years as Canada's multi-faith television network. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Partial Replication ?
Hello, I have a database which is flushed every four hours, and I want to replicate it without replicating the delete queries . Is this possible ? (sorry for my awful english) Rémy BONNET. Yahoo! Mail : votre e-mail personnel et gratuit qui vous suit partout ! Créez votre Yahoo! Mail sur http://fr.benefits.yahoo.com/ Dialoguez en direct avec vos amis grâce à Yahoo! Messenger !Téléchargez Yahoo! Messenger sur http://fr.messenger.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
maintaining logs...
hi, i m using mysqld Ver 4.0.17-standard for pc-linux on i686 (Official MySQL RPM) and i want to maintain trace logs and debug logs to see what my mysql server is doing and what error it encounters, if any. help will be highly appreciated. bye Abubakr -- NOTICE: This email and any files transmitted with it may contain privileged and confidential information and intended solely for the use of the individual or entity to whom they are addressed. Please notify the sender immediately by email if you have received this email by mistake, delete it from your system and you should not use, disseminate, distribute or copy this email. Caution: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses
OT:select in mysql
Hi, i've a little problem with query. I have two tables where Table1 id desc Table2 id desc I want a list of table1.id not included in Table2 but i don't find the solution! Example Table1: --- id ! Desc --- 1! xx 2! Xx 3! ZZ Table2: --- id ! Desc --- 1! xx 2! Xx 4! YY I would like as Result this: --- id ! Desc --- 3! ZZ Thanks for any suggestions. Massimiliano -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Administrator
Hello list I have download the MySQL Administrator twice and when trying to gzip It collapse. Does anybody know how and why? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: OT:select in mysql
I want a list of table1.id not included in Table2 but i don't find the solution! I _*think*_ this will work for you. If I'm wrong, I'm sure someone will come behind and correct me: select table1.id from table1 left outer join table2 on table1.id = table2.id where table2.id = NULL; Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: OT:select in mysql
select table1.id from table1 left outer join table2 on table1.id = table2.id where table2.id = NULL; Sorry, that last should be where table2.id IS NULL; Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ibdata1
I lost my ibdata1 file, I don't have backup, and now my tables InnoDB don't open. MySQL error: 1016 (Can't open the file: 'table.InnoDB') please, give me a solutions. Are 27 tables. please. Wilker Azevedo __ Acabe com aquelas janelinhas que pulam na sua tela. AntiPop-up UOL - É grátis! http://antipopup.uol.com.br/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: OT:select in mysql
I want a list of table1.id not included in Table2 but i don't find the solution! SELECT * FROM table1 LEFT JOIN table2 USING (id) WHERE table2.id IS NULL PB
Re: MySQL 5 Application Error
Maru, Mulugeta [EMAIL PROTECTED] wrote: Yes. I tried it at least three times and MySQL crashes i.e. I get disconn= ected. I do use Windows 2000 to run MySQL.=20 Could you provide structure of table 'players'? (Output of SHOW CREATE TABLE statement or mysqldump program) -Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED] Sent: Friday, March 05, 2004 5:02 AM To: [EMAIL PROTECTED] Subject: Re: MySQL 5 Application Error Mulugeta Maru [EMAIL PROTECTED] wrote: I am using MySQL 5 issuing the following query when the application die= d on me three times.Query: Select name, year_of_birth from players where = year_of_birth =3D ALL(select year_of_birth from players) Note: If I only use the first part of the query (i.e. without the subqu= ery) it runs no problem. I do not think it is because of the subquery, becuase I have used a number of su= bqueries with this verision and they run fine. Did you get this error every time you run the above query? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
4.1.1 Problem with SELECT INTO OUTFILE
It seems that each time we select into an OUTFILE that already exists (re-use a name) the server crashes. Anyone have any ideas if this is a setting or just a bug? Thanks. Chris.
4.0.18 or 4.1.1-alpha?
I have to install MySQL in our web servers. I don't know if choosing 4.0.18 stable version or 4.1.1-alpha. I'd prefer the first one, but in this case I'd lose some important features. What do you suggest me? Thank's Samuele ca2000 padova (italy) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
table name is lower case if there is an index on it (4.0.18 )
Hi, I have a problem with mysql 4.0.18 on WindowsXP I set the lower_case_table_names=2 as it is mentioned for windows at the mysql website. (before I'm using version 4.0.15 and had set it to 0) so the tablenames should be stored in this case as I wrote it. So I create a table in Java with an index (this is only a part of the table) String sql = ; sql += CREATE TABLE AB_OBJECTS; sql += (; sql += id INTEGER PRIMARY KEY,; sql += objectId INTEGER NOT NULL,; sql += ); _statement.execute(sql); _statement.execute(CREATE INDEX ab_object_objectid_index ON AB_OBJECTS(objectId) ); the problem is that the table is created in lower cases as 'ab_objects' but if I don't create the index, only the table, its created in upper case 'AB_OBJECTS' as it should be. I have some other tables with and without an index and all should be stored in upper case. Thanks Regards Marco Bluemel
RE: BOM Select statement
-Original Message- From: Wesley Baker [mailto:[EMAIL PROTECTED] What I want is to know how to build a SELECT statement which will return all components of mynewpc and navigate down the bill-of-materials and also return all the components for the case, the powersupply and even the parts on the powersupply. This situation calls for recursion. I don't think you can do it with just SQL. Maybe there's a way to do it that I'm not seeing, though. Faced with the same situation, with Access as the front end, I ended up writing a program in Visual Basic for Applications to do it. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SET PASSWORD troubles on mysql 4.0.12 (ERROR 1044)
Hello,
All users should be able to change their own password on any mysql.
I have trouble to allow this feature on mysql 4.0.12, on mysql 3.23.56 it works.
Let me demonstrate it:
on mysql 3.23.56:
as root:
mysql create database test_dummy;
Query OK, 0 rows affected (0.00 sec)
mysql grant all on test_dummy.* to dummy;
Query OK, 0 rows affected (0.00 sec)
mysql set password for 'dummy'=password('testpass');
Query OK, 0 rows affected (0.00 sec)
mysql flush privileges;
Query OK, 0 rows affected (0.01 sec)
mysql exit
Bye
-
as a user: dummy:
-
mysql set password=password('testpass1');
Query OK, 0 rows affected (0.01 sec)
-
so user 'dummy' can change private password. This is what I need.
now the same operations on mysql 4.0.12:
as root:
mysql create database test_dummy;
Query OK, 0 rows affected (0.00 sec)
mysql grant all on test_dummy.* to dummy;
Query OK, 0 rows affected (0.00 sec)
mysql set password for 'dummy'=password('testpass');
Query OK, 0 rows affected (0.00 sec)
mysql flush privileges;
Query OK, 0 rows affected (0.01 sec)
mysql exit
Bye
and as a user: dummy:
mysql set password=password('testpass1');
ERROR 1044: Access denied for user: 'dummy@'host_ip' to database 'mysql'
User dummy cannot change his own password ...
Any idea how to change it ? Or some hints where is a my mistake ?
Thanks,
Bogdan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SET PASSWORD troubles on mysql 4.0.12 (ERROR 1044)
At 18:10 +0100 3/5/04, Bogdan Lobodzinski wrote:
Hello,
All users should be able to change their own password on any mysql.
I have trouble to allow this feature on mysql 4.0.12, on mysql
3.23.56 it works.
Let me demonstrate it:
on mysql 3.23.56:
as root:
mysql create database test_dummy;
Query OK, 0 rows affected (0.00 sec)
mysql grant all on test_dummy.* to dummy;
Query OK, 0 rows affected (0.00 sec)
mysql set password for 'dummy'=password('testpass');
Query OK, 0 rows affected (0.00 sec)
mysql flush privileges;
Query OK, 0 rows affected (0.01 sec)
mysql exit
Bye
-
as a user: dummy:
-
mysql set password=password('testpass1');
Query OK, 0 rows affected (0.01 sec)
-
so user 'dummy' can change private password. This is what I need.
now the same operations on mysql 4.0.12:
as root:
mysql create database test_dummy;
Query OK, 0 rows affected (0.00 sec)
mysql grant all on test_dummy.* to dummy;
Query OK, 0 rows affected (0.00 sec)
mysql set password for 'dummy'=password('testpass');
Query OK, 0 rows affected (0.00 sec)
mysql flush privileges;
Query OK, 0 rows affected (0.01 sec)
mysql exit
Bye
and as a user: dummy:
mysql set password=password('testpass1');
ERROR 1044: Access denied for user: 'dummy@'host_ip' to database 'mysql'
User dummy cannot change his own password ...
Any idea how to change it ? Or some hints where is a my mistake ?
On the 4.0.12 machine, what does SELECT CURRENT_USER() return?
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
MySQL Users Conference: April 14-16, 2004
http://www.mysql.com/uc2004/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 4.0.18 or 4.1.1-alpha?
If it's going to be a full production environment where stability is crucial, use 4.0.18. If it is going to be for a development proyect, you can use 4.1.1 and enjoy the new features. Anyway, 4.1.1 seems to be quite stable if you ask me. But it might depend on how much are you willing to risk Best Regards! On Fri, 2004-03-05 at 12:24, Samuele wrote: I have to install MySQL in our web servers. I don't know if choosing 4.0.18 stable version or 4.1.1-alpha. I'd prefer the first one, but in this case I'd lose some important features. What do you suggest me? Thank's Samuele ca2000 padova (italy) -- |...| | _ _|Victor Medina M | |\ \ \| | _ \ / \ |Linux - Java - MySQL | | \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria EPA | | / / / |___| __/ ___ \ |[EMAIL PROTECTED] | |/_/_/|_|_| /_/ \_\|ext. 325 - Tél: +58-241-8507325 | ||geek by nature - linux by choice | |...|
mysqldump of UTF8 db
Hi all, I was just testing if my utf8 table would restore properly. When I execute mysqldump -umysqladmin -pmysqladmin test C:\mysql\bin\test-bp.sql No tables are created. Instead I what get in my DOS console (WinXpPro) is the beginning and end of the dump file (having skipped all the restoration bits!) which is what follows I am new at this. Could anybody please offer any ideas on what goes wrong here? I need to resolve this in order backup my whole database. Thank you for your time, Theo -- MySQL dump 10.4 -- -- Host: localhostDatabase: test -- -- -- Server version 4.1.1a-alpha-nt /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT, CHARACTER_SET_CLI ENT=utf8 */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE=NO_AUTO_VALUE_ON_ZERO */; /*!40101 SET [EMAIL PROTECTED] */; /*!40014 SET [EMAIL PROTECTED] */; /*!40014 SET [EMAIL PROTECTED] */; /*!40101 SET [EMAIL PROTECTED] */;
DROP tables question(s)?
Howdy -- How can I drop all tables in a databases? How can I drop tables beginning with foo_ Note, I don't have permissons to just drop the db. TX, David -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SET PASSWORD troubles on mysql 4.0.12 (ERROR 1044)
On Fri, 5 Mar 2004, Paul DuBois wrote:
At 18:10 +0100 3/5/04, Bogdan Lobodzinski wrote:
Hello,
All users should be able to change their own password on any mysql.
I have trouble to allow this feature on mysql 4.0.12, on mysql
3.23.56 it works.
Let me demonstrate it:
on mysql 3.23.56:
as root:
mysql create database test_dummy;
Query OK, 0 rows affected (0.00 sec)
mysql grant all on test_dummy.* to dummy;
Query OK, 0 rows affected (0.00 sec)
mysql set password for 'dummy'=password('testpass');
Query OK, 0 rows affected (0.00 sec)
mysql flush privileges;
Query OK, 0 rows affected (0.01 sec)
mysql exit
Bye
-
as a user: dummy:
-
mysql set password=password('testpass1');
Query OK, 0 rows affected (0.01 sec)
-
so user 'dummy' can change private password. This is what I need.
now the same operations on mysql 4.0.12:
as root:
mysql create database test_dummy;
Query OK, 0 rows affected (0.00 sec)
mysql grant all on test_dummy.* to dummy;
Query OK, 0 rows affected (0.00 sec)
mysql set password for 'dummy'=password('testpass');
Query OK, 0 rows affected (0.00 sec)
mysql flush privileges;
Query OK, 0 rows affected (0.01 sec)
mysql exit
Bye
and as a user: dummy:
mysql set password=password('testpass1');
ERROR 1044: Access denied for user: 'dummy@'host_ip' to database 'mysql'
User dummy cannot change his own password ...
Any idea how to change it ? Or some hints where is a my mistake ?
On the 4.0.12 machine, what does SELECT CURRENT_USER() return?
mysql SELECT CURRENT_USER();
++
| CURRENT_USER() |
++
| dummy@host_ip|
++
1 row in set (0.01 sec)
user dummy@host_ip is exactly the same like in the ERROR outoput.
I just noticed small mistake in the ERROR output. The proper one is:
mysql set password=password('testpass1');
ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'mysql'
Cheers,
Bogdan
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
MySQL Users Conference: April 14-16, 2004
http://www.mysql.com/uc2004/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 4.0.18 or 4.1.1-alpha?
Hi, If you use any 3rd party clients like EMS mysql manager. Check that they have updated their binaries to support changes in 4.1, if they have not, you won't be able to connect to 4.1. That was a big pain for me. I wanted to start using 4.1 on a backup server part time. But we use EMS a great deal. thanks, Eric At 09:31 AM 3/5/2004, Victor Medina wrote: If it's going to be a full production environment where stability is crucial, use 4.0.18. If it is going to be for a development proyect, you can use 4.1.1 and enjoy the new features. Anyway, 4.1.1 seems to be quite stable if you ask me. But it might depend on how much are you willing to risk Best Regards! On Fri, 2004-03-05 at 12:24, Samuele wrote: I have to install MySQL in our web servers. I don't know if choosing 4.0.18 stable version or 4.1.1-alpha. I'd prefer the first one, but in this case I'd lose some important features. What do you suggest me? Thank's Samuele ca2000 padova (italy) -- |...| | _ _|Victor Medina M | |\ \ \| | _ \ / \ |Linux - Java - MySQL | | \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria EPA | | / / / |___| __/ ___ \ |[EMAIL PROTECTED] | |/_/_/|_|_| /_/ \_\|ext. 325 - Tél: +58-241-8507325 | ||geek by nature - linux by choice | |...| -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 4.0.18 or 4.1.1-alpha?
If you use the old-password settings in your server, ems should connect with out a hitch Best Regards! On Fri, 2004-03-05 at 13:41, Eric wrote: Hi, If you use any 3rd party clients like EMS mysql manager. Check that they have updated their binaries to support changes in 4.1, if they have not, you won't be able to connect to 4.1. That was a big pain for me. I wanted to start using 4.1 on a backup server part time. But we use EMS a great deal. thanks, Eric At 09:31 AM 3/5/2004, Victor Medina wrote: If it's going to be a full production environment where stability is crucial, use 4.0.18. If it is going to be for a development proyect, you can use 4.1.1 and enjoy the new features. Anyway, 4.1.1 seems to be quite stable if you ask me. But it might depend on how much are you willing to risk Best Regards! On Fri, 2004-03-05 at 12:24, Samuele wrote: I have to install MySQL in our web servers. I don't know if choosing 4.0.18 stable version or 4.1.1-alpha. I'd prefer the first one, but in this case I'd lose some important features. What do you suggest me? Thank's Samuele ca2000 padova (italy) -- |...| | _ _|Victor Medina M | |\ \ \| | _ \ / \ |Linux - Java - MySQL | | \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria EPA | | / / / |___| __/ ___ \ |[EMAIL PROTECTED] | |/_/_/|_|_| /_/ \_\|ext. 325 - Tél: +58-241-8507325 | ||geek by nature - linux by choice | |...| -- |...| | _ _|Victor Medina M | |\ \ \| | _ \ / \ |Linux - Java - MySQL | | \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria EPA | | / / / |___| __/ ___ \ |[EMAIL PROTECTED] | |/_/_/|_|_| /_/ \_\|ext. 325 - Tél: +58-241-8507325 | ||geek by nature - linux by choice | |...|
Re: Major problem converting MyISAM to InnoDB
Cliff, I do not think this is a threading issue. This looks now more like a wrong .frm file problem. Please use innodb_table_monitor as I suggested earlier, and compare the table definition inside InnoDB to what SHOW CREATE TABLE says. Best regards, Heikki Innobase Oy InnoDB - transactions, row level locking, and foreign keys for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php Register now for the 2004 MySQL Users Conference! http://www.mysql.com/events/uc2004/index.html .. List: MySQL General Discussion« Previous MessageNext Message » From: Cliff Date: March 5 2004 8:12am Subject: Re: Major problem converting MyISAM to InnoDB I think I may have gotten closer to the root of the problem. It seems that the field named 'comments' is the one that crashes the server when it is selected. Here is the output of the logs when I do 'select comments from allusa': 040304 23:14:52 mysqld restarted 040304 23:14:53 InnoDB: Started /mnt/disk2/mysql/bin/mysqld: ready for connections. Version: '4.0.18-standard-log' socket: '/tmp/mysql.sock' port: 3306 Fatal error '_waitq_remove: Not in queue' at line ? in file /usr/src/lib/libc_r/uthread/uthread_priority_queue.c (errno = ?) Number of processes running now: 0 I searched google and it seems that error has been seen in many programs since it is a threading issue. Any ideas on what would cause this? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SET PASSWORD troubles on mysql 4.0.12 (ERROR 1044)
At 18:38 +0100 3/5/04, Bogdan Lobodzinski wrote:
On Fri, 5 Mar 2004, Paul DuBois wrote:
At 18:10 +0100 3/5/04, Bogdan Lobodzinski wrote:
Hello,
All users should be able to change their own password on any mysql.
I have trouble to allow this feature on mysql 4.0.12, on mysql
3.23.56 it works.
Let me demonstrate it:
on mysql 3.23.56:
as root:
mysql create database test_dummy;
Query OK, 0 rows affected (0.00 sec)
mysql grant all on test_dummy.* to dummy;
Query OK, 0 rows affected (0.00 sec)
mysql set password for 'dummy'=password('testpass');
Query OK, 0 rows affected (0.00 sec)
mysql flush privileges;
Query OK, 0 rows affected (0.01 sec)
mysql exit
Bye
-
as a user: dummy:
-
mysql set password=password('testpass1');
Query OK, 0 rows affected (0.01 sec)
-
so user 'dummy' can change private password. This is what I need.
now the same operations on mysql 4.0.12:
as root:
mysql create database test_dummy;
Query OK, 0 rows affected (0.00 sec)
mysql grant all on test_dummy.* to dummy;
Query OK, 0 rows affected (0.00 sec)
mysql set password for 'dummy'=password('testpass');
Query OK, 0 rows affected (0.00 sec)
mysql flush privileges;
Query OK, 0 rows affected (0.01 sec)
mysql exit
Bye
and as a user: dummy:
mysql set password=password('testpass1');
ERROR 1044: Access denied for user: 'dummy@'host_ip' to database 'mysql'
User dummy cannot change his own password ...
Any idea how to change it ? Or some hints where is a my mistake ?
On the 4.0.12 machine, what does SELECT CURRENT_USER() return?
mysql SELECT CURRENT_USER();
++
| CURRENT_USER() |
++
| dummy@host_ip|
++
1 row in set (0.01 sec)
user dummy@host_ip is exactly the same like in the ERROR outoput.
I just noticed small mistake in the ERROR output. The proper one is:
mysql set password=password('testpass1');
ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'mysql'
Do you in fact have more than one account with a username of dummy on
the 4.0.12 machine?
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
MySQL Users Conference: April 14-16, 2004
http://www.mysql.com/uc2004/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Dump Command Does Not Consider Foreign Key Dependencies
Description: The current mysqldump utility does an alphabetical dump of the tables as well as a row by row dump of the data following each table declaration. This is adequate enough for most databases; however, if there are strict foreign key constraints, the ordering will not always be conducive to utilizing mysqldump output to restore databases causing major headaches in order to restore when the table structures are sophisticated and/or if there is considerable BLOB output in the output. How-To-Repeat: I apologize for any syntactical mistakes, but I'm sure you can get the idea. Consider two tables: a,b. After creating these tables, defining several columns, and then implementing foreign keys, if a has a foreign key constraint on yet-to-be-created b in dump output, then a will fail to create. Further, even if a were to be created, data input into a would fail without the supporting rows in b. Fix: Ultimately, a dependency graph needs to be considered before dumping in order to dump the tables and data in an order that will allow the output to be used to restore the data rather than alphabetical. However, if we assume that the data existing now is in a normal state (simplified to mean, fulfills foreign key constraints), then we could dump structure and data in same order, but suppress details about the foreign key constraints and have those appended to the dump output as ALTER TABLE statements. I believe the latter to be a much simpler fix and would eliminate this problem. Submitter-Id: submitter ID Originator:Stephen Cuppett Organization: MySQL support: none Synopsis: Dump Data ABC order Inconsiderate of Foreign Key Constraints Severity: serious Priority: medium Category: mysql Class: change-request Release: mysql-4.0.17-standard (Official MySQL RPM) C compiler:2.95.3 C++ compiler: 2.95.3 Environment: System: Linux cuppett1 2.4.21-192-smp #1 SMP Wed Feb 18 19:31:29 UTC 2004 i686 athlon i386 GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i586-suse-linux/3.3.1/specs Configured with: ../configure --enable-threads=posix --prefix=/usr --with-local-prefix=/usr/local --infodir=/usr/share/info --mandir=/usr/share/man --libdir=/usr/lib --enable-languages=c,c++,f77,objc,java,ada --disable-checking --enable-libgcj --with-gxx-include-dir=/usr/include/g++ --with-slibdir=/lib --with-system-zlib --enable-shared --enable-__cxa_atexit i586-suse-linux Thread model: posix gcc version 3.3.1 (SuSE Linux) Compilation info: CC='gcc' CFLAGS='-O2 -mcpu=i486 -fno-strength-reduce' CXX='g++' CXXFLAGS='-O2 -mcpu=i486 -fno-strength-reduce-felide-constructors -fno-exceptions -fno-rtti ' LDFLAGS='' ASFLAGS='' LIBC: -rwxr-xr-x1 root root 1469811 2003-09-23 19:05 /lib/libc.so.6 -rw-r--r--1 root root 13553180 2003-09-23 12:04 /usr/lib/libc.a -rw-r--r--1 root root 204 2003-09-23 12:04 /usr/lib/libc.so -rw-r--r--1 root root 982008 2003-09-23 14:29 /usr/lib/libc-client.a lrwxrwxrwx1 root root 20 2004-01-08 19:04 /usr/lib/libc-client.so - libc-client.so.2002d -rwxr-xr-x1 root root 770436 2003-09-23 14:29 /usr/lib/libc-client.so.2002d Configure command: ./configure '--disable-shared' '--with-mysqld-ldflags=-all-static' '--with-client-ldflags=-all-static' '--with-server-suffix=-standard' '--without-embedded-server' '--without-berkeley-db' '--with-innodb' '--without-vio' '--without-openssl' '--enable-assembler' '--enable-local-infile' '--with-mysqld-user=mysql' '--with-unix-socket-path=/var/lib/mysql/mysql.sock' '--prefix=/' '--with-extra-charsets=complex' '--exec-prefix=/usr' '--libexecdir=/usr/sbin' '--libdir=/usr/lib' '--sysconfdir=/etc' '--datadir=/usr/share' '--localstatedir=/var/lib/mysql' '--infodir=/usr/share/info' '--includedir=/usr/include' '--mandir=/usr/share/man' '--enable-thread-safe-client' '--with-comment=Official MySQL RPM' 'CC=' 'CFLAGS=-O2 -mcpu=i486 -fno-strength-reduce' 'CXXFLAGS=-O2 -mcpu=i486 -fno-strength-reduce-felide-constructors -fno-exceptions -fno-rtti ' 'CXX=' -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Major problem converting MyISAM to InnoDB
Cliff wrote: I think I may have gotten closer to the root of the problem. It seems that the field named 'comments' is the one that crashes the server when it is selected. Here is the output of the logs when I do 'select comments from allusa': 040304 23:14:52 mysqld restarted 040304 23:14:53 InnoDB: Started /mnt/disk2/mysql/bin/mysqld: ready for connections. Version: '4.0.18-standard-log' socket: '/tmp/mysql.sock' port: 3306 Fatal error '_waitq_remove: Not in queue' at line ? in file /usr/src/lib/libc_r/uthread/uthread_priority_queue.c (errno = ?) Number of processes running now: 0 I searched google and it seems that error has been seen in many programs since it is a threading issue. Any ideas on what would cause this? Threading error is probably a consequence of the process getting SIGSEGV, which happens most likely because the .frm you have defines a different physical structure of the record than the one that is really there in the table space. If you access a field after comments (in the physical layout), do you crash or get garbage? -- Sasha Pachev Create online surveys at http://www.surveyz.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How can I disable 'max_connect_errors'?
Daevid Vincent wrote: Is there a way to disable this 'max_connect_errors' thing? http://www.mysql.com/doc/en/Blocked_host.html Tried max_connect_errors=0 but then it shows up as max_connect_errors=1 What is the 'max' that this value can be in case? We have it set to 10,000 now, but that only buys us time. When is this counter reset? on FLUSH HOSTS Is it ongoing until a FLUSH HOSTS? yes Is it until mysql is restarted? it does also reset on restart To disable for practical purposes, set it to 2^32-1 = 4294967295. On top, once a day run FLUSH HOSTS At the same time try to figure out why you are getting so many of them. -- Sasha Pachev Create online surveys at http://www.surveyz.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Replication broken after upgrade from 4 to 4.1
Stefan Kuhn wrote: Hi everybody, I have three mysql servers doing a circular replication. They (still) run Redhat 7.3. I started with Mysql 3.23, upgraded to 4 and yesterday I tried 4.1. I'm using official mysql rpms. Now the replication is broken. One server always says Connecting to master. The error log says: 040304 19:11:58 Slave I/O thread: error connecting to master '[EMAIL PROTECTED] 47.62:3306': Error: 'Lost connection to MySQL server during query' errno: 2013 retry-time: 60 retries: 86400 The server which is supposed to replicate fromt this server says: Waiting for master to send event. The log says: 040304 16:47:59 Got fatal error 1236: 'Could not find first log file name in binary log index file' from master when reading data from binary log The third replication finally seems to work. I did not change anything in configuration, passwords etc. It's all the same. Something to note: The two servers able to replicate are in the same network, the one which makes trouble is in another, firewall protected network. Port 3306 is open in both firewalls and it always worked. Does anybody have any tips? Thanks a lot (I'm really desparate) Stefan For simplicity, make sure all servers have the same version and start all together in sync with fresh logs. Newer versions might be confused by the old logs from the old versions. -- Sasha Pachev Create online surveys at http://www.surveyz.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: slave hotbackup question
Mark, http://www.innodb.com/manual.php#advanced.slave describes how to set up a new slave from a hot backup of a master. If you take a hot backup of a slave, and want to use it to set up a new slave, then the important coordinate is the MASTER binlog position that mysqld prints when you start mysqld on that new hot backup (do not mix this with the binlog position of the slave's own binlog). The new slave should start replication from that master binlog position. Relay logs etc. are not needed in the backup. Only 1) .frm files, 2) .MYI and .MYD files, 3) ibdata files, 4) ib_logfiles (these are generated in the ibbackup --apply-log phase), 5) .ibd files if you are using = MySQL-4.1.1, 6) default charset files in database directories if you are using = 4.1, and have worked with exotic charsets. Best regards, Heikki Innobase Oy InnoDB - transactions, row level locking, and foreign keys for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php Register now for the 2004 MySQL Users Conference! http://www.mysql.com/events/uc2004/index.html ... From: Mark Steele Date: March 3 2004 6:53pm Subject: slave hotbackup question Hi folks, I have a question regarding backups taken from a running slave. I have a slave replicating to a master server, and do a hot backup using the following script: ... My question is, suppose I would like to use one of these backups to create a new slave server, what additional information would I need to include in the backup to be able to start up a new slave properly? (relay logs/info files, etc...) Ideally, I would like these snapshots to be taken off the running server while it is in use, is there any way to do this? Regards, Mark Steele Implementation Director CDT Inc. [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Please help with join issue
I need help with rewriting a sql query. Nested queries that work in MS databases apparently do not work in MySQL databases. Here is what I need in MS query pseudo code: SELECT table1.myfield1, table2.myfield2 FROM table1, table2 WHERE table1.key=table2.key AND myfield1=something AND myfield2 NOT IN (SELECT myfield2 FROM table3 WHERE table3.myfield3=whatever) For example, if I wanted to get all Forum Posts (Table1) for TopicA that do NOT have replies (Table3) by User1. I have been going crazy trying joins - lefts, rights, inners, outers... Any help would be greatly appreciated!! __ Do you Yahoo!? Yahoo! Search - Find what youre looking for faster http://search.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
lire des fichiers windev5
Bonjour, La possibilité de lire directement les fichiers windev5 au format hyperfile pour exploiter les données ou les migrer sous mysql existe-t-elle? Merci. Pierre Marcotte -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 4.0.18 or 4.1.1-alpha?
Hi, hmm, mysql support needed to know that a few weeks ago! :) Thanks, Eric At 09:58 AM 3/5/2004, Victor Medina wrote: If you use the old-password settings in your server, ems should connect with out a hitch Best Regards! On Fri, 2004-03-05 at 13:41, Eric wrote: Hi, If you use any 3rd party clients like EMS mysql manager. Check that they have updated their binaries to support changes in 4.1, if they have not, you won't be able to connect to 4.1. That was a big pain for me. I wanted to start using 4.1 on a backup server part time. But we use EMS a great deal. thanks, Eric At 09:31 AM 3/5/2004, Victor Medina wrote: If it's going to be a full production environment where stability is crucial, use 4.0.18. If it is going to be for a development proyect, you can use 4.1.1 and enjoy the new features. Anyway, 4.1.1 seems to be quite stable if you ask me. But it might depend on how much are you willing to risk Best Regards! On Fri, 2004-03-05 at 12:24, Samuele wrote: I have to install MySQL in our web servers. I don't know if choosing 4.0.18 stable version or 4.1.1-alpha. I'd prefer the first one, but in this case I'd lose some important features. What do you suggest me? Thank's Samuele ca2000 padova (italy) -- |...| | _ _|Victor Medina M | |\ \ \| | _ \ / \ |Linux - Java - MySQL | | \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria EPA | | / / / |___| __/ ___ \ |[EMAIL PROTECTED] | |/_/_/|_|_| /_/ \_\|ext. 325 - Tél: +58-241-8507325 | ||geek by nature - linux by choice | |...| -- |...| | _ _|Victor Medina M | |\ \ \| | _ \ / \ |Linux - Java - MySQL | | \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria EPA | | / / / |___| __/ ___ \ |[EMAIL PROTECTED] | |/_/_/|_|_| /_/ \_\|ext. 325 - Tél: +58-241-8507325 | ||geek by nature - linux by choice | |...| -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Hitting max_connections - safe to raise this?
Alex Greg wrote: Hi, Our main database server is a 2 x PIII 1.2Ghz with 1.5GB RAM and a 73GB SCSI RAID-5 made up of 3 36GB disks. It does between 300 and 1200 queries per second. The read to write ratio is about 4:1. My problem is that we're hitting our max_connections more and more frequently. Is it safe to raise this to (say) 200, or will this cause performance problems? Already the machine is using up a lot of swap; would you recommend that I bump the RAM up to 2GB, or should I bring down the key_buffer_size in order to fit everything into physical RAM? Should I be concerned about the load average of the machine - it goes up to 6 at some points in the day. max_connections is more like a speed governor in a car. The default is set for use by a not so responsible teenager that may want to try to impress his girlfriend with his driving skills. If you are driving an ambulance, it's ok to raise the limit. Set it to 1000 or even 2000 and just watch your system to make sure you have enough resources. Are there any other performance tips that anyone can give based on this configuration? If you need more information, please let me know. Spikes in connections are usually a symptom of inefficient queries. Police your slow log (turn on log-slow-queries and log-long-format) and explain every query you find there starting with the ones that examine most rows. I also noticed very high system CPU. This usually means you are doing more I/O that you should. Ideal ratio (at least on Linux) is 70 % user/ 30% system. If you lean a lot more towards user, something is wrong with the libraries or mysqld itself to make it spin wheels, if you lean a lot the other way, you are probably scanning tables a lot. Do not sweat over the server buffer size tuning too much - compared to query optimization, there is rarely much room for improvement over the defaults, but there is quite a bit more room for trouble if you get too excited. Tune them after your slow log is either empty or at least every query is accounted for. -- Sasha Pachev Create online surveys at http://www.surveyz.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Iterating thru FullText Index
Is there any way to iterate thru the keys in a fulltext index? This issue
does not come up for other indexes since ORDER BY can achieve this:
For example if table t is indexed on part_id
SELECT DISTINCT part_id FROM t ORDER by part_id;
will return all keys in index order
Is there a way to do this for a fulltext index so that a query would
return a list of all words in the index - this could be helpful
to build dictionaries for ex.
Ex:
mysql CREATE TABLE articles (
- id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
- title VARCHAR(200),
- body TEXT,
- FULLTEXT (title,body)
- );
Query OK, 0 rows affected (0.00 sec)
mysql INSERT INTO articles VALUES
- (NULL,'MySQL Tutorial', 'DBMS stands for DataBase ...'),
- (NULL,'How To Use MySQL Efficiently', 'After you went through a
...'),
- (NULL,'Optimizing MySQL','In this tutorial we will show ...'),
- (NULL,'1001 MySQL Tricks','1. Never run mysqld as root. 2. ...'),
- (NULL,'MySQL vs. YourSQL', 'In the following database comparison
...'),
- (NULL,'MySQL Security', 'When configured properly, MySQL ...');
Query OK, 6 rows affected (0.00 sec)
Records: 6 Duplicates: 0 Warnings: 0
mysql SELECT * FROM articles
- WHERE MATCH (title,body) AGAINST ('database');
++---+--+
| id | title | body |
++---+--+
| 5 | MySQL vs. YourSQL | In the following database comparison ... |
| 1 | MySQL Tutorial| DBMS stands for DataBase ... |
++---+--+
2 rows in set (0.00 sec)
I'm looking for a way to get a result set that would look like
mysql phony query SELECT KEYS from articles USING INDEX (TITLE BODY);
MySql
Tutorial
DBMS
Efficiently
... etc...
This would be nifty.
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: lire des fichiers windev5
Bonjour Pierre, Non mysql ne support pas un format hyperfile. C'est un format propriétaire. S'il il est possible d'exporter les donnees en format ASCII ça pouvait marcher avec un mysqlimport ou load data commande. Voici le doc en français: http://www.mysql.com/doc/fr/mysqlimport.html En plus s'il est possible ce liste est en anglais. Je crois que le list mysql en français est mort. Amicalement, Ken - Original Message - From: sa cefrais [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 05, 2004 12:20 PM Subject: lire des fichiers windev5 Bonjour, La possibilité de lire directement les fichiers windev5 au format hyperfile pour exploiter les données ou les migrer sous mysql existe-t-elle? Merci. Pierre Marcotte -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How long should I keep binary logs?
Two INNODB/mysql/Win questions from a new user: [1] How long should I keep around copies of binarylog? (They're used to recover in case of failure, yes? (I'm also shutting down the databases and dumping them each night to a large text file as backup, too.) [2] Can anyone offer advice (or links to articles, etc) on best practices for backing up INNODB/mydql systems, and doing preventative/routine maintenance? Thanks from this newbie --TO dir 01/06/2004 06:06 PM 4,340,590 binarylog.015 01/07/2004 06:06 PM 3,704,180 binarylog.016 many lines snipped 03/02/2004 06:07 PM 6,124,181 binarylog.080 03/03/2004 09:10 PM 6,929,777 binarylog.081 03/04/2004 06:07 PM 5,813,520 binarylog.082 03/05/2004 01:15 PM 5,769,200 binarylog.083 03/05/2004 05:00 AM 2,324 binarylog.index -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL Dump Command Does Not Consider Foreign Key Dependencies
i turn off the checks before a dump in order to restore it properly.
In my scripts looks like:
echo SET FOREIGN_KEY_CHECKS=0;
${mysql_backup_directory}/${2}/${database_filename}
mysqldump --opt -h $2 -P $3 -u $db_username --password=$db_password $1
${mysql_backup_directory}/${2}/${database_filename} 2 $logfile
}
I would suggest that this can be included as a mysqldump option (--nochecks
or similar).
Carlos
Original Message Follows
From: Stephen Cuppett [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: MySQL Dump Command Does Not Consider Foreign Key Dependencies
Date: Fri, 05 Mar 2004 13:06:09 -0500
Description:
The current mysqldump utility does an alphabetical dump of the
tables as well as a row by row dump of the data following each
table declaration. This is adequate enough for most
databases; however, if there are strict foreign key
constraints, the ordering will not always be conducive to
utilizing mysqldump output to restore databases causing major
headaches in order to restore when the table structures are
sophisticated and/or if there is considerable BLOB output in
the output.
How-To-Repeat:
I apologize for any syntactical mistakes, but I'm sure you can
get the idea. Consider two tables: a,b. After creating
these tables, defining several columns, and then implementing
foreign keys, if a has a
foreign key constraint on yet-to-be-created b in dump output,
then a will fail to create. Further, even if a were to be
created, data input into a would fail without the supporting
rows in b.
Fix:
Ultimately, a dependency graph needs to be considered before
dumping in order to dump the tables and data in an order that
will allow the output to be used to restore the data rather
than alphabetical. However, if we assume that the data
existing now is in a normal state (simplified to mean,
fulfills foreign key constraints), then we could dump
structure and data in same order, but suppress details about
the foreign key constraints and have those appended to the
dump output as ALTER TABLE statements. I believe the latter
to be a much simpler fix and would eliminate this problem.
Submitter-Id: submitter ID
Originator:Stephen Cuppett
Organization:
MySQL support: none
Synopsis: Dump Data ABC order Inconsiderate of Foreign Key
Constraints
Severity: serious
Priority: medium
Category: mysql
Class: change-request
Release: mysql-4.0.17-standard (Official MySQL RPM)
C compiler:2.95.3
C++ compiler: 2.95.3
Environment:
System: Linux cuppett1 2.4.21-192-smp #1 SMP Wed Feb 18 19:31:29 UTC 2004
i686 athlon i386 GNU/Linux
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
/usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i586-suse-linux/3.3.1/specs
Configured with: ../configure --enable-threads=posix --prefix=/usr
--with-local-prefix=/usr/local --infodir=/usr/share/info
--mandir=/usr/share/man --libdir=/usr/lib
--enable-languages=c,c++,f77,objc,java,ada --disable-checking
--enable-libgcj --with-gxx-include-dir=/usr/include/g++ --with-slibdir=/lib
--with-system-zlib --enable-shared --enable-__cxa_atexit i586-suse-linux
Thread model: posix
gcc version 3.3.1 (SuSE Linux)
Compilation info: CC='gcc' CFLAGS='-O2 -mcpu=i486 -fno-strength-reduce'
CXX='g++' CXXFLAGS='-O2 -mcpu=i486 -fno-strength-reduce
-felide-constructors -fno-exceptions -fno-rtti '
LDFLAGS='' ASFLAGS=''
LIBC:
-rwxr-xr-x1 root root 1469811 2003-09-23 19:05 /lib/libc.so.6
-rw-r--r--1 root root 13553180 2003-09-23 12:04 /usr/lib/libc.a
-rw-r--r--1 root root 204 2003-09-23 12:04 /usr/lib/libc.so
-rw-r--r--1 root root 982008 2003-09-23 14:29
/usr/lib/libc-client.a
lrwxrwxrwx1 root root 20 2004-01-08 19:04
/usr/lib/libc-client.so - libc-client.so.2002d
-rwxr-xr-x1 root root 770436 2003-09-23 14:29
/usr/lib/libc-client.so.2002d
Configure command: ./configure '--disable-shared'
'--with-mysqld-ldflags=-all-static' '--with-client-ldflags=-all-static'
'--with-server-suffix=-standard' '--without-embedded-server'
'--without-berkeley-db' '--with-innodb' '--without-vio' '--without-openssl'
'--enable-assembler' '--enable-local-infile' '--with-mysqld-user=mysql'
'--with-unix-socket-path=/var/lib/mysql/mysql.sock' '--prefix=/'
'--with-extra-charsets=complex' '--exec-prefix=/usr'
'--libexecdir=/usr/sbin' '--libdir=/usr/lib' '--sysconfdir=/etc'
'--datadir=/usr/share' '--localstatedir=/var/lib/mysql'
'--infodir=/usr/share/info' '--includedir=/usr/include'
'--mandir=/usr/share/man' '--enable-thread-safe-client'
'--with-comment=Official MySQL RPM' 'CC=' 'CFLAGS=-O2 -mcpu=i486
-fno-strength-reduce' 'CXXFLAGS=-O2 -mcpu=i486 -fno-strength-reduce
Re: MySQL Dump Command Does Not Consider Foreign Key Dependencies
Stephen, in = 4.0, you should put SET FOREIGN_KEY_CHECKS=0; at the start of the dump file. In 4.1, mysqldump knows to add to a dump file a line /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0*/ to disable foreign key checks in the dump file. Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php Register now for the 2004 MySQL Users Conference! http://www.mysql.com/events/uc2004/index.html - Original Message - From: Stephen Cuppett [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Friday, March 05, 2004 8:11 PM Subject: MySQL Dump Command Does Not Consider Foreign Key Dependencies Description: The current mysqldump utility does an alphabetical dump of the tables as well as a row by row dump of the data following each table declaration. This is adequate enough for most databases; however, if there are strict foreign key constraints, the ordering will not always be conducive to utilizing mysqldump output to restore databases causing major headaches in order to restore when the table structures are sophisticated and/or if there is considerable BLOB output in the output. How-To-Repeat: I apologize for any syntactical mistakes, but I'm sure you can get the idea. Consider two tables: a,b. After creating these tables, defining several columns, and then implementing foreign keys, if a has a foreign key constraint on yet-to-be-created b in dump output, then a will fail to create. Further, even if a were to be created, data input into a would fail without the supporting rows in b. Fix: Ultimately, a dependency graph needs to be considered before dumping in order to dump the tables and data in an order that will allow the output to be used to restore the data rather than alphabetical. However, if we assume that the data existing now is in a normal state (simplified to mean, fulfills foreign key constraints), then we could dump structure and data in same order, but suppress details about the foreign key constraints and have those appended to the dump output as ALTER TABLE statements. I believe the latter to be a much simpler fix and would eliminate this problem. Submitter-Id: submitter ID Originator:Stephen Cuppett Organization: MySQL support: none Synopsis: Dump Data ABC order Inconsiderate of Foreign Key Constraints Severity: serious Priority: medium Category: mysql Class: change-request Release: mysql-4.0.17-standard (Official MySQL RPM) C compiler:2.95.3 C++ compiler: 2.95.3 Environment: System: Linux cuppett1 2.4.21-192-smp #1 SMP Wed Feb 18 19:31:29 UTC 2004 i686 athlon i386 GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i586-suse-linux/3.3.1/specs Configured with: ../configure --enable-threads=posix --prefix=/usr --with-local-prefix=/usr/local --infodir=/usr/share/info --mandir=/usr/share/man --libdir=/usr/lib --enable-languages=c,c++,f77,objc,java,ada --disable-checking --enable-libgcj --with-gxx-include-dir=/usr/include/g++ --with-slibdir=/lib --with-system-zlib --enable-shared --enable-__cxa_atexit i586-suse-linux Thread model: posix gcc version 3.3.1 (SuSE Linux) Compilation info: CC='gcc' CFLAGS='-O2 -mcpu=i486 -fno-strength-reduce' CXX='g++' CXXFLAGS='-O2 -mcpu=i486 -fno-strength-reduce-felide-constructors -fno-exceptions -fno-rtti ' LDFLAGS='' ASFLAGS='' LIBC: -rwxr-xr-x1 root root 1469811 2003-09-23 19:05 /lib/libc.so.6 -rw-r--r--1 root root 13553180 2003-09-23 12:04 /usr/lib/libc.a -rw-r--r--1 root root 204 2003-09-23 12:04 /usr/lib/libc.so -rw-r--r--1 root root 982008 2003-09-23 14:29 /usr/lib/libc-client.a lrwxrwxrwx1 root root 20 2004-01-08 19:04 /usr/lib/libc-client.so - libc-client.so.2002d -rwxr-xr-x1 root root 770436 2003-09-23 14:29 /usr/lib/libc-client.so.2002d Configure command: ./configure '--disable-shared' '--with-mysqld-ldflags=-all-static' '--with-client-ldflags=-all-static' '--with-server-suffix=-standard' '--without-embedded-server' '--without-berkeley-db' '--with-innodb' '--without-vio' '--without-openssl' '--enable-assembler' '--enable-local-infile' '--with-mysqld-user=mysql' '--with-unix-socket-path=/var/lib/mysql/mysql.sock' '--prefix=/' '--with-extra-charsets=complex' '--exec-prefix=/usr' '--libexecdir=/usr/sbin' '--libdir=/usr/lib' '--sysconfdir=/etc' '--datadir=/usr/share'
Re: mysqlbinlog: unknown command errors
Hi Sasha, Thanks for getting back to me on this. I was hoping to use the binlogs as an alternative to rollback.commit in the event that someone for example hoses a table by doing an update and forgetting the where clause. I want to be able to load a snapshot, dump the binlogs out and find and delete the query that hosed the table and then run the rest through mysql. I don't think I can do this with a master/slave setup. Maybe I would have better luck with version 5? Thanks, - Mark I don't think I can do something li Sasha Pachev wrote: Mark Maggelet wrote: Since I didn't get an answer to this, I'll try asking it another way: has anybody gotten a binlog with binary data (images) to load from one server to another? And if so, what version are you using? Thanks, - Mark Mark: If the latest does not work, it is a bug in mysql command line client that needs to be reported. However, mysqlbinlog has a few other issues and in a general case will not produce a reliable query playback. If you have binlog on a remote server you want played back, a better way to do it is to set up your server as a replication slave to the one containing the binlog, and point it to the start of the binlog with CHANGE MASTER TO -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
The index handles accented UTF-8 chars badly
I have a problem with index on a UTF-8 based db/table and mySQL 4.1 (I have tried 5.0 too). I run the mysqld with the --default-character-set=utf8 flag and I'm certain that it's UTF-8 data that I'm putting into the database. To reproduce, follow these simple steps. #--- CREATE DATABASE `database` DEFAULT CHARACTER SET utf8; CREATE TABLE `table` ( `id` VARCHAR( 10 ) NOT NULL , `name` VARCHAR( 10 ) NOT NULL ) CHARACTER SET = utf8; ALTER TABLE `table` ADD INDEX ( `name` ) INSERT INTO `table` ( `id` , `name` ) VALUES ( '1', 'Rene' ); INSERT INTO `table` ( `id` , `name` ) VALUES ( '2', 'René' ); # Now make some queries... SELECT * FROM `table` WHERE `name` = 'Rene'; SELECT * FROM `table` WHERE `name` = 'René'; # These previous two lines work equally, which I reckon is wrong. SELECT * FROM `table` WHERE `name` LIKE 'Rene'; # Seems to work correctly. SELECT * FROM `table` WHERE `name` LIKE 'René'; # This previous line gives no result, and I've understood it is because of how Rene and René are somehow treated as equal. # Solutions: remove Rene and the previous line will work. # Or remove the index. # Or switch to a fulltext index. # Or convert the table to InnoDB. # Of course, all of these options means a huge loss in performance, so they're not to be considered as permanent solutions. # Does anyone know what causes this problem? I reckon this is quite important because data is temporarily lost. # Is this a known problem, is it to be fixed in a future release? Cheers. Rikard http://www.websidorna.com - Gratis e-post, dating, webshop. Tjäna poäng! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: DROP tables question(s)?
David Jackson [EMAIL PROTECTED] wrote: Howdy -- How can I drop all tables in a databases? Get list of table names with SHOW TABLES FROM db_name and compose DROP TABLE statement. How can I drop tables beginning with foo_ In this case you can use SHOW TABLES .. LIKE 'foo\_%' statement to get list of the table names. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Index continues to fail on large database
On February 5, I posted this message to the list describing my problem: http://archives.neohapsis.com/archives/mysql/2004-q1/2398.html I received the following response and posted a reply to this response, respectively reply: http://archives.neohapsis.com/archives/mysql/2004-q1/2426.html response: http://archives.neohapsis.com/archives/mysql/2004-q1/2430.html The gist of the problem is that I am unable, with MySQL 4.0.17 on RedHat Enterprise Linux 2, to full-text index a 17GB customer records table containing about 35 million customer records that my client would like to be able to search. The indexing process keeps failing with the following error: error:127 (record table has crashed) Each time this error occurs, I am able to repair the database and the check it with no errors. The error seems to occur at different points within the indexing process - it is not consistent outside of it's inability to complete successfully. The server is no slouch: Dual 3GHz Zeon with 6GB Ram and a 15K RPM SCSI RAID array on an LSI RAID Card. I am able to index the first million records in a matter of minutes, but the second million records take half a day, and trying to index the whole thing fails after some ridiculous amount of days (about nine days, for instance). A couple follow-up questions to my initial post: 1) I am starting to suspect that the MySQL server parameters, underlying filesystem, or Kernel configuration are at the root of the problem. What settings should I make sure to set in each to optomize this system for indexing and serving the 17GB table of 35 million customer records (about 15 fields per record - standard customer record-like fields)? Also, do you have a recommendation for underlying filesystem? 2) What processes/software/techniques do you recommend for monitoring system IO, disk IO, RAM memory usage, and slack usage during the indexing process? I am truly a newbie when it comes to Linux system monitoring and Linux system optimization, so detailed responses in this regard are appreciated. Thanks, and as always, any responses are greatly appreciated. Devi0s -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 4.1.1 Problem with SELECT INTO OUTFILE
Chris Fossenier [EMAIL PROTECTED] wrote: It seems that each time we select into an OUTFILE that already exists (re-use a name) the server crashes. Anyone have any ideas if this is a setting or just a bug? It's known bug: http://bugs.mysql.com/bug.php?id=2123 -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Partial Replication ?
Bonnet R?my [EMAIL PROTECTED] wrote: Hello, I have a database which is flushed every four hours, and I want to replicate it without replicating the delete queries . Is this possible ? (sorry for my awful english) With mysqlbinlog utility or with SHOW BINLOG EVENTS statement find needed events (DELETE queries). From version 4.1.1 SLAVE START command has UNTIL clause. If you use UNTIL clause when SQL thread reaches given point, it stops. So, specify log file and position in the UNTIL clause. When replication stops, use SET GLOBAL SQL_SLAVE_SKIP_COUNTER to skip next event(s) from the master: http://www.mysql.com/doc/en/START_SLAVE.html http://www.mysql.com/doc/en/SET_GLOBAL_SQL_SLAVE_SKIP_COUNTER.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql_get_metadata with SHOW queries
Nate Blanchard [EMAIL PROTECTED] wrote: According to the C API docs on mysql_get_metadata: If a statement passed to mysql_prepare() is one that produces a result set, mysql_get_metadata() returns the result set metadata in the form of a pointer to a MYSQL_RES structure that can be used to process the meta information such as total number of fields and individual field information. This would imply that using a SHOW TABLES LIKE '?' as my prepared query and then calling mysql_get_metadata() should work just fine. My mysql_prepare() call works just fine, however when I make the call to mysql_get_metadata() it returns NULL. I would expect it to return the meta data describing the resultset for SHOW TABLES just like the docs say. This is happening on the download version of 4.1.1, as well as the latest bitkeeper version of 4.1.2. Is this a known issue? Are you not supposed to be able to use mysql_get_metadata on the SHOW queries? mysql_get_metadata() will work with any other result set returning command (and with SHOW queries too). But currently it's not implemented. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
You are dismissed
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SET PASSWORD troubles on mysql 4.0.12 (ERROR 1044)
On Fri, 5 Mar 2004, Paul DuBois wrote:
At 18:38 +0100 3/5/04, Bogdan Lobodzinski wrote:
On Fri, 5 Mar 2004, Paul DuBois wrote:
At 18:10 +0100 3/5/04, Bogdan Lobodzinski wrote:
Hello,
All users should be able to change their own password on any mysql.
I have trouble to allow this feature on mysql 4.0.12, on mysql
3.23.56 it works.
Let me demonstrate it:
on mysql 3.23.56:
as root:
mysql create database test_dummy;
Query OK, 0 rows affected (0.00 sec)
mysql grant all on test_dummy.* to dummy;
Query OK, 0 rows affected (0.00 sec)
mysql set password for 'dummy'=password('testpass');
Query OK, 0 rows affected (0.00 sec)
mysql flush privileges;
Query OK, 0 rows affected (0.01 sec)
mysql exit
Bye
-
as a user: dummy:
-
mysql set password=password('testpass1');
Query OK, 0 rows affected (0.01 sec)
-
so user 'dummy' can change private password. This is what I need.
now the same operations on mysql 4.0.12:
as root:
mysql create database test_dummy;
Query OK, 0 rows affected (0.00 sec)
mysql grant all on test_dummy.* to dummy;
Query OK, 0 rows affected (0.00 sec)
mysql set password for 'dummy'=password('testpass');
Query OK, 0 rows affected (0.00 sec)
mysql flush privileges;
Query OK, 0 rows affected (0.01 sec)
mysql exit
Bye
and as a user: dummy:
mysql set password=password('testpass1');
ERROR 1044: Access denied for user: 'dummy@'host_ip' to database 'mysql'
User dummy cannot change his own password ...
Any idea how to change it ? Or some hints where is a my mistake ?
On the 4.0.12 machine, what does SELECT CURRENT_USER() return?
mysql SELECT CURRENT_USER();
++
| CURRENT_USER() |
++
| dummy@host_ip|
++
1 row in set (0.01 sec)
user dummy@host_ip is exactly the same like in the ERROR outoput.
I just noticed small mistake in the ERROR output. The proper one is:
mysql set password=password('testpass1');
ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'mysql'
Do you in fact have more than one account with a username of dummy on
the 4.0.12 machine?
no, only 1 dummy account exist. I just created a dummy user only for
tests. The problem appeared when other users tried to change the start-up password.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
MySQL Users Conference: April 14-16, 2004
http://www.mysql.com/uc2004/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Please help with join issue
Erica L Ridley [EMAIL PROTECTED] wrote: I need help with rewriting a sql query. Nested queries that work in MS databases apparently do not work in MySQL databases. Here is what I need in MS query pseudo code: SELECT table1.myfield1, table2.myfield2 FROM table1, table2 WHERE table1.key=table2.key AND myfield1=something AND myfield2 NOT IN (SELECT myfield2 FROM table3 WHERE table3.myfield3=whatever) For example, if I wanted to get all Forum Posts (Table1) for TopicA that do NOT have replies (Table3) by User1. I have been going crazy trying joins - lefts, rights, inners, outers... Any help would be greatly appreciated!! SELECT table1.myfield1, table2.myfield2 FROM table1 INNER JOIN table2 ON(table1.key=table2.key AND table1.myfield1=something) LEFT JOIN table3 ON (table2.myfield2=table3.myfield2 AND table3.myfield3=whatever) WHERE table3.myfield2 IS NULL; -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
What causes a crashed table?
Hi, I ran into a slight problem this morning where MySQL suddenly wouldn't recognize a table anymore. After doing a myisamchk on it, it listed the table as having crashed. myisamchk -r on the table fixed the problem, but I am concerned that this error happened in the first place. I've tried to read thru the MySQL docs, but apparently, I must be looking in the worng places as I can't find anything that specifies what causes MySQL to mark a table as crashed. What kind of circumstances might cause this to happen? The server itself didn't reboot, nor did MySQL restart. Thanks! Eric -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Relationship between libz and libmysqlclient libraries
I notice that, while building C applications that use the libmysqlclient library, I sometimes need to link with libz library, depending on which system I am compiling on. The different systems have different mysql versions installed, so is this due to the difference in the versions? Can someone explain, generally, what functions in libmysqlclient, make use of the libz library and why? And was libz, then, not required in older versions in the past? Thanks, John -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL C API license
Folks, What license does the MySQL C API fall under? I am looking to add client support to a game that I am creating, but need to know the terms of the license etc. -Ron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: The index handles accented UTF-8 chars badly
Hi! On Mar 05, Rikard Bogren wrote: I have a problem with index on a UTF-8 based db/table and mySQL 4.1 (I have tried 5.0 too). I run the mysqld with the --default-character-set=utf8 flag and I'm certain that it's UTF-8 data that I'm putting into the database. To reproduce, follow these simple steps. #--- CREATE DATABASE `database` DEFAULT CHARACTER SET utf8; CREATE TABLE `table` ( `id` VARCHAR( 10 ) NOT NULL , `name` VARCHAR( 10 ) NOT NULL ) CHARACTER SET = utf8; ALTER TABLE `table` ADD INDEX ( `name` ) INSERT INTO `table` ( `id` , `name` ) VALUES ( '1', 'Rene' ); INSERT INTO `table` ( `id` , `name` ) VALUES ( '2', 'Ren?' Don't mind question mark, I know what was there and I used the proper character what I tested it :) ); # Now make some queries... SELECT * FROM `table` WHERE `name` = 'Rene'; SELECT * FROM `table` WHERE `name` = 'Ren?'; # These previous two lines work equally, which I reckon is wrong. This is how utf8_general_ci collation in MySQL is defined. In 4.1.2 or 4.1.3 we'll support more unicode collations, so you'll be able to chose how accents should be treated. SELECT * FROM `table` WHERE `name` LIKE 'Rene'; # Seems to work correctly. SELECT * FROM `table` WHERE `name` LIKE 'Ren?'; # This previous line gives no result, and I've understood it is because of how Rene and Ren? are somehow treated as equal. Works for me - returns 'Ren?' Apparently it's fixed already in 4.1.2 (to be out soon) Regards, Sergei -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Iterating thru FullText Index
Hi! On Mar 05, Todd Burke wrote: Is there any way to iterate thru the keys in a fulltext index? This issue does not come up for other indexes since ORDER BY can achieve this: For example if table t is indexed on part_id SELECT DISTINCT part_id FROM t ORDER by part_id; will return all keys in index order Is there a way to do this for a fulltext index so that a query would return a list of all words in the index - this could be helpful to build dictionaries for ex. No, but you can use an external utility myisam_ftdump to get this functionality. Regards, Sergei -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL C API license
To my knowledge it is GPL. Bernard On Friday 05 March 2004 17:52, Ronald J. Yacketta wrote: Folks, What license does the MySQL C API fall under? I am looking to add client support to a game that I am creating, but need to know the terms of the license etc. -Ron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL 5 Application Error
Table structure: CREATE TABLE `players` ( `PLAYERNO` smallint(6) NOT NULL default '0', `NAME` char(15) NOT NULL default '', `INITIALS` char(3) default NULL, `YEAR_OF_BIRTH` smallint(6) default NULL, `SEX` char(1) default NULL, `YEAR_JOINED` smallint(6) NOT NULL default '0', `STREET` char(15) NOT NULL default '', `HOUSENO` char(4) default NULL, `POSTCODE` char(6) default NULL, `TOWN` char(10) NOT NULL default '', `PHONENO` char(10) default NULL, `LEAGUENO` char(4) default NULL, PRIMARY KEY (`PLAYERNO`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1
query date ranges
I have been trying this is several ways, currently I have a mess
MySQL 4.1.1
PHP as the interface
I have a table of with a date range called seasons.
in it I have two date ranges and an amount to be charged
for each day in the range
2004-01-01 00:00:00 2004-06-01 00:00:0044
2004-06-02 00:00:00 2004-10-31 00:00:00110
seasonDateFrom seasonDateTo seasonRateWeekly
2004-06-02 00:00:002004-10-31 00:00:00 42.86
2004-01-01 00:00:002004-06-01 00:00:00 34.29
When I take a booking I have yet another range
$bookingDateFrom and $BookingDateTo
I need to get the SUM(seasonRateWeekly) for each day in the booking range.
Currently , and here is the bad bit, I can get it to work if I calculate
the number of days in the booking range, then loop through them in php
with foreach and increment a counter
SELECT seasonRateWeekly FROM seasons WHERE DATE_ADD('{$newbookingDateFrom}', INTERVAL
$i DAY)
BETWEEN seasonDateFrom AND seasonDateTo
This of course is almost useless as it takes 40 queries for 40 days. Not efficient at
all.
But I need the individual values, I think, to be able to query across season ranges
should
a booking range span two, or more, seasons.
As always, any help greatfully recieved
Kind regards
Kevin
--
__
(_ \
_) )
| / / _ ) / _ | / ___) / _ )
| | ( (/ / ( ( | |( (___ ( (/ /
|_| \) \_||_| \) \)
Kevin Waterson
Port Macquarie, Australia
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Relationship between libz and libmysqlclient libraries
At 14:17 -0800 3/5/04, John Ling wrote: I notice that, while building C applications that use the libmysqlclient library, I sometimes need to link with libz library, depending on which system I am compiling on. The different systems have different mysql versions installed, so is this due to the difference in the versions? Can someone explain, generally, what functions in libmysqlclient, make use of the libz library and why? And was libz, then, not required in older versions in the past? It's used to support the --compress option that causes traffic over the client/server protocol to be compressed. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com MySQL Users Conference: April 14-16, 2004 http://www.mysql.com/uc2004/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 5 Application Error
At 19:44 -0600 3/5/04, Mulugeta Maru wrote: Table structure: CREATE TABLE `players` ( `PLAYERNO` smallint(6) NOT NULL default '0', `NAME` char(15) NOT NULL default '', `INITIALS` char(3) default NULL, `YEAR_OF_BIRTH` smallint(6) default NULL, `SEX` char(1) default NULL, `YEAR_JOINED` smallint(6) NOT NULL default '0', `STREET` char(15) NOT NULL default '', `HOUSENO` char(4) default NULL, `POSTCODE` char(6) default NULL, `TOWN` char(10) NOT NULL default '', `PHONENO` char(10) default NULL, `LEAGUENO` char(4) default NULL, PRIMARY KEY (`PLAYERNO`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 What is your question? -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com MySQL Users Conference: April 14-16, 2004 http://www.mysql.com/uc2004/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problems with Mysql 4.0.15+Tomcat 4.0
Hi, i m using mysql 4.0.15 and tomcat 4 as a webserver on linux 8 machine, now the problem that i am facing is that while testing my web application when i send too many refresh requests to the web page, the server's CPU utilization reaches to 100% for a very long duration of time and on checking the processes going on the server, i see hundreds of processes for tomcat and mysql. Now what am i suppose to do to save my server from crashing and at the same time fulfilling maximum number of requests. I will be very thank ful to u. bye Abubakr -- NOTICE: This email and any files transmitted with it may contain privileged and confidential information and intended solely for the use of the individual or entity to whom they are addressed. Please notify the sender immediately by email if you have received this email by mistake, delete it from your system and you should not use, disseminate, distribute or copy this email. Caution: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses
Can my.cnf actually lessen performance?
OS X 10.3 and mysql 4.x, I have a situation where after time certain queries get really slow, in the area of 30 seconds. I seem to have pinned it down to my use of my-large.cnf. If I remove this file and let just the mysql defaults in, then I seem to not have the trouble, at least, I have 8 hours on it now with no degrade in performance. On a machine with 896MB of ram, would there be anything in my-large.cnf that would cause this? I do run apache, which does some pretty minimal serving. Perhaps I should be custom making a cfg file, if so, what do you look for to optimize your config? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
