precompiled queries
Hello, MySQL does not use precompiled queries so that it has to parse the text of the query at each request. Do you know why this choice has been done ? and if it is planned to add this fonctionnality to the API and if not, why ? -- Loïc mel : [EMAIL PROTECTED] toile : http://www.le-loarer.org/ heaven is not a place, it's a feeling Il y a 3 catégories de mathématiciens. Ceux qui savent compter, et ceux qui ne savent pas. Le mois de l'année où le polytechnicien dit le moins de conneries, c'est le mois de février, parce qu'il n'y a que vingt-huit jours. (Coluche) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Access is denied
Hello, I installed Mysql on NT workstation. The installation finished successfully. I launched the winmysqladmin.exe file and define a user for my DB. When I tried to connect to this DB with the user I have just defined I got an error : Access denied for user : 'usr@localhost' using password : YES I did the same thing on other few workstation and it worked fine, Thanks for help Meital Issers
Re: Access is denied
you probably forgot to do any one of the things described in the manual which are required for permissions changes to take effect - Original Message - From: Meital Issers [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 14, 2001 6:04 PM Subject: Access is denied Hello, I installed Mysql on NT workstation. The installation finished successfully. I launched the winmysqladmin.exe file and define a user for my DB. When I tried to connect to this DB with the user I have just defined I got an error : Access denied for user : 'usr@localhost' using password : YES I did the same thing on other few workstation and it worked fine, Thanks for help Meital Issers - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 connect MsAccess to MySQL
Hi! I used ODBC driver to connect to MySQL server from MsAccess. Is there another method how I can get data from MySQL and show it's in MsAccess forms? Thanks for any response! Andis
Re: Root account cannot access Mysql
On Wed, Jun 13, 2001 at 04:56:23PM -0400, RIDLEY, JAMES A. (AIT) wrote: Hi, I somehow locked out the root account from MySQL. How can I get access back as root on the Unix system? Try this : /path/to/mysql-directory/libexec/mysqld --skip-grant-tables In a second term, just run mysql -p - password: hit enter Works for me... James A Ridley System Administrator AIX ITO Midrange Support Ameritech/SBC Telecommunications Inc. (317)265-4252 work (317)673-3670 pager -- Met vriendelijke groet/With kind regards, Cable Wirelesshttp://www.widexs.nl Wouter de Jong System-Administrator Tel +31 23 5698070 Fax +31 23 5698099 Bijlmermeerstraat 62, 2131 HG HOOFDDORP, NL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: load-balancing with NFS
On Wed, Jun 13, 2001 at 08:55:50PM +0200, Sven Huster wrote: Hi Hi, As far as i know, DON'T DO THIS mysql with serveral instances accessing the same database will not work as expected. check http://www.mysql.com/doc/M/u/Multiple_servers.html Thanks, I'll skip the plan. No load-balancing for me thus : we run mysql over nfs but only with one instance. seems to be quite stable (db server freebsd - nfs server netapp filer) regards Sven Huster Senior IT Systems Engineer -Original Message- From: Wouter de Jong [mailto:[EMAIL PROTECTED]] Sent: 13 June, 2001 10:21 To: [EMAIL PROTECTED] Subject: load-balancing with NFS *This message was transferred with a trial version of CommuniGate(tm) Pro* Hello, I have an idea about setting up 1 machine that contains the var-directory (RAID5 for backup, etc). Then I mount the var directory from 2 (to explain now :) other servers, via NFS, and run mysqld on those. My question : is this going to work ? I mean, will mysqld allow me to have a shared /var/ directory for all databases inside ? I want load-balancing, cause my server can't handle the pressure good anymore. database-01 IN A 192.168.0.101 database-01 IN A 192.168.0.102 192.168.0.101: (running mysqld) 192.168.0.100:/opt/database/mysql/var /opt/database/mysql/var 192.168.0.102: (running mysqld) 192.168.0.100:/opt/database/mysql/var /opt/database/mysql/var 192.168.0.100: will be NFS-mounted by the 2 mysqld machines And how to configure MySQL with RAID(5) (3 disks, 1 spare) ? Is --with-raid anough, and everything will go automatically good ? I don't have to use other table-types then MyISAM ? Thanks for any input : -- Met vriendelijke groet/With kind regards, Cable Wirelesshttp://www.widexs.nl Wouter de Jong System-Administrator Tel +31 23 5698070 Fax +31 23 5698099 Bijlmermeerstraat 62, 2131 HG HOOFDDORP, NL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Met vriendelijke groet/With kind regards, Cable Wirelesshttp://www.widexs.nl Wouter de Jong System-Administrator Tel +31 23 5698070 Fax +31 23 5698099 Bijlmermeerstraat 62, 2131 HG HOOFDDORP, NL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 do I do this
Hi, I have two table: mysql select * from hotel limit 10 - ; +++ | id | hotelname | +++ | 1 | Adams Beach| | 2 | Aegean Village | | 3 | Angela | | 4 | App. in Ayja | | 5 | Apt Alfaga | | 6 | Apt. Central Playa | | 7 | Arabia Beach | | 8 | Asterias Beach | | 9 | Baron | | 10 | Bel Air| +++ and travel +-+ | nome_hotel | +-+ | Vol seul| | Carina | | Relax | | Mistral | | Esperides Beach | | Vol seul| | Angela | | Marmari Beach | | Summer Palace | | Aegean Village | +-+ What I want to do is replace the nome_hotel field with the ids of the hotel table for names that match the hotel.hotelname in the travel.nome_hotel. How do I do this. TIA Adrian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 MyODBC
Hi Benjamin, On Wed, 13 Jun 2001, Benjamin Pflugmann wrote: Sounds as if you have to install a newer MySQL package. Use Seems like. Which is the stable version now? rpm -qf /usr/lib/mysql/libmysqlclient.so.9.0.0 The result mysql-3.23.22-6 Or compile it yourself. ;-) That is my last option :-( Cheers Adrian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
lotus smart suit and myodbc
Hi All, I'm new at your list and I need your help. On my linux-server (suse7.1) runs mysql. I want to work from a win2000-client with lotus-aproach on my linux-database. I've installed myodbc and it works with ms-access but not with lotus. I hope somebody can tell me how I have to configure myodbc. Many thanks for your help!! Karl-Jens Bacher Agentur Dallmann KG Rosenweg 3 23898 Sandesneben www.agentur-dallmann.de [EMAIL PROTECTED] Tel: 04536 - 89 98 10 Fax: 04536 - 89 98 20 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
tuning user's variable understanding
hi ppl! I have two consequent queries select @g1=user from user_space where connects10 and select connect_time from connects where user=@g1 To prevent misunderstanding I say that I don't want to use joining as in my case tis very slow operation. My question is: when I proceed these two queries using mysql_query() I get success but when I get the result using mysql_store_result() and mysql_fetch_row() I get the result for the first query. Does that mean that I need to get both results from server? If so - can I avoid fetching useless data and skip getting first query result and get only the next one? Thanks, Alex - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Getting MySQL-3.23.35/up working on my box.
SDiZ Cheng writes: I cannot find the core file.. where is it? BTW, system seems somtimes run out of file handles / max processes. There is some more information to provide: mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died Attemping backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong Cannot determine thread, ebp=0xb3d8, backtrace may not be correct stack range sanity check, ok, backtrace follows 0x40078dd4 _end + 937886004 0x40077f05 _end + 937882213 0x80afda1 create_new_thread__FP3THD + 937 0x80b03a5 handle_connections_sockets__FPv + 1185 0x80af6a7 main + 2539 0x4010b2db _end + 938485307 0x8089971 _start + 33 New value of ebp failed sanity check terminating backtrace Number of processes running now: 0 010613 22:29:24 mysqld restarted /usr/local/mysql/libexec/mysqld: ready for connections 010613 22:29:25 Warning: Checking table: './Counter/common_one_IP' 010613 22:29:25 Warning: Checking table: './Counter/common_one' 010613 22:29:29 Warning: Checking table: './user/log' 010613 22:29:29 Warning: Checking table: './Counter/taikoo_taikoo_IP' 010613 22:29:29 Warning: Checking table: './Counter/taikoo_taikoo' mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died Attemping backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong Cannot determine thread, ebp=0xb3d8, backtrace may not be correct stack range sanity check, ok, backtrace follows 0x40078dd4 _end + 937886004 0x40077f05 _end + 937882213 0x80afda1 create_new_thread__FP3THD + 937 0x80b03a5 handle_connections_sockets__FPv + 1185 0x80af6a7 main + 2539 0x4010b2db _end + 938485307 0x8089971 _start + 33 New value of ebp failed sanity check terminating backtrace Number of processes running now: 0 010613 22:29:56 mysqld restarted /usr/local/mysql/libexec/mysqld: ready for connections HI! core file, if created is in datadir directory. The above looks like it is caused either by imperfect build of MySQl or by corrupted tables. Use our binary for Linux and check tables for corruption. Regards, For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /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
Help: Replication between 2 tables
Hello, I am trying to set up mysql replication between 4 machines each with version 3.23.38 installed. My problem is that the master database has a table called metadata and the slaves have the same table but called METADATA. Is there a replicate-rewrite-table option, or do I need to trap the selects on metadata and convert them to lowercase in the code to get the replication to work ?... Steven Goodliff. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 compilation problem
hi, had some problems while installing mysql-3.23.38 unzip and tar already did the following: 1) ./configure --prefix=/usr/home/domain/mysql --with-low-memory \ --with-unix-socket-path=/usr/home/domain/mysql/mysql-domain.sock 2)unlimit 3)make everything was going fine until an error appears: make: don't know how to make mi_test_all. Stop *** Error code 1 tried to use gmake -s, it was compiling halfway when it ended with an error virtual memory exhausted. i'm trying to install mysql over telnet with my internet service provider which uses BSDI BSD/OS 4.2 as their Operating System. can anyone please help? thank you. Regards, TonyTee
RE: Help: Replication between 2 tables
http://www.mysql.com/doc/N/a/Name_case_sensitivity.html Rename the METADATA table on the slaves to metadata and start mysqld with -O lower_case_table_names=1. Hello, I am trying to set up mysql replication between 4 machines each with version 3.23.38 installed. My problem is that the master database has a table called metadata and the slaves have the same table but called METADATA. Is there a replicate-rewrite-table option, or do I need to trap the selects on metadata and convert them to lowercase in the code to get the replication to 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: Multiple CPU's in Freebsd
Hi! What is the version of FreeBSD that makes this possible ?? -- 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:innodb text fields
Ryan, I hope it pays to wait. If you compile MySQL/InnoDB yourself, you will get unlimited BLOB and TEXT fields within 16 days. I am writing the support for them now and I will release the source code at my website. It will also be in the next binary release of MySQL/InnoDB, unless Monty releases another one this week :). Regards, Heikki Tuuri Innobase Oy Copied message: .. I am aware that currently innobase tables can not have abritararly large text/varchar fields and support for this will be released sometime in the month of June. The application I am working with requires text fields (usually less than 64k), and I desperatly need row level locking. Either I continue using Mysql, and use Innodb tables.. or I have to switch toPostgresql. I need to do something right away about this performance problem, I can not wait until Innodb tables are released with the unlimited row length. I tried to find out what the max row length for a Innodb table row, but did not find it in the documentation. If it isnt too much smaller than 64k I could switch now, and not have to worry about using postgresql. Does anyone know what the limit is? Any pointers would be apreciated. ryan . - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
hi
Hai,
i gone thro u'r mysql documentation.
but they haven't mentioned clearly.
it's really big headache for users.
using c language i want to connect to datadase and perform some
queries(select,update,insert and delete).according to u'r documentation u said that
first use mysql_int() and mysql_real_connect method to connect to the database
in which library files these buildin functions are defined.
this is my c file
#includestdio.h
#includestring.h
#includestdlib.h
#include/usr/local/mysql/include/mysql.h
#include/usr/local/mysql/include/my_net.h
#include/usr/local/mysql/include/mysqld_error.h
#include/usr/local/mysql/include/mysys_err.h
main()
{
MYSQL mysql;
mysql_init(mysql);
mysql_options(mysql,MYSQL_OPT_COMPRESS,0);
mysql_options(mysql,MYSQL_READ_DEFAULT_GROUP,odbc);
if (!mysql_real_connect(mysql,localhost,user=root,,InControl,0,NULL,0))
{
printf(stderr,Failed to connect to database: Error:
%s\n,mysql_error(mysql));
}
}
mysql_init() and mysql_real_connect() are build in functions.
in which library files they defined this functions.
pls mail me in detail
Regards
Lakshmi
Character sets!!
I was wondering if there were any good instructions somewhere on how to make custom character sets for MySQL. Is it necessary to compile them into the database and are the values in the arrays ASCII character values or maybe Unicode? Thanks in advance! Stefán Jökull Sigurðarson - Programmer [EMAIL PROTECTED] - Icelandic Energy Authority
concated comparisons stopped working properly
mysql select (1 5 3); +-+ | (1 5 3) | +-+ | 1 | +-+ 1 row in set (0.00 sec) mysql select (1 5 and 5 3); ++ | (1 5 and 5 3) | ++ | 0 | ++ 1 row in set (0.00 sec) This is really strange, and I remember that in 3.23.38 it worked correctly (1 5 3 returned 0) My table is InnoDB. Thanks Nico - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Replication and primary key autoinc issue
Hello! I have two databases that i want to replicate: each database should contain the same information. That's why i have set a circular replication relation. All works fine, except that one of the table is filled in real-time; this table has a primary key with autoinc type. When a new record is inserted in database 1, and simultaneously a new record is also inserted in database 2, they managed to have the same value for the primary key. So replication is no more possible. Any idea? Thanks in advance, Fabien Balageas
Re: hi
Try link is with -L/path to your library -lmysqlclient You need library libmysqlclient which is currently in instaldir/lib/mysql/... --- Dvoøáèek Michal mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fwd: Re: Access Database into mysql
My replies seem to never send to the mysql-list
but to the ppl who sent a request only, so
I am forwarding this again.
Maybe it will help other ppl as well :)
Nessi
Date: Wed, 13 Jun 2001 11:36:41 +0100
To: Ute Hoffmann [EMAIL PROTECTED]
From: Nessi [EMAIL PROTECTED]
Subject: Re: Access Database into mysql
Hi there,
I had to do the same thing.
I guess I did it the hard way since I didnt have any modules or perl.
It took me some time to figure it out and I wrote a little procedure:
[schnipp]
3. Load data into table from *.txt:
LOAD DATA [LOW_PRIORITY] [LOCAL] INFILE 'file_name.txt' [REPLACE | IGNORE]
INTO TABLE tbl_name
Example:
(You have to upload the txtfile onto the server (here root), log into the
database, use database, then command line:)
load data infile /something.txt into table tablename fields terminated
by ;;
Be sure to use ; as delimiter NO or around the fields AND replace all
with \, with \ and ; with \; in the contents.
[/schnipp]
When you export make sure to use some delimiter you are sure isnt in the
database like # or \, for paranthesis choose {none},
then replace all the '; etc as mentioned above, then replace the
delimiter with ;
This has worked for me...hope it helps you or anybody else! :)
Cheers, Nessi
RE: Replication and primary key autoinc issue
Goodday This is exactly what I have had problems with, and in the manual it tells you that autoincrement fields are not supported in circular replication. I posted a MSG on this group asking for feedback from the developers but got nothing. You have to dump he autoincrement, and do it manually in your problem. I have a table called sbcontrol and in it I have columns for each table that I HAVE to have to have an autoincrement number for, and the rows are my branches. So when I save a record Ijust update this table and use the number as my increment, works fine. Each branch starts generating at different places, one is 10 billion, the second starts at 20 billion and so on. BYe bye ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] ]On Behalf Of Fabien Balageas Sent: 14 June 2001 13:59 To: '[EMAIL PROTECTED]' Subject: Replication and primary key autoinc issue Hello! I have two databases that i want to replicate: each database should contain the same information. That's why i have set a circular replication relation. All works fine, except that one of the table is filled in real-time; this table has a primary key with autoinc type. When a new record is inserted in database 1, and simultaneously a new record is also inserted in database 2, they managed to have the same value for the primary key. So replication is no more possible. Any idea? Thanks in advance, Fabien Balageas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 exporting to spreadsheet
I would like to use MySQL to manage my company data, but my clients want all their information sent to them in an Excel spreadsheet. Presently I use Access, and export a SELECT statement into Excel, and then make a couple changes to the Excel file (I just high-lite the updated data). I want to change the database to MySQL on a Linux box, but the biggest issue is being able to export into Excel. I know I can export to a tab-delimited text file, but I would prefer to do it all in one step. Any ideas? -- Paul Lamping Terminal Velocity 4960 S Packard Ave Cudahy WI 53110 414 489-1663 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: HAVING [cond...] problem
Have you tried: HAVING ( Avg_Xmit 28800 ) AND ( Samples = 10 ) ? Cliff Daniel wrote: I'm having some difficulting on 3.23.38, linux x86... When I write the following query the HAVING clause is only listening to the 'AND Samples = 10' and displas all Avg_Xmit regardless if it's less than or equal to 28800. If I remove the 'AND Samples = 10' I get the correct results, but of course samples are permitted if less than 10, which I do not want. Any ideas? SELECT INET_NTOA(NAS_Identifier), NAS_DS1, AVG(Ascend_Xmit_Rate) as Avg_Xmit, AVG(Ascend_Data_Rate) as Avg_Recv, AVG(Acct_Session_Time) / 60 as ACHT, COUNT(*) as Samples FROM tbl_data_call_detail WHERE Acct_Session_Time 0 GROUP BY NAS_Identifier, NAS_DS1 HAVING Avg_Xmit 28800 AND Samples = 10 ORDER BY Avg_Xmit DESC Regards, Cliff - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [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: concated comparisons stopped working properly
nsabbi wrote: mysql select (1 5 3); +-+ | (1 5 3) | +-+ | 1 | +-+ 1 row in set (0.00 sec) mysql select (1 5 and 5 3); ++ | (1 5 and 5 3) | ++ | 0| ++ 1 row in set (0.00 sec) This is really strange, and I remember that in 3.23.38 it worked correctly (1 5 3 returned 0) My table is InnoDB. Thanks Nico - And why do you think it should return 0 ? ( 1 5 ) returns 1. ( 1 3 ) returns 1. ( 1 5 3 ) should then return 1. Or am I missing something? -- Gerald L. Clark [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: Multiple CPU's in Freebsd
Hi Sinisa, Since matt hasn't responded yet, I'll let you know, its not the version of FreeBSD, but the ports collection. The ports collections does not have a version number, people should just fetch latest (using cvsup) however you can fetch by date. A package in the ports collection may require a particulur version of soemthing else (ie OS or Library) but when the package is built it will check and update or error as necessary. I can give you more details if you want Sinisa. Ken - Original Message - From: Sinisa Milivojevic [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, June 14, 2001 7:11 AM Subject: Re: Multiple CPU's in Freebsd Hi! What is the version of FreeBSD that makes this possible ?? -- 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Multiple CPU's in Freebsd
Ken Menzel writes: Hi Sinisa, Since matt hasn't responded yet, I'll let you know, its not the version of FreeBSD, but the ports collection. The ports collections does not have a version number, people should just fetch latest (using cvsup) however you can fetch by date. A package in the ports collection may require a particulur version of soemthing else (ie OS or Library) but when the package is built it will check and update or error as necessary. I can give you more details if you want Sinisa. Ken Thanks for the info Ken. The info that you have provided is truly sufficient. We shall try to change building process of MySQL for FreeBSD as soon as it becomes feasible. -- 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: Re: Cannot install mysql from source distribution
On Wed, Jun 13, 2001 at 06:02:52PM -, [EMAIL PROTECTED] wrote: database,sql,query,table [Hint to list maintainer: add 3.23 as a string that gets a message through - even better, collect a copy of the next 100 legitimate messages you bounce, and collect keywords from them sufficient to get at least 98% through. Or set your filter so that mail from those subscribed to the list goes through without the keyword search, and just apply it to those not subscribed.] The flag is -lz, but I'm not remembering the ideal place to add it : ( If you have zlib installed and you then run configure, check the Makefile and see if -lz has found its way in. If not, the installation docs give some sample manual gcc lines, adding -lz to that would do it. Not sure where it belongs in the Makefile if you're trying to use make to compile. Whit On Wed, Jun 13, 2001 at 09:19:09AM -0700, Mark Vann wrote: How do you do this? --- Whit Blauvelt [EMAIL PROTECTED] wrote: Even if you have the zlib library, you may have to add the flag for it manually - it's not properly found by the configure routine as of 3.23.37, at least on Debian Linux 2.2. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[ANNOUNCE] MM.MySQL JDBC Driver Version 2.0.5 Released
CHANGELOG: - Fixed ResultSet.getBlob() ArrayIndex out-of-bounds - Fixed ResultSetMetaData.getColumnTypeName for TEXT/BLOB - Fixed ArrayIndexOutOfBounds when sending large BLOB queries (Max size packet was not being set) - Added ISOLATION level support to Connection.setIsolationLevel() - Fixed NPE on PreparedStatement.executeUpdate() when all columns have not been set. - Fixed data parsing of TIMESTAMPs with 2-digit years - Added Byte to PreparedStatement.setObject() - ResultSet.getBoolean() now recognizes '-1' as 'true' - ResultSet has +/-Inf/inf support - ResultSet.insertRow() works now, even if not all columns are set (they will be set to NULL) - DataBaseMetaData.getCrossReference() no longer ArrayIndexOOB - getObject() on ResultSet correctly does TINYINT-Byte and SMALLINT-Short Get your copy today from http://mmmysql.sourceforge.net/ (the link is in the News section). -Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL 4
Hi. Our clients are asking for AND searches in fulltext fields. The manual says it's already implemented in the 4.0 tree. Can anyone tell me when we will see a public version of MySQL featuring AND searches in fulltext fields? = Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 client
Hi, I'm looking to get a mySQL client on a PPC LynxOS board talking to a MySQL Server on PPC Linux. The server is up and running, but I now need to get the LynxOS client, and am cross compiling from Solaris to Lynx with the Lynuxworks toolkit v3.1 and unfortunately not getting very far. So far I haven't been able to get past the ./configure. Using ./configure --target=ppc-xcoff-lynxos --without-server -libdir=/usr/vendor/lynx/3.1.0/ppc/lib --includedir=/usr/vendor/lynx/3.1.0/ppc/usr/include it craps out at the tests (sprintf, int8, etc) with the following type of error... configure: error: can not run test program while cross compiling As each error occurs I've removed the test from the configure script. But still can't seem to get things working, or even a make file. Has anyone out there gotten it to work for LynxOS? Would greatly like to hear from you. TIA RikD. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Multiple CPU's in Freebsd
---Reply to mail from Sinisa Milivojevic about Multiple CPU's in Freebsd Ken Menzel writes: Hi Sinisa, Since matt hasn't responded yet, I'll let you know, its not the version of FreeBSD, but the ports collection. The ports collections does not have a version number, people should just fetch latest (using cvsup) however you can fetch by date. A package in the ports collection may require a particulur version of soemthing else (ie OS or Library) but when the package is built it will check and update or error as necessary. I can give you more details if you want Sinisa. Ken Thanks for the info Ken. The info that you have provided is truly sufficient. We shall try to change building process of MySQL for FreeBSD as soon as it becomes feasible. Hello First of all, thank you to everybody who came with good suggestions and fixes. I have the 4xCpu machine with freebsd and mysql using all of then, and it looks pretty good :-) (we'll see when I finish testing it ;-) ). One idea will be to put this information in the Mysql-manual so anybody who ones to install/compile from source in freebsd can do it without the problems we have had. Sincerely rafael Martinez - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Crashing
I use MySQL with PHP on a BSD server. For the last week or so I've been getting errors. My problem is that I'm not sure how to read the error code: Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) in /usr/home/thebookc/usr/local/etc/httpd/conf/INIFile on line 22 Warning: 0 is not a MySQL link index in /usr/home/thebookc/usr/local/etc/httpd/conf/INIFile on line 936 SYSTEM ERROR: Please contact database administrator. Error: :: Location: selectLgBanner *** If I use the kill command and then shutdown and restart the system comes back up. Then it crashes again... Can anyone tell me how to read this error message. What's going on? Anywhere that I can read to find out more about how to diagnose errors? Are there any good MySQL news groups Thanks, David Addison Transit ID, LLC.
indexing = NP complete??
Just kidding! But it seems that way... Indexing a 7 million row VARCHAR(255) table took ~12 minutes on my Athlon 1.33Ghz w/512MB. Indexing a 77 million row VARCHAR(255) table has taken 9 DAYS, and still hasn't finished. Obviously this isn't a linearly scaling operation, but it is seeming dang near exponential at the moment. Does anyone have any experience with this? Should it be taking this long? MySQL rips through the first few million rows, but after that it seems to slow to a near halt. Please don't tell me this will take twice the age of the universe to finish... Thx, -robin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
: log event entry exceeded max_allowed_packet
Hello, I'm trying to set up replication, but I cant get any further than this message on the slave. Error reading packet from server: log event entry exceeded max_allowed_packet My max allowed packet size is 512M which I've gradually reached while trying to stop the above error message. Is this the real problem or is there another issue causing this ? Cheers Steve Goodliff
Crazy Query
Hi: We have a set-up that consists of mySQL running on Linux (rh6.2) with Crystal Reports running reports on another machine. Everytime the report is ran and CR grabs it's data through the query listed below, it ties up mySQL (top reports processor % used is 90%+) and never seems to end. We've even added a limit 50 on the end with no success. Now, I look at posting my query as the same as someone posting code and asking others to debug it. But I don't know what else to do at this point. The query is pretty clean, as you can see. Any ideas? Thanks SELECT DISTINCT bid_journal1.time, bid_journal1.ugroup, bid_journal1.type, bid1.id, bid1.status, bid1.int_1_time_1, bid1.int_2_time_1, bid1.int_3_time_1, bid1.no_show, bid1.offered_rate, bid1.offered_salary, bid1.settled_rate, bid1.settled_salary, job1.id, job1.title, job1.rate, agency1.time, agency1.rank, agency1.name, agency_location1.capability, agency_location1.location, agency_location1.type, job_admin_releases1.id, job_releases1.id, job_agency_releases1.job_release_id FROM bid_journal bid_journal1, bid bid1, job job1, agency agency1, agency_location agency_location1, job_admin_releases job_admin_releases1, job_releases job_releases1, job_agency_releases job_agency_releases1 WHERE bid_journal1.bid_id = bid1.id AND bid1.job_id = job1.id AND bid1.agency_id = agency1.id AND agency1.id = agency_location1.agency_id AND job1.id = job_admin_releases1.job_id AND job_admin_releases1.id = job_releases1.job_admin_release_id AND job_releases1.id = job_agency_releases1.job_release_id ORDER BY agency1.name ASC, job1.id ASC, bid1.id ASC Jeremy
Re: Getting MySQL-3.23.35/up working on my box.
I am using the MySQL offical binary. It's okay now.. Just curious.. what distro and gcc/glibc version MySQL team use to compile their linux binary? -- Cheng Yuk Pong (SDiZ) 4096/1024 DH/DSS 0xA4C6FAD3 FE28 E6D4 AD21 5D4F F07B EEA6 3C88 5DBB A4C6 FAD3 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Crazy Query
What happens when you run this with the OPTIMIZE command? Simon -Original Message- From: Hise, Jeremy [mailto:[EMAIL PROTECTED]] Sent: 14 June 2001 17:03 To: Mysql (E-mail) Subject: Crazy Query Hi: We have a set-up that consists of mySQL running on Linux (rh6.2) with Crystal Reports running reports on another machine. Everytime the report is ran and CR grabs it's data through the query listed below, it ties up mySQL (top reports processor % used is 90%+) and never seems to end. We've even added a limit 50 on the end with no success. Now, I look at posting my query as the same as someone posting code and asking others to debug it. But I don't know what else to do at this point. The query is pretty clean, as you can see. Any ideas? Thanks SELECT DISTINCT bid_journal1.time, bid_journal1.ugroup, bid_journal1.type, bid1.id, bid1.status, bid1.int_1_time_1, bid1.int_2_time_1, bid1.int_3_time_1, bid1.no_show, bid1.offered_rate, bid1.offered_salary, bid1.settled_rate, bid1.settled_salary, job1.id, job1.title, job1.rate, agency1.time, agency1.rank, agency1.name, agency_location1.capability, agency_location1.location, agency_location1.type, job_admin_releases1.id, job_releases1.id, job_agency_releases1.job_release_id FROM bid_journal bid_journal1, bid bid1, job job1, agency agency1, agency_location agency_location1, job_admin_releases job_admin_releases1, job_releases job_releases1, job_agency_releases job_agency_releases1 WHERE bid_journal1.bid_id = bid1.id AND bid1.job_id = job1.id AND bid1.agency_id = agency1.id AND agency1.id = agency_location1.agency_id AND job1.id = job_admin_releases1.job_id AND job_admin_releases1.id = job_releases1.job_admin_release_id AND job_releases1.id = job_agency_releases1.job_release_id ORDER BY agency1.name ASC, job1.id ASC, bid1.id ASC Jeremy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Crazy Query
Yes. I actually forgot to specify that. We thought maybe the ODBC/CR was causing some overhead problems. So we did go straight to the monitor. But we got the same problem. -Original Message- From: Huntress Gary B NPRI [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 14, 2001 12:12 PM To: 'Hise, Jeremy' Subject: RE: Crazy Query The first thing I would do is open the mysql client on the redhat box and try to run this query directly. Have you tried that? Regards, Gary Huntress Code 4113 Naval Undersea Warfare Center Newport, RI 02841 1-800-669-6892 x28990 -Original Message- From: Hise, Jeremy [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 14, 2001 12:03 PM To: Mysql (E-mail) Subject: Crazy Query Hi: We have a set-up that consists of mySQL running on Linux (rh6.2) with Crystal Reports running reports on another machine. Everytime the report is ran and CR grabs it's data through the query listed below, it ties up mySQL (top reports processor % used is 90%+) and never seems to end. We've even added a limit 50 on the end with no success. Now, I look at posting my query as the same as someone posting code and asking others to debug it. But I don't know what else to do at this point. The query is pretty clean, as you can see. Any ideas? Thanks SELECT DISTINCT bid_journal1.time, bid_journal1.ugroup, bid_journal1.type, bid1.id, bid1.status, bid1.int_1_time_1, bid1.int_2_time_1, bid1.int_3_time_1, bid1.no_show, bid1.offered_rate, bid1.offered_salary, bid1.settled_rate, bid1.settled_salary, job1.id, job1.title, job1.rate, agency1.time, agency1.rank, agency1.name, agency_location1.capability, agency_location1.location, agency_location1.type, job_admin_releases1.id, job_releases1.id, job_agency_releases1.job_release_id FROM bid_journal bid_journal1, bid bid1, job job1, agency agency1, agency_location agency_location1, job_admin_releases job_admin_releases1, job_releases job_releases1, job_agency_releases job_agency_releases1 WHERE bid_journal1.bid_id = bid1.id AND bid1.job_id = job1.id AND bid1.agency_id = agency1.id AND agency1.id = agency_location1.agency_id AND job1.id = job_admin_releases1.job_id AND job_admin_releases1.id = job_releases1.job_admin_release_id AND job_releases1.id = job_agency_releases1.job_release_id ORDER BY agency1.name ASC, job1.id ASC, bid1.id ASC Jeremy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: indexing = NP complete??
On Thu, Jun 14, 2001 at 11:31:32AM -0400, Robin Senior wrote: Just kidding! But it seems that way... Indexing a 7 million row VARCHAR(255) table took ~12 minutes on my Athlon 1.33Ghz w/512MB. Indexing a 77 million row VARCHAR(255) table has taken 9 DAYS, and still hasn't finished. Obviously this isn't a linearly scaling operation, but it is seeming dang near exponential at the moment. Does anyone have any experience with this? Should it be taking this long? MySQL rips through the first few million rows, but after that it seems to slow to a near halt. I have a few comments and questions: (1) Is this a unique index? If not, consider doing a partial index on the column. Index the first 32 characters or so. I'll save a lot of disk I/O, memory, and CPU time but still yeild pretty good results (depending on your data, of course). (2) What are your key_buffer and record_buffer set to? I believe that when MySQL is doing serious scanning (as needed in building an index), a larger record_buffer will help. (3) Try running `vmstat 5' on the box for a bit. Is the CPU pegged? Is it I/O bound? Is it swapping at all? Please don't tell me this will take twice the age of the universe to finish... How about 1/2 the age of the universe. But since there's still a fair amount of debate over the true age of the universe, I probably haven't helped much, have I? :-) Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 19 days, processed 136,385,255 queries (79/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
problem using mysql_fetch_row in C API
hi all, ive got a small problem (again). i have a table with an entry foo which is an int(3). my problem is that whenever i collect the values in my c program. they are returned as characters with mysql_fetch_row. (which is ok) but i cant seem to convert them into int, using something like temp = (int) row[0]; this might not (strictly) be a mysql question. but IMHO i dont think a C forum is the right place either. any reply appriciated regards kenneth johansen [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: concated comparisons stopped working properly
And why do you think it should return 0 ? ( 1 5 ) returns 1. ( 1 3 ) returns 1. ( 1 5 3 ) should then return 1. Or am I missing something? I think probably becuse ( 5 3 ) returns 0. Depends how you read it, either as 1 is less than 5 and less than 3 or 1 is less than 5 and 5 is less than 3. Of course the real question is how does MySQL read it? :-) Cheers Jon ** 'The information included in this Email is of a confidential nature and is intended only for the addressee. If you are not the intended addressee, any disclosure, copying or distribution by you is prohibited and may be unlawful. Disclosure to any party other than the addressee, whether inadvertent or otherwise is not intended to waive privilege or confidentiality' ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: threads mysql
On Thu, Jun 14, 2001 at 08:16:01AM +0100, Dvoøáèek Michal wrote: Hi there, little problem. I have program (like phorums) and there is command mark all posts as readed. On one board is about 4000 posts, and if is new user and want mark all posts as readed - it's problem (big). All is written in ANSI C (using C API functions). And here is main problem: when i execute marking thread (most of mysql code run as separately threads) and someone wants list this board (list thread) nothing happens. After about 15 seconds program show results. And if you type show command for two times program crashed. I'm not using locking tables. And question: is possible that SELECT will wait on previously or currently running INSERT and how is it multithread programs, where some threads are using same table (to avoid error like Out of synchronization, Query cannot be executed now, ) You are running into contention on table locks. MySQL will put a READ lock on a table anytime you are reading from it. Similarly it will put a WRITE lock on a table when you update it. You might want to look at a table type which has more granular locking, such as BDB or InnoDB (or Gemini, if you can wait for it). They're described in the manual, of course. P.S. Sorry for my English, it's terrible i know, but i'm working on it :) You write better than some native speakers I know! Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 19 days, processed 136,412,594 queries (79/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
RE: Crazy Query
And there are about 27000 records in agency_location...thouh I hope the number of records isn't the problem. Thanks for the suggestions. I am doing them now. Thanks! Jeremy -Original Message- From: Hise, Jeremy [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 14, 2001 12:13 PM To: Mysql (E-mail) Subject: RE: Crazy Query Yes. I actually forgot to specify that. We thought maybe the ODBC/CR was causing some overhead problems. So we did go straight to the monitor. But we got the same problem. -Original Message- From: Huntress Gary B NPRI [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 14, 2001 12:12 PM To: 'Hise, Jeremy' Subject: RE: Crazy Query The first thing I would do is open the mysql client on the redhat box and try to run this query directly. Have you tried that? Regards, Gary Huntress Code 4113 Naval Undersea Warfare Center Newport, RI 02841 1-800-669-6892 x28990 -Original Message- From: Hise, Jeremy [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 14, 2001 12:03 PM To: Mysql (E-mail) Subject: Crazy Query Hi: We have a set-up that consists of mySQL running on Linux (rh6.2) with Crystal Reports running reports on another machine. Everytime the report is ran and CR grabs it's data through the query listed below, it ties up mySQL (top reports processor % used is 90%+) and never seems to end. We've even added a limit 50 on the end with no success. Now, I look at posting my query as the same as someone posting code and asking others to debug it. But I don't know what else to do at this point. The query is pretty clean, as you can see. Any ideas? Thanks SELECT DISTINCT bid_journal1.time, bid_journal1.ugroup, bid_journal1.type, bid1.id, bid1.status, bid1.int_1_time_1, bid1.int_2_time_1, bid1.int_3_time_1, bid1.no_show, bid1.offered_rate, bid1.offered_salary, bid1.settled_rate, bid1.settled_salary, job1.id, job1.title, job1.rate, agency1.time, agency1.rank, agency1.name, agency_location1.capability, agency_location1.location, agency_location1.type, job_admin_releases1.id, job_releases1.id, job_agency_releases1.job_release_id FROM bid_journal bid_journal1, bid bid1, job job1, agency agency1, agency_location agency_location1, job_admin_releases job_admin_releases1, job_releases job_releases1, job_agency_releases job_agency_releases1 WHERE bid_journal1.bid_id = bid1.id AND bid1.job_id = job1.id AND bid1.agency_id = agency1.id AND agency1.id = agency_location1.agency_id AND job1.id = job_admin_releases1.job_id AND job_admin_releases1.id = job_releases1.job_admin_release_id AND job_releases1.id = job_agency_releases1.job_release_id ORDER BY agency1.name ASC, job1.id ASC, bid1.id ASC Jeremy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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-relationships
Hey all, This is actually more of a theory question than anything else. I have most of my databases built to 4th normal form. So that means I am have tons of foreign keys to primary keys and what-not. Almost every table is linked to another table. The only problem I can forsee is when you decide to delete a record that is being linked by another table. Many of my PHP scripts blow up when they dont see what they are suppose to see... So the linked ID (lets say 1) is still going to be in the users table but when you query it wont find the table it was being linked too!!! How do you counter act this? My system can get very complex..do I need to write a script to couteract every single possible error??? Indy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Install help for x86 Solaris 8
Hi, I hope someone out there has an answer to this problem I'm having. I'm trying to get mysql installed on a x86 Solaris 8 box, the version I'm trying to install is 3.23.39. The configure script goes through fine, when then try to make it dies out giving me this SNIP E_RWLOCK_T -c my_error.c -fPIC -DPIC -o .libs/my_error.lo my_error.c: In function `my_error': my_error.c:42: `__builtin_va_alist' undeclared (first use in this function) my_error.c:42: (Each undeclared identifier is reported only once my_error.c:42: for each function it appears in.) my_error.c: In function `my_printf_error': my_error.c:113: `__builtin_va_alist' undeclared (first use in this function) *** Error code 1 make: Fatal error: Command failed for target `my_error.lo' Current working directory /export/home/dvignes/mysql-3.23.39/libmysql *** Error code 1 make: Fatal error: Command failed for target `all-recursive' Current working directory /export/home/dvignes/mysql-3.23.39 *** Error code 1 make: Fatal error: Command failed for target `all-recursive-am' /SNIP I also tried 3.23.32 for giggles and it didn't work either, dieing at the same spot. Anyone have any ideas ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: indexing = NP complete??
On Thu, 14 Jun 2001, Jeremy Zawodny wrote: I have a few comments and questions: (1) Is this a unique index? If not, consider doing a partial index on the column. Index the first 32 characters or so. I'll save a lot of disk I/O, memory, and CPU time but still yeild pretty good results (depending on your data, of course). No, it isn't a unique index. Most of the entries are 32 chars, but I used a varchar(255) to be safe, as it only occupies the number of bytes required to record the string, plus 1 byte to record the length. There are 77million records, and I can't guarantee that they are all 32. Will the index know to only index the required number of chars, or will it do 255? What if I had used a TEXT datatype? (2) What are your key_buffer and record_buffer set to? I believe that when MySQL is doing serious scanning (as needed in building an index), a larger record_buffer will help. Unfortunately, my key_buffer is only adjusted to 64M, and the record_buffer is set at a piddling 131072... I only got into configuring mysql after I began the indexing. The other box (same specs) that I'm running is set with: set-variable=key_buffer=128M set-variable=table_cache=512 set-variable=sort_buffer=8M set-variable=record_buffer=2M I'm trying to index on that machine at the same time, by indexing as I insert. I'm guessing 2M is still far too small? Can you recommend a better config? (3) Try running `vmstat 5' on the box for a bit. Is the CPU pegged? Is it I/O bound? Is it swapping at all? Forgot to mention I'm running Win2K, don't have vmstat, sorry. Perfmon is shite, too. Please don't tell me this will take twice the age of the universe to finish... How about 1/2 the age of the universe. But since there's still a fair amount of debate over the true age of the universe, I probably haven't helped much, have I? :-) Okay, 1/2 the age is fine. Twice the age would just be silly. Thanks a ton, -robin Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 19 days, processed 136,385,255 queries (79/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
Mysql SELECT command
Can somebody please point me to the good resourse of learning mysql's SELECT command on the Internet? Thanks, - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: concated comparisons stopped working properly
Mysql version 8.0, distrib 3.22.32 select (1 5 3) = 1 select ((15) 3) = 1 select (1 (5 3)) = 0 In this version, apparently left to right. Regards, Rich At 05:16 PM 6/14/01 +0100, Jon Haworth wrote: And why do you think it should return 0 ? ( 1 5 ) returns 1. ( 1 3 ) returns 1. ( 1 5 3 ) should then return 1. Or am I missing something? I think probably becuse ( 5 3 ) returns 0. Depends how you read it, either as 1 is less than 5 and less than 3 or 1 is less than 5 and 5 is less than 3. Of course the real question is how does MySQL read it? :-) Cheers Jon ** 'The information included in this Email is of a confidential nature and is intended only for the addressee. If you are not the intended addressee, any disclosure, copying or distribution by you is prohibited and may be unlawful. Disclosure to any party other than the addressee, whether inadvertent or otherwise is not intended to waive privilege or confidentiality' ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Regards, Rich - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
create table ... select bug
Description: create table ... with a select statement at the end seems to think there are duplicate entries: How-To-Repeat: mysql create table nr_current (id int unsigned not null primary key) TYPE=HEAP select distinct protein_id from nr where current = 1; ERROR 1062: Duplicate entry '0' for key 1 mysql select * from nr where protein_id = 0; Empty set (0.02 sec) [ same result with TYPE=MyISAM ] Fix: mysql create table nr_current (id int unsigned not null primary key) type=HEAP; Query OK, 0 rows affected (0.00 sec) mysql insert into nr_current (id) select distinct protein_id from nr where current = 1; Query OK, 693878 rows affected (52.62 sec) Records: 693878 Duplicates: 0 Warnings: 0 Submitter-Id: submitter ID Originator:Aaron J. Mackey Organization: University of Virginia MySQL support: none Synopsis: erroneous duplicate row error on create table ... select Severity: non-critical Priority: low Category: mysql Class: sw-bug Release: mysql-3.23.36 (Official MySQL RPM) Server: /usr/bin/mysqladmin Ver 8.18 Distrib 3.23.36, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.36 Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 20 min 47 sec Threads: 2 Questions: 56 Slow queries: 6 Opens: 42 Flush tables: 1 Open tables: 19 Queries per second avg: 0.045 Environment: System: Linux wrpx00.bioch.virginia.edu 2.2.14-5.0smp #1 SMP Tue Mar 7 21:01:40 EST 2000 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='egcs' CFLAGS='-O6 -fomit-frame-pointer -mpentium' CXX='egcs' CXXFLAGS='-O6 -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Mar 30 08:54 /lib/libc.so.6 - libc-2.1.3.so -rwxr-xr-x1 root root 4101324 Feb 29 2000 /lib/libc-2.1.3.so -rw-r--r--1 root root 20272704 Feb 29 2000 /usr/lib/libc.a -rw-r--r--1 root root 178 Feb 29 2000 /usr/lib/libc.so Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man --without-berkeley-db --without-innobase '--with-comment=Official MySQL RPM' - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Daemon crashing (I'm going nuts here)
The only thing I could suggest is that the version of MYSQL you have is not compatible with something else that is running, like PHP perhaps, or even the version of Linux/Kernel/C-libraries. You are experiencing very strange problems, and these types of things are typically caused by incompatibility issues between different software packages. At 11:48 AM 6/13/01 -0400, Walker, Brian wrote: I'm at wits end here, I've been through the documentation multiple times, asked questions on this list, but I still cannot get this server running. I've restarted the server and everything. The only thing I know is that the mysqld daemon crashes when I try to start it. I could not have another one running since I couldn't start the thing to begin with! Here is what happens: [root@www /usr]# bin/safe_mysqld --user=mysql [1] 26103 [root@www /usr]# Starting mysqld daemon with databases from /var/lib/mysql 010612 08:37:33 mysqld ended I have to press Ctrl-C to get a prompt back. Here's what the error log says: 010612 08:17:53 mysqld started 010612 8:17:53 Can't start server: Bind on TCP/IP port: Address already in use 010612 8:17:53 Do you already have another mysqld server running on port: 3306 ? 010612 8:17:53 Aborting 010612 8:17:53 /usr/sbin/mysqld: Shutdown Complete 010612 08:17:53 mysqld ended There is nothing using 3306 because I can telnet to it (per the manuals instruction on this error message) The one last thing I can think of is that something is outdated on my system when it comes to glibc and libc versions. Here is the output from mysqlbug. Let me know if something catches your eye. Release: mysql-3.23.38 (Official MySQL RPM) Environment: machine, os, target, libraries (multiple lines) System: Linux www.sfslsports.com 2.2.14C5 #1 Mon May 8 10:14:32 PDT 2000 i586 unknown Architecture: i586 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='egcs' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='egcs' CXXFLAGS='-O6 -fno-omit-frame-pointer \ -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Apr 27 17:33 /lib/libc.so.6 - libc-2.1.3.so -rwxr-xr-x 1 root root 4101836 Sep 5 2000 /lib/libc-2.1.3.so -rw-r--r-- 1 root root 20273284 Sep 5 2000 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Sep 5 2000 /usr/lib/libc.so Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --without-berk\ eley-db --without-innodb --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ -\ -with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/\ lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man '--with-comment=Official MySQL RPM' Any ideas? Brian Walker - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
creating/dropping index - plz help
Hi, I have a database with 14 million rows which contains 3 indexes. I am trying to drop two of these indexes and create another one. However each operation takes about 12 hours. Is there anyway I can make this a lot faster by changing runtime variables and similar things. Thanks in advance, Richard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 relationship linking.....
Hey all, This is actually more of a theory question than anything else. I have most of my databases built to 4th normal form. So that means I am have tons of foreign keys to primary keys and what-not. Almost every table is linked to another table. The only problem I can forsee is when you decide to delete a record that is being linked by another table. Many of my PHP scripts blow up when they dont see what they are suppose to see... So the linked ID (lets say 1) is still going to be in the users table but when you query it wont find the table it was being linked too!!! How do you counter act this? My system can get very complex..do I need to write a script to couteract every single possible error??? Indy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqlcheck
I can't use mysqlcheck -m -A and mysqlcheck -e -A It returns with a syntax error.. But i can run mysqlcheck -A with no error. It that a known problem? -- Cheng Yuk Pong (SDiZ) 4096/1024 DH/DSS 0xA4C6FAD3 FE28 E6D4 AD21 5D4F F07B EEA6 3C88 5DBB A4C6 FAD3 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 help for x86 Solaris 8
Daniel Vignes wrote: Hi, I hope someone out there has an answer to this problem I'm having. I'm trying to get mysql installed on a x86 Solaris 8 box, the version I'm trying to install is 3.23.39. The configure script goes through fine, when then try to make it dies out giving me this SNIP E_RWLOCK_T -c my_error.c -fPIC -DPIC -o .libs/my_error.lo my_error.c: In function `my_error': my_error.c:42: `__builtin_va_alist' undeclared (first use in this function) I got this same error from gcc that I built on a solaris sparc box, trying to compile many different programs. It turns out that the problem was having /usr/ucblib in my load path when I compiled gcc. Recompiling it without that in the path seemed to make the error go away. Todd - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 SELECT command
On Thu, 14 Jun 2001 13:50:43 -0300, Nasir Ali [EMAIL PROTECTED] wrote: Well as they say, ...if all else fails, RTFM.. :) Or pick up Paul Dubois's book on MySQL. Can somebody please point me to the good resourse of learning mysql's SELECT command on the Internet? Thanks, - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) Mike(mickalo)Blezien Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225) 686-2002 = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Getting MySQL-3.23.35/up working on my box.
On Thursday 14 June 2001 08:19, SDiZ Cheng wrote: Thanks all.. It's up and running now.. Seems that is a bug in Debian's CVS version gcc. I can't get older version of kernel compile on it too. I will move this to debian's mailing list =) Trying to run MySQL 3.23.35 is trouble (that is why we removed it from our downloads area). Running MySQL 3.23.35 linked against standard LinuxThreads is trouble raised to the power of 1 + max_connections/200. And if you compile it with a compiler straight from CVS, this is infinite trouble. I am surprised it ran at all... :-) -- MySQL Development Team For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Getting MySQL-3.23.35/up working on my box.
I have just checked bugs.debian.org . Debian Bug report logs - #81181 gcc: sig 11, reproducible and not machine-specific Somebody have file the same problem, with imapd. not mysql's bug =) -- Cheng Yuk Pong (SDiZ) 4096/1024 DH/DSS 0xA4C6FAD3 FE28 E6D4 AD21 5D4F F07B EEA6 3C88 5DBB A4C6 FAD3 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Bugs? Re: HAVING [cond...] problem
Still doesn't work, I've even tried: HAVING ( Avg_Xmit = 12345 ) AND ( Samples = 25 ) 19000 rows returned, none equalling 12345, but all have Samples = 25. It's almost as if this became an OR. Cliff Gerald Clark [EMAIL PROTECTED] writes: Have you tried: HAVING ( Avg_Xmit 28800 ) AND ( Samples = 10 ) ? Cliff Daniel wrote: I'm having some difficulting on 3.23.38, linux x86... When I write the following query the HAVING clause is only listening to the 'AND Samples = 10' and displas all Avg_Xmit regardless if it's less than or equal to 28800. If I remove the 'AND Samples = 10' I get the correct results, but of course samples are permitted if less than 10, which I do not want. Any ideas? SELECT INET_NTOA(NAS_Identifier), NAS_DS1, AVG(Ascend_Xmit_Rate) as Avg_Xmit, AVG(Ascend_Data_Rate) as Avg_Recv, AVG(Acct_Session_Time) / 60 as ACHT, COUNT(*) as Samples FROM tbl_data_call_detail WHERE Acct_Session_Time 0 GROUP BY NAS_Identifier, NAS_DS1 HAVING Avg_Xmit 28800 AND Samples = 10 ORDER BY Avg_Xmit DESC Regards, Cliff - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [EMAIL PROTECTED] -- Cliff Daniel Level 3 Communications The government deficit is the difference between the amount of money the government spends and the amount it has the nerve to collect. --Sam Ewing - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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-relationships
If I understand you correctly, you probably want to look into left joins. I.e. select a.field, b.field from table1 a left join table2 b on a.id=b.tbl1.id vs select a.field, b.field from table1a, table2 b where a.id=b.tbl1.id The first will show matching rows from table1 even when there have no matching rows in table2, whereas the second will show matching rows from table1 only when matches exist in table2 as well. Good luck... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] m] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, June 14, 2001 12:32 PM To: [EMAIL PROTECTED] Subject: mysql-relationships Hey all, This is actually more of a theory question than anything else. I have most of my databases built to 4th normal form. So that means I am have tons of foreign keys to primary keys and what-not. Almost every table is linked to another table. The only problem I can forsee is when you decide to delete a record that is being linked by another table. Many of my PHP scripts blow up when they dont see what they are suppose to see... So the linked ID (lets say 1) is still going to be in the users table but when you query it wont find the table it was being linked too!!! How do you counter act this? My system can get very complex..do I need to write a script to couteract every single possible error??? Indy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: apache/php/modperl incomp?
I believe that i've seen this on the list before. Read the php docs before compiling, don't use the builtin mysql support, specify --with-mysql=/path/to/mysqllibs HTH Greg wrote: I'm trying to have mod_perl and php running in the same apache server, accessing the same mysql database. At runtime, when the first request is issued from perl, I get the following error: dyld: /Local/Server/Apache/sbin/httpd multiple definitions of symbol __dig_vec /Local/Server/Apache/sbin/httpd definition of __dig_vec /Local/Library/Perl/darwin/auto/DBD/mysql/mysql.bundle definition of __dig_vec It occurs with both static and dso, but only from perl (php can access the DB with no error). What can I do? Greg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Daniel Bohling NewsFactor Network - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
now I have it compiled, ??
Hey gang, I got the configure script to run with no errors and got it installed in the /opt directory by using the following. ./configure --with-named-z-libs=no --without-debug --with-mysqld-user=mysql --prefix=/opt/mysql But after the make install ( and I saw no errors ) there is no /opt/mysql/var directory and I think there is suppsoed to be one. So when I start safe_mysqld I get this error, touch: cannot create /opt/mysql/var/rome-ga-2.err: No such file or directory chown: /opt/mysql/var/rome-ga-2.err: No such file or directory Starting mysqld daemon with databases from /opt/mysql/var ./safe_mysqld: /opt/mysql/var/rome-ga-2.err: cannot create Any ideas? Thanks __ Do You Yahoo!? Spot the hottest trends in music, movies, and more. http://buzz.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: Telnet to MySQL (Was port number)
I was indeed trying to test a remote connection to mysql server. I am actually trying to get JDBC working from a client that does not have MySQL installed, and was just trying to use telnet to see if the connection worked. I have discovered that I must install a JDBC driver of some kind on the server with MySQL, which I am working on now. I guess I have to grant permission to the client from the mysql server for this test. Gene. - Original Message - From: Neil Zanella [EMAIL PROTECTED] To: Dibo Chen [EMAIL PROTECTED] Cc: sanborn [EMAIL PROTECTED]; MySQL Mailing List [EMAIL PROTECTED] Sent: Wednesday, June 06, 2001 4:43 PM Subject: Re: Telnet to MySQL (Was port number) On Wed, 6 Jun 2001, Dibo Chen wrote: use 'mysql -h server_machine -u user_name -p ' to connect/query your MySQL server. You don't need telnet. My apologies for introducing some confusion here. You can use telnet to test whether mysqld accepts incoming connections from the host on which you are running telnet in case you do not have mysql already installed on the client computer. If however the mysql client is already installed on the client host you may just as well use it directly. If the telnet connection was successful you should see the mysql version and some other garbage. If the site is firewalled then telnet and mysql client should hang. Bye, Neil - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 SELECT command
On the internet specifically I'd say try http://www.mysql.com/manual.php , it's one of the better manuals I've come across (Free Software or Commercial). If you want an excellent book, get MySQL by Paul DuBois. Also 'The Practical SQL Handbook' is good, although not MySQL specific. Best of luck!! -Original Message- From: Nasir Ali [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 14, 2001 9:51 AM To: [EMAIL PROTECTED] Subject: Mysql SELECT command Can somebody please point me to the good resourse of learning mysql's SELECT command on the Internet? Thanks, - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Making SQL request from a Mac
I see you're mailing the ODBC lists as well, that may very well be your answer. Mind you I'm not familiar with Mac Programming, however, why not open a odbc connnection to your DB. You can do it with MS Access on windows easy enough, why not on a Mac? Matt Trollboy Wiseman www.shoggoth.net/trollboy/trollboy.jpg [EMAIL PROTECTED] I wish the world had one throat!! -Al Bundy - Please do not resell my e-mail address to anyone or send me unsolicited e-mail - - Original Message - From: Pascal MiQUET [EMAIL PROTECTED] To: Ansgar Becker [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, June 08, 2001 3:17 AM Subject: Re: Making SQL request from a Mac Thanks Ansgar for your answer. What I missed concerning my question, is that I need to be able to get informations from MySQL and integrate them into a Mac App Quark XPress, using a specific plugin for Photo Composition, If I really understood what I was as to do. I wonder how phpMyAdmin would let me make the link into this environnement. Regards Pascal Miquet - Original Message - From: Ansgar Becker [EMAIL PROTECTED] To: Pascal MiQUET [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, June 07, 2001 6:00 PM Subject: Re: Making SQL request from a Mac I'd like to get informations from my MySQL Server on LiNUX, and the query must be made from a Mac (Not an Os X)! Is there a good solution ? If it's not possible, How can I get access to a PC With windows ? If you run windows, have a look at MySQL-front 1.18: http://www.mysqlfront.de on a mac I would prefer the browser-based phpMyAdmin: www.phpwizard.net Ansgar - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: tuning user's variable understanding
On 14-Jun-01 brainheap wrote:
hi ppl!
I have two consequent queries
select @g1=user from user_space where connects10
and
select connect_time from connects where user=@g1
What if there are more than 1 user(s) where connects 10, or none ?
To prevent misunderstanding I say that I don't want to use joining as in
my case tis very slow operation.
Unless something is seriously wrong with the normalization, it looks like this
should be a very fast query:
SELECT a.usr, a.connects as connects, b.connect_time
FROM user_space as a, connects as b
WHERE connects 10 and a.user=b.user ...
I'm assuming user_space.user is a primary key, you have an index
on connects.user (, plus an index on user_space.connects would help).
My question is:
when I proceed these two queries using mysql_query() I get success
but when I get the result using mysql_store_result() and
mysql_fetch_row() I get the result for the first query.
Does that mean that I need to get both results from server?
If so - can I avoid fetching useless data and skip getting first query
result and get only the next one?
Anyhow, do the query, test the result discard:
$query=select @g1=user from user_space where connects10;
$rslt = mysql_query($query);
if ($rslt) {
$dontcare = mysql_numrows($rslt); // discard
$query=select connect_time from connects where user=@g1;
$rslt=mysql_query($query);
if ($rslt) {
while ($row=mysql_fetch_object($rslt)) {
... do foobarbaz ...
}
}
}
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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: now I have it compiled, ??
Complete tutorial on installing Mysql, PHP and Apache can be found on www.devshed.com Have fun. B. At 11:12 14-6-01 -0700, Mark Vann wrote: Hey gang, I got the configure script to run with no errors and got it installed in the /opt directory by using the following. ./configure --with-named-z-libs=no --without-debug --with-mysqld-user=mysql --prefix=/opt/mysql But after the make install ( and I saw no errors ) there is no /opt/mysql/var directory and I think there is suppsoed to be one. So when I start safe_mysqld I get this error, touch: cannot create /opt/mysql/var/rome-ga-2.err: No such file or directory chown: /opt/mysql/var/rome-ga-2.err: No such file or directory Starting mysqld daemon with databases from /opt/mysql/var ./safe_mysqld: /opt/mysql/var/rome-ga-2.err: cannot create Any ideas? Thanks __ Do You Yahoo!? Spot the hottest trends in music, movies, and more. http://buzz.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
won't build on hppa
Hello Does anybody know how to get MySQL build on HPPA architecture? bye, -christian- -- Real men don't take backups. They put their source on a public FTP-server and let the world mirror it. -- Linus Torvalds Package: mysql Version: 3.23.39-1 Hi, trying to build mysql on hppa. It dies in the isam directory: willy@paer:~/mysql/mysql-3.23.39/isam$ make /bin/sh ../libtool --mode=link gcc -O3 -DDBUG_OFF -O2 -g -rdynamic -o isamchk isamchk.o sort.o libnisam.a ../mysys/libmysys.a ../dbug/libdbug.a ../strings/libmystrings.a -lpthread -lz -lcrypt -lnsl -lm -lpthread gcc -O3 -DDBUG_OFF -O2 -g -rdynamic -o isamchk isamchk.o sort.o libnisam.a ../mysys/libmysys.a ../dbug/libdbug.a ../strings/libmystrings.a -lpthread -lz -lcrypt -lnsl -lm -lpthread ../mysys/libmysys.a(my_tempnam.o): In function `my_tempnam': /home/willy/mysql/mysql-3.23.39/mysys/my_tempnam.c:100: the use of `tempnam' is dangerous, better use `mkstemp' ../mysys/libmysys.a(raid.o): In function `my_raid_create': /home/willy/mysql/mysql-3.23.39/mysys/raid.cc:130: undefined reference to `operator new(unsigned)' /usr/bin/ld: raid.o(.text+0xb0): cannot find stub entry 0014__Znwj+0 /usr/bin/ld: raid.o(.text+0xb0): cannot handle R_PARISC_PCREL17F for operator new(unsigned) /home/willy/mysql/mysql-3.23.39/mysys/raid.cc:134: undefined reference to `operator delete(void*)' /usr/bin/ld: raid.o(.text+0x128): cannot find stub entry 0014__ZdlPv+0 /usr/bin/ld: raid.o(.text+0x128): cannot handle R_PARISC_PCREL17F for operator delete(void*) ../mysys/libmysys.a(raid.o): In function `my_raid_open': /home/willy/mysql/mysql-3.23.39/mysys/raid.cc:152: undefined reference to `operator new(unsigned)' /usr/bin/ld: raid.o(.text+0x19c): cannot find stub entry 0014__Znwj+0 /usr/bin/ld: raid.o(.text+0x19c): cannot handle R_PARISC_PCREL17F for operator new(unsigned) /home/willy/mysql/mysql-3.23.39/mysys/raid.cc:156: undefined reference to `operator delete(void*)' /usr/bin/ld: raid.o(.text+0x210): cannot find stub entry 0014__ZdlPv+0 /usr/bin/ld: raid.o(.text+0x210): cannot handle R_PARISC_PCREL17F for operator delete(void*) ../mysys/libmysys.a(raid.o): In function `my_raid_close': /home/willy/mysql/mysql-3.23.39/mysys/raid.cc:288: undefined reference to `operator delete(void*)' /usr/bin/ld: raid.o(.text+0x70c): cannot find stub entry 0014__ZdlPv+0 /usr/bin/ld: raid.o(.text+0x70c): cannot handle R_PARISC_PCREL17F for operator delete(void*) collect2: ld returned 1 exit status make: *** [isamchk] Error 1 these symbols are all in libstdc++, so this can be cured in one of two ways. Either use `g++' instead of gcc to do the link step, or explicitly add -lstdc++ to the command line: willy@paer:~/mysql/mysql-3.23.39/isam$ g++ -O3 -DDBUG_OFF -O2 -g -rdynamic -o isamchk isamchk.o sort.o libnisam.a ../mysys/libmysys.a ../dbug/libdbug.a ../strings/libmystrings.a -lpthread -lz -lcrypt -lnsl -lm -lpthread ../mysys/libmysys.a(my_tempnam.o): In function `my_tempnam': /home/willy/mysql/mysql-3.23.39/mysys/my_tempnam.c:100: the use of `tempnam' is dangerous, better use `mkstemp' willy@paer:~/mysql/mysql-3.23.39/isam$ gcc -O3 -DDBUG_OFF -O2 -g -rdynamic -o isamchk isamchk.o sort.o libnisam.a ../mysys/libmysys.a ../dbug/libdbug.a ../strings/libmystrings.a -lpthread -lz -lcrypt -lnsl -lm -lpthread -lstdc++ ../mysys/libmysys.a(my_tempnam.o): In function `my_tempnam': /home/willy/mysql/mysql-3.23.39/mysys/my_tempnam.c:100: the use of `tempnam' is dangerous, better use `mkstemp' how would you prefer to fix this? this is using g++ 3.0, btw, since this is the only compiler available for hppa. you can check any changes you make on hppa by logging into paer.debian.org. -- Revolutions do not require corporate support. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 using mysql_fetch_row in C API
On 14-Jun-01 Kenneth Johansen wrote: hi all, ive got a small problem (again). i have a table with an entry foo which is an int(3). my problem is that whenever i collect the values in my c program. they are returned as characters with mysql_fetch_row. (which is ok) but i cant seem to convert them into int, using something like temp = (int) row[0]; this might not (strictly) be a mysql question. but IMHO i dont think a C forum is the right place either. No it's not; yes, it would. man atoi strtod sscanf Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Error 127?
Hello and thanks, can you tell me where can I get information about the errors presented by MySQL? I have that kind of trouble each time the server (the machine) crash and it's no solved after myisamchk with any option. thanks again, Cesar A. Cabrera E. -- 'http://www.utp.edu.co/Lince/' On Thu, 14 Jun 2001, Eric Persson wrote: It sounds like your table have been corrupt, this can result in data loss. Try using isamchk to fix the problem. //Eric Cesar Cabrera wrote: Hello, what means an error 127 from table handler and an error 1030? where can I get documentation from that issues? Thanks for any help you can give me, Cesar A. Cabrera E. -- 'http://www.utp.edu.co/Lince/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: now I have it compiled, ??
You forgot the mysql_install_db --user=mysql Mark Vann wrote: Hey gang, I got the configure script to run with no errors and got it installed in the /opt directory by using the following. ../configure --with-named-z-libs=no --without-debug --with-mysqld-user=mysql --prefix=/opt/mysql But after the make install ( and I saw no errors ) there is no /opt/mysql/var directory and I think there is suppsoed to be one. So when I start safe_mysqld I get this error, touch: cannot create /opt/mysql/var/rome-ga-2.err: No such file or directory chown: /opt/mysql/var/rome-ga-2.err: No such file or directory Starting mysqld daemon with databases from /opt/mysql/var ../safe_mysqld: /opt/mysql/var/rome-ga-2.err: cannot create Any ideas? Thanks __ Do You Yahoo!? Spot the hottest trends in music, movies, and more. http://buzz.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 -- Gerald L. Clark [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
Borland C++ Builder (reading data).
Caveat: I'm not a seasoned Borland C++ builder programmer so this may very
well be just plain stupidity on my part (I'm not even a really good C
programmer either !).
However, givem some code that looks similar to this:
int state;
MYSQL_RES *result;
MYSQL_ROW row;
char sql[250];
sprintf(sql,%s%s%s%s,SELECT positionID
FROM reflectivity.positions
where position_row = ,position_row,
position_column = ,position_column);
state = mysql_query(connection,sql);
if (state != 0)
{
printf(mysql_error(connection));
return 0;
}
result = mysql_store_result(connection);
// while ((row = mysql_fetch_row(result)) != NULL)
row = mysql_fetch_row(result);
if (mysql_num_rows(result) 0)
{
// free some memory
mysql_free_result(result);
return (int)atoi(row[0]);
}
else
{
// free some memory
mysql_free_result(result);
return 0;
}
in C using gcc on linux it works. I return a valid int which corresponds
to the database entry, no warnings, no errors that I can see.
In Borland C++ Builder, although I connect to the database (ie, I can
WRITE fine to the databsae, and, there are no complaints by my connection
to the database), and if (mysql_num_rows(result) 0) returns true
(meaing it sees the row(s)), I get:
raiased EXCEPTION CLASS EAccess Violation with message Access Violation at
address 3256EEFF in module cc3250mt.dll read of address FEEFEE. Process
stopped.
row[0] however does NOT match against NULL or \0 (though if I print it out
it shows )
When I attempt to reference or work with row[0]. This has been the case
whenever I try to read an element in row under Borland (various other
functions as well) whereas the exact code (in all instances) works fine
when compiled with gcc. Again though, any WRITES to the database work
great under Borland (so I don't think it's a connection issue).
Am I just totally missing some boat here?
Thanks for any help!
Seth
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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 Crashing
Is something run from cron deleting the socket? The second error is just because your PHP script did not check for the first error. David Addison wrote: I use MySQL with PHP on a BSD server. For the last week or so I've been getting errors. My problem is that I'm not sure how to read the error code: Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) in /usr/home/thebookc/usr/local/etc/httpd/conf/INIFile on line 22 Warning: 0 is not a MySQL link index in /usr/home/thebookc/usr/local/etc/httpd/conf/INIFile on line 936 SYSTEM ERROR: Please contact database administrator. Error: :: Location: selectLgBanner *** If I use the kill command and then shutdown and restart the system comes back up. Then it crashes again... Can anyone tell me how to read this error message. What's going on? Anywhere that I can read to find out more about how to diagnose errors? Are there any good MySQL news groups Thanks, David Addison Transit ID, LLC. -- Gerald L. Clark [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: GRANT ANNOYANCE REVISITED
Thank you all for your original suggestions, but I'm still having problems. I copied this verbatim from the MySQL docs and tried it on two seperate servers: mysql GRANT ALL PRIVILEGES ON *.* TO monty@% -IDENTIFIED BY 'some_pass' WITH GRANT OPTION; ERROR 1047: Unknown command Bonjour, Are root privileges really established? I had that error message once a day. If root password is not set, in extenso there is no root, you cannot use GRANT statement. Have a look in mysql.user table to see check for root password. jean-michel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: now I have it compiled, ??
Well, I dont know why, when I do that , it tries to look in /usr/local/mysql, so i just put a symbolic link there and everything seems to be OK. Thanks all --- Gerald Clark [EMAIL PROTECTED] wrote: You forgot the mysql_install_db --user=mysql Mark Vann wrote: Hey gang, I got the configure script to run with no errors and got it installed in the /opt directory by using the following. ../configure --with-named-z-libs=no --without-debug --with-mysqld-user=mysql --prefix=/opt/mysql But after the make install ( and I saw no errors ) there is no /opt/mysql/var directory and I think there is suppsoed to be one. So when I start safe_mysqld I get this error, touch: cannot create /opt/mysql/var/rome-ga-2.err: No such file or directory chown: /opt/mysql/var/rome-ga-2.err: No such file or directory Starting mysqld daemon with databases from /opt/mysql/var ../safe_mysqld: /opt/mysql/var/rome-ga-2.err: cannot create Any ideas? Thanks __ Do You Yahoo!? Spot the hottest trends in music, movies, and more. http://buzz.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 -- Gerald L. Clark [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 = Mark Vann CCNP, CCNA, CCDA, MCSE, Network+ Network Engineer __ Do You Yahoo!? Spot the hottest trends in music, movies, and more. http://buzz.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: problem using mysql_fetch_row in C API
From: Don Read [EMAIL PROTECTED] On 14-Jun-01 Kenneth Johansen wrote: hi all, ive got a small problem (again). i have a table with an entry foo which is an int(3). my problem is that whenever i collect the values in my c program. they are returned as characters with mysql_fetch_row. (which is ok) but i cant seem to convert them into int, using something like temp = (int) row[0]; this might not (strictly) be a mysql question. but IMHO i dont think a C forum is the right place either. No it's not; yes, it would. I disagree. This is the correct forum, as many MySQL users have this problem. To elaborate; MySQL returns *all* it's results as a text string, or more specifically an array of text strings. This is actually a database standard IIRC. Just put them through either atoi (for integers), atol (for longs) or atoll (for long longs). It depends on the compiler and libraries, but these will generally work. So what you need is : temp = atoi(row[0]); Which should work fine. Russ. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 exporting to spreadsheet
On 14-Jun-01 Terminal Velocity wrote: I would like to use MySQL to manage my company data, but my clients want all their information sent to them in an Excel spreadsheet. Presently I use Access, and export a SELECT statement into Excel, and then make a couple changes to the Excel file (I just high-lite the updated data). I want to change the database to MySQL on a Linux box, but the biggest issue is being able to export into Excel. I know I can export to a tab-delimited text file, but I would prefer to do it all in one step. Any ideas? Do they want the information sent to them, or accessible via the internet. In either case a CSV file is normally sufficient. If you want access via the internet it's pretty simply to produce a page that displays an excel file (actually it's CSV) in Excel within their browser which looks quite impressive. Email me for details and I'll post the method up here. It invloves using PHP and Apache. Alternatively if you want to dump to a CSV file any language will do. Personally I'd use C or PHP. Highlighting and graphing data, you're on your own, although you *may* be able to incorporate a formula to do this in the CSV IIRC. Russ. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Error 22 from table handler
Hello, can you tell me about error 22 from table handler or where can I get some information about it, it denies me grant table level privileges for my users. Thanks, Cesar A. Cabrera E. - 'http://www.utp.edu.co/Lince' P.D.: That error results from GRANT statements and insert into tables_priv statements. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 exporting to spreadsheet
Perl's Spreadsheet::ParseExcel and Spreadsheet::WriteExcel are great for this purpose. Find them on a CPAN site near you. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] m] On Behalf Of Don Read Sent: Thursday, June 14, 2001 3:43 PM To: Terminal Velocity Cc: [EMAIL PROTECTED] Subject: RE: help exporting to spreadsheet On 14-Jun-01 Terminal Velocity wrote: I would like to use MySQL to manage my company data, but my clients want all their information sent to them in an Excel spreadsheet. Presently I use Access, and export a SELECT statement into Excel, and then make a couple changes to the Excel file (I just high-lite the updated data). I want to change the database to MySQL on a Linux box, but the biggest issue is being able to export into Excel. I know I can export to a tab-delimited text file, but I would prefer to do it all in one step. Any ideas? I've used *.csv (comma seperated values) for a web-site; IRC, Excel is the default application for these. This may not be true anymore, haven't messed with Windows in ages. I've heard there is a Perl package that speaks *.xls Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 text fields
From: ryc [EMAIL PROTECTED]
I am aware that currently innobase tables can not have abritararly large
text/varchar fields and support for this will be released sometime in the
month of June. The application I am working with requires text fields
(usually less than 64k), and I desperatly need row level locking. Either I
continue using Mysql, and use Innodb tables.. or I have to switch to
Postgresql.
I need to do something right away about this performance problem, I can
not
wait until Innodb tables are released with the unlimited row length. I
tried
to find out what the max row length for a Innodb table row, but did not
find
it in the documentation. If it isnt too much smaller than 64k I could
switch
now, and not have to worry about using postgresql. Does anyone know what
the
limit is? Any pointers would be apreciated.
Hi,
We used to have a similar problem with MS-SQL Server (a limit that's now
been removed I believe).
If you are willing to do some extra development you can get around this by
splitting the field into multiple chunks of (for example), 8k, and inserting
them with a field indicating re-assemble order.
Benefits : Better use of space with fixed field size. Can store an object of
abitrary size (i.e. from 1k to gigabytes).
Downside : Extra development. Slower retrival.
So your code would look something like :
mysql_query(db, select chunk_data from chunks where id = 5453 order by
reassemble_order);
results = mysql_get_results(db);
number = mysql_num_rows(results);
for (a=0 to number)
{
tail = mysql_result(results[a]);
bigvar = bigvar+ tail;
}
Splitting it up in the first place is a similar procedure.
Russ.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Error 22 from table handler
Hello, can you tell me about error 22 from table handler or where can I get some information about it, it denies me grant table level privileges for my users. Thanks, Cesar A. Cabrera E. - 'http://www.utp.edu.co/Lince' P.D.: That error results from GRANT statements and insert into tables_priv statements. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
include files
I installed MYSQL in Redhat Linux 6.2 and where are the include files? If your include files are not in /usr/include/mysql or /usr/local/include/mysql, I cannot find the include files and I installed from RPM MySQL-3.23.38-1.i386.rpm MySQL-client-3.23.38-1.i386.rpm Thanks MIke - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
auto_increment update
Hi there can i somehow easily recreate the auto_increment col if is was not correctly set? i just recognized that most rows contain 1 cause the primary key was set on the auto_increment col + another one. so mysql only creates a entry 1 if the other field was equal to another row. thanks regards Sven Huster - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Where is mysqladmin
Hi, I have mySQL installed under Conectiva Linux 4.2 and I'm not able to find mysqladmin ... Is there something to start to use mySQL? TIA, Juan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: threads mysql
From: Dvoøáèek Michal [EMAIL PROTECTED] Hi there, little problem. I have program (like phorums) and there is command mark all posts as readed. On one board is about 4000 posts, and if is new user and want mark all posts as readed - it's problem (big). All is written in ANSI C (using C API functions). And here is main problem: when i execute marking thread (most of mysql code run as separately threads) and someone wants list this board (list thread) nothing happens. After about 15 seconds program show results. And if you type show command for two times program crashed. I'm not using locking tables. And question: is possible that SELECT will wait on previously or currently running INSERT and how is it multithread programs, where some threads are using same table (to avoid error like Out of synchronization, Query cannot be executed now, ) Thanx Hi. Yes, MySQL will wait for a large insert to finish before running a select. At least that's my experience. You can get around this by either : a) Adding granularity into your insert thread. Only insert 10 at a time for example. b) Use a table type that has row or page level locking. Personally I'd use the later, but if you cannot do so for any reason, you'll have to do the former. Russ. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 help for x86 Solaris 8
On 14-Jun-01, Daniel Vignes said something totally profound about Install help for x86 Solaris 8 that made me ponder... DV Hi, DV DV I hope someone out there has an answer to this problem I'm having. DV I'm trying to get mysql installed on a x86 Solaris 8 box, the DV version I'm trying to install is 3.23.39. The configure script goes DV through fine, when then try to make it dies out giving me this I had similar errors when trying to compile --with-assembler. What are your ./configure options? Try these instructions and work from there: http://users.talstar.com/forager/MySQL-HOWTO.html -- Alan W. Rateliff, II: YourVillage.com Assistant Systems Administrator : 2700 Apalachee Pkwy [EMAIL PROTECTED] : Tallahassee, FL 32301 (850) 942-7021--- [EMAIL PROTECTED] http://support.yourvillage.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: auto_increment update
At 1:36 AM +0200 6/15/01, Sven Huster wrote: Hi there can i somehow easily recreate the auto_increment col if is was not correctly set? i just recognized that most rows contain 1 cause the primary key was set on the auto_increment col + another one. so mysql only creates a entry 1 if the other field was equal to another row. Well, that's what's supposed to happen if you have a primary key or unique key on multiple columns where the last column is an AUTO_INCREMENT value. If you want your AUTO_INCREMENT column to have unique values for each row, then you could drop that index and set up a PRIMARY KEY on just the AUTO_INCREMENT column. Actually, I'm not sure I understand what you want to do, so I'm just guessing. If that doesn't answer your question, please clarify. thanks regards Sven Huster -- Paul DuBois, [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: include files
At 3:33 PM -0700 6/14/01, Mike Jimenez wrote: I installed MYSQL in Redhat Linux 6.2 and where are the include files? If your include files are not in /usr/include/mysql or /usr/local/include/mysql, I cannot find the include files and I installed from RPM MySQL-3.23.38-1.i386.rpm MySQL-client-3.23.38-1.i386.rpm The first of those includes the server, and the second includes the clients. The include files and libraries are in the -devel RPM, which you didn't install. Thanks MIke -- Paul DuBois, [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
MySQL server has gone away
Description:
In testing a script that I want to put in a cron, the mysqld keeps crashing eachtime I
run the script to test it. I've tried substituting in raw numbers for the variables
in the script, but to no avail. In attempting to troubleshoot, I logged onto the
monitor and could duplicate the problem with simple entries.
I can provide any information required. :)
Offending Lines in Script:
$setdate = $pingsdb-query(insert into sla(date) values('$date'));
$input = $pingsdb-query(update sla set avail1='$availability{1}' and
packet1='$packetloss{1}' and resp1='$response{1}' where date='$date');
Script Output:
DBD::mysql::st execute failed: MySQL server has gone away at
/usr/local/lib/perl5/site_perl/5.005/i386-freebsd/Mysql.pm line 172.
MYSQL Logs:
/usr/libexec/ld-elf.so.1:
/usr/local/bin/new_mysql/mysql-3.23.38-unknown-freebsdelf4.3-i386/bin/mysqld:
Undefined symbol strtoll
010614 20:32:21 mysqld restarted
010614 20:32:21 Warning: setrlimit returned ok, but didn't change limits. Max open
files is 1640
010614 20:32:21 Warning: Changed limits: max_connections: 500 table_cache: 565
/usr/local/bin/new_mysql/mysql-3.23.38-unknown-freebsdelf4.3-i386/bin/mysqld: ready
for connections
How-To-Repeat:
Offending Lines in Script:
$setdate = $pingsdb-query(insert into sla(date) values('$date'));
$input = $pingsdb-query(update sla set avail1='$availability{1}' and
packet1='$packetloss{1}' and resp1='$response{1}');
MYSQL Logs:
/usr/libexec/ld-elf.so.1:
/usr/local/bin/new_mysql/mysql-3.23.38-unknown-freebsdelf4.3-i386/bin/mysqld:
Undefined symbol strt
oll
010614 20:32:21 mysqld restarted
010614 20:32:21 Warning: setrlimit returned ok, but didn't change limits. Max open
files is 1640
010614 20:32:21 Warning: Changed limits: max_connections: 500 table_cache: 565
/usr/local/bin/new_mysql/mysql-3.23.38-unknown-freebsdelf4.3-i386/bin/mysqld: ready
for connections
mysql describe sla;
+-++--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+-++--+-+-+---+
| date| date | YES | | NULL| |
| avail0 | float(6,2) | YES | | NULL| |
| packet0 | float(6,2) | YES | | NULL| |
| resp0 | float(6,2) | YES | | NULL| |
| avail1 | float(6,2) | YES | | NULL| |
| packet1 | float(6,2) | YES | | NULL| |
| resp1 | float(6,2) | YES | | NULL| |
| avail2 | float(6,2) | YES | | NULL| |
| packet2 | float(6,2) | YES | | NULL| |
| resp2 | float(6,2) | YES | | NULL| |
| avail3 | float(6,2) | YES | | NULL| |
| packet3 | float(6,2) | YES | | NULL| |
| resp3 | float(6,2) | YES | | NULL| |
| avail4 | float(6,2) | YES | | NULL| |
| packet4 | float(6,2) | YES | | NULL| |
| resp4 | float(6,2) | YES | | NULL| |
+-++--+-+-+---+
16 rows in set (0.00 sec)
mysql insert into sla(avail0,packet0,resp0) values('99.9965','100','38.090643');
Query OK, 1 row affected (0.01 sec)
mysql update sla set avail1='99.9965' and packet1='100' and resp1='38.090643';
ERROR 2013: Lost connection to MySQL server during query
Fix:
Submitter-Id: submitter ID
Originator:James Mackenzie
Organization:
MySQL support: none
Synopsis: MySQLd crashes when perl script attempts to update table
Severity: critical
Priority: medium
Category: mysql
Class: sw-bug
Release: mysql-3.22.32 (Source distribution)
Environment:
I'm using the standard build of mysql and perl.
System: FreeBSD tactoo.dco.psi.ca 4.2-RELEASE FreeBSD 4.2-RELEASE #0: Wed Jan 24
16:14:54 EST 2001 [EMAIL PROTECTED]:/usr/src/sys/compile/TACTOO i386
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
GCC: Using builtin specs.
gcc version 2.95.2 19991024 (release)
Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS=''
Configure command: ./configure --with-unix-socket-path=/var/tmp/mysql.sock
--with-low-memory --with-mit-threads=yes
Perl: This is perl, version 5.005_03 built for i386-freebsd
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Relationships???
If you are really after referential integrity then perhaps you should consider another database or you could always modify the code. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 15, 2001 8:32 Subject: Relationships??? Hello all, Without explicitly creating foreign keys, what is the most common method to create a truly relational database that enforces referential integrity? Any responses to this question are greatly appreciated! Sincerely, N. Silverwise - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Relationships???
Hello all, Without explicitly creating foreign keys, what is the most common method to create a truly relational database that enforces referential integrity? Any responses to this question are greatly appreciated! Sincerely, N. Silverwise - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: error checking in MySQL
At 12:04 PM +1000 6/15/01, M Felipe wrote: I need help on testing the database for errors. Basically im writing a perl script to operate my database. When i open the database, i need it to return an error code if successful. steps such as: Try running: perldoc DBI and reading the information on checking for errors. You want to know about the PrintError and RaiseError attributes. open database check for error (did database open?) if error print error message else print successful. close database use DBI $dbh = DBI-connect(DBI:mysql:dbname,user,password); $dbh will be undef if an error occurred (if RaiseError isn't enabled). $sth = $dbh-prepare(SELECT username from MyTable); $sth will be undef if an error occurred (again, if RaiseError isn't enabled). (error checking here) $sth-execute; $dbh-disconnect; Basically on the error checking part, if successful $errorcode = 0 or if there is error $errorCode = 1; Thank all, Marbeen Felipe -- Paul DuBois, [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: What's wrong here?
It would help if we knew what the error or problem was?
- Original Message -
From: Vladimir Kravtsov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, June 15, 2001 13:13
Subject: What's wrong here?
?php
require('common.php');
function DisplayPoll() {
connectdb();
mysql_select_db(pollbooth);
$sql = select choice from choices;
$query = mysql_query($sql);
$num_of_voting_choices = mysql_num_rows($query);
$sql = select choice from votes;
$query = mysql_query($sql);
$number_of_votes = mysql_fetch_array($query);
for ($i = 0; $i $num_of_choices; ++$i) {
$sql = select id from votes where choice='$i';
$query = mysql_query($sql);
$num_of_rows_for_choice = mysql_num_rows($query);
$choice_percentage = $number_of_rows_for_choice / $number_of_votes;
$number_of_pixels_to_print = $choice percentage / 5;
for ($x = 0; $x $number_of_pixels_to_print; ++$x) {
echo(img src=.$color_choice.);
echo( .$choice_percentage.\%);
}
}
}
?
Please help :)
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
error checking in MySQL
I need help on testing the database for errors. Basically im writing a perl script to operate my database. When i open the database, i need it to return an error code if successful. steps such as: open database check for error (did database open?) if error print error message else print successful. close database use DBI $dbh = DBI-connect(DBI:mysql:dbname,user,password); $sth = $dbh-prepare(SELECT username from MyTable); (error checking here) $sth-execute; $dbh-disconnect; Basically on the error checking part, if successful $errorcode = 0 or if there is error $errorCode = 1; Thank all, Marbeen Felipe - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fork, Or SetEnv Problem: Retain a MySQL Record # in a Shell
Greetings: Working ona shell based application that does an insert when a shell is started, and, needs to update that record on exit. You can't set an environment value back to the parent process, so would a fork() make the most sense? This currently works in a bash shell .profile implementation. MYSQL_REC_NO=`date '+%Y%m%d_%H%M%S'` I want to do this in a c application, instead. setenv(MYSQL_REC_NO,THE_DATE, 1); only works within the program and MYSQL_REC_NO dies on return from main. Anyone doing something similar? Regards, Van -- = Linux rocks!!! http://www.dedserius.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
What's wrong here?
?php
require('common.php');
function DisplayPoll() {
connectdb();
mysql_select_db(pollbooth);
$sql = select choice from choices;
$query = mysql_query($sql);
$num_of_voting_choices = mysql_num_rows($query);
$sql = select choice from votes;
$query = mysql_query($sql);
$number_of_votes = mysql_fetch_array($query);
for ($i = 0; $i $num_of_choices; ++$i) {
$sql = select id from votes where choice='$i';
$query = mysql_query($sql);
$num_of_rows_for_choice = mysql_num_rows($query);
$choice_percentage = $number_of_rows_for_choice / $number_of_votes;
$number_of_pixels_to_print = $choice percentage / 5;
for ($x = 0; $x $number_of_pixels_to_print; ++$x) {
echo(img src=.$color_choice.);
echo( .$choice_percentage.\%);
}
}
}
?
Please help :)
Re: indexing = NP complete??
On Thu, Jun 14, 2001 at 12:43:41PM -0400, Robin Senior wrote: On Thu, 14 Jun 2001, Jeremy Zawodny wrote: I have a few comments and questions: (1) Is this a unique index? If not, consider doing a partial index on the column. Index the first 32 characters or so. I'll save a lot of disk I/O, memory, and CPU time but still yeild pretty good results (depending on your data, of course). No, it isn't a unique index. Most of the entries are 32 chars, but I used a varchar(255) to be safe, as it only occupies the number of bytes required to record the string, plus 1 byte to record the length. Ah, okay. Then my suggestion won't help nearly as much as I thought. There are 77million records, and I can't guarantee that they are all 32. Will the index know to only index the required number of chars, or will it do 255? What if I had used a TEXT datatype? It'll do the Right Thing. :-) (2) What are your key_buffer and record_buffer set to? I believe that when MySQL is doing serious scanning (as needed in building an index), a larger record_buffer will help. Unfortunately, my key_buffer is only adjusted to 64M, and the record_buffer is set at a piddling 131072... I only got into configuring mysql after I began the indexing. The other box (same specs) that I'm running is set with: set-variable=key_buffer=128M set-variable=table_cache=512 set-variable=sort_buffer=8M set-variable=record_buffer=2M I'm trying to index on that machine at the same time, by indexing as I insert. I'm guessing 2M is still far too small? Can you recommend a better config? Is this machine basically dedicated to MySQL? If so, I'd try bumping up the record_buffer to 16 or 32MB and see what that does. I've got it set at 32MB on a server with 1GB of RAM. (3) Try running `vmstat 5' on the box for a bit. Is the CPU pegged? Is it I/O bound? Is it swapping at all? Forgot to mention I'm running Win2K, don't have vmstat, sorry. Perfmon is shite, too. Heh, okay. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 0 days, processed 2,801,545 queries (75/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
Re: What's wrong here?
Well, that isn't much to go on. I suggest you put a few print statements to
find out what's happening and also try the sql statement in the mysql prompt
to see if the sql statement does what it is suppose to. Remember, if you're
printing this in a table, error messages and results may not always be
displayed on the web page. You may have to view source.
- Original Message -
From: Vladimir Kravtsov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, June 15, 2001 14:08
Subject: RE: What's wrong here?
Sorry. It doesn't do anything.
Oh and btw, I made it so it DOES call on the function.
It would help if we knew what the error or problem was?
- Original Message -
From: Vladimir Kravtsov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, June 15, 2001 13:13
Subject: What's wrong here?
?php
require('common.php');
function DisplayPoll() {
connectdb();
mysql_select_db(pollbooth);
$sql = select choice from choices;
$query = mysql_query($sql);
$num_of_voting_choices = mysql_num_rows($query);
$sql = select choice from votes;
$query = mysql_query($sql);
$number_of_votes = mysql_fetch_array($query);
for ($i = 0; $i $num_of_choices; ++$i) {
$sql = select id from votes where choice='$i';
$query = mysql_query($sql);
$num_of_rows_for_choice = mysql_num_rows($query);
$choice_percentage = $number_of_rows_for_choice / $number_of_votes;
$number_of_pixels_to_print = $choice percentage / 5;
for ($x = 0; $x $number_of_pixels_to_print; ++$x) {
echo(img src=.$color_choice.);
echo( .$choice_percentage.\%);
}
}
}
?
Please help :)
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 3.23.39 released
Changes in release 3.23.39 -- * Fixed problem with shutdown when `INSERT DELAYED' was waiting for a `LOCK TABLE'. * Running `myisamchk --fast --force' will no longer repair tables that only had the open count wrong. -- THANK YOU! You don't know what it was for the first item to require a forced shutdown that made myisamchk take a huge amount of time. Although we have not had the need for a `myisamchk --fast --force' in a while, I tell you if you had a big fulltext index, you would avoid it like the plague. Now I have a question: Does this also apply to automatic repair inside mysqld? I'd finally use the feature if its true... Sincerely, Steven Roussey Network54.com http://network54.com/?pp=e - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
