Technical Clarification
Hi, We are doing a project with combination of ASP MYSQL (backend). We are having some problem for setting relationship between the tables. We have to know whether foreign key will be supported in MySQL and we came to know that there is no use for foreign key(as per your documentation: The FOREIGN KEY, CHECK, and REFERENCES clauses don't actually do anything. The syntax for them is provided only for compatibility, to make it easier to port code from other SQL servers and to run applications that create tables with references.) pls.. let us know whether we can use foreign key to access master table records in child tables. if there is any possiblity pls... provide solution for us. awaiting ur reply, at the earliest. regards, kathir.
MS OFFICE PROFESSIONAL 2000 $140
MS office professional 2000 FULL version for $140 !!! NEW !! If interested email at [EMAIL PROTECTED] Verified Business Paypal owner so purchases FULLY protected Verified Aol subscriber Verified Address Not burns,oem,accademic,charity,demo or otherwisebut FULLY hologrammed authentic ms office professional FULL version!! FULL product cd keys Word,excel,powerpoint,publisher,access,outlook and small business tools!!! ***Disclaimer:*** If this was sent to you by mistake or was unwanted I apologize. This is a ONE time offer and you will not be contacted again unless you reply back saying that you are interested. Thanks again - 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
About FULLTEXT
As of version 3.23.33 MySQL became attractive to deploy in our project
because it now includes (preliminary, though) support for full text
indeces. That is a GREAT advantage to prior versions. So,
congratulations for that feature, with that MySQL is definititly moving
on the right path and I'm very sure FULLTEXT is among the most important
feature why people decide to make use of MySQL.
Now, unfortunately the FULLTEXT support as it stands right now has a few
drawbacks (all my tests where done with 3.23.33 and ~ 20 rows (~
60MB) in my test table.:
- searches for words with hits 100 are reasonably fast (1 sec.)
- searches with hits 100 can get REALLY slow.:
4538 rows in 12.19 sec: select id from axp_bild where match(caption_de,
caption_us, caption_fr) against ('Kohl');
4998 rows in 6.09 sec: select id from axp_bild where upper(caption_de)
like '%KOHL%' or upper(caption_us) like '%KOHL%' or upper(caption_fr)
like '%KOHL%';
- mmhhh that makes me nervous! The FULLTEXT slower than full table
scan?
- The default for searches like "against ('A B')" is to "OR" A
and B, but it would be MUCH more usable to have it to "AND" A and B by
default.
Regards,
;Martin
-
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 backup mySQL database?
Keneth wrote: "When I try to dump sql database it gives me some errors 1.Error 1045 mysqldump --opt database backup-accp.sql mysqldump: Got error: 1045: Access denied for user: 'accp@localhost' (Using pass word: NO) " can you help? Please read the manual and list archive! Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ - 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: About FULLTEXT
Hi!
On Mar 12, Martin Rode wrote:
Now, unfortunately the FULLTEXT support as it stands right now has a few
drawbacks (all my tests where done with 3.23.33 and ~ 20 rows (~
60MB) in my test table.:
- searches for words with hits 100 are reasonably fast (1 sec.)
- searches with hits 100 can get REALLY slow.:
4538 rows in 12.19 sec: select id from axp_bild where match(caption_de,
caption_us, caption_fr) against ('Kohl');
4998 rows in 6.09 sec: select id from axp_bild where upper(caption_de)
like '%KOHL%' or upper(caption_us) like '%KOHL%' or upper(caption_fr)
like '%KOHL%';
- mmhhh that makes me nervous! The FULLTEXT slower than full table
scan?
It's easy to explain. Try them again. And in backward order. And again then ;-)
The first query is always slower. Subsequents are faster as lots of data
are already in the cache.
- The default for searches like "against ('A B')" is to "OR" A
and B, but it would be MUCH more usable to have it to "AND" A and B by
default.
http://www.mysql.com/doc/F/u/Fulltext_features_to_appear_in_MySQL_4.0.html
Regards,
Martin
Regards,
Sergei
--
MySQL Development Team
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
___/
-
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: Errors in PHP after upgrading to MySQL 3.23.34
Sorry, it appears to be _not_ a bug in mysql 3.23.34 but a conflict with the apache module mod_auth_mysql. It's still weird since i only noticed after installing 3.23.34, and had no problems herefore. Downgrading to a earlier version however did not solve the problem! My collegue installed the mod_auth_mysql this weekend and did not experience any problem as well. So there sure is some kind of conflict which I wouldn't dare to tell which, but it probably is not mysql 3.23.34 to blame! regards, rene - Original Message - From: "Ren Tegel" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 12, 2001 6:19 AM Subject: Errors in PHP after upgrading to MySQL 3.23.34 I installed the MySQL 3.23.34-1 rpm on my redhat 7 box. It all seemed to work fine, but suddenly i got this error in numerous of my php scripts. it happens only on update and insert statements. The data however might have been stored in the db. Warning: MySQL: Unable to save result set in /var/www/html/sub.php on line 34 when i look in the mysql error log i see such lines on some of the failed query's: 010312 6:04:13 Aborted connection 196 to db: 'logboek' user: 'html' host: `localhost' (Got an error reading communication packets) i'm especially wondering about the connection id, this seems to increase at every connection, however from my php scripts I make a persistant connection. Is this a incompatability issue of the php interface to mysql? ifso, must i re-compile my php binary after upgrading to 3.23.34? Fortunately it's not a production machine yet. thanx in advance, rene - 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
Crash of mysqld, HP-UX 10.20
Description: I`ve compiled the source package 3.23.32. CFLAGS="-DHPUX -I/opt/dce/include" CXXFLAGS="-DHPUX -I/opt/dce/include -felide-constructors -fno-exceptions -fno-rtti" CXX=gcc ./configure --with-pthread --with-named-thread-libs='-ldce' --prefix=/usr/local/mysql --disable-shared --with-low-memory gmake gmakeinstall cd /usr/local/mysql ./bin/mysql_install_db Output of the mysql_install_db script: Creating db table Creating host table Creating user table Creating func table Creating tables_priv table Creating columns_priv table ./bin/mysql_install_db[238]: 20017 Memory fault(coredump) Installation of grant tables failed! Examine the logs in /usr/local/mysql/var for more information. You can also try to start the mysqld demon with: /usr/local/mysql/libexec/mysqld --skip-grant You can use the command line tool /usr/local/mysql/bin/mysql to connect to the mysql database and look at the grant tables: shell /usr/local/mysql/bin/mysql -u root mysql mysql show tables Try 'mysqld --help' if you have problems with paths. Using --log gives you a log in /usr/local/mysql/var that may be helpful. The latest information about MySQL is available on the web at http://www.mysql.com Please consult the MySQL manual section: 'Problems running mysql_install_db', and the manual section that describes problems on your OS. Another information source is the MySQL email archive. Please check all of the above before mailing us! And if you do mail us, you MUST use the /usr/local/mysql/bin/mysqlbug script! How-To-Repeat: Fix: Submitter-Id: Originator:Thomas Meyer Organization: Institute of Physics University of Greifswald, Germany MySQL support: none Synopsis: Severity: critical Priority: high Category: mysql Class: sw-bug Release: mysql-3.22.32 (Source distribution) Environment: System: HP-UX plasma B.10.20 A 9000/735 2006626055 two-user license Some paths: /usr/contrib/bin/perl /usr/bin/make /usr/bin/gmake /usr/local/bin/gcc /usr/bin/cc GCC: Reading specs from /opt/gcc/lib/gcc-lib/hppa1.1-hp-hpux10.20/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='-DHPUX -I/opt/dce/include' CXX='gcc' CXXFLAGS='-DHPUX -I/opt/dce/include -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' Configure command: ./configure --with-pthread --with-named-thread-libs=-ldce --prefix=/usr/local/mysql --disable-shared --with-low-memory Perl: This is perl, version 4.0 - 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 mysql read from Informix
Perl DBI with the Mysql and the Informix drivers installed. Curtis - Original Message - From: "MArk Williams" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 12, 2001 7:21 AM Subject: Can mysql read from Informix I have a mysql server running. I would like to be able to select from the mysql DB, but get mysql to go to a remote Informix DB to get the data. Is there anyway of doing that? MArk - 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
Problem with c-code example ...
Hi! just downloaded MySQL, and compiled the c-code example located in MySQL\examples\libmysqltest It works fine for the default database called mysql ... but not for any of the other databases. Any clue? Best Regards, Christer - 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: About FULLTEXT
Sergei Golubchik wrote:
Hi!
On Mar 12, Martin Rode wrote:
Now, unfortunately the FULLTEXT support as it stands right now has a few
drawbacks (all my tests where done with 3.23.33 and ~ 20 rows (~
60MB) in my test table.:
- searches for words with hits 100 are reasonably fast (1 sec.)
- searches with hits 100 can get REALLY slow.:
4538 rows in 12.19 sec: select id from axp_bild where match(caption_de,
caption_us, caption_fr) against ('Kohl');
4998 rows in 6.09 sec: select id from axp_bild where upper(caption_de)
like '%KOHL%' or upper(caption_us) like '%KOHL%' or upper(caption_fr)
like '%KOHL%';
- mmhhh that makes me nervous! The FULLTEXT slower than full table
scan?
It's easy to explain. Try them again. And in backward order. And again then ;-)
The first query is always slower. Subsequents are faster as lots of data
are already in the cache.
Mmmhhh you are right. It's not that bad. But still for new queries with new words
I
hardly get below 4 sec. search time for queries with numbers of matches 1000.
default.
http://www.mysql.com/doc/F/u/Fulltext_features_to_appear_in_MySQL_4.0.html
Yes, I've seen that document, but what I am talking about the DEFAULT behavior if one
doesn't prefix the words with "+" or "-" should definitely "+".
"Aaaa Bbbb" should definitely execute as "+Aaaa +B".
Regards,
Martin
-
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
Comparison of BDB/Gemini/Innobase tables?
Can someone point me to a comparison of the three different transaction-based table types in MySQL? It is unclear from the on-line documentation what the benefits/features/limitations are for each of these types. Thanks Ray -- --- Raymond Cote, President Appropriate Solutions, Inc. www.AppropriateSolutions.com [EMAIL PROTECTED] 603.924.6079(v) POB 458, Peterborough, NH 03458603.924.8668(f) - 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: am I alone? (scale)
Justin writes:
Thank you Sinisa,
I actually did try the upgade, but rapidly reverted due to errors
such as these:
mysqld got signal 11;
stack range sanity check, ok, backtrace follows
0x812cfea
0x809f541
0x809da87
:
:
etc
AND...
read_const: Got error 127 when reading table ./
read_next_with_key: Got error 134 when reading table ./
read_cost: Got error 134 when reading table ./...
(sometimes dozens and dozens repeated.. re-optimizing the
table may cure them for a short while. Again this was only
on the largest/busiest few tables).
So I went back to the previous last snap of the 3.22
On the threads / glibc issue: I'm using the *statically linked*
version of mysqld from your download page, in both 3.23 (that gave
erros above), and 3.22 (that gives corrupt indexes), therefore my
understanding was that glibc / linux threads issues would not
be an issue? is that understanding incorrect?
What else in a 2.2.14 SMP kernel can cause a problem for
statically linked 3.22 or 3.23 ? I would need some clearer
explanation before making a new kernel.
By the way, we bought the $1000 support license last week,
but so far have not got into your supportwizard site.. I've
emailed support@ about this. Just so you don't think we're
not willing to pay for some attention.
thanks
-Justin
Hi!
Regarding SMP, there have been some reports on the kernel list.
But you should upgrade !!
Before that , please check and repair all corrupted tables, because,
as so many users on this list know, corrupted table(s) may crash
MySQL.
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: SELECT, LEFT JOIN, and user variables
Gary Shea writes:
cut
Sorry, this is my fault for not describing the problem better.
Here's the result I get with DISTINCT (I've given the columns
names to make the table smaller, but not changed the SQL from what
I sent in the bug report):
+---+
| i |
+---+
| 1 |
| 2 |
+---+
+---+-+-+-++
| i | vv1 | vv2 | vv3 | @vv1+@vv2+@vv3 |
+---+-+-+-++
| 1 | 1 | 0 | 1 | 1 |
| 2 | 1 | 0 | 0 | 1 |
+---+-+-+-++
Note that the sum is not correct: the last column values
should be 2 and 1, not 1 and 1. With DISTINCT, the sum
value is always correct for the very last row, and the
sum value for all other rows is the same as the
sum value in the last row!
Here's the result without DISTINCT:
+---+
| i |
+---+
| 1 |
| 2 |
+---+
+---+-+-+-++
| i | vv1 | vv2 | vv3 | @vv1+@vv2+@vv3 |
+---+-+-+-++
| 1 | 1 | 0 | 1 | 2 |
| 2 | 1 | 0 | 0 | 1 |
+---+-+-+-++
As you can see, the sums are now correct.
After I posted the bug report, I noticed that the same problem
occurs if I used ORDER BY. Probably a hint in there somewhere ;)
Sorry for the poor report!
Gary
Thank you for your report.
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: MySQL 3.23.34a - Lost connection to MySQL server during query
Jordan Russell writes:
Seems like MySQL 3.23.34a has a problem (?). I'm using the RPMs from the
MySQL web site on RH 7.0.
CREATE TABLE files (
id int(11) NOT NULL auto_increment,
folderid int(11) NOT NULL default '0',
name varchar(100) NOT NULL default '',
date datetime default NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;
Add some records (5000 in my case) with random values. Then:
mysql SELECT files.id FROM files ORDER BY files.date LIMIT 1;
ERROR 2013: Lost connection to MySQL server during query
mysql
Number of processes running now: 0
010312 01:40:16 mysqld restarted
Same thing works fine in 3.23.33 (I've gone back and checked).
Jordan Russell
Hi!
I was not able to obtain the same effect on my 3.23.33. Please uploat
your table to ftp://secret.mysql.com/pub/mysql/Incoming , so that I
can test 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: Crash of mysqld, HP-UX 10.20
[EMAIL PROTECTED] writes:
Description:
I`ve compiled the source package 3.23.32.
CFLAGS="-DHPUX -I/opt/dce/include" CXXFLAGS="-DHPUX -I/opt/dce/include
-felide-constructors -fno-exceptions -fno-rtti" CXX=gcc ./configure --with-pthread
--with-named-thread-libs='-ldce' --prefix=/usr/local/mysql --disable-shared
--with-low-memory
gmake
gmakeinstall
cd /usr/local/mysql
./bin/mysql_install_db
Output of the mysql_install_db script:
Creating db table
Creating host table
Creating user table
Creating func table
Creating tables_priv table
Creating columns_priv table
./bin/mysql_install_db[238]: 20017 Memory fault(coredump)
Installation of grant tables failed!
Examine the logs in /usr/local/mysql/var for more information.
You can also try to start the mysqld demon with:
/usr/local/mysql/libexec/mysqld --skip-grant
You can use the command line tool
/usr/local/mysql/bin/mysql to connect to the mysql
database and look at the grant tables:
shell /usr/local/mysql/bin/mysql -u root mysql
mysql show tables
Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in /usr/local/mysql/var that may be helpful.
The latest information about MySQL is available on the web at
http://www.mysql.com
Please consult the MySQL manual section: 'Problems running mysql_install_db',
and the manual section that describes problems on your OS.
Another information source is the MySQL email archive.
Please check all of the above before mailing us!
And if you do mail us, you MUST use the /usr/local/mysql/bin/mysqlbug script!
How-To-Repeat:
Fix:
Submitter-Id:
Originator: Thomas Meyer
Organization:
Institute of Physics
University of Greifswald, Germany
MySQL support: none
Synopsis:
Severity: critical
Priority: high
Category: mysql
Class: sw-bug
Release:mysql-3.22.32 (Source distribution)
Environment:
System: HP-UX plasma B.10.20 A 9000/735 2006626055 two-user license
Some paths: /usr/contrib/bin/perl /usr/bin/make /usr/bin/gmake /usr/local/bin/gcc
/usr/bin/cc
GCC: Reading specs from /opt/gcc/lib/gcc-lib/hppa1.1-hp-hpux10.20/2.95.2/specs
gcc version 2.95.2 19991024 (release)
Compilation info: CC='gcc' CFLAGS='-DHPUX -I/opt/dce/include' CXX='gcc'
CXXFLAGS='-DHPUX -I/opt/dce/include -felide-constructors -fno-exceptions -fno-rtti'
LDFLAGS=''
Configure command: ./configure --with-pthread --with-named-thread-libs=-ldce
--prefix=/usr/local/mysql --disable-shared --with-low-memory
Perl: This is perl, version 4.0
Hi!
Experience with many 10.20 users shows that the above error happens
when HP-UX is not patched with all patches available.
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: Technical Clarification
Greetings and salutations, EverybodySingAlong MySQL Supports FKs. A FK is a table's PK value, stored in another table in order to relate the records together. It does NOT support FK CONSTRAINTS. (Cascading deletes, restricts, etc.) /EverybodySingAlong ...and now for the opinion portion of our show... For all the of databases I've worked on for the past 16 years, this is not a deal killer. It just means that I, as the developer, have to do my job. IN a LOT of ways, FK constraints are bad, evil things that were designed so programmers could slack. :) Kidding, of course, but if not implemented properly, they can cause problems and they ALWAYS cost performance. Currently, my largest MySQL databases is a whopping 30 tables! (ok, so I'm not working on a grand scale here!) But 90% of my tables have FKs in them from other tables. The only difference between this database and it's MSSQL sibling (I'm porting) is that I have to manually cascade my deletes. But since my license for MSSQL was going to be $5k+ this year, it's worth it! :) Stored Procedures, IMHO, should be a much higher priority for the development team. Cal http://www.calevans.com -Original Message- From: gopinath [mailto:[EMAIL PROTECTED]] Sent: Monday, March 12, 2001 3:16 AM To: [EMAIL PROTECTED] Subject: Technical Clarification Hi, We are doing a project with combination of ASP MYSQL (backend). We are having some problem for setting relationship between the tables. We have to know whether foreign key will be supported in MySQL and we came to know that there is no use for foreign key(as per your documentation: The FOREIGN KEY, CHECK, and REFERENCES clauses don't actually do anything. The syntax for them is provided only for compatibility, to make it easier to port code from other SQL servers and to run applications that create tables with references.) pls.. let us know whether we can use foreign key to access master table records in child tables. if there is any possiblity pls... provide solution for us. awaiting ur reply, at the earliest. regards, kathir. - 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: from where shall I start ?
Do't be offended by the title: http://www1.fatbrain.com/asp/bookinfo/bookinfo.asp?theisbn=0764504150vm= GREAT Primer on SQL. Very M$ SQL oriented but you will get enough grounding in SQL to make the leap to MySQL. Cal http://www.calevans.com -Original Message- From: hanan khader [mailto:[EMAIL PROTECTED]] Sent: Monday, March 12, 2001 4:02 AM To: [EMAIL PROTECTED] Subject: from where shall I start ? Hello , to build a database using SQL Server, from where shall I start ? I mean, what shall I install on my Server, and how can I work with MySql ? sorry Iam a new in the area, and I need help ... Hanan _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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
RE: from where shall I start ?
Hi, first, from c:\mysql\bin run mysql then you can create a database named as you like with command "create database;" after you can view it, "show database;". When you had created your database, you can create your first table. Regards, Carlos -Original Message- From: hanan khader [mailto:[EMAIL PROTECTED]] Sent: lunes, 12 de marzo de 2001 11:02 To: [EMAIL PROTECTED] Subject: from where shall I start ? Hello , to build a database using SQL Server, from where shall I start ? I mean, what shall I install on my Server, and how can I work with MySql ? sorry Iam a new in the area, and I need help ... Hanan _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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
getting frequent signal 11 after upgrade from 3.23.28 to 3.23.34
Description: I just upgraded from Mysql 3.23.28 to 3.23.34 and I'm now seeing mysql errors from my scripts that say "mysqld has gone away". The /var/lib/mysql/host.err log says this repeatedly: mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died. Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Bogus stack limit or frame pointer, aborting backtrace. The db is working otherwise and the system seems otherwise unaffected, there are just errors now and again. How-To-Repeat: It's happening intermittently. Fix: none know at this time. Submitter-Id: submitter ID Originator:Bill Marrs Organization: MySQL support: none Synopsis: frequent signal 11 after upgrade from 3.23.28 to 3.23.34 Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.34 (Official MySQL RPM) Server: /usr/bin/mysqladmin Ver 8.17 Distrib 3.23.34, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.34 Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 56 min 45 sec Threads: 19 Questions: 51769 Slow queries: 0 Opens: 61 Flush tables: 1 Open tables: 55 Queries per second avg: 15.204 Environment: System: Linux ugtz.com 2.2.17 #6 SMP Wed Dec 6 18:47:48 EST 2000 i686 unknown Architecture: i686 I'm using Redhat Linux 7.0, 2.2.17 kernel. My system is a dual 800Mhz Pentium III, 756MB RAM, with a SCSI disk. 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='egcs' CFLAGS='-O6 -fomit-frame-pointer -mpentium' CXX='egcs' CXXFLAGS='-O6 -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 11 Dec 8 05:21 /lib/libc.so.6 - libc-2.2.so -rwxr-xr-x1 root root 4733359 Nov 19 09:25 /lib/libc-2.2.so -rw-r--r--1 root root 22806158 Nov 19 09:22 /usr/lib/libc.a -rw-r--r--1 root root 178 Nov 19 09:22 /usr/lib/libc.so Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man --without-berkeley-db --without-innobase '--with-comment=Official MySQL RPM' - 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: searching ALL tables
Here it is in perl/DBI using hashes of arrays:
my $database =
DBI-connect("DBI:mysql:database=$DATABASENAME;host=$HOSTNAME
ST",$MYSQLUSER,$MYSQLPASS,{RaiseError=0,PrintError=0});
my $tablea = $database-prepare("SHOW TABLES FROM DATABASENAME");
$tablea-execute();
my @active_tables;
while(my @temp = $tablea-fetchrow_array){
foreach my $tmptable (@temp){
push @alltables, $tmptable;
}
}
$tablea-finish();
foreach my $table (@alltables){
my $comand = "SELECT BLAH FROM $table";
my $sth = $database-prepare("$comand");
$sth-execute();
while(my $ref = $sth-fetchrow_hashref()) {
push @LoH, $ref;# add hits to list
}
}
for $i (0..$#LoH) {
#See camel book for printing of lists. There's lots you can do here.
for $key %{$LoH[$i]}){
print $key=$LoH[$i]{$key}\n ";
}
}
On Fri, 9 Mar 2001, Adam Crawford wrote:
Hi all,
I just want to know how to search all tables
I can work out how to search one table, or a few of them at a time
but since we have 1000+ tables, I figure there must be an easyer way
I have tried using % * instead of the table name, but with no luck
Hope someone can help
Thank you in advance.
Regards,
Adam Crawford
ps, please be sure to cc me a copy of any replys, as i am not subscribed to
the list.
-
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: getting frequent signal 11 after upgrade from 3.23.28 to 3.23.34
HI!
Please try to make a repeatable test case if possible.
This means a set of commands that would always lead to MySQL crashing.
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
mySQL error ?
I couldn't connect to mysql server, beacuse it said that user root@localhost couldn't connect (?!) but before that I did something with the grant tables, I don't remeber what? But I made one cgi that used tables, but it coonected to the mysql server as root user and a password, and it perfectly worked. Then I erased mysql directory and compiled binary version of mysql again and it said that it can't load mysql because of /tmp/mysql.sock , I am not quite sure what that is. Then I installed rpm version of mysql and I got the same message for /tmp/mysql.sock I don't know what to do now. Please help I need to install it, because I just started to practice mysql and also connecting cgi to mysql and viewing all that in browser. Thanks in advance Zoran Raskovic __ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. 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
C API for Create Table
Hi, Can anyboby help me out. I am in a fix over how to carry out CREATE TABLE using C APIs. The manual is of no help in this matter. So anybody I please help me out. Thanks in advance. Shambhu. _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.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: getting frequent signal 11 after upgrade from 3.23.28 to 3.23.34
At 05:14 PM 3/12/2001 +0200, Sinisa Milivojevic wrote: Please try to make a repeatable test case if possible. This means a set of commands that would always lead to MySQL crashing. The problem does seem caused by a sequential set of operations. The script that I've seen cause the problem sometimes crashes with this error and other times does not. I'll keep trying to track it down though... I was hoping that someone out there would have seen something similar... -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: getting frequent signal 11 after upgrade from 3.23.28 to 3.23.34
The problem does seem caused by a sequential set of operations. The script oops, I'm meant to say "doesn't seem caused" -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
Flags problem 3.23.34a with BDB support/Innobase on HP-UX 10.20
Hi! I am currently trying to compile 3.23.34a coming with BDB support. I have zlib installed in the /usr/local (not normally searched for libraries), so that until now I have [CFLAGS etc ] LDFLAGS=-L/usr/local/lib ./configure When enabling --with-berkeley-db, compilation fails, because I have another version of Berkeley DB (2.xx) installed in /usr/local/lib. Reason: The Makefile in sql/ specifies the locations given in LDFLAGS before -L../bdb/build-unix. The full solution would probably be to move around options, so that -L../bdb/build-unix is searched before other paths in any case. (One cannot put LIBS=-L/usr/local/lib, because -lz et al are (correctly) added before the specified contents of LIBS.) Is there any other solution recommended? My platform is HP-UX 10.20 with native compilers. Here the excerpt with the offending command (the optimization warnings can be ignored, they come because gcc compiler flags are hardcoded without need): aCC -O3 -DDBUG_OFF -Aa +O3 +Olibcalls +Onolimit +DAportable -DHAVE_BROKEN_SNPRINTF -D_INCLUDE_LONGLONG -L/usr/local/lib -o mysqld sql_lex.o item.o item_sum.o item_buff.o item_func.o item_cmpfunc.o item_strfunc.o item_timefunc.o thr_malloc.o item_create.o field.o key.o sql_class.o sql_list.o net_serv.o violite.o net_pkg.o lock.o my_lock.o sql_string.o sql_manager.o sql_map.o mysqld.o password.o hash_filo.o hostname.o convert.o sql_parse.o sql_yacc.o sql_base.o table.o sql_select.o sql_insert.o sql_update.o sql_delete.o procedure.o item_uniq.o sql_test.o lmmrg.a ../heap/libheap.a ../mysys/libmysys.a ../dbug/libdbug.a ../regex/libregex.a ../strings/libmystrings.a -lc_r -lz -lcrypt -lm -ldce aCC: warning 901: unknown option: `-3': use +help for online documentation. aCC: warning 928: option +O3 overrides previous setting of +O2 /usr/ccs/bin/ld: Unsatisfied symbols: db_create (code) db_env_create (code) BTW, the compilation of innobase fails with cc -DHAVE_CONFIG_H -I. -I. -I.. -I../../include -I../include -DHPUX -Dinline= - I/opt/dce/include -I/usr/local/include -O -DDBUG_OFF -Ae +O3 +Olibcalls +Onolim it +DAportable -DHAVE_BROKEN_SNPRINTF -c os0thread.c cc: warning 454: Option +O3 overrides previous setting of +O2. cc: "os0thread.c", line 29: error 1527: Incompatible types in cast: Must cast fr om scalar to scalar or to void type. cc: "os0thread.c", line 69: error 1554: Indirection must be through a pointer. cc: "os0thread.c", line 69: warning 563: Argument #2 is not the correct type. cc: "os0thread.c", line 69: error 1718: Types are not assignment-compatible. cc: "os0thread.c", line 69: warning 563: Argument #3 is not the correct type. cc: "os0thread.c", line 69: warning 604: Pointers are not assignment-compatible. cc: "os0thread.c", line 69: warning 563: Argument #4 is not the correct type. gmake[4]: *** [os0thread.o] Error 1 I have not yet analyzed the precise reason of the failure. Since it affects thread functions and the platform is HP-UX 10.20, I am not sure whether there is a solution at all. Best regards, Lutz -- Lutz Jaenicke [EMAIL PROTECTED] BTU Cottbus http://www.aet.TU-Cottbus.DE/personen/jaenicke/ Lehrstuhl Allgemeine Elektrotechnik Tel. +49 355 69-4129 Universitaetsplatz 3-4, D-03044 Cottbus Fax. +49 355 69-4153 - 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: am I alone? (scale)
On Saturday 10 March 2001 22:16, Justin wrote: Well thats good to know.. although this is sustained 24x7x365 linux 2.2.14-5.0smp, uptime 170 days but e2fsk ok's the the database partition, which is a mirror. in an attempt to get stability, I've been running on the official 3.22.32 mysql binary for a month now .. it hasn't helped. Typically indexes get corrupted and cause selects to malfunction, OR, cause mysqld to crash, OR cause count(*) or distinct(*) queries to run in infinite loops, but not necessarily on the corrupt table. it seems to me index corruption can poison the server beyond the afflicted table. We've had fairly bad luck with Linux 2.2.X and SMP for any kind of high-end system. The DAC 960 SCSI controllers proved to be fairly problematic in this environment. Sometimes updating the drivers helps. We have a couple of systems that run much better when we do not use one of the CPUs. If e2fsck says the partition is fine, then it might not be this problem. Best, Kyle -- Kyle Hayes Quicknet Technologies t: +1 415 864 5225 520 Townsend St. Suite D f: +1 415 864 8388 San Francisco, CA 94103 w: http://www.quicknet.net 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
Innobase released in MySQL-3.23.34a source distribution: transactions and row level locking now in MySQL
Hi, readers of the mailing list! the Innobase table handler has finally been released as a part of the MySQL-3.23.34a source distribution Tarball. Note that the Windows source distribution or the binary distributions do not contain yet Innobase. I have copied below the release note. I will post more information to my website www.innobase.fi as I get feedback and bug reports from users. --- Innobase engine released in the MySQL-3.23.34a source distribution for Unix. (Helsinki, March 12th, 2001) The Innobase engine source code has been released under the GNU GPL License 2 as a part of MySQL-3.23.34a source distribution for Unix. You can find the source distribution file from the MySQL website: http://www.mysql.com/downloads/mysql-3.23.html, look at source downloads for 3.23.34a Tarball. Innobase adds transactions, rollback, commit, row level locking, and an Oracle-style consistent non-locking read to MySQL, the popular open-source database. The combination MySQL/Innobase is probably the world's fastest disk-based relational transactional database. How to compile MySQL-3.23.34a with Innobase? After downloading, unzipping, and untarring the 'Tarball', go to the main directory of MySQL (usually named mysql-3.23.34a), and type: ./configure --with-innobase Then you have to compile and install MySQL. For information on this look at the MySQL documentation. To create tables in the Innobase format you have to first specify Innobase startup options in the my.cnf file. For instructions how to specify them, see section 8.7 of the MySQL online manual at the MySQL website. You can create tables in the Innobase format by specifying TYPE=INNOBASE after the table creation statement: CREATE TABLE t10 (a int not null, b int, primary key (a)) TYPE=INNOBASE; Questions, comments, bug reports on MySQL/Innobase: Please send your feedback on Innobase to [EMAIL PROTECTED] You can also post your feedback on the MySQL mailing lists: see the Documentation section of the MySQL website on instructions how to subscribe and post to the mailing lists. The main mailing list, simply named mysql, is the liveliest one. If you can report a repeatable bug, you can also post to the bugs mailing list. I would also like to receive reports from those who have tested Innobase, but who have no problems. It is helpful to know where the system is working well. Helsinki, March 12th, 2001 Heikki Tuuri Innobase Oy - 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
Which transaction table type to use
I was wondering what others are thinking with respect to transaction table type (BDB, Innobase, or Gemini) choices. It seems to me that if you want transaction support in MySQL, then you must pick one of the available transaction table types. And I would also assume that row level locking would be a better choice than page level locking. So which one, Innobase or Gemini? If you are doing typical finacial transactions, then either would be a reasonable choice, but I wonder which one would offer better backup/recovery options, etc. I was hoping for some guidance. Any takers? Thanks, Rick - / Rick Mehalick Senior Consultant / Shell Services International SSI-GPAX / Phone: 281-544-5092(WCK) / Fax:281-544-2646(WCK) / email: [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
Installation MySQL with Sun
Hi, This is the first time I have ever used or attempted to install my sql. I am using a Sun Ultra 5 with Salaris 5.8. I have downloaded mysql-3.23.34-sunsalaris2.7-sparc.tar.gz and have attempted to unzip this with the command: gunzip mysql-3.23.34-sunsalaris2.7-sparc.tar.gz | tar xvf - All appears to be working but after 10 seconds the process stops with the error: 691 bytes, 2 tape blocks tar: directory check sum error. Fro reading the documentation, it does state that there could be problems with Sun Salaris but what is the work around? Can anyone help? Regards Phil Phil Vamplew European Sales Engineer Kinecta Limited 1 Poultry London EC2R 8JR DirectLine:+44 (0)207 6432927 Mobile: +44 (0)7946 324 893 Kinecta Tel: +44 (0)207 6432249 Fax: +44 (0)207 6432201 Email:[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: mySQL error ?
TranceMaster wrote: I couldn't connect to mysql server, beacuse it said that user root@localhost couldn't connect (?!) but before that I did something with the grant tables, I don't remeber what? But I made one cgi that used tables, but it coonected to the mysql server as root user and a password, and it perfectly worked. Then I erased mysql directory and compiled binary version of mysql again and it said that it can't load mysql because of /tmp/mysql.sock , I am not quite sure what that is. Then I installed rpm version of mysql and I got the same message for /tmp/mysql.sock I don't know what to do now. Please help I need to install it, because I just started to practice mysql and also connecting cgi to mysql and viewing all that in browser. Thanks in advance Zoran Raskovic Most probably your mysqld is not running... -- Nothing Like the Sun - 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: from where shall I start ?
From: hanan khader [mailto:[EMAIL PROTECTED]] Sent: lunes, 12 de marzo de 2001 11:02 To: [EMAIL PROTECTED] Subject: from where shall I start ? Hello , to build a database using SQL Server, from where shall I start ? I mean, what shall I install on my Server, and how can I work with MySql ? sorry Iam How about http://www.mysql.com/documentation/index.html -- Nothing Like the Sun - 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: Installation MySQL with Sun
Phillip Vamplew wrote: Hi, This is the first time I have ever used or attempted to install my sql. I am using a Sun Ultra 5 with Salaris 5.8. I have downloaded mysql-3.23.34-sunsalaris2.7-sparc.tar.gz and have attempted to unzip this with the command: gunzip mysql-3.23.34-sunsalaris2.7-sparc.tar.gz | tar xvf - All appears to be working but after 10 seconds the process stops with the error: 691 bytes, 2 tape blocks tar: directory check sum error. Fro reading the documentation, it does state that there could be problems with Sun Salaris but what is the work around? Can anyone help? Regards Phil Phil Vamplew European Sales Engineer Kinecta Limited 1 Poultry London EC2R 8JR DirectLine:+44 (0)207 6432927 Mobile: +44 (0)7946 324 893 Kinecta Tel: +44 (0)207 6432249 Fax: +44 (0)207 6432201 Email:[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 try doing it this way. Some on the net showed me this way. it much easier i think $ tar zxvf mysql..xxx.gz see if that works with you. - 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/BUG with create table statment
Hi, I have tried to create a table with two fields. One is type CHAR and other is VARCHAR and it convert the CHAR to VARCHAR automatically. IS it a bug or i need to do some setting to work properly. I am working on WINNT machine. Sanjeev Gupta Programmer Analyst Indus Consultancy Services [EMAIL PROTECTED] 201-261-3100 x 264 - 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/BUG with create table statment
"Gupta, Sanjeev" wrote: Hi, I have tried to create a table with two fields. One is type CHAR and other is VARCHAR and it convert the CHAR to VARCHAR automatically. IS it a bug or i need to do some setting to work properly. I am working on WINNT machine. http://www.mysql.com/doc/S/i/Silent_column_changes.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
Need help with mysql startup problem
I just installed RH 7.0 selecting the 'install everything' option. Now when I use safe_mysqld, it starts then ends immediately with the following message in the log. 010310 12:43:30 mysqld started 010310 12:43:30 Can't start server : Bind on unix socket: Permission denied 010310 12:43:30 Do you already have another mysqld server running on socket: /var/lib/mysql/mysql. sock ? 010310 12:43:30 Aborting 010310 12:43:30 mysqld ended As far as I can see (using ps -ax | grep -i mysql), there is no other mysqld running, and although /var/lib/mysql/ exists with the mysql and test databases in it, there is no file named mysql.sock in it. Any help would be appreciated. Thanks in advance. Russ Heaton - 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: Installation MySQL with Sun
All appears to be working but after 10 seconds the process stops with the error: 691 bytes, 2 tape blocks tar: directory check sum error. Fro reading the documentation, it does state that there could be problems with Sun Salaris but what is the work around? The work-around is to use GNU tar, not Sun's tar. Adam -- Adam Stein @ Xerox Corporation Email: [EMAIL PROTECTED] Disclaimer: All views expressed here have been proved to be my own. [http://www.csh.rit.edu/~adam/] - 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
Installation on RH7 box
As the RPMs available on the MySQL site are built against RH6.x libraries, is there someplace where I can get versions linked against RedHat 7 libraries? RedHat themselves don't seem to have anything newer than 3.23.32 whereas I'd like to use 3.23.34. Yeah yeah, I know I should have installed RH6.2 on the box... Its a little late for that now though. Thanks! Alec - 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
Installation on RH7 box
As the RPMs available on the MySQL site are built against RH6.x libraries, is there someplace where I can get versions linked against RedHat 7 libraries? RedHat themselves don't seem to have anything newer than 3.23.32 whereas I'd like to use 3.23.34. Yeah yeah, I know I should have installed RH6.2 on the box... Its a little late for that now though. Thanks! Alec - 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: Installation on RH7 box
Well you need to look for updates on the RedHat site. There are conflicts with the new version, I believe, as I was never able to achieve a successful loading on my release 7.0 Linux box. I would say this may be a good time to contact them directly. Charles Hagen On Tue, 13 Mar 2001, Alec Smith wrote: As the RPMs available on the MySQL site are built against RH6.x libraries, is there someplace where I can get versions linked against RedHat 7 libraries? RedHat themselves don't seem to have anything newer than 3.23.32 whereas I'd like to use 3.23.34. Yeah yeah, I know I should have installed RH6.2 on the box... Its a little late for that now though. Thanks! Alec - 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 -- Charles L. Hagen Engineer Hagen IT 920-261-8499 - 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: Innobase in MySQL
Hi Rick, In my C code, I use SQL statements, but I use the mySQL C API to pass on the SQL statements, check for errors, number of rows returned, and access the results. I would assume that this will still work; they still work with BDB tables. ok, it should work like for BDB. There may be small differences when the API tells you the number of rows deleted or updated, because I have not had time to check that these numbers exactly agree for diffrent table types. Also SHOW TABLE STATUS will return different numbers, because for example the row count is only approximate in Innobase, calculated from a small sample of the table. I noticed in many list comments about others having problems with corrupt tables (MyISAM), and having to repair them. Since you don't have any such tools, can I assume that you are not having any problems with data loss or corrupt tables? I have not noticed table corruption in my own tests of Innobase since last fall. But, of course you have to take backups regularly. You should also use mysqldump to take logical (= text format file) backups of your tables. In case of table corruption you can recover from a backup using the MySQL log. The safest backup to use in recovery is the logical backup produced by mysqldump. I do not think a repair table procedure is the best way to implement safety, because neither MS SQL Server nor Oracle have such a procedure, and there is a vast user base for those databases. Recovering from a backup is a more reliable way. Remember that Innobase uses transactions and logging. From a benign server process crash it will automatically recover using the log files. Table corruption will only result from a bug in the low-level source code, or a media failure of the disk. I have crashed Innobase hundreds of times this winter during my development work, and it has always been able to revover from the log files. Regards, Heikki Thanks, Rick - 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: moving a MySQL Database
Well, My best method has been to do the following: 1. Dumb the existing database to a file: mysqldump databasename database.txt. 2. On the new machine, create the new database. create databasename 3. Copy the file (database.txt) to the new machine. 4. Type.. mysql databasename database.txt. On Sat, 10 Mar 2001, Kenneth Karen Brill wrote: How do I move a MySQL database to a new computer? - 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
BDB and transactions
After the vitriolic debates I've seen between the PostgreSQL fanatics and the MySQL defenders, I thought I'd ask for clarification on the support for transactions that's supposedly provided by the use of BDB tables: Having used Oracle for a while (and given my understanding of how transactions work there), does using BDB guarantee that: * DML that's not explicitly COMMITted will be automatically ROLLedBACK if the connection is terminated prematurely? * Other connections will continue to see a perfectly consistent snapshot of the DB from before the start of the transaction, as long as the transaction is not committed? * If the DB server process crashes in the middle of a transaction, then on restart, it will present a view of the DB without any of the effects of uncommitted transactions? And *with* all the effects of all committed transactions (needless to say)? * How about locking? While a transaction is not committed, how much of the tables that it modifies is automatically locked against updates by other connections? The whole table? A page of the table? A row (dare I hope?)? * (To labor a point) If a connection dies in the middle of a transaction holding locks, will it automatically roll them changes and free the locks and unblock any other operations waiting on that lock? Just checking.. Thanks! -- Shankar Unni[EMAIL PROTECTED] (408) 434-8311
Big Tables - New entry
Hi, Got some tips and trix from some users about big tables, -Using mysql 3.23.33 -ReadHat Linux 6.0 Kernel: 2.2.5 What I seem to must do is to get the "with-raid" to work if a going to solve my problem, MERGE will be to complicated to do when I have 11 diffrent Client prg working towards the DB and they make from 50 - 400 insert or replace per sec. So rewriting the diffrent clients into supporting MERGE will be my final solution. So anyone.. Anyone that can tell me a success story and a howto when it comes to the with-raid solution. Tried to recompile myslq 3.23.33 with the --with-raid but it dont seem to work. so... HELP /roger _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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: Problem with c-code example ...
I'm using Microsoft Visual C++ version 6.0 and Windows 2000 Professional. The manual samples works ... e.g. to run mysql and enter commandes manually Anyone ... ? /Christer Christer Holmstrm wrote: Hi! just downloaded MySQL, and compiled the c-code example located in MySQL\examples\libmysqltest It works fine for the default database called mysql ... but not for any of the other databases. Any clue? Best Regards, Christer - 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: MySQL 3.23.34a - Lost connection to MySQL server duringquery
Hi Jordan, Well... today I can't seem to reproduce the problem anymore. :/ I was getting it very frequently yesterday (on almost every try). I'm not sure what has changed since then. I'll let you know if the problem happens again and try to narrow down the exact steps to reproduce. Is it possible that you had a replicated system running, where the master was your updated 3.23.34 and a slave still had 3.23.33 running? - The same happened to me last night after I updated one of my masters to 3.23.34, but still left the slave running 3.23.33 for later updating. After several operations running locally on the new master's version, the same error occured. It immediately disappeared after I upgraded the slave to 3.23.34 too. Never saw it again. Maybe only coincidence, but... who knows. Regards ... Ralph ... - 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: Innobase in MySQL
Rick, Everything you wrote sounds good, except for one thing. I use the result count from a select or delete for logical branching within my code. I.e. I perform a select and if rowcount is zero, then I can do an update. That is a problem. Any thoughts? The basic rowcount functionality should work ok, because the mysql client returns right values when I do SELECTs, UPDATEs, INSERTs, or DELETEs. What I meant was that small differences between table types may occur if you receive, for example, a duplicate key error when you do an insert of a set of rows, or a transaction deadlock which results in a rollback. We have to test these special cases and check that they return the same (sensible) values for all table types. Thus, if you get an error from your SQL statement, currently you have to be extra careful to check what the rowcount returned really means. I looked at the MySQL manual section 7.21 and found the following: If you specify the keyword IGNORE in an INSERT with many value rows, any rows that duplicate an existing PRIMARY or UNIQUE key in the table are ignored and are not inserted. If you do not specify IGNORE, the insert is aborted if there is any row that duplicates an existing key value. You can determine with the C API function mysql_info() how many rows were inserted into the table. But when I tested with Innobase and MyISAM tables, I noticed that MySQL seems to assume the IGNORE option for all INSERTS, for both table types. On the other hand, ANSI SQL specifies that a duplicate key error should result in the rollback of the whole SQL statement, i.e., no rows should be inserted. The conclusion is that you should not rely on the current behavior if the SQL statement returns an error. The error handling procedure is likely to change. Regards, Heikki - 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 3.23.34a - Lost connection to MySQL server during query
Well... today I can't seem to reproduce the problem anymore. :/ I was getting it very frequently yesterday (on almost every try). I'm not sure what has changed since then. I'll let you know if the problem happens again and try to narrow down the exact steps to reproduce. Is it possible that you had a replicated system running, where the master was your updated 3.23.34 and a slave still had 3.23.33 running? - The same happened to me last night after I updated one of my masters to 3.23.34, but still left the slave running 3.23.33 for later updating. After several operations running locally on the new master's version, the same error occured. It immediately disappeared after I upgraded the slave to 3.23.34 too. Never saw it again. Hmm, I'm not using replication, but possibly some piece of the old server was still running(?). I didn't ensure the old server was stopped before I upgraded the RPM... Jordan Russell - 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
Need help optimizing this (simple) query
Hi everyone, I'm stuck on one issue which is preventing me from using MySQL in production on one particular database. (This is similar to my last post but this time I'll explain better what I'm attempting to do.) I'm trying to create a database of filenames and directories using MySQL. I have two tables -- "files" which holds the names dates of files, and "dirs" which holds directory names. Say I want to obtain the ID of the newest file. I execute: mysql SELECT id FROM files ORDER BY date DESC LIMIT 1; +--+ | id | +--+ | 2736 | +--+ 1 row in set (0.00 sec) Good so far. Now, I want to do the same thing, but also list the directory name which the file resides in. So I execute: mysql SELECT files.id, dirs.name FROM files - LEFT JOIN dirs ON files.dir_id=dirs.id - ORDER BY files.date DESC LIMIT 1; +--+---+ | id | name | +--+---+ | 2736 | Folder145 | +--+---+ 1 row in set (0.03 sec) Notice this query takes 0.03 sec to execute vs. 0.00 for the first one... Why the huge difference in time? It's still a one-row query! Could someone please explain this analomy? Is it normal for SELECT queries that include a LEFT JOIN to be *that* slow? Surely it can't be(?). I've read over the optimization section documentation countless times and I'm still stumped. Here are my table specs: /* This table has 500 rows */ CREATE TABLE dirs ( id int(11) NOT NULL auto_increment, name varchar(100) NOT NULL default '', PRIMARY KEY (id) ) TYPE=MyISAM; /* This table has 5000 rows */ CREATE TABLE files ( id int(11) NOT NULL auto_increment, dir_id int(11) NOT NULL default '0', name varchar(100) NOT NULL default '', date datetime default NULL, PRIMARY KEY (id), KEY date (date) ) TYPE=MyISAM; The output of EXPLAIN SELECT is rather puzzling to me. Why doesn't it use the "date" key on the second query? It seems like it would be much much faster if it did. mysql EXPLAIN SELECT id FROM files ORDER BY date DESC LIMIT 1; +---+---+---+--+-+--+--+---+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +---+---+---+--+-+--+--+---+ | files | index | NULL | date | 9 | NULL | 5000 | | +---+---+---+--+-+--+--+---+ mysql EXPLAIN SELECT files.id, dirs.name FROM files - LEFT JOIN dirs ON files.dir_id=dirs.id - ORDER BY files.date DESC LIMIT 1; +---++---+-+-+--+--+ + | table | type | possible_keys | key | key_len | ref | rows | Extra | +---++---+-+-+--+--+ + | files | ALL| NULL | NULL|NULL | NULL | 5000 | Using filesort | | dirs | eq_ref | PRIMARY | PRIMARY | 4 | files.dir_id |1 | | +---++---+-+-+--+--+ + Thanks very much in advance for any assistance. Jordan Russell - 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: Memory problems/bug ?
-Original Message- From: Nemholt, Jesper Frank Sent: viernes, 09 de marzo de 2001 19:52 To: '[EMAIL PROTECTED]' Subject: Memory problems/bug ? Hej! Using MySQL 3.22.32 on Tru64 4.0F patchkit 4. Compiled with Compaq CC. Ran optimize on a table, and after 10 minutes : 010307 17:00:00 Out of memory; Check if mysqld or some other process uses all available memory. If not you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space mysqld ended on Wed Mar 7 17:00:21 MET 2001 One other question about this error : If I try out the latest stable version, will I be able to use the 3.22.32 database files directly, or should I rather dump the existing and import them to the new ? I'd ofcourse still like some answers regarding my original question... -- 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: Need help optimizing this (simple) query
A .03 sec left join PREVENTS you from using MySQL. This must be a troll. You have no where clause, so no index is used. Jordan Russell wrote: Hi everyone, I'm stuck on one issue which is preventing me from using MySQL in production on one particular database. (This is similar to my last post but this time I'll explain better what I'm attempting to do.) I'm trying to create a database of filenames and directories using MySQL. I have two tables -- "files" which holds the names dates of files, and "dirs" which holds directory names. Say I want to obtain the ID of the newest file. I execute: mysql SELECT id FROM files ORDER BY date DESC LIMIT 1; +--+ | id | +--+ | 2736 | +--+ 1 row in set (0.00 sec) Good so far. Now, I want to do the same thing, but also list the directory name which the file resides in. So I execute: mysql SELECT files.id, dirs.name FROM files - LEFT JOIN dirs ON files.dir_id=dirs.id - ORDER BY files.date DESC LIMIT 1; +--+---+ | id | name | +--+---+ | 2736 | Folder145 | +--+---+ 1 row in set (0.03 sec) Notice this query takes 0.03 sec to execute vs. 0.00 for the first one... Why the huge difference in time? It's still a one-row query! Could someone please explain this analomy? Is it normal for SELECT queries that include a LEFT JOIN to be *that* slow? Surely it can't be(?). I've read over the optimization section documentation countless times and I'm still stumped. Here are my table specs: /* This table has 500 rows */ CREATE TABLE dirs ( id int(11) NOT NULL auto_increment, name varchar(100) NOT NULL default '', PRIMARY KEY (id) ) TYPE=MyISAM; /* This table has 5000 rows */ CREATE TABLE files ( id int(11) NOT NULL auto_increment, dir_id int(11) NOT NULL default '0', name varchar(100) NOT NULL default '', date datetime default NULL, PRIMARY KEY (id), KEY date (date) ) TYPE=MyISAM; The output of EXPLAIN SELECT is rather puzzling to me. Why doesn't it use the "date" key on the second query? It seems like it would be much much faster if it did. mysql EXPLAIN SELECT id FROM files ORDER BY date DESC LIMIT 1; +---+---+---+--+-+--+--+---+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +---+---+---+--+-+--+--+---+ | files | index | NULL | date | 9 | NULL | 5000 | | +---+---+---+--+-+--+--+---+ mysql EXPLAIN SELECT files.id, dirs.name FROM files - LEFT JOIN dirs ON files.dir_id=dirs.id - ORDER BY files.date DESC LIMIT 1; +---++---+-+-+--+--+ + | table | type | possible_keys | key | key_len | ref | rows | Extra | +---++---+-+-+--+--+ + | files | ALL| NULL | NULL|NULL | NULL | 5000 | Using filesort | | dirs | eq_ref | PRIMARY | PRIMARY | 4 | files.dir_id |1 | | +---++---+-+-+--+--+ + Thanks very much in advance for any assistance. Jordan Russell - 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: Need help optimizing this (simple) query
A .03 sec left join PREVENTS you from using MySQL. This must be a troll. Sigh... I guess I failed to mention this was a deliberately simplified example in order to pose my question in a easy-to-understand manner. In reality, there are much more records, and a more complex query, where the time does add up... My real question is, why does MySQL not use any index to sort when LEFT JOIN is used. (Refer to the EXPLAIN SELECT output at the end of my message.) Jordan Russell - 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: Need help optimizing this (simple) query
You have no where clause, so no index is used. Oops, missed this part. Where exactly do I need a WHERE clause, and for what? The first query doesn't have a WHERE clause and yet it appears to be using the "date" index. Jordan Russell - 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 can't understand
Hello, I have updated my mysql server from version 3.22.25 to 3.23.33. I've noticed that the same query's output I've run in the old version differs from the new version's. Eg. I've got a film database: SELECT COUNT(*) FROM FILM; returns me a number of 53. The same select with a WHERE COMMENT="deleted" clause returns 5. With "WHERE COMMENT!="deleted" " it returns 18. Normally, one would assume that #"deleted"+#"!deleted" makes 53 but it doesn't. I've seen that there were some modifications in 3.23.26 affecting mysql's behavior concerning NULL value. My question is that this new behavior is the the desired or the old one? Please CC me, i'm not on the list. sorry. Bye: PP. - 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: Need help optimizing this (simple) query
Hi, Thanks for the reply. Hve you read http://www.mysql.com/documentation/mysql/bychapter/manual_Performance.html#L EFT_JOIN_optimization ? Yes, many times, as well as just about everything else in the Performance chapter. Am I missing something totally obvious? Should I even be using a LEFT JOIN for my purpose? Any why does using two separate queries execute much faster than one query? 0.03 sec: SELECT files.id, dirs.name FROM files LEFT JOIN dirs ON files.dir_id=dirs.id ORDER BY files.date DESC LIMIT 1; 0.00 sec + 0.00 sec: SELECT id, dir_id FROM files ORDER BY date DESC LIMIT 1; SELECT name FROM dirs WHERE id=dir_id from last query; Later I want to use a LIMIT of 100 or more so I don't think using the multiple queries will be an option then... Jordan Russell - 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: I can't understand
And SELECT COUNT(*) FROM FILM WHERE COMMENT IS NULL: returns what? "P.Peti" wrote: Hello, I have updated my mysql server from version 3.22.25 to 3.23.33. I've noticed that the same query's output I've run in the old version differs from the new version's. Eg. I've got a film database: SELECT COUNT(*) FROM FILM; returns me a number of 53. The same select with a WHERE COMMENT="deleted" clause returns 5. With "WHERE COMMENT!="deleted" " it returns 18. Normally, one would assume that #"deleted"+#"!deleted" makes 53 but it doesn't. I've seen that there were some modifications in 3.23.26 affecting mysql's behavior concerning NULL value. My question is that this new behavior is the the desired or the old one? Please CC me, i'm not on the list. sorry. Bye: PP. - 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
Adding additional information to table strucure records
I don't know if this list still gets read by the staff TcX or not, but I
have this suggestion:
1/ For those of us willing to code the glue logic to make triggers,
constraints, and foreign keys work, it would be VERY helpful if ALL the
commands that are exercised on a table at creation or modification time
were available upon a structure dump, (which I don't know the syntax of
yet.
This means ONLY the current status, NOT a history.
Sooo, I could query the structure of table, find a foreign key,
and if I needed to modify the table, I could enforce referential
integrity with objects/code in PHP/ASP/Cpp/C#/Perl or whatever.
It's be a boon to those of us willing to supply the full glue logic that
MySQL needs at this point, and for xferring to some other database like
insert the 'Big-O' word here down the road.
An example:
CREATE TABLE ControllerRoomAssignments(
ControllerID INT UNSIGNED NOT NULL,
PurvineRoomID INT UNSIGNED NOT NULL,
HasThermostat ENUM ('true','false') DEFAULT 'false' NOT NULL,
FOREIGN KEY (ControllerID) REFERENCES PurvineHVACSupplyControllers
(ControllerID),
FOREIGN KEY (PurvineRoomID) REFERENCES PurvineRooms (PurvineRoomID),
PRIMARY KEY (ControllerID,PurvineRoomID),
INDEX IDX_ControllerRoomAssignments_1 (ControllerID,PurvineRoomID));
The two foreign keys are ignored, FINE, no problem, but it's be nice if
it stayed as
part of the structure dump of the table. (or, if some commandline switch
when mysql is invoked would allow this or not, or if there was a 'SET
--store-full-table-structue-- MyDataBase' command available as for
particular database.
For the first FOREIGN KEY, I could find:
'PurvineHVACSupplyControllers(ControllerID)'
and make sure that
-
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: Need help optimizing this (simple) query
Everything I've seen on this list indicates that using LEFT JOIN negates using an index. (WARNING: This is 3rd hand info and as such should be viewed skeptically!) Have you tried: SELECT files.id, dirs.name FROM files where files.dir_id=dirs.id ORDER BY files.date DESC LIMIT 1; If so, what were your results? Cal http://www.calevans.com -Original Message- From: Jordan Russell [mailto:[EMAIL PROTECTED]] Sent: Monday, March 12, 2001 2:27 PM To: Cal Evans Cc: [EMAIL PROTECTED] Subject: Re: Need help optimizing this (simple) query Hi, Thanks for the reply. Hve you read http://www.mysql.com/documentation/mysql/bychapter/manual_Performance.html#L EFT_JOIN_optimization ? Yes, many times, as well as just about everything else in the Performance chapter. Am I missing something totally obvious? Should I even be using a LEFT JOIN for my purpose? Any why does using two separate queries execute much faster than one query? 0.03 sec: SELECT files.id, dirs.name FROM files LEFT JOIN dirs ON files.dir_id=dirs.id ORDER BY files.date DESC LIMIT 1; 0.00 sec + 0.00 sec: SELECT id, dir_id FROM files ORDER BY date DESC LIMIT 1; SELECT name FROM dirs WHERE id=dir_id from last query; Later I want to use a LIMIT of 100 or more so I don't think using the multiple queries will be an option then... Jordan Russell - 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: Need help optimizing this (simple) query
Everything I've seen on this list indicates that using LEFT JOIN negates using an index. (WARNING: This is 3rd hand info and as such should be viewed skeptically!) Have you tried: SELECT files.id, dirs.name FROM files where files.dir_id=dirs.id ORDER BY files.date DESC LIMIT 1; If so, what were your results? Thanks.. I had to add ", dirs" for that to work: SELECT files.id, dirs.name FROM files, dirs where files.dir_id=dirs.id ORDER BY files.date DESC LIMIT 1; But unfortunately the results were exactly the same: 0.03 sec query time, and EXPLAIN SELECT showed the same output as when I used a LEFT JOIN -- no index, and "using filesort." I also tried adding "USE INDEX", but still the exact same results: SELECT files.id, dirs.name FROM files USE INDEX (date), dirs where files.dir_id=dirs.id ORDER BY files.date DESC LIMIT 1; And I tried reversing the column/table order; that didn't help either: SELECT dirs.name, files.id FROM dirs, files where dirs.id=files.dir_id ORDER BY files.date DESC LIMIT 1; Jordan Russell - 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: Need help optimizing this (simple) query
/* This table has 5000 rows */ CREATE TABLE files ( id int(11) NOT NULL auto_increment, dir_id int(11) NOT NULL default '0', name varchar(100) NOT NULL default '', date datetime default NULL, PRIMARY KEY (id), KEY date (date) ) TYPE=MyISAM; for grins and giggles, add: key dir_id(dir_id), to the above. Cal http://www.calevans.com -Original Message- From: Jordan Russell [mailto:[EMAIL PROTECTED]] Sent: Monday, March 12, 2001 2:48 PM To: Cal Evans Cc: [EMAIL PROTECTED] Subject: Re: Need help optimizing this (simple) query Everything I've seen on this list indicates that using LEFT JOIN negates using an index. (WARNING: This is 3rd hand info and as such should be viewed skeptically!) Have you tried: SELECT files.id, dirs.name FROM files where files.dir_id=dirs.id ORDER BY files.date DESC LIMIT 1; If so, what were your results? Thanks.. I had to add ", dirs" for that to work: SELECT files.id, dirs.name FROM files, dirs where files.dir_id=dirs.id ORDER BY files.date DESC LIMIT 1; But unfortunately the results were exactly the same: 0.03 sec query time, and EXPLAIN SELECT showed the same output as when I used a LEFT JOIN -- no index, and "using filesort." I also tried adding "USE INDEX", but still the exact same results: SELECT files.id, dirs.name FROM files USE INDEX (date), dirs where files.dir_id=dirs.id ORDER BY files.date DESC LIMIT 1; And I tried reversing the column/table order; that didn't help either: SELECT dirs.name, files.id FROM dirs, files where dirs.id=files.dir_id ORDER BY files.date DESC LIMIT 1; Jordan Russell - 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: Need help optimizing this (simple) query
Jordan Russell wrote: Everything I've seen on this list indicates that using LEFT JOIN negates using an index. (WARNING: This is 3rd hand info and as such should be viewed skeptically!) Have you tried: SELECT files.id, dirs.name FROM files where files.dir_id=dirs.id ORDER BY files.date DESC LIMIT 1; If so, what were your results? Thanks.. I had to add ", dirs" for that to work: SELECT files.id, dirs.name FROM files, dirs where files.dir_id=dirs.id ORDER BY files.date DESC LIMIT 1; But unfortunately the results were exactly the same: 0.03 sec query time, and EXPLAIN SELECT showed the same output as when I used a LEFT JOIN -- no index, and "using filesort." I also tried adding "USE INDEX", but still the exact same results: SELECT files.id, dirs.name FROM files USE INDEX (date), dirs where files.dir_id=dirs.id ORDER BY files.date DESC LIMIT 1; And I tried reversing the column/table order; that didn't help either: SELECT dirs.name, files.id FROM dirs, files where dirs.id=files.dir_id ORDER BY files.date DESC LIMIT 1; Jordan Russell Do you have an index on files that starts with dir_id and an index on dirs that stats with id and having date in the files index (after dir_id) might be helpful although I'm not sure. you could provide the output of show keys from files; show keys from dirs; it would be helpful.. - 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: Need help optimizing this (simple) query
/* This table has 5000 rows */ CREATE TABLE files ( id int(11) NOT NULL auto_increment, dir_id int(11) NOT NULL default '0', name varchar(100) NOT NULL default '', date datetime default NULL, PRIMARY KEY (id), KEY date (date) ) TYPE=MyISAM; for grins and giggles, add: key dir_id(dir_id), to the above. That didn't change anything in this query (same query time, same EXPLAIN output): SELECT files.id, dirs.name FROM files LEFT JOIN dirs ON files.dir_id=dirs.id ORDER BY files.date DESC LIMIT 1; But it actually made this query slower -- 0.07 sec instead of 0.03! SELECT files.id, dirs.name FROM files, dirs where files.dir_id=dirs.id ORDER BY files.date DESC LIMIT 1; Jordan Russell - 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
Distributed Transaction Processing
Has anyone contemplated using MySQL for DTP through a cluster of machines where the transactions are related to critical financial transactions. For example, in a commerce situation where a customer withdraws from one account and deposits into another, DTP ensures that all computers commit concurrently and if any one is not able to, then none commits. regards Martin Cameron - 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: getting frequent signal 11 after upgrade from 3.23.28 to 3.23.34
FYI, This problem got worse as more users began using the system. I had to revert back to 3.23.28, which did solve the problem. I'm sorry that I didn't come up with a reproducible test case. As near as I could tell it seemed to be intermittent in nature. Things would work, then not work. I had a couple hours where there were zero server crashes, but in the last hour the crashes were continuous so I had to revert. My system is a fairly complicate dynamic website, so it's hard to narrow things down on the live site. I'll try to reproduce it on my test system, but it's hard to simulate the same levels of load (so far, I have no luck reproducing it there). -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: I can't understand
Hello, And SELECT COUNT(*) FROM FILM WHERE COMMENT IS NULL: returns what? Sure, I forgot to mention that I know it's all about the NULL values, i can correct the "problem" (maybe not a problem but I think it's a weird behavior) i just don't understand why? The query you mentioned returns 35, added to #"!deleted" equals the total row count. It just seems to be weird that a subset and its complement does not equal the whole table. So the thing is: #"!deleted" doesn't include "#NULL" as the set filtered by the clause 'WHERE comment!="deleted"' doesn't include NULL value comments. This is what I don't understand. Bye: PP. - 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: Reinstallation HANG
"Weber, Jeff" wrote: Mysql is hanging when started on my Linux box (Red Hat Linux release 6.2 (Zoot) Kernel 2.2.14-5.0 on an i686 -- mysqld, Version: 3.23.21), so I thought I would reinstall mysql_install_db. This hangs too, see below... [root@myserver mysql]# mysql_install_db Creating func table Creating tables_priv table Creating columns_priv table Server doesn't come back after this, I have to kill -9 to stop it. Anyone have any idea why the install would hang this quickly? Thanks, Jeff You should have run mysql_install_db --user=mysql Now the database directory and all the files are probably owned by root, and mysqld can't read the directory. chown -R mysql /var/mysql/data replacing "/var/mysql/data" with actual mysql database directory. - 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 2013
I recently moved to a new server, and successfully copied the database over to the new server. However, at least half of my queries are returning the error: ERROR 2013: Lost connection to MySQL server during query The error seems to be random, and only with longer queries. I'm guessing this is one of the server variables. Can someone please tell me which one it is, so I can fix it? 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
migration question
Hi, What would be the workaround for migration from linux redhat 6.2 with mysql 3.23 to windows 2000 with mysql. I have a database dump in mysql 3.23 for linux. Merci, Jean-Francois Duckett [EMAIL PROTECTED] 514.281.0905 - See the world, Set the price - www.thedailyauction.com
Re: I can't understand
"P.Peti" wrote: Hello, And SELECT COUNT(*) FROM FILM WHERE COMMENT IS NULL: returns what? Sure, I forgot to mention that I know it's all about the NULL values, i can correct the "problem" (maybe not a problem but I think it's a weird behavior) i just don't understand why? The query you mentioned returns 35, added to #"!deleted" equals the total row count. It just seems to be weird that a subset and its complement does not equal the whole table. So the thing is: #"!deleted" doesn't include "#NULL" as the set filtered by the clause 'WHERE comment!="deleted"' doesn't include NULL value comments. This is what I don't understand. Bye: PP. 1. Read the manual. 2. Take a course in database design, or read a good SQL book. "MySQL" by DuBois ( New Riders) is a good one. 3. This is pretty basic SQL stuff, and is correct. This is NOT a "problem" as you described it. When you don't specify NOT NULL when creating the column, you have to program for the NULL or "Unknown value" which is neither equal to or not equal to any value. It isn't even equal to NULL. It "IS NULL." Everything else "IS NOT NULL." - 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
Access and MySQL
This join works perfectly in Access but if I use the same query in MySQL it shits it's pants. SELECT tbl_medien.titel, tbl_medien.ausgabe, tbl_medien.URL, tbl_medien.medientypID, tbl_autor.name, tbl_autor.vorname FROM tbl_medien INNER JOIN (tbl_autor INNER JOIN tbl_zuordnung_autoren_medien ON tbl_autor.autorenID=tbl_zuordnung_autoren_medien.autorenID) ON tbl_medien.medienID=tbl_zuordnung_autoren_medien.medienID WHERE (((tbl_medien.medientypID)='$medium')) Thanks, Patrick Patrick Schfer magna moliri Projektmanagementgesellschaft mbH Co.KG Hanauer Landstrae 184 60314 Frankfurt am Main Telefon ++49 (0)69 / 904 322-0 Mobil ++49 (0)171 / 9928016 Fax ++49 (0)69 / 904 322-200 [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
how to create stroed procedure in mysql
Sanjeev Gupta Programmer Analyst Indus Consultancy Services [EMAIL PROTECTED] 201-261-3100 x 264 - 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[2]: I can't understand
Hello P.Peti, Monday, March 12, 2001, 11:17:16 PM, you wrote: PP It just seems to be weird that a subset and its complement PP does not equal the whole table. So the thing is: PP #"!deleted" doesn't include "#NULL" as the set filtered by PP the clause 'WHERE comment!="deleted"' doesn't include NULL PP value comments. This is what I don't understand. NULL is NULL. You can't check it by comparison, the only way to get null is to use IS NULL. It is important to understand what NULL values ara and how to deal with them in SQL. Regards, ic - 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
msyql_install_db hangs with three mysqld processes
From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: mysql_install_db hanging with three mysqld processes Description: I sent a mail last week with a problem with mysql_install_db hanging. I have followed all of the advice from previous posts with no luck. I have noticed that my situation is different since I have three mysqld processes being started. No one else has mentioned that. They are children of the previous one. I have tried a binary rpm, a source rpm and these binaries. Hopefully someone has an idea. Thanks! Submitter-Id: submitter ID Originator:Josh Lucas Organization: MySQL support: none Synopsis: mysql_install_db hangs with three mysqld processes Severity: critical Priority: high Category: mysql Class: sw-bug Release: mysql-3.23.34 (Official MySQL binary) Environment: machine, os, target, libraries (multiple lines) System: Linux fidel.diarylog.org 2.2.17-14 #1 Mon Feb 5 17:53:36 EST 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/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS='-O6 -mpentium ' CXX='gcc' CXXFLAGS='-O6 -mpentium -felide-constructors' LDFLAGS='-static' LIBC: lrwxrwxrwx1 root root 13 Oct 3 07:55 /lib/libc.so.6 - libc-2.1.3.so -rwxr-xr-x1 root root 4106508 Mar 9 22:08 /lib/libc-2.1.3.so -rw-r--r--1 root root 20309704 Mar 9 22:07 /usr/lib/libc.a -rw-r--r--1 root root 178 Mar 9 22:08 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --enable-assembler --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --disable-shared Perl: This is perl, version 5.005_03 built for i386-linux - 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: Need help optimizing this (simple) query
Jordan, Ok, I'm out of ideas. The additional index should have sped things up, not slowed them down. I've got some tables with 26,000 rows in it and I do 4 joins (using a WHERE clause) with smaller tables without a hitch. Sorry I can't help. Cal http://www.calevans.com -Original Message- From: Jordan Russell [mailto:[EMAIL PROTECTED]] Sent: Monday, March 12, 2001 3:07 PM To: Steve Ruby Cc: Cal Evans; [EMAIL PROTECTED] Subject: Re: Need help optimizing this (simple) query Do you have an index on files that starts with dir_id and an index on dirs that stats with id and having date in the files index (after dir_id) might be helpful although I'm not sure. Sorry, I don't understand exactly what you mean, but... you could provide the output of show keys from files; show keys from dirs; it would be helpful.. ...Here's the output of those queries (please pardon the word wrap): mysql show keys from dirs; +---++--+--+-+---+-- ---+--++-+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Comment | +---++--+--+-+---+-- ---+--++-+ | dirs | 0 | PRIMARY |1 | id | A | 500 | NULL | NULL | | +---++--+--+-+---+-- ---+--++-+ mysql show keys from files; +---++--+--+-+---+-- ---+--++-+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Comment | +---++--+--+-+---+-- ---+--++-+ | files | 0 | PRIMARY |1 | id | A | 5000 | NULL | NULL | | | files | 1 | date |1 | date| A | 5000 | NULL | NULL | | +---++--+--+-+---+-- ---+--++-+ Adding an index for dir_id on files did not help (see my other post). Jordan Russell - 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
mysqlbug may pick the wrong complier
Description: The code that checks for cc may pick the "first" cc it finds in its path, which may not be the same cc used for compling, eg it may choose /usr/bin/gcc over /usr/local/bin/gcc How-To-Repeat: Look in the code for mysqlbug Fix: Ah this depends on finding the complier used for compling, maybe a makefile addition to add the path / CC used. Submitter-Id: submitter ID Originator:root (aka greg) Organization: Never ! MySQL support: [none ] Synopsis: mysqlbug may pick the wrong complier Severity: Priority: Category: mysql Class: Release: mysql-3.23.34a (Source distribution) Server: /usr/local/mysql/bin/mysqladmin Ver 8.18 Distrib 3.23.34a, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.34a-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 9 min 46 sec Threads: 2 Questions: 9 Slow queries: 0 Opens: 7 Flush tables: 1 Open tables: 1 Queries per second avg: 0.015 Environment: System: Linux duck.webarmadillo.com 2.4.2-ac18 #1 Sun Mar 11 21:09:43 GMT 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/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) ^^ This is wrong for my system. I actually used: Reading specs from /usr/local/lib/gcc-lib/i686-pc-linux-gnu/pgcc-2.95.2.1/specs gcc version pgcc-2.95.2.1 20001224 (release) Compilation info: CC='/usr/local/bin/gcc' CFLAGS='-O6 -mpentiumpro -mstack-align-double' CXX='/usr/local/bin/gcc' CXXFLAGS='-O6 -mpentiumpro -mstack-align-double -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 May 21 2000 /lib/libc.so.6 - libc-2.1.3.so -rwxr-xr-x1 root root 4101836 Jan 15 15:49 /lib/libc-2.1.3.so -rw-r--r--1 root root 20273324 Jan 15 15:49 /usr/lib/libc.a -rw-r--r--1 root root 178 Jan 15 15:49 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql-3.23.34a --with-mysqld-ldflags=-all-static --with-mysqld-user=mysql --without-debug --with-berkeley-db --with-innobase --without-bench --datadir=/var/lib/mysql --localstatedir=/var/lib/mysql --sysconfdir=/etc --infodir=/usr/local/info --mandir=/usr/local/man --enable-assembler --with-libwrap Perl: This is perl, version 5.005_03 built for i386-linux - 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: Reinstallation HANG
What is your swap size? What is your drive space? It sounds like you need to upgrade to their latest. Did you load all the updates on your 6.2 box? Charles Hagen On Mon, 12 Mar 2001, Weber, Jeff wrote: Mysql is hanging when started on my Linux box (Red Hat Linux release 6.2 (Zoot) Kernel 2.2.14-5.0 on an i686 -- mysqld, Version: 3.23.21), so I thought I would reinstall mysql_install_db. This hangs too, see below... [root@myserver mysql]# mysql_install_db Creating func table Creating tables_priv table Creating columns_priv table Server doesn't come back after this, I have to kill -9 to stop it. Anyone have any idea why the install would hang this quickly? Thanks, Jeff - 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 -- Charles L. Hagen Engineer Hagen IT 920-261-8499 - 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
show tables bug - minor update
Dear All The following C and CXX flags will work (/usr/local/bin/gcc is actually pgcc). Reading specs from /usr/local/lib/gcc-lib/i686-pc-linux-gnu/pgcc-2.95.2.1/specs gcc version pgcc-2.95.2.1 20001224 (release). CC='/usr/local/bin/gcc' CFLAGS='-O6 -mpentiumpro -mstack-align-double' CXX='/usr/local/bin/gcc' CXXFLAGS='-O6 -mpentiumpro -mstack-align-double -felide-constructors -fno-exceptions -fno-rtti' This results in a decent binary. C and CXX flags that are blank give an ok binary with gcc (default redhat:) Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release). Now all I need to do is find some Ok flags for egc ! regards Greg - 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't run successful configure on SunOS 5.8
Platform: SunOS 5.8
MySQL Version: 3.23.33 Source distribution not binaries.
gcc version: 2.95.2
Problem: Getting some fatal compiler errors when I run configure. Not sure what to do
about it.
Any and all help is appreciated. I've tried using this lists archived email for an
answer, but all attempts to run configure produce the same errors. I suspect I'm just
not fully understanding what I read, so if it could be stated to me again that might
help. Prior to each time I ran configure, I made sure I performed an rm config.cache
and then a make clean.
I ran configure in the following manner:
CFLAGS="-O6" CXX=gcc CXXFLAGS="-O6 -felide-constructors -fno-exceptions -fno-rtti"
./configure --prefix=~nelson/mysql/mysql-3.23.33/mysql_client \
--with-low-memory --without-server \
--enable-assembler --with-mysqld-ldflags=-all-static
Here is the first part of the config.log. It is too large to post on this list. If
you'd like to look at the rest I can email you separately. There are too many "fatal"
errors for me to believe that "make" will run error free. Errors having to do with
"select.h", "vadvise.h", "gethostbyname_r", "setsockopt", etc. Thanks for any and all
help.
This file contains any messages produced by compilers while
running configure, to aid debugging if configure makes a mistake.
configure:796: checking host system type
configure:817: checking target system type
configure:835: checking build system type
configure:870: checking for a BSD compatible install
configure:923: checking whether build environment is sane
configure:958: checking whether make sets ${MAKE}
configure:1004: checking for working aclocal
configure:1017: checking for working autoconf
configure:1030: checking for working automake
configure:1043: checking for working autoheader
configure:1056: checking for working makeinfo
configure:1158: checking whether to enable maintainer-specific portions of Makefiles
configure:1200: checking whether build environment is sane
configure:1217: checking whether make sets ${MAKE}
configure:1285: checking for gawk
configure:1285: checking for mawk
configure:1285: checking for nawk
configure:1317: checking for gcc
configure:1430: checking whether the C compiler (gcc -O6 ) works
configure:1446: gcc -o conftest -O6conftest.c 15
configure:1472: checking whether the C compiler (gcc -O6 ) is a cross-compiler
configure:1477: checking whether we are using GNU C
configure:1486: gcc -E conftest.c
configure:1505: checking whether gcc accepts -g
configure:1541: checking for c++
configure:1573: checking whether the C++ compiler (gcc -O6 -felide-constructors
-fno-exceptions -fno-rtti ) works
configure:1589: gcc -o conftest -O6 -felide-constructors -fno-exceptions -fno-rtti
conftest.C 15
configure:1615: checking whether the C++ compiler (gcc -O6 -felide-constructors
-fno-exceptions -fno-rtti ) is a cross-compiler
configure:1620: checking whether we are using GNU C++
configure:1629: gcc -E conftest.C
configure:1648: checking whether gcc accepts -g
configure:1680: checking how to run the C preprocessor
configure:1701: gcc -E conftest.c /dev/null 2conftest.out
configure:1805: checking for ranlib
configure:1915: checking for ld used by GCC
configure:1977: checking if the linker (/usr/ccs/bin/ld) is GNU ld
configure:1993: checking for BSD-compatible nm
configure:2029: checking whether ln -s works
ltconfig:603: checking for object suffix
ltconfig:604: gcc -c -O6 conftest.c 15
ltconfig:629: checking for executable suffix
ltconfig:630: gcc -o conftest -O6conftest.c 15
ltconfig:776: checking if gcc PIC flag -fPIC works
ltconfig:777: gcc -c -O6 -fPIC -DPIC conftest.c 15
ltconfig:829: checking if gcc supports -c -o file.o
ltconfig:830: gcc -c -O6 -o out/conftest2.o conftest.c 15
ltconfig:862: checking if gcc supports -c -o file.lo
ltconfig:863: gcc -c -O6 -c -o conftest.lo conftest.c 15
ltconfig:914: checking if gcc supports -fno-rtti -fno-exceptions
ltconfig:915: gcc -c -O6 -fno-rtti -fno-exceptions -c conftest.c conftest.c 15
ltconfig:958: checking if gcc static flag -static works
ltconfig:959: gcc -o conftest -O6-static conftest.c 15
ltconfig:1653: checking if global_symbol_pipe works
ltconfig:1654: gcc -c -O6 conftest.c 15
ltconfig:1657: eval "/usr/ccs/bin/nm -p conftest.o | sed -n -e 's/^.*[ ]\([BDT]\)[
][ ]*\(\)\([_A-Za-z][_A-Za-z0-9]*\)$/\1 \2\3 \3/p' conftest.nm"
ltconfig:1709: gcc -o conftest -O6 -fno-builtin -fno-rtti -fno-exceptions
conftest.c conftstm.o 15
configure:2234: checking for a BSD compatible install
configure:2292: checking for bison
configure:2325: checking for pdftex
configure:2353: checking return type of sprintf
configure:2374: gcc -o conftest -O6conftest.c 15
configure:2438: checking for uname
configure:2475: checking operating system
configure:2633: checking if we should use skip-locking as default for solaris2.8
configure:2651: checking for ln
configure:2688: checking for ln
configure:2729: checking for mv
configure:2765:
Re: Flags problem 3.23.34a with BDB support/Innobase on HP-UX 10.20
Lutz, what compiler are you using? GCC? HP:s own commercial compiler, I assume. I am currently trying to compile 3.23.34a coming with BDB support. I have zlib installed in the /usr/local (not normally searched for libraries), so that until now I have [CFLAGS etc ] LDFLAGS=-L/usr/local/lib ./configure BTW, the compilation of innobase fails with cc -DHAVE_CONFIG_H -I. -I. -I.. -I../../include -I../include -DHPUX -Dinline= - I/opt/dce/include -I/usr/local/include -O -DDBUG_OFF -Ae +O3 +Olibcalls +Onolim it +DAportable -DHAVE_BROKEN_SNPRINTF -c os0thread.c cc: warning 454: Option +O3 overrides previous setting of +O2. cc: "os0thread.c", line 29: error 1527: Incompatible types in cast: Must cast fr om scalar to scalar or to void type. cc: "os0thread.c", line 69: error 1554: Indirection must be through a pointer. cc: "os0thread.c", line 69: warning 563: Argument #2 is not the correct type. cc: "os0thread.c", line 69: error 1718: Types are not assignment-compatible. cc: "os0thread.c", line 69: warning 563: Argument #3 is not the correct type. cc: "os0thread.c", line 69: warning 604: Pointers are not assignment-compatible. cc: "os0thread.c", line 69: warning 563: Argument #4 is not the correct type. gmake[4]: *** [os0thread.o] Error 1 I have not yet analyzed the precise reason of the failure. Since it affects thread functions and the platform is HP-UX 10.20, I am not sure whether there is a solution at all. The solution might be to turn the compiler warning level to be less strict. I think the flag +DAportable is a HP compiler flag which produces an error from some less serious compiler warnings. Also the flag -Ae is suspect. But the easiest solution probably is to use the GNU C compiler if you have one on your machine. I have not compiled Innobase on the HP's commercial compiler and it will take some time to eliminate all compiler warnings there. Also the 'inline' keyword and inlined functions will probably cause problems on the HP compiler. I will check how one could generate makefiles with less strict warnings control. One possibility is to create a file Makefile.i to the directory: ...your mysql source dir... /innobase/include and put the following define there: CFLAGS = -DHAVE_CONFIG_H -I. -I. -I.. -I../../include -I../include -DHPUX -Dinline= -I/opt/dce/include -I/usr/local/include -O -DDBUG_OFF It should override the flags generated by automake. Then go to the innobase subdirectory and regenerate new Makefiles: automake autoconf ./configure Ignore the warnings automake and autoconf give. Then type make Probably you will get new errors from the HP compiler now :), I can help you tomorrow if you report the next problems you encounter. Best regards, Heikki Tuuri Innobase Oy Best regards, Lutz -- Lutz Jaenicke [EMAIL PROTECTED] BTU Cottbus http://www.aet.TU-Cottbus.DE/personen/jaenicke/ Lehrstuhl Allgemeine Elektrotechnik Tel. +49 355 69-4129 Universitaetsplatz 3-4, D-03044 Cottbus Fax. +49 355 69-4153 --- - - 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: Innobase in MySQL
I hope you can also use MySQL dump, in which case, you don't have to shut down, right? j- k- 2) Can you perform backups as with other tables? You have to shut down the database, make sure that it shuts down without errors, and then copy the Innobase data files to a safe place (it is safest also to copy the log files). Note that the .frm files only contain table definitions, not table data, which resides in the data files you specify in my.cnf. Currently there is no incremental backup nor on-line backup in Innobase. -- Joshua Kugler Associated Students of the University of Alaska Fairbanks Information Services Director [EMAIL PROTECTED] 907-474-7601 - 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 create stroed procedure in mysql
The answer you seek is clearly explained in the manual. - Original Message - From: "Gupta, Sanjeev" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 12, 2001 3:34 PM Subject: how to create stroed procedure in mysql Sanjeev Gupta Programmer Analyst Indus Consultancy Services [EMAIL PROTECTED] 201-261-3100 x 264 - 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: how to create stroed procedure in mysql
You can't. Cal http://www.calevans.com -Original Message- From: Gupta, Sanjeev [mailto:[EMAIL PROTECTED]] Sent: Monday, March 12, 2001 3:34 PM To: '[EMAIL PROTECTED]' Subject: how to create stroed procedure in mysql Sanjeev Gupta Programmer Analyst Indus Consultancy Services [EMAIL PROTECTED] 201-261-3100 x 264 - 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
GRANT problem
I wish to: GRANT SELECT ON mediabankmaster.clients TO [EMAIL PROTECTED] GRANT SELECT,INSERT ON mediabankmaster.publicdocs TO [EMAIL PROTECTED] however, this does not work. 'cemail' can SELECT from clients. 'cemail' can INSERT into publicdocs. 'cemail' CAN NOT SELECT from publiccocs. I don't know what causes this. even when i remove all the grants from 'cemail' and just have the select on public docs, it still does not allow 'cemail' to select from the publicdoc table. as you can see from the output below, I think the GRANTS are right.. why doesn't it work? mysql show grants for [EMAIL PROTECTED]; ++ | Grants for [EMAIL PROTECTED] | | ++ | GRANT USAGE ON *.* TO 'cemail'@'clients.mediabankit.com' IDENTIFIED BY PASSWORD |'06b8fb4b2db8cc44' | | GRANT SELECT ON mediabankmaster.publicdocs TO 'cemail'@'clients.mediabankit.com' | | ++ 2 rows in set (0.00 sec) mysql [1]+ Stopped mysql -p (wd: /apache/mediabank/clients/jun) (wd now: /apache/mediabank/public) [root@dahmer:public]# fg 2 mysql -u cemail -p -h clients.mediabankit.com select * from mediabankmaster.publicdocs; ERROR 1142: select command denied to user: '[EMAIL PROTECTED]' for table 'publicdocs' - Johnny Withers [EMAIL PROTECTED] p. 601.853.0211 c. 601.954.9133 - 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 directory
so does the mysql have to be installed under /usr/local/mysql ? I made a symbolic link named mysql that points to the /usr/local/mysql-3.23.32-pc-linux-gnu-i686 directory is that ok ? __ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. 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
Re: Innobase in MySQL
Joshua, I hope you can also use MySQL dump, in which case, you don't have to shut down, right? yes, you can use mysqldump without shutting down. It did not come to my mind that actually mysqldump is a kind of online backup mechanism :). Since Innobase is multiversioned, you will get consistent snapshots of your tables, and since the consistent read does not set any locks, your users should be able to update the tables concurrently. Here I have to check if mysqldump sets a full table read lock on the table you dump: for Innobase that is not needed, but maybe MySQL currently does this because of other table types. Regards, Heikki j- k- 2) Can you perform backups as with other tables? You have to shut down the database, make sure that it shuts down without errors, and then copy the Innobase data files to a safe place (it is safest also to copy the log files). Note that the .frm files only contain table definitions, not table data, which resides in the data files you specify in my.cnf. Currently there is no incremental backup nor on-line backup in Innobase. -- Joshua Kugler Associated Students of the University of Alaska Fairbanks Information Services Director [EMAIL PROTECTED] 907-474-7601 - 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 directory
Zoran Raskovic wrote: so does the mysql have to be installed under /usr/local/mysql ? I made a symbolic link named mysql that points to the /usr/local/mysql-3.23.32-pc-linux-gnu-i686 directory is that ok ? yup I go further and seperate data from binaries. This helps with partion structure (i.e big data partions (/var) vs smaller binary ones (/usr). Thus I have a datadir=/var/lib/mysql and install dir / prefix =/usr/local/mysql-$version When I do an upgrade its as simple as stoping one and starting the new one. If I need to rollback to an older version to due to an unforseen problem then I just restart the old one. Greg __ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. 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 - 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
request - insert into merge tables
Seems like it would be relatively easy to implement inserting into merge tables. I'd like to be able to at an absolute minimum round-robin insert, but even better would be something like you can do with partitioning in oracle. Baically, something like this: create table x (...) type=merge union=(a,b,c,d) partition=a:(where key=val1) partition=b:(where keyval2 and keyval3); if an insert attempt is made to that can't be partitioned, an error should be generated, otherwise, it should fall back. In the above example, it would also round-robin between c,d wherever no partition criteria didn't match. Whether or not multiple matching partition criteria should also round-robin is another good question. It's just an idea, might make merge tables quite a bit more powerful. -- Nathan Nathan Neulinger EMail: [EMAIL PROTECTED] University of Missouri - Rolla Phone: (573) 341-4841 CIS - Systems ProgrammingFax: (573) 341-4216 - 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 MySQL Binary (mysql-3.23.32-unknown-freebsdelf4.2-i386)
Description: When I try and run scripts/mysql_install_db I get the error '/usr/libexec/ld-elf.so.1: /usr/lib/libstdc++.so.3: Undefined symbol "__ti9exception"' I also got the same error when I tried to run mysql using /usr/local/mysql/bin/mysql as stated in the Subject I have FreeBSD4.1. How-To-Repeat: Fix: Submitter-Id: [EMAIL PROTECTED] Originator:Drew Toussaint Organization: Richardson Shaw PTY LTD MySQL support: none Synopsis: ?? Severity: non-critical Priority: low Category: mysql Class: sw-bug Release: mysql-3.23.32 (Source distribution) Environment: System: FreeBSD heffalump.ricshaw.com.au 4.1-RELEASE FreeBSD 4.1-RELEASE #0: Fri Jul 28 14:30:31 GMT 2000 [EMAIL PROTECTED]:/usr/src/sys/compile/GENERIC i386 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Using builtin specs. gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: -r--r--r-- 1 root wheel 1156960 Jul 28 2000 /usr/lib/libc.a lrwxrwxrwx 1 root wheel 9 Mar 7 09:25 /usr/lib/libc.so - libc.so.4 -r--r--r-- 1 root wheel 553460 Jul 28 2000 /usr/lib/libc.so.4 Configure command: ./configure --enable-large-files Perl: This is perl, version 5.005_03 built for i386-freebsd - 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 MySQL Binary (mysql-3.23.32-unknown-freebsdelf4.2-i386)
In the last episode (Mar 12), [EMAIL PROTECTED] said: Description: When I try and run scripts/mysql_install_db I get the error '/usr/libexec/ld-elf.so.1: /usr/lib/libstdc++.so.3: Undefined symbol "__ti9exception"' I also got the same error when I tried to run mysql using /usr/local/mysql/bin/mysql as stated in the Subject I have FreeBSD4.1. You'll either have to upgrade to 4.2 (or 4.3 coming out soon), or build mysql from the ports tree. A GCC upgrade went into the 4.* branch that made the c++ libraries incompatible with other versions. The binary package is built with 4.2, and doesn't like the 4.1 libstdc++.so. -- 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: Flags problem 3.23.34a with BDB support/Innobase on HP-UX 10.20
On Tue, Mar 13, 2001 at 12:00:57AM +0200, Heikki Tuuri wrote: what compiler are you using? GCC? HP:s own commercial compiler, I assume. I tend to prefer HPs commercial compiler (the code tends to be smaller and faster when running at high optimization levels). BTW, the compilation of innobase fails with cc -DHAVE_CONFIG_H -I. -I. -I.. -I../../include -I../include -DHPUX -Dinline= - I/opt/dce/include -I/usr/local/include -O -DDBUG_OFF -Ae +O3 +Olibcalls +Onolim it +DAportable -DHAVE_BROKEN_SNPRINTF -c os0thread.c cc: warning 454: Option +O3 overrides previous setting of +O2. cc: "os0thread.c", line 29: error 1527: Incompatible types in cast: Must cast fr om scalar to scalar or to void type. cc: "os0thread.c", line 69: error 1554: Indirection must be through a pointer. cc: "os0thread.c", line 69: warning 563: Argument #2 is not the correct type. cc: "os0thread.c", line 69: error 1718: Types are not assignment-compatible. cc: "os0thread.c", line 69: warning 563: Argument #3 is not the correct type. cc: "os0thread.c", line 69: warning 604: Pointers are not assignment-compatible. cc: "os0thread.c", line 69: warning 563: Argument #4 is not the correct type. gmake[4]: *** [os0thread.o] Error 1 I have not yet analyzed the precise reason of the failure. Since it affects thread functions and the platform is HP-UX 10.20, I am not sure whether there is a solution at all. The solution might be to turn the compiler warning level to be less strict. I think the flag +DAportable is a HP compiler flag which produces an error from some less serious compiler warnings. Also the flag -Ae is suspect. -Ae is extended ANSI mode. The alternate switch would be -Ac to fall back to pure KR, so -Ae is the correct way to go. +DAportable tells the backend to produce code that will also run on the older PA-1.1 CPUs (approximately before 1997), it does not affect the problem shown above. But the easiest solution probably is to use the GNU C compiler if you have one on your machine. I have not compiled Innobase on the HP's commercial compiler and it will take some time to eliminate all compiler warnings there. Also the 'inline' keyword and inlined functions will probably cause problems on the HP compiler. Yes, that is true. My CPPFLAGS already include -Dinline=, so this should not be too much of a problem. I will try GCC tomorrow (well, today :-) I will check how one could generate makefiles with less strict warnings control. One possibility is to create a file Makefile.i to the directory: ...your mysql source dir... /innobase/include and put the following define there: CFLAGS = -DHAVE_CONFIG_H -I. -I. -I.. -I../../include -I../include -DHPUX -Dinline= -I/opt/dce/include -I/usr/local/include -O -DDBUG_OFF It should override the flags generated by automake. Then go to the innobase subdirectory and regenerate new Makefiles: automake autoconf ./configure Ignore the warnings automake and autoconf give. Then type make Probably you will get new errors from the HP compiler now :), I can help you tomorrow if you report the next problems you encounter. Read you tomorrow, Lutz -- Lutz Jaenicke [EMAIL PROTECTED] BTU Cottbus http://www.aet.TU-Cottbus.DE/personen/jaenicke/ Lehrstuhl Allgemeine Elektrotechnik Tel. +49 355 69-4129 Universitaetsplatz 3-4, D-03044 Cottbus Fax. +49 355 69-4153 - 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
update on my scale problem
I've posted a few times about problems with index corruption, problems with inconsistent select results using indexes, and problems with hanging count(*) and distinct(*) on indexes. No good suggestions were provided other than upgrade to 3.23.34, (which I am loath to do unless I understand why), upgrade linux kernel due to certain problems with SMP boxes, or even turn off a processor. I've done two things, and had a clean day so far, the first clean day in several weeks! It is too soon to say the problems have gone, but it is looking better (touch wood). Fix #1 : reboot the box The box had half a year of uptime. I regarded this a badge of honor. Unfortunately, even though the filesystem was clean, it may be that the kernel had partly lost the plot sometime in the last six months, and was no longer functioning perfectly. (Not that any hint of that was provided in log messages). Fix #2: upgrade to kernel 2.4.2 If I get no weirdness by the end of this week, then I am 100% sure that either or both of these steps solved the problem.. Unfortunately I don't know which! It may be more the reboot, than the new kernel, since problems definitely started in the last few months.. I put it down to increased load, but maybe that was incorrect. So if your SMP server starts doing odd things and has been up for a while .. a simple reboot costs nothing and may very well help. -Justin - 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: Installation MySQL with Sun
See Section 4.12.1 (Solaris Notes)of documentation. Use gnu version of tar rather than Sun tar. Copy available at: http://www.mysql.com/Downloads/ John Fiegel -- Original Message -- From: "Phillip Vamplew" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Mon, 12 Mar 2001 16:50:23 - Hi, This is the first time I have ever used or attempted to install my sql. I am using a Sun Ultra 5 with Salaris 5.8. I have downloaded mysql-3.23.34-sunsalaris2.7-sparc.tar.gz and have attempted to unzip this with the command: gunzip mysql-3.23.34-sunsalaris2.7-sparc.tar.gz | tar xvf - All appears to be working but after 10 seconds the process stops with the error: 691 bytes, 2 tape blocks tar: directory check sum error. Fro reading the documentation, it does state that there could be problems with Sun Salaris but what is the work around? Can anyone help? Regards Phil Phil Vamplew European Sales Engineer Kinecta Limited 1 Poultry London EC2R 8JR DirectLine:+44 (0)207 6432927 Mobile: +44 (0)7946 324 893 Kinecta Tel: +44 (0)207 6432249 Fax: +44 (0)207 6432201 Email:[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 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
Re: charset big5 support
Hi Silver I've never tried changing character sets myself but you did download the right version and I mean source not binaries of 3.23.32? You know you can also get away with using the default charset as Chinese chars are sorted in ASCII anyway. Only problem is, you need a Chinese front end to be able to enter Chinese characters. My DB server is an English OS with mysql set to the default charset, yet users are still able to enter and view Chinese characters without any problem. From a front end only, that is. - Original Message - From: "Silver CHEN" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 12, 2001 0:48 Subject: charset big5 support dear sir: I use mysql 3.22 for a long time, it seems ok on our native language traditional chinese, charset big5. I use '--with-charset=big5' as the only one configure parameter, but when I use it on 3.23.32, the client will yield this error message: -- File 'NONEXISTENT/charsets/?.conf' not found (Errcode: 2) Character set '#1' is not a compiled character set and is not specified in the 'NONEXISTENT/charsets/Index' file -- it's a application level error message, so the pathname/filename is not important. however, I found there is no 'big5.conf' in the default /usr/local/share/mysql/charsets/ directory. should I build my own big5.conf for this problem? if so, how? thanks for your help. -- ++ |Shan-Ta CHENE-Mail : [EMAIL PROTECTED] | |Silver CHEN Tel(O) : +886-2-2378-1089-650 | |³¯µ½¹F Tel(H) : +886-2-2914-1402 | ++ == PC home §K¶O¹q¤l«H½c¡A¥Ó½Ð½Ð¦Ü: http://www.pchome.com.tw PC home Online ºô¸ô®a®x¡@¡@ ·|û²Ä¤@¡A¥xÆW³Ì¤jªº¤J¤fºô¯¸ == - 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
FW: status report
-Original Message- From: John Runnels Sent: Friday, March 09, 2001 10:47 AM To: Mysql (E-mail) Subject: FW: status report -Original Message- From: Bob Vastine-Parker Sent: Friday, March 09, 2001 10:32 AM To: John Runnels Subject: RE: status report -Original Message- From: John Runnels Sent: Friday, March 09, 2001 10:28 AM To: MY Subject: status report Here is a quick status update for MY UI Complete backend changes Complete. Add domains Complete in QA Extend Domains Complete in QA Domain Lookup Friday PM Sponsor search Complete, 1st QA pass Complete. waiting to insert sponsor id's into DB Brochure Sales Complete Join Now page In Bug Fix 2nd QA pass complete Email forwarding [EMAIL PROTECTED] Waiting to move system Into production. QA on final piece of My.ws (MY business) in progress on various pieces. Unidata License check at JenKon waiting on license. - 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
Resolution
Since I posted so many times about my problem, I feel obligated to notify everyone I have resolved it, and exactly what was wrong. I have two fields: last_update, and last_login. Both fields are timestamps, with defaults of "000". My queries were doing things like: MONTHNAME(last_login). Apparently, the previous version of MySQL I was using, 3.22.23 I believe, didn't have a problem with this. The new version I'm using, 3.23.32, apparently has a problem with this. To resolve this, I modified all my queries to use IF()...so I use: IF (last_login = '000', 'NEVER', (formatted date/time here)) AS last_login Just thought I would post to help anyone out who may have the same problem in the future! - 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
Serious bug in order by
I have just been able to repeat a bug in a rather simple ORDER BY queries that was introduced in 3.23.34. I wonder how in the world our test suite managed to miss it. We should have a fix shortly and as soon as it is available, will post a patch and will also release 3.23.35. Which reminds us of a principle that should be ( will be soon) documented in the manual - do not upgrade a production system to the latest version until it has been out for a week - we try hard to test for everything, but sometimes we miss even some simple things. The recommended version as of this second is 3.23.33. Sorry, guys. -- 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
mysql.sock -- help!!!!!
When I install mysql rpm , he puts it in /var/lib/mysql directory then, when I try to start mysql, he says that he can't find mysql.sock in /tmp/mysql.sock I donno why he is looking for it there, probably because I had binary version of mysql in /usr/local/mysql dir before. mysql.sock is in directory /var/lib/mysql/ and it is 0 bytes (!?) Now Can somebody help me how to fix this ? __ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. 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
Re: mysql.sock -- help!!!!!
the server creates the mysql.sock directory wherever you tell it to .. check /etc/my.cnf Once that is setup properly, server and client should agree. If you leave it in /tmp, then set the /tmp sticky bit to stop it getting accidently rm'd -Justin On Mon, Mar 12, 2001 at 07:57:49PM -0800, Zoran Raskovic wrote: When I install mysql rpm , he puts it in /var/lib/mysql directory then, when I try to start mysql, he says that he can't find mysql.sock in /tmp/mysql.sock I donno why he is looking for it there, probably because I had binary version of mysql in /usr/local/mysql dir before. mysql.sock is in directory /var/lib/mysql/ and it is 0 bytes (!?) Now Can somebody help me how to fix this ? __ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. 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 - 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[2]: I can't understand
Hello, Thanx for the answers, I think I've got the point now. I have one more doubt though. You described me that this whole thing with the comparison not working with NULL values is obvious. Why did it work in 3.22.25 then? Thank you for the answers so far. Bye: PP. - 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
forward slash in indexed search
Can anyone explain why LIKE queries do not use an index when the LIKE string contains a forward slash? Example: CREATE TABLE words ( word varchar(250) PRIMARY KEY ); Populate table with 200,000+ rows EXPLAIN SELECT * FROM words WHERE word LIKE 'abcdef'; This query uses the Primary key to search EXPLAIN SELECT * FROM words WHERE word LIKE 'abc/def'; This query does not use any key and scans ALL rows I am on Windows, MySQL 3.23.32. Is it a bug?
