RPM Install appears to have failed
RedHat6.2 install (everything) out of box on Intel 1 proc server 256mb ram. Downloaded 3.23.52-1 rpm client rpm to /usr/loca/tmp - i created the tmp folder as root and chmod 777 Followed the install instructions - which only included: To perform a standard minimal installation, run: shell rpm -i MySQL-VERSION.i386.rpm MySQL-client-VERSION.i386.rpm (No user or group or environment setup instructions before running rpm's???) So logged in as root I executed the following, and got the result below [root@plinux tmp]# rpm -i MySQL-Max-3.23.52-1.i386.rpm MySQL-client-3.23.52-1.i386.rpm Giving mysqld a couple of seconds to restart var/tmp/rpm-tmp.10346: /etc/rc.d/init.d/mysql: No such file or directory Was this successful? Where did mysql install to? The post installation steps say to: shell ./scripts/mysql_install_db shell cd mysql_installation_directory shell ./bin/safe_mysqld --user=mysql cd_mysql_installation_directory - where the heck did it install at? don't think this happened... thanks in advance. Chris Becker MCDBA MCSE http://www.PrismSoftware.com [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: Fw: Rename Database
William, Tuesday, October 02, 2001, 11:18:48 AM, you wrote: I am curious how to rename a database in MySQL 4.0 running on win2k server. If your database contains only ISAM/MyISAM tables you can do it like - shutdown MySQL server - rename database dir - restart MySQL server -- 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: SubSelect Query
vinita, Thursday, October 03, 2002, 5:56:49 AM, you wrote: vvM mysql select userGroup from machineGroup_userGroups where hostname=mulga; vvM +---+ vvM | userGroup | vvM +---+ vvM | staff | vvM | tech | vvM +---+ vvM 2 rows in set (0.01 sec) vvM mysql select username from account where loginGroup=staff OR vvM loginGroup=tech; vvM +--+ vvM | username | vvM +--+ vvM | aharwood | vvM | alistair | vvM ... works fine vvM BUT vvM mysql select username from account where loginGroup IN vvM - (select userGroup from machineGroup_userGroups where vvM hostname=mulga) ; vvM ERROR 1064: You have an error in your SQL syntax near 'select userGroup vvM from machineGroup_userGroups where hostname' at line 2 vvM Both loginGroup userGroup are VAR(20) vvM Any idea what is wrong?? Sub-selects isn't implemented in MySQL yet: http://www.mysql.com/doc/en/ANSI_diff_Sub-selects.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
PB to retrieve ID
Hi, I'm writing a c++ program using MySQL++. I insert in a table a new line. This table has an autoincrement field call ID. Immediatly after storing a new line in the table, I execute (in the program) a SELECT * FROM table command to retrieve the new ID just affected to the new line, but I always got 0 for it. What's wrong ? Should I put a commit command i the code ? Thanks -- Cordialement ~~ Emmanuel POIZOT CNAM/INTECHMER B.P. 324 50103 CHERBOURG Cedex Tél : (33)(0)2 33 88 73 42 Fax : (33)(0)2 33 88 73 39 ~~ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 v4.0.4 support Unicode ?
Khanh, Thursday, October 03, 2002, 6:46:05 AM, you wrote: KP Does new MYSQL v4.0.4 support Unicode ? KP I know that version 4.0 can store Unicode, but it cannot order, unless KP we have to write extra codes for it. Unless I am wrong ! Nope, MySQL 4.0.X doesn't support unicode. It will come only in 4.1. -- 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: can't connect to remote host
luoya, Thursday, October 03, 2002, 9:01:22 AM, you wrote: ll I just install mysql 3.23.52-max-nt on two computers. One is Win2K and ll another is winXP. It seems all right. I use the following commands on ll both. ll C:\mysql\binmysql ¨Chlocalhost ¨Curoot ¨Cp ll Mysql prompt: ll Welcome to the MySQL monitor. Commands end with ; or \g. ll Your MySQL connection id is 9 to server version: 3.23.52-max-nt ll Type 'help;' or '\h' for help. Type '\c' to clear the buffer. ll But when I use following commands to connect remotely from winXP to win2K. ll C:\mysql\binmysql ¨Ch202.112.224.1 ¨Curoot ¨Cp ll (202.112.202.1 is IP of Win2K.) ll Mysql prompt: ll ERROR 2003: Can't connect to MySQL server on '202.112.224.1' (10060) ll Win2K and winXP all be connected to internet. Is MySQL server running on the remote host, too? Check also that you didn't run remote MySQL server with --skip-networking option. -- 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
lotus decs problem with myodbc
Hello I'm trying to connect a Lotus Server through DECS, to a MySQL db. The Lotus and the MySQL servers are installed on the same linux machine. I installed iodbc, myodbc, successfully tested them with odbctest from Linux, and with ndctest (or smth like that) from a Windows system. Anyway, I'm trying to configure the Decs server from a Windows client, with Notes Administrator, but without any luck. The standard error message when I'm trying to select the tables is: Unable to browse ODBC Oh yea, I also installed the myodbc driver on the Windows system I'm running the NotesAdmin from. Any ideas? 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
CONFIG_SMP redefine warnings while compiling...
Just wanted to drop a patch on subject if it hasnt been fixed yet. Cheers --- mysql-3.23.52/include/global.h-orig Wed Aug 14 00:08:16 2002 +++ mysql-3.23.52/include/global.h Thu Oct 3 09:22:49 2002 @@ -201,8 +201,11 @@ #include alloca.h #endif #ifdef HAVE_ATOMIC_ADD +#include linux/config.h #define __SMP__ +#ifndef CONFIG_SMP #define CONFIG_SMP +#endif #include asm/atomic.h #endif --- mysql-3.23.52/include/my_global.h-orig Thu Oct 3 09:23:08 2002 +++ mysql-3.23.52/include/my_global.h Thu Oct 3 09:23:32 2002 @@ -201,8 +201,11 @@ #include alloca.h #endif #ifdef HAVE_ATOMIC_ADD +#include linux/config.h #define __SMP__ +#ifndef CONFIG_SMP #define CONFIG_SMP +#endif #include asm/atomic.h #endif -- Jerry Lundström | System Developer/Administrator | Tiscali AB Ringvägen 100 C | S - 104 60 Stockholm | P: +46-8-691 47 00 mailto:[EMAIL PROTECTED] | www.tiscali.se - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PB to retrieve ID
Hi, You should use LAST_INSERT_ID() function, check the manual for details: http://www.mysql.com/doc/en/Getting_unique_ID.html Regards Joseph Bueno Poizot Emmanuel wrote: Hi, I'm writing a c++ program using MySQL++. I insert in a table a new line. This table has an autoincrement field call ID. Immediatly after storing a new line in the table, I execute (in the program) a SELECT * FROM table command to retrieve the new ID just affected to the new line, but I always got 0 for it. What's wrong ? Should I put a commit command i the code ? 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/InnoDB-4.0.4 is released
Puiu, - Original Message - From: Puiu Hrenciuc [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED]; Philip Molter [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 1:46 AM Subject: Re: MySQL/InnoDB-4.0.4 is released I hoped that you will solve the MySQL consuming all computer's resources in 4.0.4, but nope, the problem is still there. I'm trying to run MySQL on Win ME and when started normally it consumes all resources of my computer. When I start it with --skip-innodb it works just fine. Why ? we need more information of the bug. If you start from an MS-DOS prompt, what does mysqld-max.exe print? C:\mysql\bin mysqld-max --console If mysqld-max starts up, you should enable the general query log with mysqld-max --log --console and look at hostname.log in the datadir to determine if you have some daemon process running on the computer which constantly issues queries to the server. Do you have Microsoft Visual C++, so that you could compile yourself and run mysqld-max in the debugger to determine what it does? At least I saw you fixed WinMySQLAdmin. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: Philip Molter [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, October 02, 2002 5:48 PM Subject: Re: MySQL/InnoDB-4.0.4 is released Philip, - Original Message - From: Philip Molter [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, October 02, 2002 4:16 PM Subject: Re: MySQL/InnoDB-4.0.4 is released On Wed, Oct 02, 2002 at 02:12:23PM +0300, Heikki Tuuri wrote: : Hi! : : InnoDB is a table type which provides transactions, row level locking, : foreign key constraints, and a non-free hot backup tool to MySQL. : : InnoDB is included in both downloadable versions of MySQL-4.0: MySQL-Pro and : MySQL-Max. : : Release 4.0.4-beta is mainly a bug fix release. Will the bugfixes for this release (not necessarily the new/updated features) be backported to the 3.23.x series? Given that MySQL 4 isn't marked as stable yet, many of us using InnoDB no doubt still use 3.23.x. of course, the fix will be backported if the bug also existed in 3.23. The DESC bugs in 4.0.x are not present in 3.23. Since 4.0.x releases will come in more rapid succession than 3.23 releases, it may soon be that the most bug-free InnoDB is actually in the latest 4.0.x. * Philip Molter * Texas.net Internet * http://www.texas.net/ * [EMAIL PROTECTED] Regards, Heikki Innobase Oy sql query - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: excel to mysql
to load files into mysql: create a table: create table newtable (column1 int(10),column2 varchar(250)); import the data: load data infile '/path/to/file/file.csv' into table newtable fields terminated by ',' lines terminated by '\n' Alia Mikati wrote: Hello everybody I hope u can help me with this. I want to export tables from excel to mysql and i saved the file as .csv then clicked on browse to get Location of the textfile. But it doesnt work. I get for expl: SQL-query : 3,Technical 4,Technical 7,Technical 15,Technical 20,Technical 26,Technical 32,Technical MySQL said: You have an error in your SQL syntax near '3,Technical 4,Technical 7,Technical 15,Technical 20,Techn' at line 1 Plz how can I do it? Thx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Richard Dobson Database Administrator MRC Bright Study Clinical Pharmacolgy St Bartholomew's and the Royal London School of Medicine and Dentistry Charterhouse Square London EC1M 6BQ Tel: 020-7882-5670 Mob: 07711-522926 Fax: 020-7882-5672 [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: Starting Mysql on RedHat 7.2.
Damien, Thursday, October 03, 2002, 4:25:56 AM, you wrote: DB Hi, I have just started out using MySQL and have had no end of trouble DB getting it started. I am running Redhat 7.2 and MySQL 3.23. I found that I DB had to modify my.cnf to point to the path /var/lib/mysql/mysql instead of DB just /var/lib/mysql. It still does not start however. The log file shows DB that the table 'mysql.host' does not exist. I have searched the system for DB this file but it does not exist anywhere. Therefore it cannot be another DB path issue. It seems that the install may note have created it. I installed DB it using RPM at the shell. If you installed MySQL server from rpm by default datadir is /var/lib/mysql not the /var/lib/mysql/mysql. That is why MySQL server can't find mysql.host. -- 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: Win32 static binary of MySQLGUI 1.7.5-2
Norman, Wednesday, October 02, 2002, 5:25:36 PM, you wrote: NWJ Downloaded Win32 static binary of MySQLGUI 1.7.5-2 , but it would not NWJ unzip. NWJ Error message Cannot open file: it does not appear to be a valid NWJ archive. If you downloaded this file, try downloading the file again. NWJ I tried and the same thing happened. Try to download it from another mirror. -- 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: Compilation options of rpm packages
Hello Iago, Tuesday, October 1, 2002, 11:54:44 AM, you wrote: IS Any of MySQL AB team could explain the options used in the compilation of IS rpm packages for Linux? IS Thanks in advance. You can download the corresponding src.rpm and see. IS Iago. -- 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: RH8.0 MySQL source install problems
Joseph, Thursday, October 03, 2002, 3:47:21 AM, you wrote: JS Just built a fresh RedHat 8.0 Server and tried to install the latest JS MySQL from source. [skip] JS Here is the error JS /usr/local/mysq/usr/local/mysql/bin/safe_mysqld: line 273: 24640 JS Segmentation fault $NOHUP_NICENESS$ledir/$MYSQLD $defaults JS --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid- JS file=$pid_file --skip-locking$err_log 21 JS Number of processes running now: 1 JS [root@dev mysql]# /usr/local/mysqlmysqld process hanging, pid 24643 - JS killed JS 021002 17:35:33 mysqld restarted JS MySQL will restart and be accessable for about 15 - 30 seconds and then JS the error repeats. I suggest you to install MySQL official binaries, downloadable from http://www.mysql.com/ as compiling MySQL is tricky and almost impossible in a clean Red Hat environment. -- 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: Select maximum of concurrently present visitors
* [EMAIL PROTECTED] Hi, I woud like to ask for help with sql select. I have table - visitor, arrival, departure. (Time is in timestamp in sec. from 1970) I need select top of concurrently present visitors, between 00.00 and 29.59. So my boss want know when was shop most full and how many wisitors was there. May be other thing which would by nice is select top of concurrently present visitors every 5 minutes like format 00.05 4, 00.10 5, 00.15 8 ,00.20 6 ... 23.55 7. Thanks for any idea Beld Maybe something like this...: use test; create table visit (id int primary key not null,arrival int,departure int); insert into visit values (1,1,3),(2,2,4),(3,2,5),(4,2,3),(5,3,6), (6,3,4),(7,3,4),(8,4,5),(9,5,6); create temporary table times (id int primary key not null); insert into times values (1),(2),(3),(4),(5),(6); select times.id,count(*) as cnt from times,visit where times.id between visit.arrival and visit.departure group by times.id; In the 'times' table, you would put the timestamps you want as checkpoints, 00:05, 00:10, 00:15 and so on for the appropriate date. Add ORDER BY to get the most busy times first: ... order by cnt desc; -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
OT but related: DNS using SQL databases
Hi, I have heard of some Linux based DNS services that use MySQL as the bases for zone files. Is there anyone who could point me in the right direction or has experience in using these tools. The is my understanding that queries can be created that allow much easier maintanence of the DNS system. Thanks. -David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: OT but related: DNS using SQL databases
David Durham wrote: Hi, I have heard of some Linux based DNS services that use MySQL as the bases for zone files. Is there anyone who could point me in the right direction or has experience in using these tools. The is my understanding that queries can be created that allow much easier maintanence of the DNS system. Thanks. -David Hi, A quick search on Google gave me a pointer to MyDNS: http://mydns.bboy.net/ Hope this helps Joseph Bueno - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL/InnoDB-4.0.4 is released
Hi, You have right, in the new version (4.0.4) on Windows 9x are the same symptom. I research a little in this morning and i found where is the problem when the innodb is initialised. The problems is in the function: sync_array_create() ...when it must initialise a lot of cells(n_cells=aprox. 6.000.000). The routine is next : for (i = 0; i n_cells; i++) { cell = sync_array_get_nth_cell(arr, i); cell-wait_object = NULL; /* Create an operating system event semaphore with no name */ cell-event = os_event_create(NULL); cell-event_set = FALSE; /* it is created in reset state */ } The configuration of my computer for testing is: CPU : INTEL P IV/1,7 Ghz RAM: 512 MB DDRAM HDD: 2x40 GB(IDE) OS:Windows 98 OSR2 Maybe this help on Heikki to see what happend. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Puiu Hrenciuc [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED]; Philip Molter [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 12:46 AM Subject: Re: MySQL/InnoDB-4.0.4 is released I hoped that you will solve the MySQL consuming all computer's resources in 4.0.4, but nope, the problem is still there. I'm trying to run MySQL on Win ME and when started normally it consumes all resources of my computer. When I start it with --skip-innodb it works just fine. Why ? At least I saw you fixed WinMySQLAdmin. - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: Philip Molter [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, October 02, 2002 5:48 PM Subject: Re: MySQL/InnoDB-4.0.4 is released Philip, - Original Message - From: Philip Molter [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, October 02, 2002 4:16 PM Subject: Re: MySQL/InnoDB-4.0.4 is released On Wed, Oct 02, 2002 at 02:12:23PM +0300, Heikki Tuuri wrote: : Hi! : : InnoDB is a table type which provides transactions, row level locking, : foreign key constraints, and a non-free hot backup tool to MySQL. : : InnoDB is included in both downloadable versions of MySQL-4.0: MySQL-Pro and : MySQL-Max. : : Release 4.0.4-beta is mainly a bug fix release. Will the bugfixes for this release (not necessarily the new/updated features) be backported to the 3.23.x series? Given that MySQL 4 isn't marked as stable yet, many of us using InnoDB no doubt still use 3.23.x. of course, the fix will be backported if the bug also existed in 3.23. The DESC bugs in 4.0.x are not present in 3.23. Since 4.0.x releases will come in more rapid succession than 3.23 releases, it may soon be that the most bug-free InnoDB is actually in the latest 4.0.x. * Philip Molter * Texas.net Internet * http://www.texas.net/ * [EMAIL PROTECTED] Regards, Heikki Innobase Oy sql query - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: [Q] Replication temporary tables (fwd)
Andrey, Tuesday, October 01, 2002, 11:53:41 AM, you wrote: AK Why is temporary tables replecated? AK Is it true? Yes, temporary table are replicated properly since 3.23.29: http://www.mysql.com/doc/en/Replication_Features.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: pro vs max
Keith C. Ivey wrote: MySQL AB appears to be in the midst of changing the names for the various versions, and the information on the various pages doesn't seem to be consistent yet. I had replied to the original as well (and it got spam filtered for not containing SQL!), but I'll say it again: the downloads page has a relatively succinct description of what each product is. It may not mention the product name you're looking for, but ChangeLogs and the llike are usually the best place to find those things. What _is_ available is well described, IMHO: * MySQL 3.23 -- Stable release (recommended) latest version is 3.23.52 o *3.23 http://www.mysql.com/downloads/mysql-3.23.html* -- Default package (use this if you are unsure) o *3.23 Max http://www.mysql.com/downloads/mysql-max-3.23.html* -- Package with maximum features * MySQL 4.0 -- Beta release (use this for new development) latest version is 4.0.3 o *4.0 Pro http://www.mysql.com/downloads/mysql-pro-4.0.html* -- Default package with all the features necessary for typical usage, including the InnoDB transactional table handler (use this if you are unsure) o *4.0 Max http://www.mysql.com/downloads/mysql-max-4.0.html* -- Package with maximum features (SSL, RAID, BDB) -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: OT but related: DNS using SQL databases
FYI..I use MyDNS here, and i really like it. has a nice little contribed PHP interface included in it too. be aware, it's only an authoritative name server, if you want to do recursive/cache, you need something like djbdns dnscache along side it. -Tony - System Administrator Net Infrastructure - -Original Message- From: Joseph Bueno [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 5:37 AM To: David Durham Cc: [EMAIL PROTECTED] Subject: Re: OT but related: DNS using SQL databases David Durham wrote: Hi, I have heard of some Linux based DNS services that use MySQL as the bases for zone files. Is there anyone who could point me in the right direction or has experience in using these tools. The is my understanding that queries can be created that allow much easier maintanence of the DNS system. Thanks. -David Hi, A quick search on Google gave me a pointer to MyDNS: http://mydns.bboy.net/ Hope this helps Joseph Bueno - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Examples and Documents on joining tables?
Is there a document that compiles examples on different ways of joining two or more tables? I found a few on http://www.mysql.com/doc/en/JOIN.html but they do not cover joining more than two tables. Thanks for any suggestions. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Need Driver to connect Unix SCO 5.2 Open Server to MySQL DB?
You keep bringing up ODBC like it is some magic charm. Why do you think you need ODBC? Does your client software require it? You have not told us what the client is, or what it is written in. The 'mysql' client on any platform talks natively to the 'mysqld' server on any platform. PHP does not need ODBC. Perl does not need ODBC. VB can use libraries other than ODBC. Chris Couture wrote: Thanks again for the help! I tried this on my local machine and it worked like a champ. Here is the question that my unix software programmer has: I believe the client end would be a unix ODBC, which mysql has an SCO version, but it says you need iODBC (or uODBC - I can't remember which), but they don't have a compiled version for SCO. So we would need the gcc compiler and then compile it. That throws a whole other wrench into it as I don't want to be responsible in trying to figure why it won't compile - if there is a problem. The easiest thing might be to install a full version of MySQL on the SCO machine. That should include the client. So then we could write to the other server (or the SCO server if for some reason we need to). The neato advantage to this is for new software. The software I am currently writing is Windows client with SQL Server 2000. I could change it so it uses MySQL and then the data server could continue to be the SCO machine for security purposes. Pose the question to the list that: If I load a full version of MySQL on SCO OpenServer 5.2, does that include a client so I could write to both a linux machine running MySQL or the SCO machine just by changing the INSERT statement? You can't change an INSERT statement to write to two machines. If so, that would be the easiest since MySQL has a compiled binary for SCO (I looked at 3.2 - last stable version - I didn't check the 4.03 max. So this brings up this question from me: I am using MySQL version 4.0.3max right now so lets say that we installed version 3.2 on the UNIX machine, could the older client talk to the 4.0* versions of the MySQL server or should we try to keep them the same? It will be only for simple insert statements and maybe simple selects in the future. Thanks again for the help. Chris -Original Message- From: gerald_clark [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 9:12 AM To: Chris Couture Cc: [EMAIL PROTECTED] Subject: Re: Need Driver to connect Unix SCO 5.2 Open Server to MySQL DB? Chris Couture wrote: Thanks for the info. Let me see if I have this right. (I am asking these question on behalf of my UNIX programmer who will be doing all of the programming so sorry if I am asking simple questions.) To make this simple, let's label the computers. The MySQL database server will be labeled B and the UNIX machine doing the inserts will be A This is what I understand so far. I install the client on A and it can then talk to the mysqld server on B? How do I need to go about telling A where the mysql server is located? Is this something I can set up in a ini file or does it need to be in the scripts that are ran to do the inserts (like a php or asp script does). My UNIX guy asked me to ask about an ODBC connector. Will MyODBC work on Unix? mysql -h hostname -u username -p databasename will connect the mysql client to the derver on hostname. In PHP and perl, there are connection routines that will include the hostname. Use ODBC only if there is no other connection method available. Tell your UNIX guy to check out mysql.com. Thanks so much for the help! Chris You are welcome. -Original Message- From: gerald_clark [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 3:16 PM To: Chris Couture Cc: [EMAIL PROTECTED] Subject: Re: Need Driver to connect Unix SCO 5.2 Open Server to MySQL DB? You need the client 'mysql' on the unix machine to talk to the server 'mysqld' on whatever machine. This will allow you to write shell scripts that call mysql. If you want to program in PHP or perl, then you need their mysql drivers which talk to the server. Chris Couture wrote: Hi, I'm a MySQL Newbie and am working on my first real project. The project involves removing the Access database off of our system and using MySQL in its place. Here is what happens now with this database The Unix machine writes information to the end of a text file every time an invoice is processed. This text file is FTP'd every 10 minutes over to our server. Access starts up and querys all the data and puts it into the proper tables. (Currently there are 15,000+ records and this has only been running for 6 months so you can see the need to rethink this process.) This process allows our shipping computers, using OBDC to connect to the access database where they can pull the information into the fields (name, address, service type etc) Anyway,
gemini/acid or innodb ?
Hello, I found an other table type for transaction : The simplicity of ACID transactions is especially important in a distributed database environment where the transactions are being made simultaneously. Learn more about the Gemini table type that supports ACID Transactions. Find in nusphere site. Is gemini better than innodb ? How can i get gemini table type ? Is gemini a solution of nusphere (corp.) and Innodb a solution of mysql (corp.) ? How beeing objective ? Thanks. ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.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
OT: Reply-Adress in this list
I use some mail-lists for mysql, php and security with Outlook Express. When I reply, some lists set their list-adress automatically, some the adress of the person originally posting. The second version may not so good IMHO, because I think so many replies are not going to the lists. mysql++ and mysql do not automatically reply to the list mysql-de does. I think the a big Problem with the first solution are some autoresponders which may spamming mainling lists. I'm not a freak in mailservers, but maybe others know if there's a better configuration. Maybe I can configure my Outlook Express better? -- [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 and ODBC prolbme
I have mysql on a linux box (IP 192.168.0.1), and I've got a windows 2000 box that I am trying to connect to with with odbc. I am getting the following error message [MySQL AB][MyODBC] ERROR : Can't connect to MySQL server on 192.168.0.1 (10061) I'm not sure how to go about correcting this problem Jeff Bluemel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
OT: Re: Using Install shield, how to do ODBC DSN setting ?
Best to check out InstallShield's product forums at http://community.installshield.com. Their users and support staff troll it and assist persons in need. Kelly SQL,MySQL At 11:52 AM 10/2/2002 +0800, Alice Tan wrote: Hi, i am doing a project and it is almost nearing release version. i planned to do the installation by using install shield to one short doing the mysql, myodbc installation and also the ODBC DSN setting. is anyone have any idea to do the ODBC DSN setting through install shield ? or writing any programs/script to make it work ? hope can get reply ASAP. thanx regards, alice /---\ Confidential and/ or privileged information may be contained in this e-mail and any attachments transmitted with it ('Message'). If you are not the addressee indicated in this Message (or responsible for delivery of this Message to such person),you are hereby notified that any dissemination, distribution, printing or copying of this Message or any part thereof is prohibited. Please delete this Message if received in error and advise the sender by return e-mail. Opinions, conclusions and other information in this Message that do not relate to the official business of this company shall be understood as neither given nor endorsed by this company. This mail is certified Virus Free by *ProtectNow! (InternetNow Sdn Bhd) *Scanner Engine powered by Norman Virus Control \--/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Kelly Firkins Database Developer Siebel configuration and administration PHP, MySQL and Linux work @ IS - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: OT: Reply-Adress in this list
In the last episode (Oct 03), Franz Alt said: I use some mail-lists for mysql, php and security with Outlook Express. When I reply, some lists set their list-adress automatically, some the adress of the person originally posting. The second version may not so good IMHO, because I think so many replies are not going to the lists. mysql++ and mysql do not automatically reply to the list mysql-de does. I think the a big Problem with the first solution are some autoresponders which may spamming mainling lists. I'm not a freak in mailservers, but maybe others know if there's a better configuration. Maybe I can configure my Outlook Express better? Use the reply-to-all or List-reply button, whichever Outlook has. -- Dan Nelson [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Need Driver to connect Unix SCO 5.2 Open Server to MySQL DB?
This is what I thought. Thanks. I think we are almost there! Chris -Original Message- From: gerald_clark [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 8:51 AM To: Chris Couture Cc: [EMAIL PROTECTED] Subject: Re: Need Driver to connect Unix SCO 5.2 Open Server to MySQL DB? You keep bringing up ODBC like it is some magic charm. Why do you think you need ODBC? Does your client software require it? You have not told us what the client is, or what it is written in. The 'mysql' client on any platform talks natively to the 'mysqld' server on any platform. PHP does not need ODBC. Perl does not need ODBC. VB can use libraries other than ODBC. Chris Couture wrote: Thanks again for the help! I tried this on my local machine and it worked like a champ. Here is the question that my unix software programmer has: I believe the client end would be a unix ODBC, which mysql has an SCO version, but it says you need iODBC (or uODBC - I can't remember which), but they don't have a compiled version for SCO. So we would need the gcc compiler and then compile it. That throws a whole other wrench into it as I don't want to be responsible in trying to figure why it won't compile - if there is a problem. The easiest thing might be to install a full version of MySQL on the SCO machine. That should include the client. So then we could write to the other server (or the SCO server if for some reason we need to). The neato advantage to this is for new software. The software I am currently writing is Windows client with SQL Server 2000. I could change it so it uses MySQL and then the data server could continue to be the SCO machine for security purposes. Pose the question to the list that: If I load a full version of MySQL on SCO OpenServer 5.2, does that include a client so I could write to both a linux machine running MySQL or the SCO machine just by changing the INSERT statement? You can't change an INSERT statement to write to two machines. If so, that would be the easiest since MySQL has a compiled binary for SCO (I looked at 3.2 - last stable version - I didn't check the 4.03 max. So this brings up this question from me: I am using MySQL version 4.0.3max right now so lets say that we installed version 3.2 on the UNIX machine, could the older client talk to the 4.0* versions of the MySQL server or should we try to keep them the same? It will be only for simple insert statements and maybe simple selects in the future. Thanks again for the help. Chris -Original Message- From: gerald_clark [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 9:12 AM To: Chris Couture Cc: [EMAIL PROTECTED] Subject: Re: Need Driver to connect Unix SCO 5.2 Open Server to MySQL DB? Chris Couture wrote: Thanks for the info. Let me see if I have this right. (I am asking these question on behalf of my UNIX programmer who will be doing all of the programming so sorry if I am asking simple questions.) To make this simple, let's label the computers. The MySQL database server will be labeled B and the UNIX machine doing the inserts will be A This is what I understand so far. I install the client on A and it can then talk to the mysqld server on B? How do I need to go about telling A where the mysql server is located? Is this something I can set up in a ini file or does it need to be in the scripts that are ran to do the inserts (like a php or asp script does). My UNIX guy asked me to ask about an ODBC connector. Will MyODBC work on Unix? mysql -h hostname -u username -p databasename will connect the mysql client to the derver on hostname. In PHP and perl, there are connection routines that will include the hostname. Use ODBC only if there is no other connection method available. Tell your UNIX guy to check out mysql.com. Thanks so much for the help! Chris You are welcome. -Original Message- From: gerald_clark [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 3:16 PM To: Chris Couture Cc: [EMAIL PROTECTED] Subject: Re: Need Driver to connect Unix SCO 5.2 Open Server to MySQL DB? You need the client 'mysql' on the unix machine to talk to the server 'mysqld' on whatever machine. This will allow you to write shell scripts that call mysql. If you want to program in PHP or perl, then you need their mysql drivers which talk to the server. Chris Couture wrote: Hi, I'm a MySQL Newbie and am working on my first real project. The project involves removing the Access database off of our system and using MySQL in its place. Here is what happens now with this database The Unix machine writes information to the end of a text file every time an invoice is processed. This text file is FTP'd every 10 minutes over to our server. Access starts up and querys all the data and puts it into the proper tables. (Currently there are 15,000+ records
Re: Reply-to munging
Franz Alt wrote: When I reply, some lists set their list-adress automatically, some the adress of the person originally posting. The second version may not so good IMHO, because I think so many replies are not going to the lists. mysql++ and mysql do not automatically reply to the list mysql-de does. http://www.google.ca/search?q=reply-to+mungingie=UTF-8oe=UTF-8hl=enbtnG=Google+Searchmeta= From one site: Reply-To munging does not benefit the user with a reasonable mailer. People want to munge Reply-To headers to make ``reply back to the list'' easy. But it already is easy. Reasonable mail programs have two separate ``reply'' commands: one that replies directly to the author of a message, and another that replies to the author plus all of the list recipients. Even the lowlyBerkeleyMail http://www.bsdi.com/bsdi-man/?Mail%281%29 command has had this for about a decade. Also: It, in fact, /decreases/functionality. Reply-To munging destroys the ``reply-to-author'' capability. Munging makes this command act effectively the same as the ``reply-to-group'' function. We haven't added anything new, we've only taken away. Reply-To munging is not merely benign, it is harmful. It renders a useful mail capability inoperative. PS, this has nothing to do with SQL or QUERIES ... :) -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Need Driver to connect Unix SCO 5.2 Open Server to MySQL DB?
Dean, Thanks for you reply. You are almost correct in our system layout but the MySQL database server is on a seperate machine (currently running Windows 2000 AS with all the databases on a separate drive and soon to be updated to Linux). The inserts would need to take place over the network to the MySQL server, which from what Gerald has helped me with, seems like we only need to put the hostname in when we call the MySQL server verses having it insert locally. This still leaves one real question and that is, which client do I need to use on the SCO 5.2 machine? If we install the older 3.2 (already compiled) version of MySQL on the UNIX machine, can it talk to the newer 4.** server located on the other machine. It's going to complete a simple insert statement. If not, I guess we will need to compile our own. As far as the programming language that the UNIX is using, I will have to talk to my UNIX programmer. The Windows machines used for processing the shipments work just right using the MyODBC connection. I have converted our old Access databases over to MySQL and everything works like a dream there. It's just a matter of getting the UNIX machine that processes all of our orders to dump the data to the MySQL database instead of inserting it into the text file so that everything is tied together. Thanks again, Chris -Original Message- From: Grimes, Dean [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 8:01 AM To: Chris Couture Subject: RE: Need Driver to connect Unix SCO 5.2 Open Server to MySQL DB? Chris, If I understood you correctly, you have a Unix server that creates text string when an invoice is processed. That string of data is to be inserted into the MySQL database. Then you have a Windows application that needs to be able to retrieve that data from the MySQL database that resides on the Unix server. If that is stated correctly, then I am assuming that MySQL and the invoice processor are running on the same Unix server. If that is the case, it should be easy enough for your programmer to insert that data directly into MySQL. There are a couple of different methods that will work. 1. You could write a shell script that your invoice processor would call each time a record needs to be inserted. The data would be passed as parameters to the shell script. The shell script would use the MySQL client to perform the insert. There is some overhead associated with this method but you are only inserting about 2500 records a month. Which translates to only 84 inserts a day. This is very low traffic and your system should handle it no problem. Example script: #!/bin/ksh # Insert into mysql database mysql -s % insert into table_name (col1,col2,col3,col4) values($1,$2,$3,$4); % This script is not checking for any errors. The completion status should be returned to the calling program for obvious reasons. Of course this assumes that the user_id that the invoice processing program is running as has grants in the mysql.user table with insert privileges. The invoice processing program would have a system call like: system(/path/to/script/insert_to_mysql arg1 arg2 arg3 arg4) or some such call as that. That is the easiest method to putting data into mysql. 2. Depending on the language your invoice processor is written in, you could talk directly to MySQL. This is the preferred method. I would need more information about your invoice processing program to more accurately provide examples. As to your Windows app. MyODBC works just fine. We use it here and have had no problems with it. ODBC is going to be slower than a direct connect, but again we're talking a very low amount of traffic. You should have no problems. Dean -Original Message- From: Chris Couture [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 8:36 PM To: [EMAIL PROTECTED] Subject: RE: Need Driver to connect Unix SCO 5.2 Open Server to MySQL DB? Thanks again for the help! I tried this on my local machine and it worked like a champ. Here is the question that my unix software programmer has: I believe the client end would be a unix ODBC, which mysql has an SCO version, but it says you need iODBC (or uODBC - I can't remember which), but they don't have a compiled version for SCO. So we would need the gcc compiler and then compile it. That throws a whole other wrench into it as I don't want to be responsible in trying to figure why it won't compile - if there is a problem. The easiest thing might be to install a full version of MySQL on the SCO machine. That should include the client. So then we could write to the other server (or the SCO server if for some reason we need to). The neato advantage to this is for new software. The software I am currently writing is Windows client with SQL Server 2000. I could change it so it uses MySQL and then the data server could continue to be the SCO machine for security purposes. Pose the question
RE: MySQL and ODBC prolbme
Can the two machines ping each other? -Original Message- From: Jeff Bluemel [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 9:11 AM To: [EMAIL PROTECTED] Subject: MySQL and ODBC prolbme I have mysql on a linux box (IP 192.168.0.1), and I've got a windows 2000 box that I am trying to connect to with with odbc. I am getting the following error message [MySQL AB][MyODBC] ERROR : Can't connect to MySQL server on 192.168.0.1 (10061) I'm not sure how to go about correcting this problem Jeff Bluemel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Select Query
if you have an ms. windows machine for a front end, i recommend that you download corereader from http://CoreReader.com/ . ( it's free. ) it does pointclick queries, so you can quickly experiment with them until you get what you want. it installs at the novice level, so set it to the proficient skill level. in the where clause frame, you'll find drop-down lists for the selects. i believe that the one that you want is the is in which will produce the ansi92 in select for you. when it's returning what you want, open the sql frame, which will show you the sql statement that it built for you. (fair warning: not even corereader can make the data connection simple. ) Query ( that gets past the anti spam ) Question is.. I have a select where I want to get ID 15 id 25 Can I do something like WHERE ID = 15,25 Or do I have to do WHERE ID = 15 ID = 25 - Chris Kay Techex Communications Website: www.techex.com.au Email: [EMAIL PROTECTED] Telephone: 1300 88 111 2 - Fax: (02) 9970 5788 - -- John Ragan [EMAIL PROTECTED] 501-228-0317 http://www.CoreReader.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: OT: Reply-Adress in this list
Franz Alt wrote: I use some mail-lists for mysql, php and security with Outlook Express. When I reply, some lists set their list-adress automatically, some the adress of the person originally posting. The second version may not so good IMHO, because I think so many replies are not going to the lists. mysql++ and mysql do not automatically reply to the list mysql-de does. I think the a big Problem with the first solution are some autoresponders which may spamming mainling lists. I'm not a freak in mailservers, but maybe others know if there's a better configuration. Maybe I can configure my Outlook Express better? -- [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 what happens if you click reply to all - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
DATE_FORMAT PROBLEM
I run the following query from a php script - select d1.code, d1.type, d1.descr, d1.grouptype, d1.cusref, d1.stock, d1.minstock, d1.appmeth, d1.supplier, d1.suppref, d1.leadtime, d1.price, d1.reorder, d1.code1, d1.code2, d1.notes, d1.usr, d1.usr, d1.cusname, d1.colours, d1.stitchcount, d1.height, d1.width, DATE_FORMAT(d1.created, '%d-%m-%Y'), DATE_FORMAT(d1.amended, '%d-%m-%Y'), d2.extdescr from decheader as d1, decextdescr as d2 where d1.code = d2.code and d1.code = '00042' The problem I am having is with the DATE_FORMAT. Running the above query returns the following for the width column. 94.40 DATE_FORMAT(d1.created, '%d-%m-%Y'): NULL DATE_FORMAT(d1.amended, '%d-%m-%Y'): 03-10-2002 The width column should only return 94.40. Why does this query put 3 columns into one? This e-mail is intended for the recipient only and may contain confidential information. If you are not the intended recipient then you should reply to the sender and take no further ation based upon the content of the message. Internet e-mails are not necessarily secure and CCM Limited does not accept any responsibility for changes made to this message. Although checks have been made to ensure this message and any attchments are free from viruses the recipient should ensure that this is the case. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
I have a slow query that needs optimising..
Hi all, I wonder if anyone could help me speed up the following query (it works fine and produces the result I want but it's very slow...) Here is a typical query (will be executed quite often on a reasonably busy system (about 50% idle doing other stuff that is not using the below tables..)): select count(*) as num,publicinfo.*,if (local_classes.cat='hot','checked','') as checked,local_classes.* from publicinfo, local_classes where local_classes.class_code = publicinfo.class_code and x507000 and x547000 and y164500 and y204500 group by cat; This is running very slowly on Redhat 7.2, MySQL 3.23 binary install, a twin 1GHz Xeon compaq ML530, 1GB Ram, SCSI disk etc... (it's not swapping and the disk servicetime is OK) Can anyone come up with a touch of magic to make this query more efficient? (table definitions below...) There are 2 tables: 1. 'publicinfo' (Just under 800,000 records): CREATE TABLE publicinfo ( id mediumint(9) NOT NULL auto_increment, seq int(11) NOT NULL default '0', name varchar(50) NOT NULL default '', pc varchar(10) NOT NULL default '', host varchar(120) NOT NULL default '', path varchar(120) NOT NULL default '', url varchar(120) NOT NULL default '', class_code enum('h','rp','rs','mv','www','pub','gc','res','cin','ind','hot','des','loc' ,'tube','cam') default NULL, x mediumint(9) NOT NULL default '0', y mediumint(9) NOT NULL default '0', supplier varchar(10) NOT NULL default 'mm', PRIMARY KEY (id), KEY cat_idx (class_code), KEY geo_idx (x,y) ) TYPE=MyISAM; 2. 'local_classes' (about 1000 records) CREATE TABLE local_classes ( class_code varchar(40) NOT NULL default '', name varchar(30) NOT NULL default '', cat varchar(20) NOT NULL default '', label varchar(25) NOT NULL default '', KEY class_idx (class_code), KEY cat_idx (cat), KEY idx1 (class_code,cat) ) TYPE=MyISAM; - Thanks to all who try Kindest Regards, Andrew Sql, query Andrew Braithwaite Implementation Manager multimap.com e: [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/InnoDB-4.0.4 is released
Gelu, - Original Message - From: Gelu Gogancea [EMAIL PROTECTED] To: Puiu Hrenciuc [EMAIL PROTECTED]; Heikki Tuuri [EMAIL PROTECTED]; Philip Molter [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 2:40 PM Subject: Re: MySQL/InnoDB-4.0.4 is released Hi, You have right, in the new version (4.0.4) on Windows 9x are the same symptom. I research a little in this morning and i found where is the problem when the innodb is initialised. The problems is in the function: sync_array_create() ...when it must initialise a lot of cells(n_cells=aprox. 6.000.000). that number is strange. It should be 10 000. Maybe you have compiled with optimizations so that the debugger shows a wrong number. But this reveals a possible reason for the slowness and other problems in Win 95/98/ME. Can you try the following: in \mysql\innobase\include\os0thread.h change #define OS_THREAD_MAX_N 1 to a smaller value, for example, 100. It may be that Win 95/98/ME has problems in creating a large number of event semaphores. You have to recompile the 'innobase' project because the change is in a header. Please report if this helps. Regards, Heikki Innobase Oy sql query The routine is next : for (i = 0; i n_cells; i++) { cell = sync_array_get_nth_cell(arr, i); cell-wait_object = NULL; /* Create an operating system event semaphore with no name */ cell-event = os_event_create(NULL); cell-event_set = FALSE; /* it is created in reset state */ } The configuration of my computer for testing is: CPU : INTEL P IV/1,7 Ghz RAM: 512 MB DDRAM HDD: 2x40 GB(IDE) OS:Windows 98 OSR2 Maybe this help on Heikki to see what happend. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Puiu Hrenciuc [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED]; Philip Molter [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 12:46 AM Subject: Re: MySQL/InnoDB-4.0.4 is released I hoped that you will solve the MySQL consuming all computer's resources in 4.0.4, but nope, the problem is still there. I'm trying to run MySQL on Win ME and when started normally it consumes all resources of my computer. When I start it with --skip-innodb it works just fine. Why ? At least I saw you fixed WinMySQLAdmin. - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: Philip Molter [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, October 02, 2002 5:48 PM Subject: Re: MySQL/InnoDB-4.0.4 is released Philip, - Original Message - From: Philip Molter [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, October 02, 2002 4:16 PM Subject: Re: MySQL/InnoDB-4.0.4 is released On Wed, Oct 02, 2002 at 02:12:23PM +0300, Heikki Tuuri wrote: : Hi! : : InnoDB is a table type which provides transactions, row level locking, : foreign key constraints, and a non-free hot backup tool to MySQL. : : InnoDB is included in both downloadable versions of MySQL-4.0: MySQL-Pro and : MySQL-Max. : : Release 4.0.4-beta is mainly a bug fix release. Will the bugfixes for this release (not necessarily the new/updated features) be backported to the 3.23.x series? Given that MySQL 4 isn't marked as stable yet, many of us using InnoDB no doubt still use 3.23.x. of course, the fix will be backported if the bug also existed in 3.23. The DESC bugs in 4.0.x are not present in 3.23. Since 4.0.x releases will come in more rapid succession than 3.23 releases, it may soon be that the most bug-free InnoDB is actually in the latest 4.0.x. * Philip Molter * Texas.net Internet * http://www.texas.net/ * [EMAIL PROTECTED] Regards, Heikki Innobase Oy sql query - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try:
re: [Q] Replication temporary tables (fwd)
äÏÂÒÙÊ ÄÅÎØ. sql Andrey, Tuesday, October 01, 2002, 11:53:41 AM, you wrote: AK Why is temporary tables replecated? AK Is it true? Yes, temporary table are replicated properly since 3.23.29: http://www.mysql.com/doc/en/Replication_Features.html Hmm... What is the reason? If I create a temporary table in one process, I can't use it in another. And after close connection table will destroy. What is the reason to replicate it? Best regards. ___ Andrey Kotrekhov [EMAIL PROTECTED] ISP Alkar Teleport ÔÅÌ. +380 562 34-00-44 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
InnoDB hard lockup
Hi All, First thanks to all who worked on InnoDB, it is truely exciting to get its features in an open-source DB. We've had an excellent experience thus far with a few exceptions. Any help on solving the problem below is greatly appreciated ... We experienced a hard lockup a few days ago with mysql-max-3.23.52 for Solaris 2.7. The DB had been running very well for over a month until the innodb_monitor was turned on. After turning it on, all InnoDB threads blocked within a few minutes, and we saw the messages below in the error log. The only other info that may seem relevent is that we have a monitor that executes show table status every 15 minutes to check for remaining space in the InnoDB tablespace. That monitor does not run in our test environment and we never had a problem with the innodb monitor in our test environment while executing a similar workload. So this problem may be correlated or caused by the show table status command in conjunction with the innodb monitor. Any thoughts? ... end of innodb monitor output removed ... -- ROW OPERATIONS -- 5 queries inside InnoDB, 0 queries in queue; main thread: doing background drop tables Number of rows inserted 9070335, updated 3286308, deleted 1038094, read 536669195 11.52 inserts/s, 14.80 updates/s, 8.40 deletes/s, 393.73 reads/s END OF INNODB MONITOR OUTPUT InnoDB: Warning: a long semaphore wait: --Thread 75521 has waited at trx0trx.c line 576 for 242.00 seconds the semaphore: Mutex at 1c12938 created file srv0srv.c line 1621, lock var 1 Last time reserved in file lock0lock.c line 341, waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 75832 has waited at lock0lock.c line 341 for 242.00 seconds the semaphore: Mutex at 1c12938 created file srv0srv.c line 1621, lock var 1 Last time reserved in file lock0lock.c line 341, waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 74124 has waited at trx0trx.c line 576 for 242.00 seconds the semaphore: Mutex at 1c12938 created file srv0srv.c line 1621, lock var 1 Last time reserved in file lock0lock.c line 341, waiters flag 1 ... lots more like this, and then ... InnoDB: Warning: a long semaphore wait: --Thread 75521 has waited at trx0trx.c line 576 for 434.00 seconds the semaphore: Mutex at 1c12938 created file srv0srv.c line 1621, lock var 1 Last time reserved in file lock0lock.c line 341, waiters flag 1 InnoDB: Error: semaphore wait has lasted 600 seconds InnoDB: We intentionally crash the server, because it appears to be hung. 020924 17:56:27 InnoDB: Assertion failure in thread 9 in file sync0arr.c line 934 InnoDB: We intentionally generate a memory trap. InnoDB: Send a detailed bug report to [EMAIL PROTECTED] mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked agaist is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Select Query
I seem to be having problems trying to get to http://www.corereader.com ... Anyone else? +--+ | ___ ___ | | //_/_/_/_/_/ //_/_/_/ | |//_/ //_/ _/ | | //_/ //_/ _/| | //_/ //_/_/_/ | |--| | Tony Devlin - [EMAIL PROTECTED] | | Airewaves Broadband, Systems Admin | | Website - www.airewaves.com | | Atlanta, Ga - 678.522.3923 | | Beaufort, SC - 843.379.AIRE(2473)| +--+ -Original Message- From: John Ragan [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 10:47 AM To: [EMAIL PROTECTED]; Chris Kay Subject: Re: Select Query if you have an ms. windows machine for a front end, i recommend that you download corereader from http://CoreReader.com/ . ( it's free. ) it does pointclick queries, so you can quickly experiment with them until you get what you want. it installs at the novice level, so set it to the proficient skill level. in the where clause frame, you'll find drop-down lists for the selects. i believe that the one that you want is the is in which will produce the ansi92 in select for you. when it's returning what you want, open the sql frame, which will show you the sql statement that it built for you. (fair warning: not even corereader can make the data connection simple. ) Query ( that gets past the anti spam ) Question is.. I have a select where I want to get ID 15 id 25 Can I do something like WHERE ID = 15,25 Or do I have to do WHERE ID = 15 ID = 25 - Chris Kay Techex Communications Website: www.techex.com.au Email: [EMAIL PROTECTED] Telephone: 1300 88 111 2 - Fax: (02) 9970 5788 - -- John Ragan [EMAIL PROTECTED] 501-228-0317 http://www.CoreReader.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: DATE_FORMAT PROBLEM
On 3 Oct 2002, at 15:33, Mark Colvin wrote: The problem I am having is with the DATE_FORMAT. Running the above query returns the following for the width column. 94.40 DATE_FORMAT(d1.created, '%d-%m-%Y'): NULL DATE_FORMAT(d1.amended, '%d-%m-%Y'): 03-10-2002 Show your PHP code. How exactly are you retrieving the values? This doesn't seem like a problem with MySQL itself but rather with PHP or (much more likely) with your code. -- 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: Perl with Mysql
HI all I'm trying to do the following --- # want to select (just preparing) every thing from the table PERSON where i don't know the deptID yet. $per = $dbh-prepare(SELECT * FROM person WHERE deptID = ?); # selecting deptID from the table ACCOUNT, say with some condition $acc = $dbh-prepare(SELECT deptID FROM account WHERE ; $acc-execute() or die Can't execute the SQL statment: $DBI::errstr\n; while ( @accRow = $acc-fetchrow_array ) { # For each deptID I get from the ACCOUNT table, I want all the info from the PERSON table $per-execute($accRow[0] ) or die Can't execute the SQL statment: $DBI::errstr\n; The statements above are all part of a subroutine, and not meant to be executed as individual commands. Here's what is on the page you referenced: sub age_by_id { # Arguments: database handle, person ID number my ($dbh, $id) = @_; my $sth = $dbh-prepare('SELECT age FROM people WHERE id = ?') or die Couldn't prepare statement: . $dbh-errstr; $sth-execute($id) or die Couldn't execute statement: . $sth-errstr; my ($age) = $sth-fetchrow_array(); return $age; } You have to pass this subroutine 2 arguments when you execute it: $dbh and $id before it will work. -- /* All outgoing email scanned by Norton Antivirus 2002 */ Amer Neely, Softouch Information Services W: www.softouch.on.ca E: [EMAIL PROTECTED] V: 519.438.5887 Perl | PHP | MySQL | CGI programming for all data entry forms. We make web sites work! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL/InnoDB-4.0.4 is released
Hi! I believe the following patch fixes the startup problems on Win 95/98/ME in InnoDB versions which have been released after July 2, 2002. Looks like Win XP can easily create 40 000 event semaphores, but for 95/98/ME it is too much. This should be in upcoming MySQL-3.23.53 and MySQL-4.0.5. Thank you for the bug reports. Heikki Innobase Oy ChangeSet 1.1204 02/10/03 18:10:34 [EMAIL PROTECTED] +1 -0 os0thread.h: Fix the probable reason why InnoDB versions after July 2, 2002 did not start properly in some Win 95/98/ME computers innobase/include/os0thread.h 1.7 02/10/03 18:10:26 [EMAIL PROTECTED] +9 -0 Fix the probable reason why InnoDB versions after July 2, 2002 did not start properly in some Win 95/98/ME computers # This is a BitKeeper patch. What follows are the unified diffs for the # set of deltas contained in the patch. The rest of the patch, the part # that BitKeeper cares about, is below these diffs. # User: heikki # Host: hundin.mysql.fi # Root: /home/heikki/mysql --- 1.6/innobase/include/os0thread.h Tue Aug 13 01:18:15 2002 +++ 1.7/innobase/include/os0thread.h Thu Oct 3 18:10:26 2002 @@ -15,7 +15,16 @@ /* Maximum number of threads which can be created in the program; this is also the size of the wait slot array for MySQL threads which can wait inside InnoDB */ +#ifdef __WIN__ +/* Windows 95/98/ME seemed to have difficulties creating the all +the event semaphores for the wait array slots. If the computer had += 64 MB memory, InnoDB startup could take minutes or even crash. +That is why we set this to only 1000 in Windows. */ + +#define OS_THREAD_MAX_N 1000 +#else #define OS_THREAD_MAX_N 1 +#endif /* Possible fixed priorities for threads */ #define OS_THREAD_PRIORITY_NONE 100 - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: Gelu Gogancea [EMAIL PROTECTED]; Puiu Hrenciuc [EMAIL PROTECTED]; Philip Molter [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 6:07 PM Subject: Re: MySQL/InnoDB-4.0.4 is released Gelu, - Original Message - From: Gelu Gogancea [EMAIL PROTECTED] To: Puiu Hrenciuc [EMAIL PROTECTED]; Heikki Tuuri [EMAIL PROTECTED]; Philip Molter [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 2:40 PM Subject: Re: MySQL/InnoDB-4.0.4 is released Hi, You have right, in the new version (4.0.4) on Windows 9x are the same symptom. I research a little in this morning and i found where is the problem when the innodb is initialised. The problems is in the function: sync_array_create() ...when it must initialise a lot of cells(n_cells=aprox. 6.000.000). that number is strange. It should be 10 000. Maybe you have compiled with optimizations so that the debugger shows a wrong number. But this reveals a possible reason for the slowness and other problems in Win 95/98/ME. Can you try the following: in \mysql\innobase\include\os0thread.h change #define OS_THREAD_MAX_N 1 to a smaller value, for example, 100. It may be that Win 95/98/ME has problems in creating a large number of event semaphores. You have to recompile the 'innobase' project because the change is in a header. Please report if this helps. Regards, Heikki Innobase Oy sql query The routine is next : for (i = 0; i n_cells; i++) { cell = sync_array_get_nth_cell(arr, i); cell-wait_object = NULL; /* Create an operating system event semaphore with no name */ cell-event = os_event_create(NULL); cell-event_set = FALSE; /* it is created in reset state */ } The configuration of my computer for testing is: CPU : INTEL P IV/1,7 Ghz RAM: 512 MB DDRAM HDD: 2x40 GB(IDE) OS:Windows 98 OSR2 Maybe this help on Heikki to see what happend. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Puiu Hrenciuc [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED]; Philip Molter [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 12:46 AM Subject: Re: MySQL/InnoDB-4.0.4 is released I hoped that you will solve the MySQL consuming all computer's resources in 4.0.4, but nope, the problem is still there. I'm trying to run MySQL on Win ME and when started normally it consumes all resources of my computer. When I start it with --skip-innodb it works just fine. Why ? At least I saw you fixed WinMySQLAdmin. - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: Philip Molter [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, October 02, 2002 5:48 PM Subject: Re:
mysql solaris binaries
hi, i've downloaded and unpacked both the 3.2.3 and 4.0.4 binaries for solaris. neither create a var directory, so i create the var directory myself and give mysql ownership of it. yet when i run mysqld it still won't write the pid file. what gives? tia, j - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
make error
I cannot find a fix for this (only a couple of mentions on upgrading glibc, i think i have the latest). I get this during make mkdir .libs gcc -DDEFAULT_CHARSET_HOME=\/usr/local\ -DDATADIR=\/usr/local/var\ -DSHA REDIR=\/usr/local/share/mysql\ -DUNDEF_ THREADS_HACK -DDONT_USE_RAID -I./../include -I../include -I./.. -I.. -I.. -O 3 -DDBUG_OFF -c libmysql.c -fPIC -DPIC - o .libs/libmysql.lo libmysql.c: In function `mysql_real_connect': libmysql.c:1324: warning: passing arg 5 of `gethostbyname_r' from incompatible pointer type libmysql.c:1324: too few arguments to function `gethostbyname_r' libmysql.c:1324: warning: assignment makes pointer from integer without a cast make[2]: *** [libmysql.lo] Error 1 make[2]: Leaving directory `/usr/local/src/mysql-3.23.52/libmysql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/local/src/mysql-3.23.52' make: *** [all-recursive-am] Error 2 [repett0@unigeek mysql-3.23.52]$ rpm -aq | grep glib glib2-2.0.1-2 glibc-kernheaders-2.4-7.16 glibc-2.2.5-39 glib-1.2.10-5 glibc-common-2.2.5-39 glibc-devel-2.2.5-34 [mysql-3.23.52]$ uname -a Linux unigeek.com 2.4.18-53um #1 Thu Aug 22 08:54:36 CDT 2002 i686 unknown [ mysql-3.23.52]$ Thanks Ron - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: I have a slow query that needs optimising..
On Thu, 03 Oct 2002, Andrew Braithwaite wrote: Please can you post an explain of this query? As a first guess try: alter table publicinfo add index location (x,y,class_code); Nigel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
unable to set root password
hi everyone, i have just installed mysql.i was able to start the mysqld process.howeveri am unable to set password for root using the following command sequence : ./bin/mysqladmin -u root -password 'abcd' I get the following output : ./bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' I had read that there is a default userid called 'test'.i am unable to use that as well. please help me in solving this login problem. thanks palash - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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/InnoDB-4.0.4 is released
Hi Heikki and all friends, You quite right.If OS_THREAD_MAX_N is 100 or 1000 all it's ok and svr_init() works well. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: Gelu Gogancea [EMAIL PROTECTED]; Puiu Hrenciuc [EMAIL PROTECTED]; Philip Molter [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 5:07 PM Subject: Re: MySQL/InnoDB-4.0.4 is released Gelu, - Original Message - From: Gelu Gogancea [EMAIL PROTECTED] To: Puiu Hrenciuc [EMAIL PROTECTED]; Heikki Tuuri [EMAIL PROTECTED]; Philip Molter [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 2:40 PM Subject: Re: MySQL/InnoDB-4.0.4 is released Hi, You have right, in the new version (4.0.4) on Windows 9x are the same symptom. I research a little in this morning and i found where is the problem when the innodb is initialised. The problems is in the function: sync_array_create() ...when it must initialise a lot of cells(n_cells=aprox. 6.000.000). that number is strange. It should be 10 000. Maybe you have compiled with optimizations so that the debugger shows a wrong number. But this reveals a possible reason for the slowness and other problems in Win 95/98/ME. Can you try the following: in \mysql\innobase\include\os0thread.h change #define OS_THREAD_MAX_N 1 to a smaller value, for example, 100. It may be that Win 95/98/ME has problems in creating a large number of event semaphores. You have to recompile the 'innobase' project because the change is in a header. Please report if this helps. Regards, Heikki Innobase Oy sql query The routine is next : for (i = 0; i n_cells; i++) { cell = sync_array_get_nth_cell(arr, i); cell-wait_object = NULL; /* Create an operating system event semaphore with no name */ cell-event = os_event_create(NULL); cell-event_set = FALSE; /* it is created in reset state */ } The configuration of my computer for testing is: CPU : INTEL P IV/1,7 Ghz RAM: 512 MB DDRAM HDD: 2x40 GB(IDE) OS:Windows 98 OSR2 Maybe this help on Heikki to see what happend. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Puiu Hrenciuc [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED]; Philip Molter [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 12:46 AM Subject: Re: MySQL/InnoDB-4.0.4 is released I hoped that you will solve the MySQL consuming all computer's resources in 4.0.4, but nope, the problem is still there. I'm trying to run MySQL on Win ME and when started normally it consumes all resources of my computer. When I start it with --skip-innodb it works just fine. Why ? At least I saw you fixed WinMySQLAdmin. - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: Philip Molter [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, October 02, 2002 5:48 PM Subject: Re: MySQL/InnoDB-4.0.4 is released Philip, - Original Message - From: Philip Molter [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, October 02, 2002 4:16 PM Subject: Re: MySQL/InnoDB-4.0.4 is released On Wed, Oct 02, 2002 at 02:12:23PM +0300, Heikki Tuuri wrote: : Hi! : : InnoDB is a table type which provides transactions, row level locking, : foreign key constraints, and a non-free hot backup tool to MySQL. : : InnoDB is included in both downloadable versions of MySQL-4.0: MySQL-Pro and : MySQL-Max. : : Release 4.0.4-beta is mainly a bug fix release. Will the bugfixes for this release (not necessarily the new/updated features) be backported to the 3.23.x series? Given that MySQL 4 isn't marked as stable yet, many of us using InnoDB no doubt still use 3.23.x. of course, the fix will be backported if the bug also existed in 3.23. The DESC bugs in 4.0.x are not present in 3.23. Since 4.0.x releases will come in more rapid succession than 3.23 releases, it may soon be that the most bug-free InnoDB is actually in the latest 4.0.x. * Philip Molter * Texas.net Internet * http://www.texas.net/ * [EMAIL PROTECTED] Regards, Heikki
Re: MySQL/InnoDB-4.0.4 is released
Gelu, - Original Message - From: Gelu Gogancea [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED]; Puiu Hrenciuc [EMAIL PROTECTED]; Philip Molter [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 7:48 PM Subject: Re: MySQL/InnoDB-4.0.4 is released Hi Heikki and all friends, You quite right.If OS_THREAD_MAX_N is 100 or 1000 all it's ok and svr_init() works well. thank you! Next week Lenz will start building 3.23.53 where I have reduced the number to 1000. With good luck 3.23.53 will be released around October 17, 2002. Regards, Gelu Regards, Heikki Innobase Oy _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: Gelu Gogancea [EMAIL PROTECTED]; Puiu Hrenciuc [EMAIL PROTECTED]; Philip Molter [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 5:07 PM Subject: Re: MySQL/InnoDB-4.0.4 is released Gelu, - Original Message - From: Gelu Gogancea [EMAIL PROTECTED] To: Puiu Hrenciuc [EMAIL PROTECTED]; Heikki Tuuri [EMAIL PROTECTED]; Philip Molter [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 2:40 PM Subject: Re: MySQL/InnoDB-4.0.4 is released Hi, You have right, in the new version (4.0.4) on Windows 9x are the same symptom. I research a little in this morning and i found where is the problem when the innodb is initialised. The problems is in the function: sync_array_create() ...when it must initialise a lot of cells(n_cells=aprox. 6.000.000). that number is strange. It should be 10 000. Maybe you have compiled with optimizations so that the debugger shows a wrong number. But this reveals a possible reason for the slowness and other problems in Win 95/98/ME. Can you try the following: in \mysql\innobase\include\os0thread.h change #define OS_THREAD_MAX_N 1 to a smaller value, for example, 100. It may be that Win 95/98/ME has problems in creating a large number of event semaphores. You have to recompile the 'innobase' project because the change is in a header. Please report if this helps. Regards, Heikki Innobase Oy sql query The routine is next : for (i = 0; i n_cells; i++) { cell = sync_array_get_nth_cell(arr, i); cell-wait_object = NULL; /* Create an operating system event semaphore with no name */ cell-event = os_event_create(NULL); cell-event_set = FALSE; /* it is created in reset state */ } The configuration of my computer for testing is: CPU : INTEL P IV/1,7 Ghz RAM: 512 MB DDRAM HDD: 2x40 GB(IDE) OS:Windows 98 OSR2 Maybe this help on Heikki to see what happend. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Puiu Hrenciuc [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED]; Philip Molter [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 12:46 AM Subject: Re: MySQL/InnoDB-4.0.4 is released I hoped that you will solve the MySQL consuming all computer's resources in 4.0.4, but nope, the problem is still there. I'm trying to run MySQL on Win ME and when started normally it consumes all resources of my computer. When I start it with --skip-innodb it works just fine. Why ? At least I saw you fixed WinMySQLAdmin. - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: Philip Molter [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, October 02, 2002 5:48 PM Subject: Re: MySQL/InnoDB-4.0.4 is released Philip, - Original Message - From: Philip Molter [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, October 02, 2002 4:16 PM Subject: Re: MySQL/InnoDB-4.0.4 is released On Wed, Oct 02, 2002 at 02:12:23PM +0300, Heikki Tuuri wrote: : Hi! : : InnoDB is a table type which provides transactions, row level locking, : foreign key constraints, and a non-free hot backup tool to MySQL. : : InnoDB is included in both downloadable versions of MySQL-4.0: MySQL-Pro and : MySQL-Max. : : Release 4.0.4-beta is mainly a bug fix release. Will the bugfixes
More Detailed EXPLAIN
If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: Is there a way to get a more detailed explain statement? If not, maybe someone can answer this for me. Say I have a statement like this: EXPLAIN SELECT /*! STRAIGHT_JOIN */ t1.* FROM table2 t2 INNER JOIN table1 t1 /*! USE INDEX ( field1 ) */ ON t1.field1=t2.field1 AND t2.field2 IS NOT NULL INNER JOIN table3 t3 ON t1.field2=t3.field2 AND t3.field1=1 WHERE MOD(t1.field1,5)=3 AND t1.field3=0 AND t1.field4NOW(); This produces an explain of +---++-+-+-+---+--+-+ | table | type | possible_keys | key | key_len | ref | rows || Extra | +---++-+-+-+---+--+-+ | t2| index | PRIMARY,field1 | field1 | 7 | NULL | 30 || where used; Using index | | t1| ref| field2,field1,field4,field3 | field1 | 4 | t2.field1 | 508 || where used | | t3| eq_ref | PRIMARY,field1 | PRIMARY | 4 | t1.field2 |1 || where used | +---++-+-+-+---+--+-+ That's the exact same explain as (no MOD() expression): EXPLAIN SELECT /*! STRAIGHT_JOIN */ t1.* FROM table2 t2 INNER JOIN table1 t1 /*! USE INDEX ( field1 ) */ ON t1.field1=t2.field1 AND t2.field2 IS NOT NULL INNER JOIN table3 t3 ON t1.field2=t3.field2 AND t3.field1=1 WHERE t1.field3=0 AND t1.field4NOW(); My question is, when is that MOD() performed and used? Is it going to join t1, t2, and t3, find the fields that match on keys, and then sift out the rows that don't pass the MOD() or is it going to join t2 - t1, sift out the MOD() entries, then join t3 into the mix on the remaining rows? sql, query * Philip Molter * Texas.net Internet * http://www.texas.net/ * [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: Select Query
i just tried, and it came right up. the server is located in the southern u.s., so perhaps the hurricane is effecting it. I seem to be having problems trying to get to http://www.corereader.com ... Anyone else? +--+ | ___ ___ | | //_/_/_/_/_/ //_/_/_/ | |//_/ //_/ _/ | | //_/ //_/ _/| | //_/ //_/_/_/ | |--| | Tony Devlin - [EMAIL PROTECTED] | | Airewaves Broadband, Systems Admin | | Website - www.airewaves.com | | Atlanta, Ga - 678.522.3923 | | Beaufort, SC - 843.379.AIRE(2473)| +--+ -Original Message- From: John Ragan [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 10:47 AM To: [EMAIL PROTECTED]; Chris Kay Subject: Re: Select Query if you have an ms. windows machine for a front end, i recommend that you download corereader from http://CoreReader.com/ . ( it's free. ) it does pointclick queries, so you can quickly experiment with them until you get what you want. it installs at the novice level, so set it to the proficient skill level. in the where clause frame, you'll find drop-down lists for the selects. i believe that the one that you want is the is in which will produce the ansi92 in select for you. when it's returning what you want, open the sql frame, which will show you the sql statement that it built for you. (fair warning: not even corereader can make the data connection simple. ) Query ( that gets past the anti spam ) Question is.. I have a select where I want to get ID 15 id 25 Can I do something like WHERE ID = 15,25 Or do I have to do WHERE ID = 15 ID = 25 - Chris Kay Techex Communications Website: www.techex.com.au Email: [EMAIL PROTECTED] Telephone: 1300 88 111 2 - Fax: (02) 9970 5788 - -- John Ragan [EMAIL PROTECTED] 501-228-0317 http://www.CoreReader.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 -- John Ragan [EMAIL PROTECTED] 501-228-0317 http://www.CoreReader.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: Benchmark Results or MySQL Articles Needed!
On Wed, 2002-10-02 at 20:51, mos wrote: At 09:40 PM 10/2/2002, you wrote: For science fair I'm doing a project on MySQL. For my introduction, I need some articles, benchmarks, or anything else credible that I can put in the bibliography. If anyone can help me out, I'd be extremely appreciative! Thanks. SS, Benchmarks are no longer believable because other database manufacturers (not MySQL AB of courseg) can twist the tests so it appears their database is faster than it is. I did run into InnoDb benchmarks at http://www.innodb.com/bench.html. Instead of benchmarks you might want to report on who's using MySQL. See http://www.mysql.com/press/user_stories/index.html and http://www.innodb.com/userstories.html. Also the size of some of these databases (1+Terabyte) might impress people. Mike We're working on developing real-world database workloads at the Open Source Development Lab (http://www.osdl.org/projects/performance/). While these are based on the TPC benchmarks, the intent is to evaluate system performance as opposed to seeing which database is faster. Our development here is currently focused on SAP DB, but this does not mean we want it to exclusively work with that database. We would love (and appreciate) any help to adapt it to work with SAP DB. Please contact us if there is any interest. Thanks, Mark -- Mark Wong - - [EMAIL PROTECTED] Open Source Development Lab Inc - A non-profit corporation 15275 SW Koll Parkway - Suite H - Beaverton OR, 97006 (503)-626-2455 x 32 (office) (503)-626-2436 (fax) http://www.osdl.org/archive/markw/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 hard lockup
Wayne, please send me the whole MySQL error log. Looks like some thread, which had reserved the InnoDB 'kernel' mutex to access the InnoDB lock table, got stuck. This is interesting: 5 queries inside InnoDB, 0 queries in queue; main thread: doing background drop tables If you drop a table where there still are queries running, then InnoDB delays the drop table until the queries have ended, and only after that drops the table. When dropping the table, InnoDB has to remove also any locks there are on the table. The code is not that well tested. The bug might be there. What DROP TABLE and what queries could have been involved? Do you have very many tables? Does SHOW TABLE STATUS take long? Are you sure you ran innodb_monitor and not innodb_lock_monitor? Can you repeat the bug? Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB Copied message: .. Subject: InnoDB hard lockup From: Wayne Lewis Date: Thu, 3 Oct 2002 08:48:26 -0700 Hi All, First thanks to all who worked on InnoDB, it is truely exciting to get its features in an open-source DB. We've had an excellent experience thus far with a few exceptions. Any help on solving the problem below is greatly appreciated ... We experienced a hard lockup a few days ago with mysql-max-3.23.52 for Solaris 2.7. The DB had been running very well for over a month until the innodb_monitor was turned on. After turning it on, all InnoDB threads blocked within a few minutes, and we saw the messages below in the error log. The only other info that may seem relevent is that we have a monitor that executes show table status every 15 minutes to check for remaining space in the InnoDB tablespace. That monitor does not run in our test environment and we never had a problem with the innodb monitor in our test environment while executing a similar workload. So this problem may be correlated or caused by the show table status command in conjunction with the innodb monitor. Any thoughts? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ODBC ... why even uset it? (! flame/troll..genuine question)
Hello, Been using mysql on w2k for a couple years now and never used the DSN ODBC connection. See a lot of articles (google/archives/etc) on how to use it .. but none on why. Any particular reason I would even want to use ODBC for a mysql connection as opposed to just directly connecting to it with Perl DBI. (Like I would on a *nix box). As for why have you been actively avoiding ODBC .. well..mainly portability reasons. I like to secretly hope one day my boss lets me migrate to Solaris or *BSD . But if there are other issues at stake (performance, features, etc etc) might make sense to switch to ODBC Cheers, -Peter ## Peter Thoenen - Systems Programmer Commercial Communications Camp Bondsteel, Kosovo ## Stumbled Upon...heh (Score:5, Funny) /. by $carab on 23:00 23 August 2002 (#4131637) ForensicTec officials said they stumbled upon the military networks about two months ago, while checking on network security for a private-sector client. Someone new to a Dvorak probably tried to type in lynx http://www.google.com; but instead got nmap -v -p 1-1024 -sS -P0 army.mil -T paranoid. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RV: off-topic informix to oracle.
Sorry but I'm sure one of you guru's knows about the best software (ltl) to migrate informix database to Oracle, I need to link then oracle to MySQL, and then to report via crystal reports. EJB - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fw: Three Tables
Pass Filter: sql,query - Original Message - From: William Martell [EMAIL PROTECTED] To: MySQL Main List [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 1:48 AM Subject: Three Tables Hello All, I have three tables in my database t1, t2, and t3. Each table has records that are the same or similar. I am trying to SELECT part number, part description, location, part cost, sell price and on hand quantity from these three tables. Each part number is the same in all three tables. I am having trouble with my select statement. Can anyone help??? Thank you for your time and assistance. Sincerely, William Martell - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
To Duplicate a Row?
Is there a simple way to duplicate one or more rows in a table? I tried: INSERT INTO table SELECT * FROM table WHERE criteria but apparently INSERT...SELECT cannot function on the same table. - filter fodder, ignore - sql query (I swear, I'm gonna put that in my .signature soon... :-) -- : Jan Steinman -- nature photography: http://www.Bytesmiths.com : Bytesmiths -- artists' services: http://www.Bytesmiths.com/Services : Join the forums at http://www.Bytesmiths.com/wiki - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 Examples and Documents on joining tables?
Is there a document that compiles examples on different ways of joining two or more tables? I found a few on http://www.mysql.com/doc/en/JOIN.html but they do not cover joining more than two tables. Thanks for any suggestions. I wish there were more examples as well! I use this for multi-table joins: SELECT table1.bunch, table2.of, table3.stuff FROM table1 INNER JOIN table2 ON table2.some_id INNER JOIN table3 ON table3.some_id WHERE table1.some_id = table2.some_id AND table1.some_id = table3.some_id; Not sure if this the best way or not, but it works... Anyone with more experience care to contribute? Are there optimum ways to join multiple tables? Josh - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Slave server and InnoDB
sql,query Hello. Is there an option for the slave server to NOT stop when an error inducing query is run on the master? For instance, if someone tries in insert a duplicate entry, and the master shows the error, but updates the binlog, how can I keep the slave from seeing the same error, and NOT stopping itself? Thanks! -James - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
raid vs splitting the database
sql, query I have a dilemma and maybe you can help. I'm wanting to improve my disk performance and I'm wondering if I should go with Raid 10 or if I should simply mirror the drives so that I have redundancy and then put some of my tables on one drive and some on the other. Or the third option is to put the tables on one drive and the logs on another drive. Ultimately, what is going to give me the best performance? Should I use 3 drives (mirrored so 6 actual drives) and put half of the tables on drive 1, half on drive 2, and logs on drive 3? TIA, Gary - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Perl MySQL installed with rpm's vs binaries combination
Perl was installed from my RedHat 6.2 install media, I remember a problem of installing MySQL using the binaries would cause conflicts with a rpm installed Perl. That is what someone in this newsgroup told me about a year ago. Is this true? I couldn't get the MySQL to install with the RPM's. Is it safe to install using the binary version of MySQL, will I encounter any problems using Perl to access the database with the Perl(rpm) MySQL(binary) versions? Will I need to re-install Perl Thanks Chris Previous Post, no answer yet: To: [EMAIL PROTECTED] Subject: RPM Install appears to have failed Date Sent: 10/2/02 RedHat6.2 install (everything) out of box on Intel 1 proc server 256mb ram. Downloaded 3.23.52-1 rpm client rpm to /usr/loca/tmp - i created the tmp folder as root and chmod 777 Followed the install instructions - which only included: To perform a standard minimal installation, run: shell rpm -i MySQL-VERSION.i386.rpm MySQL-client-VERSION.i386.rpm (No user or group or environment setup instructions before running rpm's???) So logged in as root I executed the following, and got the result below [root@plinux tmp]# rpm -i MySQL-Max-3.23.52-1.i386.rpm MySQL-client-3.23.52-1.i386.rpm Giving mysqld a couple of seconds to restart var/tmp/rpm-tmp.10346: /etc/rc.d/init.d/mysql: No such file or directory Was this successful? Where did mysql install to? The post installation steps say to: shell ./scripts/mysql_install_db shell cd mysql_installation_directory shell ./bin/safe_mysqld --user=mysql cd_mysql_installation_directory - where the heck did it install at? don't think this happened... thanks in advance. Chris Becker MCDBA MCSE http://www.PrismSoftware.com [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: Is there Examples and Documents on joining tables?
Hi Arthur, Thanks for your answer and your example. Your example is very good but I can't map to what I'm trying to do. As you suggested I have to understand how inner join is implemented in MySQL. The query that I'm working on selects fields from three tables, in this way, Table_1 has columns A,B,C supplies fields ( A,B, C) Table_2 has columns A,T,U supplies fields (T,U) Table_3 has columns A,B,C,X,Y,Z supplies fields (X,Y,Z) Table_1 and table_2 have a strange relationship with each other, one row in table_3 could match with a number of rows in table_1 if table_1.A = table_3.A and table_1.B=table_3.B and (table_1.C=table_3.C or table_3.C = *). That's what I can't get to work. I worked on this on MSSQL and wrote a query that does the above but I cannot find the equivalent query for it in MySQL. For I've split the query in two parts and put the results back together in my application. But I would look at DBTools and see if I can learn something from it. Thanks again for you advice. [EMAIL PROTECTED] wrote: Once you understand the logic of joins the rest is pretty straightforward, since in terms of execution the sequence in which you do the joins is irrelevant. (Performance is another issue, quickly resolved by specifying the smallest tables first.) Supposing that you have tables Products, Suppliers and Categories, which Products having foreign keys referencing Suppliers and Categories... SELECT ProductID, ProductName, SupplierID, SupplierName, CategoryID, CategoryName FROM Products INNER JOIN Suppliers ON Products.SupplierID = Suppliers.SupplierID INNER JOIN Categories ON Products.CategoryID = Categories.CategoryID; You can just keep building up such a query according to the number of tables you need to drag into the operation. Given the above query, you may well want to change the order of table references, but that doesn't intrude upon the logic and unless you have a very large number of rows in one or more tables, the performance difference will barely be noticeable. There are several GUI tools that let you perform multi-table selects using drag-and-drop techniques (c.f. DBTools, IMO one of the finest, with the added benefit that it remembers relatinships that you declare within it). Then you can inspect the code it writes and tweak it to suit using EXPLAIN. hth, Arthur - Original Message - From: damovand [EMAIL PROTECTED] To: mysql [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 12:31 PM Subject: Is there Examples and Documents on joining tables? Is there a document that compiles examples on different ways of joining two or more tables? I found a few on http://www.mysql.com/doc/en/JOIN.html but they do not cover joining more than two tables. Thanks for any suggestions. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Examples and Documents on joining tables?
corereader will help you do a pointclick join of up to four tables. you can operate corereader without it, but reading the documentation is strongly recommended. Is there a document that compiles examples on different ways of joining two or more tables? I found a few on http://www.mysql.com/doc/en/JOIN.html but they do not cover joining more than two tables. Thanks for any suggestions. -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.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: Is there Examples and Documents on joining tables?
Once you understand the logic of joins the rest is pretty straightforward, since in terms of execution the sequence in which you do the joins is irrelevant. (Performance is another issue, quickly resolved by specifying the smallest tables first.) Supposing that you have tables Products, Suppliers and Categories, which Products having foreign keys referencing Suppliers and Categories... SELECT ProductID, ProductName, SupplierID, SupplierName, CategoryID, CategoryName FROM Products INNER JOIN Suppliers ON Products.SupplierID = Suppliers.SupplierID INNER JOIN Categories ON Products.CategoryID = Categories.CategoryID; You can just keep building up such a query according to the number of tables you need to drag into the operation. Given the above query, you may well want to change the order of table references, but that doesn't intrude upon the logic and unless you have a very large number of rows in one or more tables, the performance difference will barely be noticeable. There are several GUI tools that let you perform multi-table selects using drag-and-drop techniques (c.f. DBTools, IMO one of the finest, with the added benefit that it remembers relatinships that you declare within it). Then you can inspect the code it writes and tweak it to suit using EXPLAIN. hth, Arthur - Original Message - From: damovand [EMAIL PROTECTED] To: mysql [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 12:31 PM Subject: Is there Examples and Documents on joining tables? Is there a document that compiles examples on different ways of joining two or more tables? I found a few on http://www.mysql.com/doc/en/JOIN.html but they do not cover joining more than two tables. Thanks for any suggestions. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: JOIN examples
Josh Trutwin wrote: SELECT table1.bunch, table2.of, table3.stuff FROM table1 INNER JOIN table2 ON table2.some_id INNER JOIN table3 ON table3.some_id WHERE table1.some_id = table2.some_id AND table1.some_id = table3.some_id; Your where is sort of in the wrong place ... SELECT table1.bunch, table2.of, table3.stuff FROM table1 INNER JOIN table2 ON table2.some_id = table1.some_id INNER JOIN table3 ON table3.some_id = table1.some_id; ... or, for a more concrete example (if a tad contrived) ... SELECT PhoneNumbers.Number as FaxNumber FROM Customers LEFT JOIN CustomerPhoneNumbers ON CustomerPhoneNumbers.CustomerID = Customers.ID LEFT JOIN PhoneNumbers ON PhoneNumbers.ID = CustomerPhoneNumbers.PhoneNumberID WHERE CustomerPhoneNumbers.Type = 'fax' AND Customers.ID = '443'; It would operate on data such as: Customers: { ID = 443 }, CustomerPhoneNumbers { CustomerID = 443, PhoneNumbersID = 272, Type = 'fax'; CustomerID = 443, PhoneNumbersID = 273, Type = 'phone' }, PhoneNumbers { ID = '272', Number = 555-1212; ID = '273', Number = 555-1213 } PS, I actually use this table structure for phone numbers, with great success. PPS, would you believe that message didn't pass the spam filter, since it checks for stupid things like SQL and QUERY? -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 Examples and Documents on joining tables?
Yes there are. First do as you have written, although your syntax is a bit wrong but the email compiler forgives such stuff :-) SELECT table1.bunch, table2.of, table3.stuff FROM table1 INNER JOIN table2 ON table2.some_id INNER JOIN table3 ON table3.some_id WHERE table1.some_id = table2.some_id AND table1.some_id = table3.some_id; should have been: SELECT table1.bunch, table2.of, table3.stuff FROM table1 INNER JOIN table2 ON table2.some_id = table1.FK INNER JOIN table3 ON table3.some_id = table1.FK WHERE table1.some_id = table2.some_id AND table1.some_id = table3.some_id; IMO you confuse the logic if you combine joins with wheres. You make it very hard to understand what's occurring and even harder to debug it. Store all your join logic in the join clauses, then reserve the where for precisely what you mean. For example: SELECT Table1.Stuff INNER JOIN Table2 ON Table1.FK = Table2.PK INNER JOIN Table3 ON Table2.FK = Table3.PK (etc.) WHERE Table1.PK = myVar In this sort of construction, the logic is far more apparent than in a construction which blurs the joins and wheres. Just my $.02. Arthur - Original Message - From: Josh Trutwin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 3:57 PM Subject: Re: Is there Examples and Documents on joining tables? Is there a document that compiles examples on different ways of joining two or more tables? I found a few on http://www.mysql.com/doc/en/JOIN.html but they do not cover joining more than two tables. Thanks for any suggestions. I wish there were more examples as well! I use this for multi-table joins: SELECT table1.bunch, table2.of, table3.stuff FROM table1 INNER JOIN table2 ON table2.some_id INNER JOIN table3 ON table3.some_id WHERE table1.some_id = table2.some_id AND table1.some_id = table3.some_id; Not sure if this the best way or not, but it works... Anyone with more experience care to contribute? Are there optimum ways to join multiple tables? Josh - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InnoDB hard lockup
Wayne, the bug found and fixed. If SHOW INNODB STATUS or innodb_monitor printed several hundred transactions, and the output was truncated, it forgot to release the 'kernel' mutex, causing the hang. Also the main thread was hung. That is why it claimed to be doing a background table drop. The bug will be fixed in 3.23.53 and 4.0.5. Until then do not use SHOW INNODB STATUS, innodb_monitor, or innodb_lock_monitor if you have hundreds of concurrent connections to the server. Thank you for the detailed bug report, Heikki Innobase Oy ChangeSet 1.1208 02/10/03 23:07:32 [EMAIL PROTECTED] +1 -0 lock0lock.c: Fix bug: if SHOW INNODB STATUS or innodb_monitor printed several hundred transactions, the output was truncated and we forgot to release the kernel mutex innobase/lock/lock0lock.c 1.17 02/10/03 23:07:18 [EMAIL PROTECTED] +20 -0 Fix bug: if SHOW INNODB STATUS or innodb_monitor printed several hundred transactions, the output was truncated and we forgot to release the kernel mutex # This is a BitKeeper patch. What follows are the unified diffs for the # set of deltas contained in the patch. The rest of the patch, the part # that BitKeeper cares about, is below these diffs. # User: heikki # Host: hundin.mysql.fi # Root: /home/heikki/mysql --- 1.16/innobase/lock/lock0lock.c Tue Oct 1 13:47:39 2002 +++ 1.17/innobase/lock/lock0lock.c Thu Oct 3 23:07:18 2002 @@ -3599,6 +3599,8 @@ mtr_t mtr; if (buf_end - buf 600) { + sprintf(buf, ... output truncated!\n); + return; } @@ -3623,6 +3625,9 @@ if ((ulint)(buf_end - buf) 100 + strlen(lock_latest_err_buf)) { + lock_mutex_exit_kernel(); + sprintf(buf, ... output truncated!\n); + return; } @@ -3630,6 +3635,9 @@ } if (buf_end - buf 600) { + lock_mutex_exit_kernel(); + sprintf(buf, ... output truncated!\n); + return; } @@ -3641,6 +3649,9 @@ while (trx) { if (buf_end - buf 900) { + lock_mutex_exit_kernel(); + sprintf(buf, ... output truncated!\n); + return; } @@ -3678,6 +3689,9 @@ } if (buf_end - buf 900) { + lock_mutex_exit_kernel(); + sprintf(buf, ... output truncated!\n); + return; } @@ -3688,6 +3702,9 @@ buf += strlen(buf); if (buf_end - buf 500) { + lock_mutex_exit_kernel(); + sprintf(buf, ... output truncated!\n); + return; } @@ -3742,6 +3759,9 @@ } if (buf_end - buf 500) { + lock_mutex_exit_kernel(); + sprintf(buf, ... output truncated!\n); + return; } - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 9:09 PM Subject: Re: InnoDB hard lockup Wayne, please send me the whole MySQL error log. Looks like some thread, which had reserved the InnoDB 'kernel' mutex to access the InnoDB lock table, got stuck. This is interesting: 5 queries inside InnoDB, 0 queries in queue; main thread: doing background drop tables If you drop a table where there still are queries running, then InnoDB delays the drop table until the queries have ended, and only after that drops the table. When dropping the table, InnoDB has to remove also any locks there are on the table. The code is not that well tested. The bug might be there. What DROP TABLE and what queries could have been involved? Do you have very many tables? Does SHOW TABLE STATUS take long? Are you sure you ran innodb_monitor and not innodb_lock_monitor? Can you repeat the bug? Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB Copied message: .. Subject: InnoDB hard lockup From: Wayne Lewis Date: Thu, 3 Oct 2002 08:48:26 -0700 -- -- Hi All, First thanks to all who worked on InnoDB, it is truely exciting to get its features in an open-source DB. We've had an excellent experience thus far with a few exceptions. Any help on solving the problem below is greatly appreciated ... We experienced a hard lockup a few days ago with mysql-max-3.23.52 for Solaris 2.7. The DB had been running very well for over a month until the innodb_monitor was turned on. After turning it on, all InnoDB threads blocked within a few minutes, and we saw the messages below in the error log. The only other info that may seem relevent is that we have a monitor that executes show table status every 15 minutes to check for remaining space in the InnoDB tablespace. That monitor does not run in our test environment and we never had a problem with the innodb monitor in our test environment while executing a similar workload. So this problem may be correlated or caused by the show table status command in conjunction with the innodb monitor. Any thoughts? - Before posting, please check: http://www.mysql.com/manual.php (the
Re: Is there Examples and Documents on joining tables?
Josh Trutwin wrote: SELECT table1.bunch, table2.of, table3.stuff FROM table1 INNER JOIN table2 ON table2.some_id INNER JOIN table3 ON table3.some_id WHERE table1.some_id = table2.some_id AND table1.some_id = table3.some_id; Your where is sort of in the wrong place ... SELECT table1.bunch, table2.of, table3.stuff FROM table1 INNER JOIN table2 ON table2.some_id = table1.some_id INNER JOIN table3 ON table3.some_id = table1.some_id; ... or, for a more concrete example (if a tad contrived) ... Odd, the example I typed was from a working, albeit slow example. Maybe that's why the performance of that query is so dang slow. Thanks for the examples, this is great stuff for my archives. Looks like I have some work to do... Josh SELECT PhoneNumbers.Number as FaxNumber FROM Customers LEFT JOIN CustomerPhoneNumbers ON CustomerPhoneNumbers.CustomerID = Customers.ID LEFT JOIN PhoneNumbers ON PhoneNumbers.ID = CustomerPhoneNumbers.PhoneNumberID WHERE CustomerPhoneNumbers.Type = 'fax' AND Customers.ID = '443'; It would operate on data such as: Customers: { ID = 443 }, CustomerPhoneNumbers { CustomerID = 443, PhoneNumbersID = 272, Type = 'fax'; CustomerID = 443, PhoneNumbersID = 273, Type = 'phone' }, PhoneNumbers { ID = '272', Number = 555-1212; ID = '273', Number = 555-1213 } PS, I actually use this table structure for phone numbers, with great success. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Slave server and InnoDB
James, - Original Message - From: James Kelty [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Friday, October 04, 2002 12:13 AM Subject: Slave server and InnoDB sql,query Hello. Is there an option for the slave server to NOT stop when an error inducing query is run on the master? For instance, if someone tries in insert a duplicate entry, and the master shows the error, but updates the binlog, how can I keep the slave from seeing the same error, and NOT stopping itself? only successful queries are written to the binlog and replicated. It is a bug in MySQL replication if a duplicate key error in the master is propagated to the slave. Thanks! -James Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Multi-table Join (WAS: Is there Examples and Documents on joining tables?)
Here is the query that I had in a PhP script that joins a bunch of tables (I'll try to make this look readable). If you're curious, it's for a motorcross site (www.springcreekmx.com): SELECT standings.rank, race.race_date, class.class_name, racer.racer_name, cycle.cycle_desc, race_event.racer_id, race_event.points_earned, race_event.racing_number, race_event.overall_rank, race_event.round, standings.total_points FROM race_event INNER JOIN racer ON racer.racer_id INNER JOIN standings ON standings.racer_id INNER JOIN race ON race.round INNER JOIN class ON class.class_id INNER JOIN cycle ON cycle.cycle_id WHERE race_event.racing_cycle = cycle.cycle_id AND race_event.class_id = class.class_id AND race.round = race_event.round AND race.series_id = race_event.series_id AND race.class_id = race_event.class_id AND standings.racer_id = racer.racer_id AND standings.class_id = race_event.class_id AND standings.series_id = race_event.series_id AND race_event.racer_id = racer.racer_id AND race_event.class_id = '2' ORDER BY rank, race_date; This syntax actually works, from the posts it sounds like I might be getting away with one. So, from the posts regarding table joins, this would be correctly written as: SELECT standings.rank, race.race_date, class.class_name, racer.racer_name, cycle.cycle_desc, race_event.racer_id, race_event.points_earned, race_event.racing_number, race_event.overall_rank, race_event.round, standings.total_points FROM race_event INNER JOIN racer ON racer.racer_id = race_event.racer_id INNER JOIN standings ON standings.racer_id = racer.racer_id AND standings.class_id = race_event.class_id AND standings.series_id = race_event.series_id INNER JOIN race ON race.round = race_event.round AND race.series_id = race_event.series_id AND race.class_id = race_event.class_id INNER JOIN class ON class.class_id = race_event.class_id INNER JOIN cycle ON cycle.cycle_id = race_event.racing_cycle WHERE race_event.class_id = '$class_search' ORDER BY rank, race_date; Looks much nicer, doesn't seem to be a dramatic increase in performance, but I think it makes more sense this way. Does this look ok? The size of tables (smallest to largest) is series, cycle, class, race, racer, standings, race_event. I re-ordered the INNER JOINS to join on the smallest table like so: SELECT standings.rank, race.race_date, class.class_name, racer.racer_name, cycle.cycle_desc, race_event.racer_id, race_event.points_earned, race_event.racing_number, race_event.overall_rank, race_event.round, standings.total_points FROM series INNER JOIN cycle ON cycle.cycle_id = race_event.racing_cycle INNER JOIN class ON class.class_id = race_event.class_id INNER JOIN race ON race.round = race_event.round AND race.series_id = race_event.series_id AND race.class_id = race_event.class_id INNER JOIN racer ON racer.racer_id = race_event.racer_id INNER JOIN standings ON standings.racer_id = racer.racer_id AND standings.class_id = race_event.class_id AND standings.series_id = race_event.series_id INNER JOIN race_event ON series.series_id = race_event.series_id WHERE race_event.class_id = '$class_search' ORDER BY rank, race_date The first query averages about 0.085 seconds from the mysql prompt, the second about 0.075 seconds and the 3rd 0.065 seconds. Thanks for some great advice, this has been bugging me for a while! Josh - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 Examples and Documents on joining tables?
Thanks John, I looked through your web site, it seems to me that corereader is microsoft based product. I'm on Linux RedHat 7.2. thanks [EMAIL PROTECTED] wrote: corereader will help you do a pointclick join of up to four tables. you can operate corereader without it, but reading the documentation is strongly recommended. Is there a document that compiles examples on different ways of joining two or more tables? I found a few on http://www.mysql.com/doc/en/JOIN.html but they do not cover joining more than two tables. Thanks for any suggestions. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 Examples and Documents on joining tables?
Send me create-table scripts and population scripts and I'll do this for you. But on rereading your message I'm guessing that your normalization is wrong. You have more than one multi-valued dependency. Your example description is either wrong or insufficient. T1 (presumably the parent of all parents) has a PK of let's say A. T2 has an FK into T1 := A. T3 should not have any trace of A or B or C, all of which are derivable. I hope this won't strike you as pedantic, but you get into severe problems when you store multiple multi-valued keys in any given table. This is the difference between 3NF and 4NF+BCNF. Jargon aside, suppose the following: T1 = Customers, with columns CityID, RegionID and CountryID Should you choose this model, you either: a) force the front end to intelligently preclude absurd options; or b) face the prospect of such entries as Toronto, New York, Japan. IMO this is obviously incorrect. The most you need to store is the least you need to store. Instead of this method, consider a cascading alternative: Cities -= Regions -= Counties All you need to store in this model is the CityID, since this is enough to distinguish Springfield, Ohio from Springield, Nebraska. a) you don't need to carry the cascading FKs and b) they are counterproductive even should you choose to carry them, for they either permit nonsense or you force the front end to carry mucho additional logic that is not properly part of the front end. Instead consider intelligent multi-table queries that retrieve for example Vancouver, BC, Canada and Vancouver, WA, USA. This makes your front end smarter and your back end more resilient. Examples of this are abundant. A front end that permits you to transfer employee 123 from department 234 to department 234 are IMO bad, beneath consideration of serious programming. We have to be a lot smarter than that. Given a screen that allows employee-transfer, the least it could do is preclude transfer to the same department! Lest I sound like some proselitizer, I only do so because I have made this mistake a dozen times and paid the price. At this late stage in the game, I now fully appreciate the virtues of BCNF+4NF and hope never to make this mistakes again. Normalize to the max and you're guaranteed to be correct. Codd is no fool. He is a genious and the more you read him the more sense he makes. I wish I were an order of magnitude close to his perceptions. I look back on my errors and realize I should have read him more closely, and obeyed his edicts even if I couldn't comprehend them at the time! - Original Message - From: damovand [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: mysql [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 8:08 PM Subject: Re: Is there Examples and Documents on joining tables? Hi Arthur, Thanks for your answer and your example. Your example is very good but I can't map to what I'm trying to do. As you suggested I have to understand how inner join is implemented in MySQL. The query that I'm working on selects fields from three tables, in this way, Table_1 has columns A,B,C supplies fields ( A,B, C) Table_2 has columns A,T,U supplies fields (T,U) Table_3 has columns A,B,C,X,Y,Z supplies fields (X,Y,Z) Table_1 and table_2 have a strange relationship with each other, one row in table_3 could match with a number of rows in table_1 if table_1.A = table_3.A and table_1.B=table_3.B and (table_1.C=table_3.C or table_3.C = *). That's what I can't get to work. I worked on this on MSSQL and wrote a query that does the above but I cannot find the equivalent query for it in MySQL. For I've split the query in two parts and put the results back together in my application. But I would look at DBTools and see if I can learn something from it. Thanks again for you advice. [EMAIL PROTECTED] wrote: Once you understand the logic of joins the rest is pretty straightforward, since in terms of execution the sequence in which you do the joins is irrelevant. (Performance is another issue, quickly resolved by specifying the smallest tables first.) Supposing that you have tables Products, Suppliers and Categories, which Products having foreign keys referencing Suppliers and Categories... SELECT ProductID, ProductName, SupplierID, SupplierName, CategoryID, CategoryName FROM Products INNER JOIN Suppliers ON Products.SupplierID = Suppliers.SupplierID INNER JOIN Categories ON Products.CategoryID = Categories.CategoryID; You can just keep building up such a query according to the number of tables you need to drag into the operation. Given the above query, you may well want to change the order of table references, but that doesn't intrude upon the logic and unless you have a very large number of rows in one or more tables, the performance difference will barely be noticeable. There are several GUI tools that let you perform multi-table selects using drag-and-drop techniques (c.f.
RE: raid vs splitting the database
Hi, In my experience (assuming that you are using mysql for all of these operations) the best way is to separate your tables into read-heavy and write heavy and put each into separate databases. Put the write-heavy logs database onto a separate disk/spindle and use delayed inserts (so that the apps can carry on regardless). With the read-heavy tables, use raid and/or use heap tables and serve as much from memory as possible to get max performance. Hardcore Option: If you have heavy logging to a few tables lots of reads (but not many updates to those tables you're reading from) from lots of other tables (as I do..) use replication over a few machines for the read-heavy tables, do the all selects from there and also write the logs to those machines (but don't replicate the logs) then each day/month (do this at a quiet time...whenever/whatever suits you) dump all the logs to another machine for analysing purposes. This effects a rollover of logs and can be quite useful if you're writing lot's of logtables each day. Hope this helped, Andrew Sql,query -Original Message- From: Gary Traffanstedt [mailto:[EMAIL PROTECTED]] Sent: Thursday, 03 October 2002 21:27 To: [EMAIL PROTECTED] Subject: raid vs splitting the database sql, query I have a dilemma and maybe you can help. I'm wanting to improve my disk performance and I'm wondering if I should go with Raid 10 or if I should simply mirror the drives so that I have redundancy and then put some of my tables on one drive and some on the other. Or the third option is to put the tables on one drive and the logs on another drive. Ultimately, what is going to give me the best performance? Should I use 3 drives (mirrored so 6 actual drives) and put half of the tables on drive 1, half on drive 2, and logs on drive 3? TIA, Gary - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Slave server and InnoDB
On Fri, Oct 04, 2002 at 12:51:16AM +0300, Heikki Tuuri wrote: only successful queries are written to the binlog and replicated. It is a bug in MySQL replication if a duplicate key error in the master is propagated to the slave. Or someone accidentallly muged data on the slave. We've had that happen more than once. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 58 days, processed 1,224,114,821 queries (241/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
Replication issue in 4.0.4
We have a 4.0.4-beta master and slave. The slaving process starts correctly, but randomly (and frequently) has issues. When the server starts, it will slave, but eventually will hit one of two conditions: - Duplicate key insert error (we re-sync'd the slave by hand during the install, copying databases by hand, etc, so they're known good) - Signal 8. The database will hit Signal 8, die, and be restarted. Immediately upon restarting, it dies, and restarts, ad naseum. The Dupkicate Key insert doesn't have any decent or recognizable accompanying errors, however the signal 8 leaves the following in the logs: 021003 18:04:03 mysqld restarted /usr/local/libexec/mysqld: ready for connections 021003 18:04:03 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'dbmaster1-bin.002' at position 110748 mysqld got signal 8; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=402649088 read_buffer_size=1044480 sort_buffer_size=1048568 max_used_connections=0 max_connections=2500 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 130 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=0x82d4d00 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, fp=0x5c190f98, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x80940d7 0x81798fb 0x8095aa5 0x8056129 0x8057109 0x804b7d2 0x80b513a 0x80cd4ad 0x809f16d 0x80a2d8c 0x80db5a5 0x81183c6 0x8117147 0x8177394 0x81aa79a New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x82d0ba6 = UPDATE /* sess_read:update timestamp */ admin.login SET login.last_modified = NOW(), login.mumbojumbo = FLOOR(RAND()*) WHERE login.uid IN( 0, 27 ) AND login.session = 'fb103efea43b37b049cb1d54f400724d' thd-thread_id=2 Successfully dumped variables, if you ran with --log, take a look at the details of what thread 2 did to cause the crash. In some cases of really bad corruption, the values shown above may be invalid. The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains information that should help you find out what is causing the crash. Number of processes running now: 0 I have run a backtrace, and came up with the following: 0x80940d7 _Z15handle_segfaulti + 503 0x81798fb sem_timedwait + 95 0x8095aa5 rnd + 53 0x8056129 _ZN13Item_func_mul3valEv + 41 0x8057109 _ZN15Item_func_floor7val_intEv + 41 0x804b7d2 _ZN4Item13save_in_fieldEP5Field + 226 0x80b513a _Z11fill_recordR4ListI4ItemES2_ + 106 0x80cd4ad _Z12mysql_updateP3THDP13st_table_listR4ListI4ItemES6_PS4_P8st_orderm15enum_duplicates13thr_lock_type + 2093 0x809f16d _Z21mysql_execute_commandv + 4829 0x80a2d8c _Z11mysql_parseP3THDPcj + 300 0x80db5a5 _ZN15Query_log_event10exec_eventEP17st_relay_log_info + 293 0x81183c6 _Z22process_io_create_fileP14st_master_infoP21Create_file_log_event + 166 0x8117147 _Z10next_eventP17st_relay_log_info + 423 0x8177394 pthread_handle_free + 72 0x81aa79a __nss_lookup_function + 686 Reverting the slave to 4.0.3 fixed the instability AFAICT (it's only been reverted for a brief period). The master has remained at 4.0.4 Let me know if you need further info. Thanks -- Shane Allen [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
Archive of this mysql list
Is there an archive of all posts to this mysql list that I can search somewhere? Chris Becker MCDBA MCSE http://www.PrismSoftware.com [EMAIL PROTECTED] sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Archive of this mysql list
Yep, It's here http://www.mysql.com/documentation/searchlists.html Cheers, Andrew Sql,query -Original Message- From: Chris Becker [mailto:[EMAIL PROTECTED]] Sent: Friday, 04 October 2002 00:43 To: [EMAIL PROTECTED] Subject: Archive of this mysql list Is there an archive of all posts to this mysql list that I can search somewhere? Chris Becker MCDBA MCSE http://www.PrismSoftware.com [EMAIL PROTECTED] 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Archive of this mysql list
Ahem, have a look at the bottom of any post to the list: Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) :) HTH, William. -Original Message- From: Chris Becker [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 16:43 To: [EMAIL PROTECTED] Subject: Archive of this mysql list Is there an archive of all posts to this mysql list that I can search somewhere? Chris Becker MCDBA MCSE http://www.PrismSoftware.com [EMAIL PROTECTED] 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 moving database using mysqldump
Hello All; I am having a problem using the mysqldump application. I have an old server that I am trying to move to a faster machine. No matter what I do, about 90 queries in the connection ceases and the old meachine gets a server has gone away error. I have tries runnig mysql dump piped to the mysql client on the old machine with the client connecting across the network and on the new machine with mysqldump connecting across the network. I have also tried producing a file and then piping the file into mysql client on the new machine, but no success, always the new machine stops processing requests around the 90-100 query mark. Does anyone have any idea why this is happening? The file is about 40-50MB and the largest table in the database is only 110,000 rows, so this should not be straining the system. Thanks, Mike Hillyer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Problem with moving database using mysqldump
Hi, Some of the old mysqldump apps have a bug where they're missing quotes on long rows. Try the dump the other way - i.e. use the mysqldump client on the new machine and pipe it from the old machine back to the new machine (make sure the new machine has permissions to grab from the old one...). With something like: mysqldump -h oldmachine -u username olddatabase | mysql newdatabasename Cheers, Andrew Sql,query -Original Message- From: Mike Hillyer [mailto:[EMAIL PROTECTED]] Sent: Friday, 04 October 2002 01:25 To: MySQL Mailing List Subject: Problem with moving database using mysqldump Hello All; I am having a problem using the mysqldump application. I have an old server that I am trying to move to a faster machine. No matter what I do, about 90 queries in the connection ceases and the old meachine gets a server has gone away error. I have tries runnig mysql dump piped to the mysql client on the old machine with the client connecting across the network and on the new machine with mysqldump connecting across the network. I have also tried producing a file and then piping the file into mysql client on the new machine, but no success, always the new machine stops processing requests around the 90-100 query mark. Does anyone have any idea why this is happening? The file is about 40-50MB and the largest table in the database is only 110,000 rows, so this should not be straining the system. Thanks, Mike Hillyer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: RPM Install appears to have failed
Hi, Where is the Mysql-server version. you have installed only client and mysql-max, but no mysql-server. Use rpm -Uvh for your installations, so that you can easily know the progress of installation. regards, Praveen --- Chris Becker [EMAIL PROTECTED] wrote: RedHat6.2 install (everything) out of box on Intel 1 proc server 256mb ram. Downloaded 3.23.52-1 rpm client rpm to /usr/loca/tmp - i created the tmp folder as root and chmod 777 Followed the install instructions - which only included: To perform a standard minimal installation, run: shell rpm -i MySQL-VERSION.i386.rpm MySQL-client-VERSION.i386.rpm (No user or group or environment setup instructions before running rpm's???) So logged in as root I executed the following, and got the result below [root@plinux tmp]# rpm -i MySQL-Max-3.23.52-1.i386.rpm MySQL-client-3.23.52-1.i386.rpm Giving mysqld a couple of seconds to restart var/tmp/rpm-tmp.10346: /etc/rc.d/init.d/mysql: No such file or directory Was this successful? Where did mysql install to? The post installation steps say to: shell ./scripts/mysql_install_db shell cd mysql_installation_directory shell ./bin/safe_mysqld --user=mysql cd_mysql_installation_directory - where the heck did it install at? don't think this happened... thanks in advance. Chris Becker MCDBA MCSE http://www.PrismSoftware.com [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 __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL and ODBC prolbme
well - I can't telnet to that port, but I have a web server up running, and I cannot telnet to port 80 either, but my web browser does work. I am also connecting to it on port 3306 locally. - Original Message - From: Jeremy Tinley [EMAIL PROTECTED] To: 'Jeff Bluemel' [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 9:49 AM Subject: RE: MySQL and ODBC prolbme Nope, just telnet linuxhost 3306 Leave the telnet port alone. -J -Original Message- From: Jeff Bluemel [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 10:45 AM To: Jeremy Tinley Subject: Re: MySQL and ODBC prolbme ok - let me ask a question - I've got linux setup to listen for telnet sessions on port 23 - shoud I try to change that to port 3306? - Original Message - From: Jeremy Tinley [EMAIL PROTECTED] To: 'Jeff Bluemel' [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 9:26 AM Subject: RE: MySQL and ODBC prolbme Start with the basic network stuff. Can you ping the linux machine? Can you telnet to the linux machine on port 3306? Can you get to the linux machine on any other port? Can you get to the linux machine from another machine? The error doesn't appear to be a permissions error. It looks more like a network connection problem. -J -Original Message- From: Jeff Bluemel [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 9:50 AM To: Jeremy Tinley Subject: Re: MySQL and ODBC prolbme yes I can connect to mysql on the local machine (do it all the time), the linux box is the firewall / gateway, and there are no restrictions on the private IP range. - Original Message - From: Jeremy Tinley [EMAIL PROTECTED] To: 'Jeff Bluemel' [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 8:44 AM Subject: RE: MySQL and ODBC prolbme That's pretty vague.. is there a firewall between the two? Is MySQL running? Can you connect to MySQL locally on the Linux machine? -J -Original Message- From: Jeff Bluemel [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 9:11 AM To: [EMAIL PROTECTED] Subject: MySQL and ODBC prolbme I have mysql on a linux box (IP 192.168.0.1), and I've got a windows 2000 box that I am trying to connect to with with odbc. I am getting the following error message [MySQL AB][MyODBC] ERROR : Can't connect to MySQL server on 192.168.0.1 (10061) I'm not sure how to go about correcting this problem Jeff Bluemel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem with moving database using mysqldump
Hi Mike, I hope you are on linux machine, What are versions on old and new machines, is there any difference?. just tar the data dir /var/lib/mysql (in most of the cases) and untar on the new machines by moving the existing mysql directory by this old data. I don't think this will fail, I have done this procedure many times for the same versions, but never tried with different versions. regards, Praveen --- Mike Hillyer [EMAIL PROTECTED] wrote: Hello All; I am having a problem using the mysqldump application. I have an old server that I am trying to move to a faster machine. No matter what I do, about 90 queries in the connection ceases and the old meachine gets a server has gone away error. I have tries runnig mysql dump piped to the mysql client on the old machine with the client connecting across the network and on the new machine with mysqldump connecting across the network. I have also tried producing a file and then piping the file into mysql client on the new machine, but no success, always the new machine stops processing requests around the 90-100 query mark. Does anyone have any idea why this is happening? The file is about 40-50MB and the largest table in the database is only 110,000 rows, so this should not be straining the system. Thanks, Mike Hillyer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.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: RPM Install appears to have failed
Thanks Praveen, So Max is not a server version, it sure is difficult to determine that on the download page: MySQL database server standard clients: · MySQL 3.23 -- Stable release (recommended) latest version is 3.23.52 · · 3.23 -- Default package (use this if you are unsure) · · 3.23 Max -- Package with maximum features Should I now download 3.23 (Default pkg) and run the rpm, how will this affect what happened on my server below? Is there a way to un-install the client and Max? Or should I just install 3.23 and all will be better? Thanks again. Chris At 06:23 PM 10/3/2002 -0700, you wrote: Hi, Where is the Mysql-server version. you have installed only client and mysql-max, but no mysql-server. Use rpm -Uvh for your installations, so that you can easily know the progress of installation. regards, Praveen --- Chris Becker [EMAIL PROTECTED] wrote: RedHat6.2 install (everything) out of box on Intel 1 proc server 256mb ram. Downloaded 3.23.52-1 rpm client rpm to /usr/loca/tmp - i created the tmp folder as root and chmod 777 Followed the install instructions - which only included: To perform a standard minimal installation, run: shell rpm -i MySQL-VERSION.i386.rpm MySQL-client-VERSION.i386.rpm (No user or group or environment setup instructions before running rpm's???) So logged in as root I executed the following, and got the result below [root@plinux tmp]# rpm -i MySQL-Max-3.23.52-1.i386.rpm MySQL-client-3.23.52-1.i386.rpm Giving mysqld a couple of seconds to restart var/tmp/rpm-tmp.10346: /etc/rc.d/init.d/mysql: No such file or directory Was this successful? Where did mysql install to? The post installation steps say to: shell ./scripts/mysql_install_db shell cd mysql_installation_directory shell ./bin/safe_mysqld --user=mysql cd_mysql_installation_directory - where the heck did it install at? don't think this happened... thanks in advance. Chris Becker MCDBA MCSE http://www.PrismSoftware.com [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 __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.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 Chris Becker MCDBA MCSE http://www.PrismSoftware.com [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 Index Efficiency
I have a table with millions of records, lots of fields, and lots of indexes. It appears I break every rule for table efficiency...but there is a reason! I needed to do summarized data on *lots* of the fields at once, and the savings in time simplicity far outweigh any performance hits I may have come up against (which are few). However, I have a question on the best design for an index. Let's say I have three fields in particular I usually summarize the dataset with: Date, Country and CustomerType. Typically I would always query the table with a specific Date in mind (in -MM-DD format), but often I would also supply Country and/or CustomerType. Within a specific date range, Country would have less than a dozen variants, while CustomerType may have less. So a couple sample queries would be: Select Country,Sum(sales) From MyTable Where (Date'2002-01-01' and Date'2002-09-01') Group By Country Select CustomerType,Sum(sales) From MyTable Where (Date'2002-01-01' and Date'2002-09-01') Group By CustomerType Select CustomerType,Sum(sales) From MyTable Where (Date'2002-01-01' and Date'2002-09-01') And Country='Canada' Group By CustomerType If I understand the MySQL documentation correctly (and I probably don't!), the most efficient index would be to have indexes with Country and CustomerType listed first, since their values number far less than Date. This would mean indexes of: Date,Country Date,CustomerType Country,Date CustomerType,Date Country,CustomerType,Date CustomerType,Country,Date That seems like a lot to me. If I simply made Date the first entry on all it would be: Date,Country,CustomerType Date,CustomerType,Country But, as I said, would having the date first be efficient? Any thoughts would be appreciated! Aaron Fransen http://gomail.dynu.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
Fwd: Re: OT: Reply-Adress in this list
I did it again!!! -- Forwarded Message -- Subject: Re: OT: Reply-Adress in this list Date: Fri, 4 Oct 2002 10:31:28 +0800 From: Niclas Hedhman [EMAIL PROTECTED] To: Dan Nelson [EMAIL PROTECTED] On Thursday 03 October 2002 22:23, Dan Nelson wrote: In the last episode (Oct 03), Franz Alt said: When I reply, some lists set their list-adress automatically, some the adress of the person originally posting. The second version may not so good IMHO, because I think so many replies are not going to the lists. mysql++ and mysql do not automatically reply to the list mysql-de does. Use the reply-to-all or List-reply button, whichever Outlook has. Easier to say than remember if you have (like I do) 15 mailing lists and a couple of different behaviours. I don't care which becomes industry standard, as long as the behaviours converge, reducing what I have to remember. There is actually one good thing about replying to the list, instead of the individual; The list can manage to remove invalid email addresses and out-of-office replies (not that all lists do that, but could). Niclas --- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Reply-to munging
On Thursday 03 October 2002 22:33, Michael T. Babcock wrote: Franz Alt wrote: From one site: Reply-To munging does not benefit the user with a reasonable mailer. People want to munge Reply-To headers to make ``reply back to the list'' easy. But it already is easy. Reasonable mail programs have two separate ``reply'' commands: one that replies directly to the author of a message, and another that replies to the author plus all of the list recipients. Even the lowlyBerkeleyMail http://www.bsdi.com/bsdi-man/?Mail%281%29 command has had this for about a decade. Also: It, in fact, /decreases/functionality. Reply-To munging destroys the ``reply-to-author'' capability. Munging makes this command act effectively the same as the ``reply-to-group'' function. We haven't added anything new, we've only taken away. Reply-To munging is not merely benign, it is harmful. It renders a useful mail capability inoperative. I don't by the less functionality argument any more than if you have a good emailer. I think I have a good emailer, and on the munging lists, I press Reply-All, it will also send to the original author, but 95% of the case I want the list, and original author doesn't want two replies. PS, this has nothing to do with SQL or QUERIES ... :) Completely agree, have to change the implementation of the OT here. INSERT INTO MailingList ( Features ) VALUES ( 'Munge the Reply-To header.' ); My question is, can this made work at the lists.mysql.com DB? ;o) Better? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
WHERE clause efficiency
If I have a table, Name VARCHAR(100) L DOUBLE a DOUBLE b DOUBLE and execute the incredible SELECT * FROM Colors WHERE SQRT( SQ( ABS( L - 45.5 ) ) + SQ( ABS( a - 13.2 ) ) + SQ( ABS( b + 23.4 ) ) ) 2.5 ; Could MySQL benefit in any way by indexing the L,a,b fields? Or will it just plough through all the records one by one, anyway? Niclas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: RPM Install appears to have failed
Max is a server. your install directory out of an RPM should be /var/lib/mysql if you are root su to root and see if it's there. It should tell you this in /usr/share/doc/packages/Mysql thwere's a manual there or it should be. John Coder On Thu, 2002-10-03 at 21:55, Chris Becker wrote: Thanks Praveen, So Max is not a server version, it sure is difficult to determine that on the download page: MySQL database server standard clients: · MySQL 3.23 -- Stable release (recommended) latest version is 3.23.52 · · 3.23 -- Default package (use this if you are unsure) · · 3.23 Max -- Package with maximum features Should I now download 3.23 (Default pkg) and run the rpm, how will this affect what happened on my server below? Is there a way to un-install the client and Max? Or should I just install 3.23 and all will be better? Thanks again. Chris At 06:23 PM 10/3/2002 -0700, you wrote: Hi, Where is the Mysql-server version. you have installed only client and mysql-max, but no mysql-server. Use rpm -Uvh for your installations, so that you can easily know the progress of installation. regards, Praveen --- Chris Becker [EMAIL PROTECTED] wrote: RedHat6.2 install (everything) out of box on Intel 1 proc server 256mb ram. Downloaded 3.23.52-1 rpm client rpm to /usr/loca/tmp - i created the tmp folder as root and chmod 777 Followed the install instructions - which only included: To perform a standard minimal installation, run: shell rpm -i MySQL-VERSION.i386.rpm MySQL-client-VERSION.i386.rpm (No user or group or environment setup instructions before running rpm's???) So logged in as root I executed the following, and got the result below [root@plinux tmp]# rpm -i MySQL-Max-3.23.52-1.i386.rpm MySQL-client-3.23.52-1.i386.rpm Giving mysqld a couple of seconds to restart var/tmp/rpm-tmp.10346: /etc/rc.d/init.d/mysql: No such file or directory Was this successful? Where did mysql install to? The post installation steps say to: shell ./scripts/mysql_install_db shell cd mysql_installation_directory shell ./bin/safe_mysqld --user=mysql cd_mysql_installation_directory - where the heck did it install at? don't think this happened... thanks in advance. Chris Becker MCDBA MCSE http://www.PrismSoftware.com [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 __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.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 Chris Becker MCDBA MCSE http://www.PrismSoftware.com [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: WHERE clause efficiency
At 10:43 +0800 10/4/02, Niclas Hedhman wrote: If I have a table, Name VARCHAR(100) L DOUBLE a DOUBLE b DOUBLE and execute the incredible SELECT * FROM Colors WHERE SQRT( SQ( ABS( L - 45.5 ) ) + SQ( ABS( a - 13.2 ) ) + SQ( ABS( b + 23.4 ) ) ) 2.5 ; Could MySQL benefit in any way by indexing the L,a,b fields? Or will it just plough through all the records one by one, anyway? It has to read each row in order to evaluate the expression. An index will do you no good. How could it be otherwise? Niclas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: RPM Install appears to have failed
Your right - Max is a server, thank you. Directories you listed do not exist. That rpm is all honked up. Is there an UN-install flag for rpm? I would like to cleanly reverse what was done w/ the rpm and install from the binary, is this possible? The workaround provided below does not seem to be tested, before I cause any more damage I would like to clean the orig install up, if it even did anything... Thanks. Found this thread: Subject: MySQL-Max-3.23.52-1.i386.rpm is missing many files. From: alg Date: Sat, 21 Sep 2002 20:17:05 -0400 Description: I'm trying to install MySQL MAX 3.23.52 (MySQL, with transactions enabled). My rpm attempts goes like this... 1. Check for installed MySQL... [root@Zeke mysql]# rpm -q -a | fgrep -i mysql [root@Zeke mysql]# 2. Nothing, so I attempt an install... [root@Zeke mysql]# rpm -i MySQL-Max-3.23.52-1.i386.rpm Giving mysqld a couple of seconds to restart var/tmp/rpm-tmp.34280: /etc/rc.d/init.d/mysql: No such file or directory QUESTIONS 1. Why is the mysql start/stop script missing? 2. In addition, OTHER FILES are missing, as compared to the tar/gzip binary: mysql-max-3.23.52-pc-linux-gnu-i686.tar.gz Thanks in advance. /AL How-To-Repeat: 1. Download the Intel Linux RPM file: MySQL-Max-3.23.52-1.i386.rpm 2. su as root 3. rpm -i MySQL-Max-3.23.52-1.i386.rpm 4. See the error /etc/rc.d/init.d/mysql: No such file or directory Fix: BETTER FIX: 1. Re-build the rpm file for MySQL-Max-3.23.52 2. While you guys are at it, provide the rpm for the other modules (ask RedHat for help on this, if necessary). If you want me to do some of the work, I'll volunteer the time. ... Just give me some RH linux box to login to. ... I have only 1 box at home, which I use to support my consulting clients, so I can't fool around with the box too much. WORKAROUND: 1. Install the RPM file, in spite of its problems: MySQL-Max-3.23.52-1.i386.rpm 2. Install tar/gzip file: mysql-max-3.23.52-pc-linux-gnu-i686.tar.gz ...This way, other rpm files that depend on MySQL-Max-3.23.52-1 won't have problems (assuming that they are properly installed). Submitter-Id: [EMAIL PROTECTED] Originator:alg Organization: Al G, WowSignal.Com MySQL support: none Synopsis: MySQL-Max-3.23.52-1.i386.rpm is missing many files. Severity: serious Priority: medium Category: mysql Class: change-request Release: mysql-3.23.52-max (Official MySQL-max binary) At 11:04 PM 10/3/2002 -0400, John Coder wrote: Max is a server. your install directory out of an RPM should be /var/lib/mysql if you are root su to root and see if it's there. It should tell you this in /usr/share/doc/packages/Mysql thwere's a manual there or it should be. John Coder On Thu, 2002-10-03 at 21:55, Chris Becker wrote: Thanks Praveen, So Max is not a server version, it sure is difficult to determine that on the download page: MySQL database server standard clients: · MySQL 3.23 -- Stable release (recommended) latest version is 3.23.52 · · 3.23 -- Default package (use this if you are unsure) · · 3.23 Max -- Package with maximum features Should I now download 3.23 (Default pkg) and run the rpm, how will this affect what happened on my server below? Is there a way to un-install the client and Max? Or should I just install 3.23 and all will be better? Thanks again. Chris At 06:23 PM 10/3/2002 -0700, you wrote: Hi, Where is the Mysql-server version. you have installed only client and mysql-max, but no mysql-server. Use rpm -Uvh for your installations, so that you can easily know the progress of installation. regards, Praveen --- Chris Becker [EMAIL PROTECTED] wrote: RedHat6.2 install (everything) out of box on Intel 1 proc server 256mb ram. Downloaded 3.23.52-1 rpm client rpm to /usr/loca/tmp - i created the tmp folder as root and chmod 777 Followed the install instructions - which only included: To perform a standard minimal installation, run: shell rpm -i MySQL-VERSION.i386.rpm MySQL-client-VERSION.i386.rpm (No user or group or environment setup instructions before running rpm's???) So logged in as root I executed the following, and got the result below [root@plinux tmp]# rpm -i MySQL-Max-3.23.52-1.i386.rpm MySQL-client-3.23.52-1.i386.rpm Giving mysqld a couple of seconds to restart var/tmp/rpm-tmp.10346: /etc/rc.d/init.d/mysql: No such file or directory Was this successful? Where did mysql install to? The post installation steps say to: shell ./scripts/mysql_install_db
RE: Reply-to munging
I don't by the less functionality argument any more than if you have a good emailer. I think I have a good emailer, and on the munging lists, I press Reply-All, it will also send to the original author, but 95% of the case I want the list, and original author doesn't want two replies. PS, this has nothing to do with SQL or QUERIES ... :) My opinion on this is that if I have a question, and I've exhausted the archive, and google, and my reference manuals, and my magic 8-ball, then I'm more than happy to get a duplicate answer - even though it's the exact same answer. Plus, sometimes I send people I'm helping via a list more information to their private address. Just because one person want's a 3mb attachment doesn't mean everyone on the list want's it. My 2 cents... William. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Create table if not exists from mysqldump?
Hi, I am trying to use mysqldump to dump the structure of a single database and want the output to make create table commands that include the IF NOT EXISTS switch so that when the file is imported into an existing database it does not write over tables with the same name. Does anyone know if this is possible with mysqldump and if so what option achieves this? 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: RPM Install appears to have failed
On Thu, 2002-10-03 at 23:26, Chris Becker wrote: Your right - Max is a server, thank you. Directories you listed do not exist. That rpm is all honked up. Is there an UN-install flag for rpm? I would like to cleanly reverse what was done w/ the rpm and install from the binary, is this possible? The workaround provided below does not seem to be tested, before I cause any more damage I would like to clean the orig install up, if it even did anything... Thanks. I beleive the command is rpm -e package -e for erase I assume John Coder Found this thread: Subject: MySQL-Max-3.23.52-1.i386.rpm is missing many files. From: alg Date: Sat, 21 Sep 2002 20:17:05 -0400 Description: I'm trying to install MySQL MAX 3.23.52 (MySQL, with transactions enabled). My rpm attempts goes like this... 1. Check for installed MySQL... [root@Zeke mysql]# rpm -q -a | fgrep -i mysql [root@Zeke mysql]# 2. Nothing, so I attempt an install... [root@Zeke mysql]# rpm -i MySQL-Max-3.23.52-1.i386.rpm Giving mysqld a couple of seconds to restart var/tmp/rpm-tmp.34280: /etc/rc.d/init.d/mysql: No such file or directory QUESTIONS 1. Why is the mysql start/stop script missing? 2. In addition, OTHER FILES are missing, as compared to the tar/gzip binary: mysql-max-3.23.52-pc-linux-gnu-i686.tar.gz Thanks in advance. /AL How-To-Repeat: 1. Download the Intel Linux RPM file: MySQL-Max-3.23.52-1.i386.rpm 2. su as root 3. rpm -i MySQL-Max-3.23.52-1.i386.rpm 4. See the error /etc/rc.d/init.d/mysql: No such file or directory Fix: BETTER FIX: 1. Re-build the rpm file for MySQL-Max-3.23.52 2. While you guys are at it, provide the rpm for the other modules (ask RedHat for help on this, if necessary). If you want me to do some of the work, I'll volunteer the time. ... Just give me some RH linux box to login to. ... I have only 1 box at home, which I use to support my consulting clients, so I can't fool around with the box too much. WORKAROUND: 1. Install the RPM file, in spite of its problems: MySQL-Max-3.23.52-1.i386.rpm 2. Install tar/gzip file: mysql-max-3.23.52-pc-linux-gnu-i686.tar.gz ...This way, other rpm files that depend on MySQL-Max-3.23.52-1 won't have problems (assuming that they are properly installed). Submitter-Id: [EMAIL PROTECTED] Originator:alg Organization: Al G, WowSignal.Com MySQL support: none Synopsis: MySQL-Max-3.23.52-1.i386.rpm is missing many files. Severity: serious Priority: medium Category: mysql Class: change-request Release: mysql-3.23.52-max (Official MySQL-max binary) Chris Becker MCDBA MCSE http://www.PrismSoftware.com [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
connecting to mysql database from php...
hi all: i am attempting to connect to a mysql database from php, using the following syntax in the php: $dsn = mysql://webuser@localhost/doug ; $db = DB::connect( $dsn ) ; if ( DB::isError($db) ) { print $dsn.\n ; die( $db-getMessage().\n ) ; } i get this message: mysql://webuser@localhost/doug DB Error: no such database any suggestions would be greatly appreciated. -- regards, allen wayne best, esq your friendly neighborhood rambler owner my rambler will go from 0 to 105 Current date: 8:2:21::275:2002 For a holy stint, a moth of the cloth gave up his woolens for lint. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
key blocks
How would one go about changing the key block size for a table/database/server? As I understand it, key blocks are 1024 bytes (1k) by default. I am creating an ext2 partition with 16k blocks for a database with tens of millions of records and would like to optimize the key block size to the fs block size for optimal index usage. I can't seem to find any information about changing this value. D. Walton sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: RE: how can I turn on query log on Windows? (mysql-3.23.38)
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, October 04, 2002 12:17 AM To: Dragos Madalin Popa Subject: Re: RE: how can I turn on query log on Windows? (mysql-3.23.38) Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. Thank You, Madalin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: WHERE clause efficiency
On Friday 04 October 2002 11:04, Paul DuBois wrote: At 10:43 +0800 10/4/02, Niclas Hedhman wrote: If I have a table, Name VARCHAR(100) L DOUBLE a DOUBLE b DOUBLE and execute the incredible SELECT * FROM Colors WHERE SQRT( SQ( ABS( L - 45.5 ) ) + SQ( ABS( a - 13.2 ) ) + SQ( ABS( b + 23.4 ) ) ) 2.5 ; Could MySQL benefit in any way by indexing the L,a,b fields? Or will it just plough through all the records one by one, anyway? It has to read each row in order to evaluate the expression. An index will do you no good. How could it be otherwise? Well, in WHERE L 2.5 an index can help, which is equal to WHERE L - 2.5 0, so how much formula reversion does it manage? None, some or a lot? SQRT( a + b + c ) 2.5 a + b + c 6.25 SQ( a' ) + SQ( b' ) + SQ( c' ) 6.25 is only true if and only if -2.5 a' 2.5, and -2.5 b' 2.5, and -2.5 c' 2.5 -2.5 ABS( a ) 2.5, means that a must be 0 a 2.5, and so on I can apply logic, since I am a thinking being, but I was wondering if MySQL was smart enough to do this in a generic formula reversal/optimization thing. I realize that I probably have to resort to custom code hooked into MySQL to do what I want in a really optimized way, but... Niclas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Help tunning a FreeBSD machine for postfix+mysql PLEASE!!
People, I'm running a postfix server with mysql on a FreeBSD machine. This mail server holds about 500 virtual domains and 6000 virtual accounts. Using the command mysql -e show processlist;|wc -l I get the current amount of mysql conns. It floats at about 150-200 simultaneous connections on mysql. When it hits 240 connections I get the error: ERROR 1135: Can't create a new thread (errno 35). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug This happens too often for a production machine. There are 2GB RAM, double-Xeon, 150GB RAID5, etc. For instance, we replicated mysql on another 2 machines, so we keep balancing the load by hand on those 3 machines. Each supports 240 mysql connections. I already have tweaked a little FreeBSD's kernel with the following: kern.osrelease: 4.6.2-RELEASE kern.maxusers: 512 kern.maxproc: 8212 kern.maxfiles: 131072 kern.maxfilesperproc: 65536 kern.maxprocperuid: 7390 kern.ipc.nmbclusters: 65536 kern.ipc.maxsockets: 65536 Also, I'm using softupdates and async on disks (SCSI Ultra-3 w/ hardware raid5). I have pulled kern.maxusers to 2048 but machine begun to crash, so I kept on 512. Any idea why? If anybody has any idea about how to increase the number of concurrent conns of mysql, please help me. I've searched mysql, freebsd and postfix sites, forums archives and could not find howto solve this. Please, this machine is in production and I must solve this to pull more 15.000 accounts into this machine! Any idea, help or anything will be appreciated. If you need more info, pelase ask. Thanks in advance. -- Marcio Merlone - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php