Re[2]: Some more about mysql perfomance.
Hello Tim, Saturday, April 07, 2001, 3:21:52 AM, you wrote: The reason singly queries are slower are of course that the initialization phase (reading the data from a socket, parsing, locking, checking which keys to use) is about half of the query time. Peter Heikki made tests which also shows some strange things - for Peter example why INSERT is FASTER then SELECT. I haven't seen the test but I can imagine this is true in some context. The reason for this is that a SELECT has to go through many optimization stages to find out what indexes to use and what queries to do. This is one basic fault with SQL; The optimizer has to do a lot of work... TB Most high-end relational databases address this by... TB a) storing the query execution plan etc in a cache keyed by the sql TBstatement text. That way, if another statement with the same text is TBexecuted a ready-made execution plan is available. TB b) to make that effective they support placeholders that abstract out TBliteral values from the statement text, so the cached plan can be TBreused regardless of the literal values boind to the placeholders TBfor a particular execution. Well. This is not the real limitation at leas at this point. I've checked two things 1) just "select 10" which of couse does not need much optimizations 2) select from heap table the same query as I did from myisam. First query is about 4 times faster, and the second is at least 2 times faster then stock query and scales much petter then selecting multiple pages by hash in (XX,XX,XX). Both this things shows that sql parsing/commutication is not the only point. TB I appreciate that doing (b) would require major changes to the protocol TB etc, but it's just occured to me that there's a very simple way to TB avoid that but still get the benefits of (a)... TB Imagine if, when a statement arrived, mysqld made a char-by-char copy, TB but in that copy skipped out the literal values and kept a seperate TB list of those. That would be a very fast and simple piece of code. TB That 'abstracted' statement could then be used as the key to the TB statement cache. If it matched an entry in the cache then mysql TB could skip the generation of the query execution plan! TB (To simplify access rights issues you could also add the username to TB the abstracted statement.) TB What do you think Monty? TB Tim. -- Best regards, Petermailto:[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: Some more about mysql perfomance.
Hello Michael, Saturday, April 07, 2001, 3:14:42 AM, you wrote: MW Hi! "Peter" == Peter Zaitsev [EMAIL PROTECTED] writes: Peter Hello mysql, Peter I made one more test of mysql perfomance. Peter PIII-700/768Mb/Linux 2.4.2 glbc 2.1.3 Peter I had the followings table with 12.000.000 rows (well I checked Peter this with 1 rows as well but the speed does not differs much) Peter in it and I checked how fast I can select data by hash key "select * Peter from g00pages where hash=1" - the query was constant and only one Peter row matched. The speed was about queries/sec 1800. MW Is hash an unique key? No it's not but it has just a couple of collisions per 100.000 records. Peter So I decided to check what about selecting many pages at the time. Peter like "select * from g00pages there hash in (1,2,3...)" - the best Peter result I got is then selecting about 100 pages/query this gave me Peter about 2 times more perfomance then selecting pages one by one. This Peter locked even more upsetting. MW Why is this upsetting? Because you only got 3600 pages per second or MW because it was 2 times faster than single queries? Both :) I really expected about 1 of selects per second one by one, and much more scaling like I got with heap table, then I got up to 7 pages per second. MW The reason singly queries are slower are of course that the MW initialization phase (reading the data from a socket, parsing, MW locking, checking which keys to use) is about half of the query time. Yes, the problem is I thought this takes much more then 50% on such very simple query, then all data is in memory. The only thing indeed to call the os is data as myisam does not caches data, therefore I tested my reiserfs and got 25000 of file open+read+close per second on directory with 150 files of 10 bytes each :) Peter I've tried the same thing with heap table - the result's are Peter strange. The perfomance is starting from about 3600 pages/sec then Peter I've increased The number of pages/query I've got up to 7 Peter pages/sec which is quite good :) Peter The strange thing is why result differ so much then ALL data fits it Peter memory without any problem Peter Well. Of couse I'll soon try glibc 2.2.x with your patches but I Peter don't se how it can improve things then I have obly one thread Peter running and one cpu and the query is running relatively big. Peter Heikki made tests which also shows some strange things - for Peter example why INSERT is FASTER then SELECT. MW I haven't seen the test but I can imagine this is true in some MW context. The reason for this is that a SELECT has to go through many MW optimization stages to find out what indexes to use and what queries MW to do. This is one basic fault with SQL; The optimizer has to do a MW lot of work... Well. But then I select with multiple pages selected optimizer takes it's work ony once, and this is well showed with heap tables, but with myisam this somehow is not thrue. Other interesting thing is - if I'll tell mysql explictly to use the index will it reduce optimization cost ? It's a pity what mysql misses something like PROFILE call for the query so I could check how much time is spent for different phases of query execution. MW Sergei is actually working on something interesting for people that MW need all the speed they can get: We are going to provide a interface MW directly to the storage handler, without any optimizations. MW This will of course not be SQL, but we expect this to be VERY fast as MW long as you are searching on a specific key... Yes it's nice. The other possible speedup is prepeared statements, or execution plan cache (classical solutions) :) Peter Even looking at the context swithces does not explain the thing much Peter - my result show that this system can do about 300.000 of context Peter swithces per second - so 5.000-10.000 of context swithces per second Peter does not eat much from cpu. MW To be able to comment, I would need to make a gprof of this. MW (This has to wait at least until the end of next week...) OK. This is not really pain - just comments :) My current pains are problems with repair tables and keycache :) -- Best regards, Petermailto:[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: MySQLGUI strange behavior
Peter Adamka writes: Hi 1, I got packages from mysql site (3.23.33). 2, The mysqlGUI is 100% statical. 3, It crashes after I try to create database and then going to admin panel. 4, I've found something that I've not seen. It end crashes with segfoult. Malmo In order to pinpoint a problem, please send me also the output of SHOW GRANTS FOR the user with which you are logging in. Also, what is a name of the database that you have tried to create ?? I would truly like to pinpoint a bug and then to fix it. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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 run MYSQL 3.23.36 on HPUX 10.2
Kory Wheatley writes: I'm Trying to install the Binary Installation of Mysql 3.23.36 on HPUX 10.2. I receive the following error when I run the "scripts/mysql_install_db" Command. Warning: setrlimit couldn't increase number of open files to more than 60 . Warning: Changed limits: max_connections 50 table_cached:64 scripts/mysql_install_db[288]: 6288 Memory Fault(coredump) installation of grant tables failed! Does anyone know the solution? MYSQL Debug stuff below: __ Release: mysql-3.23.36 (Official MySQL binary) Environment: machine, os, target, libraries (multiple lines) System: HP-UX cwis B.10.20 C 9000/802 492603331 32-user license Some paths: /usr/bin/perl /usr/bin/make /usr/bin/cc Compilation info: CC='gcc' CFLAGS='-DHPUX -I/opt/dce/include -O6 -fpic' CXX='gcc' CXXFLAGS='-DHPUX -I/opt/dce/include -felide-constructors -fno-exceptions -fno-rtti -O6 ' LDFLAGS='' LIBC: -r-xr-xr-x 1 binbin1863680 Nov 10 1999 /lib/libc.1 -r--r--r-- 1 binbin2456532 Nov 10 1999 /lib/libc.a lrwx-- 1 root sys 15 Jul 30 1999 /lib/libc.sl - /usr/lib/libc.1 -r-xr-xr-x 1 binbin1863680 Nov 10 1999 /usr/lib/libc.1 -r--r--r-- 1 binbin2456532 Nov 10 1999 /usr/lib/libc.a lrwx-- 1 root sys 15 Jul 30 1999 /usr/lib/libc.sl - /usr/lib/libc.1 Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-pthread --with-named-thread-libs=-ldce --disable-shared Perl: This is perl, version 5.004_01 -- # Kory Wheatley Academic Computing Analyst Sr. Phone 282-3874 # Everything must point to him. Hi! Please read our manual on HP-UX. You need to do things. Apply all available patches (include DCE) plus raise limits for the user under whose uid MySQL daemon is running. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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
Transactions in MySql
MySql support transactions? The OLE-DB provider support transactions? Call the method Begintrans on a connection object (ADO) return an error!!!
Re: Enquiry
Sounds like you downloaded the Source code ... you need the 'Standard binary (tarball) distribution' for 'Windows 95/98/NT/2000 (Intel)' (at http://www.mysql.com/downloads/mysql-3.23.html) Download the binary version, unzip it, and you will be set to go! - Original Message - From: "Amit" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, April 07, 2001 11:40 AM Subject: Enquiry Dear Sir, This a mail from a new established software company. We are developing a software using vb6.0 as front-end and want to use MYSQL as back-end. We have already downloaded it from your site. It was the latest version MYSQL 3.23 for win95/98. But now we don't know how to install it on our system because we are unable to find any setup.exe or install.exe file in it. and the make_dir.bat file is causing a problem and does not execute. Another information we want is that wheather our software which is developed in VB 6.0 will be able to access the database in MYSQL if it is not installed on our client's machine. - 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
Advice on where to go next in profiling a query
We are very happy users of MySQL, which we run a nice big genome database on. We have a web front end to the database (www.ensembl.org if anyone is interested) and we are looking at getting our pages to come back faster. I have been moving things out of Perl into C for the heavier lifting between the database and the actual html/gif generation. Although there is alot more milage in this, we may soon be coming up to a mysql side limit. The main queries join two tables, both with indexes, looking like: sprintf(sqlbuffer, "SELECT IF (sgp.raw_ori=1,(f.seq_start+sgp.chr_start-sgp.raw_start-%d)," " (sgp.chr_start+sgp.raw_end-f.seq_end-%d)), " " IF (sgp.raw_ori=1,(f.seq_end+sgp.chr_start-sgp.raw_start-%d)," " (sgp.chr_start+sgp.raw_end-f.seq_start-%d))," " IF (sgp.raw_ori=1,f.strand,(-f.strand))," " f.id, f.score, f.analysis," " f.hstart, f.hend, f.hid" " FROM %s f,static_golden_path sgp" " WHERE sgp.raw_id = f.contig AND sgp.chr_end = %d AND sgp.chr_start = %d AND sgp.chr_name = '%s'" " AND f.score '%s'", start,start,start,start,table,start,end,chr_name,score); The table f can vary depending on the precise query. The main join is sgp.raw_id = f.contig with the main restriction being sgp.chr_end = X AND sgp.chr_start = Y getting an interval of rows on sgp. We have appropiate keys on the tables. Notice the nice if statements returning stuff, which work very well and don't seem to slow things down at all... Cardinality is about 5,000,000 rows for f, with the f.contig being around 400,000 unique ids (integers), whereas sgp has about 100,000 rows. The final query will return anywhere between 2 and 150 unique f.contig ids which get expanded to something like 20 to 5000 rows in the f table. The query comes back between 0.1 and 1.5 seconds (depending on the precise make up of the data), and this might soon dominate the page refresh rate. At the moment, the page refresh for larger regions is 40 seconds, which is unacceptable to users, so improving this query would be a big win. I am interested at the moment about how we go about investigating ways of getting this to go faster. At the moment we have a rather crude profiling tool for aspects of how fast things comes back inside the HTML generation code and of course we can run things from the mysql client to test query times. Does anyone have any advice about what we should look into first about improving turn-around thanks ewan - Ewan Birney. Mobile: +44 (0)7970 151230, Work: +44 1223 494420 [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
3.23.36: created tables still corrupted
Hi, i once reported this together with the "update fails after alter"-bug in 3.23.35; this is how it "works": mysql DROP TABLE IF EXISTS ttt; Query OK, 0 rows affected (0.01 sec) mysql CREATE TABLE ttt ( - i1 varchar(10) default NULL - ) TYPE=MyISAM; Query OK, 0 rows affected (0.00 sec) mysql INSERT INTO ttt VALUES ('1'); Query OK, 1 row affected (0.00 sec) mysql \q Bye balin:~ # myisamchk /usr/local/var/test/ttt.MYI Checking MyISAM file: /usr/local/var/test/ttt.MYI Data records: 1 Deleted blocks: 0 myisamchk: warning: 1 clients is using or hasn't closed the table properly - check file-size - check key delete-chain - check record delete-chain - check index reference - check record links MyISAM-table '/usr/local/var/test/ttt.MYI' is usable but should be fixed ^^^ note this; i get this on each and every table i create (3.23.24 was o.k.). Doesn't sound too nice for a production environment imho... This happens on Linux 2.2.18/glibc 2.1, Linux 2.2.18/glibc 2.2. Connection through socket. regards, Jan Legenhausen - 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
./configure help
hi everybody we get this err mex when we run: ./configure --prefix=7usr/local/mysql err mex: "configure: error: installation or configuration problem: C compiler cannot create executables" hoping that u can help us, we wish u a good day
Re: huidziekte
Sorry, maar het merendeel van de mailinglist spreekt ten eerste geen nederlands en het onderwerp van de mailinglist ligt wat anders dan de hieronder beschreven problemen... Gaarne dit soort mailtjes prive te houden, ook met het respect op de mensen die het al helemaal niet begrijpen. bvd. -- Sorry, but the biggest part of this mailinglist doesn't speak dutch and the subject of the mailinglist is also different than the below described problems. Please keep these kind of messages private, also with respect towards the non dutch speaking ppl on this mailinglist which form the majority. On Thu, 5 Apr 2001, Rita de Groot wrote: Vijf jaar voordat deze foto's werden genomen werd bij mij diagnose reumatische artritis gesteld en als zodanig ook behandeld. Niets hielp. Toen de ziekte zich zo manifesteerde zoals u hieronder kunt zien.. http://www.naardedokter.com/testimonials/sys_lup_eryth.htm - 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: ./configure help
At 17:25 7-4-01 +0200, com2 wrote: hi everybody we get this err mex when we run: ./configure --prefix=7usr/local/mysql Hrrr, 7usr/local/mysql ? dunno if that's the reason.. but it might not be able to find such path. /usr/local/mysql perhaps?? 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
New filter
I have now installed the new spam filter on this list. It is very simple - instead of having bad words, we now have good words. You must mention one of the following: sql, database, query in the body of your message to get past the filter. Substrings are ok, and check is case-insensitive so if you say MySQL, it will work. If you get a bounce, just reply after optional editing. But even if you do not edit, as long as your mail client quotes the original message entirely, it will go through, as the magic words will be included in the reply. I think the above three should be sufficient - if not, we can always reasonably extend them. If you post often, to safe-guard against a bounce, just add one of the magic words to your signature, I would of course recommend something like "MySQL is great!", but "MySQL is a rotten database" will work too, as far as the filter is concerned - then your message will always make it. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / 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
Multi-level JOIN query
Hi! I need some suggestions about a special query. The situation is: There are (for simplicity) 4 tables: A,B,C and D which must be joined like this: Between A and B must be an outer-join association and C and D must be connected to B also with outer-join. But this causes a 'Cross dependency found in OUTER JOIN' error. I could connect A and B with INNER JOIN but it's useless from my point of view. I think the problem could be solved with redesigning the database structure, but it's currently not possible. Does somebody know a good (general) solution for this? Temporary tables could help, but i deal with lot's of data and I'm afraid it would be very slow. Thanks! Christian Fischer - 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
Unaligned address crash on Tru64
Jesper: The problem is apparently a bug that under some circumstances tries to store an integer at an unaligned address with movl instruction. Slave code does a lot of address magic, so there is a lot of room for alignment bugs. Any chance you could run the slave in a debugger and find the line where this happens? -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / 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
Re: Foreign Keys
On Thu, 5 Apr 2001, Dennis Gearon wrote: Date: Thu, 05 Apr 2001 14:24:25 -0700 From: Dennis Gearon [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Foreign Keys Are people using Mysql using foreign keys and how are they using them? It seems that the way to use them is with the scripting language used to access the database. bonjour, neither foreign keys nor need for foreign keys using mysql. Use WHERE clause. A foreign key is a column (or columns) in a table that refers to a key in another table. A foreign key contains only values in the referenced key, or NULLs. Joins on referenced key/foreign key pairs are very common, regardless whether the DBMS is MySQL, Oracle or what-have-you. What MySQL lacks, that many DBMSs have, are relational integrity constraints that prevent you from inserting or altering values in a foreign key that are not in the referenced key, or deleting the rows in the referenced table that the foreign key refers to. This means that the programmer has to be careful to avoid writing code that creates orphan records, since MySQL won't prevent you from creating them. Bob Hall Know thyself? Absurd direction! Bubbles bear no introspection. -Khushhal Khan Khatak - 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: date select question (better explained)
I'm trying to figure out how to select records from an events database which (from today) will take place on next weekend. The table has a from_date and a to_date fields, among other. I've found a way mixing PHP with SQL, but I'm curious to know if is there a neat and pure SQL version using the built-in date functions in mySQL. Can you explain differently or give some more detail? Perhaps show some actual table data, show what output you want, state explicitly in words what you want to accomplish and explain what the problem is. I'm sure I (and any number of others can help), but I don't understand the problem based on what you've written. Sorry, I'll try to explain better. I want to develop a php/mysql based agenda of city activities, and these are stored in a table with id,type,title,description and from_date and to_date fields. A pseudo query which would retrieve what I need would be: select * from city_agenda where from_date='next_sunday' and to_date='next_saturday'; But I do not see how to get 'nex_saturday' and 'next_sunday' using mySQL date functions. With PHP is easy to find out these dates and pass them to the select, but I wonder if is there a pure SQL version of this. Anyone? TIA Llorenc Sole Maresme Netcom, S.L. Sir, the following retrieves the date for the Sunday of the current week that runs from Sunday to Saturday. Use Data_add() to add 7 and 13 days for next Sunday and the following Saturday. SELECT Date_sub( Now(), Interval If(Weekday(Now()) = 6, 0, Weekday(Now()) + 1) day ) Bob Hall Know thyself? Absurd direction! Bubbles bear no introspection. -Khushhal Khan Khatak - 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: Unaligned address crash on Tru64
-Original Message- From: Sasha Pachev [mailto:[EMAIL PROTECTED]] Sent: Saturday, April 07, 2001 6:54 PM To: Nemholt, Jesper Frank Cc: [EMAIL PROTECTED] Subject: Unaligned address crash on Tru64 Jesper: The problem is apparently a bug that under some circumstances tries to store an integer at an unaligned address with movl instruction. Slave code does a lot of address magic, so there is a lot of room for alignment bugs. Aha. I've also recieved unaligned access errors, allthoug without running into a crash, in other situations. I remember recieving it every time I access one of the following : mysqladmin status mysqladmin processlist mysqladmin extended-status mysqladmin variables I haven't checked if it is all of them or just one of them, but I get one "unaligned access" error every time I access a PHP page containing these as systemcalls. Any chance you could run the slave in a debugger and find the line where this happens? I'll try debugging next week. I'll debug the Compaq CC/C++ compiled version, since this is the one I hope to get working (it generally produces faster smaller binaries on Tru64 than GCC). One thing btw. for the MySQL INSTALL-SOURCE Tru64 documentation : Might be a good idea to add that in order to compile recent MySQL versions ( 3.22.x) one has to upgrade the make utility. The one present by default on all Tru64 versions until 5.1 is not able to make MySQL. I haven't checked if the one present on 5.1 or 5.1A is better. -- Un saludo / Venlig hilsen / Regards Jesper Frank Nemholt Unix System Manager Compaq Computer Corporation Phone : +34 699 419 171 E-Mail: [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: Multi-level JOIN query
Hi! I need some suggestions about a special query. The situation is: There are (for simplicity) 4 tables: A,B,C and D which must be joined like this: Between A and B must be an outer-join association and C and D must be connected to B also with outer-join. But this causes a 'Cross dependency found in OUTER JOIN' error. I could connect A and B with INNER JOIN but it's useless from my point of view. I think the problem could be solved with redesigning the database structure, but it's currently not possible. You need to specify the outer join. A LEFT OUTER JOIN B is not the same as A RIGHT OUTER JOIN B or B LEFT OUTER JOIN A. When you have nested outer joins, only one of the tables can be preserved. You need to specify which table is being preserved (all rows are returned). I recommend posting the table definitions and stating which columns are used in the joins. Does somebody know a good (general) solution for this? Temporary tables could help, but i deal with lot's of data and I'm afraid it would be very slow. Thanks! Christian Fischer Outer joins + lot's of data = slow queries, even without temp tables. Bob Hall Know thyself? Absurd direction! Bubbles bear no introspection. -Khushhal Khan Khatak - 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 speed :)
At 13:35 Uhr -0400 6.4.2001, Vivek Khera wrote: ... LIMIT '3',2 and resulting in a parse error. The fix was to call $sth-execute($start+0,$howmany+0) and then DBI did the right thing. A similar problem may occur if you use a text variable in a == comparison before passing it to execute. If you run perl with tainting check, DBD::mysql will interpret the text variable as number and not quote it, leading to either a parsing error or a security hole in your application. I have written about this on 2000/08/23 to the dbi-users and msql-mysql-modules lists. Tim Bunce suspected it to be a driver bug. I don't know if it has been solved. Christian. - 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: Some more about mysql perfomance.
Hi! "Tim" == Tim Bunce [EMAIL PROTECTED] writes: Tim On Sat, Apr 07, 2001 at 02:14:42AM +0300, Michael Widenius wrote: The reason singly queries are slower are of course that the initialization phase (reading the data from a socket, parsing, locking, checking which keys to use) is about half of the query time. Peter Heikki made tests which also shows some strange things - for Peter example why INSERT is FASTER then SELECT. I haven't seen the test but I can imagine this is true in some context. The reason for this is that a SELECT has to go through many optimization stages to find out what indexes to use and what queries to do. This is one basic fault with SQL; The optimizer has to do a lot of work... Tim Most high-end relational databases address this by... Tim a) storing the query execution plan etc in a cache keyed by the sql Timstatement text. That way, if another statement with the same text is Timexecuted a ready-made execution plan is available. Which databases are you referring to? According to the benchmarks I have run no one of the big database vendors does this very good by default. The problem with SQL is that the above approach doesn't work very well when you have more than one key in use by a query or the keys are unevenly distributed. Even with a cached query plan, you will still loose the time for sending the query, the parsing and initialization of the query. As the optimizer in MySQL is only a minor part of the total time for most queries, this will not give us any major speed increase. Prepared statements would help a bit, at least if the developer could give hints to the optimizer that it only need to use a given set of indexes (This would of course fail for some queries, but generally this would be good). Tim b) to make that effective they support placeholders that abstract out Timliteral values from the statement text, so the cached plan can be Timreused regardless of the literal values boind to the placeholders Timfor a particular execution. For any placeholder that is a key, we would still need to do a lot of the work that we do today for any query. Tim I appreciate that doing (b) would require major changes to the protocol Tim etc, but it's just occured to me that there's a very simple way to Tim avoid that but still get the benefits of (a)... We will add prepared statements in MySQL 4; At this point we don't intend to cache the query plan but only avoid all parsing overhead (all parameters will be sent in binary format, which will be MUCH faster) Tim Imagine if, when a statement arrived, mysqld made a char-by-char copy, Tim but in that copy skipped out the literal values and kept a seperate Tim list of those. That would be a very fast and simple piece of code. Tim That 'abstracted' statement could then be used as the key to the Tim statement cache. If it matched an entry in the cache then mysql Tim could skip the generation of the query execution plan! Tim (To simplify access rights issues you could also add the username to Tim the abstracted statement.) Tim What do you think Monty? My estimate (which could be wrong) is that we would get a 10 % speedup from the current setup. The major slow point here (I think) is sending the queries between the client and server. I will know more when we start benchmarking the embedded MySQL code, within the next two weeks, as this setup doesn't have any TCP/IP or socket overhead. What we also need to do is to benchmark the different sections in the MySQL code to be able to know how much a gain we can do by adding some kind of cached plans. I just hope that having to store and retrieve query plans will not cause almost as much overhead than the gain we would get from this. Another option would be to allow the user to specify the query plan MySQL should use. (In other words, more options like STRAIGHT_SELECT and use_index(...)). Theoretically this could give almost as good performance than cached query plans. Regards, Monty - 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: Some more about mysql perfomance.
Hi! "Peter" == Peter Zaitsev [EMAIL PROTECTED] writes: Peter Hello Michael, Peter Saturday, April 07, 2001, 3:14:42 AM, you wrote: MW Hi! "Peter" == Peter Zaitsev [EMAIL PROTECTED] writes: Peter Hello mysql, Peter I made one more test of mysql perfomance. Peter PIII-700/768Mb/Linux 2.4.2 glbc 2.1.3 Peter I had the followings table with 12.000.000 rows (well I checked Peter this with 1 rows as well but the speed does not differs much) Peter in it and I checked how fast I can select data by hash key "select * Peter from g00pages where hash=1" - the query was constant and only one Peter row matched. The speed was about queries/sec 1800. MW Is hash an unique key? Peter No it's not but it has just a couple of collisions per 100.000 Peter records. The problem with a not unique key is that MySQL will do an extra check if it should use the key during the optimization stage. If the key would be unique, MySQL can skip this stage. Peter So I decided to check what about selecting many pages at the time. Peter like "select * from g00pages there hash in (1,2,3...)" - the best Peter result I got is then selecting about 100 pages/query this gave me Peter about 2 times more perfomance then selecting pages one by one. This Peter locked even more upsetting. MW Why is this upsetting? Because you only got 3600 pages per second or MW because it was 2 times faster than single queries? Peter Both :) I really expected about 1 of selects per second one by Peter one, and much more scaling like I got with heap table, then I got up Peter to 7 pages per second. A thing I forgot to add: - As a lot of times goes to sending/receiving data between client/server I expect that you will get more than 3600 queries / second if you are using more than one client. Have you tried this? MW The reason singly queries are slower are of course that the MW initialization phase (reading the data from a socket, parsing, MW locking, checking which keys to use) is about half of the query time. Peter Yes, the problem is I thought this takes much more then 50% on such Peter very simple query, then all data is in memory. The only thing indeed Peter to call the os is data as myisam does not caches data, therefore I Peter tested my reiserfs and got 25000 of file open+read+close per second on Peter directory with 150 files of 10 bytes each :) Peter I've tried the same thing with heap table - the result's are Peter strange. The perfomance is starting from about 3600 pages/sec then Peter I've increased The number of pages/query I've got up to 7 Peter pages/sec which is quite good :) This shows that we need to do some more benchmarks to understand exactly where the time is spent for queries like this. Peter The strange thing is why result differ so much then ALL data fits it Peter memory without any problem Peter Well. Of couse I'll soon try glibc 2.2.x with your patches but I Peter don't se how it can improve things then I have obly one thread Peter running and one cpu and the query is running relatively big. glibc 2.2 will only help when you have many threads doing queries at the same time. Peter Heikki made tests which also shows some strange things - for Peter example why INSERT is FASTER then SELECT. MW I haven't seen the test but I can imagine this is true in some MW context. The reason for this is that a SELECT has to go through many MW optimization stages to find out what indexes to use and what queries MW to do. This is one basic fault with SQL; The optimizer has to do a MW lot of work... Peter Well. But then I select with multiple pages selected optimizer takes Peter it's work ony once, and this is well showed with heap tables, but with Peter myisam this somehow is not thrue. With MyISAM, there is a lot of more system calls involved than with HEAP tables ; It could be these that slows downs things. Peter Other interesting thing is - if I'll tell mysql explictly to use the Peter index will it reduce optimization cost ? Yes. Peter It's a pity what mysql misses something like PROFILE call for the Peter query so I could check how much time is spent for different phases of Peter query execution. Any suggestions for the output for this? MW Sergei is actually working on something interesting for people that MW need all the speed they can get: We are going to provide a interface MW directly to the storage handler, without any optimizations. MW This will of course not be SQL, but we expect this to be VERY fast as MW long as you are searching on a specific key... Peter Yes it's nice. The other possible speedup is prepeared statements, or Peter execution plan cache (classical solutions) :) We will add prepared statements in MySQL 4; The question is will these really help your basic setup? Peter Even looking at the context swithces does not explain the thing much Peter - my result show that this system can do about 300.000 of context Peter swithces per second - so 5.000-10.000 of
Re: Unaligned address crash on Tru64
On Saturday 07 April 2001 13:19, Nemholt, Jesper Frank wrote: -Original Message- From: Sasha Pachev [mailto:[EMAIL PROTECTED]] Sent: Saturday, April 07, 2001 6:54 PM To: Nemholt, Jesper Frank Cc: [EMAIL PROTECTED] Subject: Unaligned address crash on Tru64 Jesper: The problem is apparently a bug that under some circumstances tries to store an integer at an unaligned address with movl instruction. Slave code does a lot of address magic, so there is a lot of room for alignment bugs. Aha. I've also recieved unaligned access errors, allthoug without running into a crash, in other situations. I remember recieving it every time I access one of the following : mysqladmin status mysqladmin processlist mysqladmin extended-status mysqladmin variables I haven't checked if it is all of them or just one of them, but I get one "unaligned access" error every time I access a PHP page containing these as systemcalls. Was the error coming from mysqladmin or from mysqld itself? In any case, if this even happens with the non-replication code, it looks like there could be some problem with int4store() and int8store() macros. We would have to see which line the crash happens on, though. Any chance you could run the slave in a debugger and find the line where this happens? I'll try debugging next week. I'll debug the Compaq CC/C++ compiled version, since this is the one I hope to get working (it generally produces faster smaller binaries on Tru64 than GCC). One thing btw. for the MySQL INSTALL-SOURCE Tru64 documentation : Might be a good idea to add that in order to compile recent MySQL versions ( 3.22.x) one has to upgrade the make utility. The one present by default on all Tru64 versions until 5.1 is not able to make MySQL. I haven't checked if the one present on 5.1 or 5.1A is better. We recommend that you use gmake to build MySQL. Others may or may not work. I've just realized that we do not seem to have this recommendation in the manual, at least I cannot find it - will be fixed shortly. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / 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
Best field type for binary data
Hello List, I'm going to be storing a LOT of MP3's in a MySQL db, what's the best field type to use? Blob? Thanks, Tyler - 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 with jdbc
Hi I have a problem with SQL UPDATE statement within a Java programm which establish a connection to a Mysql Server over JDBC. The SQL UPDATE statement looks like that: UPDATE tableX set x = x + ? where rowx = ? where the walue of ? on the x = x + ? part my some times be - values and some time + values for example +1 or -10. But after the execution , if i make a select statement to look at the new values on the table , i see that random values are asigned, not the walues which i expect. What can be the reason Thanks for you answers __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.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
Testing alerts
I have just installed a special alert when somebody posts a message about a stack trace or segmentation fault to the general list. This is to test my alert system. Please disregard. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / 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
Re: problem with jdbc
On Saturday 07 April 2001 17:59, Kamil Yildirim wrote: Hi I have a problem with SQL UPDATE statement within a Java programm which establish a connection to a Mysql Server over JDBC. The SQL UPDATE statement looks like that: UPDATE tableX set x = x + ? where rowx = ? where the walue of ? on the x = x + ? part my some times be - values and some time + values for example +1 or -10. But after the execution , if i make a select statement to look at the new values on the table , i see that random values are asigned, not the walues which i expect. What can be the reason What version of MySQL are you using? -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / 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
a re-Install Nightmare.....
Hi there... I had installed mySQL about two weeks ago, then installed php and apache. All was working fine until I STUPIDLY deleted the mysql data table in 'var' a couple of days ago. I thought I could just re-install mySQL, but it has crapped out ever since. I heard that you must install PhP AFTER mySQL, so I deleted php and apache. still no good. below is what happens when I do the make... THE LAST GOOD LINE IS : c++ -03 -DDBUG_OFF -fno-implicit-templates -rdynamic -o .libs/mysql mysql.o read ibmysql/.libs/libmysqlclient.so -lz -lcrypt -lnsl -lm -lz -lcrypt -lnsl -lm -Wl, ../libmysql/.libs/libmysql.so: undefined reference to 'mkstemp64' collect2: ld returned 1 exit status make[2]: *** [mysql] error 1 make[2]: Leaving directory '/apps/mysql-3.23.36/client' make[1]: *** [all-recursive] Error 1 MAKE[1]: leaving directory '/apps/mysql-3.23.36' make: *** [all-recursive-am] Error 2 if I follow this with a make install, it craps out... \/apps/ is where I keep all my applications before I run and install them... please help, I have a presentation to do on Monday and this is the LAST thing I needed ! in desparation, Richard [EMAIL PROTECTED] www.stirlingbrig.com Stirling Brig - Music to Live to "Great spirits have always encountered violent opposition from mediocre minds." -- Albert Einstein - 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: more info on a re-install nightmare
re: my last email on a failed mySQL database install sorry ! forgot hte os etc... OS : RedHat 7.0 running on a Del CPi laptop with 128MEG ram, 4GIG Hd, pentII 266 CPU. Richard [EMAIL PROTECTED] www.stirlingbrig.com Stirling Brig - Music to Live to "Great spirits have always encountered violent opposition from mediocre minds." -- Albert Einstein - 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: INSERT DELAYED still keeps CRUSHING (trying everything)
On Thursday 01 March 2001 11:03, Artem Koutchine wrote: Sinisa, i thought i pointed out that mysql ALWAYS crashes on any single INSERT DELAY anytime, any database, under any conditions and during any weather. NO single INSERT DELAY can be executed successfully. This looks like a bug in the thread library. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / 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
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.36 (Source distribution) Environment: System: Linux localhost 2.2.17-8wl2smp #1 SMP Sun Jan 14 21:32:16 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.0) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 11 4¿ù 6 03:29 /lib/libc.so.6 - libc-2.2.so -rwxr-xr-x1 root root 4761074 12¿ù 15 22:39 /lib/libc-2.2.so -rw-r--r--1 root root 22855536 12¿ù 15 22:37 /usr/lib/libc.a -rw-r--r--1 root root 178 12¿ù 15 22:37 /usr/lib/libc.so lrwxrwxrwx1 root root 10 4¿ù 6 03:39 /usr/lib/libc-client.a - c-client.a Configure command: ./configure --prefix=/usr/local/mysql --localstatedir=/usr/local/mysqsl/date --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
uninstalling MySQL
how do I uninstall MySQL 3.22 after installing it? worst part is that I installed it so long ago that I can't remember if I did it by .rpm or .tar help please, Dave - 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
create table foo select * from bar does not copy keys??
I'm not sure if this is a bug or not, but I just realized today that some of my create table queries (on mysql 3.23.32 ) were not behaving as I would expect.. Example: ** mysql create table foo (id int not null primary key, field1 varchar(55), unique data_index (id,field1)); Query OK, 0 rows affected (0.04 sec) mysql show columns from foo; ++-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | ++-+--+-+-+---+ | id | int(11) | | PRI | 0 | | | field1 | varchar(55) | YES | | NULL| | ++-+--+-+-+---+ 2 rows in set (0.02 sec) mysql create table bar select * from foo; Query OK, 0 rows affected (0.07 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql show columns from bar; ++--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | ++--+--+-+-+---+ | id | int(11) | | | 0 | | | field1 | char(55) | YES | | NULL| | ++--+--+-+-+---+ 2 rows in set (0.00 sec) *** As you can see the primary key is not a part of table bar. Nor is the unique index as shown with mysqldump *** root@raid:/home/mswanson mysqldump -d test bar # MySQL dump 8.12 # # Host: localhostDatabase: test # # Server version3.23.32-log # # Table structure for table 'bar' # CREATE TABLE bar ( id int(11) NOT NULL default '0', field1 char(55) default NULL ) TYPE=MyISAM; ** The manual doesn't say anything about this. Is this a bug or just something I missed in the manual? Thanks -Marc- #/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/# #Marc Swanson | # #MSwanson Consulting | \|||/ # # | /o o\ # #Phone: (603)868-1721|-oooOooo-# #Fax:(603)868-1730| Solutions in: # #Mobile: (603)512-1267| 'PHP'Perl # #[EMAIL PROTECTED] | 'SQL'C++ # # | 'HTML 'Sh/Csh# #http://www.mswanson.com | 'Javascript# #/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/# - 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
Working with FIND_IN_SET
I am working on a rather large database project, in which I am making a text column that contains different data, seperated by commas. What I need to do is run a query where I will return only the datasets that contain any of sets that partially, or fully match any data in the set... For example, if the dataset contains: dark, black, small I want to be able to return this data if the query contains ran contains any of the following matches: dark black small sma bla ...etc... I do not, however, want a full LIKE search with wildcards, because I do not want to return the set if they were to search on 'all' (which would match smALL). Is there an easy way to do this, or am I forced into matching entire words in a set? I appreciate any help anyone could offer me... Thank you... John
Mysql ServerClient Myodbc Silent installation successfully completed
I have created a setup program using Wise Windows Installer Professional 3.0 . I also create a merge module. It can distribute mysql odbc driver and set it installed ot target windows system by using odbcinst.ini and odbc ini and required registry key. My setup uses that merge module and distribute out commercial software , mysqlserver , mysql client , myodbc with odbc2.5 and 3.0 support , creates a required dsn etc... by using just one install button :) And it works perfect. If anyone need this please mail me. If i get too many mail i will put theese subject on our company web page. Regards. Yusuf Incekara Avukatpro Limited Sirketi http://www.avukatpro.com/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: ./configure help
err mex: configure: error: installation or configuration problem: C compiler cannot create executables Take a look at config.log, you will usually find the real cause for the error in there. Jens - 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