Re: innodb_flush_log_at_trx_commit
On Mon, Jun 03, 2002 at 07:07:29AM +0100, ritu singla wrote: Hello, in InnoDB tables in MySQL, if innodb_flush_log_at_trx_commit is set to 1, then on COMMIT, the buffer log is flushed to disk log... Right. or the changes are reflected in the disk copy of the database??? i mean what is flushed, the buffer-pool that contains data and indexes or the log-buffer?? Log buffer. Once the transaction is in the on-disk log, it's durable. InnoDB can choose to update the actual tables later. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.51: up 4 days, processed 97,368,631 queries (264/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Command line interface
Hi Very new to MySQL and just wondering if there is an alternative interface to the command line. The beginners tutorial I am working through from WWW.Mysql.com seems to do all tasks from the command line. This seems very cumbersome in modern times. I understand there is a graphical interface in development. If so is it an improvement to the command line. How do most users of MySQL interact with the program. I would imagine entering or editing large amounts of data at the command line would be quite a task. Thanks David Ehmer Email: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql not supporting php.
mysql support is not available to php on this server This is the error I receive. MySQL is working fine, but I need to know how get php working with sql. Also, does anyone know the command to list all the db's? thanks. Dave - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Command line interface
I use exclusevely command line interface, and i believe most of the programmers prefer command line interface over GUI. As to large queries... just save them in yor files or use 'edit' command. On Mon, 3 Jun 2002, Ehmer David wrote: Hi Very new to MySQL and just wondering if there is an alternative interface to the command line. The beginners tutorial I am working through from WWW.Mysql.com seems to do all tasks from the command line. This seems very cumbersome in modern times. I understand there is a graphical interface in development. If so is it an improvement to the command line. How do most users of MySQL interact with the program. I would imagine entering or editing large amounts of data at the command line would be quite a task. Thanks David Ehmer Email: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
subselects in mysql 4.1 and other questions
Hi, 1. I am reading 'internals' list and I see some words about subselect in 'bk commit into 4.1 tree' messages... Seems like we can expect subselect in 4.1 branch !?? :) 2. When 4.0.2 beta will be released? 3. Seems like gcc 3.0 (or 3.1?) becomes an official recommended compliler for mysql source (at least for linux)? Thanks, sorry for my English, Alexander - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
command line interface
Hi Very new to MySQL and just wondering if there is an alternative interface to the command line. The beginners tutorial I am working through from WWW.Mysql.com seems to do all tasks from the command line. This seems very cumbersome in modern times. I understand there is a graphical interface in development. If so is it an improvement to the command line. How do most users of MySQL interact with the program. I would imagine entering or editing large amounts of data at the command line would be quite a task. Thanks David Ehmer Email: [EMAIL PROTECTED] [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql not supporting php.
David Grant wrote: This is the error I receive. MySQL is working fine, but I need to know how get php working with sql. This means your PHP was not compiled with MySQL support. Recompile PHP. Also, does anyone know the command to list all the db's? thanks. show databases; -- H | Life is the art of drawing without an eraser. - John Gardner + Ashley M. Kirchner mailto:[EMAIL PROTECTED] . 303.442.6410 x130 Director of Internet Operations / SysAdmin. 800.441.3873 x130 Photo Craft Laboratories, Inc.. 3550 Arapahoe Ave, #6 http://www.pcraft.com . . .. Boulder, CO 80303, U.S.A. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 not supporting php.
The follow lines will -list DBs -allow to select one -list tables under the selected DB mysql show databases; mysql use databasenamehere mysql show tables; hope this helped! -Original Message- From: David Grant [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 12:21 PM To: My SQL Mailing List Subject: mysql not supporting php. mysql support is not available to php on this server This is the error I receive. MySQL is working fine, but I need to know how get php working with sql. Also, does anyone know the command to list all the db's? thanks. Dave - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem with crystal reports
I am using mysql 3.23.49-Max on Windows and I have configured InnoDB for transactions My front-end is created in Visual Basic connecting using MyODBC 3.51.02 I can be able to access the data using visual basic perfectly and it is supporting transactions okey. I am creating the reports in Crystal Reports 8.0 connecting using MyODBC When I create a report connecting to a single table the data can be previewed fine But when I create a report that has to relate two tables it gives me an error while I try to preview the report. The error I am getting is as follws. ODBC error: [MySQL][ODBC 3.51 Driver][mysqld-3.23.49-max]You have an error in your SQL syntax near 'INNER JOIN 'rctdt' rctdt1 ON receipt1.'receiptno'=rctdt1.'rctdtno'} ORDER BY r' at line 1 This error comes with just an okey. When I click OK I get another message Error detected by database DLL I was earlier able to create the reports using mysql-3.23.49 with MyODBC 2.50 But I need the system to support transactions that is why I moved up to MySql 3.23.49-max with MyODBC 3.51.02 Any help will be highly appreciated since this system is crutial for my organisation. Kind regards Harrison Njamba Somak Travel Limited P.O. Box 48495 Tel 535509 / 0733-923214 Nairobi Kenya - This email and any files transmitted with it are confidential and intended solely for the use of the addressee. If you have received this email in error you may not disclose, copy, distribute or act upon its contents without the authors prior written consent. Please can you notify the system manager at [EMAIL PROTECTED] immediately and delete this email. - Any views or opinions expressed are those of the author and do not necessarily represent those of Somak Travel Limited, Kenya. - This footnote also confirms that this email message has been swept for the presence of computer viruses. No responsibility can be accepted in the event that a virus is contained within it or any attachments. - SOMAK TRAVEL LTD - KENYA NAIROBI, PO BOX 48495. Tel: +(2542) 557832 Fax:+(2542) 535175 MOMBASA, PO BOX 90738. Tel: +(25411)486197 Fax:+(25411)487324 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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_ping()
What I want to know, is:
1) after reading the header, how should one respond?
2) Is a command necessary, or can one close after succesfully
authenticating?
3) Is there a sign-off?
Ie - what does a minimal valid connection look like?
I may be totally off, but couldn't you just try to open a socket to the
relevant port - if it goes OK, you're fine. If not, well...
example code in PHP:
if($fp = fsockopen($host_domain, $port, $errno, $errstr, $timeout)){
// - juhuu!
}else{
// - boohoo...
}
Just my quick-and-dirty $0.02
Best regards,
Eivind
sql, query
Best regards,
Melvyn Sopacua
WebMaster IDG.nl
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
If it applies, where it applies - this email is a personal
contribution and does not reflect the views of my employer
IDG.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
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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 timer
Hello, can somebody tell me, how to execute some actions automatically at the specified time, on MySQL server? --- Best Regards, zygiz === Dalyvauk pasaulio futbolo cempionato totalizatoriuje! Kiekviena rungtyniu diena - vertingi prizai. http://www.delfi.lt/news/sport/fifaworldcup/article.php?id=1069515 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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_ping()
I may be totally off, but couldn't you just try to open a
socket to the
relevant port - if it goes OK, you're fine. If not, well...
example code in PHP:
if($fp = fsockopen($host_domain, $port, $errno, $errstr, $timeout)){
// - juhuu!
}else{
// - boohoo...
}
This works but the host that is running that will be blocked after 10 trys.
I am also looking for a different way of doing this without actually installing the
mysql client.
--
Stefan Immel
|N|O|C Network Operation Center
-+-+-+---
| Grove
Auf der Stuecke 6Tel. +49 2773-8167-0
35708 Haiger / Germany Fax +49 2773-8167-20
--
mailto:[EMAIL PROTECTED] http://www.grove.de
There is always hope, only because it is the one
thing nobody's figured out how to kill yet.
~ Galen, Crusade Racing The Night
--
http://www.nocr2.de - NOC R2
die Lösung für den IT-Workflow
--
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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_ping()
Hi Melvyn, If i understand well you need to make a diagnostic of your network ... you must read the ICMP packets to do this. Anyway MySQL recovery the last session(connection) ignoring the time out settings. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Melvyn Sopacua [EMAIL PROTECTED] To: Gelu Gogancea [EMAIL PROTECTED] Cc: MySQL General [EMAIL PROTECTED] Sent: Monday, June 03, 2002 4:30 AM Subject: Re: mysql_ping() Hi Gelu, At 23:10 2-6-2002, Gelu Gogancea shared with all of us: I'm sorry ... i didn't read carefully you mail No problem. Anyway, my opinion is that you should use(i don't know if is possible) the mysql_options to set time out. That works if only mysqld is down and the machine is reachable. If the machine itself is down - it times out. From experience I know that visitors will hit refresh buttons and pretty soon, your webserver will complain as well :-(. Best regards, Melvyn Sopacua WebMaster IDG.nl _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ If it applies, where it applies - this email is a personal contribution and does not reflect the views of my employer IDG.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: command line interface
How do most users of MySQL interact with the program. I would imagine entering or editing large amounts of data at the command line would be quite a task. I have to say thhe comannd line interface is by far my preferred interface against MySQL. There are a few free GUI tools running on windows that I have checked out. For instance MySQLyog, which is available for free. You could also check out MySQLfront. These are front-ends both valuable for inspecting the db, importing data etc. For inserting some amount of data the best method is to import either from prepared SQL files or CSV (comm-separated values) files. And to me, the most convenient way to do these things is right from the command line. No doubt! Once you get used to this way of working, I'm sure it will become second nature. Best regards, Eivind :-) sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql_ping()
At 03:52 3-6-2002, Mark Matthews shared with all of us: So - indeed - I'm probably barking up the wrong tree, by looking at mysql_ping(), but I basically want to mimmick the behavior, so the there's no connection error for the webserver involved. See it as Net::SMTP, using a simple HELO - RSET - QUIT. If you want to see a simpler version of the MySQL protocol in source form, you might want to check out the MM.MySQL JDBC driver, where all of the code you would need to see would be in MysqlIO.java. See http://mmmysql.sourceforge.net/. It is a 100% pure Java version of the libmysql network code, which sounds like the bit you might trying to duplicate from PHP. Set aside the usual Java code overhead :-), this actually is what I was looking for! I think I can port that. Will have a go at that, later tonight. Best regards, Melvyn Sopacua WebMaster IDG.nl _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ If it applies, where it applies - this email is a personal contribution and does not reflect the views of my employer IDG.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: MySQL timer
there is no such thing built in MySQL. you should use cron to have this job done. zygiz wrote: Hello, can somebody tell me, how to execute some actions automatically at the specified time, on MySQL server? --- Best Regards, zygiz === Dalyvauk pasaulio futbolo cempionato totalizatoriuje! Kiekviena rungtyniu diena - vertingi prizai. http://www.delfi.lt/news/sport/fifaworldcup/article.php?id=1069515 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Sammy Lau mailto: [EMAIL PROTECTED] - Tell me what you want and I'll tell you how you can live without 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: mysql not supporting php.
On Monday 03 Jun 2002 9:50 am, David Grant wrote: mysql support is not available to php on this server This is the error I receive. MySQL is working fine, but I need to know how get php working with sql. PHP isn't compiled with MySQL support. Recompile php and add --with-mysql to the configure script. Also, does anyone know the command to list all the db's? thanks. SHOW DATABASES; Cheers, Markus -- Markus Lervik Linux-administrator Vaasa City Library - Regional Library, Finland [EMAIL PROTECTED] +358-6-325 3589/+358-40-832 6709 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 query efficiency - JOINs
I have a question regarding the efficiency of an explicit JOIN statement vs. an implicit one. What I mean: I have a many-to-many mapping through a mapping table. I.e. I have different types of tools mapped to several categories in which they might belong. For instance, a complete programming suite may be categorized both as a debugger, a C-compiler and an assembler... This programming tool is mapped to all these 3 categories through a table just coupling the id's against each other... If the ID of the programming tool itself is 134, the entries for this tool in the mapping table will be like this: +++ | ToolID | TypeID | +++ |134 | 24 | |134 | 19 | |134 | 17 | +++ Now I wonder, when extracting all the info for a certain tool from the database, will it actually be more efficient to use the explicit JOIN statement rather than just tie the keys to one another in the query? This may seem very basic to some; but my formal database knowledge IS very basic. Please, if you can shed some light on the topic or give me som epointers to a good reference; you are very welcome to do so! Best regards, Eivind :-) sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: how to deinstall old mysql version?
On Fri, 31 May 2002, andy wrote: I am just trying to configure my root server. The provider has preinstalled mysql on suse72. So I did try to get rid of this installation with yast, but this did not work out. After compiling php,apache and mysql, PHP is still trying to connect to the old server. The new server is running but how could I tell php to connect to the right server? Thanx for any help on that, Andy sql, query Andy, SuSE has a specific directory tree. When you are going to recompile on a SuSE system you have to use their configuration. Have a look at /usr/share/doc/packages/mysql/README.SuSE Thomas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: smaller mysql docs?
On Fri, 31 May 2002, Ray a PowerWeb Tech wrote: is there a place to get the manual that is split a bit more then the current manual_split. these are the 2 pages i end up reading the most even though its usually for just the grant, create, insert syntax (human in need of memory upgrade) 416k Sep 26 2001 manual_MySQL_Database_Administration.html 312k Sep 26 2001 manual_Reference.html i'm not sure what's wrong with my computer, but loading the pages takes a while from the local harddrive, or maybe its rendering the page... either way, the larger pages are annoyingly slow. or is there a cheat sheet page? (syntax, links into the manual, not much else) Ray, get a copy of pinfo-0.6.3.tar.gz, compile and use it to load mysql.info It looks like lynx with colors and works like a charm. Thomas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Installation process
Mary, Friday, May 31, 2002, 7:39:34 PM, you wrote: MD I am a newbie, to group and MySQL. MD I just downloaded MySQL for win 2000. MD The zip file, when opened and clicked on install, MD it created c:\mysql directory and did the install. MD Now what next? MD DOnt I have to start the server? MD How do I create instances? MD How do I get into the dbadmin to maintain tables etc,? MD What is the super user id? how do I set this up? MD I have a limited experience on Oracle. MD A DB2 or ACCESS like control center - is something MD like that available on MySQL? Mary, all your questions are completly covered in the MySQL manual. How to start the MySQL server: http://www.mysql.com/doc/N/T/NT_start.html Info about option files my.cnf (my.ini) read at: http://www.mysql.com/doc/O/p/Option_files.html About privileges and secure in MySQL: http://www.mysql.com/doc/P/r/Privilege_system.html http://www.mysql.com/doc/U/s/User_Account_Management.html How to create and use database: http://www.mysql.com/doc/D/a/Database_use.html MD thanx for any response and any clue in tis direction. MD -Mary -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: mysqldump -A dump.txt
Eric, Monday, June 03, 2002, 1:49:24 AM, you wrote: EF I didn't get that deeply into why exactly, but it seems that when I removed EF the mysql database from the file, that the rest went fine with EF mysql -u -p dumpfile If you use -A option for mysqldump, mysqldump makes backup of all databases including database 'mysql'. If you don't want to make backup of database 'mysql' use -B option for mysqldump. Look at: http://www.mysql.com/doc/m/y/mysqldump.html EF I got an error about the column_prv field already existing I believe. Sorry, EF I should have been much more specific. I appreciate your answering even EF though I was vague. EF I think mostly I learned my lesson, and I should export one database at a EF time, with --tab= EF Thanks, EF Eric -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL timer
zygiz, Monday, June 03, 2002, 11:58:42 AM, you wrote: z Hello, can somebody tell me, how to execute some actions automatically at the specified time, on MySQL server? You can't do it with MySQL only. z zygiz -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re:Installing
weng, Thursday, May 30, 2002, 2:52:29 AM, you wrote: If you start MySQL server from MS DOS prompt as: C:\mysql\binmysqld-nt --standalone --debug mysqld shows you warning message. wc hi! i tried this already.. And? What result did you get? Does MySQL server run with --standalone --debug options? wc but whenever i type wc mysqld-nt -install to install mysql as a service.. an wc error messge Failed to install service occurs.. wc using Windows 2000 wc but if i type net start mysql, it says that wc The requested service has alrdy been started. Look in Control Panel - Administrative Tools - Services is there MySQL in the list of services? If so, is it running? wc and i really dont know if this is the reason why i wc cant view php files in IE correctly.. wc pls help.. thanks.. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: install MySql on drive other than C
Inbal, Sunday, June 02, 2002, 11:42:01 AM, you wrote: IO I read in the manual about building mysql not on c:\ IO and i found that i need to change the file my.ini IO my questions are: IO 1) can i build this file by my self and not with winmysqladmin.exe? Yes, you can create file my.ini or my.cnf by yourself. IO 2) it is enough to change this file if i want to put mysql in drive d, or am IO i need to do another changes? You should specify path to MySQL base dir and data dir, look at: http://www.mysql.com/doc/W/i/Windows_prepare_environment.html IO thanks -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Interbase vs MySQL
Hi all. I'm looking for a comparison between Interbase and MySQL. Thanks in advance. Iago. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL startup error
This is the error message that I get Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Could ayone please show me how to sort this out I had MySQL running before this. This has happened all of a sudden. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Fw: fault tolerance
On Sun, 2 Jun 2002 16:39:36 -0500 Khaled Elmeleegy [EMAIL PROTECTED] wrote: What if the MySQL server crashes during an Insert or delete or update statement, In what state would that leave the database, and would MySQL recover? If so how would it do that? If not what would happen, half of the statement would get executed before the crash while the rest is not? Would you please direct me to where i can find documentation about how MySQL handles recovery in case of normal queries (one sql statement) not transactions (as i know it uses journals for transactions, but not sure if it does the same with queries) Thanks, Khaled Hi! It depends on the table handler. With MyISAM you have to REPAIR TABLE(s) thereafter if they are corrupted. But why would MySQL server crash at all , when it is very stable. Also, keep in mind that this list is dedicated to the internal functioning of MySQL server, not to the general questions of this kind. -- 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
RE: Bug with multi-table DELETE in MySQL 4.0.1
Leeuw van der, Tim writes: Hello, Thank you very much for your reply! I was hoping that this was indeed fixed in 4.0.2. I was using 4.0.0 when the bug occurred and upgraded today to 4.0.1; I will retest the query with 4.0.2 as soon as it's released. Apologies btw for not mentioning the version I was using. With regards, --Tim Hi! Thank you for your bug report, thanks to which bug in multi-table delete was fixed. A fix will come up in 4.0.2. This is a patch for the bug: = sql/sql_parse.cc 1.228 vs edited = *** /tmp/sql_parse.cc-1.228-5440Wed May 29 21:20:27 2002 --- edited/sql/sql_parse.cc Sat Jun 1 21:23:55 2002 *** *** 1960,1965 --- 1960,1966 } auxi-lock_type=walk-lock_type=TL_WRITE; auxi-table= (TABLE *) walk;// Remember corresponding table + (void)add_item_to_list(new Item_field(auxi-db,auxi-real_name,*)); } tables-grant.want_privilege=(SELECT_ACL ~tables-grant.privilege); if (add_item_to_list(new Item_null())) -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL + cygwin
Hello Chris, I would recommend to try to compile MySQL itself under cygwin (or you already tried it?). Just use GCC version they suggest (I failed to compiled it using GCC 3.1). BTW, if you succeed, I would really appreciate if send me mysqlclient-library compiled under cygwin. CK Anyone have any ideas on how to get MySQL to work under cygwin? CK I'm especially interested in getting a libmysqlclient which is compatible CK with cygwin so that I can use it to compile various other program which CK require the library... CK Currently, I run mysql 3.23.49-max for Win32 (NT 4.0) because I do most of CK my development thereon, but lately, I've been starting to integrate various CK DB and PHP related functions into my unix like system (which is currently CK non existent). CK Because of this, the closest I can find to running both a linux equivalent CK and a Win32 platform, is cygwin But alas... No mysql for cygwin, only CK for Win32? CK And I can't use the Win32 includes or libraries to compile other related CK software via cygwin, it complains about a incompatible host type... CK snips lots of ./configure stuff CK configure: warning: /cygdrive/d/mysql/lib/opt: invalid host type CK configure: warning: /cygdrive/d/mysql/include: invalid host type CK configure: error: can only configure for one host and one target at a time CK /snip CK Any idea's or help will be appreciated... Best regards, Yegor __ Yegor Bryukhov, PhD student at GC CUNY office: 4330 office phone: +1(212)817-8653 home phone: +1(718)842-4250 e-mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ENCODE algorithm
On Mon, 2002-06-03 at 04:58, Evgeny Chuykov wrote: What algorithm do ENCODE-DECODE functions use? This is noname algorithm with questionable security level. Use DES_ENCRYPT/DES_DECRYPT instead. This uses triple DES. Tõnu sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Get message
How can I get the message when I make a query like e.g: 8 rows in set (0.01 sec) How can I get with Delphi. I use the component Zeos dbo to access Mysql Regards Alexander Curitiba/BRA A busca mais veloz e precisa da internet. Acesse agora: http://www.zoom.com.br. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: subselects in mysql 4.1 and other questions
Alexander, Monday, June 03, 2002, 9:46:40 AM, you wrote: AB 1. I am reading 'internals' list and I see some words about subselect in 'bk AB commit into 4.1 tree' messages... AB Seems like we can expect subselect in 4.1 branch !?? :) Yeah, sub-selects is in our TODO for 4.1, look at: http://www.mysql.com/doc/T/O/TODO_MySQL_4.1.html AB 2. When 4.0.2 beta will be released? 4.0.2 will come soon. AB 3. Seems like gcc 3.0 (or 3.1?) becomes an official recommended compliler AB for mysql source (at least for linux)? It depends on version of MySQL, for 3.23.* use 2.95.X where X=2 is recommended. Look at: http://www.mysql.com/doc/I/n/Installing_source.html for 3.23.50 you can use either gcc 2.95.x or gcc 3.0.x to compile MySQL. AB Thanks, sorry for my English, AB Alexander -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL startup error
Neville, Monday, June 03, 2002, 1:44:25 PM, you wrote: NL This is the error message that I get NL NL Can't connect to local MySQL server through socket NL '/var/lib/mysql/mysql.sock' (2) NL NL Could ayone please show me how to sort this out NL I had MySQL running before this. This has happened NL all of a sudden. perror 2 Error code 2: No such file or directory If you MySQL server is running, it may happen because 1. you don't have permissions on that file/dir 2. your socket file is located in other place - check where mysql.sock is located and specify path to the socket with --socket option. 3. Somebody deleted socket file. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Setting Auto Increment
Arul, Saturday, June 01, 2002, 8:34:40 AM, you wrote: A Is it that i can make a column auto increment only if its data type is A integer. A Can i not set auto increment value for a numeric datatype You can set up AUTO_INCREMENT attribute for all int's and float's types. A -Arul -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: replication problem
Hello, More than likely you have missed the step that the slave database has to be the exact one that the master has before the start of the binlog. Shutdown both servers, grab a copy of the master's data directory and tar that up, move that to the slave, delete the slave's current data directory, now untar the master's data dir in appropriate place on the slave (/usr/local/mysql in most cases), then make sure the permissions on the files a right (basically the mysql user must be able to read write to the files the directory), then restart the master, then finally restart the slave. i did exactly that, checked md5sums on all files and whether mysql user can create/read/write to mysql's data directory. then i start master, and in its datadir 3 files show up: mysql log, binary log and index file after that i start slave, and in its datadir 2 files show up: mysql log and master.info file. in mysql log i can read: 020603 14:49:18 mysqld started /usr/sbin/mysqld: ready for connections 020603 14:49:18 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'FIRST' at position 4 020603 14:49:18 Slave: received 0 length packet from server, apparent master shutdown: (0) 020603 14:49:18 Slave: Failed reading log event, reconnecting to retry, log 'FIRST' position 35 020603 14:49:18 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'FIRST' at position 35 020603 14:49:18 Slave: received 0 length packet from server, apparent master shutdown: (0) what am i doing possible wrong ? please help, terry - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Autorefresh MyODBC
Hi. Can we use Access to link table in MySQL and force Access to refresh data from MySQL automatically when data in MySQL table have change. Kittiphum Worachat,M.T. www.hatyailab.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL + cygwin
hi, i have mysql compiled with cygwin with gcc version 2.95.3 you can fetch installed version from http://www3.ibt.com.pl/mysql.tar.gz it is prepared to be installed in /opt in cygwin's directory structure best regards, terry -Original Message- From: Yegor N. Bryukhov [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 1:41 PM To: Chris Knipe Cc: [EMAIL PROTECTED] Subject: Re: MySQL + cygwin Hello Chris, I would recommend to try to compile MySQL itself under cygwin (or you already tried it?). Just use GCC version they suggest (I failed to compiled it using GCC 3.1). BTW, if you succeed, I would really appreciate if send me mysqlclient-library compiled under cygwin. CK Anyone have any ideas on how to get MySQL to work under cygwin? CK I'm especially interested in getting a libmysqlclient which is compatible CK with cygwin so that I can use it to compile various other program which CK require the library... CK Currently, I run mysql 3.23.49-max for Win32 (NT 4.0) because I do most of CK my development thereon, but lately, I've been starting to integrate various CK DB and PHP related functions into my unix like system (which is currently CK non existent). CK Because of this, the closest I can find to running both a linux equivalent CK and a Win32 platform, is cygwin But alas... No mysql for cygwin, only CK for Win32? CK And I can't use the Win32 includes or libraries to compile other related CK software via cygwin, it complains about a incompatible host type... CK snips lots of ./configure stuff CK configure: warning: /cygdrive/d/mysql/lib/opt: invalid host type CK configure: warning: /cygdrive/d/mysql/include: invalid host type CK configure: error: can only configure for one host and one target at a time CK /snip CK Any idea's or help will be appreciated... Best regards, Yegor __ Yegor Bryukhov, PhD student at GC CUNY office: 4330 office phone: +1(212)817-8653 home phone: +1(718)842-4250 e-mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Autorefresh MyODBC
Since Access is using ODBC to get to the tables I'm pretty sure this is not possible. You could write an access form with a timer on it that requereies the data ever x seconds to refresh it. (But this is bad...m'Kay?) =C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -Original Message- From: Kittiphum Worachat [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 7:54 AM To: [EMAIL PROTECTED] Subject: Autorefresh MyODBC Hi. Can we use Access to link table in MySQL and force Access to refresh data from MySQL automatically when data in MySQL table have change. Kittiphum Worachat,M.T. www.hatyailab.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: Get message
you can't. Check the archives, this was discussed about 2 weeks ago. * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 7:13 AM To: [EMAIL PROTECTED] Subject: Get message How can I get the message when I make a query like e.g: 8 rows in set (0.01 sec) How can I get with Delphi. I use the component Zeos dbo to access Mysql Regards Alexander Curitiba/BRA A busca mais veloz e precisa da internet. Acesse agora: http://www.zoom.com.br. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Command line interface
Have a look at urSQL from http://www.urbanresearch.com/ursql On Mon, 3 Jun 2002, Ehmer David wrote: Hi Very new to MySQL and just wondering if there is an alternative interface to the command line. The beginners tutorial I am working through from WWW.Mysql.com seems to do all tasks from the command line. This seems very cumbersome in modern times. I understand there is a graphical interface in development. If so is it an improvement to the command line. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
1 or 2 tables with the same data
I have a MySQL table called questions where I have (qid, catid, userid, title, question, point, status, timestamp) title and question are of type text with a FULLTEXT index and never change. I use the table for: - Get all data - Get results from several rows without fetching the title and question. - Search for rows where title or question match text. My question is, would it be an advantage to have all data in one table and all fixed data such as (qid, catid, userid, point, status, timestamp) in another table? Regards Jacob - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Autorefresh MyODBC
This depends on whether the table will always be open I believe you are using MyODBC connection. Create a new table and then choose link table in access. While linking choose to save the password. Any changes which will occur in the mysql table will be viewable from access. But this will occur when the table is reopened. If the table is already open the record changes will not be viewable. - Original Message - From: Kittiphum Worachat [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 03, 2002 3:54 PM Subject: Autorefresh MyODBC Hi. Can we use Access to link table in MySQL and force Access to refresh data from MySQL automatically when data in MySQL table have change. Kittiphum Worachat,M.T. www.hatyailab.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 - This email and any files transmitted with it are confidential and intended solely for the use of the addressee. If you have received this email in error you may not disclose, copy, distribute or act upon its contents without the authors prior written consent. Please can you notify the system manager at [EMAIL PROTECTED] immediately and delete this email. - Any views or opinions expressed are those of the author and do not necessarily represent those of Somak Travel Limited, Kenya. - This footnote also confirms that this email message has been swept for the presence of computer viruses. No responsibility can be accepted in the event that a virus is contained within it or any attachments. - SOMAK TRAVEL LTD - KENYA NAIROBI, PO BOX 48495. Tel: +(2542) 557832 Fax:+(2542) 535175 MOMBASA, PO BOX 90738. Tel: +(25411)486197 Fax:+(25411)487324 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Get message
Unfortunately, I don't have. I subscribed today. -- Mensagem Original -- you can't. Check the archives, this was discussed about 2 weeks ago. * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 7:13 AM To: [EMAIL PROTECTED] Subject: Get message How can I get the message when I make a query like e.g: 8 rows in set (0.01 sec) How can I get with Delphi. I use the component Zeos dbo to access Mysql Regards Alexander Curitiba/BRA A busca mais veloz e precisa da internet. Acesse agora: http://www.zoom.com.br. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php A busca mais veloz e precisa da internet. Acesse agora: http://www.zoom.com.br. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 not supporting php.
It sounds as if you didn't compile in mysql support with you php executable. You can check this using the phpinfo() function. If you are using the cgi only, try something like... 'php -q -i | grep configure' This will show you all the configuration options you selected when compiling/installing php. There will be some html junk you'll have to sift through, but you should be able to see it. As for showing the db's, try mysqlshow. If you want to see the tables in a db, mysqlshow db_name. If you want to see the info for one table in a db, mysqlshow db_name table_name. Later on, Big Din KR (Terrence :-|) - Original Message - From: David Grant [EMAIL PROTECTED] Date: 02 Jun 2002 23:50:53 -0700 To: My SQL Mailing List [EMAIL PROTECTED] Subject: mysql not supporting php. mysql support is not available to php on this server This is the error I receive. MySQL is working fine, but I need to know how get php working with sql. Also, does anyone know the command to list all the db's? thanks. Dave - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- ___ Download the free Opera browser at http://www.opera.com/ Powered by Outblaze - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
is there a whoami for mysql?
is there a show grants self or a whoami type command? i'm trying to setup security, but i'm not show who i'm login in as? root@% or [EMAIL PROTECTED]/255.255.255.0 i am logging in just fine, but i don't really want to delete root@% until i know i'm getting the right login. \s just shows me Current user: [EMAIL PROTECTED] but show grants for [EMAIL PROTECTED]; says there are no grants for this account. also, i could see this coming up for debugging as a big help. note: all ips and usernames have been changed to protect the incredably insecure, and maybe a bit paranoid. sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Get message
'salright. Short answer. The driver does not give you this message. you can time the execution yourself and then count the rows. For the full discussion try digging around at: http://www.mysql.com/documentation/searchlists.html HTH, =C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 8:23 AM To: [EMAIL PROTECTED] Subject: RE: Get message Unfortunately, I don't have. I subscribed today. -- Mensagem Original -- you can't. Check the archives, this was discussed about 2 weeks ago. * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 7:13 AM To: [EMAIL PROTECTED] Subject: Get message How can I get the message when I make a query like e.g: 8 rows in set (0.01 sec) How can I get with Delphi. I use the component Zeos dbo to access Mysql Regards Alexander Curitiba/BRA A busca mais veloz e precisa da internet. Acesse agora: http://www.zoom.com.br. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php A busca mais veloz e precisa da internet. Acesse agora: http://www.zoom.com.br. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
INSERT performance when indexes are used
Hi, I have a table with about 5 million records, and an index on that table's VARCHAR(255) field, as well as a couple of integer indexes. The VARCHAR-index is essential to my application as I frequently need to search through the whole table by using the VARCHAR field. When I do INSERTs into this table, they sometimes take a considerably long time to complete. For example, inserting 1000 rows sometimes takes 700 ms, sometimes 7 ms. I assume this is because the indexes need to be modified. Is it possible to leave extra space in the index tree leaves so that individual INSERTs could work without modifications to the whole index tree? I know that I'll have about 1-2 INSERTs per day, and I'd like each of them to work as fast as possible (preferably less than 1 ms). Since the table grows anyway, I don't mind the index files containing some unused space. The table is a MyISAM table, with a 1 GB MYD-file and a 400 MB MYI-file. I know there are workarounds to this problem (doing inserts in a single batch instead of several, loading data from a text file, etc.), but for now I'd just like to know how well the indexes can be customized. I am running MySQL 3.23.49 on Windows NT with MyISAM tables. -- Mikko Noromaa (mikkon@nm-sol) - tel. +358 40 7348034 Noromaa Solutions - see http://www.nm-sol.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
Big table and Mysql
Hi all, I would like to ask if is possible create and use this table size with MySQL. So, I have 15 columns in 1 row and it contain 100B of data. I have in plane insert cca 30 000 000 rows per year - 3 GB/year * 4 years = 12 GB of data (120 000 000 rows and 1 800 000 000 ). HW configuration is: 2x PIII/1.4G, 2GB RAM, HW RAID 5 - HDD 3x73GB 15000rpm OS Linux 2.4.18 ext3. So is possible do it with MySQL, this HW and Linux? Thanks for any advice and experiences. bewel Bez Financ se pi koupi nemovitosti neobejdete http://reality.finance.cz - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 not supporting php.
At 01:50 AM 6/3/2002, you wrote: mysql support is not available to php on this server This is the error I receive. MySQL is working fine, but I need to know how get php working with sql. Also, does anyone know the command to list all the db's? thanks. Dave Dave, Switch to PHP 4.2.1 which has MySQL built into it. It also fixes some security problems. See www.php.net for download. 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
Re: Interbase vs MySQL
At 05:28 AM 6/3/2002, you wrote: Hi all. I'm looking for a comparison between Interbase and MySQL. Thanks in advance. Iago. lago See http://lists.mysql.com/php/search.php?ps=10q=interbaseps=20m=and. 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
Re: MySQL + cygwin
Hi Chris, I have tried to compile following version of the MySQL under cygwin. - 3.23.47 - 3.23.50 - 4.0.1 I was able to compile (client + server ) all of mentioned version, BUT most of the test have failed except for the version 3.23.50 that seem to me to work in most cases but not in all. I am still exploring the cygwin MySQL and therefore there could be people with other experience. For your information I was able to connect to my cygwin MySQL Server (3.23.50) with the MyCC GUI interface as well as compile the DBD::mysql Perl module that I am using for LXR source code indexer and cross-referencer under Cygwin. I have to admit that I am not sure about reliability be my compiled MySQL Server. I am able to use only the safe_mysqld variant of the MySQL startup procedure. (For some reason in MySQL version 4.0.1 it is called mysqld_safe). When I tried to use the Perl module (compiled with cygwin MySQL client v3.23.50) to connect to the Win32 MySQL server 4.0.x via mysql.sock I was unsuccessful. I do not know whether it is possible at all. The Win32 MySQL server didn't created the socket file. Maybe my configuration is incorect. My suggestion is that you use the MySQL version 3.23.50. Only this version I was able to put alive. Cheers, Viliam - Original Message - From: Chris Knipe [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 03, 2002 4:49 PM Subject: MySQL + cygwin Anyone have any ideas on how to get MySQL to work under cygwin? I'm especially interested in getting a libmysqlclient which is compatible with cygwin so that I can use it to compile various other program which require the library... Currently, I run mysql 3.23.49-max for Win32 (NT 4.0) because I do most of my development thereon, but lately, I've been starting to integrate various DB and PHP related functions into my unix like system (which is currently non existent). Because of this, the closest I can find to running both a linux equivalent and a Win32 platform, is cygwin But alas... No mysql for cygwin, only for Win32? And I can't use the Win32 includes or libraries to compile other related software via cygwin, it complains about a incompatible host type... snips lots of ./configure stuff configure: warning: /cygdrive/d/mysql/lib/opt: invalid host type configure: warning: /cygdrive/d/mysql/include: invalid host type configure: error: can only configure for one host and one target at a time /snip Any idea's or help will be appreciated... -- me query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: is there a whoami for mysql?
Hi Ray, You can see what user you is with: select user(); Ray wrote: is there a show grants self or a whoami type command? i'm trying to setup security, but i'm not show who i'm login in as? root@% or [EMAIL PROTECTED]/255.255.255.0 i am logging in just fine, but i don't really want to delete root@% until i know i'm getting the right login. \s just shows me Current user: [EMAIL PROTECTED] but show grants for [EMAIL PROTECTED]; says there are no grants for this account. also, i could see this coming up for debugging as a big help. note: all ips and usernames have been changed to protect the incredably insecure, and maybe a bit paranoid. sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- -- \|/ __\|/ `@ / o . \ @' Microsoft? Por acaso é alguma nova /___| \/ |___\ marca de papel higiênico? \___U__/ .^. Luciano Barcaro - Linux User # 99517 /v\ Registre-se gratuitamente em // \\http://counter.li.org //(.)\\ ICQ # 17266954 ^`~'^ -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
INSERT performance when indexes are used
Hi, I have a table with about 5 million records, and an index on that table's VARCHAR(255) field, as well as a couple of integer indexes. The VARCHAR-index is essential to my application as I frequently need to search through the whole table by using the VARCHAR field. When I do INSERTs into this table, they sometimes take a considerably long time to complete. For example, inserting 1000 rows sometimes takes 700 ms, sometimes 7 ms. I assume this is because the indexes need to be modified. Is it possible to leave extra space in the index tree leaves so that individual INSERTs could work without modifications to the whole index tree? I know that I'll have about 1-2 INSERTs per day, and I'd like each of them to work as fast as possible (preferably less than 1 ms). Since the table grows anyway, I don't mind the index files containing some unused space. The table is a MyISAM table, with a 1 GB MYD-file and a 400 MB MYI-file. I know there are workarounds to this problem (doing inserts in a single batch instead of several, loading data from a text file, etc.), but for now I'd just like to know how well the indexes can be customized. I am running MySQL 3.23.49 on Windows NT with MyISAM tables. -- Mikko Noromaa (mikkon@nm-sol) - tel. +358 40 7348034 Noromaa Solutions - see http://www.nm-sol.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: INSERT performance when indexes are used
One thing you could try is limiting your index length ALTER TABLE `sometable` ADD INDEX(`somecolumn`(10)) This will only index off of the first 10 characters of your data. Depending on the type of data you store, this may improve your performance. - Original Message - From: Mikko Noromaa [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 03, 2002 9:11 AM Subject: INSERT performance when indexes are used Hi, I have a table with about 5 million records, and an index on that table's VARCHAR(255) field, as well as a couple of integer indexes. The VARCHAR-index is essential to my application as I frequently need to search through the whole table by using the VARCHAR field. When I do INSERTs into this table, they sometimes take a considerably long time to complete. For example, inserting 1000 rows sometimes takes 700 ms, sometimes 7 ms. I assume this is because the indexes need to be modified. Is it possible to leave extra space in the index tree leaves so that individual INSERTs could work without modifications to the whole index tree? I know that I'll have about 1-2 INSERTs per day, and I'd like each of them to work as fast as possible (preferably less than 1 ms). Since the table grows anyway, I don't mind the index files containing some unused space. The table is a MyISAM table, with a 1 GB MYD-file and a 400 MB MYI-file. I know there are workarounds to this problem (doing inserts in a single batch instead of several, loading data from a text file, etc.), but for now I'd just like to know how well the indexes can be customized. I am running MySQL 3.23.49 on Windows NT with MyISAM tables. -- Mikko Noromaa (mikkon@nm-sol) - tel. +358 40 7348034 Noromaa Solutions - see http://www.nm-sol.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
How to select last record?
Hello! :) Is there any chance to select last record in one sql statement? Thanks. Kosyo __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: How to select last record?
[snip] Is there any chance to select last record in one sql statement? [/snip] Try this query; SELECT * FROM tableName ORDER BY id DESC LIMIT 1 HTH! Jay - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: is there a whoami for mysql?
mysql select user(); +---+ | user()| +---+ | [EMAIL PROTECTED] | +---+ mysql show grants for [EMAIL PROTECTED]; ERROR 1141: There is no such grant defined for user 'root' on host '192.168.0.17' mysql show grants for user(); ERROR 1064: You have an error in your SQL syntax near 'user()' at line 1 mysql select user,host from mysql.user where user='root'; +---+---+ | user | host | +---+---+ | root | % | | root | 192.168.0.0/255.255.255.0 | | root | localhost | +---+---+ in theory i should be logged in [EMAIL PROTECTED]/255.255.255.0, but i've been wrong before... is there a way to just get which user/host set is being used? On Monday 03 June 2002 9:28, you wrote: Hi Ray, You can see what user you is with: select user(); Ray wrote: is there a show grants self or a whoami type command? i'm trying to setup security, but i'm not show who i'm login in as? root@% or [EMAIL PROTECTED]/255.255.255.0 i am logging in just fine, but i don't really want to delete root@% until i know i'm getting the right login. \s just shows me Current user: [EMAIL PROTECTED] but show grants for [EMAIL PROTECTED]; says there are no grants for this account. also, i could see this coming up for debugging as a big help. note: all ips and usernames have been changed to protect the incredably insecure, and maybe a bit paranoid. sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- The best cure for insomnia is to get a lot of sleep. -- W. C. Fields - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
support UTF-8
Hi , Do mysql ver 2.23.X support UTF-8 . If yes , to what extends. I have tried UTF-8 with mysql ver 3.23.37 on windows. It seems as that it support UTF-8 , but tools (utilities ) for mysql does not fully support utf . Have any body have tried that. Regards, shahzad sarwar - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Insert into longblob column, it's limitation
Good Day
I will attempt to give you as much information about the software as I can before I
ask the question.
OS : RedHat 7.1
MySQL : Version 3.23.49a for Linux - binary distribution for pc-linux
I want to insert into longblob column very big large data.
but.. I have strange Errors...
Example..
mysql create table test (aa longblob);
mysql insert into test values(load_file('testfile.exe'));
ERROR 1030 : Got error 139 from table handler
mysql
./perror 139 - Too big row ( = 16M)
The size of testfile.exe is 16.3M
The table type of test is MYISAM
max_allowed_packet = 6700(64M?)
I don't know about this error...
So..
I want to know the limitation of longblob column for each table Type, InnoDB, MYISAM.
And. How do insert into longblob column 4G data?
Thank you
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Sluggish performance on medium sized table.. EXPLAIN SELECT's included.
A database is being used to log support calls for a call center. There are around 25,000 clients in the database. The existing call notes were imported from flat text files. One table (call_notes) contains the call time, ticketid, noteid, ect.. Another table (call_notes_text) only contains noteid and note_text. When I query the call_notes table for a specific noteid, the info is returned instantly. However when I query the call_notes_text table for a specific noteid it takes 15-17 seconds to return the data. The table has around 15,000 rows with each row containing a field about the size of a small newspaper article. The server is a dual processor intel333 with 256k ram (RH7.2) running MySQL 3.23.41. When running the queries outline below CPU usage is only around 15% or so. Each table contains an id which is key. I've copied and pasted results from some EXPLAIN table queries below. mysql explain call_notes; +--++--+-+-+ + | Field| Type | Null | Key | Default | Extra | +--++--+-+-+ + | noteid | int(10)| | PRI | NULL| auto_increment | | ticketid | int(10)| | | 0 | | | userid | int(5) | | | 0 | | | contactid| int(5) | | | 0 | | | call_start | datetime | | | -00-00 00:00:00 | | | call_end | datetime | | | -00-00 00:00:00 | | | call_elapsed | time | | | 00:00:00| | | call_seconds | int(10)| | | 0 | | | entered_statusid | tinyint(2) | | | 0 | | | datemodified | datetime | | | -00-00 00:00:00 | | +--++--+-+-+ + 10 rows in set (0.00 sec) mysql explain call_notes_text; +---+-+--+-+-++ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-++ | noteid| int(10) | | PRI | NULL| auto_increment | | note_text | text| | | || +---+-+--+-+-++ 2 rows in set (0.00 sec) mysql explain facility_contact; +--+-+--+-+-+--- -+ | Field| Type| Null | Key | Default | Extra | +--+-+--+-+-+--- -+ | contactid| int(10) | | PRI | NULL| auto_increment | | fnum | varchar(8) | | | | | | contact | varchar(30) | | | | | | contactadded | datetime| | | -00-00 00:00:00 | | +--+-+--+-+-+--- -+ 4 rows in set (0.00 sec) mysql explain users; +--+--+--+-+-+-- --+ | Field| Type | Null | Key | Default | Extra | +--+--+--+-+-+-- --+ | userid | int(10) | | PRI | NULL| auto_increment | | username | varchar(50) | | | | | | password | varchar(50) | | | | | | deptid | tinyint(4) | | | 0 | | | jobtitleid | int(2) | | | 0 | | | namefirst| varchar(50) | | | | | | namelast | varchar(50) | | | | | | ext | int(5) | | | 0 | | | email| varchar(100) | | | | | | level| int(1) | | | 1 | | | senior | char(3) | | | | | | dateadded| datetime | | | -00-00 00:00:00 | | | datemodified | datetime | | | -00-00 00:00:00 | | | active | tinyint(1) | | | 1 | | +--+--+--+-+-+-- --+ 14 rows in set (0.00 sec) Here is the actual query that is being used in the script. (I've broken down so it's easier to read) SELECT call_notes.call_elapsed, call_notes.call_seconds, call_notes.call_start, call_notes.call_end, call_notes_text.note_text, users.username, users.namefirst, users.email, facility_contact.contactid,
Sluggish performance on medium sized table.. EXPLAIN SELECT's i ncluded.
A database is being used to log support calls for a call center. There are around 25,000 clients in the database. The existing call notes were imported from flat text files. One table (call_notes) contains the call time, ticketid, noteid, ect.. Another table (call_notes_text) only contains noteid and note_text. When I query the call_notes table for a specific noteid, the info is returned instantly. However when I query the call_notes_text table for a specific noteid it takes 15-17 seconds to return the data. The table has around 15,000 rows with each row containing a field about the size of a small newspaper article. The server is a dual processor intel333 with 256k ram (RH7.2) running MySQL 3.23.41. Each table contains an id which is key. I've copied and pasted results from some EXPLAIN table queries below. Here is the actual query that is being used in the script. (I've broken down so it's easier to read) SELECT call_notes.call_elapsed, call_notes.call_seconds, call_notes.call_start, call_notes.call_end, call_notes_text.note_text, users.username, users.namefirst, users.email, facility_contact.contactid, facility_contact.contact FROM call_notes, call_notes_text, users, facility_contact WHERE call_notes.ticketid = '1' call_notes.userid = users.userid call_notes.contactid = facility_contact.contactid call_notes_text.noteid = call_notes.noteid ORDER BY call_notes.call_start DESC; (results snipped) 1 row in set (17.89 sec) Now I go to command line and run this query: mysql SELECT * FROM call_notes_text WHERE noteid='1'; (results snipped) 1 row in set (0.00 sec) I ran an EXPLAIN SELECT on my main query. (fyi, ticketid 1 has a noteid of 1) EXPLAIN SELECT call_notes.call_elapsed, call_notes.call_seconds, call_notes.call_start, call_notes.call_end, call_notes_text.note_text, users.username, users.namefirst, users.email, facility_contact.contactid, facility_contact.contact FROM call_notes, call_notes_text, users, facility_contact WHERE call_notes.ticketid = '1' call_notes.userid = users.userid call_notes.contactid = facility_contact.contactid call_notes_text.noteid = call_notes.noteid ORDER BY call_notes.call_start DESC; +--++-+-+-+- ---+---+-+ | table| type | possible_keys | key | key_len | ref| rows | Extra | +--++-+-+-+- ---+---+-+ | call_notes_text | ALL| PRIMARY,noteid,noteid_2 | NULL|NULL | NULL | 14682 | Using temporary; Using filesort | | call_notes | eq_ref | PRIMARY,noteid,noteid_2 | PRIMARY | 4 | call_notes_text.noteid | 1 | where used | | users| eq_ref | PRIMARY,userid | PRIMARY | 4 | call_notes.userid | 1 | | | facility_contact | eq_ref | PRIMARY,contactid | PRIMARY | 4 | call_notes.contactid | 1 | | +--++-+-+-+- ---+---+-+ 4 rows in set (0.00 sec) Note the number of rows returned from call_notes_text. This matches the total number of rows in that table. It appears to be a problem with the query, but I can't see where the problem is. Thanks for any help you can provide. - 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
No response from mysql; mysql_install_db freezes
From: Peter Lloyd [EMAIL PROTECTED] To: script Subject: No response from mysql; mysql_install_db freezes Description: I am following the installation instructions in the documentation, and after invoking the script 'mysql_install_db', I see a few announcements, then nothing happens. I waited for hours and still nothing happened. I tried several times and still nothing happened. The announcements that appear on the screen are: Creating db table Creating host table Creating user table Creating func table Creating tables_priv table Creating columns_priv table ... and then nothing. I looked inside the script and I can see that, at this point, it is issuing the command to mysql to create some tables. So, I tried to reproduce this manually, but again I get nothing. The documentation suggests that I should see the 'mysql' prompt and be able to issue SQL commands, but I see no prompt and every command is ignored except CTRL-Z, which produces the response Stopped (user) I checked whether the MySQL daemon is running -- it is: 20644 pts/10 0:02 mysqld 20583 pts/10 0:00 csh 20640 pts/10 0:00 mysql_in After several attempts there seem to be multiple daemons, which I guess is wrong. I tried to 'kill pid' then but that had no effect. I read the relevant documentation: 2.4.1 Problems Running mysql_install_db but it does not cover this situation. I tried stopping and starting the daemon using mysql.server stop and start, but in both cases I got the response 'cannot execute'. How-To-Repeat: scripts/mysql_install_db Fix: Not known. Help requested! Submitter-Id: peri Originator:Peter Lloyd Organization: Nortel Networks MySQL support: none Synopsis: mysql_install_db does not complete. Severity: critical Priority: high Category: mysql Class: support Release: mysql-3.22.30 (TCX binary) Environment: System: SunOS wcm1s0m1 5.6 Generic_105181-19 sun4u sparc SUNW,Ultra-5_10 Architecture: sun4 Some paths: /opt/bin/perl /usr/ccs/bin/make /opt/SUNWspro/bin/cc Compilation info: CC='gcc' CFLAGS='-O2 -fomit-frame-pointer' CXX='gcc' CXXFLAGS='-O2 -fomit-frame-pointer' LDFLAGS='' Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=TCX binary' --disable-shared Perl: This is perl, version 5.005_02 built for sun4-solaris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
4.0 When?
Hi, Is there a roadmap for mysql 4.0? We'd like to upgrade our MySQL DB server to another one which can use some useful techniques eg. sub-selects, transaction handling, etc. I like mysql very much and I know that in 4.0 these techs will be implemented. But I don't know when will this new server released... Thanks in advance! Regards; Istvan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: 4.0 When?
Oh, not the alpha, but the stable version, of course! Is there a roadmap for mysql 4.0? We'd like to upgrade our MySQL DB server to another one which can use some useful techniques eg. sub-selects, transaction handling, etc. I like mysql very much and I know that in 4.0 these techs will be implemented. But I don't know when will this new server released... Thanks in advance! Regards; Istvan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 crash on ALTER TABLE command
Hi all, I have a problem with MySQL under Windows NT/2000 where it crashes every time I issue an ALTER TABLE command while the table is being written to under high load. I've tried several versions of MySQL on a few different machines/OS and still the problem remains. I'm hoping someone might be able to tell me what I'm doing wrong. Server 1 (previous configuration): Single Pentium 2/266MHz 384MB RAM Windows NT Server 4.0 w/service pack 6 MySQL 3.23.39 Server 1 (upgraded/current configuration): Single Pentium 2/266MHz 384MB RAM Windows 2000 Server MySQL 3.23.49 Server 2: Single Pentium 3/500 MHz 256MB RAM Windows 2000 Server MySQL 3.23.49 Server 3: Single Pentium 2/233 MHz 128MB RAM Windows 2000 Server MySQL 3.23.39/3.23.49/3.23.50 (pre-release) (I've included the output from the 'show variables' command at the bottom of the email) Everything runs fine until I have to make a minor change once in a blue moon to one of the more heavily used tables. I've been able to reproduce the exact same behavior on a test database on all of the machines. The test database is defined below: mysql CREATE DATABASE stresstest; mysql USE stresstest; mysql CREATE TABLE InsertTest ( KeyField int not null auto_increment primary key, KeyValue varchar(255) ); I then run several Perl scripts that simply start inserting rows like crazy into this new table. Then from a mysql command window I issue a simple ALTER statement like below: mysql ALTER TABLE InsertTest ADD COLUMN DummyField int; The update works, however the mysql-nt service crashes with an Application Error ( The instruction at 0x77f83941 referenced memory at 0x0010. The memory could not be written) immediately after the update is complete. Under NT 4.0, a Dr. Watson error similar to that would appear instead. I've tried locking the table using LOCK TABLES InsertTest WRITE before issuing the update but it still fails. Please let me know if you need any more information. Any help would be greatly appreciated! mysql show variables; +-+- + | Variable_name | Value | +-+- + | back_log| 50 | | basedir | d:\mysql\ | | binlog_cache_size | 32768 | | character_set | latin1 | | character_sets | latin1 big5 czech euc_kr gb2312 gbk sjis tis 620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1 251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 | | concurrent_insert | ON | | connect_timeout | 5 | | datadir | d:\mysql\data\ | | delay_key_write | ON | | delayed_insert_limit| 100 | | delayed_insert_timeout | 300 | | delayed_queue_size | 1000 | | flush | OFF | | flush_time | 1800 | | have_bdb| NO | | have_gemini | NO | | have_innodb | NO | | have_isam | YES | | have_raid | NO
All records returne with JOIN
The following query takes a very long time to process. It finally returns only the row I'm wanting, but when I run an EXPLAIN SELECT on it, it looks like all 14687 rows are being examined for the record -- instead of mysql honing in on the desired row immediately. SELECT call_notes.call_elapsed, call_notes.call_seconds, call_notes.call_start, call_notes.call_end, call_notes_text.note_text, users.username, users.namefirst, users.email, facility_contact.contactid, facility_contact.contact FROM call_notes, call_notes_text, users, facility_contact WHERE call_notes.ticketid = '1' call_notes.userid = users.userid call_notes.contactid = facility_contact.contactid call_notes_text.noteid = call_notes.noteid ORDER BY call_notes.call_start DESC; (results snipped) 1 row in set (17.89 sec) A variable called $ticketid is passed to this query (and is placed where the '1' is above). The ticketid is the key I use across several tables. It is a field in call_notes and that is how I'm getting the noteid (which is the primary key of call_notes and call_notes_text). I will post details on the tables if needed. Any help or guidance appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 and Windows
-Message d'origine- De : Alexandre Zglav [mailto:[EMAIL PROTECTED]] Envoyé : lundi, 3. juin 2002 19:05 À : mysql (Elektronikus levelek) Objet : InnoDB and Windows Hello all . Nice to meet you. Maybe this thread has already been solved. If so im sorry for the disturb. Here is my problem: I want to use InnoDB transactionnal table types with mysql on Windows 2000 . I set my ini file correctly, start the console and my ibdata table is created and I can now create InnoDB tables. The problem is I cnat specify the autoincrement option for the Innodb data file . Here is what my ini looks like now : innodb_data_home_dir = C:\mysql\ibdata innodb_data_file_path =ibdata1:100M This setting works perfectly but the ibdata1 file is not autoincrementing when it is full . And here is what it should look like to have an auto extending innodb data file innodb_data_home_dir = C:\mysql\ibdata innodb_data_file_path =ibdata1:100M:autoextend:max:2000M Now if I try this last setting I get a syntax error on the innodb_data_file_path line when I try to start the Mysql-max server in console mode. I know it is supposed to work as said in the manual. Now is it a known bug on windows platform ??? Thanks . Any help apreciated . --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.365 / Virus Database: 202 - Release Date: 24.05.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
Updating stock data
I have a database containing stock data which I want to keep up to date. The relevant fields are the symbol, date, high, low, and last prices. When a new price comes in for an existing date, I want to update the high if the price is higher, the low if the price is lower, and I always want to update the last price. If a price comes in with a new date, I want to insert a new record and put the price into the high, low, and last price fields. The way I'm doing it now works, but I'm not sure it's best. Basically, I look to see whether the currect date exists by retrieving the high and low for the date. If it succeeds, I calculate whether the new price is higher than the existing high or lower than the existing low. Then I update the high, low and last price. If the date retreival fails, I do an insert. My questions are: 1) is there a way to do either an insert or an update and not have to check if a bar exists first? Should I use replace and it is just as quick? 2) Is there a way to update the highs and lows in one SQL statement without having to fetch any info from the database first? TIA. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 + cygwin
Hey everyone, Thanks for all the help / comments re cygwin. I'll definitely be giving some of them a try. Terry offered a pre-compiled binary which I am busy getting at the moment that I'll have a look at to see how nice it is. I'll also be very tempted to compile my own versions However, as funny as this sounds, where on earth is the source code for mysql (and which platform do I get for cygwin?? standard linux glibc??) All I seem to get from the mysql.com site is precompiled binaries... Maybe I should just have another look. Viliam also made some shocking (for me personally at least) claims in regards to mysql under cygwin / win32. I think it's safe to say that under cygwin / win32 mysql sockets won't operate. I don't believe win32 supports this, and all connections will have to be tcp/ip based (which suits me perfectly, seeing that the applications requiring database access, and the database itself would be on two different systems). I have no reason why most of the perl stuff would not be working however... I'll definitely look into this. Perhaps perl under cygwin requires the use of Win32::ODBC instead of DBI (it's possible I suppose). Everything perl wise I've done (mostly on ActivePerl - Win32) uses Win32::ODBC to establish database connections and transactions, while DBI is used in exactly the same manner or code for the *nix equivalent. If anyone's interested, and if I am successful in my attempts to get cygwin + win32 integrated together on the two unique platforms, I'll be more than happy to make the binaries available as a port... I don't have anywhere to host this at the moment, but I'm sure someone here will be able to organise something... Maybe I can even get to stash it under the contrib sections at mysql.com... But yeah, let's first wait and see how things turn out.. Maybe what I intend to do isn't possible in practise -- me - Original Message - From: Yegor N. Bryukhov [EMAIL PROTECTED] To: Chris Knipe [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, June 03, 2002 1:40 PM Subject: Re: MySQL + cygwin Hello Chris, I would recommend to try to compile MySQL itself under cygwin (or you already tried it?). Just use GCC version they suggest (I failed to compiled it using GCC 3.1). BTW, if you succeed, I would really appreciate if send me mysqlclient-library compiled under cygwin. CK Anyone have any ideas on how to get MySQL to work under cygwin? CK I'm especially interested in getting a libmysqlclient which is compatible CK with cygwin so that I can use it to compile various other program which CK require the library... CK Currently, I run mysql 3.23.49-max for Win32 (NT 4.0) because I do most of CK my development thereon, but lately, I've been starting to integrate various CK DB and PHP related functions into my unix like system (which is currently CK non existent). CK Because of this, the closest I can find to running both a linux equivalent CK and a Win32 platform, is cygwin But alas... No mysql for cygwin, only CK for Win32? CK And I can't use the Win32 includes or libraries to compile other related CK software via cygwin, it complains about a incompatible host type... CK snips lots of ./configure stuff CK configure: warning: /cygdrive/d/mysql/lib/opt: invalid host type CK configure: warning: /cygdrive/d/mysql/include: invalid host type CK configure: error: can only configure for one host and one target at a time CK /snip CK Any idea's or help will be appreciated... Best regards, Yegor __ Yegor Bryukhov, PhD student at GC CUNY office: 4330 office phone: +1(212)817-8653 home phone: +1(718)842-4250 e-mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: All records returne with JOIN
Michael, In Oracle, with which I am much more familiar, only primary keys are indexed automatically. Foreign keys are not indexed automatically. You have to create the indexes on the foreign key columns explicitly. My guess is that MySQL works the same way, and that this is the source of your difficulty. Guessing that call_notes.note_id, users.userid, and facility_contact.contactid are primary keys, you must still explicitly create indexes on all 4 columns on the left side of the = signs in the where clause. Omitting those indexes can cause exactly the sort of difficulty you are experiencing. I know this first-hand. Of course, I'm also assuming that all your tables are InnoDB tables. Hope this helps. --Erv Young At 12:35 PM 6/3/2002 -0400, Stembridge, Michael wrote: The following query takes a very long time to process. It finally returns only the row I'm wanting, but when I run an EXPLAIN SELECT on it, it looks like all 14687 rows are being examined for the record -- instead of mysql honing in on the desired row immediately. SELECT call_notes.call_elapsed, call_notes.call_seconds, call_notes.call_start, call_notes.call_end, call_notes_text.note_text, users.username, users.namefirst, users.email, facility_contact.contactid, facility_contact.contact FROM call_notes, call_notes_text, users, facility_contact WHERE call_notes.ticketid = '1' call_notes.userid = users.userid call_notes.contactid = facility_contact.contactid call_notes_text.noteid = call_notes.noteid ORDER BY call_notes.call_start DESC; (results snipped) 1 row in set (17.89 sec) A variable called $ticketid is passed to this query (and is placed where the '1' is above). The ticketid is the key I use across several tables. It is a field in call_notes and that is how I'm getting the noteid (which is the primary key of call_notes and call_notes_text). I will post details on the tables if needed. Any help or guidance appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Uninstalling MySQL
I have built a MySQL binary from source and have installed it with no problem. However, when I go to make uninstall, make bombs on me. Any recommended way for uninstalling a MySQL distro? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Sluggish performance on medium sized table.. EXPLAINSELECT's i ncluded.
Try changing your WHERE clause from: WHERE call_notes.ticketid = '1' call_notes.userid = users.userid call_notes.contactid = facility_contact.contactid call_notes_text.noteid = call_notes.noteid To WHERE call_notes.ticketid = '1' call_notes.userid = users.userid call_notes.contactid = facility_contact.contactid call_notes.noteid = call_notes_text.noteid Note only the last line is changed and is reversed. A database is being used to log support calls for a call center. There are around 25,000 clients in the database. The existing call notes were imported from flat text files. One table (call_notes) contains the call time, ticketid, noteid, ect.. Another table (call_notes_text) only contains noteid and note_text. When I query the call_notes table for a specific noteid, the info is returned instantly. However when I query the call_notes_text table for a specific noteid it takes 15-17 seconds to return the data. The table has around 15,000 rows with each row containing a field about the size of a small newspaper article. The server is a dual processor intel333 with 256k ram (RH7.2) running MySQL 3.23.41. Each table contains an id which is key. I've copied and pasted results from some EXPLAIN table queries below. Here is the actual query that is being used in the script. (I've broken down so it's easier to read) SELECT call_notes.call_elapsed, call_notes.call_seconds, call_notes.call_start, call_notes.call_end, call_notes_text.note_text, users.username, users.namefirst, users.email, facility_contact.contactid, facility_contact.contact FROM call_notes, call_notes_text, users, facility_contact WHERE call_notes.ticketid = '1' call_notes.userid = users.userid call_notes.contactid = facility_contact.contactid call_notes_text.noteid = call_notes.noteid ORDER BY call_notes.call_start DESC; (results snipped) 1 row in set (17.89 sec) Now I go to command line and run this query: mysql SELECT * FROM call_notes_text WHERE noteid='1'; (results snipped) 1 row in set (0.00 sec) I ran an EXPLAIN SELECT on my main query. (fyi, ticketid 1 has a noteid of 1) EXPLAIN SELECT call_notes.call_elapsed, call_notes.call_seconds, call_notes.call_start, call_notes.call_end, call_notes_text.note_text, users.username, users.namefirst, users.email, facility_contact.contactid, facility_contact.contact FROM call_notes, call_notes_text, users, facility_contact WHERE call_notes.ticketid = '1' call_notes.userid = users.userid call_notes.contactid = facility_contact.contactid call_notes_text.noteid = call_notes.noteid ORDER BY call_notes.call_start DESC; +--++-+-+-+- ---+---+-+ | table| type | possible_keys | key | key_len | ref| rows | Extra | +--++-+-+-+- ---+---+-+ | call_notes_text | ALL| PRIMARY,noteid,noteid_2 | NULL|NULL | NULL | 14682 | Using temporary; Using filesort | | call_notes | eq_ref | PRIMARY,noteid,noteid_2 | PRIMARY | 4 | call_notes_text.noteid | 1 | where used | | users| eq_ref | PRIMARY,userid | PRIMARY | 4 | call_notes.userid | 1 | | | facility_contact | eq_ref | PRIMARY,contactid | PRIMARY | 4 | call_notes.contactid | 1 | | +--++-+-+-+- ---+---+-+ 4 rows in set (0.00 sec) Note the number of rows returned from call_notes_text. This matches the total number of rows in that table. It appears to be a problem with the query, but I can't see where the problem is. Thanks for any help you can provide. - 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 -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try:
RE: Sluggish performance on medium sized table.. EXPLAIN SELECT's i ncluded.
First of all, sorry for the multiple mailings of the same message. I was receiving bounce messages, so I thought they weren't going through. On to the reply... I saw that a while ago and decided to try reversing, but I still have the same delay. Mike -Original Message- From: Brent Baisley [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 2:18 PM To: Stembridge, Michael; [EMAIL PROTECTED] Subject: Re: Sluggish performance on medium sized table.. EXPLAIN SELECT's i ncluded. Try changing your WHERE clause from: WHERE call_notes.ticketid = '1' call_notes.userid = users.userid call_notes.contactid = facility_contact.contactid call_notes_text.noteid = call_notes.noteid To WHERE call_notes.ticketid = '1' call_notes.userid = users.userid call_notes.contactid = facility_contact.contactid call_notes.noteid = call_notes_text.noteid Note only the last line is changed and is reversed. A database is being used to log support calls for a call center. There are around 25,000 clients in the database. The existing call notes were imported from flat text files. One table (call_notes) contains the call time, ticketid, noteid, ect.. Another table (call_notes_text) only contains noteid and note_text. When I query the call_notes table for a specific noteid, the info is returned instantly. However when I query the call_notes_text table for a specific noteid it takes 15-17 seconds to return the data. The table has around 15,000 rows with each row containing a field about the size of a small newspaper article. The server is a dual processor intel333 with 256k ram (RH7.2) running MySQL 3.23.41. Each table contains an id which is key. I've copied and pasted results from some EXPLAIN table queries below. Here is the actual query that is being used in the script. (I've broken down so it's easier to read) SELECT call_notes.call_elapsed, call_notes.call_seconds, call_notes.call_start, call_notes.call_end, call_notes_text.note_text, users.username, users.namefirst, users.email, facility_contact.contactid, facility_contact.contact FROM call_notes, call_notes_text, users, facility_contact WHERE call_notes.ticketid = '1' call_notes.userid = users.userid call_notes.contactid = facility_contact.contactid call_notes_text.noteid = call_notes.noteid ORDER BY call_notes.call_start DESC; (results snipped) 1 row in set (17.89 sec) Now I go to command line and run this query: mysql SELECT * FROM call_notes_text WHERE noteid='1'; (results snipped) 1 row in set (0.00 sec) I ran an EXPLAIN SELECT on my main query. (fyi, ticketid 1 has a noteid of 1) EXPLAIN SELECT call_notes.call_elapsed, call_notes.call_seconds, call_notes.call_start, call_notes.call_end, call_notes_text.note_text, users.username, users.namefirst, users.email, facility_contact.contactid, facility_contact.contact FROM call_notes, call_notes_text, users, facility_contact WHERE call_notes.ticketid = '1' call_notes.userid = users.userid call_notes.contactid = facility_contact.contactid call_notes_text.noteid = call_notes.noteid ORDER BY call_notes.call_start DESC; +--++-+--- --+-+- ---+---+-+ | table| type | possible_keys | key | key_len | ref| rows | Extra | +--++-+--- --+-+- ---+---+-+ | call_notes_text | ALL| PRIMARY,noteid,noteid_2 | NULL|NULL | NULL | 14682 | Using temporary; Using filesort | | call_notes | eq_ref | PRIMARY,noteid,noteid_2 | PRIMARY | 4 | call_notes_text.noteid | 1 | where used | | users| eq_ref | PRIMARY,userid | PRIMARY | 4 | call_notes.userid | 1 | | | facility_contact | eq_ref | PRIMARY,contactid | PRIMARY | 4 | call_notes.contactid | 1 | | +--++-+--- --+-+- ---+---+-+ 4 rows in set (0.00 sec) Note the number of rows returned from call_notes_text. This matches the total number of rows in that table. It appears to be a problem with the query, but I can't see where the problem is. Thanks for any help you can provide. - Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual)
Re: Sluggish performance on medium sized table.. EXPLAIN SELECT's i ncluded.
On 3 Jun 2002, at 11:49, Stembridge, Michael wrote: FROM call_notes, call_notes_text, users, facility_contact WHERE call_notes.ticketid = '1' call_notes.userid = users.userid call_notes.contactid = facility_contact.contactid call_notes_text.noteid = call_notes.noteid I've found that LEFT JOIN can be useful in getting MySQL to process tables in the best order. (It also can make problems with your tables more obvious, if records are missing from one of the joined tables.) Try changing that to FROM call_notes c LEFT JOIN call_notes_text ct ON c.noteid = ct.noteid LEFT JOIN users u ON c.userid = u.userid LEFT JOIN facility_contact f ON c.contactid = f.contactid WHERE c.ticketid = 1 and see how your EXPLAIN result changes. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: mysqldump -A dump.txt
You are loading all databases, but the security database (mysql) is already there. Assuming you are starting with nothing and restoring all databases that the server knows about, one method that works is to start the server with --skip-grant-tables, then load the dump file, then flush privileges. This will restore the security settings. At least, it works for me. (I have --add-drop-tables when I dump; presumably it would work to drop or delete the mysql database manually.) There's also a -o switch in the mysql client which says only update one database. I haven't succeeded in making it work. Date: Sun, 02 Jun 2002 18:49:24 -0400 To: Benjamin Pflugmann [EMAIL PROTECTED] From: Eric Frazier [EMAIL PROTECTED] Subject: Re: mysqldump -A dump.txt Hi, I didn't get that deeply into why exactly, but it seems that when I removed the mysql database from the file, that the rest went fine with mysql -u -p dumpfile I got an error about the column_prv field already existing I believe. Sorry, I should have been much more specific. I appreciate your answering even though I was vague. I think mostly I learned my lesson, and I should export one database at a time, with --tab= Thanks, Eric At 01:52 AM 6/3/02 +0200, Benjamin Pflugmann wrote: Hi. Which version of mysqldump did you use and what error message do you get? I have never used mysqldump this way but from what I read in the help of mysqldump 3.23.31, mysqldump should insert the necessary SQL statements regarding changing and creating the databases (if they do not already exist). Bye, Benjamin. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Updating stock data
On 3 Jun 2002, at 10:06, Mike G wrote: Basically, I look to see whether the currect date exists by retrieving the high and low for the date. If it succeeds, I calculate whether the new price is higher than the existing high or lower than the existing low. Then I update the high, low and last price. If the date retreival fails, I do an insert. My questions are: 1) is there a way to do either an insert or an update and not have to check if a bar exists first? Should I use replace and it is just as quick? REPLACE deletes the existing data before inserting the record, so it wouldn't work for your purpose. 2) Is there a way to update the highs and lows in one SQL statement without having to fetch any info from the database first? You could do something like UPDATE stock_prices SET high = GREATEST(high, $price), low = LEAST(low, $price), last = $price WHERE date = '$date' AND symbol = '$symbol'; but you'd still have to check to see whether the update happened and if not then do an insert. It's tricky because if the record already exists and its last price happens to be equal to the current price, then no update will occur (because there's no change and MySQL optimizes the query away), so mysql_affected_rows() won't work. One solution would be to add a last_update_time column that would always change, but it may not be worth it if you'd have no other use for it. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Get message
http://www.mysqldeveloper.com/lists/index.pcgi?readlist=mysql [EMAIL PROTECTED] wrote: Unfortunately, I don't have. I subscribed today. -- Mensagem Original -- you can't. Check the archives, this was discussed about 2 weeks ago. * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 7:13 AM To: [EMAIL PROTECTED] Subject: Get message How can I get the message when I make a query like e.g: 8 rows in set (0.01 sec) How can I get with Delphi. I use the component Zeos dbo to access Mysql Regards Alexander Curitiba/BRA A busca mais veloz e precisa da internet. Acesse agora: http://www.zoom.com.br. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php A busca mais veloz e precisa da internet. Acesse agora: http://www.zoom.com.br. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 736-5160 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Sluggish performance on medium sized table.. EXPLAIN SELECT's i ncluded.
Thank you Keith - I worked with your example and LEFT JOIN has solved the problem. Best Regards, Mike -Original Message- From: Keith C. Ivey [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 2:26 PM To: [EMAIL PROTECTED] Cc: Stembridge, Michael Subject: Re: Sluggish performance on medium sized table.. EXPLAIN SELECT's i ncluded. On 3 Jun 2002, at 11:49, Stembridge, Michael wrote: FROM call_notes, call_notes_text, users, facility_contact WHERE call_notes.ticketid = '1' call_notes.userid = users.userid call_notes.contactid = facility_contact.contactid call_notes_text.noteid = call_notes.noteid I've found that LEFT JOIN can be useful in getting MySQL to process tables in the best order. (It also can make problems with your tables more obvious, if records are missing from one of the joined tables.) Try changing that to FROM call_notes c LEFT JOIN call_notes_text ct ON c.noteid = ct.noteid LEFT JOIN users u ON c.userid = u.userid LEFT JOIN facility_contact f ON c.contactid = f.contactid WHERE c.ticketid = 1 and see how your EXPLAIN result changes. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Get message
Hi. On Mon 2002-06-03 at 10:22:35 -0300, [EMAIL PROTECTED] wrote: Unfortunately, I don't have. I subscribed today. Irrelevant. What he meant is, check the online archives (it is the recommended thing to do before posting a question at all): http://www.mysql.com/documentation/searchlists.html Bye, Benjamin. you can't. Check the archives, this was discussed about 2 weeks ago. [...] How can I get the message when I make a query like e.g: 8 rows in set (0.01 sec) How can I get with Delphi. I use the component Zeos dbo to access Mysql Regards -- [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
Newbie - How 2 ODBC/JDBC to MySQL
Hello! I just installed MySQL. Win 2000 Professional. I am logged in as none. No User Id. No Password. I wonder how. :) I could create tables, update records, query etc,. Now I would like to make ODBC connections. And eventually make JDBC connection from my \ Java code. How do I do this? How do I setup ODBC connection to this? I have just performed default installation. And I think I gave my WIn User account some kind of grant priveleges. I donot recollect bcs, it was mentioned in some web page. And I just executed while trying this and that to get into the MySQL. thanx in advance for any help suggested. -Mary __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Record dependancies
Is there a way to do this in one query (never mind the possibilities for endless loops): Say you have a table that looks like this: fieldName dependantOn joe monster bob joe briggs monster briggs vision I want to do a query so that the records are ordered as follows (based on the value of the 'dependantOn' field) briggs monster joe bob vision How can I do this in one query? I obviously cannot ORDER BY dependantOn because in the end, the dependancies wouldn't be resolved. ORDER BY fieldName is moot as it doesn't address the need. Anyone have any ideas, suggestions? Is this even possible? Or am I barking up the wrong tree and I'm going to have to figure this out via multiple queries? Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Newbie - How 2 ODBC/JDBC to MySQL
Need to go grab myodbc. Check downloads at www.mysql.com. grab the binaries unless you are brave enough to compile. :) Install (It comes with a setup) and then configure an ODBC source like normal. it works, I've done it. =C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -Original Message- From: Mary DeGallo [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 3:00 PM To: [EMAIL PROTECTED] Subject: Newbie - How 2 ODBC/JDBC to MySQL Hello! I just installed MySQL. Win 2000 Professional. I am logged in as none. No User Id. No Password. I wonder how. :) I could create tables, update records, query etc,. Now I would like to make ODBC connections. And eventually make JDBC connection from my \ Java code. How do I do this? How do I setup ODBC connection to this? I have just performed default installation. And I think I gave my WIn User account some kind of grant priveleges. I donot recollect bcs, it was mentioned in some web page. And I just executed while trying this and that to get into the MySQL. thanx in advance for any help suggested. -Mary __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 4.0 When?
Hi. As MySQL AB normally only does a stable release, when the appropriate state is reached, the only valid answer is when it's ready. A more useful answer may be http://www.mysql.com/doc/M/y/MySQL_4.0_In_A_Nutshell.html Btw, (stable) transactions are already available in the 3.23.x releases. Bye, Benjamin. On Mon 2002-06-03 at 18:28:49 +0200, [EMAIL PROTECTED] wrote: Oh, not the alpha, but the stable version, of course! Is there a roadmap for mysql 4.0? We'd like to upgrade our MySQL DB server to another one which can use some useful techniques eg. sub-selects, transaction handling, etc. I like mysql very much and I know that in 4.0 these techs will be implemented. But I don't know when will this new server released... [...] -- [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
files in /tmp
Hey guys, there are 2 files in my /tmp directory that look like mysql datafiles: #sql208_ecc_0.MYD #sql208_ecc_0.MYI They're on the same box as our development mysql instance but I don't see them on any of our other instances. Anyone have any idea what they are/if I can delete them? They're clogging up disk space... thanks, Don - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Sluggish performance on medium sized table.. EXPLAIN SELECT's i ncluded.
Hi. On Mon 2002-06-03 at 14:17:42 -0400, [EMAIL PROTECTED] wrote: Try changing your WHERE clause from: WHERE call_notes.ticketid = '1' call_notes.userid = users.userid call_notes.contactid = facility_contact.contactid call_notes_text.noteid = call_notes.noteid To WHERE call_notes.ticketid = '1' call_notes.userid = users.userid call_notes.contactid = facility_contact.contactid call_notes.noteid = call_notes_text.noteid Note only the last line is changed and is reversed. AFAIK, this should change nothing, as MySQL will change the order of the assignment as appropriate. If you have an example which proves otherwise I am very interested to see it. Bye, Benjamin. -- [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: Record dependencies
SQL for Smarties by the demigod Joe Celko. Chapters 28 and 29 describe this tree structure. READ BOTH OF THEM, even though you won't use the code in 28. Chap 29 holds the simplified concepts to make a tree structure work with single select. It's not easy. It's a complex concept but once you master it you'll find 100's of uses for it. (I use it to open pickle jars these days!) :) And this logic will work in mySQL as well? Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Sluggish performance on medium sized table.. EXPLAIN SELECT's i ncluded.
Hello. You missed to mention that using LEFT JOIN changes the meaning of the SELECT in question and it may also be a lot slower, dependend on the data. I think STRAIGHT_JOIN is more appropriate to force the tables to be read in a certain order. Bye, Benjamin. On Mon 2002-06-03 at 14:26:21 -0400, [EMAIL PROTECTED] wrote: On 3 Jun 2002, at 11:49, Stembridge, Michael wrote: FROM call_notes, call_notes_text, users, facility_contact WHERE call_notes.ticketid = '1' call_notes.userid = users.userid call_notes.contactid = facility_contact.contactid call_notes_text.noteid = call_notes.noteid I've found that LEFT JOIN can be useful in getting MySQL to process tables in the best order. (It also can make problems with your tables more obvious, if records are missing from one of the joined tables.) Try changing that to FROM call_notes c LEFT JOIN call_notes_text ct ON c.noteid = ct.noteid LEFT JOIN users u ON c.userid = u.userid LEFT JOIN facility_contact f ON c.contactid = f.contactid WHERE c.ticketid = 1 and see how your EXPLAIN result changes. [...] [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: Record dependencies
Yes, the concepts he presents are in generic SQL. I've used them in 2 different systems (menus and security) and they work fine. (NOTE: You DO have to write your own code.) ;) =C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -Original Message- From: Chris Boget [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 3:20 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Record dependencies SQL for Smarties by the demigod Joe Celko. Chapters 28 and 29 describe this tree structure. READ BOTH OF THEM, even though you won't use the code in 28. Chap 29 holds the simplified concepts to make a tree structure work with single select. It's not easy. It's a complex concept but once you master it you'll find 100's of uses for it. (I use it to open pickle jars these days!) :) And this logic will work in mySQL as well? Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: convertion probleme from string to char *
Hello, I use a little function to solve this problem in mysql++ .
char* c_string(const string s){
char* p = new char[s.length() + 1];
s.copy(p, string::npos);
p[s.length()] = 0;
return p;
}
char *temp = c_string(row[ YOUR COLUMN].c_str());
MArio H.C.T.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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++ 1.7.9 installation help
Hi, I try to install mySQL++ 1.7.9 in Linux 7.1 (gcc 2.96). I put the mySQL++ source code in /home/group2/ and type the following commands: automake autoconf ./configure --with-prefix='/home/group2/' but there is an error message: checking for MySQL library directory... configure: error: Didn't find the mysql library dir in '' Does it mean that I need to put the mysql library in the directory: /home/group2/? If this is the case, then anybody can tell me that where can I download mysql library? Thanks! _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Sluggish performance on medium sized table.. EXPLAIN SELECT's included.
On 3 Jun 2002, at 22:23, Benjamin Pflugmann wrote: You missed to mention that using LEFT JOIN changes the meaning of the SELECT in question and it may also be a lot slower, dependend on the data. I think STRAIGHT_JOIN is more appropriate to force the tables to be read in a certain order. You're right in general, and I should have qualified my answer more. I think LEFT JOIN is a good choice in cases like this where there is one main table and several associated tables that have exactly one matching record each. Using STRAIGHT_JOIN in that case would produce the same results if all your data is correct, but if you somehow had records missing from your associated tables, then you'd end up with missing records in your results, which might be less noticeable than the partial records returned with LEFT JOIN. That may or may not be worth worrying about. I don't think LEFT JOIN is slower than STRAIGHT_JOIN in that (common) circumstance, but I could be wrong. Using LEFT JOIN when possible also has the minor advantage that it's standard SQL rather than MySQL-specific. But then there's probably going to be plenty of other MySQL-specific SQL in your queries anyway. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
changing the root password
I can't remember my root password. I know that there is a way to set it by starting mysql with certain parameters, but I can't remember what those parameters are. Can you help me out? Thanks! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mySQL++ 1.7.9 installation help
Hi, If you have installed MySQL, the library it is on the right place. Gelu - Original Message - From: Shaorong Liu [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 12:01 AM Subject: mySQL++ 1.7.9 installation help Hi, I try to install mySQL++ 1.7.9 in Linux 7.1 (gcc 2.96). I put the mySQL++ source code in /home/group2/ and type the following commands: automake autoconf ./configure --with-prefix='/home/group2/' but there is an error message: checking for MySQL library directory... configure: error: Didn't find the mysql library dir in '' Does it mean that I need to put the mysql library in the directory: /home/group2/? If this is the case, then anybody can tell me that where can I download mysql library? Thanks! _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mySQL++ 1.7.9 installation help
1.You need libraries+headers from MySQL installation 2.You have to specify their locations in configure parameters (--with-mysql-lib=..., --with-mysql-include=...) As I remember one of these parameters does not recognize well on RH 7.2 (and 7.1 also I guess) I try to install mySQL++ 1.7.9 in Linux 7.1 (gcc 2.96). I put the mySQL++ source code in /home/group2/ and type the following commands: automake autoconf ./configure --with-prefix='/home/group2/' but there is an error message: checking for MySQL library directory... configure: error: Didn't find the mysql library dir in '' Does it mean that I need to put the mysql library in the directory: /home/group2/? If this is the case, then anybody can tell me that where can I download mysql library? Thanks! -- Best regards, Yegor __ Yegor Bryukhov, PhD student at GC CUNY office: 4330 office phone: +1(212)817-8653 home phone: +1(718)842-4250 e-mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to back up multiple times
Hello: A newbie here using Lasso5, MySQL on a Mac OSX I would like to back up the MySQL dbs at certain intervals during business hours. The backups should not be overwritten but kept as archives. Is there a commercial/shareware product which will automate this process as well as reconstruct the dbs in case of a crash or corruption from a previous backup? Thank you. Charles Gorenstein - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
stupid error, please kick me (and send me a solution)
Hey guys,
i'm getting this error with the following sql script using php:
--error--
Warning: Supplied argument is not a valid MySQL-Link resource in
/var/www/phpquiz/register_user.php on line 12
--error--
--script--
$link_glob = mysql_connect('$host_glob', '$un_glob', '$pw_glob');
$query = INSERT INTO user values('0', '$fname', '$lname', '$email',
'$username', PASSWORD('$password');
$result = mysql_db_query('$db_glob', '$query', $link_glob');
if (!$result) {
echo font size=+1Your Information could not be
entered into the database,
Please contact the a
href=mailto:$webmasterwebmaster/a./fontbrbr . mysql_errno() .
: . mysql_error() . brbr;
} else {
echo font size=+1Your Information has successfully
been entered into the
database!/fontbr;
--
Jule Slootbeek
[EMAIL PROTECTED]
http://blindtheory.cjb.net
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Cyber Cafe software
Does anybody know of any software all ready written or what would have to be done, to allow us to run a cyber cafe style setup. What we need the software to do is to allow someone to come in and plug in their computer to our network (actually a customers network). They want the following: 1. A customer comes in and signs up starting a clock so they could charge the customer for the time. 2. They want it to work for wired or wireless networks. So when they sign in, it would either have to set their IP address on their machine automatically, or we would have to give them an IP address to put in to their system. 3. It would have to send a report once a day to an email address (or multiple email addresses) with the days summary of time used and amount of money made. 4. A regular customer could come in and use the same login each time so that they could track everything over long periods of time, on a per customer basis. They might want to give discounts to these people and/or give away free stuff. Kind of likefor every minute someone has been on, they get one credit point. Those credit points can be used for purchasing extra time, or other products in the business. Now, if it is kept in a mysql database, than that would not be hard to pull. I know that there are cyber cafe's out there now, so I am assuming that I should not have to reinvent the wheel for this software. If not, how would somebody go about setting this up. Basically, if I could get it set up so that ALL IP addresses on the local network are not allowed in unless they sign in first, than what file would it have to put that IP address in and what would have to be restarted to allow that customer access? Preferably, I would like the program to work with RedHat Linux, PHP and MySQL. Thanks In Advance Steve Buehler - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: stupid error, please kick me (and send me a solution)
Your missing your closing } at the end of the else statement.
- Original Message -
From: Jule Slootbeek [EMAIL PROTECTED]
To: mysql [EMAIL PROTECTED]; php-general
[EMAIL PROTECTED]
Sent: Monday, June 03, 2002 5:09 PM
Subject: stupid error, please kick me (and send me a solution)
Hey guys,
i'm getting this error with the following sql script using php:
--error--
Warning: Supplied argument is not a valid MySQL-Link resource in
/var/www/phpquiz/register_user.php on line 12
--error--
--script--
$link_glob = mysql_connect('$host_glob', '$un_glob', '$pw_glob');
$query = INSERT INTO user values('0', '$fname', '$lname', '$email',
'$username', PASSWORD('$password');
$result = mysql_db_query('$db_glob', '$query', $link_glob');
if (!$result) {
echo font size=+1Your Information could not be entered into the
database,
Please contact the a
href=mailto:$webmasterwebmaster/a./fontbrbr . mysql_errno() .
: . mysql_error() . brbr;
} else {
echo font size=+1Your Information has successfully been entered into
the
database!/fontbr;
--
Jule Slootbeek
[EMAIL PROTECTED]
http://blindtheory.cjb.net
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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: stupid error, please kick me (and send me a solution)
It would also appear you are missing a closing ) at the end of the
'$query=...' line. You have two opening backets and only one closing.
Greg
-Original Message-
From: Bruce Lewis [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 4 June 2002 7:50
To: [EMAIL PROTECTED]; mysql; php-general
Subject: Re: stupid error, please kick me (and send me a solution)
Your missing your closing } at the end of the else statement.
- Original Message -
From: Jule Slootbeek [EMAIL PROTECTED]
To: mysql [EMAIL PROTECTED]; php-general
[EMAIL PROTECTED]
Sent: Monday, June 03, 2002 5:09 PM
Subject: stupid error, please kick me (and send me a solution)
Hey guys,
i'm getting this error with the following sql script using php:
--error--
Warning: Supplied argument is not a valid MySQL-Link resource in
/var/www/phpquiz/register_user.php on line 12
--error--
--script--
$link_glob = mysql_connect('$host_glob', '$un_glob', '$pw_glob');
$query = INSERT INTO user values('0', '$fname', '$lname', '$email',
'$username', PASSWORD('$password');
$result = mysql_db_query('$db_glob', '$query', $link_glob');
if (!$result) {
echo font size=+1Your Information could not be entered into the
database,
Please contact the a
href=mailto:$webmasterwebmaster/a./fontbrbr . mysql_errno() .
: . mysql_error() . brbr;
} else {
echo font size=+1Your Information has successfully been entered into
the
database!/fontbr;
--
Jule Slootbeek
[EMAIL PROTECTED]
http://blindtheory.cjb.net
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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
