Re: Maximum number of tables
Jose, - Original Message - From: JSL [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Monday, September 02, 2002 11:49 PM Subject: Maximum number of tables - Original Message - From: JSL [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 02, 2002 5:05 PM Subject: Maximum number of tables Subject: Maximum number of tables Does anyone know what the maximum number of tables a INNODB can store is? one table occupies at least n pages where 1) n = 1 + the number of indexes, if you have not defined a primary key for the table; 2) n = the number of indexes, if you have defined a primary key. Since there are max 4 billion pages in the tablespace, you can calculate the max number of tables from this formula. We can say InnoDB supports up to 4 billion tables. Thanks, José Lourenço Best regards, 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 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: select using 2 left joins
Hi Jed, you aree totally right. The statement I typed should indeed be: WHERE tableName.manufacturersID=12 Meaning I got the ambiguity error. thx for the tip, Wilbert - Original Message - From: Jed Verity [EMAIL PROTECTED] To: Wilbert Enserink [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, September 02, 2002 6:38 PM Subject: Re: select using 2 left joins I'm a little surprised that MySQL isn't giving you an error on the ambiguity of manufacturersID=12. What happens if you specify tableName.manufacturersID=12? HTH, Jed On the threshold of genius, Wilbert Enserink wrote: Hi all, I'm having troubles with a good selection statement in my query. I have three tables: tableAds, tableProducts and tableManufacturer. They all have unique ID's defined. In the tableProducts there is a column named manufacturerID. So I know which product was made by which manufacturer. In the tableAds I have a column ProductsID so I know what Product is advertised. Now I want to find all the adsvertisments of products which are made by a specific manufacturer. I'm trying a query like: SELECT * FROM tableAds LEFT JOIN tableProducts ON (tableProducts.productsID=tableAds.productsID) LEFT JOIN tableManufacturers ON (tableManufacturers.manufacturersID=tableProducts.manufacturersID) WHERE manufacturersID=12 However this query returns all advertisments in the tableAds and not the Ads wirth manufacturer number 12 involved. Anybody knows how to improve this query? Any help would be much appreciated. thx in advance. Wilbert Enserink - Pas de Deux Van Mierisstraat 25 2526 NM Den Haag tel 070 4450855 fax 070 4450852 http://www.pdd.nl [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 - Pas de Deux Van Mierisstraat 25 2526 NM Den Haag tel 070 4450855 fax 070 4450852 http://www.pdd.nl [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
upgrading v3.2.3 to v4.0.2 and An error occurred during the move data process: -103
Well Well Well , I proceeded in upgrading v3.2.3 to v4.0.2 and An error occurred during the move data process: -103 Component Servers File Group: File: Thus i unzipped mysql-4.0.2-alpha-win.zip into C:\mysql and the above happened I am using excessivly MyODBC to connect to M$ Access 2000 front-end. Please point me in the righrt direction as i really need to get version 4 up and running for transactions (innodb) Cheers Chuckie -- Regards Chuck Amadi ICT Dept Systems Programmer Rhaglenydd Systemau Adran ICT - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Innodb too slow
Hi, why innodb queries work MUCH slower (100 times) than if the table was of myisam type? It's mysql 4.0.3 on FreeBSD 4.5 server. The innodb monitor outputs many messages like the following, why are they there and what do they mean? Purge done for trx's n:o 0 782 undo n:o 0 0 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 3811, ACTIVE 0 sec, OS thread id 10250 fetching rows MySQL thread id 2, query id 3044 localhost handy Sending data SELECT count(*) from stat Trx read view will not see trx with id = 0 3812, sees 0 3807 ---TRANSACTION 0 3810, ACTIVE 1 sec, OS thread id 12300 fetching rows MySQL thread id 4, query id 3043 localhost handy Sending data SELECT count(*) from stat Trx read view will not see trx with id = 0 3811, sees 0 3806 ---TRANSACTION 0 3809, ACTIVE 1 sec, OS thread id 13325 fetching rows MySQL thread id 5, query id 3042 localhost handy Sending data SELECT count(*) from stat Trx read view will not see trx with id = 0 3811, sees 0 3806 ---TRANSACTION 0 3808, ACTIVE 1 sec, OS thread id 14350 fetching rows MySQL thread id 6, query id 3041 localhost handy Sending data SELECT count(*) from stat Trx read view will not see trx with id = 0 3809, sees 0 3804 ---TRANSACTION 0 3807, ACTIVE 1 sec, OS thread id 11275 fetching rows MySQL thread id 3, query id 3040 localhost handy Sending data SELECT count(*) from stat Trx read view will not see trx with id = 0 3808, sees 0 3803 Any help will be appreciated, thanks! Alexander Varshavchick, Metrocom Joint Stock Company Phone: (812)118-3322, 118-3115(fax) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql_real_connect - capi
I am using c to write some basic mysql programs and I cannot seem to get past mysql_real_connect. I get an access denied message. It does not recognize the password user combination. I set the usr/pswd up with the admin progrram and can get into mysql fine. One thing I noticed on the error message is the full host and domain name are appended to the usr and the password is being used. My statement looks like: connect = mysql_real_connect(mysql,prod.home.com,root,fakepswd,,0,0,0) ; Thanks for the help in advance. BB - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 v3.2.3 to v4.0.2 and An error occurred during the move data process: -103
At 08:41 03/09/02 +0100, Chuck Amadi wrote: Hi, Well Well Well , I proceeded in upgrading v3.2.3 to v4.0.2 and An error occurred during the move data process: -103 Shutdown the current installed server or install 4.0.X on another directory. Component Servers File Group: File: Thus i unzipped mysql-4.0.2-alpha-win.zip into C:\mysql and the above happened I am using excessivly MyODBC to connect to M$ Access 2000 front-end. Please point me in the righrt direction as i really need to get version 4 up and running for transactions (innodb) Cheers Chuckie -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel Angel Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ 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
innodb vs myisam performance
Hi, I've just ran a benchmark test to compare Innodb and MyISAM, and I just want some input from you guys which already using Innodb ;-) I have two tables : same definition and same records Innodb table name : CUSTOMER MyISAM table name : CUSTOMER2 and this is what I found on my queries : - select * from CUSTOMER where CUST_ID like %bing; 294 rows in set (56.46 sec) select * from CUSTOMER2 where CUST_ID like %bing; 294 rows in set (18.99 sec) - mysql select count(*) from CUSTOMER; +--+ | count(*) | +--+ | 1673406 | +--+ 1 row in set (7.37 sec) mysql select count(*) from CUSTOMER2; +--+ | count(*) | +--+ | 1673406 | +--+ 1 row in set (0.01 sec) - mysql update CUSTOMER set CUST_VALID_HP=1 where CUST_COUNTRY_CODE=ID; Query OK, 228323 rows affected (1 min 11.72 sec) Rows matched: 718424 Changed: 228323 Warnings: 0 mysql update CUSTOMER2 set CUST_VALID_HP=1 where CUST_COUNTRY_CODE=ID; Query OK, 228323 rows affected (1 min 49.11 sec) Rows matched: 718424 Changed: 228323 Warnings: 0 Are these results normal Is it true that select query on Innodb slower than on MyISAM ? What are the reasons ? Thanks. -- Don't patch bad code - rewrite it. - The Elements of Programming Style (Kernighan Plaugher) MySQL 3.23.51 : up 74 days, Queries : 357.886 per second (avg). -- Dicky Wahyu Purnomo - System Administrator PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan 12790 Phone : +62 21 79199577 - HP : +62 8551044244 - Web : http://www.1rstwap.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: build under Win32 - thanks
Thank you very much for help. Nick. 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
Order by date
Hi, I have a query from tables that give me records with two date date1 and date2. How can I order the records by the most recent date (between the two date) for each records ? Example: Data: IDdescriptiondate1date2 1 aaa09/03/02 09/05/02 2 bbb 09/04/02 3 ccc 09/02/02 09/10/02 Result: IDdescriptiondate 3 ccc 09/02/02 1 aaa09/03/02 2 bbb09/04/02 Thanks Xavier - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 daemon after reboot (after initial install)
Bill, Tuesday, September 03, 2002, 6:08:57 AM, you wrote: BF I installed 3.23.52 on a RedHat 7.3 machine. Everything was just fine until I BF rebooted later for another reason. Now I can't start the daemon. I tried BF deleting /var/lib/mysql/mysql.sock as root. It deleted, but to no avail. Any BF idea what I have done wrong? I don't understand sockets. They're magic to me. BF ps shows no daemon running. mysqladmin also show no daemon and won't ping BF ...Bill BF -- BF [username $] /usr/sbin/mysqld BF 020902 20:58:00 Can't start server : Bind on unix socket: Permission denied BF 020902 20:58:00 Do you already have another mysqld server running on socket: BF /var/lib/mysql/mysql.sock ? BF 020902 20:58:00 Aborting BF 020902 20:58:00 /usr/sbin/mysqld: Shutdown Complete Check if there is another MySQL server running. Check permissions on the MySQL data dir. -- 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: Install questions
Matt, Monday, September 02, 2002, 8:33:36 PM, you wrote: MTW I just installed MySQL from RPM and can connect to it via shell using MTW the MySQL command, but I can't get anything else to connect to it. MTW MySQL Connection Failed: Can't connect to local MySQL server through MTW socket '/tmp/mysql.sock' (2) Check if MySQL server is running. If so, find where mysql.sock is located (/var/lib/mysql ?) and specify path to the socket for the client. Or you can also create a symlink. -- 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: Inno DB Question
Heikki,
Thanks for your answer. I was yesterday making other tests using dbExpress
components and the only way that I found so far to get the dbExpress
components working on transactions on MySQL is using the method ExcuteDirect
of the TSQLConnection. This is the code :
TSQLConnection *Conn;
Conn = SQLConnection1-CloneConnection();
Conn-Connected=true;
Conn-ExecuteDirect(BEGIN);
Conn-ExecuteDirect(INSERT INTO regn_info VALUES('t3','test1'));
Conn-ExecuteDirect(INSERT INTO regn_info VALUES('t4','test2'));
Conn-ExecuteDirect(COMMIT);
But I don't know why is impossible to do the same using the normal
TSQLQuery. I already sent the message to the borland newsgroups.
Thanks
Javier
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: 02 September 2002 20:06
To: [EMAIL PROTECTED]
Subject: Re: Inno DB Question
Javier,
it may be that the dbExpress interface is still lagging behind MySQL
development.
If I recall right, people have complained loudly in Borland newsgroups that
dbExpress created a new connection for each SQL query it issues to MySQL.
That makes the use of transactions impossible with it.
If this has not been fixed in the latest version of dbExpress, it would be
good if you would write to Borland people about this, or to the Borland
newsgroups.
Regards,
Heikki
Innobase Oy
- Original Message -
From: Javier Diaz [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Monday, September 02, 2002 3:06 PM
Subject: Inno DB Question
Hi all,
I'm using MySQL 4.0.2 alpha-max with Inno DB and Borland Builder 6.0 to
connect to MySQL. I'm trying to use the new dbExpress component for
Borland
to connect to MySQL using the libmysql.dll
I have been making some tests with transactions using the dbExpress
components and the normal ODBC but I can't get the ROLLBACK function to
work.
Here are some examples:
using dbExpress
TSQLConnection Q;
Q= new TSQLQuery(Application);
Q-SQLConnection=SQLConnection1;
/* I test with and without BEGIN
Q-SQL-Clear();
Q-SQL-Add(BEGIN);
Q-ExecSQL();
*/
Q-SQL-Clear();
Q-SQL-Add(SET AUTOCOMMIT=0);
Q-ExecSQL();
Q-SQL-Clear();
Q-SQL-Add(INSERT INTO regn_info VALUES('t1','test1'));
Q-ExecSQL();
Q-SQL-Clear();
Q-SQL-Add(INSERT INTO regn_info VALUES('t2','test2'));
Q-ExecSQL();
Q-SQL-Clear();
Q-SQL-Add(ROLLBACK);
Q-ExecSQL();
//--
Using ODBC
TQuery *Q_ODBC;
Q_ODBC= new TQuery(Application);
Q_ODBC-DatabaseName=salsadb;
/*
Q-SQL-Clear();
Q-SQL-Add(BEGIN);
Q-ExecSQL();
*/
Q_ODBC-SQL-Clear();
Q_ODBC-SQL-Add(SET AUTOCOMMIT=0);
Q_ODBC-ExecSQL();
Q_ODBC-SQL-Clear();
Q_ODBC-SQL-Add(INSERT INTO regn_info VALUES('t1','test1'));
Q_ODBC-ExecSQL();
Q_ODBC-SQL-Clear();
Q_ODBC-SQL-Add(INSERT INTO regn_info VALUES('t2','test2'));
Q_ODBC-ExecSQL();
Q_ODBC-SQL-Clear();
Q_ODBC-SQL-Add(ROLLBACK);
Q_ODBC-ExecSQL();
In both cases the ROLLBACK dosen't work and I get the inserted values in
the
table.
Any idea what can be happening?
Thanks a lot
Javier Diaz
--
This e-mail is intended for the named addressee only. It may contain
confidential and/or privileged information. If you have received this
message in error, please let us know and then delete this message from your
system. You should not copy the message, use it for any purpose or disclose
its contents to anyone.
This e-mail has been scanned for all viruses by Star Internet. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
*Scanned for all known viruses by Messagelabs*
This e-mail has been scanned for all viruses by Star Internet. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
MySQL Backup
Hi, can someone point me in the right direction please regarding backing up a MySQL database using Veritas 8.6 on a Windows 2000 server? Is there a script I can use to dump the database to a cold file where I can back it up off-line or are there agents available to enable me to back the database up live. Many thanks in advance Tom Tom McCay Delivery Consultancy Ramesys (e-Business Services) Ltd Tel: 0115 971-2000 Mobile: 07721 066104 Mail: [EMAIL PROTECTED] ** This communication contains information that is confidential and may also be privileged. Any offers and/or commitments made within this document are subject to contract and without prejudice. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information within it is strictly prohibited and may be unlawful. If you have received this communication in error, please return it with the subject line received in error to [EMAIL PROTECTED] then delete the mail and destroy any copies of it. www.ramesys.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: Order by date
Xavier, select ID, description, if (ifnull(date1, 20201231) ifnull(date2, 20201231), ifnull(date1, 20201231), ifnull(date2, 20201231)) as date from MyTable order by date I didn't test it, but it should work. Any questions? don't hesitate to ask. Best regards, Mikhail. - Original Message - From: Xavier NOPRE [EMAIL PROTECTED] To: Mailing list MySql [EMAIL PROTECTED] Sent: Tuesday, September 03, 2002 11:18 AM Subject: Order by date Hi, I have a query from tables that give me records with two date date1 and date2. How can I order the records by the most recent date (between the two date) for each records ? Example: Data: IDdescriptiondate1date2 1 aaa09/03/02 09/05/02 2 bbb 09/04/02 3 ccc 09/02/02 09/10/02 Result: IDdescriptiondate 3 ccc 09/02/02 1 aaa09/03/02 2 bbb09/04/02 Thanks Xavier - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL Backup
-Original Message- From: Tom McCay (Ramesys - Nottingham) [mailto:[EMAIL PROTECTED]] Sent: 3. september 2002 11:59 To: [EMAIL PROTECTED] Subject: MySQL Backup Hi, can someone point me in the right direction please regarding backing up a MySQL database using Veritas 8.6 on a Windows 2000 server? Is there a script I can use to dump the database to a cold file where I can back it up off-line or are there agents available to enable me to back the database up live. I usually just copy the complete DB directory from one computer to another one. With fast ethernet it takes around 5-10 minutes (30 minutes if I have to backup the table where I store images). Only thing is that mysql can't write to the table currently being copied. But that's not much of a problem, since I do the copy in the wee hours of the night, when almost no one uses the server. Is this a 'stupid' thing to do? I've done this for some time and nothing has gone wrong, no data corrupted either. Running source compiled 4.0.2-alpha: Uptime: 70 days 6 hours 42 min 24 sec Threads: 11 Questions: 215514424 Slow queries: 613 Opens: 87 Flush tables: 1 Open tables: 59 Queries per second avg: 35.492 Erlend Stromsvik - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Backup
Hello! Erlend Hopsø Strømsvik wrote: -Original Message- From: Tom McCay (Ramesys - Nottingham) [mailto:[EMAIL PROTECTED]] Sent: 3. september 2002 11:59 To: [EMAIL PROTECTED] Subject: MySQL Backup Hi, can someone point me in the right direction please regarding backing up a MySQL database using Veritas 8.6 on a Windows 2000 server? Is there a script I can use to dump the database to a cold file where I can back it up off-line or are there agents available to enable me to back the database up live. I usually just copy the complete DB directory from one computer to another one. With fast ethernet it takes around 5-10 minutes (30 minutes if I have to backup the table where I store images). Only thing is that mysql can't write to the table currently being copied. But that's not much of a problem, since I do the copy in the wee hours of the night, when almost no one uses the server. If you are copying the data from one computer to the other, why not installing a little mysql on the backup machine and replicate to that mysql? With only inserts/deletes/updates done on the replication machine, there is no high load to be expected and you have an up-to-date copy all the time. Is this a 'stupid' thing to do? I've done this for some time and nothing has gone wrong, no data corrupted either. Running source compiled 4.0.2-alpha: Uptime: 70 days 6 hours 42 min 24 sec Threads: 11 Questions: 215514424 Slow queries: 613 Opens: 87 Flush tables: 1 Open tables: 59 Queries per second avg: 35.492 Greetings Ralf -- Ralf Narozny Besuchen Sie uns auf der DMS-Expo. SAP, Dokumenten- management oder das komplette Office ins Portal einbinden? Wir zeigen es Ihnen - vom 3. bis 5.9. auf der Messe Essen Halle 3, Stand 3255 SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
link under Win32 for udf
Hello. It's anew me. And how linking under Win32 with --with-mysqld-ldflags=-rdynamic? I need UDF. Thanks in advance. Nick. mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
GRANT not working
I have a new installation of RedHat 7.3 and MySql. I had MySql working great on a Mandrake 8.0 installation. Now that I have reloaded this box with RH, I cannot get setup and working. I can run mysql as root and get in. I ran the commands below: grant all on * to amp identified by 'blahdblah'; flush privileges; Now when I run mysql like this: $mysql -u amp -pblahdblah I get the following error: ERROR 1045: Access denied for user: 'amp@localhost' (Using password: YES) I have a sneaking suspicion about the host but I don't know how to fix it. Thanks for any help. Andrew - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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.2a Bind-Address problem
Hi all, I just tried 4.0.3beta and it doesn't seem to address the bind-address problem at all. When I include the option in the ini file and run mysql-max-nt --help, it stops showing the variables when it reaches bind-address variable and a window pops up with the following message: The instruction at 0x005c89eb referenced memory at 0xb000a8c0. The memory could not be read. Regards, Michael - Original Message - From: Victoria Reznichenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 27, 2002 3:57 AM Subject: Re: MySql 4.0.2a Bind-Address problem Michael, Tuesday, August 27, 2002, 12:40:31 PM, you wrote: MTI tried to use config. variable 'bind-address' for MySQL 4.0.2a MT (mysqld-max-nt) to assign a particular ip for the server. However, I got MT the following error: MT E:\mysql4.0.2a\binmysqld-max-nt --help MT Unknown suffix '.' used for variable 'bind-address' (value '192.168.0.176') MT mysqld-max-nt: Error while setting value '192.168.0.176' to 'bind-address' MT my .ini segment as follow: MT # The MySQL server MT [mysqld] MT port=3306 MT skip-name-resolve MT bind-address=192.168.0.176 MT It's a known bug and it is fixed in 4.0.3 -- 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 not working
I believe that your problem is specifically with RedHat. I've ran it on just about every incarnation of Linux from Mandrake to Gentoo. The only one that I have ever had a problem getting MySQL to run on was RedHat 7.x and I've even run it on things like OpenMosix (www.openmosix.org) and Scyld. Tried RedHat versions from 7.0 to 7.3, none of them will run, install any other distro, it works from the start. Don't matter whether it's MySQL 3.x or 4.x, it won't work for me or anyone else I know with RedHat. Hope that helps you with your problem. Matt - Original Message - From: Andrew Pierce [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 03, 2002 7:06 AM Subject: GRANT not working I have a new installation of RedHat 7.3 and MySql. I had MySql working great on a Mandrake 8.0 installation. Now that I have reloaded this box with RH, I cannot get setup and working. I can run mysql as root and get in. I ran the commands below: grant all on * to amp identified by 'blahdblah'; flush privileges; Now when I run mysql like this: $mysql -u amp -pblahdblah I get the following error: ERROR 1045: Access denied for user: 'amp@localhost' (Using password: YES) I have a sneaking suspicion about the host but I don't know how to fix it. Thanks for any help. Andrew - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL Backup
I usually just copy the complete DB directory from one computer to another one. With fast ethernet it takes around 5-10 minutes (30 minutes if I have to backup the table where I store images). Only thing is that mysql can't write to the table currently being copied. But that's not much of a problem, since I do the copy in the wee hours of the night, when almost no one uses the server. If you are copying the data from one computer to the other, why not installing a little mysql on the backup machine and replicate to that mysql? With only inserts/deletes/updates done on the replication machine, there is no high load to be expected and you have an up-to-date copy all the time. This 'manual' copy is for the drive I take home. To provide a backup in case the office burns down or someone decides to 'remove' the server. Also, replication does not provide cover for human mistakes, done with intention or just by being clueless. A delete from table.this is just as devestating on both master and slave. Going to buy this one soon: http://www.allmediait.com/html/araid.html Just to test out how to do an easy and complete systembackup. Also replication does not take care of the backup needed of all the other data and programs on the server. erlend stromsvik - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 not working
I personally have never had a problem with Redhat. Andrew try this: grant all privileges on *.* to 'amp'@'%' identified by 'blah' (with grant option) ; let me know if it works. - Original Message - From: Matt Hargraves [EMAIL PROTECTED] To: Andrew Pierce [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, September 03, 2002 7:22 PM Subject: Re: GRANT not working I believe that your problem is specifically with RedHat. I've ran it on just about every incarnation of Linux from Mandrake to Gentoo. The only one that I have ever had a problem getting MySQL to run on was RedHat 7.x and I've even run it on things like OpenMosix (www.openmosix.org) and Scyld. Tried RedHat versions from 7.0 to 7.3, none of them will run, install any other distro, it works from the start. Don't matter whether it's MySQL 3.x or 4.x, it won't work for me or anyone else I know with RedHat. Hope that helps you with your problem. Matt - Original Message - From: Andrew Pierce [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 03, 2002 7:06 AM Subject: GRANT not working I have a new installation of RedHat 7.3 and MySql. I had MySql working great on a Mandrake 8.0 installation. Now that I have reloaded this box with RH, I cannot get setup and working. I can run mysql as root and get in. I ran the commands below: grant all on * to amp identified by 'blahdblah'; flush privileges; Now when I run mysql like this: $mysql -u amp -pblahdblah I get the following error: ERROR 1045: Access denied for user: 'amp@localhost' (Using password: YES) I have a sneaking suspicion about the host but I don't know how to fix it. Thanks for any help. Andrew - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: GRANT not working
On Tue, 2002-09-03 at 13:22, Matt Hargraves wrote: Tried RedHat versions from 7.0 to 7.3, none of them will run, install any other distro, it works from the start. Don't matter whether it's MySQL 3.x or 4.x, it won't work for me or anyone else I know with RedHat. I am running mysql 3.23.49 on RH7.3, I did not specify the identified by part, but I was able to (as root) create a db and grant a normal user all privileges to it. Everything was working fine as far as I've tried it... grant all on * to amp identified by 'blahdblah'; flush privileges; I also did not use the flush privileges command, I simply logged out of mysql and logged back in... $mysql -u amp -pblahdblah The command I use to start mysql as user is simply mysql --local-infile=1 (to be able to insert data from a file. This probably doesn't help that musch but at least you'll know it should be possible... Regards, -- # Mertens Bram M8ram [EMAIL PROTECTED] Linux User #249103 # # Red Hat Linux 7.3 KDE 3.0.0-10 kernel 2.4.18-3 i686 128MB RAM # - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
about several selects/inserts
Hi, I would like to know if you could help me to solve the following problem: The application I developed needs to run several selects, inserts and updates all the time. When the clients are selecting data, mySql runs the selects at the same time, but when an update command starts executing, all other clients have to wait until the command have finished. I know that it is the way mySql runs: Multiple reads but only one write. But I wonder what can I do to allow writes and reads to run at the same time, because some times one client starts a big select and all other clients have to wait almost one minute before executing their inserts and updates. My users are now turning off their computers because they think the computers have frozen. All your ideas will be very much welcome. My application uses mySql (3.23.52) and Windows 2000 Server running on a 1Gb-DELL-2processors machine with MYISAM table handler ! - ++ Dyego Souza do Carmo ++ Dep. Desenvolvimento - E S C R I B A I N F O R M A T I C A - The only stupid question is the unasked one (somewhere in Linux's HowTo) Linux registred user : #230601 -- $ look into my eyes look: cannot open my eyes - Reply: [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
script for complete Database dump?
is there any single MySQL script that would backup my complete database? thanks! Kai - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
host field in tables_priv
Hi I'm new to mysql and i'm trying to understand the privileges table. With the following configuration of the user table +---+--+ | host | user | +---+--+ | % | robber | | 192.168.0.0/255.255.255.0 | phpuser | | 192.168.0.0/255.255.255.0 | root | | localhost | root | +---+--+ and of the tables_priv +---+-+--+-+ | host | db | user | table_name | +---+-+--+-+ | 192.168.0.0/255.255.255.0 | esempio | phpuser | utenti | | localhost | esempio | phpuser | utenti | | port1 | mysql | phpadmin | db | | port1 | mysql | phpadmin | tables_priv | | port1 | mysql | phpadmin | user| +---+-+--+-+ the phpuser can connect fron the internal network but gets the following error when selects ERROR 1142: select command denied to user: 'phpuser@linux' for table 'utenti' It works only if I change to the followings assigning explicitly the name of the host: +---+-+--+-+ | host | db | user | table_name | +---+-+--+-+ | linux | esempio | phpuser | utenti | | localhost | esempio | phpuser | utenti | | port1 | mysql | phpadmin | db | | port1 | mysql | phpadmin | tables_priv | | port1 | mysql | phpadmin | user| +---+-+--+-+ Why? from the manual it doesn't happen. If anyone can help me thanks in advance. -- --- Roberto Bernetti e-mail: [EMAIL PROTECTED] V. S.da Vecchia del Pinocchio 1/A 60131 ANCONA tel/fax 071 2867103 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: script for complete Database dump?
use mySQLdump. c:\mysql\bin\mysqldump.exe there is a switch for dumping the whole DB. heh, .b -Original Message- From: Kai Vermehr [mailto:[EMAIL PROTECTED]] Sent: 03 September 2002 13:10 To: MySQL List Subject: script for complete Database dump? is there any single MySQL script that would backup my complete database? thanks! Kai - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Rowlevel Locking
Hi, I have did setup for MySQL - Innodb tables. But I am not getting support for row level locks. Whenever I am issuing a update the innodb tables are locking my tables. Please help me whether I need to set any variables in sqld file to get the support for row level locks ??? Regards, Sekhar - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem with ALTER query
Ramanathan, Saturday, August 31, 2002, 3:54:27 PM, you wrote: RPS I have two connections open to a mysql-nt server. I am using one RPS connection to add a field field to a table using the command RPS ALTER TABLE testtable ADD testfield int; RPS Now if I issue any query from the second connection, the mysql-nt daemon RPS crashes with a Dr.Watson error. The but if I open a new connection it works RPS fine. Only connections open at the time of table alteration have problem RPS Can anyone help me to overcome this problem What version of MySQL do you use? I just tested it and all worked like a charm. Could you provide a repeatable test case? -- 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: primary/foreign key contraints
neal, Tuesday, September 03, 2002, 4:06:37 AM, you wrote: n Sorry for the MySQL newbie question ... but are there not primary/foreign n key constraints in MySQL 3? I can't imagine that this is right. Perhaps n I'm just overlooking something Foreign keys constraints is supported in InnoDB tables: http://www.mysql.com/doc/en/ANSI_diff_Foreign_Keys.html http://www.mysql.com/doc/en/SEC447.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: script for complete Database dump?
Kai, Tuesday, September 03, 2002, 3:09:45 PM, you wrote: KV is there any single MySQL script that would backup my complete database? What about mysqldump? http://www.mysql.com/doc/en/mysqldump.html -- 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
Datafiles on raw devices
I've heard that MySQL 4.x can use raw devices on Linux, I'm curious to learn more. Are some speed tests available? Where I can find documentation? I can realize InnoDB tablespaces can benefit from bypassing the filesystem overhead, but one of MySQL advantages is it's based on files you can move/backup easily: is this also the case with raw devices? I mean, how can you backup a tablespace live if you can't use mysqlhotcopy? You have to switch mysqld off and use dd, or you have to use mysqldump to dump the database, otherwise you loose data integrity I guess. Does someone thought a solution? Is this feature Linux only, or FreeBSD also? Thank you, -- Gianluca Sordiglioni DB Manager vox2web srl - gruppo OmniaNetwork spa phone: +39 02 45054533 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Problem with ORDER BY
turn them back into numbers with a math function
ORDER BY ABS(value)
-Original Message-
From: Jürgen Müller [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 30, 2002 5:23 PM
To: [EMAIL PROTECTED]
Subject: Add: Problem with ORDER BY
I've changed my query to:
$order = SUBSTRING_INDEX(objektname,'-',1);
$order .=
,RIGHT(objektname,(LENGTH(objektname)-LOCATE('-',objektname)));
so that the syntax ist okay, and the tests too:
mySQL returns the correct values:
objekt SUBSTRING_INDEX(objekt,'-',1) LENGTH(objekt)
LOCATE('-',objekt) RIGHT(...)
MD1-1234 MD1 8
4 1234
MD1-32MD1 6
4 32
SD1-1 SD1 5
4 1
But the search-results are not ordered corectly. Perhaps i
can transform
the numbers int integer? I think they are stil handled as string...
Greetings,
Jürgen
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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
Fwd: Re: MySQL 3.23.52
Forwarded Message: To: Martin Brülisauer [EMAIL PROTECTED] From: [EMAIL PROTECTED] Subject: Re: MySQL 3.23.52 Date: Tue, 3 Sep 2002 14:15:42 +0200 - Your message cannot be posted to [EMAIL PROTECTED] because it did not follow the format expected by our spam/off-topic filter. To this list we accept only repeatable bugs reports, meaning that you can describe a set of steps we can follow to repeat the bug on our systems. If you are having problems with MySQL but are unable to provide the required description, and have not purchased a support contract from MySQL AB, you should send your message to [EMAIL PROTECTED] and possibly one of our knowledgable users or developers will help you. However, we do not guarantee that every message on [EMAIL PROTECTED] will be answered. We can afford to provide free code, but unfortunately, we cannot afford to provide guaranteed free support on top of that. We do, nevertheless, fix our bugs regardless of who reports them and whose systems they affect, and will investigate your problem if you can prove to us with a test case that the error is in our code and not yours. If you have purchased a support contract from MySQL AB, you should follow the standard support request procedure to report this problem. Support contracts are available at https://order.mysql.com/. If you are able to describe how we can repeat the problem, include the string How-To-Repeat: in the body of your message, followed by the detailed description of what we need to do to make it happen, and our filter will accept your message. If you use mysqlbug script, which comes with the MySQL distribution, to post the message, it will be automatically accepted. You have written the following: ---start of your message Hi, When compiling MySQL 3.23.52 on Linux/Alpha 2.4.19 using - gcc 3.2.1 (snapshot 20020901) - binutils 2.13 (release) - glibc-2.2.92 (snapshot (20020901) I have to compile the c++ modules with the optimization -O1 instead of -O4 (default). With -O4 MyISAM tables are sometimes (random) wrong. Fields of type INT(11) are shown and used as INT(11), zerofill. Due to lack of time I did not analyze where the problem is but I guess somewhere in sql_analyze.cc. When creating the tables and MySQL is started with enable-log, I can see the correct CREATE TABLE statements. After the create DESCRIBE TABLENAME produces the wrong result and if I insert tuples and read them back, they are zerofilled. This problem exists also using: - MySQL 2.23.51 (on any compiler/binutils combination). - gcc-3.2 (release) - gcc-3.1.1 (release) - gcc-3.1 (release) - gcc-3.0.4 (release) - binutils-2.10.0.33 (release) - glibc-2.2.5 (release) - glibc-2.2 (release) Workaround: Change the -O4 flag to -O1 in the Makefile. With best regards, Martin Brulisauer [EMAIL PROTECTED] ---end of your message--- MySQL Development Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Inno DB Question
Javier,
- Original Message -
From: Javier Diaz [EMAIL PROTECTED]
To: 'Heikki Tuuri' [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED] (E-mail) [EMAIL PROTECTED]
Sent: Tuesday, September 03, 2002 12:32 PM
Subject: RE: Inno DB Question
Heikki,
Thanks for your answer. I was yesterday making other tests using dbExpress
components and the only way that I found so far to get the dbExpress
components working on transactions on MySQL is using the method
ExcuteDirect
of the TSQLConnection. This is the code :
TSQLConnection *Conn;
Conn = SQLConnection1-CloneConnection();
Conn-Connected=true;
Conn-ExecuteDirect(BEGIN);
Conn-ExecuteDirect(INSERT INTO regn_info VALUES('t3','test1'));
Conn-ExecuteDirect(INSERT INTO regn_info VALUES('t4','test2'));
Conn-ExecuteDirect(COMMIT);
if the above works, that is good. I actually recommend using explicit SQL
commands to commit or rollback a transaction, because they are the most
probable to work with old interfaces to MySQL. You also know then best what
commands you are actually sending to the MySQL server.
I assume you also tested ROLLBACK? Did you test that 2 connections keep
locks as expected, i.e., if one user has not committed his insert, then
another user has to wait if he issues SELECT ... FOR UPDATE which should
read that inserted row?
But I don't know why is impossible to do the same using the normal
TSQLQuery. I already sent the message to the borland newsgroups.
Thanks
Javier
Thanks you,
Heikki
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: 02 September 2002 20:06
To: [EMAIL PROTECTED]
Subject: Re: Inno DB Question
Javier,
it may be that the dbExpress interface is still lagging behind MySQL
development.
If I recall right, people have complained loudly in Borland newsgroups
that
dbExpress created a new connection for each SQL query it issues to MySQL.
That makes the use of transactions impossible with it.
If this has not been fixed in the latest version of dbExpress, it would be
good if you would write to Borland people about this, or to the Borland
newsgroups.
Regards,
Heikki
Innobase Oy
- Original Message -
From: Javier Diaz [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Monday, September 02, 2002 3:06 PM
Subject: Inno DB Question
Hi all,
I'm using MySQL 4.0.2 alpha-max with Inno DB and Borland Builder 6.0 to
connect to MySQL. I'm trying to use the new dbExpress component for
Borland
to connect to MySQL using the libmysql.dll
I have been making some tests with transactions using the dbExpress
components and the normal ODBC but I can't get the ROLLBACK function to
work.
Here are some examples:
using dbExpress
TSQLConnection Q;
Q= new TSQLQuery(Application);
Q-SQLConnection=SQLConnection1;
/* I test with and without BEGIN
Q-SQL-Clear();
Q-SQL-Add(BEGIN);
Q-ExecSQL();
*/
Q-SQL-Clear();
Q-SQL-Add(SET AUTOCOMMIT=0);
Q-ExecSQL();
Q-SQL-Clear();
Q-SQL-Add(INSERT INTO regn_info VALUES('t1','test1'));
Q-ExecSQL();
Q-SQL-Clear();
Q-SQL-Add(INSERT INTO regn_info VALUES('t2','test2'));
Q-ExecSQL();
Q-SQL-Clear();
Q-SQL-Add(ROLLBACK);
Q-ExecSQL();
//--
Using ODBC
TQuery *Q_ODBC;
Q_ODBC= new TQuery(Application);
Q_ODBC-DatabaseName=salsadb;
/*
Q-SQL-Clear();
Q-SQL-Add(BEGIN);
Q-ExecSQL();
*/
Q_ODBC-SQL-Clear();
Q_ODBC-SQL-Add(SET AUTOCOMMIT=0);
Q_ODBC-ExecSQL();
Q_ODBC-SQL-Clear();
Q_ODBC-SQL-Add(INSERT INTO regn_info VALUES('t1','test1'));
Q_ODBC-ExecSQL();
Q_ODBC-SQL-Clear();
Q_ODBC-SQL-Add(INSERT INTO regn_info VALUES('t2','test2'));
Q_ODBC-ExecSQL();
Q_ODBC-SQL-Clear();
Q_ODBC-SQL-Add(ROLLBACK);
Q_ODBC-ExecSQL();
In both cases the ROLLBACK dosen't work and I get the inserted values in
the
table.
Any idea what can be happening?
Thanks a lot
Javier Diaz
--
This e-mail is intended for the named addressee only. It may contain
confidential and/or privileged information. If you have received this
message in error, please let us know and then delete this message from
your
system. You should not copy the message, use it for any purpose or
disclose
its contents to anyone.
This e-mail has been scanned for all viruses by Star Internet. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL
RE: Euro sign mysql
Hi Tod, What happens if you escape the string first, like with DBD's quoting function? Sorry i don't know it, how should i use this function? Still, the error message is a bit odd. Perhaps it isn't even Mysql's fault... How are you connecting? Using the mysql client. thx Derk On Monday 02 September 2002 09:27 am, Derk van der Harst wrote: Hello everyone, how can I insert records with the Euro sign into the mysql database? When i try to insert the euro sign i get the err message 'query is empty'. Can somebody help? thanks Derk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Rowlevel Locking
Sekhar, do your updates have good indexes through which they can access only the rows they are going to update? From section 8.4 of http://www.innodb.com/ibman.html: UPDATE ... SET ... WHERE ... : sets an exclusive next-key lock on every record the search encounters From section 8.5: a.. Add good indexes to your tables. Then your queries need to scan less index records and consequently set less locks. Use EXPLAIN SELECT to determine that MySQL picks appropriate indexes for your queries. Best regards, Heikki Innobase Oy (sql query) Copied message: ... Hi, I have did setup for MySQL - Innodb tables. But I am not getting support for row level locks. Whenever I am issuing a update the innodb tables are locking my tables. Please help me whether I need to set any variables in sqld file to get the support for row level locks ??? Regards, Sekhar - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 ?
It think MySQL could very well have corrupted the data back in 3.23.38 for Marian when I first started out using mysql, I was fairly new to linux and totally new to MySQL MySQL default install went to /var/lib/mysql, default RedHat /var is quite small So unknowingly to me, it filled up quite quickly, and MySQL did indeed keep on chugging, and my data did indeed get totally trashed Since no other daemons were running that would write to /var (not even mail) then my finger was pointing at mysql I was also running replication at the time, so that may have also been a problem, mind you I was able to succesfully restore from the slave datasets ( i believe it did not send any more updates to the slave once the filesystem was full ) dunno, just an experience I had to share -Original Message- From: Mark Matthews [mailto:[EMAIL PROTECTED]] Sent: Monday, September 02, 2002 10:22 AM To: Nairam Cc: [EMAIL PROTECTED] Subject: Re: Bug ? Marian wrote: Why mysql corrupt tables if filesystem if full ... ? On good database servers (eg. PROGRESS) process shutdown server (protetcting data). sytem: linux-2.2.19 mysql-3.23-38 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php What table types are you using? MySQL doesn't usually corrupt tables when the disk is full, it handles it in the following way: http://www.mysql.com/doc/en/Full_disk.html Also, you're using a pretty old version of MySQL, you might want to upgrade to a newer version if possible. The latest version in the 3.23 series is 3.23.52 -- For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mark Matthews [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL 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
How Many Fields
What is the limit on amount of fields in a MYSQL table. Access / lotus will only do 255, whereas Filemaker will do over Hopefully someone will tell me it is more than 459 (that is what I need in mine). Thanks Brian Leyland - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Row level Locking
Hi, I have did setup for MySQL - Innodb tables. But I am not getting support for row level locks. Whenever I am issuing a update the innodb tables are locking my tables. Please help me whether I need to set any variables in sqld file to get the support for row level locks ??? Regards, Sekhar - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem with ALTER query
I have just installed redhat linux 7.1 and now need to install Mysql. with innodb support. I downloaded the rpm (3.23.51) from the mysql site and tried to install it. The process appeared to stop mysql and then complained it could not find a file: /etc/rc.d/mysql A query on rpm -qa | grep mysql showed no changes had taken place. How do I install the latest version of mysql? Should I be using the rpm ? Regards Peter Goggin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Finding gaps in date intervals
Hi, I have a table with this structure: CREATE TABLE dats ( id INT UNSIGNED NOT NULL, id_ref INT UNSIGNED NOT NULL, start DATE NOT NULL, endDATE NOT NULL ) Now I am trying to create a query that will give me all intervals for which the table does not contain an entry grouped by id_ref, e.g. if the table would contain 1, 1, '2000-01-01', '2000-31-12' 2, 1, '2001-02-01', '2002-31-12' I would like to get 1, '2001-01-01', '2001-01-31', as there is a gap between these two entries. Any idea on how to get this? Jens - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Insert date format
Hello,
I am developing an aplication where I need format the date for inserting
into mySQL.
With DATE_FORMAT I can format the mySQL date to my date, but I haven't
found a good way to format my date to the mySQL date.
My format is 'dd-mm-' and to convert it to '-mm-dd' I'm using
the next sequence:
SELECT DATE_FORMAT(
CONCAT(
SUBSTRING_INDEX('03-05-2002', '-', -1),
'-',
SUBSTRING_INDEX(SUBSTRING_INDEX('03-05-2002', '-', 2),
'-', -1),
'-',
SUBSTRING_INDEX('03-05-2002', '-', 1)),
'%Y-%m-%d' );
I have searched in the manual, the list and in the DuBois' book, but I
haven't found a single function to parse my date to the mySQL date. Is
that rigth? Is there no function to parse from any date to the mySQL
date?
Regards
Javier
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
UPDATE syntax dummy question...
Howdy, I'm trying to perform an update on a php poll table. Here is the table description: mysql describe vbooth_data; +-+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+-+---+ | pollID | int(11) | | | 0 | | | optionText | char(50) | | | | | | optionCount | int(11) | | | 0 | | | voteID | int(11) | | | 0 | | +-+--+--+-+-+---+ 4 rows in set (0.00 sec) And here is my update query: update vbooth_data set optionText='Not at all, I'm waiting for the other shoe to drop' where (pollID='34' AND voteID='3'); When I hit Enter, it gives me this prompt: ' And nothing I input will do anything. I end up having to exit with CTRL-C or CTRL-D. I know this is probably a simple syntax issue, but what am I doing wrong?? And what is mysql looking for with that ' prompt? Thanks! Matthias - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 too slow
Hi Alexander, I believe that the the 'count()' function works differently under INNODB type tables. With MyISAM count(*) is stored in a 'table status' area, but INNODB must scan the tables and count the rows (very slow). All other types of queries should perform much better for you, but 'count(*)' is not impelemented the same way. Hope this helps, Ken - Original Message - From: Varshavchick Alexander [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 03, 2002 3:56 AM Subject: Innodb too slow Hi, why innodb queries work MUCH slower (100 times) than if the table was of myisam type? It's mysql 4.0.3 on FreeBSD 4.5 server. The innodb monitor outputs many messages like the following, why are they there and what do they mean? Purge done for trx's n:o 0 782 undo n:o 0 0 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 3811, ACTIVE 0 sec, OS thread id 10250 fetching rows MySQL thread id 2, query id 3044 localhost handy Sending data SELECT count(*) from stat Trx read view will not see trx with id = 0 3812, sees 0 3807 ---TRANSACTION 0 3810, ACTIVE 1 sec, OS thread id 12300 fetching rows MySQL thread id 4, query id 3043 localhost handy Sending data SELECT count(*) from stat Trx read view will not see trx with id = 0 3811, sees 0 3806 ---TRANSACTION 0 3809, ACTIVE 1 sec, OS thread id 13325 fetching rows MySQL thread id 5, query id 3042 localhost handy Sending data SELECT count(*) from stat Trx read view will not see trx with id = 0 3811, sees 0 3806 ---TRANSACTION 0 3808, ACTIVE 1 sec, OS thread id 14350 fetching rows MySQL thread id 6, query id 3041 localhost handy Sending data SELECT count(*) from stat Trx read view will not see trx with id = 0 3809, sees 0 3804 ---TRANSACTION 0 3807, ACTIVE 1 sec, OS thread id 11275 fetching rows MySQL thread id 3, query id 3040 localhost handy Sending data SELECT count(*) from stat Trx read view will not see trx with id = 0 3808, sees 0 3803 Any help will be appreciated, thanks! Alexander Varshavchick, Metrocom Joint Stock Company Phone: (812)118-3322, 118-3115(fax) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: primary/foreign key contraints
Neal, Sorry for the MySQL newbie question ... but are there not primary/foreign key constraints in MySQL 3? In MyISAM tables or ISAM tables no. I can't imagine that this is right. Perhaps I'm just overlooking something innodb? (mysql query) DSL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
InnoDB locks disappear
My program uses locks to allow for multi-threading (processing requests that are stored in the database using more than one thread and/or application). The problem is that the locks disappear for seemingly no reason at all. The same queries are repeated over and over again until the lock just vanishes, so it seems to be a time-out or something like that. I've created a log-file of the queries and two reports from the innodb_lock_monitor, the one just before the lock vanishes and the one after. I would really appreciate some help, Wouter Zelle ---Query log -- Comments: At the start of the fragment the request is being locked in connection #23 (every request is locked in a seperate connection so commits won't do harm anyone else). The next query (14:43:13) finds all unprocessed requests in the DB (Connection #22 is used for this query). The 'For Update'-query tries to lock the request and fails if it is already locked (causing my app to move on to the next request). Connection #24 is used for this kind of query after 14:43:18. As you can see, the two types of requests keep interleaving until I halted the app, which was after the request was unlocked. I've cleaned up the log a bit for easy reading. --- 14:42:42 23 Connect wouter@localhost on 23 Init DB rosetta 23 Query SHOW VARIABLES 23 Query SET autocommit=0 23 Query SELECT [t0.columns] FROM REQUEST t0, ROSETTA_USER T1 WHERE (t0.EXTERNAL_IDENTIFIER = 'RequestID01' AND T1.LOGIN = 'login') AND t0.USER_ID = T1.USER_ID FOR UPDATE 14:43:13 22 Query SELECT [t0.columns] FROM REQUEST t0 WHERE t0.STATUS = 'ReadyForProcessing' ORDER BY t0.CREATION_DATE ASC 22 Query commit 14:43:18 24 Connect wouter@localhost on 24 Init DB rosetta 24 Query SHOW VARIABLES 24 Query SET autocommit=0 24 Query SELECT [t0.columns] FROM REQUEST t0, ROSETTA_USER T1 WHERE (t0.EXTERNAL_IDENTIFIER = 'RequestID01' AND T1.LOGIN = 'login') AND t0.USER_ID = T1.USER_ID FOR UPDATE 14:43:43 22 Query SELECT [t0.columns] FROM REQUEST t0 WHERE t0.STATUS = 'ReadyForProcessing' ORDER BY t0.CREATION_DATE ASC 22 Query commit 14:44:12 24 Query SELECT [t0.columns] FROM REQUEST t0, ROSETTA_USER T1 WHERE (t0.EXTERNAL_IDENTIFIER = 'RequestID01' AND T1.LOGIN = 'login') AND t0.USER_ID = T1.USER_ID FOR UPDATE 14:44:33 22 Query SELECT [t0.columns] FROM REQUEST t0 WHERE t0.STATUS = 'ReadyForProcessing' ORDER BY t0.CREATION_DATE ASC 22 Query commit 14:44:53 24 Query SELECT [t0.columns] FROM REQUEST t0, ROSETTA_USER T1 WHERE (t0.EXTERNAL_IDENTIFIER = 'RequestID01' AND T1.LOGIN = 'login') AND t0.USER_ID = T1.USER_ID FOR UPDATE 14:45:18 22 Query SELECT [t0.columns] FROM REQUEST t0 WHERE t0.STATUS = 'ReadyForProcessing' ORDER BY t0.CREATION_DATE ASC 22 Query commit 14:45:24 24 Query SELECT [t0.columns] FROM REQUEST t0, ROSETTA_USER T1 WHERE (t0.EXTERNAL_IDENTIFIER = 'RequestID01' AND T1.LOGIN = 'login') AND t0.USER_ID = T1.USER_ID FOR UPDATE 14:45:42 22 Query SELECT [t0.columns] FROM REQUEST t0 WHERE t0.STATUS = 'ReadyForProcessing' ORDER BY t0.CREATION_DATE ASC 22 Query commit 14:45:54 24 Query SELECT [t0.columns] FROM REQUEST t0, ROSETTA_USER T1 WHERE (t0.EXTERNAL_IDENTIFIER = 'RequestID01' AND T1.LOGIN = 'login') AND t0.USER_ID = T1.USER_ID FOR UPDATE 14:46:23 22 Query SELECT [t0.columns] FROM REQUEST t0 WHERE t0.STATUS = 'ReadyForProcessing' ORDER BY t0.CREATION_DATE ASC 22 Query commit 14:46:41 24 Query SELECT [t0.columns] FROM REQUEST t0, ROSETTA_USER T1 WHERE (t0.EXTERNAL_IDENTIFIER = 'RequestID01' AND T1.LOGIN = 'login') AND t0.USER_ID = T1.USER_ID FOR UPDATE 14:47:08 22 Query SELECT [t0.columns] FROM REQUEST t0 WHERE t0.STATUS = 'ReadyForProcessing' ORDER BY t0.CREATION_DATE ASC 14:47:09 22 Query commit 23 Quit 14:47:283 Query DROP TABLE innodb_lock_monitor ---End Query Log ---INNODB MONITOR OUTPUT -- Comments: I took out everything but the transactions, since I don't think the rest will be of any help. If you need some other info, please ask. -- --- = 14:47:06 INNODB MONITOR OUTPUT = TRANSACTIONS Trx id counter 0 370112 Purge done for trx's n:o 0 370096 undo n:o 0 0 Total number of lock structs in row lock hash table 2 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 370111, not started, OS thread id 1660 MySQL thread id 24, query id 1036 localhost 127.0.0.1 wouter ---TRANSACTION 0 370110, not started, OS thread id 1636 MySQL thread id 22, query id 1035 localhost 127.0.0.1 wouter ---TRANSACTION 0 370099, ACTIVE 264 sec, OS thread id 292 4 lock struct(s), heap size 320 MySQL thread id 23, query id 1015 localhost 127.0.0.1 wouter TABLE LOCK
entry just made in mysql table
sql,query Is there a way to find out what the value of the last entry just made in a mysql table where the field is being auto incremented? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 and Service Pack 3
Hi! Miguel == Miguel Angel Solórzano [EMAIL PROTECTED] writes: Hello, I have a very strange problem with all of the Windows versions of MySQL. I upgraded to Service Pack 3 for Windows 2000 Server and now MySQL will not work period. Has anyone ran into this problem and or know of a fix? Miguel Some users had reported before this issue, for someone the remove and Miguel re-install the MySQL service had resolved the issue. If the above doesn't help, can you please run the mysqld-debug binary from a command window with the options: mysqld --debug --standalone in a separate windows. (Note that this will not run in the background) You can now try to connect to MySQL from another command window with 'mysql' If the above crashes or hangs, the file: c:\mysqld.trace should contain information of where it hangs. If this happens, please ftp this log and a readme file describing the problem to ftp://support.mysql.com/pub/mysql/secret and we will take a look at this. Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
getting the id each side of a given id
hi all, given a certain id # (eg 4), how would i query the value either side of it (usually 3 and 5). In theory, yes, it'd be 3 + 5, but in the case of the following table: 1 4 5 it'd be 1 + 5, and this: 3 4 7 it'd be 3 + 7. Even more interesting would be obtaining some sort of an error when there ISN'T a value higher or lower... eg 4 5 6 7 or 1 2 3 4 TIA, Justin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: Help! Recovering corrupt table
Rolf, Tuesday, September 03, 2002, 1:57:49 AM, you wrote: RH I'm using MySQL 3.23.51. I have a table which started giving 127 errors. [skip] RH It recovers my table but I end up with only 1030 out of 27497 rows, RH so that's not a log of help! RH Running myisamchk -r -e gives a similar result (only 1030 rows are RH recovered), as does truncating the table first then restored the MYD RH file and running myiasmchk. RH Any other suggestions as to what to try? Could you repair table with REPAIR TABLE .. USE_FRM ? RH Thanks for the the suggestion. What does USE_FRM mean? That gives a RH syntax error. If I do a plain REPAIR TABLE then it has the same RH effect as myisamchk, just giving me 1030 out of 27000+ rows! Oh! My fault :( It's supported only since 4.0.2 Could you use 4.0.2 temporarily? Does it also deletes records? RH Not sure what you mean? If you would use REPAIR TABLE .. USE_FRM it also deletes 26 thousand rows? -- 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: mysqld --help - Segmentation fault
sitnikov, Friday, August 30, 2002, 8:34:03 PM, you wrote: Description: s Segmentation fault when starti mysqld with --help How-To-Repeat: s mysqld --help I tested it and mysqld --help worked without any problem. Today Michael Tam reported about crush if he used bind-address option. Did you use bind-address option? If no, could you provide contents of my.cnf file? s Server version: mysql-4.0.3-beta-pc-linux-gnu-i686 Environment: s System: Linux gap 2.4.18 #3 SMP Fri Mar 15 14:40:03 EET 2002 i686 unknown s Architecture: i686 s Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc s GCC: Reading specs from /usr/lib/gcc-lib/i486-suse-linux/2.95.3/specs s gcc version 2.95.3 20010315 (SuSE) s Compilation info: CC='gcc' CFLAGS='-O2 -mcpu=pentiumpro ' CXX='gcc' CXXFLAGS='-O2 -mcpu=pentiumpro -felide-constructors' LDFLAGS='-static' s LIBC: s -rwxr-xr-x1 root root 1384040 Jul 14 16:43 /lib/libc.so.6 s -rw-r--r--1 root root 25214756 Dec 18 2001 /usr/lib/libc.a s -rw-r--r--1 root root 178 Dec 18 2001 /usr/lib/libc.so s Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-server-suffix= --enable-thread-safe-client s --enable-local-infile --enable-assembler --with-other-libc=/usr/local/mysql-glibc --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --disable-shared 'CFLAGS=-O2 -mcpu=pentiumpro s ' 'CXXFLAGS=-O2 -mcpu=pentiumpro -felide-constructors' CXX=gcc LDFLAGS=-static -- 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: mysql_real_connect - capi
Buddy, Tuesday, September 03, 2002, 11:05:24 AM, you wrote: BB I am using c to write some basic mysql programs and I cannot seem to get BB past mysql_real_connect. I get an access denied message. It does not BB recognize the password user combination. I set the usr/pswd up with the BB admin progrram and can get into mysql fine. One thing I noticed on the BB error message is the full host and domain name are appended to the usr BB and the password is being used. My statement looks like: connect = BB mysql_real_connect(mysql,prod.home.com,root,fakepswd,,0,0,0) ; What exact error message did you get? Did you connect from the same host with admin program as with C application or no? -- 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
Number of queries per second
Hi I'm trying to see how many queries per second I have running in my MySQL server. I understand that the number i see (Queries per second avg) is the average since the time the MySQL Server came up. The numbers i see below do not make much sense since the number stabilizes around 47 at any given time. Uptime: 4295 Threads: 188 Questions: 203027 Slow queries: 0 Opens: 144 Flush tables: 1 Open tables: 30 Queries per second avg: 47.271 Uptime: 4296 Threads: 186 Questions: 203033 Slow queries: 0 Opens: 144 Flush tables: 1 Open tables: 30 Queries per second avg: 47.261 Uptime: 4297 Threads: 186 Questions: 203085 Slow queries: 0 Opens: 144 Flush tables: 1 Open tables: 30 Queries per second avg: 47.262 Uptime: 4298 Threads: 182 Questions: 203114 Slow queries: 0 Opens: 144 Flush tables: 1 Open tables: 30 Queries per second avg: 47.258 Uptime: 4299 Threads: 180 Questions: 203175 Slow queries: 0 Opens: 144 Flush tables: 1 Open tables: 30 Queries per second avg: 47.261 Uptime: 4300 Threads: 177 Questions: 203231 Slow queries: 0 Opens: 144 Flush tables: 1 Open tables: 30 Queries per second avg: 47.263 Uptime: 4301 Threads: 176 Questions: 203263 Slow queries: 0 Opens: 144 Flush tables: 1 Open tables: 30 Queries per second avg: 47.259 Uptime: 4302 Threads: 181 Questions: 203349 Slow queries: 0 Opens: 144 Flush tables: 1 Open tables: 30 Queries per second avg: 47.268 how can i ask to see the number of queries per second in at a given second or a defined period of time? thanks berber - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Insert date format
Hello Javier,
I am developing an aplication where I need format the date for inserting
into mySQL.
=what language is your application written in?
=dn
With DATE_FORMAT I can format the mySQL date to my date, but I haven't
found a good way to format my date to the mySQL date.
My format is 'dd-mm-' and to convert it to '-mm-dd' I'm using
the next sequence:
SELECT DATE_FORMAT(
CONCAT(
SUBSTRING_INDEX('03-05-2002', '-', -1),
'-',
SUBSTRING_INDEX(SUBSTRING_INDEX('03-05-2002', '-', 2),
'-', -1),
'-',
SUBSTRING_INDEX('03-05-2002', '-', 1)),
'%Y-%m-%d' );
I have searched in the manual, the list and in the DuBois' book, but I
haven't found a single function to parse my date to the mySQL date. Is
that rigth? Is there no function to parse from any date to the mySQL
date?
Regards
Javier
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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 too slow
Thank you Ken for the answer, but here the cause was different from what you say. count() works fast enough for innodb as well, expecially if the query cache feature is turned on. In my case, I used a mysql 4.0.3 compiled from ports, which had a debug option turned on, and it appeared to be critical for performance which dropped more then by 100 times because of it! As I was going further, 4.0.3 version went out of control after about 10 minutes of being uptime - it suddenly just silently refused showing all configured databases :( So I'm now installing 4.0.2, hope it'll be behaving better. Regards Alexander Varshavchick, Metrocom Joint Stock Company Phone: (812)118-3322, 118-3115(fax) On Tue, 3 Sep 2002, Ken Menzel wrote: Date: Tue, 3 Sep 2002 10:34:06 -0400 From: Ken Menzel [EMAIL PROTECTED] To: Varshavchick Alexander [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: Innodb too slow Hi Alexander, I believe that the the 'count()' function works differently under INNODB type tables. With MyISAM count(*) is stored in a 'table status' area, but INNODB must scan the tables and count the rows (very slow). All other types of queries should perform much better for you, but 'count(*)' is not impelemented the same way. Hope this helps, Ken - Original Message - From: Varshavchick Alexander [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 03, 2002 3:56 AM Subject: Innodb too slow Hi, why innodb queries work MUCH slower (100 times) than if the table was of myisam type? It's mysql 4.0.3 on FreeBSD 4.5 server. The innodb monitor outputs many messages like the following, why are they there and what do they mean? Purge done for trx's n:o 0 782 undo n:o 0 0 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 3811, ACTIVE 0 sec, OS thread id 10250 fetching rows MySQL thread id 2, query id 3044 localhost handy Sending data SELECT count(*) from stat Trx read view will not see trx with id = 0 3812, sees 0 3807 ---TRANSACTION 0 3810, ACTIVE 1 sec, OS thread id 12300 fetching rows MySQL thread id 4, query id 3043 localhost handy Sending data SELECT count(*) from stat Trx read view will not see trx with id = 0 3811, sees 0 3806 ---TRANSACTION 0 3809, ACTIVE 1 sec, OS thread id 13325 fetching rows MySQL thread id 5, query id 3042 localhost handy Sending data SELECT count(*) from stat Trx read view will not see trx with id = 0 3811, sees 0 3806 ---TRANSACTION 0 3808, ACTIVE 1 sec, OS thread id 14350 fetching rows MySQL thread id 6, query id 3041 localhost handy Sending data SELECT count(*) from stat Trx read view will not see trx with id = 0 3809, sees 0 3804 ---TRANSACTION 0 3807, ACTIVE 1 sec, OS thread id 11275 fetching rows MySQL thread id 3, query id 3040 localhost handy Sending data SELECT count(*) from stat Trx read view will not see trx with id = 0 3808, sees 0 3803 Any help will be appreciated, thanks! Alexander Varshavchick, Metrocom Joint Stock Company Phone: (812)118-3322, 118-3115(fax) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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.3b Bind-Address problem
Hi all, I just tried 4.0.3beta and it doesn't seem to address the bind-address problem at all. When I include the option in the ini file and run mysql-max-nt --help, it stops showing the variables when it reaches bind-address variable and a window pops up with the following message: The instruction at 0x005c89eb referenced memory at 0xb000a8c0. The memory could not be read. Regards, Michael -- Michael Tam - NFI Database Developer Natural Resources Canada [EMAIL PROTECTED] Pacific Forestry Center Phone: (250) 363-8074 506 West Burnside Road Fax: (250) 363-0775 Victoria, BC V8Z 1M5 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: UPDATE syntax dummy question...
Hi, You should escape quotes within strings: Matthias Trevarthan wrote: Howdy, I'm trying to perform an update on a php poll table. Here is the table description: mysql describe vbooth_data; +-+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+-+---+ | pollID | int(11) | | | 0 | | | optionText | char(50) | | | | | | optionCount | int(11) | | | 0 | | | voteID | int(11) | | | 0 | | +-+--+--+-+-+---+ 4 rows in set (0.00 sec) And here is my update query: update vbooth_data set optionText='Not at all, I'm waiting for the other shoe to drop' where (pollID='34' AND voteID='3'); update vbooth_data set optionText='Not at all, I\'m waiting for the other shoe to drop' where (pollID='34' AND voteID='3'); When I hit Enter, it gives me this prompt: ' And nothing I input will do anything. I end up having to exit with CTRL-C or CTRL-D. I know this is probably a simple syntax issue, but what am I doing wrong?? And what is mysql looking for with that ' prompt? Thanks! Matthias Regards -- Joseph Bueno - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Many Fields
I can't think of any reason to have that many fields. It really starts to make the databases structure unmanageable, or at least difficult and time consuming to manage. It also can make it very difficult to create a good, flexible search interface. Filemaker might be an exception because of the way it's relations work and the limited options you have for displaying related information. Searching on related fields in FileMaker also gives you a very generous performance hit. :) I usually try to design my databaes vertically instead of horizontally. For instance, each phone number for someone would be a record in another table, rather than having separate field for home, work, cell, fax, etc. This gives you much more flexibility, like tracking 3 home phones, 2 cell phone, 2 faxes, and a work phone. On Tuesday, September 3, 2002, at 10:00 AM, Brian Leyland wrote: What is the limit on amount of fields in a MYSQL table. Access / lotus will only do 255, whereas Filemaker will do over Hopefully someone will tell me it is more than 459 (that is what I need in mine). Thanks Brian Leyland - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: UPDATE syntax dummy question...
Matthias, MySQL is letting you know that you have an unterminated string with the apostrophe. You'll have to either use double quotes to contain the string Not at all, I'm waiting for the other shoe to drop, or escape the apostrophe in the word I'm. i.e. UPDATE vbooth_data SET optionText=Not at all, I'm waiting for the other shoe to drop WHERE (pollID='34' AND voteID='3'); Or UPDATE vbooth_data SET optionText='Not at all, I\'m waiting for the other shoe to drop' WHERE (pollID='34' AND voteID='3'); HTH, Bryant Hester Juxtapose, inc. -Original Message- From: Matthias Trevarthan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 03, 2002 9:31 AM To: [EMAIL PROTECTED] Subject: UPDATE syntax dummy question... Howdy, I'm trying to perform an update on a php poll table. Here is the table description: mysql describe vbooth_data; +-+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+-+---+ | pollID | int(11) | | | 0 | | | optionText | char(50) | | | | | | optionCount | int(11) | | | 0 | | | voteID | int(11) | | | 0 | | +-+--+--+-+-+---+ 4 rows in set (0.00 sec) And here is my update query: update vbooth_data set optionText='Not at all, I'm waiting for the other shoe to drop' where (pollID='34' AND voteID='3'); When I hit Enter, it gives me this prompt: ' And nothing I input will do anything. I end up having to exit with CTRL-C or CTRL-D. I know this is probably a simple syntax issue, but what am I doing wrong?? And what is mysql looking for with that ' prompt? Thanks! Matthias - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: UPDATE syntax dummy question...
You need to escape the ' mark in your string. The query should be: update vbooth_data set optionText='Not at all, I''m waiting for the other shoe to drop' where (pollID=34 AND voteID=3); Note the '' within the string: the first tick escapes the second one. If you're more comfortable with C-style escaping, you can use \' instead (but this isn't so portable). Also, you shouldn't really be specifying your pollID and voteID as strings: take out the tick marks around those. Otherwise you're adding pointless (albeit small) load for the server to cast the string to an int. -Chris On Tue, 2002-09-03 at 10:31, Matthias Trevarthan wrote: Howdy, I'm trying to perform an update on a php poll table. Here is the table description: mysql describe vbooth_data; +-+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+-+---+ | pollID | int(11) | | | 0 | | | optionText | char(50) | | | | | | optionCount | int(11) | | | 0 | | | voteID | int(11) | | | 0 | | +-+--+--+-+-+---+ 4 rows in set (0.00 sec) And here is my update query: update vbooth_data set optionText='Not at all, I'm waiting for the other shoe to drop' where (pollID='34' AND voteID='3'); When I hit Enter, it gives me this prompt: ' And nothing I input will do anything. I end up having to exit with CTRL-C or CTRL-D. I know this is probably a simple syntax issue, but what am I doing wrong?? And what is mysql looking for with that ' prompt? Thanks! Matthias - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Insert date format
Hello,
I am developing an aplication where I need format the date for
inserting into mySQL.
=what language is your application written in?
=dn
The application is written in Java, but the problem is that the module
where the dates for the DB are managed is an open source framework and I
wouldn't like to touch that code.
The framework provides a way to modify the dates from/to the database
defining native database functions in a config file.
Anyway, the problem is alredy solved, but I still have the dude if I
there is a better solution.
Regards
Javier
With DATE_FORMAT I can format the mySQL date to my date, but I
haven't found a good way to format my date to the mySQL date.
My format is 'dd-mm-' and to convert it to '-mm-dd'
I'm using
the next sequence:
SELECT DATE_FORMAT(
CONCAT(
SUBSTRING_INDEX('03-05-2002', '-', -1),
'-',
SUBSTRING_INDEX(SUBSTRING_INDEX('03-05-2002', '-', 2),
'-', -1),
'-',
SUBSTRING_INDEX('03-05-2002', '-', 1)),
'%Y-%m-%d' );
I have searched in the manual, the list and in the DuBois'
book, but I
haven't found a single function to parse my date to the
mySQL date. Is
that rigth? Is there no function to parse from any date to
the mySQL
date?
Regards
Javier
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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
Openssl and MySQL 4.0.3-Beta
According to the documentation under section 4.3.9 to get openssl working with mysql you need to configure mysql with the --with-vio --with-openssl. When I add the as arguments to ./configure and then compile it I get a mysqld that will run but try to do anything with it and the client freezes it seems. Is there any way to enable these options with the rpm binary packages. I would like to use the ones that are built by mysql.com. If not how can I compile this so it works right. Thanks for any help. Matthew Scarrow ComIT Solutions Inc. [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: UPDATE syntax dummy question...
Howdy Matthias, update vbooth_data set optionText='Not at all, I'm waiting for the other shoe to drop' where (pollID='34' AND voteID='3'); When I hit Enter, it gives me this prompt: ' Two things: 1 (the ) is because it is waiting for the end of the string - you have an apostrophe opening the optionText string, then another one to 'end' it before WHERE, but there's a problem with the I'm apostrophe four words into the string! 2 both columns in the WHERE clause are integers, so neither value needs to be quoted. Regards, =dn List bait: 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: entry just made in mysql table
At 17:10 +0200 9/3/02, mixo wrote: sql,query Is there a way to find out what the value of the last entry just made in a mysql table where the field is being auto incremented? SELECT LAST_INSERT_ID(); - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: UPDATE syntax dummy question...
Thanks everyone! I see that I need double quotes now. I received about 12 different personal emails from various people with exactly the same answer. Thanks again! On Tuesday 03 September 2002 10:31, Matthias Trevarthan wrote: Howdy, I'm trying to perform an update on a php poll table. Here is the table description: mysql describe vbooth_data; +-+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+-+---+ | pollID | int(11) | | | 0 | | | optionText | char(50) | | | | | | optionCount | int(11) | | | 0 | | | voteID | int(11) | | | 0 | | +-+--+--+-+-+---+ 4 rows in set (0.00 sec) And here is my update query: update vbooth_data set optionText='Not at all, I'm waiting for the other shoe to drop' where (pollID='34' AND voteID='3'); When I hit Enter, it gives me this prompt: ' And nothing I input will do anything. I end up having to exit with CTRL-C or CTRL-D. I know this is probably a simple syntax issue, but what am I doing wrong?? And what is mysql looking for with that ' prompt? Thanks! Matthias - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql_real_connect - capi
From: Buddy Bell [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: mysql_real_connect - capi Date: 03 Sep 2002 04:05:24 -0400 I am using c to write some basic mysql programs and I cannot seem to get past mysql_real_connect. I get an access denied message. It does not recognize the password user combination. I set the usr/pswd up with the admin progrram and can get into mysql fine. One thing I noticed on the error message is the full host and domain name are appended to the usr and the password is being used. My statement looks like: connect = mysql_real_connect(mysql,prod.home.com,root,fakepswd,,0,0,0) ; Thanks for the help in advance. BB Try: mysql_real_connect(mysql,prod.home.com,root,fakepswd, 0, NULL, 0) this is the syntax that works for me regis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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.3b Bind-Address Problem
Hi all, I just tried 4.0.3beta and it doesn't seem to address the bind-address problem at all. When I include the option in the ini file and run mysql-max-nt --help, it stops showing the variables when it reaches bind-address variable and a window pops up with the following message: The instruction at 0x005c89eb referenced memory at 0xb000a8c0. The memory could not be read. Regards, Michael -- Michael Tam - NFI Database Developer Natural Resources Canada [EMAIL PROTECTED] Pacific Forestry Center Phone: (250) 363-8074 506 West Burnside Road Fax: (250) 363-0775 Victoria, BC V8Z 1M5 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
case (in)sensitive
Heey Folks, I've got this small problem... I'm working on a site (www.esctoday.com). In runs on PHP and MySQL. The remote server has some linux version, for local testing of scripts I use Windows 2000. And now the problem, when I run a create tables script on windows 2000 it changes the capitalization of tables to all lower case. While on *nix versions, it all stays as I entered it. The problem in this, is that scripts I run locally will work nomatter how I capitalize the table and row names, while the server does care about this. Is there some way to turn this case insensitiveness off, so that my MySQL on win2k will also be case sensitive? Thanks, Wouter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: JOIN?
I have a query which is more complex (taking advantage of relational databases more) than I have ever done before... and I'm not sure where in the docs to be looking for examples. I have three tables... cd (id, title, etc) artist (id, name) cd_to_artist (cdid, artistid) In my CD database, I use the following structure: CREATE TABLE Artists (Artist VARCHAR (50) NOT NULL, ArtistID INT UNSIGNED NOT NULL PRIMARY KEY) CREATE TABLE Titles (Title VARCHAR (50) NOT NULL, TitleID INT UNSIGNED NOT NULL PRIMARY KEY, ArtistID INT UNSIGNED NOT NULL) CREATE TABLE Tracks (ArtistID INT UNSIGNED, TitleID INT UNSIGNED, Sequence DECIMAL(1,2), Track VARCHAR(100)) which is close to what you have. You're on the right track with your thinking. Use the ID of the Artist to find CD titles; use them both to find tracks. If you're wondering why I set the Sequence field as a decimal, it's the only way I could think of to deal with releases containing more than 1 CD. So, CD1 sequences look like 1.01, 1.02 ... 1.10 and CD2 sequences look like 2.01, 2.02, ... 2.13 and so on. -- /* All outgoing email scanned by Norton Antivirus 2002 */ Amer Neely, Softouch Information Services W: www.softouch.on.ca E: [EMAIL PROTECTED] V: 519.438.5887 Perl | PHP | MySQL | CGI programming for all data entry forms. We make web sites work! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: UPDATE syntax dummy question...
On Tue, 2002-09-03 at 16:31, Matthias Trevarthan wrote: And here is my update query: update vbooth_data set optionText='Not at all, I'm waiting for the other shoe to drop' where (pollID='34' AND voteID='3'); When I hit Enter, it gives me this prompt: ' This prompt indicates you did not close the '' signs, IMHO the ' in I'm is causing the problem, sql must think your command ends after the I. I think you can simply escape the ' with something like \'. HTH p.s. you will find the explanation of the different prompts in point 3.2 of the Mysql manual... -- # Mertens Bram M8ram [EMAIL PROTECTED] Linux User #249103 # # Red Hat Linux 7.3 KDE 3.0.0-10 kernel 2.4.18-3 i686 128MB RAM # - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Openssl and MySQL 4.0.3-Beta
At 12:44 -0400 9/3/02, Matthew Scarrow wrote: According to the documentation under section 4.3.9 to get openssl working with mysql you need to configure mysql with the --with-vio --with-openssl. When I add the as arguments to ./configure and then compile it I get a mysqld that will run but try to do anything with it and the client freezes it seems. Yep. The developers are working on it. In the meantime, try this. Instead of invoking ./configure like this: ./configure --with-vio --with-openssl [other options] invoke it like this: CFLAGS=-DEXTRA_DEBUG ./configure --with-vio --with-openssl [other options] or, for csh/tcsh: setenv CFLAGS -DEXTRA_DEBUG ./configure --with-vio --with-openssl [other options] That may get you going. Is there any way to enable these options with the rpm binary packages. I would like to use the ones that are built by mysql.com. If not how can I compile this so it works right. Thanks for any help. Matthew Scarrow ComIT Solutions Inc. [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: Openssl and MySQL 4.0.3-Beta
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tuesday 03 September 2002 18:44, Matthew Scarrow wrote: According to the documentation under section 4.3.9 to get openssl working with mysql you need to configure mysql with the --with-vio --with-openssl. That's correct. When I add the as arguments to ./configure and then compile it I get a mysqld that will run but try to do anything with it and the client freezes it seems. Is there any way to enable these options with the rpm binary packages. I would like to use the ones that are built by mysql.com. Unfortunately not - you need to recompile the code to enable SSL support for now. We plan to enable SSL in the 4.0.x Max binary packages in the future (where available). If not how can I compile this so it works right. You were on the right track. Unfortunately OpenSSL support in 4.0.3 is broken - - sorry about that. As a workaround, you can try compiling MySQL with adding CFLAGS=-DEXTRA_DEBUG, this will magically work around the bug. It seems like some critical code is inside an #ifndef DBUG_OFF somewhere... We are currently investigating this problem and it will hopefully be fixed for 4.0.4. Bye, LenZ - -- For technical support contracts, visit https://order.mysql.com/?ref=mlgr __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Lenz Grimmer [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE9dRekSVDhKrJykfIRAhbBAJ0WQr13CMYQ0j+RC4Zmhuwlx9+njwCZAQQK W9DFxHQioNk/gwjg8zNBxe4= =CK3t -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 locks disappear
Wouter, - Original Message - From: Wouter Zelle [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Tuesday, September 03, 2002 7:43 PM Subject: InnoDB locks disappear My program uses locks to allow for multi-threading (processing requests that are stored in the database using more than one thread and/or application). The problem is that the locks disappear for seemingly no reason at all. The same queries are repeated over and over again until the lock just vanishes, so it seems to be a time-out or something like that. I've created a log-file of the queries and two reports from the innodb_lock_monitor, the one just before the lock vanishes and the one after. the default for innodb_lock_wait_timeout is 50 seconds in recent versions. It may be that the manual at www.mysql.com is outdated and claims it is infinite. A lock wait timeout rolls back the whole transaction and releases all locks. You should check the return value of your queries and look if they are reporting lock wait timeouts or other errors. I would really appreciate some help, Wouter Zelle Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB ---Query log -- Comments: At the start of the fragment the request is being locked in connection #23 (every request is locked in a seperate connection so commits won't do harm anyone else). The next query (14:43:13) finds all unprocessed requests in the DB (Connection #22 is used for this query). The 'For Update'-query tries to lock the request and fails if it is already locked (causing my app to move on to the next request). Connection #24 is used for this kind of query after 14:43:18. As you can see, the two types of requests keep interleaving until I halted the app, which was after the request was unlocked. I've cleaned up the log a bit for easy reading. --- 14:42:42 23 Connect wouter@localhost on 23 Init DB rosetta 23 Query SHOW VARIABLES 23 Query SET autocommit=0 23 Query SELECT [t0.columns] FROM REQUEST t0, ROSETTA_USER T1 WHERE (t0.EXTERNAL_IDENTIFIER = 'RequestID01' AND T1.LOGIN = 'login') AND t0.USER_ID = T1.USER_ID FOR UPDATE 14:43:13 22 Query SELECT [t0.columns] FROM REQUEST t0 WHERE t0.STATUS = 'ReadyForProcessing' ORDER BY t0.CREATION_DATE ASC 22 Query commit 14:43:18 24 Connect wouter@localhost on 24 Init DB rosetta 24 Query SHOW VARIABLES 24 Query SET autocommit=0 24 Query SELECT [t0.columns] FROM REQUEST t0, ROSETTA_USER T1 WHERE (t0.EXTERNAL_IDENTIFIER = 'RequestID01' AND T1.LOGIN = 'login') AND t0.USER_ID = T1.USER_ID FOR UPDATE 14:43:43 22 Query SELECT [t0.columns] FROM REQUEST t0 WHERE t0.STATUS = 'ReadyForProcessing' ORDER BY t0.CREATION_DATE ASC 22 Query commit 14:44:12 24 Query SELECT [t0.columns] FROM REQUEST t0, ROSETTA_USER T1 WHERE (t0.EXTERNAL_IDENTIFIER = 'RequestID01' AND T1.LOGIN = 'login') AND t0.USER_ID = T1.USER_ID FOR UPDATE 14:44:33 22 Query SELECT [t0.columns] FROM REQUEST t0 WHERE t0.STATUS = 'ReadyForProcessing' ORDER BY t0.CREATION_DATE ASC 22 Query commit 14:44:53 24 Query SELECT [t0.columns] FROM REQUEST t0, ROSETTA_USER T1 WHERE (t0.EXTERNAL_IDENTIFIER = 'RequestID01' AND T1.LOGIN = 'login') AND t0.USER_ID = T1.USER_ID FOR UPDATE 14:45:18 22 Query SELECT [t0.columns] FROM REQUEST t0 WHERE t0.STATUS = 'ReadyForProcessing' ORDER BY t0.CREATION_DATE ASC 22 Query commit 14:45:24 24 Query SELECT [t0.columns] FROM REQUEST t0, ROSETTA_USER T1 WHERE (t0.EXTERNAL_IDENTIFIER = 'RequestID01' AND T1.LOGIN = 'login') AND t0.USER_ID = T1.USER_ID FOR UPDATE 14:45:42 22 Query SELECT [t0.columns] FROM REQUEST t0 WHERE t0.STATUS = 'ReadyForProcessing' ORDER BY t0.CREATION_DATE ASC 22 Query commit 14:45:54 24 Query SELECT [t0.columns] FROM REQUEST t0, ROSETTA_USER T1 WHERE (t0.EXTERNAL_IDENTIFIER = 'RequestID01' AND T1.LOGIN = 'login') AND t0.USER_ID = T1.USER_ID FOR UPDATE 14:46:23 22 Query SELECT [t0.columns] FROM REQUEST t0 WHERE t0.STATUS = 'ReadyForProcessing' ORDER BY t0.CREATION_DATE ASC 22 Query commit 14:46:41 24 Query SELECT [t0.columns] FROM REQUEST t0, ROSETTA_USER T1 WHERE (t0.EXTERNAL_IDENTIFIER = 'RequestID01' AND T1.LOGIN = 'login') AND t0.USER_ID = T1.USER_ID FOR UPDATE 14:47:08 22 Query SELECT [t0.columns] FROM REQUEST t0 WHERE t0.STATUS = 'ReadyForProcessing' ORDER BY t0.CREATION_DATE ASC 14:47:09 22 Query commit 23 Quit 14:47:283 Query DROP TABLE innodb_lock_monitor ---End Query Log ---INNODB MONITOR OUTPUT -- Comments: I took out everything but the transactions, since I don't think the rest will be of any help. If you need some other info, please ask. -- ---
Re: Fwd: Crash when adding field
Victoria Reznichenko writes:
Hi!
Indeed I could repeat it :(
In addition, MySQL crushes if the table is not empty. Subscriber
provide ALTER TABLE .. with a column name that already exists.
So I modify test case a little to:
CREATE TABLE `users` (
`ID` int(10) unsigned NOT NULL auto_increment,
`FullName` char(50) NOT NULL default '',
`UserName` char(50) NOT NULL default '',
`Password` char(50) NOT NULL default '',
`Level` enum('1','2') NOT NULL default '1',
PRIMARY KEY (`ID`,`UserName`),
UNIQUE KEY `ID` (`ID`),
KEY `ID_2` (`ID`)
) TYPE=MyISAM;
Query OK, 0 rows affected (0.01 sec)
INSERT INTO users(ID) VALUES(NULL);
ALTER TABLE `users` ADD `Level1` ENUM('1','2') DEFAULT 1 NOT NULL;
This is a forwarded message
From: Matt Parlane [EMAIL PROTECTED]
To:
Date: Tuesday, September 03, 2002, 1:56:12 AM
Subject: Crash when adding field
Thank you for your bug report, but this bug is already fixed in 4.0.4.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
___/ 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 4.0.3b Bind-Address Problem
At 14:25 03/09/02 -0400, Tam, Michael wrote: Hi, I just tried 4.0.3beta and it doesn't seem to address the bind-address problem at all. When I include the option in the ini file and run mysql-max-nt --help, it stops showing the variables when it reaches bind-address variable and a window pops up with the following message: The instruction at 0x005c89eb referenced memory at 0xb000a8c0. The memory could not be read. Thanks you for the bug report. I was able to repeat it. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel Angel Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ 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
UDFs in Windows 2000
Hi Everyone: Can UDFs be written for Microsoft 2000? Many of the posts I read on the newsgroups contradict each other. It seems that support was added by a patch from Ralph Mason, but I can not be sure. I am using 3.23.52 and VC6. I was able to make a dll of the udf I wanted to add. I assumed a DLL was the same as the .SO file, however I am not sure how to set the rdynamic flag. I start mysqld and attempt to add my function but I get an error 1126 which means can't open shared library 'udfnotify.dll' (errno 0)' I looked up error 1126 and at least for the unix versions it tells me I need to set -rdynamic. I have not been able to find any refererence to Windows. Thanks for any help you can give. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
crash
Hello ! Mysql 4.03 crash on my linux server... ./resolve_stack_dump -s /tmp/mysqld.sym -n mysql.stack 0x80c84fa handle_segfault__Fi + 450 0x13bae5 (?) 0x80f33bf create_myisam_tmp_table__FP8st_tableP15TMP_TABLE_PARAMUl + 355 0x80f31fe create_tmp_table__FP3THDP15TMP_TABLE_PARAMRt4List1Z4ItemP8st_orderbN24Ul + 4538 0x80ec253 mysql_select__FP3THDP13st_table_listRt4List1Z4ItemP4ItemP8st_orderT4T3T4UlP1 3select_result + 4035 0x80f93c6 handle_select__FP3THDP6st_lexP13select_result + 102 0x80d295a mysql_execute_command__Fv + 934 0x80d6585 mysql_parse__FP3THDPcUi + 557 0x80d1a23 dispatch_command__F19enum_server_commandP3THDPcUi + 1511 0x80d793e do_command__FP3THD + 94 0x80d0bee handle_one_connection__FPv + 682 0x138e42 (?) 0x2a821a (?) why ? It restart all five minuts... Thibaud GRANGIER Administrateur des reseaux PHPNET http://www.phpnet.org [PHPNET, l'hébergeur Professionnel du PHP mais à prix associatif] [EMAIL PROTECTED] Depuis le NOC - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Install questions
On Tue, 2002-09-03 at 05:24, Victoria Reznichenko wrote: MTW I just installed MySQL from RPM and can connect to it via shell using MTW the MySQL command, but I can't get anything else to connect to it. MTW MySQL Connection Failed: Can't connect to local MySQL server through MTW socket '/tmp/mysql.sock' (2) Check if MySQL server is running. If so, find where mysql.sock is located (/var/lib/mysql ?) and specify path to the socket for the client. Or you can also create a symlink. Mysql.sock is located at: /var/lib/mysql/mysql.sock and I've ne'er had to change this in php before, and see no place to enter that info in php.ini... any other thoughts? -- Matt TrollBoy Wiseman Webmaster: Shoggoth.net Site Designer: phpslash.org The oldest and strongest emotion of mankind is fear, and the oldest and strongest kind of fear is fear of the unknown. -H.P. Lovecraft - Please do not resell my e-mail address to anyone or send me unsolicited e-mail - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
slow-queries.log vs. explain
I've been monitoring slow-queries.log to try and find querys that might be causing problems. I see the following logged: # Time: 020903 16:59:14 # User@Host: cfweb[cfweb] @ storm.centurytel.net [10.10.1.17] # Query_time: 47 Lock_time: 0 Rows_sent: 5 Rows_examined: 145240 SELECT clari_category.image_exists, clari_article.id, clari_article.image_url_standard FROM clari_category LEFT JOIN clari_article ON clari_category.id = clari_article.id WHERE clari_category.datestamp '2002-09-01' AND clari_category.image_exists = '0' AND clari_article.image_url_standard != ''; But when I do an explain on the same query I get: +++---+-+-+---+--++ | table | type | possible_keys | key | key_len | ref | rows | Extra | +++---+-+-+---+--++ | clari_category | ref| idx_imagekey,idx_imagestoryvalidation,idx_datestamp,idx_photo | idx_photo | 1 | const | 1448 | where used | | clari_article | eq_ref | idx_primary,idx_datearticle | idx_primary | 100 | clari_category.id | 1 | where used | +++---+-+-+---+--++ 2 rows in set (0.00 sec) I don't understand why the query is examining 145240 rows when explain says it should be limited to 1448? Am I missing something? __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.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: Linker issues with 3.23.52 and solaris 7
Reconfiguring without the --with-mysqld-ldflags=-all-static switch resolved the issue. Any idea why the recommended configuration does not link properly in my case? Thanks, Christian - Christian Gilmore Technology Leader GeT WW Global Applications Development IBM Software Group -Original Message- From: Christian Gilmore [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 03, 2002 4:29 PM To: Mysql Mailing List (E-mail) Subject: Linker issues with 3.23.52 and solaris 7 Hello. I'm attempting to install 3.23.52 on solaris 7 from source and am having issues with the linker not finding libraries in /usr/lib. I'd greatly appreciate any help as it seems this should be a non-issue. phantom% gcc -v Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.7/2.95.3/specs gcc version 2.95.3 20010315 (release) phantom% ./configure --prefix=/opt/gnu/depot/mysql-3.23.52 --enable-assembler --with-mysqld-ldflags=-all-static phantom% make . gcc -O3 -DDBUG_OFF -O3 -felide-constructors -fno-exceptions -fno-rtti -fno-implicit-templates -fno-exceptions -fno-rtti -DHAVE_CURSES_H -I/export/home/cgilmore/mysql-3.23.52/include -DHAVE_RWLOCK_T -L/usr/local/lib -L/opt/gnu/lib -L/usr/lib -o mysqld sql_lex.o item.o item_sum.o item_buff.o item_func.o item_cmpfunc.o item_strfunc.o item_timefunc.o thr_malloc.o item_create.o field.o key.o sql_class.o sql_list.o net_serv.o violite.o net_pkg.o lock.o my_lock.o sql_string.o sql_manager.o sql_map.o mysqld.o password.o hash_filo.o hostname.o convert.o sql_parse.o sql_yacc.o sql_base.o table.o sql_select.o sql_insert.o sql_update.o sql_delete.o sql_do.o procedure.o item_uniq.o sql_test.o log.o log_event.o init.o derror.o sql_acl.o unireg.o time.o opt_range.o opt_sum.o opt_ft.o records.o filesort.o handler.o ha_heap.o ha_myisam.o ha_myisammrg.o ha_berkeley.o ha_innobase.o ha_gemini.o ha_isam.o ha_isammrg.o sql_db.o sql_table.o sql_rename.o sql_crypt.o sql_load.o mf_iocache.o field_conv.o sql_show.o sql_udf.o sql_analyse.o sql_cache.o slave.o sql_repl.o mini_client.o mini_client_errors.o md5.o stacktrace.o -static ../isam/libnisam.a ../merge/libmerge.a ../myisam/libmyisam.a ../myisammrg/libmyisammrg.a ../heap/libheap.a ../mysys/libmysys.a ../dbug/libdbug.a ../regex/libregex.a ../strings/libmystrings.a -ldl -lpthread -lthread -lz -lcrypt -lgen -lsocket -lnsl -lm -lpthread -lthread ld: fatal: library -ldl: not found ld: fatal: library -lpthread: not found ld: fatal: library -lthread: not found ld: fatal: library -lpthread: not found ld: fatal: library -lthread: not found phantom% ls -l /usr/lib | grep thread lrwxrwxrwx 1 root root 17 Aug 31 2000 libpthread.so - ./libpthread.so.1 -rwxr-xr-x 1 bin bin 36316 Sep 1 1998 libpthread.so.1 lrwxrwxrwx 1 root root 16 Aug 31 2000 libthread.so - ./libthread.so.1 -rwxr-xr-x 1 bin bin185792 Jul 11 2001 libthread.so.1 lrwxrwxrwx 1 root root 19 Aug 31 2000 libthread_db.so - ./libthread_db.so.0 -rwxr-xr-x 1 bin bin 10912 Jul 11 2001 libthread_db.so.0 -rwxr-xr-x 1 bin bin 39332 Jul 11 2001 libthread_db.so.1 -rw-r--r-- 1 bin bin 74405 Sep 1 1998 llib-lpthread.ln -rw-r--r-- 1 bin bin 6468 Sep 1 1998 llib-lthread -rw-r--r-- 1 bin bin122265 Sep 1 1998 llib-lthread.ln phantom% ls -l /usr/lib | grep dl lrwxrwxrwx 1 root root 12 Aug 31 2000 libdl.so - ./libdl.so.1 -rwxr-xr-x 1 bin bin 4600 Jul 11 2001 libdl.so.1 -rw-r--r-- 1 bin bin 2129 Sep 1 1998 llib-ldl.ln Thanks, Christian - Christian Gilmore Technology Leader GeT WW Global Applications Development IBM Software Group - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Linker issues with 3.23.52 and solaris 7
Hello. I'm attempting to install 3.23.52 on solaris 7 from source and am having issues with the linker not finding libraries in /usr/lib. I'd greatly appreciate any help as it seems this should be a non-issue. phantom% gcc -v Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.7/2.95.3/specs gcc version 2.95.3 20010315 (release) phantom% ./configure --prefix=/opt/gnu/depot/mysql-3.23.52 --enable-assembler --with- mysqld-ldflags=-all-static phantom% make . gcc -O3 -DDBUG_OFF -O3 -felide-constructors -fno-exceptions -fno-rtti -fno-i mplicit-templates -fno-exceptions -fno-rtti -DHAVE_CURSES_H -I/export/home/c gilmore/mysql-3.23.52/include -DHAVE_RWLOCK_T -L/usr/local/lib -L/opt/gnu/li b -L/usr/lib -o mysqld sql_lex.o item.o item_sum.o item_buff.o item_func.o item_cmpfunc.o item_strfunc.o item_timefunc.o thr_malloc.o item_create.o field.o key.o sql_class.o sql_list.o net_serv.o violite.o net_pkg.o lock.o my_lock.o sql_string.o sql_manager.o sql_map.o mysqld.o password.o hash_filo.o hostname.o convert.o sql_parse.o sql_yacc.o sql_base.o table.o sql_select.o sql_insert.o sql_update.o sql_delete.o sql_do.o procedure.o item_uniq.o sql_test.o log.o log_event.o init.o derror.o sql_acl.o unireg.o time.o opt_range.o opt_sum.o opt_ft.o records.o filesort.o handler.o ha_heap.o ha_myisam.o ha_myisammrg.o ha_berkeley.o ha_innobase.o ha_gemini.o ha_isam.o ha_isammrg.o sql_db.o sql_table.o sql_rename.o sql_crypt.o sql_load.o mf_iocache.o field_conv.o sql_show.o sql_udf.o sql_analyse.o sql_cache.o slave.o sql_repl.o mini_client.o mini_client_errors.o md5.o stacktrace.o -static ../isam/libnisam.a ../merge/libmerge.a ../myisam/libmyisam.a ../myisammrg/libmyisammrg.a ../heap/libheap.a ../mysys/libmysys.a ../dbug/libdbug.a ../regex/libregex.a ../strings/libmystrings.a -ldl -lpthread -lthread -lz -lcrypt -lgen -lsocket -lnsl -lm -lpthread -lthread ld: fatal: library -ldl: not found ld: fatal: library -lpthread: not found ld: fatal: library -lthread: not found ld: fatal: library -lpthread: not found ld: fatal: library -lthread: not found phantom% ls -l /usr/lib | grep thread lrwxrwxrwx 1 root root 17 Aug 31 2000 libpthread.so - ./libpthread.so.1 -rwxr-xr-x 1 bin bin 36316 Sep 1 1998 libpthread.so.1 lrwxrwxrwx 1 root root 16 Aug 31 2000 libthread.so - ./libthread.so.1 -rwxr-xr-x 1 bin bin185792 Jul 11 2001 libthread.so.1 lrwxrwxrwx 1 root root 19 Aug 31 2000 libthread_db.so - ./libthread_db.so.0 -rwxr-xr-x 1 bin bin 10912 Jul 11 2001 libthread_db.so.0 -rwxr-xr-x 1 bin bin 39332 Jul 11 2001 libthread_db.so.1 -rw-r--r-- 1 bin bin 74405 Sep 1 1998 llib-lpthread.ln -rw-r--r-- 1 bin bin 6468 Sep 1 1998 llib-lthread -rw-r--r-- 1 bin bin122265 Sep 1 1998 llib-lthread.ln phantom% ls -l /usr/lib | grep dl lrwxrwxrwx 1 root root 12 Aug 31 2000 libdl.so - ./libdl.so.1 -rwxr-xr-x 1 bin bin 4600 Jul 11 2001 libdl.so.1 -rw-r--r-- 1 bin bin 2129 Sep 1 1998 llib-ldl.ln Thanks, Christian - Christian Gilmore Technology Leader GeT WW Global Applications Development IBM Software Group - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Bitten by a strange bug...
Tom - I'll address what I can I had the same problem with fields being truncated on direct connections (the problem does not manifest on ODBC table attaches in Access). IIRC, the way to solve this problem is to make sure the optimize columns widths (option 1) in the ODBC properties. Hope that helps (at least a little). j- k- On Wednesday 28 August 2002 15:37, Tom Emerson wrote: But enough of the background, here is the problem: developing a visual-basic (6) application using myodbc connected to a mysql database on the network. Adding records works well the first time, but after the database has closed (i.e., the next time I run the program), I run into problems. I've tracked it down to what VB believes is the maximum field size for a given field, and it appears to be limited to whatever the longest value is in the particular field -- when a table is new (empty), there are no entries, so VB thinks the fields are -1 in length (technically, unlimited), and the program works fine. The next time the program runs, the fields definedlength property is set to whatever the longest value happens to be in the table (hence the ugly workaround is to insert a bogus entry with spaces or some filler character padded out to the maximum length -- this is fine for master [key] tables, but for detail entries it might become problematic.) I've even tried the pad char fields to maximum option via the ODBC driver window in the control panel, but that doesn't seem to have any effect. -- Joshua Kugler, Information Services Director Associated Students of the University of Alaska Fairbanks [EMAIL PROTECTED], 907-474-7601 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Cross Database Table Join
I'm trying to do a cross database mysql query. Does anyone know of a way to do this? I've looked through all the documentation I can find including release 4.0. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
changing a slave to a master in mysql replication
Currently to make a slave a master, the docs say you need to set the bin-log option in my.cnf on the slave, and that will make the transition to master quicker. I know I can manually change a slave to a master by stopping the slave process, stop mysql, take a snapshot of the databases, copy over a new master my.cnf, make sure I have granted rights to a user for the old master to return as a slave, and restart. My question is how does having the bin-log option on the slave actually help this process? Or is there an easier way to convert a slave to master using the log position that I missed? Thanks in advance for any help. ~Vicky - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Ãâ·ÑÓòÃû£¬.com .net .orgÈÎÒâÑ¡Ôñ
http://www.indexcn.comÖйúÊ×Ò³--ΪÄú´òÔìÆóÒµÉÏÍøÊ×Ò³£¡ Ãâ·ÑÓòÃû£¬.com.net.orgÈÎÒâÑ¡Ôñ£¬ ÏÖÆð·²¹ºÂòÖйúÊ×Ò³¸÷¿îÐéÄâÖ÷»ú¾ùËÍÒ»¸ö¹ú¼ÊÓ¢ÎÄÓòÃû¼ÛÖµ100Ôª£¬¿ÉÖ§³Ö 20¸ö×ÓÓòÃû£¬URLת·¢£¬ÔÚÏßÐÞ¸ÄDNSµÈ¡£ 1.Ö»Òª350Ôª£¬¼´¿ÉÂíÉÏÓµÓÐ"Æóҵͨ"Ìײͣº ¸ßËÙÎȶ¨100MÐéÄâÖ÷»ú£¬ËÍ100MÆóÒµÓʾֿɿªÊ®¸öÓÊÏ䣬 È«²¿Ö§³Ö¸÷ÖÖ³ÌÐò£¬ËÍACCESSODBC»òMYSQLÊý¾Ý¿â£¬ ÔÙËÍÒ»¸ö¹ú¼ÊÓ¢ÎÄÓòÃû£¬È«Ì×·þÎñ£¬ÆóÒµ½¨Õ¾Ê×Ñ¡£¡ 2.ͬʱÍƳö"´¿Ò³Ãæ(html)ÐéÄâÖ÷»ú"£¬ÒÔ³¬Îȶ¨ºÍ³¬µÍ¼ÛÌṩ¸ø²»ÐèÒªÔËÐи÷Àà³ÌÐò£¬ ½ö·¢²¼ÎÄ×ÖºÍͼƬ×ÊÁϵÄÆóÒµºÍ¸öÈËÓû§,ËÍ100MÆóÒµÓʾ֣¬¿É¿ªÊ®¸öÓÊÏ䣬 Ö»Ðè250Ôª£¬ÔÙËÍÒ»¸ö¹ú¼ÊÓ¢ÎÄÓòÃû¼ÛÖµ100Ôª£¬³¬Öµ·þÎñ»¶ÓÑ¡¹º¡£ 3.ÆóÒµÍøÕ¾½¨É裬ÍøÕ¾Íƹ㣬ËÑË÷ÒýÇæµÇ½£¬3721ÍøÂçʵÃûµÈ¡£ ÕâÊÇÀ´×ÔÖйúÊ×Ò³(http://www.indexcn.com)µÄÎʺ¸ÐлÄúÊÕ¿´Õâ·âÓʼþ¡£ ÎÒÃÇÕæ³ÏµÄÏ£ÍûÄúÄܳÉΪÎÒÃÇÔÚ¹óµØÇøµÄÖØÒª»ï°é¡£ÎÒÃÇÊÇÒ»¼ÒרÃÅΪ¸÷ ÀàÆóÊÂÒµµ¥Î»ÌṩÍøÂçÐÅÏ¢¼¼ÊõÓ¦Óù滮¡¢Èí¼þ¿ª·¢¡¢É豸²É¹º¡¢Æ½Ì¨·þ ÎñµÄÐÅÏ¢¼¼Êõ¹«Ë¾¡£×¨ÃÅΪ¸÷ÀàÆóÊÂÒµµ¥Î»ÌṩÌṩ¸ßËÙ¡¢Îȶ¨¡¢¼ÛµÍµÄ ·þÎñÆ÷¿Õ¼ä¼°¸÷ÖÖÓòÃû×¢²á,ÓжàÄêÍøÂç½ÓÈë¾Ñ飬רҵÌṩÐéÄâÖ÷»ú·þÎñ¡£ ÖйúÊ×Ò³£¨http://www.indexcn.com)ÏÃÃÅÍò´´ÍØÕ¹ÍøÂç¿Æ¼¼ÓÐÏÞ¹«Ë¾ÎªÄú·þÎñ ¹«Ë¾µØÖ·£ºÏÃÃÅÊмκÌ·488ºÅ¹«Â·´óÏÃ12Â¥ Óʱࣺ361009 µç»°:0592-5551711 ´«Õæ:0592-5551722 µç×ÓÓʼþ£º[EMAIL PROTECTED] QQ:7168 Èç¹ûÕâ·âÓʼþ´òÈÅÄúÁË£¬ÇëËæÊÖɾµô£¬²¢Çë¼ûÁ¡£ÈôÄú²»Ï£ÍûÔÙ´ÎÊÕµ½ÎÒÃǵÄÓʼþ£¬Çëµã»÷ÕâÀï¸ÃÓʼþʹÓá°ÉÌÎñÓʼþ¹ú¼Ê¿ì³µ¡±Èí¼þ·¢ËÍ¡£ÏêÇéÇëµã»÷ÕâÀï·ÃÎÊÎÒÃǵÄÖ÷Ò³¡£×¢Òâ:±¾Èí¼þ½öÏÞÓںϷ¨ÓÃ;£¬Èç¹û·¢ËÍÀ¬»øÓʼþÔì³Éºó¹û¸ÅÓÉʹÓÃÕß×ÔÐге£! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Installing mysql in redhat linux 7.1
I have just installed redhat linux 7.1 and now need to install Mysql. with innodb support. I downloaded the rpm (3.23.51) from the mysql site and tried to install it. The process appeared to stop mysql and then complained it could not find a file: /etc/rc.d/mysql A query on rpm -qa | grep mysql showed no changes had taken place. How do I install the latest version of mysql? Should I be using the rpm ? Regards Peter Goggin Regards Peter Goggin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Installing mysql in redhat linux 7.1
If this is the first time u r installing mysql, then, rpm -i mysql.rpm. If u r updating, then rpm -u mysqlxxx.rpm should do it. The binary install is more optimized and hence is the best way to install mysql, however, rpm's work fine too. Regards, Bhavin. - Original Message - From: Peter Goggin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 03, 2002 5:12 PM Subject: Installing mysql in redhat linux 7.1 I have just installed redhat linux 7.1 and now need to install Mysql. with innodb support. I downloaded the rpm (3.23.51) from the mysql site and tried to install it. The process appeared to stop mysql and then complained it could not find a file: /etc/rc.d/mysql A query on rpm -qa | grep mysql showed no changes had taken place. How do I install the latest version of mysql? Should I be using the rpm ? Regards Peter Goggin Regards Peter Goggin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: changing a slave to a master in mysql replication
bin-log in 'needed' for a server to act as a master. This will make the server log all it's queries for the slave to follow. Don't know of a faster way. Regards, Bhavin. - Original Message - From: Vicky Gonzalez [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 03, 2002 4:54 PM Subject: changing a slave to a master in mysql replication Currently to make a slave a master, the docs say you need to set the bin-log option in my.cnf on the slave, and that will make the transition to master quicker. I know I can manually change a slave to a master by stopping the slave process, stop mysql, take a snapshot of the databases, copy over a new master my.cnf, make sure I have granted rights to a user for the old master to return as a slave, and restart. My question is how does having the bin-log option on the slave actually help this process? Or is there an easier way to convert a slave to master using the log position that I missed? Thanks in advance for any help. ~Vicky - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Bitten by a strange bug...
I had this problem to but was never able to find what was causing it. The way I got around it was by doing execute statements like: connection.execute(INSERT INTO .) That way I avoided VB handling the updates and it worked. But since Josh pointed this little problems solution out I might give that a try. -Nick Tom - I'll address what I can I had the same problem with fields being truncated on direct connections (the problem does not manifest on ODBC table attaches in Access). IIRC, the way to solve this problem is to make sure the optimize columns widths (option 1) in the ODBC properties. Hope that helps (at least a little). j- k- On Wednesday 28 August 2002 15:37, Tom Emerson wrote: But enough of the background, here is the problem: developing a visual-basic (6) application using myodbc connected to a mysql database on the network. Adding records works well the first time, but after the database has closed (i.e., the next time I run the program), I run into problems. I've tracked it down to what VB believes is the maximum field size for a given field, and it appears to be limited to whatever the longest value is in the particular field -- when a table is new (empty), there are no entries, so VB thinks the fields are -1 in length (technically, unlimited), and the program works fine. The next time the program runs, the fields definedlength property is set to whatever the longest value happens to be in the table (hence the ugly workaround is to insert a bogus entry with spaces or some filler character padded out to the maximum length -- this is fine for master [key] tables, but for detail entries it might become problematic.) I've even tried the pad char fields to maximum option via the ODBC driver window in the control panel, but that doesn't seem to have any effect. -- Joshua Kugler, Information Services Director Associated Students of the University of Alaska Fairbanks [EMAIL PROTECTED], 907-474-7601 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 a slave to a master in mysql replication
Bhavin Vyas wrote Tuesday, September 03, 2002 9:02 PM in response to: To: Vicky Gonzalez; [EMAIL PROTECTED] Subject: Re: changing a slave to a master in mysql replication bin-log in 'needed' for a server to act as a master. This will make the server log all it's queries for the slave to follow. Don't know of a faster way. Thanks for the prompt reply, I understand why bin-log is needed for a master, but I was questioning the usefulness of having the bin-log setting for a slave while it's running as a slave. When the slave becomes a master, doesn't it need a new my.cnf (which would have the bin-log set) or can it become a master with its slave my.cnf? If it can become a master using the slave my.cnf (which has the bin-log set) what commands would I need to call to make it a master now, and no longer a slave to its old master? Thanks again! ~Vicky - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Help!! Extreme newbie
Being new to MYSQL as well as this list, I'm hoping you'll forgive what I'm sure will be a rather dumb question... I just installed mysql on a new install of SUSE 8.0 and every time I try to connect to the mysql server as a non root use I am denied access..have changed passwords, granted permissions, flushed permissions and yet nothing seems to work... Any suggestions? Thanks, Al Davis AKA extreme mysql/linux newbie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 a slave to a master in mysql replication
As far I know, it would help to leave it set. All the queries executed by the slave to follow the master have the master's server id associated with them. The one's which don't have that id will be replicated by the new slave(old master), there by making the process easier and faster. Regards, Bhavin. - Original Message - From: Vicky Gonzalez [EMAIL PROTECTED] To: Bhavin Vyas [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, September 03, 2002 6:16 PM Subject: RE: changing a slave to a master in mysql replication Bhavin Vyas wrote Tuesday, September 03, 2002 9:02 PM in response to: To: Vicky Gonzalez; [EMAIL PROTECTED] Subject: Re: changing a slave to a master in mysql replication bin-log in 'needed' for a server to act as a master. This will make the server log all it's queries for the slave to follow. Don't know of a faster way. Thanks for the prompt reply, I understand why bin-log is needed for a master, but I was questioning the usefulness of having the bin-log setting for a slave while it's running as a slave. When the slave becomes a master, doesn't it need a new my.cnf (which would have the bin-log set) or can it become a master with its slave my.cnf? If it can become a master using the slave my.cnf (which has the bin-log set) what commands would I need to call to make it a master now, and no longer a slave to its old master? Thanks again! ~Vicky - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Installing mysql in redhat linux 7.1
I use the 4.x branch for innodb support. Hrmm, did you download ALL the rpm's? the client, the server and libs i think. I suggest backup/dump your databases first before doing a reinstall. I also strongly suggest you install from the source so you can customize your installation of MySQL better. Respectfully yours, Sherwin T. Ang Systems Administrator Internet Manila http://www.i-manila.com.ph Tridel Technologies Inc. 7F Hanston Building Emerald Avenue Ortigas Center Pasig City 1605 Metro Manila Philippines (632) 634.5140 Local 1024 - Original Message - From: Peter Goggin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 04, 2002 8:12 AM Subject: Installing mysql in redhat linux 7.1 I have just installed redhat linux 7.1 and now need to install Mysql. with innodb support. I downloaded the rpm (3.23.51) from the mysql site and tried to install it. The process appeared to stop mysql and then complained it could not find a file: /etc/rc.d/mysql A query on rpm -qa | grep mysql showed no changes had taken place. How do I install the latest version of mysql? Should I be using the rpm ? Regards Peter Goggin Regards Peter Goggin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Help!! Extreme newbie
Pada Tue, 3 Sep 2002 21:40:44 -0400 Al Davis [EMAIL PROTECTED] menulis : Being new to MYSQL as well as this list, I'm hoping you'll forgive what I'm sure will be a rather dumb question... I just installed mysql on a new install of SUSE 8.0 and every time I try to connect to the mysql server as a non root use I am denied access..have changed passwords, granted permissions, flushed permissions and yet nothing seems to work... you can't login from non-root shell account ? try to use mysql like this : shell mysql -uroot and to assign mysql root password : shell mysqladmin -uroot password new-password-for-mysql-root-user and to create new mysql user: mysql grant all privileges on *.* to username@localhost/hosts identified by password; mysql flush privileges; -- Write clearly - don't be too clever. - The Elements of Programming Style (Kernighan Plaugher) MySQL 3.23.51 : up 74 days, Queries : 358.074 per second (avg). -- Dicky Wahyu Purnomo - System Administrator PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan 12790 Phone : +62 21 79199577 - HP : +62 8551044244 - Web : http://www.1rstwap.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: Cross Database Table Join
Pada Tue, 3 Sep 2002 19:28:33 -0400 Bob Davis [EMAIL PROTECTED] menulis : I'm trying to do a cross database mysql query. Does anyone know of a way to do this? I've looked through all the documentation I can find including release 4.0. what kind of query do want to do ? shell mysql -p DB_A mysql select * from DB_B.Table_B1; it's crossing other DB ;-) -- Let's call it an accidental feature. -- Larry Wall MySQL 3.23.51 : up 75 days, Queries : 358.102 per second (avg). -- Dicky Wahyu Purnomo - System Administrator PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan 12790 Phone : +62 21 79199577 - HP : +62 8551044244 - Web : http://www.1rstwap.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: stored procedures and triggers
That's only if you access it directly from client. What I was talking about is AppServer sitting next to MySQL server. Preferably on the same computer. Agree that for some cascade actions triggers are very useful. But most of the folks just try to push all business logic into sp/triggers. And that's better to do in AppServer for large-scale apps. So it's strange when the initial poster said that they are core of his development. Because they shouldn't be. Yuri. Yuri. I don't agreed Yuri. triggers and sp are really useful and make the process run faster. Think on this: the user is trying to delete a record on a table. The primary key of that table is present in several other tables in the database. Before deleting the record you should search in every table for the primary key to be deleted, and if you find it the record couldn't be deleted. Well, with triggers and sp, all the job of opening every related table and look for the primary key will take place in the server, minimizing time and network traffic. Without triggers and sp, you have to manually code the process and every table you open is a request to the server and data navigating trough the network. The process is slower and more vulnerable in a non secure network. In an Internet environment triggers and sp take more importance. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
row level locking .. urgent
Hi, I have did setup for MySQL - Innodb tables. But I am not getting support for row level locks. Whenever I am issuing a update the innodb tables are locking my tables. Please help me whether I need to set any variables in sqld file to get the support for row level locks ??? Regards, Sekhar - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: row level locking .. urgent
On Wed, Sep 04, 2002 at 10:28:36AM +0530, Sekhar.Thota wrote: Hi, I have did setup for MySQL - Innodb tables. But I am not getting support for row level locks. Whenever I am issuing a update the innodb tables are locking my tables. Please help me whether I need to set any variables in sqld file to get the support for row level locks ??? Have you read the InnoDB manual at www.innodb.com yet? -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 28 days, processed 577,372,495 queries (231/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
