MySQL 4.0.23 wrong shared libraries output??
4.0.22 libdbug.a libmyisam.a libmysqlclient.so.12.0.0 libnisam.a libheap.a libmyisammrg.a libmysqlclient.so libmystrings.alibvio.a libmerge.a libmysqlclient.la libmysqlclient.so.12libmysys.a 4.0.23 libdbug.a libmerge.a libmyisammrg.a libmysqlclient.12 libmysqlclient.la libmysys.a libvio.a libheap.a libmyisam.a libmysqlclient libmysqlclient.12.0.0 libmystrings.a libnisam.a Note that libraries that are compiled from 4.0.23 doesn't have .so (I didn't make any typo myself) When executing ldd /mysql linux-gate.so.1 => (0xe000) libreadline.so.4 => /usr/lib/libreadline.so.4 (0xb7fbb000) libncurses.so.5 => /usr/lib/libncurses.so.5 (0xb7f7b000) libmysqlclient.so.12 => not found Compile flags for 4.0.23 and 4.0.22 CFLAGS=-O2 -march=pentium4 -mcpu=pentium4 -fomit-frame-pointer -mmmx -msse -msse2 -mfpmath=sse CXXFLAGS=$CFLAGS ./configure --without-readline --without-bench --without-man --without-docs --with-vio --without-extra-tools --without-debug --with-unix-socket-path=/var/mysql/mysql.sock --enable-assembler --enable-shared --disable-static Anyone got this problem too? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
newbie help
I just created a database and tried to LOAD 1 line of data from a text file. I have only 9 coloums , most varchar, one char, one smallint (autoincrement) when i load the data (tab de-limeted) it goes fine but i get one Warning. I found on mysql.org that i need to INTO OUTFILE and look for errors,...but i dont see any? None of the coloums are overunning, all data types seem correct... What else could be going on? could i just ignore the warning? thank you bd - 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
mysqlgui
To whom it may concern, Where can i find the documentation for mysqlgui? thanks bd - 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
Possible Index problem?
I am using mysql verison 3.23.41-nt I am working with the following two tables. mysql> show create table table1; | Table | Create Table - | table1 | CREATE TABLE `table1` ( `Column1` varchar(63) NOT NULL default '', `Column2` varchar(31) default NULL PRIMARY KEY (`Column1`) ) TYPE=MyISAM | mysql> show create table table2; | Table | Create Table -- | table2 | CREATE TABLE `table2` ( `Column1` varchar(63) default NULL KEY `idx1` (`Column1`) ) TYPE=MyISAM | ++ 1) When i run the first query through explain the expected results happen mysql> explain SELECT table1.column1 FROM table1, table2 WHERE table1.column1 = table2.column2; +-+---+---+-+-+---+---+-+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +-+---+---+-+-+---+---+-+ | table1 | index | PRIMARY | PRIMARY | 63 | NULL | 57379 | Using index | | table2 | ref | idx1 | idx1| 64 | table1.column1| 1 | Using index | +-+---+---+-+-+---+---+-+ However, when i select an additional column, the following unexpected results happen mysql> explain SELECT table1.column1, table1.column2 FROM table1, table2 WHERE table1.column1 = table2.column2 +-+--+---+--+-+---+---+-+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +-+--+---+--+-+---+---+-+ | table1 | ALL | PRIMARY | NULL |NULL | NULL | 57379 | | | table2 | ref | idx1 | idx1 | 64 | table1.column1| 1 | Using index | +-+--+---+--+-+---+---+-+ 2) Also, look at the following scanario mysql> explain SELECT table1.column1 FROM table1, table2 WHERE table1.column1 = table2.column2 order by table1.column1 asc; +-+---+---+-+-+---+---+-+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +-+---+---+-+-+---+---+-+ | table1 | index | PRIMARY | PRIMARY | 63 | NULL | 57379 | Using index | | table2 | ref | idx1 | idx1| 64 | table1.column1| 1 | Using index | +-+---+---+-+-+---+---+-+ However, when i select an additional column, the following unexpected results happen mysql> explain SELECT table1.column1, table1.column2 FROM table1, table2 WHERE table1.column1 = table2.column2 order by table1.column1 asc +-+--+---+--+-+---+---++ | table | type | possible_keys | key | key_len | ref | rows | Extra | +-+--+---+--+-+---+---++ | table1 | ALL | PRIMARY | NULL |NULL | NULL | 57379 | Using filesort | | table2 | ref | idx1 | idx1 | 64 | table1.column1| 1 | Using index| +-+--+---+--+-+---+---++ I am baffled as to why simple selecting an extra column results in the index no longer being used even though the where clause has not changed. If anybody could provide me an explain as to why this is occuring with a solution, it would be greatly appreciated. TIA __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.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
question about show status.
Hi I have a question on the table_lock_waited and table_lock_immediate variables for MySQL. On my server, am seeing the sum of 'table_lock_immediate' and 'table_lock_waited' way less than 'Questions' for 'show status' (only about 40%). Although I do run queries like 'show status' they are definitely not run as often. Am running Mysql 3.23.40 with raid option on MYISAM. So: 1. Is 'questions' equals to the number of SQL statements sent to server? 2. Any explanations for the difference above? 3. Does every select, insert, and update that works on 1 table incur 1 lock, i.e. EITHER of the table_lock params will be increment for such queries? regards, Teck Lee - 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
question about temp tables
Hi While tuning the system to minimize locking, I added SQL_BUFFER_RESULT to some of my select statements. Since then have been seeing a lot of created_tmp_disk_tables e.g. below is what I see after restarting the system for less than an hour. | Created_tmp_disk_tables | 515 | | Created_tmp_tables | 717 | | Created_tmp_files| 0 | I have my temp table variables set to quite high and are fairly certain that my queries are less than 64M (any way to tell?). set-variable= tmp_table_size=64M set-variable= max_tmp_tables=100 set-variable= max_heap_table_size=64M Anything I have done wrong or should look into? Anyway to see what temp tables are being created and what for? regards, Teck Lee - 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: Java Applet for Mysql
Thanks for the prompt reply. I am new in Java. Can you recommend a online tutorial that related to Database programming(Java) for Mysql Many Thanks :Tanpy - Original Message - From: "Jeremy Zawodny" <[EMAIL PROTECTED]> To: "David Tan Teck Siang" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, May 31, 2001 3:35 PM Subject: Re: Java Applet for Mysql > On Thu, May 31, 2001 at 09:30:11AM +0800, David Tan Teck Siang wrote: > > > > Can anyone here recommend a link to the FREE and the most simple > > Java source code for MYSQL query without using Java runtime?? > > I'm confused. How do you plan to do this without a Java runtime? > > Have you looked on www.mysql.com? > > Jeremy > -- > Jeremy D. Zawodny, <[EMAIL PROTECTED]> > Technical Yahoo - Yahoo Finance > Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 > > MySQL 3.23.29: up 5 days, processed 35,429,838 queries (73/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
Java Applet for Mysql
Can anyone here recommend a link to the FREE and the most simple Java source code for MYSQL query without using Java runtime?? Thanks tanpy :)