Re: Addnew problem
are you using something like this? :: set dbconn = server.createobject(ADODB.Recordset) dbconn.open dsn=yourdsnname;uid=;pwd=;driver=mysql sql = SELECT * FROM tablename recordset.open sql, dbconn insert = INSERT INTO tablename (column1, column2) VALUES ('valueforcolumn1', 'valueforcolumn2') dbconn.execute insert It's much easier that way. 2nd Question: The only thing I can think of is if you are using a WHERE clause. You must be new to this. (by the way, cool name dude). Make sure that database is connecting and you have the right recordset settings. - Deryck H - http://www.comp-u-exchange.com - Original Message - From: vincent de vilder [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 12, 2001 1:29 AM Subject: Addnew problem Hi, When i create a webpage in frontpage in ASP code, de Addnew function to add a record in my mysql database does not function properly. The record is inserted , but the other first existing record will be deleted. What is going wrong here ? ALso when i create a new database with a column ('test') for example, it is not possible to add records when the database is empty, so i have to manualy add a record in the database first. What is here the problem. thanks Vincent de vilder [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Deryck H - http://www.comp-u-exchange.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Same Sockets problem for MySQLGUI but with a different twist.
First - I read the Readme file several times. Second - I went though your listserv where you very politely redirect everyone to the Readme file Third - I'm a newbe to linux and MySQL (Microsoft'er looking for the other world) and I don't know what a socket file would be called or where I would find it. I've searched the drive using whereis and looking for sock or socket but I don't find anything. Could anyone take mercy on a Win2K geek and give me step by step instructions on finding or building this sockets file. Maybe I'll convert completely one day :-) Cheers, Randy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to use JOINS
OK, well, mysql has LEFT JOINS, right? OK then, in that case, how the heck do I use them?! I need to join 14 tables (with the exact same structure, columns) together and view all of there contents with a WHERE clause like this: SELECT * FROM t1, t2, t3, t4, t5, etc ORDER BY date DESC or SELECT * FROM theworks WHERE userid = 'userid' Any suggestions? I need that join. WHY? Because it's ambiguous if I dont have it. - Deryck H - http://www.comp-u-exchange.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Error
Hi, Could somebody tell me what is this? SQL select * from users limit 0,25 failed : Got error 127 from table handler TIA Alex - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error
Hi, Could somebody tell me what is this? SQL select * from users limit 0,25 failed : Got error 127 from table handler TIA Alex http://www.mysql.com/doc/manual.php?search_query=Got+error+127+from+table+ha ndlersubmit=Searchdepth=0 jason - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to use JOINS
On Wed, Sep 12, 2001 at 02:13:59AM -0500, Deryck Henson wrote: OK, well, mysql has LEFT JOINS, right? OK then, in that case, how the heck do I use them?! I need to join 14 tables (with the exact same structure, columns) together and view all of there contents with a WHERE clause like this: SELECT * FROM t1, t2, t3, t4, t5, etc ORDER BY date DESC or SELECT * FROM theworks WHERE userid = 'userid' Any suggestions? I need that join. WHY? Because it's ambiguous if I dont have it. I'm not entirely sure, but it sounds like you might be confusing a JOIN with a UNION. JOINs are used to bring together related records (related in the RDBMS sense of related) into larger records composed of columns from each table. A UNION allows you to treat several similarly structured tables as if the are one large table. MySQL doesn't yet have UNIONs (4.0 will), but it does have MERGE tables which allow you to combine several tables into a sort of virtual table against which you can write queries. Hope this helps, Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 6 days, processed 131,748,231 queries (248/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Video game programming????
Hi I was just browsing thru the amazon.com site and just happened to read a customer review on the MySQL (other new riders) book by Paul DuBios and Michael Widenius. It has a wierd review from someone which says I was extremely dissapointed to say the least. This book doesn't even begin to cover **video game programming in mySQL**, not even the basics. In fact, it doesn't cover **video game programming at all**. . blah blah . The line that caught my attention was the one which are inside the ** symbols. Now, this was something new to me.So, i just thought if anyone could tell me more on this. What's video game programming got to do with MySQL ?? and what does he mean by this. Can anyone enlighten me on this ?? Thanx in advance. Nilesh - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mySQL on unix vs ODBC
Hi everyone ! We've got a problem: running mySQL on unix(sun) we connect a third party windows software over ODBC. All is nice until a windows path is stored in the db Trying to store C:\Program Files\3p SW\ I find that it becomes C:Program Files3p SW. Is it possible, by means of configuration, to have backslashes preserved ? Either in ODBC or ... somewhere ? Facts: 3d party software = no code no chance of changes ODBC - installed from myodbc-2.50.37-nt.zip mySQL - 3.23.39 ( 3.23.41 could be used) thanx in advance peter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: manual
I have tryed to download the mysql manual.pdf but for some reason I cant. Would anyone be able to email me the pdf version? [EMAIL PROTECTED] Hi, I think it's around 3MB.. so if say 10 persons would mail it to you you'll get about 30MB in your mailbox.. If you're using M$ IE you might need to IIRC right click on the link.. mysql, query Bye, B. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Video game programming????
On Wed, Sep 12, 2001 at 01:31:59AM +0530, Nilesh Parmar wrote: Hi I was just browsing thru the amazon.com site and just happened to read a customer review on the MySQL (other new riders) book by Paul DuBios and Michael Widenius. It has a wierd review from someone which says I was extremely dissapointed to say the least. This book doesn't even begin to cover **video game programming in mySQL**, not even the basics. In fact, it doesn't cover **video game programming at all**. . blah blah . The line that caught my attention was the one which are inside the ** symbols. Now, this was something new to me.So, i just thought if anyone could tell me more on this. What's video game programming got to do with MySQL ?? and what does he mean by this. Can anyone enlighten me on this ?? Ah, the Perl and MySQL for the Web book, I imagine. Whoever posted that review was an idiot. As one of the technical reviewers for the book, I bugs me to see that sort of comment there. I believe it's a really good book. I'm sure that others who have read it will agree. I've already recommended it to a few co-workers just for a few specific chapters. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 6 days, processed 132,187,796 queries (248/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: GEMINI Table Type
On Tue, Sep 11, 2001 at 03:29:00PM +0200, Henning Schroeder wrote: At 11:03 11.09.01, you wrote: does MYSQL.COM has a table type same as GEMINI ( GEMINI yes. MySQL contains support for BDB and InnoDB tables, that are transaction-safe. I don´t want to provoke any anger here, maybe i´m still too new on the list. But actually, i´m a bit sick of the current state of the gemini dispute. I have the feeling that you can´t even say the g-word loud here From the description on the mysql.org website, gemini tables look pretty good. But that´s maybe because they are not so easy on describing the problems with their tables as mysql.com on their website (with innodb and bdb tables). Also, it looks just like marketing talk so i refuse to form an opinion from that. I beta tested Gemini before things got interesting. The technology *is* good, but it's also rather controversial (as you've noticed). So could somebody more enlightened than me please fix us up on the technological benefits/drawbacks on these table types? Gemini provides crash recovery, record-level locking, and high levels of concurrency (as their documentation probably says). It really does work--or did when I last tried it. Also, I would very much love to hear about these legal problems. mysql.com still says But the products they [NuSphere] have shipped are and continue to be in GPL violation.. Nusphere gives you an Gemini GPL Source download. One of the two must be wrong :-)) Let's just say that it's rather complex. The mail archives for this list already contain a fair amount of information on the topic. And there's a lot of information that you simply won't get until the legal stuff is all over. I was about to type something to the effect please shake hands, stop sueing each other and live happily. but i see that i´m not clued enough about the situation to have a real opinion. I think that everyone involved would like it to be that simple and easy, but it's clearly not. Is somebody? Yes, but most of the folks who know the details really can't discuss them. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 6 days, processed 132,326,734 queries (248/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mySQL on unix vs ODBC
Thanks Will, to avoid further misunderstandings - the escapefeature of backslash is fully understood. The problem is that the 3d party sw or the myODBC doesn't understand that the inbound text SHOULD HAVE backslash but does exactly whats expected - escape the next char. What I'm asking is - is there any configurable way that ODBC can be made to add that extra escaping backslash needed other than recompiling ODBC which isn't an option for the moment. anyone have clue !?? again, thanx in advance peter Will French [EMAIL PROTECTED] 09/12/01 10:20AM mySQL sees back slashes (\) as escape sequence characters. Use either \\ or substitute forward slashes (/). -Original Message- From: Peter Gad [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 12, 2001 4:10 AM To: [EMAIL PROTECTED] Subject: mySQL on unix vs ODBC Hi everyone ! We've got a problem: running mySQL on unix(sun) we connect a third party windows software over ODBC. All is nice until a windows path is stored in the db Trying to store C:\Program Files\3p SW\ I find that it becomes C:Program Files3p SW. Is it possible, by means of configuration, to have backslashes preserved ? Either in ODBC or ... somewhere ? Facts: 3d party software = no code no chance of changes ODBC - installed from myodbc-2.50.37-nt.zip mySQL - 3.23.39 ( 3.23.41 could be used) thanx in advance peter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
OT: Seeking Active Functioning Israeli IRC Servers
Greetings: Sorry for the off-topic. All bookmarked .il irc servers are currently unavailable. If any on the list has an active .il IRC link it would be helpful. (Israeli BBS-es also useful) You can post anonymously from safeweb.com at http://www.dedserius.com/guestbook/ Best Regards, Van sql, mysql, odbc, select -- = Linux rocks!!! http://www.dedserius.com/ = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ERROR 1073: create InnoDB tables!
Hi, I tried create table specify type=InnoDB. with the following script: create table objects(uri blob not null, primary key uriIndex (uri(255)), classname blob) type=InnoDB; I'm getting the following error ERROR 1073: BLOB column 'uri' can't be used in key specification with the used table type This is what I found in the mySQL docs: * Only the MyISAM table type supports indexing on BLOB and TEXT columns. When putting an index on a BLOB or TEXT column you MUST always specify the length of the index: CREATE TABLE test (blob_col BLOB, index(blob_col(10))); I could change the uri to varchar but... * Values in VARCHAR columns are variable-length strings. I can declare a VARCHAR column to be any length between 1 and 255, just as for CHAR columns. That's not very good, we can choose - transactions but uri limited to 255 chars - no limit but also no transactions Is it supported ? If yes, please let me know how? Any help is welcome. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL on Mac OS X?
Has anyone had any experience of running MySQL on Mac OS X? If so, how have you found it - is it stable and non-buggy? Also, has anyone had any experience of using both MySQL *and* PHP together on Mac OS X? I would be very interested to hear anyone's thoughts on this, regards Paul - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
JOINS what is the difference in?
database,sql,query,table Hi, have been told to use joins and after reading the manual a bit I do not know what it is about. I have added couple of examples. Could anyone tell me what difference is in them if any? the MY: is what I have been using and SUGGESTED is what was offered to be instead of MY: MY: select * from baseinfo,addressinfo where baseinfo.aid=addressinfo.aid; SUGGESTED: select * from baseinfo LEFT JOIN addressinfo ON baseinfo.aid=addressinfo.aid; SUGGESTED: select * from baseinfo LEFT JOIN addressinfo USING (aid); MY: Select * from baseinfo,addressinfo,postalinfo Where baseinfo.aid=addressinfo.aid and addressinfo.postalnumber=postalinfo.postalnumber; SUGGESTED: select * from baseinfo LEFT JOIN addressinfo ON baseinfo.aid=addressinfo.aid LEFT JOIN postalinfo ON addressinfo.postalnumber=postalinfo.postalnumber; What kind of practical uses do you have for JOINS? Jari Mäkelä - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Video game programming????
It has a wierd review from someone which says I was extremely dissapointed to say the least. This book doesn't even begin to cover **video game programming in mySQL**, not even the basics. In fact, it doesn't cover **video game programming at all**. . blah blah . What's video game programming got to do with MySQL ?? Hi Nilesh, yes I saw that 'review' as well and my first thought was boy, what a class 1 jerk! (or a SQL Server advocate - same thing ;-) ! ). But then I got to thinking: 1. Two of MySQL's strengths are that it's small and fast - pre-requisites for video game work. 2. Most (and I would have thought all) games have pretty extensive data structures for player position, position of bad guys, ammo etc. Given this why couldn't MySQL be used as the data backend for a video game? In fact, once the geniuses at MySQL give us peer-to-peer replication then this would be ideal for some kind of MUD-type game, (each player would effectively have a local copy of the DB, transmit their moves out and receive other peoples moves). Even without this you could do a type of DOOM, where all the layout would be stored in the DB, heck, you could even have a leave-rejoin facility for multiple players, (single player game) since the DB could be used to store the users configuration, the same way it can be used to store personalised Web page configuration. Or maybe something similar to the old SGI flight/dog 'sims', (that was an ace timewaster and I sure wish someone would port it to Linux!) Further it occurs to my fevered imagination that you could use Blender to make the graphics bit for a DOOM clone, and link it to a MySQL backend, or embed it. AFAIK Blender uses Python and I seem to remember seeing a Python interface to MySQL. Ain't MySQL wonderful, and so flexible too! Bob Cross, rapidly turning into a major MySQL advocate. Disclaimer 1: The rabid dribblings above are personal to the author only, my employer has much more common sense. * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * This message is confidential. It may also be privileged or protected by other legal rules. It does not constitute an offer or acceptance of an offer, nor shall it form any part of a legally binding contract. If you have received this communication in error, please let us know by reply then destroy it. You should not use, print, copy the message or disclose its contents to anyone. E-mail is subject to possible data corruption, is not secure, and its content does not necessarily represent the opinion of this Company. No representation or warranty is made as to the accuracy or completeness of the information and no liability can be accepted for any loss arising from its use. This e-mail and any attachments are not guaranteed to be free from so-called computer viruses and it is recommended that you check for such viruses before down-loading it to your computer equipment. This Company has no control over other websites to which there may be hypertext links and no liability can be accepted in relation to those sites. Scottish Newcastle plc Registered in Scotland, Registered Number 16288 Registered Office: 33, Ellersly Road, Edinburgh, EH12 6HX * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL on Mac OS X?
I haven't run mysql personally on my OS X box yet but I do know of some who have and there seems to be a current problem with getting mysql to quit properly. I think that will be fixed with Mac OS X 10.1 which is coming out sometime this month. Other than that go to www.versiontracker.com and click on the OS X section and do a search for SQL you will find a lot of tools to help you out. Troy On Wednesday, September 12, 2001, at 05:03 AM, Paul Groves wrote: Has anyone had any experience of running MySQL on Mac OS X? If so, how have you found it - is it stable and non-buggy? Also, has anyone had any experience of using both MySQL *and* PHP together on Mac OS X? I would be very interested to hear anyone's thoughts on this, regards Paul - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Unable to run Bench Tests...
Placed At : BOM Durga Prasad@SATYAM 09/12/2001 03:25 PM Hi all, I have just installed MySQL 3.23.42-1. using MySQL3.23.42-1.i386.rpm. OS: RH Linux 7.1 glibc:2.2.2.10 gcc: 2.96-81 perl: 5.6.0-12 When i try to install MySQL-bench-3.23.42-1.i386.rpm using the command: rpm -i MySQL-bench-3.23.42-1.i386.rpm i get the following error. error: failed dependencies: MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.42-1 This inspite of installing Bundle::DBI as well as Bundle::DBD::mysql Does any body else has any idea why this is so. Rgds, Durga Prasad - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Adding in character sets
Is there a way to add support for additional character sets to an existing mysql installation without recompiling? I am currently running mysql 3.23.32 if I do need to recompile should I get the source for 3.23.32 or should I already upgrade to 3.23.42? Thanks, David Suna [EMAIL PROTECTED] [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Video game programming????
database, sql, query, table database, sql, query, table (I hate 123box.co.uk) Im not gonna go into long discussions of game programming in here. But the reason most people dont use a database backend for most modern games is more a matter of speed than anything else. You cant get an average of over 45fps in anything but a simple game, if you are storing the data in a database. Its much faster to use a c++ class, or good old c struct to store data than use an interface to a database. Im sure there are many types of games where a database would be suitable. But most 'video games' are all about high-speed constant action which require incredibly fast data processing. Im not against MySQL at all, its great for my work requirements, im just not sure its suitable for a 'video game'. Andrew -Original Message- From: Robert Cross [mailto:[EMAIL PROTECTED]] Sent: 12 September 2001 10:31 am To: Nilesh Parmar Cc: [EMAIL PROTECTED] Subject: Re: Video game programming It has a wierd review from someone which says I was extremely dissapointed to say the least. This book doesn't even begin to cover **video game programming in mySQL**, not even the basics. In fact, it doesn't cover **video game programming at all**. . blah blah . What's video game programming got to do with MySQL ?? Hi Nilesh, yes I saw that 'review' as well and my first thought was boy, what a class 1 jerk! (or a SQL Server advocate - same thing ;-) ! ). But then I got to thinking: 1. Two of MySQL's strengths are that it's small and fast - pre-requisites for video game work. 2. Most (and I would have thought all) games have pretty extensive data structures for player position, position of bad guys, ammo etc. Given this why couldn't MySQL be used as the data backend for a video game? In fact, once the geniuses at MySQL give us peer-to-peer replication then this would be ideal for some kind of MUD-type game, (each player would effectively have a local copy of the DB, transmit their moves out and receive other peoples moves). Even without this you could do a type of DOOM, where all the layout would be stored in the DB, heck, you could even have a leave-rejoin facility for multiple players, (single player game) since the DB could be used to store the users configuration, the same way it can be used to store personalised Web page configuration. Or maybe something similar to the old SGI flight/dog 'sims', (that was an ace timewaster and I sure wish someone would port it to Linux!) Further it occurs to my fevered imagination that you could use Blender to make the graphics bit for a DOOM clone, and link it to a MySQL backend, or embed it. AFAIK Blender uses Python and I seem to remember seeing a Python interface to MySQL. Ain't MySQL wonderful, and so flexible too! Bob Cross, rapidly turning into a major MySQL advocate. Disclaimer 1: The rabid dribblings above are personal to the author only, my employer has much more common sense. * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * This message is confidential. It may also be privileged or protected by other legal rules. It does not constitute an offer or acceptance of an offer, nor shall it form any part of a legally binding contract. If you have received this communication in error, please let us know by reply then destroy it. You should not use, print, copy the message or disclose its contents to anyone. E-mail is subject to possible data corruption, is not secure, and its content does not necessarily represent the opinion of this Company. No representation or warranty is made as to the accuracy or completeness of the information and no liability can be accepted for any loss arising from its use. This e-mail and any attachments are not guaranteed to be free from so-called computer viruses and it is recommended that you check for such viruses before down-loading it to your computer equipment. This Company has no control over other websites to which there may be hypertext links and no liability can be accepted in relation to those sites. Scottish Newcastle plc Registered in Scotland, Registered Number 16288 Registered Office: 33, Ellersly Road, Edinburgh, EH12 6HX * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SUPPORT FOR UNICODE
Hi everyone, I am not a user of MYSQL yet, but shall be soon. I needed to know if MYSQL has begun to support UNICODE (UTF- 8) as rest of the RDBMS' have adopted it to meet the language needs of non-english countries. And I am just hoping that amongst so many MYSQL users probably some one would be having first hand information. pls do tell thanks, Priti - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL: Unable to save result set
Hello, Starting 2-3 days ago, when we or our users try to access some parts of our site we receive some PHP/SQL, as this: Warning: MySQL: Unable to save result set in /home/bestjobs/public_html/nb/insert_user.php on line 21 We did not change anything in the php scripta or database structure and when we've run the scripts on other server all os OK. So we believe this errors are caused by a sever problem. Can you tell me what kind of problems might be? Catalin Tenita - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL on Mac OS X?
Has anyone had any experience of running MySQL on Mac OS X? If so, how have you found it - is it stable and non-buggy? Also, has anyone had any experience of using both MySQL *and* PHP together on Mac OS X? I would be very interested to hear anyone's thoughts on this, regards Paul -- Paul Groves, HCDT Senior Project Officer Humanities Computing Development Team OUCS, 13 Banbury Rd, Oxford, OX6 2NN. Tel: +44 (0)1865 273 290 Web: www.oucs.ox.ac.uk/hcdt/staff.html#paul HCDT is part of the Learning Technologies Group www.oucs.ox.ac.uk/ltg/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mySQL on unix vs ODBC
At 9:10 AM +0100 9/12/01, Peter Gad wrote: Hi everyone ! We've got a problem: running mySQL on unix(sun) we connect a third party windows software over ODBC. All is nice until a windows path is stored in the db Trying to store C:\Program Files\3p SW\ I find that it becomes C:Program Files3p SW. Is it possible, by means of configuration, to have backslashes preserved ? Either in ODBC or ... somewhere ? Backslash is escape character; to store a string containing one, you have to double it. For example, use the string C:\\Program Files\\3p SW\\ is your INSERT query, and it will show up in your SELECT result as C:\Program Files\3p SW\ Facts: 3d party software = no code no chance of changes ODBC - installed from myodbc-2.50.37-nt.zip mySQL - 3.23.39 ( 3.23.41 could be used) thanx in advance peter -- + Open source questions? + | Steve Edberg University of California, Davis | | [EMAIL PROTECTED] Computer Consultant | | http://aesric.ucdavis.edu/ http://pgfsun.ucdavis.edu/ | +--- http://pgfsun.ucdavis.edu/open-source-tools.html ---+ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem...
Placed At : BOM Durga Prasad@SATYAM 09/12/2001 05:10 PM Hi all, I have just installed MySQL 3.23.42-1. using MySQL3.23.42-1.i386.rpm. OS: RH Linux 7.1 glibc:2.2.2.10 gcc: 2.96-81 perl: 5.6.0-12 When i try to install MySQL-bench-3.23.42-1.i386.rpm using the command: rpm -i MySQL-bench-3.23.42-1.i386.rpm i get the following error. error: failed dependencies: MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.42-1 This inspite of installing Bundle::DBI as well as Bundle::DBD::mysql Does any body else has any idea why this is so. Rgds, Durga Prasad - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
starting problems. . .
Hi there, I am currently using Slackware 8 (linux) and I have some problems. There is mysql package in the slackware installation, which I installed it but never manage to run it successfully. Everytime I type the following safe_mysqld and I get the following message: Starting mysqld daemon with databases from /var/lib/mysql 010912 15:13:45 mysqld ended which means that for a strange reason the server doesn't starts. Do you have any idea what might be the problem ? I also dowload your docs from the site but couldn't manage to solve it out. Any help would be appreciated. Regards, Nikolaos Rasidakis ~~~ email: [EMAIL PROTECTED] home: http://kickme.to/kafros ~~~ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to use JOINS
Merges wont work because they dont allow inserts. But I'll check out UNION. Thanx - Deryck H - http://www.comp-u-exchange.com - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Deryck Henson [EMAIL PROTECTED] Cc: MySQL [EMAIL PROTECTED] Sent: Wednesday, September 12, 2001 2:56 AM Subject: Re: How to use JOINS On Wed, Sep 12, 2001 at 02:13:59AM -0500, Deryck Henson wrote: OK, well, mysql has LEFT JOINS, right? OK then, in that case, how the heck do I use them?! I need to join 14 tables (with the exact same structure, columns) together and view all of there contents with a WHERE clause like this: SELECT * FROM t1, t2, t3, t4, t5, etc ORDER BY date DESC or SELECT * FROM theworks WHERE userid = 'userid' Any suggestions? I need that join. WHY? Because it's ambiguous if I dont have it. I'm not entirely sure, but it sounds like you might be confusing a JOIN with a UNION. JOINs are used to bring together related records (related in the RDBMS sense of related) into larger records composed of columns from each table. A UNION allows you to treat several similarly structured tables as if the are one large table. MySQL doesn't yet have UNIONs (4.0 will), but it does have MERGE tables which allow you to combine several tables into a sort of virtual table against which you can write queries. Hope this helps, Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 6 days, processed 131,748,231 queries (248/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: starting problems. . .
I am currently using Slackware 8 (linux) and I have some problems. There is mysql package in the slackware installation, which I installed it but never manage to run it successfully. Everytime I type the following safe_mysqld and I get the following message: Starting mysqld daemon with databases from /var/lib/mysql 010912 15:13:45 mysqld ended which means that for a strange reason the server doesn't starts. Do you have any idea what might be the problem ? I also dowload your docs from the site but couldn't manage to solve it out. Look at the .err file in /var/lib/mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: starting problems. . .
I presume that you did run the mysql_install_db first of all?? If so, then check the ownership of the directory where the database lives. This should be mysql:mysql. HAd the same problems till I resolved the ownership issue. Regards, Ian. -Original Message- From: Nikolaos Rasidakis [mailto:[EMAIL PROTECTED]] Sent: 12 September 2001 13:29 To: [EMAIL PROTECTED] Subject: starting problems. . . Hi there, I am currently using Slackware 8 (linux) and I have some problems. There is mysql package in the slackware installation, which I installed it but never manage to run it successfully. Everytime I type the following safe_mysqld and I get the following message: Starting mysqld daemon with databases from /var/lib/mysql 010912 15:13:45 mysqld ended which means that for a strange reason the server doesn't starts. Do you have any idea what might be the problem ? I also dowload your docs from the site but couldn't manage to solve it out. Any help would be appreciated. Regards, Nikolaos Rasidakis ~~~ email: [EMAIL PROTECTED] home: http://kickme.to/kafros ~~~ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Video game programming????
At 1:31 AM +0530 9/12/01, Nilesh Parmar wrote: Hi I was just browsing thru the amazon.com site and just happened to read a customer review on the MySQL (other new riders) book by Paul DuBios and Michael Widenius. It has a wierd review from someone which says I was extremely dissapointed to say the least. This book doesn't even begin to cover **video game programming in mySQL**, not even the basics. In fact, it doesn't cover **video game programming at all**. . blah blah . The line that caught my attention was the one which are inside the ** symbols. Now, this was something new to me.So, i just thought if anyone could tell me more on this. What's video game programming got to do with MySQL ?? and what does he mean by this. Can anyone enlighten me on this ?? Thanx in advance. Nilesh Just a follow-up on the various theories that have been posted about this review. (It refers to MySQL and not MySQL and Perl for the Web, by the way.) Here's the review in its entirety: [1 star] Don't waste your time..., April 17, 2001 Reviewer: Joey Ramone (see more about me) from Loves Park, IL I was extremely dissapointed to say the least. This book doesn't even begin to cover video game programming in mySQL, not even the basics. In fact, it doesn't cover video game programming at all. The section on compiling for DOS must have been lost on the way to the printing press... While the plot had substance to it, the ending was predictable and unoriginal... The review is a satire. Note who it's by: Joey Ramone (of The Ramones). It was posted the day after Joey Ramone died, perhaps as some sort of weird tribute, and it's deliberately got nothing to do with what the book's really about. -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
time of selecet statements
I have to measure the time of an select-query. How can i use the benchmark command for doing it? A simple benchmark(10,select field from tbl where key_field=condition) gives me an error. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Faster mysql
Hello, How I can make my mysql faster ? Can I compile it with special options ? Pozdrawiam, Marcin Pyla (o_ [ Marcin Pyla - Cubbi [EMAIL PROTECTED] | + NetArt ISP + ] (/)_ [ God, root, what's the difference? -- God is more forgiving ] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Faster mysql
Look and making MySQL fly The hard stuff is where to start. Raid 0 and lost of memory Then yes there are a few things that you can remove when compiling to make things faster depending what you need to do. And then theirs stuff to do in my.cnf Simon -Original Message- From: Marcin Pyla [mailto:[EMAIL PROTECTED]] Sent: 12 September 2001 14:19 To: [EMAIL PROTECTED] Subject: Faster mysql Hello, How I can make my mysql faster ? Can I compile it with special options ? Pozdrawiam, Marcin Pyla (o_ [ Marcin Pyla - Cubbi [EMAIL PROTECTED] | + NetArt ISP + ] (/)_ [ God, root, what's the difference? -- God is more forgiving ] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Faster mysql
On Wed, 12 Sep 2001, Simon Green wrote: Look and making MySQL fly The hard stuff is where to start. Raid 0 and lost of memory I used Raid 5 + 1 (hardware) and it gaves only 2 seconds faster... Then yes there are a few things that you can remove when compiling to make things faster depending what you need to do. And then theirs stuff to do in my.cnf Can you give me an exempels ? Simon -Original Message- From: Marcin Pyla [mailto:[EMAIL PROTECTED]] Sent: 12 September 2001 14:19 To: [EMAIL PROTECTED] Subject: Faster mysql Hello, How I can make my mysql faster ? Can I compile it with special options ? Pozdrawiam, Marcin Pyla (o_ [ Marcin Pyla - Cubbi [EMAIL PROTECTED] | + NetArt ISP + ] (/)_ [ God, root, what's the difference? -- God is more forgiving ] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Pozdrawiam, Marcin Pyla (o_ [ Marcin Pyla - Cubbi [EMAIL PROTECTED] | + NetArt ISP + ] (/)_ [ The system is going down to maintenance mode NOW !! ] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Understanding problem or bug?
I have 4 tables where the primary key is identical with the primary key of the other tables. Here's my strange result of two queries: select count(*) from tbl_a natural left join tbl_b natural left join tbl_c natural left join tbl_d where where tbl_c.field1=x and tbl_d.field2=y; Result: 7 matching rows select count(*) from tbl_a left join tbl_b using(ID) left join tbl_c using(ID) left join tbl_d using(ID) where where tbl_c.field1=x and tbl_d.field2=y; Result: 1016 matching rows Shouldn't be both queries match the same number of rows? (I'm using mysql 3.23.37 on a linux system) Thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: error 1064
Gene Gurevich wrote: Hi all: I'm trying to import the tables from the dump file via mysqldump testdb exp That should be: mysql testdb exp and it complaints about the command in the export file: DROP TABLE IF EXISTS db; CREATE TABLE db ( Host char(60) NOT NULL default '', Db char(64) NOT NULL default '', User char(16) NOT NULL default '', Select_priv enum('N','Y') NOT NULL default 'N', Insert_priv enum('N','Y') NOT NULL default 'N', Update_priv enum('N','Y') NOT NULL default 'N', Delete_priv enum('N','Y') NOT NULL default 'N', Create_priv enum('N','Y') NOT NULL default 'N', Drop_priv enum('N','Y') NOT NULL default 'N', Grant_priv enum('N','Y') NOT NULL default 'N', References_priv enum('N','Y') NOT NULL default 'N', Index_priv enum('N','Y') NOT NULL default 'N', Alter_priv enum('N','Y') NOT NULL default 'N', UNIQUE KEY Primary (Host,Db,User), KEY User (User) ) TYPE=MyISAM MAX_ROWS=1000 PACK_KEYS=1 Specifically the last three lines. The file I'm using was created via mysqldump --add-drop-table --all-databases. I can't understand why a file created by a mysqldump can have any issues. Can anyone explain that for me? Is there a error search engine on mysql.com (something like oracle has on oracle.com)? thanks in advance = __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: error 1064
That's what I used : mysql testdb exp. Sorry about the typo Gene --- Gerald Clark [EMAIL PROTECTED] wrote: Gene Gurevich wrote: Hi all: I'm trying to import the tables from the dump file via mysqldump testdb exp That should be: mysql testdb exp and it complaints about the command in the export file: DROP TABLE IF EXISTS db; CREATE TABLE db ( Host char(60) NOT NULL default '', Db char(64) NOT NULL default '', User char(16) NOT NULL default '', Select_priv enum('N','Y') NOT NULL default 'N', Insert_priv enum('N','Y') NOT NULL default 'N', Update_priv enum('N','Y') NOT NULL default 'N', Delete_priv enum('N','Y') NOT NULL default 'N', Create_priv enum('N','Y') NOT NULL default 'N', Drop_priv enum('N','Y') NOT NULL default 'N', Grant_priv enum('N','Y') NOT NULL default 'N', References_priv enum('N','Y') NOT NULL default 'N', Index_priv enum('N','Y') NOT NULL default 'N', Alter_priv enum('N','Y') NOT NULL default 'N', UNIQUE KEY Primary (Host,Db,User), KEY User (User) ) TYPE=MyISAM MAX_ROWS=1000 PACK_KEYS=1 Specifically the last three lines. The file I'm using was created via mysqldump --add-drop-table --all-databases. I can't understand why a file created by a mysqldump can have any issues. Can anyone explain that for me? Is there a error search engine on mysql.com (something like oracle has on oracle.com)? thanks in advance = __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: starting problems. . .
I had similar problems with sue7.2 i finally got fed up and downloaded the most current binary distribution and followed directions. I am still trying to work out some issues but at least i have a working system XAPHS Chris Bolt wrote: I am currently using Slackware 8 (linux) and I have some problems. There is mysql package in the slackware installation, which I installed it but never manage to run it successfully. Everytime I type the following safe_mysqld and I get the following message: Starting mysqld daemon with databases from /var/lib/mysql 010912 15:13:45 mysqld ended which means that for a strange reason the server doesn't starts. Do you have any idea what might be the problem ? I also dowload your docs from the site but couldn't manage to solve it out. Look at the .err file in /var/lib/mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Faster mysql
Steps In Compiling MySQL Use the right compiler Use pgcc = Pentium optimzed gcc on Pentium Strip unnecessary parts Only use character sets you will use Skip BDB tables, replication if you don't need them compile MySQL without support for exceptions (as MySQL does not use C++ exceptions) Simon PS there is more you can do please read the manual... -Original Message- From: Marcin Pyla [mailto:[EMAIL PROTECTED]] Sent: 12 September 2001 14:45 To: Simon Green Cc: [EMAIL PROTECTED] Subject: RE: Faster mysql On Wed, 12 Sep 2001, Simon Green wrote: Look and making MySQL fly The hard stuff is where to start. Raid 0 and lost of memory I used Raid 5 + 1 (hardware) and it gaves only 2 seconds faster... Then yes there are a few things that you can remove when compiling to make things faster depending what you need to do. And then theirs stuff to do in my.cnf Can you give me an exempels ? Simon -Original Message- From: Marcin Pyla [mailto:[EMAIL PROTECTED]] Sent: 12 September 2001 14:19 To: [EMAIL PROTECTED] Subject: Faster mysql Hello, How I can make my mysql faster ? Can I compile it with special options ? Pozdrawiam, Marcin Pyla (o_ [ Marcin Pyla - Cubbi [EMAIL PROTECTED] | + NetArt ISP + ] (/)_ [ God, root, what's the difference? -- God is more forgiving ] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Pozdrawiam, Marcin Pyla (o_ [ Marcin Pyla - Cubbi [EMAIL PROTECTED] | + NetArt ISP + ] (/)_ [ The system is going down to maintenance mode NOW !! ] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Faster mysql
Marcin wrote: How I can make my mysql faster ? Can I compile it with special options? Check out section 5.5 of the manual. I found there's also some very useful information readily available in the file INSTALL-SOURCE* in the top level of the source directory. I'm not sure whether GCC v3.0 might make a difference, as I've heard mixed reviews of it so far. Maybe someone else on this list has got some hard data on this. Bob Cross. * I turned on the O3 flag for my v.41 build and I'm not sure how much better performance I got, (there was an observable speedup), but the memory requirement dropped to just about 60% of what it previously was. * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * This message is confidential. It may also be privileged or protected by other legal rules. It does not constitute an offer or acceptance of an offer, nor shall it form any part of a legally binding contract. If you have received this communication in error, please let us know by reply then destroy it. You should not use, print, copy the message or disclose its contents to anyone. E-mail is subject to possible data corruption, is not secure, and its content does not necessarily represent the opinion of this Company. No representation or warranty is made as to the accuracy or completeness of the information and no liability can be accepted for any loss arising from its use. This e-mail and any attachments are not guaranteed to be free from so-called computer viruses and it is recommended that you check for such viruses before down-loading it to your computer equipment. This Company has no control over other websites to which there may be hypertext links and no liability can be accepted in relation to those sites. Scottish Newcastle plc Registered in Scotland, Registered Number 16288 Registered Office: 33, Ellersly Road, Edinburgh, EH12 6HX * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql to oracle conversion
Hi. Is there a tool to convert a mysql database to oracle? thanks = __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re:error in sec index entry update
Brian, the error message means that you updated a secondary key of a row but InnoDB did not find the index entry in the secondary index. The bug may be due to an error in purge, insert buffer, or the buffer pool. I am currently running tests on this and studying it. Could you please run CHECK TABLE on the table webassign.rosterInnoDB and send the output to me? Also the CREATE TABLE statement would help in hunting the bug. You can repair your table by dropping it and reimporting it, but the output of CHECK TABLE should be seen first. Regards, Heikki Hello, I'm using mysql 3.23.40 with InnoDB tables. Recently I've been seeing several of the following messages in my logs related to indexes. InnoDB: error in sec index entry update in InnoDB: index user_ table webassign/rosterInnoDB: tuple 0: len 50; hex \ 646a61646f40727574676572732020202020202020202020202020202020202020202020202 02020202020 \ 20202020202020; asc [username] ;; 1: len 3; hex \ 000cfa; asc ;; InnoDB: record RECORD: info bits 0 0: len 50; hex \ 646a61636f62736540756d642e756d696368202020202020202020202020202020202020202 02020202020 \ 20202020202020; asc [username] ;; 1: len 3; hex 44; asc D;; I'm not sure what other information to give to describe the problem. I do not know exactly what caused the errors to appear nor how to duplicate the errors. I see no ill effects of the error. I have omitted the usernames reported in the error above but those users are still retrievable. Please let me know if more information is needed or if anyone else has experienced this problem.Thanks very much in advance,Brian Pittman System: SunOS 5.6 Generic_105181-17 sun4u sparc SUNW,Ultra-4Architecture: sun4 Some paths: /bin/perl /usr/local/bin/make /usr/local/bin/gcc /usr/ucb/cc GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.6/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS=''LIBC: -rw-r--r-- 1 bin bin 1607728 Dec 28 1999 /lib/libc.a lrwxrwxrwx 1 root root 11 Apr 14 1998 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 bin bin 1014088 Dec 28 1999 /lib/libc.so.1 -rw-r--r-- 1 bin bin 1607728 Dec 28 1999 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Apr 14 1998 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 bin bin 1014088 Dec 28 1999 /usr/lib/libc.so.1 Configure command: ./configure --with-unix-socket-path=/var/tmp/mysql.sock \ --with-low-memory --with-mit-threads=yes --without-perl --enable-thread-safe-client \ --with-berkeley-db --with-innodb - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re:ERROR 1073: create InnoDB tables!
Hi! You can probably circumvent the problem by adding an extra VARCHAR column where you put the first 255 characters of the blob column. Or maybe you could generate an artificial primary key with auto-increment, for example? Regards, Heikki http://www.innodb.com Hi, I tried create table specify type=InnoDB.with the following script: create table objects(uri blob not null, primary key uriIndex (uri(255)), classname blob) type=InnoDB;I'm getting the following error ERROR 1073: BLOB column 'uri' can't be used in key specification with the used \ table typeThis is what I found in the mySQL docs: * Only the MyISAM table type supports indexing on BLOB and TEXT columns. When putting \ an index on a BLOB or TEXT column you MUST always specify the length of the index: CREATE TABLE test (blob_col BLOB, index(blob_col(10))); I could change the uri to varchar but... * Values in VARCHAR columns are variable-length strings. I can declare a VARCHAR \ column to be any length between 1 and 255, just as for CHAR columns. That's not very good, we can choose- transactions but uri limited to 255 chars - no limit but also no transactions Is it supported ? If yes, please let me know how?Any help is welcome. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Crash Recovery
I have a table with over 26 million records that experiences a high volume of traffic. Recently, query results became a little screwy; upon investigation it was found that the table and the index were fouled up. The results of an isamchk on the table yielded: Checking ISAM file: /usr8/hydrology/measurement Data records: 27034726 Deleted blocks: 0 - check file-size ./bin/isamchk: warning: Size of datafile is: 11 Should be: 3554138 - check delete-chain - check index reference - check data record references index: 1 ./bin/isamchk: error: Found key at page 1024 that points to record outside datafile ISAM-table '/usr8/hydrology/measurement' is corrupted Fix it using switch -r or -o and on the index yielded: Data records: 27034726 Deleted blocks: 0 - check file-size ./bin/isamchk: warning: Size of datafile is: 11 Should be: 3554138 - check delete-chain - check index reference - check data record references index: 1 ./bin/isamchk: error: Found key at page 1024 that points to record outside datafile ISAM-table '/usr8/hydrology/measurement.ISM' is corrupted Fix it using switch -r or -o Trying to fix the table as suggested results in the datafile being reduced to a file size of 0 bytyes. Before the fix it is over 4Gigs. I have tried several different options for isamchk including the --quick,which does not kill the data file but still does not work. So the question is: since the isamchk can detect the 27 million records, what is my best hope for getting them all out. select * results in garbage any thoughts would be appreciated. I can get about 90% of the records out with carefully crafted where clauses, but I am a little concerned with the integrity of them. What is the probability that the integrity of these records can be trusted. They look ok and a few random checks that I have done show no problems. thanks to all. Kevin Kotun, P.E. Hydrologist Everglades National Park - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem with 3.23.42
Hi Devin, You need to look into serveral things. Did you run mysql_install_db? If there is an error file in /usr/local/var (it will be servername.domain.err ) read what it says in that file. See http://www.mysql.com/doc/P/o/Post-installation.html Sorry for the delay in responding we here in New Jersey and US are devastated by what has happened here. I hope this helps Ken - Original Message - From: Devin Atencio [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 11, 2001 8:07 PM Subject: Problem with 3.23.42 I just installed MySQL 3.23.42 onto my FreeBSD 4.4-RC3 Box and It installed just fine but now when I run the database it bombs And does the following: su-2.04# /usr/local/bin/safe_mysqld [1] 68926 su-2.04# Starting mysqld daemon with databases from /usr/local/var 010911 18:01:07 mysqld ended [1]+ Done/usr/local/bin/safe_mysqld Any idea why it just dies? \\\// -(@ @)- --oOO--(_)--OOo- - Devin Atencio ArosNet Systems Admin Dept [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: error in sec index entry update
Heikki, Here is the output from CHECK TABLE: mysql check table roster; +--+---+--+--+ | Table| Op| Msg_type | Msg_text | +--+---+--+--+ | webassign.roster | check | status | OK | +--+---+--+--+ 1 row in set (20.82 sec) Here was my original CREATE TABLE statement: create table roster ( class_id mediumint unsigned not null, username char(50) not null, user_id char(20) not null, fullname char(50) not null, user_end_datetime datetime default '-00-00 00:00:00' not null, creation_date datetime default '-00-00 00:00:00' not null, primary key (class_id, username), key roster_ (class_id, username) ) type = innodb; (Completely unrelated question but I've oft wondered if both the primary key and the key statements in create table are necesary. I've gotten into the habit of always using both but am I just adding overhead?) Here is the statement used to create the secondary index: create index user_ on roster (username); Also, here are the current indexes: mysql show index from roster; +++--+--+-+---+-+--++-+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Comment | +++--+--+-+---+-+--++-+ | roster | 0 | PRIMARY |1 | class_id| A |NULL | NULL | NULL | | | roster | 0 | PRIMARY |2 | username| A | 98270 | NULL | NULL | | | roster | 1 | roster_ |1 | class_id| A |NULL | NULL | NULL | | | roster | 1 | roster_ |2 | username| A | 98270 | NULL | NULL | | | roster | 1 | user_|1 | username| A | 98270 | NULL | NULL | | +++--+--+-+---+-+--++-+ 5 rows in set (0.03 sec) Let me know if there is any other information I can get for you. Thanks very much, Brian Heikki Tuuri wrote: Brian, the error message means that you updated a secondary key of a row but InnoDB did not find the index entry in the secondary index. The bug may be due to an error in purge, insert buffer, or the buffer pool. I am currently running tests on this and studying it. Could you please run CHECK TABLE on the table webassign.rosterInnoDB and send the output to me? Also the CREATE TABLE statement would help in hunting the bug. You can repair your table by dropping it and reimporting it, but the output of CHECK TABLE should be seen first. Regards, Heikki Hello, I'm using mysql 3.23.40 with InnoDB tables. Recently I've been seeing several of the following messages in my logs related to indexes. InnoDB: error in sec index entry update in InnoDB: index user_ table webassign/rosterInnoDB: tuple 0: len 50; hex \ 646a61646f40727574676572732020202020202020202020202020202020202020202020202 02020202020 \ 20202020202020; asc [username] ;; 1: len 3; hex \ 000cfa; asc ;; InnoDB: record RECORD: info bits 0 0: len 50; hex \ 646a61636f62736540756d642e756d696368202020202020202020202020202020202020202 02020202020 \ 20202020202020; asc [username] ;; 1: len 3; hex 44; asc D;; I'm not sure what other information to give to describe the problem. I do not know exactly what caused the errors to appear nor how to duplicate the errors. I see no ill effects of the error. I have omitted the usernames reported in the error above but those users are still retrievable. Please let me know if more information is needed or if anyone else has experienced this problem.Thanks very much in advance,Brian Pittman System: SunOS 5.6 Generic_105181-17 sun4u sparc SUNW,Ultra-4Architecture: sun4 Some paths: /bin/perl /usr/local/bin/make /usr/local/bin/gcc /usr/ucb/cc GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.6/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS=''LIBC: -rw-r--r-- 1 bin bin 1607728 Dec 28 1999 /lib/libc.a lrwxrwxrwx 1 root root 11 Apr 14 1998 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 bin bin 1014088 Dec 28 1999 /lib/libc.so.1 -rw-r--r-- 1 bin bin 1607728 Dec 28 1999 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Apr 14 1998 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 bin bin 1014088 Dec 28 1999 /usr/lib/libc.so.1 Configure command: ./configure
Can't get MySQL to use available memory (performance very slow)
Hi there, I'm having trouble configuring MySQL 3.23.36 running on a Sparc/SunOS 5.8 to use the available 1 gig of memory and was wondering if anyone might be able to help find a solution. /usr/ucb/ps -aux gives the stats: USER PID %CPU %MEM SZ RSS TT SSTART TIME COMMAND root 2120 36.6 7.044881669800 ?O Sep 11 16:46 /u01/opt/MySQL/lib when a single user is running a simple query like: SELECT count(id) FROM ind WHERE cust=1 AND email''; This query takes 8.29 seconds to run and there are less than 200,000 records in the ind table. Different queries don't change the percentage of memory being used, only the CPU usage seems to change. I tried adding an index to the ind table for the cust and email fields, but the query took even longer since about 175,000 records have nonempty email fields. mysqld is using the huge.cnf configuration file for 1G-2G systems (settings from file are listed at end of this message) I've also played around with tweaking command line settings via the safe_mysqld commands suggested via http://www.mysql.com/doc/S/e/Server_parameters.html such as shell safe_mysqld -O key_buffer=64M -O table_cache=256 \ -O sort_buffer=4M -O record_buffer=1M with little or no improvement. Can someone explain why MySQL isn't using more memory or point me in the right direction to improve MySQL's performance? Many thanks in advance, Joe Kaiping == cnf file settings: == [mysqld] port= 3306 socket = /tmp/mysql.sock skip-locking set-variable= key_buffer=384M set-variable= max_allowed_packet=1M set-variable= table_cache=512 set-variable= sort_buffer=2M set-variable= record_buffer=2M set-variable= thread_cache=8 set-variable= thread_concurrency=4 # Try number of CPU's*2 set-variable= myisam_sort_buffer_size=64M log-bin server-id = 1 [isamchk] set-variable= key_buffer=256M set-variable= sort_buffer=256M set-variable= read_buffer=2M set-variable= write_buffer=2M [myisamchk] set-variable= key_buffer=256M set-variable= sort_buffer=256M set-variable= read_buffer=2M set-variable= write_buffer=2M [mysqlhotcopy] interactive-timeout - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: FW: URGENTE - Replication...... - mySql
Sasha, I tried the bug script to send the bug, but didn't have time to go thru the problems (looking for X, then couldn't open on vi). Reading that script I thought I saw support@..so I went ahead and send to that list. I knew it was a paid support list, but I didn't have any question, only let you know that it is a bug and I thought it justified the email to that list. - Regards, Rod~ -Original Message- From: Sasha Pachev [mailto:[EMAIL PROTECTED]] Sent: Monday, September 10, 2001 6:56 PM To: Rodrigo Zerlotti; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: FW: URGENTE - Replication.. - mySql On Monday 10 September 2001 09:43, Rodrigo Zerlotti wrote: here it is... - Regards, Rodgrigo: Thanks for a bug report. We will try to get this fixed in 3.23.43. Next time, please write to [EMAIL PROTECTED] when you find a bug and have a test case for it. This address ([EMAIL PROTECTED]) is reserved for paying customers. Joshua and other users: Please do not advise others to use [EMAIL PROTECTED] to users without a support contract as a way to get personal help from MySQL AB when other methods do not work. We usually reply to such messages with a template, and in some near future will have a filter that will check for valid support contract info and reply with a template if it is not present. We have also had a problem with users asking a support question on [EMAIL PROTECTED] after they got no answer on [EMAIL PROTECTED] This is also against the rules. [EMAIL PROTECTED] is reserved for discussion of internal ( not client application) MySQL development, and should not be used as a way to get free support from developers from MySQL AB and experienced users that subscribe to the list. If you have sent a question to the general list [EMAIL PROTECTED]) and nobody answers it, you should do one or more of the following: * consider purchasing a support contract at https://order.mysql.com/ * re-state the question providing more relevant information, or in other words, make it easier to answer it * spend some time studying the manual, the source code, and doing some troubleshooting to try to understand how things work * if you think you have found a bug, follow instructions at http://www.mysql.com/doc/B/u/Bug_reports.html to create a repeatable bug report. Once you have a test case, you can write it to [EMAIL PROTECTED] - if you have a test case, we will work with you on the bug until it is fixed regardless of whether you have a support contract or not. The only difference is that without a support contract, we ask you to do the homework and give us a full test case. In short, we provide free code, but we cannot afford to give free support to go along. -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can't get MySQL to use available memory (performance very slow)
In the last episode (Sep 12), Joe Kaiping said: Hi there, I'm having trouble configuring MySQL 3.23.36 running on a Sparc/SunOS 5.8 to use the available 1 gig of memory and was wondering if anyone might be able to help find a solution. /usr/ucb/ps -aux gives the stats: USER PID %CPU %MEM SZ RSS TT SSTART TIME COMMAND root 2120 36.6 7.044881669800 ?O Sep 11 16:46 /u01/opt/MySQL/lib when a single user is running a simple query like: SELECT count(id) FROM ind WHERE cust=1 AND email''; This query takes 8.29 seconds to run and there are less than 200,000 records in the ind table. Different queries don't change the percentage of memory being used, only the CPU usage seems to change. Mysql does not cache table data for the MyISAM type, so you won't see any memory change there. What does an EXPLAIN SELECT.. print for the above query? I tried adding an index to the ind table for the cust and email fields, but the query took even longer since about 175,000 records have nonempty email fields. A single 2-column index, or two separate indexes? Mysql can only use one index per query, so a compound index would help the most here. If your problem truly is disk I/O, you can try using the InnoDB table type, which caches both index and table data in memory. -- Dan Nelson [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: error in sec index entry update
Brian, your table seems to get corrupt only temporarily. It suggests I have a bug in the interplay of UPDATE and purge. Probably no need to reimport the table. About keys: there is no need to define the same key as the primary key and a non-primary. Thus the key roster_ is unnecessary. Thanks for the info. I will now study and test with a table of your kind, and look what goes wrong. Regards, Heikki At 12:05 PM 9/12/01 -0400, you wrote: Heikki, Here is the output from CHECK TABLE: mysql check table roster; +--+---+--+--+ | Table| Op| Msg_type | Msg_text | +--+---+--+--+ | webassign.roster | check | status | OK | +--+---+--+--+ 1 row in set (20.82 sec) Here was my original CREATE TABLE statement: create table roster ( class_id mediumint unsigned not null, username char(50) not null, user_id char(20) not null, fullname char(50) not null, user_end_datetime datetime default '-00-00 00:00:00' not null, creation_date datetime default '-00-00 00:00:00' not null, primary key (class_id, username), key roster_ (class_id, username) ) type = innodb; (Completely unrelated question but I've oft wondered if both the primary key and the key statements in create table are necesary. I've gotten into the habit of always using both but am I just adding overhead?) Here is the statement used to create the secondary index: create index user_ on roster (username); Also, here are the current indexes: mysql show index from roster; +++--+--+-+---+ -+--++-+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Comment | +++--+--+-+---+ -+--++-+ | roster | 0 | PRIMARY |1 | class_id| A |NULL | NULL | NULL | | | roster | 0 | PRIMARY |2 | username| A | 98270 | NULL | NULL | | | roster | 1 | roster_ |1 | class_id| A |NULL | NULL | NULL | | | roster | 1 | roster_ |2 | username| A | 98270 | NULL | NULL | | | roster | 1 | user_|1 | username| A | 98270 | NULL | NULL | | +++--+--+-+---+ -+--++-+ 5 rows in set (0.03 sec) Let me know if there is any other information I can get for you. Thanks very much, Brian Heikki Tuuri wrote: Brian, the error message means that you updated a secondary key of a row but InnoDB did not find the index entry in the secondary index. The bug may be due to an error in purge, insert buffer, or the buffer pool. I am currently running tests on this and studying it. Could you please run CHECK TABLE on the table webassign.rosterInnoDB and send the output to me? Also the CREATE TABLE statement would help in hunting the bug. You can repair your table by dropping it and reimporting it, but the output of CHECK TABLE should be seen first. Regards, Heikki Hello, I'm using mysql 3.23.40 with InnoDB tables. Recently I've been seeing several of the following messages in my logs related to indexes. InnoDB: error in sec index entry update in InnoDB: index user_ table webassign/rosterInnoDB: tuple 0: len 50; hex \ 646a61646f40727574676572732020202020202020202020202020202020202020202020202 02020202020 \ 20202020202020; asc [username] ;; 1: len 3; hex \ 000cfa; asc ;; InnoDB: record RECORD: info bits 0 0: len 50; hex \ 646a61636f62736540756d642e756d696368202020202020202020202020202020202020202 02020202020 \ 20202020202020; asc [username] ;; 1: len 3; hex 44; asc D;; I'm not sure what other information to give to describe the problem. I do not know exactly what caused the errors to appear nor how to duplicate the errors. I see no ill effects of the error. I have omitted the usernames reported in the error above but those users are still retrievable. Please let me know if more information is needed or if anyone else has experienced this problem.Thanks very much in advance,Brian Pittman System: SunOS 5.6 Generic_105181-17 sun4u sparc SUNW,Ultra-4Architecture: sun4 Some paths: /bin/perl /usr/local/bin/make /usr/local/bin/gcc /usr/ucb/cc GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.6/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS=''LIBC: -rw-r--r-- 1 bin bin 1607728 Dec 28 1999
RE: Can't get MySQL to use available memory (performance very slow)
Thanks for the quick reply, Dan. The EXPLAIN SELECT for that SELECT outputs: mysql EXPLAIN SELECT count(id) FROM ind WHERE cust=1 AND email''; +---+--+---+--+-+--++--- -+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +---+--+---+--+-+--++--- -+ | ind | ALL | NULL | NULL |NULL | NULL | 181831 | where used | +---+--+---+--+-+--++--- -+ I first tried using a 2 field index with slower results and then tried using separate single field indexes, but that was also slower than not using any index. The InnoDB table type sounds promising, so I'll start looking into that. If anyone else has other suggestions, they really are most appreciated!! Thanks again, Joe -Original Message- From: Dan Nelson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 12, 2001 9:17 AM To: Joe Kaiping Cc: [EMAIL PROTECTED] Subject: Re: Can't get MySQL to use available memory (performance very slow) In the last episode (Sep 12), Joe Kaiping said: Hi there, I'm having trouble configuring MySQL 3.23.36 running on a Sparc/SunOS 5.8 to use the available 1 gig of memory and was wondering if anyone might be able to help find a solution. /usr/ucb/ps -aux gives the stats: USER PID %CPU %MEM SZ RSS TT SSTART TIME COMMAND root 2120 36.6 7.044881669800 ?O Sep 11 16:46 /u01/opt/MySQL/lib when a single user is running a simple query like: SELECT count(id) FROM ind WHERE cust=1 AND email''; This query takes 8.29 seconds to run and there are less than 200,000 records in the ind table. Different queries don't change the percentage of memory being used, only the CPU usage seems to change. Mysql does not cache table data for the MyISAM type, so you won't see any memory change there. What does an EXPLAIN SELECT.. print for the above query? I tried adding an index to the ind table for the cust and email fields, but the query took even longer since about 175,000 records have nonempty email fields. A single 2-column index, or two separate indexes? Mysql can only use one index per query, so a compound index would help the most here. If your problem truly is disk I/O, you can try using the InnoDB table type, which caches both index and table data in memory. -- Dan Nelson [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Copying from one table to another.
Hello, I'm new to MySQL, so forgive my ignorance. I'd like to copy data from one table to another. I have one table I've made from a filemaker database. And one that contains my main data. I want to update the main data from the Main file using the data from the filemaker file. Each row has a unique zip code, and the zip code is in each of the files, so I thought I'd use that as an index field, but with no luck. What I've tried so far is this, and it doesn't see to work. Update tbl1 set CategoryInTable1 = CategoryInTable 2 where ZipInTable1 = ZipInTable2; I've also tried: Update tbl1, tbl2 set CategoryInTable1 = CategoryInTable 2 where ZipInTable1 = ZipInTable2;and Update tbl1, tbl2 set tbl1.CategoryInTable1 = tbl2.CategoryInTable 2 where tbl1.ZipInTable1 = tbl2.ZipInTable2; I thought to do an Insert-Select, but I can't since I want to update the table I'm selecting from. Any help would really be appreciated. Thanks. -eric spletzer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Undefined symbol strtoll
Sorry...here is the rest of the info: uname -a= FreeBSD reviews.aspd.net 4.2-RELEASE FreeBSD 4.2-RELEASE #0: Tue Dec 26 18:38:27 GMT 2000 [EMAIL PROTECTED]:/usr/src/sys/compile/FLASH42 mailto:webmaster@:/usr/src/sys/compile/FLASH42 i386 ldd did not work, the system told me to use objdump -i instead and here is what i got: reviews# objdump -i mysqld BFD header file version 2.10.0 elf32-i386 (header little endian, data little endian) i386 srec (header endianness unknown, data endianness unknown) i386 symbolsrec (header endianness unknown, data endianness unknown) i386 tekhex (header endianness unknown, data endianness unknown) i386 binary (header endianness unknown, data endianness unknown) i386 ihex (header endianness unknown, data endianness unknown) i386 elf32-i386 srec symbolsrec tekhex binary ihex i386 elf32-i386 srec symbolsrec tekhex binary ihex It might help to post to the list the output of: uname -a (remove the host name if you want). ldd /path/to/the/real/mysqld Also, try running /sbin/ldconfig as root just to make sure it is up to date. --Bill [EMAIL PROTECTED] wrote: I am getting some pretty odd errors from Mysqlit was running, hung up while importing data, and has been fried since. This is the exact error i am getting: # cd /usr/local/mysql # bin/mysqld /usr/libexec/ld-elf.so.1: bin/mysqld: Undefined symbol strtoll I would GREATLY appreciate any help on this...i have looked through the email archives, as well as the manuals and documentation, but seen nothing to explain it. I am desperately in need of assistance, as my webhost WAS located 2 doors down from the Towers, and is no longer aroundthe servers are co-located in California...but i am utterly on my own now for server administration. Amber - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Bill Adams TriQuint Semiconductor - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Can't get MySQL to use available memory (performance very slow)
I believe the answer will be for you to create a single index on *just* the cust column. (I assume that a specific cust id occurs only once or a few times in the whole table.) This will allow MySQL to use that index to find the small set of records (quickly) where cust=1, then to screen the email value against that set of records. Cheers, Kent query,database - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Copying from one table to another.
I obviously dont know what the error message is but Update tbl1, tbl2 set tbl1.CategoryInTable1 = tbl2.CategoryInTable 2 where ^ | This space may be a problem good luck, try to provide the error message -- kevin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
What have i done? adding new db
Kevin: A database is, in some sense, a container for your tables. It sounds like you want to compose a new container. Thus, To list your databases (containers): mysql show databases; ... it seems that the list should contain your dbb and mysql, probably also test. To create a new database (container): mysql create database new_dbb; Next, you would be able to use new_dbb; and begin creating tables in it, using the 'create table' SQL statement. Cheers, Kent. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Copying table V.2.0
Kevin thanks for your response. Here are the different errors for each SQl command I enter. Command: update tblSNLC,tblSNOrg set tblSNOrg.OrgSponsor1=tblSNLC.SponsorFull where tblSNOrg.OrgZip=tblSNLC.Zip; Error: Failed to execute SQL : SQL update tblSNLC,tblSNOrg set tblSNOrg.OrgSponsor1=tblSNLC.SponsorFull where tblSNOrg.OrgZip=tblSNLC.Zip; failed : You have an error in your SQL syntax near 'tblSNOrg set tblSNOrg.OrgSponsor1=tblSNLC.SponsorFull where tblSNOrg.OrgZip=tblS' at line 1 Command: update tblSNLC,tblSNOrg set OrgSponsor1=SponsorFull where OrgZip=Zip; Error: Failed to execute SQL : SQL update tblSNLC,tblSNOrg set OrgSponsor1=SponsorFull where OrgZip=Zip; failed : You have an error in your SQL syntax near 'tblSNOrg set OrgSponsor1=SponsorFull where OrgZip=Zip' at line 1 THIS NEXT ONE SEEMS THE CLOSEST Command: update tblSNOrg set OrgSponsor1=tblSNLC.SponsorFull where OrgZip=tblSNLC.Zip; Error: Failed to execute SQL : SQL update tblSNOrg set OrgSponsor1=tblSNLC.SponsorFull where OrgZip=tblSNLC.Zip; failed : Unknown table 'tblSNLC' in field list I don't know why it wouldn't find the table Thanks for any continued help. -eric On 9/12/2001 10:46 AM, Kevin Kotun [EMAIL PROTECTED] wrote: I obviously dont know what the error message is but Update tbl1, tbl2 set tbl1.CategoryInTable1 = tbl2.CategoryInTable 2 where ^ | This space may be a problem good luck, try to provide the error message -- kevin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql++ compilation difficulties
Hi there, I'm experiencing problems with compiling my source that uses mysql++. It compiles ok but in the linking process it prints many warnings and it doesn't produce any output file. When I pass the -c flag to gcc to stop at linking, it looks ok cause it produces a .o file. I have gcc version 2.95.2 19991024 (release) and mysql++ version 1.7.9 When i try to compile the examples that come with mysql++ it outputs many warnings too and there is also no output file. The same source I can compile under VisualC++ 6.0 and mysql++ 1.7 Pavol Cierny - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
I am having a hard time printing Select * from table_1 \p; the result is: -- Select * from table_1 -- . . . But it doesn't print. Anyone? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: print
At 2:14 PM -0400 9/12/01, Jeremy Morano wrote: I am having a hard time printing Select * from table_1 \p; the result is: -- Select * from table_1 -- . . . But it doesn't print. Anyone? Define what you mean by print. -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
where is my binary log file
hi, i have a lamer question: where is my binary log file? i can't find it. i am sure it exists because grows crazy, when i restore a database from dumpfile. i found nothing about binary log in my.cnf. version: mysql 3.23.32-log install path: /usr/local (default) thanx, ati - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Copying table V.2.0
I think you need a new approach. It appears that update does not support the join you are attempting. It seems that you are trying to update the value for a column from one table with the value of a column from another table. If this is the case, i would use a shell script to first extract the values from tblSNLC and then update them directly into the tblSNOrg Kevin thanks for your response. Here are the different errors for each SQl command I enter. Command: update tblSNLC,tblSNOrg set tblSNOrg.OrgSponsor1=tblSNLC.SponsorFull where tblSNOrg.OrgZip=tblSNLC.Zip; Error: Failed to execute SQL : SQL update tblSNLC,tblSNOrg set tblSNOrg.OrgSponsor1=tblSNLC.SponsorFull where tblSNOrg.OrgZip=tblSNLC.Zip; failed : You have an error in your SQL syntax near 'tblSNOrg set tblSNOrg.OrgSponsor1=tblSNLC.SponsorFull where tblSNOrg.OrgZip=tblS' at line 1 Command: update tblSNLC,tblSNOrg set OrgSponsor1=SponsorFull where OrgZip=Zip; Error: Failed to execute SQL : SQL update tblSNLC,tblSNOrg set OrgSponsor1=SponsorFull where OrgZip=Zip; failed : You have an error in your SQL syntax near 'tblSNOrg set OrgSponsor1=SponsorFull where OrgZip=Zip' at line 1 THIS NEXT ONE SEEMS THE CLOSEST Command: update tblSNOrg set OrgSponsor1=tblSNLC.SponsorFull where OrgZip=tblSNLC.Zip; Error: Failed to execute SQL : SQL update tblSNOrg set OrgSponsor1=tblSNLC.SponsorFull where OrgZip=tblSNLC.Zip; failed : Unknown table 'tblSNLC' in field list I don't know why it wouldn't find the table Thanks for any continued help. -eric On 9/12/2001 10:46 AM, Kevin Kotun [EMAIL PROTECTED] wrote: I obviously dont know what the error message is but Update tbl1, tbl2 set tbl1.CategoryInTable1 = tbl2.CategoryInTable 2 where ^ | This space may be a problem good luck, try to provide the error message -- kevin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Can someone please help with this?
I hope that someone can please tell me how to fix this. When I try to run IIS Im getting an error WMI ADAP was unable to load the w3ctrs.dll performance library due to an unknown problem within the library: 0x0 Thats just one of several. Im running win2k pro. I have installed PhP and MySQL ... Any help would be great. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: FW: URGENTE - Replication...... - mySql
On Wednesday 12 September 2001 10:36, Rodrigo Zerlotti wrote: Sasha, I tried the bug script to send the bug, but didn't have time to go thru the problems (looking for X, then couldn't open on vi). Reading that script I thought I saw support@..so I went ahead and send to that list. I knew it was a paid support list, but I didn't have any question, only let you know that it is a bug and I thought it justified the email to that list. Thanks for the feedback. We will see if we can clean up mysqlbug a bit to make it easier to use. You can, however, send a bug report without mysqlbug to [EMAIL PROTECTED], as long as you have clear instructions on how we can reproduce the bug on our systems. -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Urgent Assistance
Hi group, I am in need of assistance with a database and php query we are trying to achieve. Basically we are have a form where one field searches a field in the mysql database and the other searches for keywords using the MATCH query. What we need to do is for the user to be able to enter a date or keyword and for it to query the database. Is it possible to do alternate queries based upon what the user is entering. So we would like to be able to do a sql elseif statement, but I am unsure if this is possible. Here is out current code: $sql= SELECT *, MATCH (auction, email, website) AGAINST ('$keywords') AS score FROM ukcalendars WHERE date = '$date' HAVING score != 0 ORDER BY score ASC LIMIT $limitvalue1, $limit; But we need to be able to also do: $sql= SELECT * FROM ukcalendars WHERE date = '$date' LIMIT $limitvalue1, $limit; But I am unsure how I can achieve this, if at all possible. With thanks barry Zimmerman www.bzdpltd.co.uk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Comparing Dates
I have a date comparison problem that I'm sure is simple enough but I'm just not experienced enough to figure it out. I simply want to grab every entry in a given table that has been entered within the last three days. I'm using Perl so I first start with a Perl timestamp and convert it to a MySQL timestamp. ($sec,$min,$hr,$mday,$mon,$year,$wday,$yday,$isdst) = localtime(time); $year = $year + 1900; if ($mon = 9) { $mon = 0$mon; } if ($mday = 9) { $mday = 0$mday; } if ($hr = 9) { $hr = 0$hr; } if ($min = 9) { $min = 0$min; } if ($sec = 9) { $sec = 0$sec; } $currenttime = $year$mon$mday$hr$min$sec; Now I want to select all entries that are = ($currenttime - 3 days) It would work most of the time if I just subtracted 300 from $currenttime, however wouldn't things get messy at the beginnings of every month? For example, with a good, regular date like 20010915103934 (09/15/01), subtracting 300 would give me 20010912103934 (09/12/01). That would work. However, if $currenttime = 20010901103934 (09/01/01) and I subtracted 300, I would get 20010898103934 (08/98/01). See, that would be completely screwed up. How can I accomplish my goal? Please forgive the MySQL newbie for his stupidity. Thanks, -- Ned Dupont Web Developer WS Packaging Group Inc. 920-487-6270 [EMAIL PROTECTED] http://www.wspackaging.com -- International Webmasters Association http://iwanet.org At 5:03 PM -0700 9/4/01, Chad Berryman wrote: I am trying to create a MySQL SELECT statement using PHP where I am getting a filtered list back by a date in the database formatted as -mm-dd where the date falls between a one week window that is in constant motion. For example, take todays date (as a julian calendar number) and a date that is set 7 days in the future (also as a julian calendar number and find all rows in the database where the date field (as a julian number) falls between the julian number of the window, i.e. today and one week from today. The SELECT statement that I came up with is this SELECT *,DATE_FORMAT(birthday,'%M %d'), DAYOFYEAR(DATE_FORMAT(birthday,'$yr-%m-%d')) FROM table_name WHERE DAYOFYEAR(DATE_FORMAT(birthday,'$yr-%m-%d')) = $yday AND DAYOFYEAR(DATE_FORMAT(birthday,'$yr-%m-%d')) = $yday_hi; The PHP variables $yr, $yday, and $yday_hi are set as $yr is the current 4 digit year $yday is the current julian calendar date for today $yday_hi is the julian calendar date one week in the future. You're making this way too hard, I suspect. To find all birthdays from a target date to the target date plus a week, do this: ... WHERE birthday = $target_date AND birthday = DATE_ADD($target_date,INTERVAL 7 DAY) This select statement works fine until I get to December 24th of any year, and the $yday_hi goes beyond the actual number of julian days in this year. So I have created an if statement that says if the date in the future is bigger than the julian date for December 31 of this year, then subtract the 2 and set the date in the future as the difference. For example, if there are 364 days this year, and today's julian calendar date is 360, the one week in the future would be (360 + 7) or 367. So subtract 364 from 367 which is 3 and set the $yday_hi variable to 3. This makes the numbers work. So if today is December 30th (or 364) the week in the future date would become Jan 6 (or 6 as a julian date). It is at this time that the select statement look like SELECT ... WHERE birthday = 364 (today) AND = 6 (one week from today) My select statement will ONLY work if $yday is smaller than $yday_hi. Is there a way to make MySQL understand that I need dates at the end of the year, and at the beginning ?? I hope that makes sense. Chad - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql 3.23.42 errors during compile on Solaris
Hi, when I compilling mysql that occur something error below on solaris. Soft Spc. Solaris 8 Mysql 3.23.42 gcc 3.0.1 GNU Make 3.79.1 My steps: gunzip -d -c mysql-3.23.4.tar.gz | tar xvf - cd mysql-3.23.42 CC=gcc CFLAGS=-O3 CXXLD=g++ \ CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti \ ./configure \ --prefix=/usr/local/mysql \ --with-low-memory \ --with-extra-charsets=complex \ --enable-assembler make Error: creating mysqltest gcc -DUNDEF_THREADS_HACK -I./../include -I../include -I./.. -I.. -I..-O3 -DDBUG_OFF -O3 -felide-constructors -fno-exceptions -fno-rtti -fno-implicit-templates -fno-exceptions -fno-rtti -DHAVE_CURSES_H -I/usr/local/mysql-3.23.42/include -DHAVE_RWLOCK_T -c mysqlbinlog.cc /bin/sh ../libtool --mode=link gcc -O3 -DDBUG_OFF -O3 -felide-constructors -fno-exceptions -fno-rtti -fno-implicit-templates -fno-exceptions -fno-rtti -DHAVE_CURSES_H -I/usr/local/mysql-3.23.42/include -DHAVE_RWLOCK_T -o mysqlbinlog mysqlbinlog.o ../libmysql/libmysqlclient.la -lz -lcrypt -lgen -lsocket -lnsl -lm gcc -O3 -DDBUG_OFF -O3 -felide-constructors -fno-exceptions -fno-rtti -fno-implicit-templates -fno-exceptions -fno-rtti -DHAVE_CURSES_H -I/usr/local/mysql-3.23.42/include -DHAVE_RWLOCK_T -o .libs/mysqlbinlog mysqlbinlog.o ../libmysql/.libs/libmysqlclient.so -lz -lcrypt -lgen -lsocket -lnsl -lm -lz -lcrypt -lgen -lsocket -lnsl -lm -Wl,--rpath -Wl,/usr/local/mysql/lib/mysql mysqlbinlog.o(.gnu.linkonce.d._ZTV9Log_event+0xc): undefined reference to `__cxa_pure_virtual' mysqlbinlog.o(.gnu.linkonce.d._ZTV9Log_event+0x1c): undefined reference to `__cxa_pure_virtual' collect2: ld returned 1 exit status make[2]: *** [mysqlbinlog] Error 1 make[2]: Leaving directory `/usr/local/mysql-3.23.42/client' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/local/mysql-3.23.42' make: *** [all-recursive-am] Error 2 Anybody help-me? Thanks! --- José Raimundo S. Barbosamailto:[EMAIL PROTECTED] Setor de Informação DDR 621-0350/0324 --- Embrapa Amazônia Ocidental http://www.cpaa.embrapa.br Rod. AM-010 KM 29 CEP: 69011-970 Cx. Postal 319Manaus, AM - Brasil Fone:(092)621-0300 FAX:(092)622-1100/232-8101 Embrapa-Sat: 81 Fax: --- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Comparing Dates
I have a date comparison problem that I'm sure is simple enough but I'm just not experienced enough to figure it out. I simply want to grab every entry Um. First of all, better code would be: my @now = localtime( ); $now[5] += 1900; $now[4] += 1; $currenttime = sprintf( '%04d%02d%02d%02d%02d%02d', @now[5, 4, 3, 2, 1, 0] ); Second, to add/subtract dates in perl and other languages, check out Date::Calc. Third, in MySQL you cand do something like: WHERE some_dateDATE_SUB( NOW( ), INTERVAL 5 DAY) Check out the MySQL manual for more info on DATE_SUB. --Bill - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL: Unable to save result set
That error message is coming from PHP, not from MySQL. PHP generates that error message when, for some reason, the number of fields returned by a MySQL query was greater than zero, but the return from mysql_store_result() or mysql_use_result() was zero or NULL. The PHP code which checks those values is very dependent on the version of MySQL you are using. The check for valid fields is different for version before and after MySQL 3.22.24, and the query execution is different before and after MySQL version 3.21.99. Did you recently upgrade you MySQL server without getting a new PHP interpreter, or re-compiling your PHP interpreter with the newer MySQL client library? ..chris - Original Message - From: Catalin Tenita [EMAIL PROTECTED] Hello, Starting 2-3 days ago, when we or our users try to access some parts of our site we receive some PHP/SQL, as this: Warning: MySQL: Unable to save result set in /home/bestjobs/public_html/nb/insert_user.php on line 21 We did not change anything in the php scripta or database structure and when we've run the scripts on other server all os OK. So we believe this errors are caused by a sever problem. Can you tell me what kind of problems might be? Catalin Tenita - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql install failed on FreeBSD!!
Hi, I am pretty new to mysql and started installing it on freeBSD from usr/ports/. I got the following error. Can somebody help me why it is failing. thanks, siva === Installing for mysql-server-3.23.36 === mysql-server-3.23.36 depends on executable: mysql - not found ===Verifying install for mysql in /usr/ports/databases/mysql323-client === Building for mysql-client-3.23.36 make all-recursive Making all in include Making all in libmysql /bin/sh ../libtool --mode=link cc -DDBUG_OFF -O -pipe -o libmysqlclient.la -rp ath .iso.org.dod.internet.private.enterprises.clickarray/lib/mysql -version-info 10:0:0 libmysql.lo net.lo violite.lo password.lo get_password.lo errmsg.lo my_ init.lo my_static.lo my_malloc.lo my_realloc.lo my_creat e.lo my_delete.lo mf_tempfile.lo my_open.lo mf_casecnv.lo my _read.lo my_write.lo errors.lo my_error.lo my_getwd.lo my_div.l o mf_pack.lo my_messnc.lo mf_dirname.lo mf_fn_ext.lo mf_wcomp.lo typelib.lo safemalloc.lo my_alloc.lo mf_format.lo mf_path.lo mf_unixpath.lo my_fopen.lo my_fstream.lo mf_loadpath.lo my_pthread.lo my_thr_init.lo thr_mutex.lo mulalloc.lo string.lo default.lo my_compress.lo array.lo my_once.lo list.lo my_net.lo cha rset.lo hash.lo getopt.lo getopt1.lo getvar.lo my_lib.lo strmov.lo strxmov.lo st rnmov.lo strmake.lo strend.lo strnlen.lo strfill.lo is_prefix. lo int2str.lo str2int.lo strinstr.lo strcont.lo strcend.lo bchange.lo bmove.lo bmove_upp.lo longlon g2str.lostrtoull.lo strtoll.lo llstr.lo ctype.lo dbug.lo -lz -lcrypt -lm libtool: link: only absolute run-paths are allowed *** Error code 1 Stop in /usr/ports/databases/mysql323-client/work/mysql-3.23.36/libmysql. *** Error code 1 Stop in /usr/ports/databases/mysql323-client/work/mysql-3.23.36. *** Error code 1 Stop in /usr/ports/databases/mysql323-client. *** Error code 1 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Table Mysqld host doesnt exist
I installed MYSQL on a HPUX 11 machine and I ran the mysql-test-run script and everything passed, but when I start mysql up using bin/safe_mysqld or bin/safe_mysql --user=mysql I receive this error in the logfile Table 'mysqld.host' doesn't exist Any solutions -- # Kory Wheatley Academic Computing Analyst Sr. Phone 282-3874 # Everything must point to him. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql to oracle conversion
At 8:31 AM -0700 9/12/01, Gene Gurevich wrote: Hi. Is there a tool to convert a mysql database to oracle? thanks Check the Oracle web site. -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Renaming Columns...
How??? ALTER TABLE table1 RENAME ??? Tried it, dont work. - Deryck H - http://www.comp-u-exchange.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL on Mac OS X?
At 10:03 AM +0100 9/12/01, Paul Groves wrote: Has anyone had any experience of running MySQL on Mac OS X? If so, how have you found it - is it stable and non-buggy? Also, has anyone had any experience of using both MySQL *and* PHP together on Mac OS X? I would be very interested to hear anyone's thoughts on this, I use it on my iBook when I'm travelling and don't have access to MySQL on my primary servers. I run it with Perl (DBI), PHP 4, Python (DB-API), and Java (JDBC). I think I've gotten Ruby to compile and used the Ruby MySQL interface a bit, too. Don't quote me on that. :-) The one problem is that the server won't shut down properly. This is apparently a problem with Apple's thread library or something. kill -9 works, though. If you restart Mac OS X, it seems to pause during shutdown more with mysqld running than when it's not, which I attribute to the system waiting for mysqld to shut down, and then finally force killing it. regards Paul -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Renaming Columns...
How??? ALTER TABLE table1 RENAME ??? Tried it, dont work. That renames the table itself. ALTER TABLE tbl_name CHANGE old_name new_name column_definition where column_definition is how you defined the column when you created it. For example if you have a table CREATE TABLE xyz ( c CHAR(30) NOT NULL ) Then you can rename c to d like this: ALTER TABLE xyz CHANGE c d CHAR(30) NOT NULL To answer your next question :-), no, you can't do it without repeating the column definition. - Deryck H - http://www.comp-u-exchange.com -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SV: Renaming Columns...
Rename is for Tables (I think ...I am fresh, too. So fresh that I send it to you privatly. Sorry about that!) ALTER TABLE table1 CHANGE column1 coloum2 varchar(20) not null [or what ever datatype]; gives you what you want. Ann - Original Message - From: Deryck Henson [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Thursday, September 13, 2001 12:00 AM Subject: Renaming Columns... How??? ALTER TABLE table1 RENAME ??? Tried it, dont work. - Deryck H - http://www.comp-u-exchange.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Error Message: Impossible WHERE clause noticed after reading consttables
I have a table with several fields, the primary key is a CHAR(11) field that does NOT allow NULL values. This field is called rec_key. Now, when I attempt to run the following query: SELECT * FROM table_name WHERE rec_key LIKE 'key_value' it returns NO data.. If I drop EXPLAIN in front of it, I get the response: Impossible WHERE clause noticed after reading const tables. I am attaching a mysqldump of a portion of the data so you can test this yourself... This file has the complete table definition in it along with the data.. Lee Willmann - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Size of DB
Hello, I'm new to MySQL and I was wondering if there was a command that you can issue to see the current size of a mysql database (in kb or MB)? = 'Toine - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL getting backlogged
Right now MySQL is getting really backlogged but I have no idea why. There are 169 concurrently running queries, and 153 of them are in show the status as Opening tables. A processlist looks something like this (formatted by Status, Seconds query has been running, and query): Opening tables 15 SELECT users.username, user... Opening tables 15 SELECT users.username, user... Opening tables 15 SELECT users.username, user... Opening tables 13 SELECT users.username, da_i... Opening tables 13 SELECT users.username, user... Opening tables 13 SELECT users.username, user... Opening tables 13 SELECT users.username, user... Opening tables 13 SELECT users.username, user... Opening tables 9SELECT users.username, user... Opening tables 8SELECT users.username, user... Opening tables 8SELECT users.username, user... Opening tables 8SELECT users.username, user... Opening tables 8SELECT users.username, user... Opening tables 8SELECT users.username, user... The status line from the mysql client looks like this: Threads: 190 Questions: 9272 Slow queries: 311 Opens: 868 Flush tables: 1 Open tables: 862 Queries per second avg: 31.753 Threads: 204 Questions: 11381 Slow queries: 311 Opens: 871 Flush tables: 1 Open tables: 865 Queries per second avg: 30.349 What I don't get is why all those queries are at Opening tables. My table_cache is currently set to 2048. It's a FreeBSD 3.4-RELEASE box. $ sysctl kern.maxfilesperproc kern.maxfilesperproc: 16424 I just reloaded the processlist and now half of the queries are in closing tables state (with running times from 16 to 48 seconds) and the other half are in Opening tables state, with running times all at 1 second. Why are threads closing tables if the table cache isn't even full? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Designing a recovery plan for MySQL
I got an idea and thought i would ask around about a recovery plan about databases? Currently all i do is dump the databases on to a share on an NT box thru a SMB share from the RH 7.1 Linux DB server. The NT box is a Compaq CL1850 which is 2 Compaq 1850 server with a shared SCSI array. The NT box is backed up on a 6 hour interval. I was just wondering any other ideas. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
synopsis of the problem (one line)
Description: How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:root Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-3.23.42 (Source distribution) Environment: System: Linux edu 2.4.2-3 #1 Sun Jun 24 01:31:37 KST 2001 i686 unknown 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/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-85) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 9¿ù 12 22:30 /lib/libc.so.6 - libc-2.2.2.so -rwxr-xr-x1 root root 1236396 4¿ù 7 06:58 /lib/libc-2.2.2.so -rw-r--r--1 root root 26350254 4¿ù 7 04:27 /usr/lib/libc.a ::q! -rw-r--r--1 root root 178 4¿ù 7 04:27 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql --localstatedir=/usr/local/mysql/data --with-charset=euc_kr - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
synopsis of the problem (one line)
Description: How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:root Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-3.23.42 (Source distribution) Environment: System: Linux edu 2.4.2-3 #1 Sun Jun 24 01:31:37 KST 2001 i686 unknown 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/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-85) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 9¿ù 12 22:30 /lib/libc.so.6 - libc-2.2.2.so -rwxr-xr-x1 root root 1236396 4¿ù 7 06:58 /lib/libc-2.2.2.so -rw-r--r--1 root root 26350254 4¿ù 7 04:27 /usr/lib/libc.a -rw-r--r--1 root root 178 4¿ù 7 04:27 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql --localstatedir=/usr/local/mysql/data --with-charset=euc_kr - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SQL Expert Needed
Hi Guys, here goes.. SELECT count(page_searchwords.word_id) as score, page_data.id, filename, title FROM page_data, pagewords, page_searchwords WHERE (page_searchwords.media_type='static' AND pagewords.id = page_searchwords.word_id AND page_data.id = page_searchwords.id AND LCASE(pagewords.word) LIKE LCASE('%hit%')) OR (page_searchwords.media_type='static' AND pagewords.id = page_searchwords.word_id AND page_data.id = page_searchwords.id AND LCASE(pagewords.word) LIKE LCASE('%two%')) GROUP BY page_data.id ORDER BY score DESC; Hi Guys, above is one of the SQL queries my PHP codes makes up to search my database. That is what it looks like for a two words search, i.e. hit two. It looks like the following when it does a one word search, i.e. hit SELECT count(page_searchwords.word_id) as score, page_data.id, filename, title FROM page_data, pagewords, page_searchwords WHERE (page_searchwords.media_type='static' AND pagewords.id = page_searchwords.word_id AND page_data.id = page_searchwords.id AND LCASE(pagewords.word) LIKE LCASE('%hit%')) GROUP BY page_data.id ORDER BY score DESC; I'll now explain the tables to you. I have the follwing tables in my database. table: page_data table: pagewordstable: page_searchwords ++--+---+-+ ++-+ ++-++ | id | filename | title | contents | | id | word|| id | word_id | media_type | ++--+---+-+ ++-+ ++-++ | 1 | 01_title | ABC | information | | 1 | wtc || 2 | 1| static| | 2 | fileAA | foo | wtc | ++-+ ++-++ | 3 | foobar | bar | content | | 2 | information || 1 + 2| static| ++--+---+-+ ++-+ ++-++ It works like this. page_data has the webpage information in it, when the page get's update the SQL I have written get's all of the keywords from the page. It then get's the id's from the pagewords table (i.e. pagewords.id), adding the words if it is not already there. Then once it has all of the id's from pagewords (i.e. pagewords.id) it adds the information to the page_searchwords table. The page_searchwords.id column contains the equivalent of the page_data.id column. page_searchwords.word_id is the equivalent of the pagewords.id column and the media_type is any of the following three strings; static, pdf, news. The search works like this it. It sorts through the page_words table and get's the id of the words the user is searching. In the example above if the user search's for wtc and information, the id's it would retrieve are 1 and 2. Once it has these id's it then searches the page_searchwords table and retrieves any row which has a word_id value of either 1 or 2 (being wtc or information respectively). Once it has this it then write the search results out to the browser using the following columns from the page_data table; id, filename, title. I then also have another table: table: news ++--+-+--+ | id | headline | content | date | ++--+-+--+ | 1 | newHead | contentH| 11.01| ++--+-+--+ | 2 | header | bulding | 12.01| ++--+-+--+ This is much the same as the page_data title. I also have the contents of the news pages being update into the pagewords and page_searchword tables. What I need to know is how to look through these at the same time, and get the new id, headline and content out of the database. Does anybody have any idea? This does make sense doesn't it? Let me know if it doesn't thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Designing a recovery plan for MySQL
In the last episode (Sep 12), adam said: I got an idea and thought i would ask around about a recovery plan about databases? Currently all i do is dump the databases on to a share on an NT box thru a SMB share from the RH 7.1 Linux DB server. The NT box is a Compaq CL1850 which is 2 Compaq 1850 server with a shared SCSI array. The NT box is backed up on a 6 hour interval. I was just wondering any other ideas. How about simply backing up the mysql server itself, instead of copying the data over the wire to another machine? If all you do is inserts, and can tolerate having to rebuild the indexes on recovery, you don't even need to take the system down. Just back up the raw database files. If you want a consistent snapshot, you can mysqldump to a local file which you then back up, or create a slave mysqld for backup purposes that you shut down during the backup. That way your main databse is always active. -- Dan Nelson [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: my.cnf optimization question ..
On Tue, Sep 11, 2001 at 03:17:47PM -0500, Weslee Bilodeau wrote: They average around 500 connections/second at any given time, two have a master/slave setup. Connections/sec or Queries/sec? That's a lot of connections per second? Can you use persistent connections? It would save a lot of overhead. Half and half, at the moment .. We had a problem that when we connected to multiple database servers from PHP using persistant connections, it would get confused. By confused I meant 1.) It would 'leak' MySQL connections. Somehow it 'forgot' it had an open connection. 2.) It would pick the wrong server. Each server has specific information on it, in seperate database/tables. The persistant connection code would actually hand back the wrong database handle and the queries would fail. We had to disable persistant connections because of this. Ouch. I hadn't heard about those problems before. It's probably worth testing again, 'cause it will give you a nice boost--especially at that connection rate. Our current my.cnf file: [mysqld] skip-locking set-variable= key_buffer=384M set-variable= max_allowed_packet=1M set-variable= table_cache=400 set-variable= sort_buffer=10M set-variable= record_buffer=10M set-variable= thread_cache=8 You might increase the thread_cache quite a bit. It'll bypass the need to create/destroy threads all the time. It may not give you a big improvement, but it can't hurt. The reason I'm asking is because of the MySQL page on Linux-specific notes. Which basically said you can have lots of threads, providing your key-cache is low. Wonder what that really means... or at least what the rationale behind it is. Have you experimented much with they key_buffer? Any noticeable difference if you double it or cut it in half? I'm trying to get as many threads as I can , and get MySQL to be ram-happy for speed as well. A good plan. ;-) Any changes for this many connections/ram that would be suggested? How are things looking in SHOW STATUS? Any red flags that you've noticed? Any slow queries? Slow queries are actually watched with a fine-tooth comb. I catch anything slow, I first smack the programmer along side the head, then throw Paul's book at them. I attempt to optimize it where possible, or just drop thier table and force them to do it over again. Hahhahahah... Well, that's good to hear, I suppose. The queries themselves seem to be pretty well optimized, I just wanna make sure the config I've got can scale. :) I know the feeling. I'm used to servers with a few hundered connections, with 512 MB of ram .. Not what they want, which is a few thousand, with 2gb of ram. Having not broken the 1,000 mark myself, I don't have a lot else here to say. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 7 days, processed 146,377,980 queries (241/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php