/tmp/mysql.sock problem
Apologies for posting such a basic query, but I couldn't find an archived version of the mailing list, or a fix to my problem. Using Linux Mandrake 8.2. It's the problem with mysql.sock, which I've tried to make the /tmp directory sticky, following the command on the mysql site. However, it still hasn't provided me with a mysql.sock file. How do I reinstate this file? advTHANKSance 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
MySQL Access 97 slow
Why do linked MySQl tables in Access 97 take longer to open thne linked Access 97 tables in Access 97? Is it MyODBC? Tom Worobec --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.365 / Virus Database: 202 - Release Date: 5/24/2002 - 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
release 4.0.2
Hello developers, What problem with release 4.0.2? Why you can't release it also as 'alpha' and continue work on next version like 4.0.3. You alredy fix many bugs and add many very nice features, such as query like 'MATCH ... AGAINST(... IN BOOLEAN MODE)'. Release it! We (users) write you all other bugs. -- Best regards, Artem mailto:[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: Sluggish performance on medium sized table.. EXPLAIN SELECT's included.
Michael, Stembridge, Michael wrote: Finally, I ran an EXPLAIN SELECT on my main query. (fyi, ticketid 1 has a noteid of 1) EXPLAIN SELECT call_notes.call_elapsed, call_notes.call_seconds, call_notes.call_start, call_notes.call_end, call_notes_text.note_text, users.username, users.namefirst, users.email, facility_contact.contactid, facility_contact.contact FROM call_notes, call_notes_text, users, facility_contact WHERE call_notes.ticketid = '1' call_notes.userid = users.userid call_notes.contactid = facility_contact.contactid call_notes_text.noteid = call_notes.noteid ORDER BY call_notes.call_start DESC; +--++-+-+-+- ---+---+-+ | table| type | possible_keys | key | key_len | ref| rows | Extra | +--++-+-+-+- ---+---+-+ | call_notes_text | ALL| PRIMARY,noteid,noteid_2 | NULL|NULL | NULL | 14682 | Using temporary; Using filesort | | call_notes | eq_ref | PRIMARY,noteid,noteid_2 | PRIMARY | 4 | call_notes_text.noteid | 1 | where used | | users| eq_ref | PRIMARY,userid | PRIMARY | 4 | call_notes.userid | 1 | | | facility_contact | eq_ref | PRIMARY,contactid | PRIMARY | 4 | call_notes.contactid | 1 | | +--++-+-+-+- ---+---+-+ 4 rows in set (0.00 sec) Note the number of rows returned from call_notes_text. This matches the total number of rows in that table. That indicates that MySQL takes call_notes_text as the driving table (the table to begin with) in your join. I don't have the experience with MySQL here but in general you should always ask yourself: how big are the result sets from each table in the join (considering all your where clauses)? Then it should be clearer which table would be a good driving table. In your case it's probably call_notes (assuming that ticket_id is a very selective column (you mentioned the relationship between note_id and ticket_id); maybe an index on ticket_id would be helpful too). You should also query your database to get some idea about the distribution of the data, e.g. select count(*),ticket_id from call_notes group by ticket_id. After you have come to a conclusion you just have to teach MySQL to process your tables in the appropriate order; rephrase your SQL and use straight join. HTH Regards, Frank. -- Dr. Frank Ullrich, Netzwerkadministration Heise Zeitschriften Verlag GmbH Co KG, Helstorfer Str. 7, D-30625 Hannover E-Mail: [EMAIL PROTECTED] Phone: +49 511 5352 587; FAX: +49 511 5352 538 - 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: Uninstalling MySQL
On Mon, 3 Jun 2002, Mysql Help Service wrote: I have built a MySQL binary from source and have installed it with no problem. However, when I go to make uninstall, make bombs on me. Any recommended way for uninstalling a MySQL distro? su -c 'make uninstall' Thomas - 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: /tmp/mysql.sock problem
Dicky Wahyu Purnomo wrote: On Tue, 04 Jun 2002 08:04:01 +0100 adam [EMAIL PROTECTED] wrote: Apologies for posting such a basic query, but I couldn't find an archived version of the mailing list, or a fix to my problem. Using Linux Mandrake 8.2. It's the problem with mysql.sock, which I've tried to make the /tmp directory sticky, following the command on the mysql site. However, it still hasn't provided me with a mysql.sock file. How do I reinstate this file? the mysql.sock file is automatically created when mysqld is started. please check your configuration (/etc/my.cnf) and your mysql daemon ... :D Thanks. However, something's still wrong. Restarted the daemon - /usr/sbin/safe_mysqld and the file wasn't created. How can I check where this file is going? I've searched for it, but not found it. Adam -- -BEGIN PGP PUBLIC KEY BLOCK- Version: GnuPG v1.0.4 (GNU/Linux) Comment: For info see http://www.gnupg.org Comment: A revocation certificate should follow iEkEIBECAAkFAjxu+xACHQIACgkQEN8jbmPrR/B3LwCcDZs25AlyaMhHxZ0PoFAx 3iFknAEAmwcOYuqBoG2AGYJ5U8z3YiFgWvok =TLkp -END PGP PUBLIC KEY BLOCK- - 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
Null Values in child table with no values in Parent Table
Hi All I have created a table parent and also another table child where parentid column in child is a foreign key to the id column in parent table Is it possible that i have no entries in parent table , and i am inserting null values for parentid in child table.. sql,query Regards, -Arul - 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-4.0.1 installtion problem on redhat
From: ymalik To: [EMAIL PROTECTED] Subject: [Installation ] Description: precise description of the problem (multiple lines) mysql-4.0.1-alpha (Official MySQL RPM) installtion problem How-To-Repeat: code/input/activities to reproduce the problem (multiple lines) Fix: how to correct or work around the problem, if known (multiple lines) Submitter-Id:submitter ID Originator: Organization: organization of PR author (multiple lines) MySQL support: [none | licence | email support | extended email support ] Synopsis:synopsis of the problem (one line) Severity:[ non-critical | serious | critical ] (one line) Priority:[ low | medium | high ] (one line) Category:mysql Class:[ sw-bug | doc-bug | change-request | support ] (one line) Release:mysql-4.0.1-alpha (Official MySQL RPM) Environment: machine, os, target, libraries (multiple lines) System: Linux pcvsingh 2.4.9-13 #1 Tue Oct 30 20:11:04 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/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-98) Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='gcc' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Apr 18 09:21 /lib/libc.so.6 - libc-2.2.4.so -rwxr-xr-x1 root root 1283580 Oct 3 2001 /lib/libc-2.2.4.so -rw-r--r--1 root root 27314604 Oct 3 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 Oct 3 2001 /usr/lib/libc.so Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --without-berkeley-db --with-innodb --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 --with-embedded-server --enable-thread-safe-client '--with-comment=Official MySQL RPM' hostname.err 020604 14:40:39 mysqld started mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=8388600 record_buffer=131072 sort_buffer=2097144 max_used_connections=0 max_connections=100 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 225791 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. 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, fp=0xbfffd860, stack_bottom=0x5f637565, thread_stack=65536, aborting backtrace. Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x13 is invalid pointer thd-thread_id=0 Successfully dumped variables, if you ran with --log, take a look at the details of what thread 0 did to cause the crash. In some cases of really bad corruption, the values shown above may be invalid. The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains information that should help you find out what is causing the crash. 020604 14:40:39 mysqld ended -- -yogesh -- -yogesh - 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: WinZeos and Transactions
If WinZeos you've written about is the Zeos Database Objects (http://www.zeoslib.org), then I think I know the solution for your problem. First of all you don't have to BEGIN a transaction because when using an InnoDB connection, you always have an apened transaction, and when you close it by COMMIT or ROLLBACK InnoDB will automatically start a new one for you. There must be a TZMySQLTransact component on your palette which must be linked to your TZMySQLDatabase object. And all your TZMySQLQueryes and TZMySQLTable-s have to be linked to it too by their Transaction property. Now you have to AutoCommit property to False and TransactSafe property to True (of the TZMySQLTransact object). And that's all you have to do. Anyway the TZMySQLTransact has it's own Commit and Rollback methods. Use them. The proper documentation of how InnoDB tranasction types work, you can find it in the MySQL manual. Bye, niel At 09:38 2002.06.04.s +0200, you wrote: Hi all. I use WinZeos 3.0.3 to access MySQL 3.23.49 with Delphi 5.0. I'm using InnoDB tables and I want to use transactions. I try to begin a transaction with BEGIN and SET AUTOCOMIT=0 but doesn't work I can see the rows inserted in the database with another connection. What is the problem? The WinZeos components is too old? Iago. - 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
upgrading php for mysql support
Could anyone help me please? I am currently using 4.0.6 which was installed before mysql and has no support. I have downloaded compiled and installed php 4.2.1, restarted Apache, but it continues to run the old 4.0.6. Is there a procedure I should follow or command line I dont know? Thank for the help :) David - 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
repair problem
hello, i have a broken table and mysql seems not to fix it: mysql repair table ksiegi; +--++--+--+ | Table| Op | Msg_type | Msg_text | +--++--+--+ | gbook.ksiegi | repair | status | OK | +--++--+--+ 1 row in set (0.09 sec) mysql check table ksiegi; +--+---+--+--+ | Table| Op| Msg_type | Msg_text | +--+---+--+--+ | gbook.ksiegi | check | error| 0 when updateing keyfile | | gbook.ksiegi | check | error| Corrupt | +--+---+--+--+ 2 rows in set (0.01 sec) what can i do about it ? thanks in advance, terry - 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: WinZeos and Transactions
Thanks for your help Daniel. I've tried transactions with ZeosDBO 5.3.0 beta6 and it worked well. The problem is that I want not to change zeos component 3.0.3 to 5.3.0 because it changes some things (first changes the names of the components) and I have to change the code of the application. Also ZeosDBO 5.3.0 is supposed to be beta. Iago. -Mensaje original- De: Kiss Dániel [mailto:[EMAIL PROTECTED]] Enviado el: martes 4 de junio de 2002 11:33 Para: [EMAIL PROTECTED] Asunto: Re: WinZeos and Transactions If WinZeos you've written about is the Zeos Database Objects (http://www.zeoslib.org), then I think I know the solution for your problem. First of all you don't have to BEGIN a transaction because when using an InnoDB connection, you always have an apened transaction, and when you close it by COMMIT or ROLLBACK InnoDB will automatically start a new one for you. There must be a TZMySQLTransact component on your palette which must be linked to your TZMySQLDatabase object. And all your TZMySQLQueryes and TZMySQLTable-s have to be linked to it too by their Transaction property. Now you have to AutoCommit property to False and TransactSafe property to True (of the TZMySQLTransact object). And that's all you have to do. Anyway the TZMySQLTransact has it's own Commit and Rollback methods. Use them. The proper documentation of how InnoDB tranasction types work, you can find it in the MySQL manual. Bye, niel At 09:38 2002.06.04.s +0200, you wrote: Hi all. I use WinZeos 3.0.3 to access MySQL 3.23.49 with Delphi 5.0. I'm using InnoDB tables and I want to use transactions. I try to begin a transaction with BEGIN and SET AUTOCOMIT=0 but doesn't work I can see the rows inserted in the database with another connection. What is the problem? The WinZeos components is too old? Iago. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: innodb_flush_log_at_trx_commit
Jeremy, do we have the control as to WHEN to update the actual tables??? Thanx.. Ritu Singla --- Jeremy Zawodny [EMAIL PROTECTED] wrote: On Mon, Jun 03, 2002 at 07:07:29AM +0100, ritu singla wrote: Hello, in InnoDB tables in MySQL, if innodb_flush_log_at_trx_commit is set to 1, then on COMMIT, the buffer log is flushed to disk log... Right. or the changes are reflected in the disk copy of the database??? i mean what is flushed, the buffer-pool that contains data and indexes or the log-buffer?? Log buffer. Once the transaction is in the on-disk log, it's durable. InnoDB can choose to update the actual tables later. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.51: up 4 days, processed 97,368,631 queries (264/sec. avg) Everything you always wanted to know about cars and bikes,now at: http://in.autos.yahoo.com/cricket/tracker.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
can't start mysql.server
hi, my machine is compaq alphastation DS20E, and the mysql verision is mysql-3.23.49-dec-osf5.1-alphaev6(binary package) after executed scripts/mysql_install_db, I copy the mysql.server from /usr/local/mysql/support-files to /usr/local/mysql/bin, then executed mysql.server start and some error message showed: /usr/local/mysql/bin/mysql.server: @HOSTNAME@: not found /usr/local/mysql/bin/mysql.server: my_print_defaults: not found # chown: unknown username mysql Starting mysqld daemon with databases from /usr/local/mysql/data 020604 17:02:58 mysqld end what can I do? Thanks for your help Best regards, Paul - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: upgrading php for mysql support
Hi. This is a PHP and not a MySQL issue and therefore off-topic here. Please fine some appropriate PHP forum to ask. Bye, Benjamin. PS: The PHP READMEs contain the procedures to follow. On Tue 2002-06-04 at 02:56:25 -0700, [EMAIL PROTECTED] wrote: Could anyone help me please? I am currently using 4.0.6 which was installed before mysql and has no support. I have downloaded compiled and installed php 4.2.1, restarted Apache, but it continues to run the old 4.0.6. Is there a procedure I should follow or command line I dont know? Thank for the help :) -- [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: can't start mysql.server
Have a look to mysql error log located in /usr/local/mysql/data David - Original Message - From: Paul [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 12:15 PM Subject: can't start mysql.server hi, my machine is compaq alphastation DS20E, and the mysql verision is mysql-3.23.49-dec-osf5.1-alphaev6(binary package) after executed scripts/mysql_install_db, I copy the mysql.server from /usr/local/mysql/support-files to /usr/local/mysql/bin, then executed mysql.server start and some error message showed: /usr/local/mysql/bin/mysql.server: @HOSTNAME@: not found /usr/local/mysql/bin/mysql.server: my_print_defaults: not found # chown: unknown username mysql Starting mysqld daemon with databases from /usr/local/mysql/data 020604 17:02:58 mysqld end what can I do? Thanks for your help Best regards, Paul - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Where do i get 3.23.50 Max
Hi All MySQL Max doesnt support the feature of the column ,which is referred to be a foreign key , to be null But the Inno Db Site says We suppress the FOREIGN KEY check if any of the column values in the foreign key or referenced key to be checked is the SQL NULL.This is compatible with Oracle Ref : http://www.innodb.com/ibman.html#InnoDB_foreign_keys The release is MySQL/InnoDB-3.23.50, April 23, 2002 But where do i get this version... In www.mysql.org i could only download Max 3.23.49 Any ideas.. -Arul - 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 get data from MySQL with perl
How do I query a database with Perl - retrieve a item and then have that as a var to use in another insert statement Currently I have : Use DBI I define: my vars : host,db,username,password etc I create my db object etc I used the script to do a insert to my db and it worked fine - but I cant get data from a table with a SELECT * table WHERE whatever) I don't know excactly how to tel perl how to get the field as a var. Any help welcome - any good Perl tutorials out there ? - 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-Max-3.23.50 is downloadable from http://www.mysql.com/downloads/mysql-3.23-pre.html
Hi! People on the mailing list are asking where they can download MySQL-(Max)-3.23.50. It is available from http://www.mysql.com/downloads/mysql-3.23-pre.html. The release .50 is a regular stable release for all the other platforms except Linux. In the Linux version there is a bug in the custom-built glibc library. But as far as I know the bug has not caused much problems to Linux users either. Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.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-Max-3.23.50 is downloadable from http://www.mysql.com/downloads/mysql-3.23-pre.html
Hi Heikki Tuuri I am not sure whether it's the Max version of MySql 3.23.50 Coz the URL differs for ordinary version and Max Version.In the Max version , i couldnt see anything beyond 3.23.49 -Arul - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 4:22 PM Subject: MySQL-Max-3.23.50 is downloadable from http://www.mysql.com/downloads/mysql-3.23-pre.html Hi! People on the mailing list are asking where they can download MySQL-(Max)-3.23.50. It is available from http://www.mysql.com/downloads/mysql-3.23-pre.html. The release .50 is a regular stable release for all the other platforms except Linux. In the Linux version there is a bug in the custom-built glibc library. But as far as I know the bug has not caused much problems to Linux users either. Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.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
Loading data from file
USING LOAD LOCAL INFILE Have a database file 15000± records however only approximately 8300 will load in from the file. I found some of the records that did not load in and they appear to be ok. So I emptied the loaded fields and tried to just load approximately 180 records that did not load from the larger file. They all loaded correctly. Any suggestions on why they would not load from the big file? Is there some kind of maximum number of records to load at a time? using: mysql Mac OS X bbedit to view and edit files. Also tried loading the smaller file into the larger database file (ie the ones that were skipped ) and it won't do it using the LOAD LOCAL INFILE. Is there any problem with loading different files into the a table? Is there an easier way to do this? Thanks for any help, Ken - 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-Max-3.23.50 is downloadable from http://www.mysql.com/downloads/mysql-3.23-pre.html
Arul, you find, for example, the following binaries from that page: Binary packages (tar.gz) MySQL 3.23.50 Linux (Intel libc6 systems) Download MySQL 3.23.50 Linux (Alpha) Download MySQL 3.23.50 Linux (IA64) Download MySQL 3.23.50 Linux (Sparc) Download MySQL-Max 3.23.50 Linux (Intel libc6 systems) Download MySQL-Max 3.23.50 Linux (Alpha) Download MySQL-Max 3.23.50 Linux (IA64) Download MySQL-Max 3.23.50 Linux (Sparc) Download Regards, Heikki - Original Message - From: Arul [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 2:00 PM Subject: Re: MySQL-Max-3.23.50 is downloadable from http://www.mysql.com/downloads/mysql-3.23-pre.html Hi Heikki Tuuri I am not sure whether it's the Max version of MySql 3.23.50 Coz the URL differs for ordinary version and Max Version.In the Max version , i couldnt see anything beyond 3.23.49 -Arul - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 4:22 PM Subject: MySQL-Max-3.23.50 is downloadable from http://www.mysql.com/downloads/mysql-3.23-pre.html Hi! People on the mailing list are asking where they can download MySQL-(Max)-3.23.50. It is available from http://www.mysql.com/downloads/mysql-3.23-pre.html. The release .50 is a regular stable release for all the other platforms except Linux. In the Linux version there is a bug in the custom-built glibc library. But as far as I know the bug has not caused much problems to Linux users either. Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.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
Replication not staying connected
Description: Replication has been running fine for the past few months. Last night after we did a couple of table rebuilds and a few hundred thousand sql updates, replication started falling behind due to the slave disconnecting every minute or so. Here's what we see in the error log: 020604 7:08:53 Error reading packet from server: Lost connection to MySQL server during query (read_errno 0,server_errno= 2013) 020604 7:08:53 Slave: Failed reading log event, reconnecting to retry, log 'fosters-bin.906' position 218272266 020604 7:08:53 Slave: reconnected to master 'mysql-repl@fosters:3306',replication resumed in log 'fosters-bin.906' at pos ition 218272266 The slave reconnects, runs for about 1-5 minutes and then get's the same error as above. We have another slave which is encountering the same problem but much less frequently (2.5 hours between the last error and it's replication has managed to stay caught up. Both master and servers are running 3.23.46. What do you think is causing the disconnects and is there any way to debug this? How-To-Repeat: Fix: Submitter-Id: Originator:Marc Prewitt Organization: Wall Street Source MySQL support: extended login support Synopsis: Replication not staying connected Severity: critical Priority: high Category: mysql Class: sw-bug Release: mysql-3.23.46 (Source distribution) Server: /usr/local/bin/mysqladmin Ver 8.23 Distrib 3.23.46, for sun-solaris2.8 on sparc 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.46-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/tmp/mysql.sock Uptime: 8 hours 36 min 18 sec Threads: 2 Questions: 3970404 Slow queries: 127 Opens: 461 Flush tables: 1 Open tables: 448 Queries per second avg: 128.169 Environment: System: SunOS polar 5.8 Generic_108528-12 sun4u sparc SUNW,Sun-Blade-1000 Architecture: sun4 Some paths: /usr/local/bin/perl /usr/local/bin/make /usr/local/bin/gcc GCC: Reading specs from /opt/gcc/3.0.4/lib/gcc-lib/sparc-sun-solaris2.8/3.0.4/specs Configured with: ../3.0.4/configure --with-gcc-version-trigger=/usr/local/src/gcc/3.0.4/gcc/version.c --prefix=/opt/gcc/3.0.4 --with-system-zlib Thread model: posix gcc version 3.0.4 Compilation info: CC='/opt/gcc/2.95.2/bin/gcc' CFLAGS='-O3 -mcpu=v8 -Wa,-xarch=v8plusa' CXX='/opt/gcc/2.95.2/bin/g++' CXXFLAGS='-O3 -mcpu=v8 -Wa,-xarch=v8plusa -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 11 Aug 22 2001 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1136748 Nov 27 2001 /lib/libc.so.1 lrwxrwxrwx 1 root root 11 Aug 22 2001 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1136748 Nov 27 2001 /usr/lib/libc.so.1 Configure command: ./configure --prefix=/opt/mysql/3.23.46 --with-berkeley-db --with-innobase --localstatedir=/export/DB/mysqldb --with-unix-socket-path=/var/tmp/mysql.sock - 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
processlist
Hello all, Please can any one tell me how do i see all the queries in my mysql server in real-time? this is for checking witch ones are longer. regards tsa -- E-Mail: [EMAIL PROTECTED] Date: 04-Jun-2002 Time: 12:04:29 This message was sent by ME! -- - 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
Bug related to large tables and it's indexes on Win2k
Hi all, When large tables are being addressed, we seem to have encountered a bug related to having large indexes on the table. We have several tables in our system that have reached 4 gigs in size. We altered the table definition to allow it to get larger... this is our current table creation statement (for the table giving us trouble, not the entire system) CREATE TABLE IcAlias( IcAliasID BIGINT NOT NULL PRIMARY KEY, mID VARCHAR(255) NOT NULL, IcEntityID BIGINT NOT NULL, IcTypeID SMALLINT NOT NULL, IcDupSortID VARCHAR(255) NOT NULL, INDEX mIDIdx (mID), INDEX IcTypeIDIdx (IcTypeID), INDEX IcEntityIDIdx (IcEntityID), INDEX IcDupSortIDIdx (IcDupSortID)) AVG_ROW_LENGTH=4096 MAX_ROWS=4294967295; Before we added the AVG_ROW_LENGTH and MAX_ROWS settings, we generated a table that was 4 gigs in size and an index that was over 6 gigs. Now the table fails when the index file approaches 4 gigs (actually 3.5 something)! We are getting this message when trying to insert data: Error: Can't change size of indexfile, error: 22, when using table: icalias We originally saw this in 3.23.36 and have reproduced it in the latest 4.0 alpha download. The platform is a Windows 2000 box running on dual Athlons (1900+ I think) with 4 gigs of ram and a 135 gig raid. I've spent a lot of time looking in Deja and on the MySql site and have not found a solution to this problem. Given that it takes 12 hours or so to build this table, it takes a while to test any attempts at a fix. Any help would be ~greatly~ appreciated! I really don't know what to try next! - 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: processlist
On Tuesday 04 June 2002 15:07, [EMAIL PROTECTED] wrote: Hello all, Please can any one tell me how do i see all the queries in my mysql server in real-time? this is for checking witch ones are longer. `mysqladmin -v proc` Or (in mysql client) mysql SHOW PROCESSLIST; regards tsa -- Best regards, Sergey S. Kostyliov [EMAIL PROTECTED] Public PGP key: http://sysadminday.org.ru/rathamahata.asc - 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: processlist
Hi, Just connect to mysql and use this query : show processlit; http://www.mysql.com/doc/S/H/SHOW_PROCESSLIST.html You can also use slow query logs. http://www.mysql.com/doc/S/l/Slow_query_log.html David - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 1:07 PM Subject: processlist Hello all, Please can any one tell me how do i see all the queries in my mysql server in real-time? this is for checking witch ones are longer. regards tsa -- E-Mail: [EMAIL PROTECTED] Date: 04-Jun-2002 Time: 12:04:29 This message was sent by ME! -- - 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 in inserting date
create table dt (dt datetime); --- OK insert into dt values ( date_format('04/06/2002 13:48:38', '%d/%m/%Y %H:%i:%s')); --- Surprisingly it enters NULL insert into dt values ( date_format('2002/04/06 13:48:38', '%Y/%d/%m %H:%i:%s')); --- Surprisingly (not really) it enters correct date WHY is it so? I want the first insert to work properly. But it seems it is not working. By simply moving the year part in first place makes the statement to work properly. Why? Is it a MySQL bug. Please respond. I already invested almost a day in finding it out. Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: RE: InnoDB and Windows
Alexandre, Monday, June 03, 2002, 8:08:14 PM, you wrote: AZ Maybe this thread has already been solved. If so im sorry for the disturb. AZ Here is my problem: AZ I want to use InnoDB transactionnal table types with mysql on Windows 2000 . AZ I set my ini file correctly, start the console and my ibdata table is AZ created and I can now create InnoDB tables. AZ The problem is I cnat specify the autoincrement option for the Innodb data AZ file . AZ Here is what my ini looks like now : AZ innodb_data_home_dir = C:\mysql\ibdata AZ innodb_data_file_path =ibdata1:100M AZ This setting works perfectly but the ibdata1 file is not autoincrementing AZ when it is full . AZ And here is what it should look like to have an auto extending innodb data AZ file AZ innodb_data_home_dir = C:\mysql\ibdata AZ innodb_data_file_path =ibdata1:100M:autoextend:max:2000M AZ Now if I try this last setting I get a syntax error on the AZ innodb_data_file_path line when I try to start the Mysql-max server in AZ console mode. AZ I know it is supposed to work as said in the manual. Now is it a known bug AZ on windows platform ??? What version of MySQL server are you using? Autoextend is only supported since version 3.23.50 -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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: Newbie - How 2 ODBC/JDBC to MySQL
Mary, Monday, June 03, 2002, 11:00:17 PM, you wrote: MDI just installed MySQL. Win 2000 Professional. MDI am logged in as none. MDNo User Id. No Password. MDI wonder how. :) Check the manual. By default on Windows all local users have full privileges on all databases. MDI could create tables, update records, query etc,. MDNow I would like to make ODBC connections. MDAnd eventually make JDBC connection from my \ MDJava code. MDHow do I do this? MDHow do I setup ODBC connection to this? You should install ODBC driver. You can download it from: http://www.mysql.com/downloads/api-myodbc.html MDI have just performed default installation. MDAnd I think I gave my WIn User account some kind of MD grant priveleges. I donot recollect bcs, MD it was mentioned in some web page. And I MD just executed while trying this and that to MD get into the MySQL. MD thanx in advance for any help suggested. MD -Mary -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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: files in /tmp
Don, Monday, June 03, 2002, 11:13:59 PM, you wrote: DV there are 2 files in my /tmp directory that look like mysql datafiles: DV #sql208_ecc_0.MYD DV #sql208_ecc_0.MYI DV They're on the same box as our development mysql instance but I don't see them on any of our other instances. Anyone have any idea what they are/if I can delete them? They're clogging up disk DV space... These are files corresponding to the temporary tables. Path to the dir where temporary tables are stored is specified with TMPDIR variable of mysqld: http://www.mysql.com/doc/T/e/Temporary_files.html DV thanks, DV Don -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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: Null Values in child table with no values in Parent Table
Arul, Tuesday, June 04, 2002, 9:23:34 AM, you wrote: A I have created a table parent and also another table child where parentid A column in child is a foreign key to the id column in parent table A Is it possible that i have no entries in parent table , and i am inserting A null values for parentid in child table.. Since 3.23.50 you can set parentid to the NULL value. You can also use ON DELETE SET NULL clause, that will be automatically update parentid to the NULL value: http://www.mysql.com/doc/S/E/SEC446.html You can download 3.23.50 from the MySQL site: http://www.mysql.com/downloads/mysql-3.23-pre.html A Regards, A -Arul -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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: changing the root password
Chris, Tuesday, June 04, 2002, 12:08:38 AM, you wrote: CS I can't remember my root password. I know that there is a way to set it by CS starting mysql with certain parameters, but I can't remember what those CS parameters are. Can you help me out? Thanks! You should start mysqld with --skip-grant-tables option. for more details look at: http://www.mysql.com/doc/R/e/Resetting_permissions.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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: processlist
thanks David, i have allready seen that but what is exactlly them command line to do so? EX: the select queries or the update ones in all databases or in just in one. regards tsa On 04-Jun-2002 David BORDAS wrote: Hi, Just connect to mysql and use this query : show processlit; http://www.mysql.com/doc/S/H/SHOW_PROCESSLIST.html You can also use slow query logs. http://www.mysql.com/doc/S/l/Slow_query_log.html David - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 1:07 PM Subject: processlist Hello all, Please can any one tell me how do i see all the queries in my mysql server in real-time? this is for checking witch ones are longer. regards tsa -- E-Mail: [EMAIL PROTECTED] Date: 04-Jun-2002 Time: 12:04:29 This message was sent by ME! -- - 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 -- E-Mail: [EMAIL PROTECTED] Date: 04-Jun-2002 Time: 12:20:56 PGP Fingerprint = 5519 0CE9 2553 6877 A929 8270 91C0 D92D 4063 559E This message was sent by ME! -- - 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: Re: /tmp/mysql.sock problem
adam, Tuesday, June 04, 2002, 12:05:30 PM, you wrote: the mysql.sock file is automatically created when mysqld is started. please check your configuration (/etc/my.cnf) and your mysql daemon ... :D a Thanks. However, something's still wrong. a Restarted the daemon - /usr/sbin/safe_mysqld and the file wasn't created. a How can I check where this file is going? I've searched for it, but not a found it. Are you sure that your MySQL server was started? Check with the following command if there is mysqld in the process list ps ax | grep mysqld a Adam -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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: processlist
thanks Sergey, but that command line only shows the total processlist, it doesn't show exactlly witch queries are happening on my tables besids my one that says 'show full processlist'.The others are sleep , but if they are really, why is my mysql server running severls processes with 11.5 Mgs or so? Do i need some kind of compilation option to show me more info on the processlist? best regards, tsa On 04-Jun-2002 Sergey S. Kostyliov wrote: On Tuesday 04 June 2002 15:07, [EMAIL PROTECTED] wrote: Hello all, Please can any one tell me how do i see all the queries in my mysql server in real-time? this is for checking witch ones are longer. `mysqladmin -v proc` Or (in mysql client) mysql SHOW PROCESSLIST; regards tsa -- Best regards, Sergey S. Kostyliov [EMAIL PROTECTED] Public PGP key: http://sysadminday.org.ru/rathamahata.asc - 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 -- E-Mail: [EMAIL PROTECTED] Date: 04-Jun-2002 Time: 12:26:38 PGP Fingerprint = 5519 0CE9 2553 6877 A929 8270 91C0 D92D 4063 559E This message was sent by ME! -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
OT GUI front-end on Mac OS X?
Is anyone successfully accessing MySQL from Mac OS X via a GUI front-end? Any advice? Thanks, Andrew __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.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
JDBC Drivers
Hi Could anyone suggest me the JDBC Drivers available for MySql. Can the driver support Connection Pooling and RowSet -Arul - 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: processlist
Think that even if mysql don't have connection, there are severals processes running ... For waiting connection for exemple. with 11.5 Mgs or so This memory is i think a buffer or a cache shared by each mysql process such as indexes for exemple ... David From: [EMAIL PROTECTED] To: Sergey S. Kostyliov [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 1:33 PM Subject: Re: processlist thanks Sergey, but that command line only shows the total processlist, it doesn't show exactlly witch queries are happening on my tables besids my one that says 'show full processlist'.The others are sleep , but if they are really, why is my mysql server running severls processes with 11.5 Mgs or so? Do i need some kind of compilation option to show me more info on the processlist? best regards, tsa On 04-Jun-2002 Sergey S. Kostyliov wrote: On Tuesday 04 June 2002 15:07, [EMAIL PROTECTED] wrote: Hello all, Please can any one tell me how do i see all the queries in my mysql server in real-time? this is for checking witch ones are longer. `mysqladmin -v proc` Or (in mysql client) mysql SHOW PROCESSLIST; regards tsa -- Best regards, Sergey S. Kostyliov [EMAIL PROTECTED] Public PGP key: http://sysadminday.org.ru/rathamahata.asc - 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 -- E-Mail: [EMAIL PROTECTED] Date: 04-Jun-2002 Time: 12:26:38 PGP Fingerprint = 5519 0CE9 2553 6877 A929 8270 91C0 D92D 4063 559E This message was sent by ME! -- - 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
PLEASE SEE THE MYSQL.ERR FILE ATTACHED
Good Morning, Please see into file mysql.err look the InnoDB errors. We are working with 4.0.1-alpha-max-nt-log versión under operating system Windows 2000 advance Server. Our database have about 13GB of disk. Thank you for your help. We are waiting for your solutions or comments. Best regards, AVIATUR TEAM. MySql: preparado para conexiones 020530 17:58:17 MySql: Apagado normal 020530 17:58:18 MySql: Forzando a cerrar el thread 1 usuario: 'root' MySql: preparado para conexiones InnoDB: error in sec index entry update in InnoDB: index AESTADO table estadistica/docmserv InnoDB: tuple 0: len 2; hex 5045; asc PE;; 1: len 2; hex 4342; asc CB;; 2: len 16; hex 34393133383430303030343534313534; asc 491384454154;; 3: len 10; hex 20202038333233303738; asc8323078;; 4: len 3; hex 303530; asc 050;; 5: len 3; hex 303031; asc 001;; 6: len 2; hex 2031; asc 1;; InnoDB: record RECORD: info bits 0 0: len 2; hex 5045; asc PE;; 1: len 2; hex 4342; asc CB;; 2: len 16; hex 34393133363239363030313138303939; asc 4913629600118099;; 3: len 10; hex 20202039313838343932; asc9188492;; 4: len 3; hex 303130; asc 010;; 5: len 3; hex 303031; asc 001;; 6: len 2; hex 2031; asc 1;; InnoDB: Make a detailed bug report and send it InnoDB: to [EMAIL PROTECTED] TRANSACTION 0 1199700, OS thread id 2792 updating or deleting, active, runs or sleeps, has 97 lock struct(s), undo log entries 162 MySQL thread id 9, query id 8416 cluster1 172.30.26.8 root LOAD DATA LOCAL INFILE D:/estadistica/planos/DOCMSERV_MYSQL1020.TXT REPLACE INTO TABLE DOCMSERV InnoDB: error in sec index entry update in InnoDB: index KEY_NITFEC table estadistica/relmrela InnoDB: tuple 0: len 16; hex 20202020202020202020202020757364; asc usd;; 1: len 3; hex 8fa4b6; asc ..;; 2: len 2; hex 2031; asc 1;; 3: len 2; hex 5654; asc VT;; InnoDB: record RECORD: info bits 0 0: len 16; hex 20202020202020202020202020555344; asc USD;; 1: len 3; hex 8fa489; asc .?;; 2: len 2; hex 4731; asc G1;; 3: len 2; hex 5654; asc VT;; InnoDB: Make a detailed bug report and send it InnoDB: to [EMAIL PROTECTED] InnoDB: error in sec index entry update in InnoDB: index KEY_FECHA table estadistica/relmrela InnoDB: tuple 0: len 3; hex 8fa4b6; asc ..;; 1: len 16; hex 20202020202020202020202020757364; asc usd;; 2: len 2; hex 2031; asc 1;; 3: len 2; hex 5654; asc VT;; InnoDB: record RECORD: info bits 0 0: len 3; hex 8fa4b6; asc ..;; 1: len 16; hex 20202020202020202020202020205646; asc VF;; 2: len 2; hex 4931; asc I1;; 3: len 2; hex 5654; asc VT;; InnoDB: Make a detailed bug report and send it InnoDB: to [EMAIL PROTECTED] InnoDB: error in sec index entry update in InnoDB: index KEY_TIPFEC table estadistica/relmrela InnoDB: tuple 0: len 2; hex 5654; asc VT;; 1: len 3; hex 8fa4b6; asc ..;; 2: len 16; hex 20202020202020202020202020757364; asc usd;; 3: len 2; hex 2031; asc 1;; InnoDB: record RECORD: info bits 0 0: len 2; hex 5654; asc VT;; 1: len 3; hex 8fa4b6; asc ..;; 2: len 16; hex 20202020202020202020202020205646; asc VF;; 3: len 2; hex 4931; asc I1;; InnoDB: Make a detailed bug report and send it InnoDB: to [EMAIL PROTECTED] TRANSACTION 0 1199812, OS thread id 2792 updating or deleting, active, runs or sleeps, has 7 lock struct(s), undo log entries 673 MySQL thread id 9, query id 8596 cluster1 172.30.26.8 root LOAD DATA LOCAL INFILE D:/estadistica/planos/RELMRELA_MYSQL.TXT REPLACE INTO TABLE RELMRELA TRANSACTION 0 1199812, OS thread id 2792 updating or deleting, active, runs or sleeps, has 7 lock struct(s), undo log entries 673 MySQL thread id 9, query id 8596 cluster1 172.30.26.8 root LOAD DATA LOCAL INFILE D:/estadistica/planos/RELMRELA_MYSQL.TXT REPLACE INTO TABLE RELMRELA TRANSACTION 0 1199812, OS thread id 2792 updating or deleting, active, runs or sleeps, has 7 lock struct(s), undo log entries 673 MySQL thread id 9, query id 8596 cluster1 172.30.26.8 root LOAD DATA LOCAL INFILE D:/estadistica/planos/RELMRELA_MYSQL.TXT REPLACE INTO TABLE RELMRELA InnoDB: error in sec index entry update in InnoDB: index KEY_NITFEC table estadistica/relmrela InnoDB: tuple 0: len 16; hex 20202020202020203433303237313436; asc 43027146;; 1: len 3; hex 8fa48f; asc .;; 2: len 2; hex 4531; asc E1;; 3: len 2; hex 5654; asc VT;; InnoDB: record RECORD: info bits 0 0: len 16; hex 20202020202020203433303237313336; asc 43027136;; 1: len 3; hex 8fa327; asc .';; 2: len 2; hex 2031; asc 1;; 3: len 2; hex 5654; asc VT;; InnoDB: Make a detailed bug report and send it InnoDB: to [EMAIL PROTECTED] InnoDB: error in sec index entry update in InnoDB: index KEY_FECHA table estadistica/relmrela InnoDB: tuple 0: len 3; hex 8fa48f; asc .;; 1: len 16; hex 20202020202020203433303237313436; asc 43027146;; 2: len 2; hex 4531; asc E1;; 3: len 2; hex 5654; asc VT;; InnoDB: record RECORD: info bits 0 0: len 3; hex 8fa48f; asc .;; 1: len 16; hex 20202020202020203432393737303130; asc 42977010;; 2: len 2; hex 4531; asc E1;; 3: len 2; hex
Re: processlist
Hi, If show processlist is not satisfied for you the try : show full processlist; On the right you can see the current query. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: [EMAIL PROTECTED] To: Sergey S. Kostyliov [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 2:33 PM Subject: Re: processlist thanks Sergey, but that command line only shows the total processlist, it doesn't show exactlly witch queries are happening on my tables besids my one that says 'show full processlist'.The others are sleep , but if they are really, why is my mysql server running severls processes with 11.5 Mgs or so? Do i need some kind of compilation option to show me more info on the processlist? best regards, tsa On 04-Jun-2002 Sergey S. Kostyliov wrote: On Tuesday 04 June 2002 15:07, [EMAIL PROTECTED] wrote: Hello all, Please can any one tell me how do i see all the queries in my mysql server in real-time? this is for checking witch ones are longer. `mysqladmin -v proc` Or (in mysql client) mysql SHOW PROCESSLIST; regards tsa -- Best regards, Sergey S. Kostyliov [EMAIL PROTECTED] Public PGP key: http://sysadminday.org.ru/rathamahata.asc - 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 -- E-Mail: [EMAIL PROTECTED] Date: 04-Jun-2002 Time: 12:26:38 PGP Fingerprint = 5519 0CE9 2553 6877 A929 8270 91C0 D92D 4063 559E This message was sent by ME! -- - 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: Problem in inserting date
Bad answer. If you 'guess', then don't answer. The idea behind the date_format is to format a date as per user's need and should not be forced to a particular format just because some countries follows some format. Still looking for serious answer? - Original Message - From: Harald Fuchs [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 6:26 PM Subject: Re: Problem in inserting date In article 000901c20bc2$7b286100$221464a4@cimws34, R.C.Nougain [EMAIL PROTECTED] writes: create table dt (dt datetime); --- OK insert into dt values ( date_format('04/06/2002 13:48:38', '%d/%m/%Y %H:%i:%s')); --- Surprisingly it enters NULL Surprisingly only for those who don't read the MySQL documentation. insert into dt values ( date_format('2002/04/06 13:48:38', '%Y/%d/%m %H:%i:%s')); --- Surprisingly (not really) it enters correct date WHY is it so? I guess because in some languages/countries the day is in front of the month, whereas in others it's the other way round. By simply moving the year part in first place makes the statement to work properly. Why? Is it a MySQL bug. No, it's a documented feature. I already invested almost a day in finding it out. You really should invest two hours or so in reading the documentation. - 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
Full-Text Search Help!
I've implemented a full-text index on several of my database fields in a table, populated those fields with some very simple, yet distinct records, and have run recommended queries against that table. Alas, I still end up getting back empty query sets. I have read about having a minimum of 3 records in my table to retrieve results, which I do have. Can anyone offer up their interpretation of a proper fulltext query (there doesn't seem to be one good way in the online docs)??? Thanks. -D - 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: Bug related to large tables and it's indexes on Win2k
Win2k (at least the version that we are on) does indeed support files much larger than 2 gigs. Another db we use has index files that are 6.8 gigs and 4.7 gigs. - Original Message - From: miguel solorzano [EMAIL PROTECTED] To: Jared Richardson [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: Jared Richardson [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 9:40 AM Subject: Re: Bug related to large tables and it's indexes on Win2k At 08:17 4/6/2002 -0400, Jared Richardson wrote: Hi, When large tables are being addressed, we seem to have encountered a bug related to having large indexes on the table. We have several tables in our system that have reached 4 gigs in size. Did you had tested if actually your OS supports size files greater than 4 GB ?. I use Win2k Server and its default format doesn't permits files with size greater than 2 GB (even formatted with NTFS). Regards, -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.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: ON DELETE , ON UPDATE Operation
No, there are no STANDARD libraries that will do this for you. There are some good database abstraction layers that you can employ, my fav is ADODB (hit google to find it) but it only handles the basics. You will have to write PHP code that you call each time you delete a record to do additional processing. =C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -Original Message- From: N.Elangovan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 12:03 AM To: [EMAIL PROTECTED] Subject: ON DELETE , ON UPDATE Operation Dear Sir, I am developing an application on PHP using MYSQL database. Its alittle comples database. It uses a lot of links within database. The problem is how i can implement ON DELETE and on update operation with PHP MYSQL. Are there STANDARD LIBRARIES for this operation. Thanking you N.Elangovan - 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: OT GUI front-end on Mac OS X?
SQL4X Manager by InterServices has worked for me, it doesn't have much for meta edit guis though (alter tables and grant/revoke users) On Tuesday 04 June 2002 8:05, you wrote: Is anyone successfully accessing MySQL from Mac OS X via a GUI front-end? Any advice? Thanks, Andrew __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.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
Equivalent SELECT for SHOW command
Hello all, Are there any system_table which I can to do a pure SELECT command to get the same results that MySql SHOW command, in the same way that Oracle DB ? 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
How to write output of sql stmt to file
Hi there, I am trying to get only records out of a table mathing a query. This should be piped into a textfile. My problem is that I have to transmit this records to a new machine. So the output should be a kind of sql commands which I could run with phpadmin or similar to import them to the other db on the other machine. Is this possible? Thank you for any help, andy - 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
Frontend and report tool
Hi Can anyone tell me if they know about a good frontend for mysql with reporting facilities, or alternatively only a report generator? Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem in inserting date
This date formatting is how mysql handles dates. If it cannot parse the date then is will store an invalid date. Please see http://www.mysql.com/doc/D/A/DATETIME.html as this will answer some of your datetime questions. Accept your rebuke. You should have read up on datetimes before posting. I guess that goes for a few questions on this list. Steve Bad answer. If you 'guess', then don't answer. The idea behind the date_format is to format a date as per user's need and should not be forced to a particular format just because some countries follows some format. Still looking for serious answer? - Original Message - From: Harald Fuchs [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 6:26 PM Subject: Re: Problem in inserting date In article 000901c20bc2$7b286100$221464a4@cimws34, R.C.Nougain [EMAIL PROTECTED] writes: create table dt (dt datetime); --- OK insert into dt values ( date_format('04/06/2002 13:48:38', '%d/%m/%Y %H:%i:%s')); --- Surprisingly it enters NULL Surprisingly only for those who don't read the MySQL documentation. insert into dt values ( date_format('2002/04/06 13:48:38', '%Y/%d/%m %H:%i:%s')); --- Surprisingly (not really) it enters correct date WHY is it so? I guess because in some languages/countries the day is in front of the month, whereas in others it's the other way round. By simply moving the year part in first place makes the statement to work properly. Why? Is it a MySQL bug. No, it's a documented feature. I already invested almost a day in finding it out. You really should invest two hours or so in reading the documentation. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
query
alright, not sure if i can even do this or not, but i figured the list would know. here is the query i have: SELECT count(ID),sum(pnt1)+sum(pnt2)+sum(pnt3)+sum(pnt4) FROM wiseQuiz_questions WHERE test='$test' here is the table structure i have: CREATE TABLE `wiseQuiz_questions` ( `ID` int(11) NOT NULL auto_increment, `test` int(11) default NULL, `question` text, `ans1` text, `ans2` text, `ans3` text, `ans4` text, `pnt1` int(11) default NULL, `pnt2` int(11) default NULL, `pnt3` int(11) default NULL, `pnt4` int(11) default NULL, PRIMARY KEY (`ID`) ); the values that i am concerned with are the pnt1, pnt2, pnt3 and pnt4 fields. as you can see with the query i am simply summing each of the columns. what i would like to do is out of the four fields only add the HIGHEST value to the sum. is there a way to do that? some of the values i have are below: 3 2 1 0 2 3 0 1 in this scenario i would want to see the total as 6, rather than 12. see where i am going? thanks in advance, katen - 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: GUI compiling on OSX
Luke Sather wrote: Greetings. I'd really enjoy having a SQL GUI for my Mac laptop, is it likely that one of BSD sources will compile under OSX? I haven't compiling anything yet, so I thought I'd should ask if it has been mentioned before. Here is a list of many GUI MySQL clients for OS X (not complete though). They all vary in feature set and price (including free): MacSQL Runtime Labs http://www.rtlabs.com/ ProSQL Intelli Innovations http://www.intellisw.com/prosql/ CocoaSQL mxcantor technologies http://homepage.mac.com/mxcantor/ SQLGrinder Advenio Software http://www.advenio.com/sqlgrinder/ SQL4X Manager InterServices http://www.macosguru.de/packages/SQL4XManager.html SQLBoss SQLBoss Inc. http://www.sqlboss.com/ MySQL Magic La Chose Interactive http://www.theinteractivething.com/?menu=productsp=mysqlmagiclng=en phpMyAdmin Phpwizard.net http://www.phpwizard.net/projects/phpMyAdmin/ Webmin James Cameron http://www.webmin.com/webmin/index.html JaneBUILDER See Jane Code http://www.seejanecode.com/ Doing a search on VersionTracker for SQL would lead you to most of these: http://www.versiontracker.com/macosx/ - 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 ALL on *.* to ... Error
Hi all, I have a strange problem, I am startirng my mysql-4.0.1 with option --skip-grant-tables. I am using mysql and when I try : grant ALL on *.* to admin@localhost identified by passwd i get the following errot: ERROR 1047: Unknown command Can some one felp me with that? Gregards Vlady - 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: Bug related to large tables and it's indexes on Win2k
The table type is the default, MYISAM - Original Message - From: Schneck Walter [EMAIL PROTECTED] To: 'Jared Richardson ' [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 10:11 AM Subject: AW: Bug related to large tables and it's indexes on Win2k | Hi, | | what table-typ do you use ? | | rg Walter | | -Originalnachricht- | Von: Jared Richardson | An: [EMAIL PROTECTED]; [EMAIL PROTECTED] | Cc: Jared Richardson | Gesendet: 04.06.02 14:17 | Betreff: Bug related to large tables and it's indexes on Win2k | | Hi all, | | When large tables are being addressed, we seem to have encountered a bug | related to having large indexes on the table. | | We have several tables in our system that have reached 4 gigs in size. | We | altered the table definition to allow it to get larger... this is our | current table creation statement (for the table giving us trouble, not | the | entire system) | | CREATE TABLE IcAlias( |IcAliasID BIGINT NOT NULL PRIMARY KEY, |mID VARCHAR(255) NOT NULL, |IcEntityID BIGINT NOT NULL, |IcTypeID SMALLINT NOT NULL, |IcDupSortID VARCHAR(255) NOT NULL, |INDEX mIDIdx (mID), |INDEX IcTypeIDIdx (IcTypeID), |INDEX IcEntityIDIdx (IcEntityID), |INDEX IcDupSortIDIdx (IcDupSortID)) |AVG_ROW_LENGTH=4096 MAX_ROWS=4294967295; | | Before we added the AVG_ROW_LENGTH and MAX_ROWS settings, we generated | a | table that was 4 gigs in size and an index that was over 6 gigs. Now | the | table fails when the index file approaches 4 gigs (actually 3.5 | something)! | We are getting this message when trying to insert data: | Error: Can't change size of indexfile, error: 22, when using table: | icalias | | We originally saw this in 3.23.36 and have reproduced it in the latest | 4.0 | alpha download. The platform is a Windows 2000 box running on dual | Athlons | (1900+ I think) with 4 gigs of ram and a 135 gig raid. | | I've spent a lot of time looking in Deja and on the MySql site and have | not | found a solution to this problem. Given that it takes 12 hours or so to | build this table, it takes a while to test any attempts at a fix. | | Any help would be ~greatly~ appreciated! I really don't know what to try | next! | | | - | Please check http://www.mysql.com/Manual_chapter/manual_toc.html; | before | posting. To request this thread, e-mail [EMAIL PROTECTED] | | To unsubscribe, send a message to the address shown in the | List-Unsubscribe header of this message. If you cannot see it, | e-mail [EMAIL PROTECTED] instead. | - 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 write output of sql stmt to file
[snip] I am trying to get only records out of a table mathing a query. This should be piped into a textfile. My problem is that I have to transmit this records to a new machine. So the output should be a kind of sql commands which I could run with phpadmin or similar to import them to the other db on the other machine. Is this possible? [/snip] from: http://www.mysql.com/doc/S/E/SELECT.html The SELECT ... INTO OUTFILE 'file_name' form of SELECT writes the selected rows to a file. The file is created on the server host and cannot already exist (among other things, this prevents database tables and files such as `/etc/passwd' from being destroyed). You must have the file privilege on the server host to use this form of SELECT. SELECT ... INTO OUTFILE is mainly intended to let you very quickly dump a table on the server machine. If you want to create the resulting file on some other host than the server host you can't use SELECT ... INTO OUTFILE. In this case you should instead use some client program like mysqldump --tab or mysql -e SELECT ... outfile to generate the file. SELECT ... INTO OUTFILE is the complement of LOAD DATA INFILE; the syntax for the export_options part of the statement consists of the same FIELDS and LINES clauses that are used with the LOAD DATA INFILE statement. See section 6.4.9 LOAD DATA INFILE Syntax. In the resulting text file, only the following characters are escaped by the ESCAPED BY character: The ESCAPED BY character The first character in FIELDS TERMINATED BY The first character in LINES TERMINATED BY Additionally, ASCII 0 is converted to ESCAPED BY followed by 0 (ASCII 48). The reason for the above is that you must escape any FIELDS TERMINATED BY, ESCAPED BY, or LINES TERMINATED BY characters to reliably be able to read the file back. ASCII 0 is escaped to make it easier to view with some pagers. As the resulting file doesn't have to conform to the SQL syntax, nothing else need be escaped. Here follows an example of getting a file in the format used by many old programs. SELECT a,b,a+b INTO OUTFILE /tmp/result.text FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '' LINES TERMINATED BY \n FROM test_table; HTH! Jay - 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: Bug related to large tables and it's indexes on Win2k
Thanks Walter since their is no reason (that I am aware of) for the system not to handle the current problem, I want to try to solve it if possible. I have been using MySql for a number of years... if this is an actual bug, it will be the first one I've ever encountered! :) Also, we've tested InnoDB with our data (it's all meta data so it's a very large number of very small bits of data) and found it to be slower than the ISAM tables for our application. - Original Message - From: Schneck Walter [EMAIL PROTECTED] To: 'Jared Richardson ' [EMAIL PROTECTED]; Schneck Walter [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 10:20 AM Subject: AW: Bug related to large tables and it's indexes on Win2k | Well, | | im not an expert in MYSQL tabletypes, | but what if seen yet InnoDB is the most | preferred tabletyp for real appis. | if possible try out InnoDB. | | rg Walter | | -Originalnachricht- | Von: Jared Richardson | An: Schneck Walter; [EMAIL PROTECTED]; [EMAIL PROTECTED] | Gesendet: 04.06.02 16:15 | Betreff: Re: Bug related to large tables and it's indexes on Win2k | | The table type is the default, MYISAM | | - Original Message - | From: Schneck Walter [EMAIL PROTECTED] | To: 'Jared Richardson ' [EMAIL PROTECTED]; | [EMAIL PROTECTED]; [EMAIL PROTECTED] | Sent: Tuesday, June 04, 2002 10:11 AM | Subject: AW: Bug related to large tables and it's indexes on Win2k | | | | Hi, | | | | what table-typ do you use ? | | | | rg Walter | | | | -Originalnachricht- | | Von: Jared Richardson | | An: [EMAIL PROTECTED]; [EMAIL PROTECTED] | | Cc: Jared Richardson | | Gesendet: 04.06.02 14:17 | | Betreff: Bug related to large tables and it's indexes on Win2k | | | | Hi all, | | | | When large tables are being addressed, we seem to have encountered a | bug | | related to having large indexes on the table. | | | | We have several tables in our system that have reached 4 gigs in size. | | We | | altered the table definition to allow it to get larger... this is our | | current table creation statement (for the table giving us trouble, not | | the | | entire system) | | | | CREATE TABLE IcAlias( | |IcAliasID BIGINT NOT NULL PRIMARY KEY, | |mID VARCHAR(255) NOT NULL, | |IcEntityID BIGINT NOT NULL, | |IcTypeID SMALLINT NOT NULL, | |IcDupSortID VARCHAR(255) NOT NULL, | |INDEX mIDIdx (mID), | |INDEX IcTypeIDIdx (IcTypeID), | |INDEX IcEntityIDIdx (IcEntityID), | |INDEX IcDupSortIDIdx (IcDupSortID)) | |AVG_ROW_LENGTH=4096 MAX_ROWS=4294967295; | | | | Before we added the AVG_ROW_LENGTH and MAX_ROWS settings, we | generated | | a | | table that was 4 gigs in size and an index that was over 6 gigs. Now | | the | | table fails when the index file approaches 4 gigs (actually 3.5 | | something)! | | We are getting this message when trying to insert data: | | Error: Can't change size of indexfile, error: 22, when using table: | | icalias | | | | We originally saw this in 3.23.36 and have reproduced it in the latest | | 4.0 | | alpha download. The platform is a Windows 2000 box running on dual | | Athlons | | (1900+ I think) with 4 gigs of ram and a 135 gig raid. | | | | I've spent a lot of time looking in Deja and on the MySql site and | have | | not | | found a solution to this problem. Given that it takes 12 hours or so | to | | build this table, it takes a while to test any attempts at a fix. | | | | Any help would be ~greatly~ appreciated! I really don't know what to | try | | next! | | | | | | - | | Please check http://www.mysql.com/Manual_chapter/manual_toc.html; | | before | | posting. To request this thread, e-mail | [EMAIL PROTECTED] | | | | To unsubscribe, send a message to the address shown in the | | List-Unsubscribe header of this message. If you cannot see it, | | e-mail [EMAIL PROTECTED] instead. | | | - 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 of mysql failed on solaris 2.6
From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Installation of mysql on Solaris 2.6 using 3.23.49-sun-solaris2.7-sparc version content-length: 2557 Description: I'm trying to install mysql version 3.23.49-sun-solaris2.7-sparc on Sun Solaris 2.6 but kept on getting the error when I ran the ./configure : Preparing tables_priv table Preparing columns_priv table Installing all prepared tables ld.so.1: ./bin/mysqld: fatal: libpthread.so.1: version `SUNW_1.2' not found (required by file ./bin/mysqld) Killed Installation of grant tables failed! This is first install of mysql on this system. How-To-Repeat: I followed the documentation regarding the steps of installation. groupadd mysql useradd -g mysql mysql cd /usr/local gunzip /path/to/mysql-VERSION-OS.tar.gz | tar xvf - ln -s mysql-VERSION-OS mysql cd mysql scripts/mysql_install_db whenever I got to the mysql_install_db, that is when I get the error: ld.so.1: ./bin/mysqld: fatal: libpthread.so.1: version `SUNW_1.2' not found (required by file ./bin/mysqld) Fix: Submitter-Id: [EMAIL PROTECTED] Originator:ttran Organization: startsampling MySQL support: [email support ] Synopsis: Installation of mysql on sun solaris 2.6 failed. Severity: Priority: Category: mysql Class: Release: mysql-3.23.49-max (Official MySQL-max binary) Environment: System: SunOS kauai 5.6 Generic_105181-23 sun4u sparc SUNW,Ultra-80 Architecture: sun4 Some paths: /usr/local/bin/perl /usr/local/bin/make /usr/local/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.6/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='-O3 -fno-omit-frame-pointer' CXX='gcc' CXXFLAGS='-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: -rw-r--r-- 1 bin bin 1600348 Mar 20 1998 /lib/libc.a lrwxrwxrwx 1 root root 11 Feb 1 2000 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 bin bin 1009696 Mar 20 1998 /lib/libc.so.1 -rw-r--r-- 1 bin bin 1600348 Mar 20 1998 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Feb 1 2000 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 bin bin 1009696 Mar 20 1998 /usr/lib/libc.so.1 Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL-max binary' --with-extra-charsets=complex --with-server-suffix=-max --enable-thread-safe-client --enable-local-infile --enable-assembler --disable-shared --with-berkeley-db --with-innodb Perl: This is perl, version 5.005_03 built for sun4-solaris = Tuan Tran Email address: [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.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-4.0.1 installtion problem on redhat
Yogesh, Tuesday, June 04, 2002, 12:26:10 PM, you wrote: YM Description: YM precise description of the problem (multiple lines) YM mysql-4.0.1-alpha (Official MySQL RPM) installtion problem YM How-To-Repeat: YM code/input/activities to reproduce the problem (multiple lines) YM Fix: YM how to correct or work around the problem, if known (multiple lines) YM Submitter-Id:submitter ID YM Originator: YM Organization: YM organization of PR author (multiple lines) YM MySQL support: [none | licence | email support | extended email support ] YM Synopsis:synopsis of the problem (one line) YM Severity:[ non-critical | serious | critical ] (one line) YM Priority:[ low | medium | high ] (one line) YM Category:mysql YM Class:[ sw-bug | doc-bug | change-request | support ] (one line) YM Release:mysql-4.0.1-alpha (Official MySQL RPM) YM hostname.err YM 020604 14:40:39 mysqld started YM mysqld got signal 11; YM This could be because you hit a bug. It is also possible that this binary YM or one of the libraries it was linked against is corrupt, improperly built, YM or misconfigured. This error can also be caused by malfunctioning hardware. YM We will try our best to scrape up some info that will hopefully help YM diagnose YM the problem, but since we have already crashed, something is definitely YM wrong YM and this may fail. Signal 11 happens if MySQL is compiled using wrong libraries and compilers (the case when you do compile MySQL on a raw Red Hat) or broken hardware. You are using the official MySQL packages, so most likely it happens because of broken harware. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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: Mysl crashing
Steven, Tuesday, June 04, 2002, 5:29:06 AM, you wrote: Description: SW Our mysql server crashes relatively often. Most of the time after a crash, the error logs show a line like thd-query at 0x84aef98 = show processlist (although some have 0x50e64580 SW is invalid pointer and others (nil) is invalid pointer). We do have a process which regularly does a show processlist on this server. SW I was running the debian packaged version of mysql (latest version in woody), but upgraded to mysql-max and ran myisamchk on all tables before starting the database to make sure that the SW problems were not benig caused by table corruption. I do not believe that we are using any functions that require mysql-max, so if installing the binary release of mysql is the next recommended SW step, I can do this. How-To-Repeat: SW I can not get this to happen on demand, but I was wondering if the above lines indicate that the show processlist command was causing the problem. Can you repeat it with the official MySQL binary distribution? Please, also check the tables. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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: repair problem
Terry, Tuesday, June 04, 2002, 12:46:44 PM, you wrote: T i have a broken table and mysql seems not to fix it: mysql repair table ksiegi; T +--++--+--+ T | Table| Op | Msg_type | Msg_text | T +--++--+--+ T | gbook.ksiegi | repair | status | OK | T +--++--+--+ T 1 row in set (0.09 sec) mysql check table ksiegi; T +--+---+--+--+ T | Table| Op| Msg_type | Msg_text | T +--+---+--+--+ T | gbook.ksiegi | check | error| 0 when updateing keyfile | T | gbook.ksiegi | check | error| Corrupt | T +--+---+--+--+ T 2 rows in set (0.01 sec) T what can i do about it ? Can you upload your table(gzipped) to ftp://support.mysql.com/pub/mysql/secret ? T thanks in advance, T terry -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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: query
* Steve Katen alright, not sure if i can even do this or not, but i figured the list would know. here is the query i have: SELECT count(ID),sum(pnt1)+sum(pnt2)+sum(pnt3)+sum(pnt4) FROM wiseQuiz_questions WHERE test='$test' here is the table structure i have: CREATE TABLE `wiseQuiz_questions` ( `ID` int(11) NOT NULL auto_increment, `test` int(11) default NULL, `question` text, `ans1` text, `ans2` text, `ans3` text, `ans4` text, `pnt1` int(11) default NULL, `pnt2` int(11) default NULL, `pnt3` int(11) default NULL, `pnt4` int(11) default NULL, PRIMARY KEY (`ID`) ); the values that i am concerned with are the pnt1, pnt2, pnt3 and pnt4 fields. as you can see with the query i am simply summing each of the columns. what i would like to do is out of the four fields only add the HIGHEST value to the sum. is there a way to do that? some of the values i have are below: 3 2 1 0 2 3 0 1 in this scenario i would want to see the total as 6, rather than 12. see where i am going? Maybe you can use the function called GREATEST()...? URL: http://www.mysql.com/doc/M/a/Mathematical_functions.html Something like: SELECT count(ID),sum(greatest(pnt1,pnt2,pnt3,pnt4)) FROM wiseQuiz_questions WHERE test='$test' -- Roger - 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 write output of sql stmt to file
Did you check out the -w option to mysqldump? andy wrote: Hi there, I am trying to get only records out of a table mathing a query. This should be piped into a textfile. My problem is that I have to transmit this records to a new machine. So the output should be a kind of sql commands which I could run with phpadmin or similar to import them to the other db on the other machine. Is this possible? Thank you for any help, andy - 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: Problem in inserting date
On Tue, 4 Jun 2002, R.C.Nougain wrote: Bad answer. If you 'guess', then don't answer. The idea behind the date_format is to format a date as per user's need and should not be forced to a particular format just because some countries follows some format. Still looking for serious answer? RC, seriously, date_format determines the format of what you get out of this function, and not the format of the input. When you want to feed it a string, this string must be parsed and must be in a representation suitable to MySQL. By definition this is '/mm/dd'. What you are looking for is a completely different function not yet available in MySQL. It would take a string, interprete it according to a given template and would then return the date in 'standard' representation. Thomas Spahni - 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: Record dependencies
Yes, the concepts he presents are in generic SQL. I've used them in 2 different systems (menus and security) and they work fine. (NOTE: You DO have to write your own code.) ;) Ok, I picked up the book yesterday. It has alot of really good information. However, with regards to the concepts presented in the chapters you pointed out, it doesn't appear to be very useful to me. What the author suggests is fine for data (and a tree) that is relatively static. However, my tree is going to be dynamic. Users will be able to come online and define the relationship between records. Using the example I gave yester- day, the fields might look like this: fieldName dependantOn joe monster bob joe briggs monster briggs vision today, but might look like this: fieldName dependantOn joe bob monster briggs monster vision bob tomorrow The author suggests using numbers in two columns (lft, rgt) to represent the lower and upper limits with regards to the boundries of each node. Unfortunately, I cannot do that for two reasons: * As mentioned above, my tree structure is dynamic. * My keys (fieldName, dependantOn) are word values, not numeric. I do not believe this matters in some cases, but I don't think that mySQL can use the BETWEEN command on alpha values. So basically, I'm back at square one where I'm not sure where I can go to find the information I need with regards to how to traverse my dynamic tree with one query. Purchasing the book you suggested was far from a waste as it contains a great deal of very useful information. Sadly, it didn't help me much in my case. Any other suggestions? Chris - 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: grant ALL on *.* to ... Error
grant ALL PRIVILEGES on *.* to admin@localhost identified by passwd you may want to include with grant option -Original Message- From: vlady [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 10:15 AM To: [EMAIL PROTECTED] Subject: grant ALL on *.* to ... Error Hi all, I have a strange problem, I am startirng my mysql-4.0.1 with option --skip-grant-tables. I am using mysql and when I try : grant ALL on *.* to admin@localhost identified by passwd i get the following errot: ERROR 1047: Unknown command Can some one felp me with that? Gregards Vlady - 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: Full-Text Search Help!
David, Tuesday, June 04, 2002, 5:43:16 PM, you wrote: DS I've implemented a full-text index on several of my database fields in a DS table, populated those fields with some very simple, yet distinct records, DS and have run recommended queries against that table. Alas, I still end up DS getting back empty query sets. I have read about having a minimum of 3 DS records in my table to retrieve results, which I do have. Can anyone offer DS up their interpretation of a proper fulltext query (there doesn't seem to be DS one good way in the online docs)??? David, when you get some non-expected results, please send in the mail-list the full info, i.e. your SQL statement, your table structure (use DESCRIBE) and so on. If you get empty result set it could be because of: 1. Incorrect SELECT statemnt; 2. 50% threshold, i.e. your search word is contained in more that 50% rows in the table. 3. Something wrong in full-text search. DS Thanks. DS -D -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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: grant ALL on *.* to ... Error
vlady, Tuesday, June 04, 2002, 5:14:54 PM, you wrote: v I have a strange problem, v I am startirng my mysql-4.0.1 with option --skip-grant-tables. v I am using mysql and when I try : v grant ALL on *.* to admin@localhost identified by passwd v i get the following errot: v ERROR 1047: Unknown command v Can some one felp me with that? FLUSH PRIVILEGES; and then use GRANT statement :) v Gregards v Vlady -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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: WinZeos and Transactions
It's easy to upgrade. I just did a search and replace in the .dfm files. Fredrick - Original Message - From: Informatica Handem [EMAIL PROTECTED] To: Kiss Dániel [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 3:00 AM Subject: RE: WinZeos and Transactions Thanks for your help Daniel. I've tried transactions with ZeosDBO 5.3.0 beta6 and it worked well. The problem is that I want not to change zeos component 3.0.3 to 5.3.0 because it changes some things (first changes the names of the components) and I have to change the code of the application. Also ZeosDBO 5.3.0 is supposed to be beta. Iago. -Mensaje original- De: Kiss Dániel [mailto:[EMAIL PROTECTED]] Enviado el: martes 4 de junio de 2002 11:33 Para: [EMAIL PROTECTED] Asunto: Re: WinZeos and Transactions If WinZeos you've written about is the Zeos Database Objects (http://www.zeoslib.org), then I think I know the solution for your problem. First of all you don't have to BEGIN a transaction because when using an InnoDB connection, you always have an apened transaction, and when you close it by COMMIT or ROLLBACK InnoDB will automatically start a new one for you. There must be a TZMySQLTransact component on your palette which must be linked to your TZMySQLDatabase object. And all your TZMySQLQueryes and TZMySQLTable-s have to be linked to it too by their Transaction property. Now you have to AutoCommit property to False and TransactSafe property to True (of the TZMySQLTransact object). And that's all you have to do. Anyway the TZMySQLTransact has it's own Commit and Rollback methods. Use them. The proper documentation of how InnoDB tranasction types work, you can find it in the MySQL manual. Bye, niel At 09:38 2002.06.04.s +0200, you wrote: Hi all. I use WinZeos 3.0.3 to access MySQL 3.23.49 with Delphi 5.0. I'm using InnoDB tables and I want to use transactions. I try to begin a transaction with BEGIN and SET AUTOCOMIT=0 but doesn't work I can see the rows inserted in the database with another connection. What is the problem? The WinZeos components is too old? Iago. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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: release 4.0.2
I agree, I would like to use multi table delete and other new features in win32... - Original Message - From: Artem V. Ryabov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 1:00 AM Subject: release 4.0.2 Hello developers, What problem with release 4.0.2? Why you can't release it also as 'alpha' and continue work on next version like 4.0.3. You alredy fix many bugs and add many very nice features, such as query like 'MATCH ... AGAINST(... IN BOOLEAN MODE)'. Release it! We (users) write you all other bugs. -- Best regards, Artem mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Bug related to large tables and it's indexes on Win2k
Hi Jared and Walter I don't suggest changing to InnoDB just to try solve a unknown problem! MyISAM tables are usually less problematic, being the default table type, and most tested in MySQL. And it seems Jared has benchmarked it as being more suited to his situation. InnoDb tables are usually better where you need row locking and transactions, and MyISAM usually for tables where the vast majority of queries are selects (such as websites). Jared, I can't help solve your problem, but I'd be very interested if you got an answer! Two suggestions though that may be of use: 1) Make sure your indexes are healthy 2) Try using a MERGE table regards, ian gilfillan - Original Message - From: Jared Richardson [EMAIL PROTECTED] To: Schneck Walter [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 4:24 PM Subject: Re: Bug related to large tables and it's indexes on Win2k Thanks Walter since their is no reason (that I am aware of) for the system not to handle the current problem, I want to try to solve it if possible. I have been using MySql for a number of years... if this is an actual bug, it will be the first one I've ever encountered! :) Also, we've tested InnoDB with our data (it's all meta data so it's a very large number of very small bits of data) and found it to be slower than the ISAM tables for our application. - Original Message - From: Schneck Walter [EMAIL PROTECTED] To: 'Jared Richardson ' [EMAIL PROTECTED]; Schneck Walter [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 10:20 AM Subject: AW: Bug related to large tables and it's indexes on Win2k | Well, | | im not an expert in MYSQL tabletypes, | but what if seen yet InnoDB is the most | preferred tabletyp for real appis. | if possible try out InnoDB. | | rg Walter | | -Originalnachricht- | Von: Jared Richardson | An: Schneck Walter; [EMAIL PROTECTED]; [EMAIL PROTECTED] | Gesendet: 04.06.02 16:15 | Betreff: Re: Bug related to large tables and it's indexes on Win2k | | The table type is the default, MYISAM | | - Original Message - | From: Schneck Walter [EMAIL PROTECTED] | To: 'Jared Richardson ' [EMAIL PROTECTED]; | [EMAIL PROTECTED]; [EMAIL PROTECTED] | Sent: Tuesday, June 04, 2002 10:11 AM | Subject: AW: Bug related to large tables and it's indexes on Win2k | | | | Hi, | | | | what table-typ do you use ? | | | | rg Walter | | | | -Originalnachricht- | | Von: Jared Richardson | | An: [EMAIL PROTECTED]; [EMAIL PROTECTED] | | Cc: Jared Richardson | | Gesendet: 04.06.02 14:17 | | Betreff: Bug related to large tables and it's indexes on Win2k | | | | Hi all, | | | | When large tables are being addressed, we seem to have encountered a | bug | | related to having large indexes on the table. | | | | We have several tables in our system that have reached 4 gigs in size. | | We | | altered the table definition to allow it to get larger... this is our | | current table creation statement (for the table giving us trouble, not | | the | | entire system) | | | | CREATE TABLE IcAlias( | |IcAliasID BIGINT NOT NULL PRIMARY KEY, | |mID VARCHAR(255) NOT NULL, | |IcEntityID BIGINT NOT NULL, | |IcTypeID SMALLINT NOT NULL, | |IcDupSortID VARCHAR(255) NOT NULL, | |INDEX mIDIdx (mID), | |INDEX IcTypeIDIdx (IcTypeID), | |INDEX IcEntityIDIdx (IcEntityID), | |INDEX IcDupSortIDIdx (IcDupSortID)) | |AVG_ROW_LENGTH=4096 MAX_ROWS=4294967295; | | | | Before we added the AVG_ROW_LENGTH and MAX_ROWS settings, we | generated | | a | | table that was 4 gigs in size and an index that was over 6 gigs. Now | | the | | table fails when the index file approaches 4 gigs (actually 3.5 | | something)! | | We are getting this message when trying to insert data: | | Error: Can't change size of indexfile, error: 22, when using table: | | icalias | | | | We originally saw this in 3.23.36 and have reproduced it in the latest | | 4.0 | | alpha download. The platform is a Windows 2000 box running on dual | | Athlons | | (1900+ I think) with 4 gigs of ram and a 135 gig raid. | | | | I've spent a lot of time looking in Deja and on the MySql site and | have | | not | | found a solution to this problem. Given that it takes 12 hours or so | to | | build this table, it takes a while to test any attempts at a fix. | | | | Any help would be ~greatly~ appreciated! I really don't know what to | try | | next! | | | | | | - | | Please check http://www.mysql.com/Manual_chapter/manual_toc.html; | | before | | posting. To request this thread, e-mail | [EMAIL PROTECTED] | | | | To unsubscribe, send a message to the address shown in the | | List-Unsubscribe header of this message. If you cannot see it, | | e-mail [EMAIL PROTECTED] instead. | | |
RE: grant ALL on *.* to ... Error
http://www.mysql.com/doc/G/R/GRANT.html It's in there...keep digging. * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -Original Message- From: vlady [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 9:15 AM To: [EMAIL PROTECTED] Subject: grant ALL on *.* to ... Error Hi all, I have a strange problem, I am startirng my mysql-4.0.1 with option --skip-grant-tables. I am using mysql and when I try : grant ALL on *.* to admin@localhost identified by passwd i get the following errot: ERROR 1047: Unknown command Can some one felp me with that? Gregards Vlady - 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
Full-Text update crash
I've read a couple posts about problems issuing updates to mysql on full-text key'd columns, unfortunately the only answer found is that its will be fixed in the upcoming 4.0.2 release. any idea when that will go beta? or should I trying using the cvs version? I could post a stack trace, but I'm sure its the same problem posted here: http://groups.google.com/groups?hl=enlr=ie=UTF8oe=UTF8threadm=a37qm6%241v4g%241%40FreeBSD.csie.NCTU.edu.twrnum=5prev=/groups%3Fq%3Dupdate%2Bcrash%2Bmysql%2Bfulltext%26hl%3Den%26lr%3D%26ie%3DUTF8%26oe%3DUTF8%26selm%3Da37qm6%25241v4g%25241%2540FreeBSD.csie.NCTU.edu.tw%26rnum%3D5 (geedang thats one long url) -ryan - 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 Access 97 slow
It's ODBC in general. One more layer of abstraction to deal with. =C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -Original Message- From: Tom Worobec [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 2:56 AM To: MySQl Lists Subject: MySQL Access 97 slow Why do linked MySQl tables in Access 97 take longer to open thne linked Access 97 tables in Access 97? Is it MyODBC? Tom Worobec --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.365 / Virus Database: 202 - Release Date: 5/24/2002 - 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 write output of sql stmt to file
Jay Blanchard wrote: [snip] I am trying to get only records out of a table mathing a query. This should be piped into a textfile. My problem is that I have to transmit this records to a new machine. So the output should be a kind of sql commands which I could run with phpadmin or similar to import them to the other db on the other machine. Is this possible? How about: echo your_statement_here | mysql -N database | ssh user@remotemachine 'cat - | mysql -N database' assuming you are using kind of Unix/Linux with abilitiy to contact the remote machine with ssh Greetings Ralf - 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: Frontend and report tool
You might want to have a look at urSQL -- http://www.urbanresearch.com/ursql -- it has built in support for exporting query results in a variety of formats... On Tue, 4 Jun 2002, Petre Agenbag wrote: Hi Can anyone tell me if they know about a good frontend for mysql with reporting facilities, or alternatively only a report generator? - 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: grant ALL on *.* to ... Error
- Original Message - From: vlady [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 4:14 PM Subject: grant ALL on *.* to ... Error Hi all, I have a strange problem, I am startirng my mysql-4.0.1 with option --skip-grant-tables. I am using mysql and when I try : grant ALL on *.* to admin@localhost identified by passwd Well, if you want to GRANT stuff, it might help to actually start WITH grant-tables. :) - 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
Re: grant ALL on *.* to ... Error
- Original Message - From: Mark [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 6:19 PM Subject: Re: grant ALL on *.* to ... Error - Original Message - From: vlady [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 4:14 PM Subject: grant ALL on *.* to ... Error Hi all, I have a strange problem, I am startirng my mysql-4.0.1 with option --skip-grant-tables. I am using mysql and when I try : grant ALL on *.* to admin@localhost identified by passwd Well, if you want to GRANT stuff, it might help to actually start WITH grant-tables. :) I worded this a bit awkwardly; what I meant was, that, prior to granting new privileges, you bring mysql into a state WITH grant-tables again by forcing it to reload the grant tables. You can do that by executing FLUSH PRIVILEGES first. - 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
how to make stress test , mysql
hi, I have finished an application about online exam using java servlet and tomcat and mysql. I am trying to write a testing script to simulate 180 students to take the exam during the period of one hour. so far i have no idea how to start. I didn't find anything talking about that. I just found some stress test software but they not free. so i am trying to write a simple testing script. Any help will be appreciated very much. bin __ Movies, Music, Sports, Games! http://entertainment.yahoo.ca - 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: /tmp/mysql.sock problem
Dicky Wahyu Purnomo wrote: On Tue, 04 Jun 2002 08:04:01 +0100 adam [EMAIL PROTECTED] wrote: Apologies for posting such a basic query, but I couldn't find an archived version of the mailing list, or a fix to my problem. Using Linux Mandrake 8.2. It's the problem with mysql.sock, which I've tried to make the /tmp directory sticky, following the command on the mysql site. However, it still hasn't provided me with a mysql.sock file. How do I reinstate this file? the mysql.sock file is automatically created when mysqld is started. please check your configuration (/etc/my.cnf) and your mysql daemon ... :D On Tue, 04 Jun 2002 10:04:28 +0100 adam [EMAIL PROTECTED] wrote: It's the problem with mysql.sock, which I've tried to make the /tmp directory sticky, following the command on the mysql site. However, it still hasn't provided me with a mysql.sock file. How do I reinstate this file? the mysql.sock file is automatically created when mysqld is started. please check your configuration (/etc/my.cnf) and your mysql daemon ... :D did u install mysql from rpm or tgz ? if rpm ... 0. make sure that all mysqld stopped ... killall -9 safe_mysqld; killall -9 mysqld 1. /etc/init.d/mysql start or /etc/init.d/mysql restart 2. ps ax | grep mysqld 3. you should see minimal line with safe_mysqld and only mysqld 4. do -- shell $ updatedb 5. do -- shell $ locate mysql.sock 6. for sure ... run mysql client -- shell $ mysql I've followed these instructions and strangely, mysql.sock appears in /var/lib/mysql/ Should I copy it over? I has a funny equals sign next to it in Midnight Commander. Thanks again for advice. Adam -- -BEGIN PGP PUBLIC KEY BLOCK- Version: GnuPG v1.0.4 (GNU/Linux) Comment: For info see http://www.gnupg.org Comment: A revocation certificate should follow iEkEIBECAAkFAjxu+xACHQIACgkQEN8jbmPrR/B3LwCcDZs25AlyaMhHxZ0PoFAx 3iFknAEAmwcOYuqBoG2AGYJ5U8z3YiFgWvok =TLkp -END PGP PUBLIC KEY BLOCK- - 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: /tmp/mysql.sock problem
Egor Egorov wrote: adam, Tuesday, June 04, 2002, 12:05:30 PM, you wrote: the mysql.sock file is automatically created when mysqld is started. please check your configuration (/etc/my.cnf) and your mysql daemon ... :D a Thanks. However, something's still wrong. a Restarted the daemon - /usr/sbin/safe_mysqld and the file wasn't created. a How can I check where this file is going? I've searched for it, but not a found it. Are you sure that your MySQL server was started? Check with the following command if there is mysqld in the process list ps ax | grep mysqld Egor, This was the output I received: [root@localhost mysql]# ps ax | grep mysqld 2398 pts/0S 0:00 grep mysqld [root@localhost mysql]# Thanks 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
Re: /tmp/mysql.sock problem
OK got this sorted in the end, by putting a soft link in to the /tmp folder pointing to the /var/lib - thanks one and all. Adam Dicky Wahyu Purnomo wrote: On Tue, 04 Jun 2002 08:04:01 +0100 adam [EMAIL PROTECTED] wrote: Apologies for posting such a basic query, but I couldn't find an archived version of the mailing list, or a fix to my problem. Using Linux Mandrake 8.2. It's the problem with mysql.sock, which I've tried to make the /tmp directory sticky, following the command on the mysql site. However, it still hasn't provided me with a mysql.sock file. How do I reinstate this file? the mysql.sock file is automatically created when mysqld is started. please check your configuration (/etc/my.cnf) and your mysql daemon ... :D -- -BEGIN PGP PUBLIC KEY BLOCK- Version: GnuPG v1.0.4 (GNU/Linux) Comment: For info see http://www.gnupg.org Comment: A revocation certificate should follow iEkEIBECAAkFAjxu+xACHQIACgkQEN8jbmPrR/B3LwCcDZs25AlyaMhHxZ0PoFAx 3iFknAEAmwcOYuqBoG2AGYJ5U8z3YiFgWvok =TLkp -END PGP PUBLIC KEY BLOCK- - 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 Access 97 slow
-Original Message- From: Tom Worobec [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 12:56 AM To: MySQl Lists Subject: MySQL Access 97 slow Why do linked MySQl tables in Access 97 take longer to open thne linked Access 97 tables in Access 97? Is it MyODBC? Unless the table is too big, it shouldn't take much time. Make sure no debug and/or traces enabled for the driver/ driver manager. Check with the new version of the driver 3.51.03 that is released yesterday. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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
FW: Multiple Servers, mysqld_multi
sql,query Is there any option to do this on a windows version? All the documentation ( and from what I see of the installation of the = windows version ) leads me to believe there is not Luc - 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
? Afer adding an Innodb file - .frm corruption ?
My objective is to create a clean new and installed system (with a clean database) from a developpement environment (where I do tests and developpement) where the database is full of things I clean. One solution would be to recreate from zero the database. But I have decided to use a cleaned version of this database. But at the end of the process I have this error on the log: InnoDB: Cannot find table zope/Users from the internal data dictionary InnoDB: of InnoDB though the .frm file for the table exists. Maybe you InnoDB: have deleted and recreated InnoDB data files but have forgotten InnoDB: to delete the corresponding .frm files of InnoDB tables, or you InnoDB: have moved .frm files to another database? When I do: mysql use zope; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Didn'd find any fields in table 'Log' Didn'd find any fields in table 'Miscdata' Didn'd find any fields in table 'Users' Database changed mysql select * from Users; ERROR 1016: Can't open file: 'Users.InnoDB'. (errno: 1) mysql The process I follow to create this broken database is: 1) Copy all the filesystem of the developpment computer (where are the files of a dirty database (mysql 3.23.46)) to the computer I use to generate the clean image (in a mounted local disk). 2) Run mysql (3.23.47) in this computer, pointing to the database in the disk. Clean the databases (remove all the fields of the tables I want) (delete from ...). 3) Stop mysql. 4) Add another Innodb database file in the mysql configuration file (so this file will be created when mysql will be runned in the freshly installed system). Delete Innodb log files. 5) Create a copy of the filesystem with dump tool. 6) I recreate all the filesystem in a another computer, beeing the root filesystem. So this computer is now a copy of the developpment computer, but without dirty things. 7) Everything works well, the second Innodb file is created. Except at the moment of accessing to the database, where I have this kind of errors. So somewhere in the process the .frm files are broken. The strange thing is that the database is accessed well in 2), an I haven't any error, even after deleting it. So I suppose that what happens is that mysql becomes mad when it creates the new Innodb file (after rebooting the computer, after the restore), he is not able to maintain in sync the .frm files. Am I right ?? Or should I use exactly the same version of mysql ?? (The error comes because I use 3.23.47, when the files after is read by a 3.23.46. ?) Or is it a bug ? (empty databases + add an Innodb file) If I delete a .frm files: rm /var/lib/mysql/zope/Log.frm mysql select * from Log; ERROR 1146: Table 'zope.Log' doesn't exist Thank you very much, -- Saludos de Julián EA4ACL -.- - 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: Mysl crashing
Hi, It happened to me ...with Red Hat 7.2 and MySQL 3.23.47. Anyway if you want to see easily what's wrong you can do: Identify the PID of your process which make monitoring processes. In other task you can do : strace -d -p the_PID ...and let it open. When MySQL crash strace tell you with what signal is out. If the signal is one of : SIGILL or SIGBUS you have a hardware problem for sure . Else So...which what signal die ? Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Steven Wilton [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 5:29 AM Subject: Mysl crashing Description: Our mysql server crashes relatively often. Most of the time after a crash, the error logs show a line like thd-query at 0x84aef98 = show processlist (although some have 0x50e64580 is invalid pointer and others (nil) is invalid pointer). We do have a process which regularly does a show processlist on this server. I was running the debian packaged version of mysql (latest version in woody), but upgraded to mysql-max and ran myisamchk on all tables before starting the database to make sure that the problems were not benig caused by table corruption. I do not believe that we are using any functions that require mysql-max, so if installing the binary release of mysql is the next recommended step, I can do this. How-To-Repeat: I can not get this to happen on demand, but I was wondering if the above lines indicate that the show processlist command was causing the problem. Fix: Unknown Submitter-Id: submitter ID Originator: root Organization: MySQL support: none Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-3.23.49 (Source distribution) Server: /usr/bin/mysqladmin Ver 8.23 Distrib 3.23.49, 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.49a-max-log Protocol version 10 Connection Localhost via UNIX socket UNIX socket /var/run/mysqld/mysqld.sock Uptime: 3 days 9 hours 36 min 13 sec Threads: 45 Questions: 21283332 Slow queries: 701 Opens: 186 Flush tables: 1 Open tables: 98 Queries per second avg: 72.448 Environment: System: Linux mysql1 2.4.18 #3 SMP Thu May 9 14:56:09 WST 2002 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs gcc version 2.95.4 20011002 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 14 Mar 8 09:07 /lib/libc.so.5 - libc.so.5.4.46 -rw-r--r--1 root root 563068 Feb 5 05:30 /lib/libc.so.5.4.46 lrwxrwxrwx1 root root 13 May 22 10:44 /lib/libc.so.6 - libc-2.2.5.so -rwxr-xr-x1 root root 1153784 Apr 28 17:57 /lib/libc-2.2.5.so -rw-r--r--1 root root 2390922 Apr 28 17:58 /usr/lib/libc.a -rw-r--r--1 root root 178 Apr 28 17:58 /usr/lib/libc.so Configure command: ./configure --prefix=/usr --exec-prefix=/usr --libexecdir=/usr/sbin --datad ir=/usr/share --sysconfdir=/etc/mysql --localstatedir=/var/lib/mysql --inclu dedir=/usr/include --infodir=/usr/share/info --mandir=/usr/share/man --enabl e-shared --with-libwrap --enable-assembler --with-berkeley-db --with-innodb --enable-static --enable-shared --enable-local-infile --with-raid --enable-t hread-safe-client --without-readline --with-unix-socket-path=/var/run/mysqld /mysqld.sock --with-mysqld-user=mysql --without-bench --with-client-ldflags= -lstdc++ --with-extra-charsets=all - 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
LOAD DATA LOCAL INFILE
Before I get started, let me say that I have looked at the manual, gone through a number of posts to the lists and read Paul's MySQL book. I've tried a lot of things over the course of the past three hours and am hoping that someone can shed some light on this one. When I do the load data local infile, everything drops in fine EXCEPT for the last field in the list. It comes in blank and usually gives me an error. Here is a sample of my .csv file: Texas AM University,College Station, TX,1999,Design, install, test and run blah, blah.,Whatever Industry Here is ONE of the many syntaxes I've tried that looks like it should cover it all: LOAD DATA INFILE 'd:\\text.csv' INTO TABLE projects FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\' ESCAPED BY '\\' LINES TERMINATED BY '\n'; But no. No matter what I try, .txt files, .csv files, with returns, without, the last field always gets dropped. I'm at my wits end, and that's a short trip on a GOOD day. The text file is done in wordpad or notepad and saved as plain text. Running on an NT server. Any help is appreciated. Thanks. Brent - 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: LOAD DATA LOCAL INFILE
[snip] Texas AM University,College Station, TX,1999,Design, install, test and run blah, blah.,Whatever Industry LOAD DATA INFILE 'd:\\text.csv' INTO TABLE projects FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\' ESCAPED BY '\\' LINES TERMINATED BY '\n'; [/snip] Have you tried this... LOAD DATA INFILE 'd:\\text.csv' INTO TABLE projects FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\' ESCAPED BY '\\' LINES TERMINATED BY '\r\n'; HTH! Jay sql,query - 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: LOAD DATA LOCAL INFILE
[snip] Texas AM University,College Station, TX,1999,Design, install, test and run blah, blah.,Whatever Industry LOAD DATA INFILE 'd:\\text.csv' INTO TABLE projects FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\' ESCAPED BY '\\' LINES TERMINATED BY '\n'; Have you tried this... LOAD DATA INFILE 'd:\\text.csv' INTO TABLE projects FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\' ESCAPED BY '\\' LINES TERMINATED BY '\r\n'; [/snip] Can you post a description of your table, DESCRIBE tablename? HTH! Jay sql,query - 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: WinZeos and Transactions
Yes, It's easy to upgrade, but this version of zeoslib is sufficient stable to use? Also what enhancements it has? Thanks for your help. Iago. -Mensaje original- De: Fredrick Bartlett [mailto:[EMAIL PROTECTED]] Enviado el: martes 4 de junio de 2002 17:02 Para: Informatica Handem; Kiss Dániel; [EMAIL PROTECTED] Asunto: Re: WinZeos and Transactions It's easy to upgrade. I just did a search and replace in the .dfm files. Fredrick - Original Message - From: Informatica Handem [EMAIL PROTECTED] To: Kiss Dániel [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 3:00 AM Subject: RE: WinZeos and Transactions Thanks for your help Daniel. I've tried transactions with ZeosDBO 5.3.0 beta6 and it worked well. The problem is that I want not to change zeos component 3.0.3 to 5.3.0 because it changes some things (first changes the names of the components) and I have to change the code of the application. Also ZeosDBO 5.3.0 is supposed to be beta. Iago. -Mensaje original- De: Kiss Dániel [mailto:[EMAIL PROTECTED]] Enviado el: martes 4 de junio de 2002 11:33 Para: [EMAIL PROTECTED] Asunto: Re: WinZeos and Transactions If WinZeos you've written about is the Zeos Database Objects (http://www.zeoslib.org), then I think I know the solution for your problem. First of all you don't have to BEGIN a transaction because when using an InnoDB connection, you always have an apened transaction, and when you close it by COMMIT or ROLLBACK InnoDB will automatically start a new one for you. There must be a TZMySQLTransact component on your palette which must be linked to your TZMySQLDatabase object. And all your TZMySQLQueryes and TZMySQLTable-s have to be linked to it too by their Transaction property. Now you have to AutoCommit property to False and TransactSafe property to True (of the TZMySQLTransact object). And that's all you have to do. Anyway the TZMySQLTransact has it's own Commit and Rollback methods. Use them. The proper documentation of how InnoDB tranasction types work, you can find it in the MySQL manual. Bye, niel At 09:38 2002.06.04.s +0200, you wrote: Hi all. I use WinZeos 3.0.3 to access MySQL 3.23.49 with Delphi 5.0. I'm using InnoDB tables and I want to use transactions. I try to begin a transaction with BEGIN and SET AUTOCOMIT=0 but doesn't work I can see the rows inserted in the database with another connection. What is the problem? The WinZeos components is too old? Iago. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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
Is it possible to have MySQL perform an action at a specifictime?
I have a file containing commands to add and drop tables as a means of synchronizing two databases. What i want to happen is for MySQL to open this file and read it at a specific time without the user having to explicitly connect to MySQL and type in the commands in order to get it to read the file, such as mysql dbname text_file_name. Is there a way to schedule a process either using a function of MySQL or of the operating system to get it to do this? The operating system would be Linux to my knowledge. I am hosting the db on an ISP and am not sure what they will let me do in regards to interacting with MySQL but it is possible to get a telnet connection if need be to perhaps setup a script. if it has to be a shell script, i doubt they will let me do this, but you never know. Also, as another option, is it possible to create a web interface for this instead where a button hit by the user would initiate the reading of the file somehow? This might be easier but I was not sure how to exactly send command line directions from a webpage. Thank you, Jamie Buck - 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: Is it possible to have MySQL perform an action at a specifictime?
[snip] I have a file containing commands to add and drop tables as a means of synchronizing two databases. What i want to happen is for MySQL to open this file and read it at a specific time without the user having to explicitly connect to MySQL and type in the commands in order to get it to read the file, such as mysql dbname text_file_name. Is there a way to schedule a process either using a function of MySQL or of the operating system to get it to do this? The operating system would be Linux to my knowledge. I am hosting the db on an ISP and am not sure what they will let me do in regards to interacting with MySQL but it is possible to get a telnet connection if need be to perhaps setup a script. if it has to be a shell script, i doubt they will let me do this, but you never know. Also, as another option, is it possible to create a web interface for this instead where a button hit by the user would initiate the reading of the file somehow? This might be easier but I was not sure how to exactly send command line directions from a webpage. [/snip] Sounds like you need to run a CRON job (you will have to know if your specific implementation has this.) You can have the CRON run a script that will perform the actions. You can use many script types to accomplish this such as PERL, AWK, PHP (you have to install PHP as a CGI binary) and others. This should give you enough to be able to ask your ISP some questions. HTH! Jay mysql, query, sql - 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: Is it possible to have MySQL perform an action at a specifictime?
Have you looked at cron on LINUX? - Original Message - From: Jamie Buck [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 11:37 AM Subject: Is it possible to have MySQL perform an action at a specifictime? I have a file containing commands to add and drop tables as a means of synchronizing two databases. What i want to happen is for MySQL to open this file and read it at a specific time without the user having to explicitly connect to MySQL and type in the commands in order to get it to read the file, such as mysql dbname text_file_name. Is there a way to schedule a process either using a function of MySQL or of the operating system to get it to do this? The operating system would be Linux to my knowledge. I am hosting the db on an ISP and am not sure what they will let me do in regards to interacting with MySQL but it is possible to get a telnet connection if need be to perhaps setup a script. if it has to be a shell script, i doubt they will let me do this, but you never know. Also, as another option, is it possible to create a web interface for this instead where a button hit by the user would initiate the reading of the file somehow? This might be easier but I was not sure how to exactly send command line directions from a webpage. Thank you, Jamie Buck - 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
Making fulltext index is very slow!!
Hi I have a Huge amounts of data imported into mysql. My database has about 1,500,000 rows.each row has a text field with approx 70 words in it!.Size of my .MYD is 1013MB mysql has been starting to make fulltext index on text field since 55 hours ago!!! and now it dose not accomplish this job yet!! Although my HD is not very fast(128Mb 300MHZ) but this really takes a long time to finish. I've increased size of key_buffer_size and table_cache befor but it still a long time! Dose any body can recommend me any faster solution? TNX in Advance --M. Hajimoradi - 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
Is it possible to have MySQL perform an action at a specifictime?
I have a file containing commands to add and drop tables as a means of synchronizing two databases. What i want to happen is for MySQL to open this file and read it at a specific time without the user having to explicitly connect to MySQL and type in the commands in order to get it to read the file, such as mysql dbname text_file_name. Is there a way to schedule a process either using a function of MySQL or of the operating system to get it to do this? The operating system would be Linux to my knowledge. I am hosting the db on an ISP and am not sure what they will let me do in regards to interacting with MySQL but it is possible to get a telnet connection if need be to perhaps setup a script. if it has to be a shell script, i doubt they will let me do this, but you never know. Also, as another option, is it possible to create a web interface for this instead where a button hit by the user would initiate the reading of the file somehow? This might be easier but I was not sure how to exactly send command line directions from a webpage. Thank you, Jamie Buck - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
a question
I downloaded mysql win 32 1.75-2 and downloaded the GUI for it. How do I tie the SDK to the gui? Pardon me if this sounds vague. AMeet - 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
Left join?
I have the following tables: Member_interests: Member_id Interest_id Interests: Name Interest_id I need a query that selects each interest name, and the # of members who have selected it...sample output: Boating 25 Hiking 10 .. Swimming0 Jumping 0 Talking 0 The following query works great, but does not display the Interest names with 0 members: SELECT DISTINCT(mi.interest_id), COUNT(*) AS count, i.name FROM member_interests AS mi, interests AS i WHERE mi.interest_id = i.id GROUP BY mi.interest_id ORDER BY i.name Is there a way to have the 0's displayed as well? I'm thinking a left join would probably be involved? - 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: Bug related to large tables and it's indexes on Win2k
* Jared Richardson [...] CREATE TABLE IcAlias( IcAliasID BIGINT NOT NULL PRIMARY KEY, mID VARCHAR(255) NOT NULL, IcEntityID BIGINT NOT NULL, IcTypeID SMALLINT NOT NULL, IcDupSortID VARCHAR(255) NOT NULL, INDEX mIDIdx (mID), INDEX IcTypeIDIdx (IcTypeID), INDEX IcEntityIDIdx (IcEntityID), INDEX IcDupSortIDIdx (IcDupSortID)) AVG_ROW_LENGTH=4096 MAX_ROWS=4294967295; Why do you use AVG_ROW_LENGTH=4096? It seems to me the max record length is 528...? Also, you do normally not want an index on 255 characters of a column... have you considered using INDEX mIDIdx (mID(10)) and INDEX IcDupSortIDIdx (IcDupSortID(10)) or similar? -- Roger sql - 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: Making fulltext index is very slow!!
1) Add 1 or 2 gigs of ram 2) Adjust the my.ini (or my.cnf) settings to use it This will get your data into memory and off the disk. This will make it run an order of magnitude faster. Also, you can buy a P4 from Dell for $599. You might want to throw more hardware at the problem. - Original Message - From: Mahdi Hajimoradi [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 2:53 PM Subject: Making fulltext index is very slow!! | Hi | I have a Huge amounts of data imported into mysql. | My database has about 1,500,000 rows.each row has a text | field with approx 70 words in it!.Size of my .MYD is 1013MB | mysql has been starting to make fulltext index on text field since 55 hours | ago!!! | and now it dose not accomplish this job yet!! | Although my HD is not very fast(128Mb 300MHZ) but this really takes a long | time to finish. | I've increased size of key_buffer_size and table_cache befor but it still a | long time! | Dose any body can recommend me any faster solution? | | TNX in Advance | --M. Hajimoradi | | | - | 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
Web Buttons and Command Line Instructions
Is there a way to develop buttons on a webpage that can send command line instructions to MySQL, such as to run a script in a file that already exists on the server? The command line instruction would be as follows: mysql database_name file_name Is it feasible to get this sent to MySQL through a button? - 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: Bug related to large tables and it's indexes on Win2k
I replied below - Original Message - From: Roger Baklund [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 3:24 PM Subject: Re: Bug related to large tables and it's indexes on Win2k | * Jared Richardson | [...] | CREATE TABLE IcAlias( | IcAliasID BIGINT NOT NULL PRIMARY KEY, | mID VARCHAR(255) NOT NULL, | IcEntityID BIGINT NOT NULL, | IcTypeID SMALLINT NOT NULL, | IcDupSortID VARCHAR(255) NOT NULL, | INDEX mIDIdx (mID), | INDEX IcTypeIDIdx (IcTypeID), | INDEX IcEntityIDIdx (IcEntityID), | INDEX IcDupSortIDIdx (IcDupSortID)) | AVG_ROW_LENGTH=4096 MAX_ROWS=4294967295; | | Why do you use AVG_ROW_LENGTH=4096? It seems to me the max record | length is 528...? | According to the MySql docs, the max table size is AVG_ROW_LENGTH * MAX_ROWS We were trying to ensure the maximum amount of growth... this table can grow very very large We'll try an import with only 528 AVG_ROW_LENGTH and see what happens. | Also, you do normally not want an index on 255 characters of a | column... have you considered using INDEX mIDIdx (mID(10)) and | INDEX IcDupSortIDIdx (IcDupSortID(10)) or similar? | Got a build going with that right now! :) 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