Re: InnoDB transactions with Connection Pooling
On Mon, Apr 22, 2002 at 09:02:54AM +0300, Heikki Tuuri wrote: Mark, if you do not explicitly do SET AUTOCOMMIT=0 then MySQL automatically calls COMMIT after every SQL statement. Make that: SET AUTOCOMMIT=1 Heikki is probably low on coffee. :-) Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 73 days, processed 1,941,489,847 queries (304/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Select with Order By that don't use my INDEX :(
- Original Message - From: MySQL Newsgroup @[EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, April 19, 2002 2:55 PM Subject: Re: Select with Order By that don't use my INDEX :( Subject: Re: Select with Order By that don't use my INDEX :( From: Vic Cekvenich [EMAIL PROTECTED] === Better yet, remove the order by. Make it sort by the index, ie, create an index that matches your select. Vic Dr. Frank Ullrich wrote: Can someone tell me more about this index that matches select ? My query is always different : explain SELECT * FROM Forums WHERE Field2=5020 AND Field3=0 ORDER BY Field4 DESC LIMIT 0,20; 1Field28000 like category number in fact ... Field4 is a datetime 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: Got an error reading communication packets ...
Gelu wrote: Hi, I know , sound strange.I life the same experience and my problem was , the first network switch, near the server machine(big responding time on the network - over 5.000 msec).What is was really oddly, not all the time the network have the same behaviour. The network interfaces , mounted on the server machine , can be influence by this behaviour.So, the client doesn't matter where is runnig (on the localhost or another host). Hi, 'really strange ... And do you have any solution for this ? Thanks for your answers and regards, @+ -- DouRiX Good luck, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Do-Risika RAFIEFERANTSIARONJY [EMAIL PROTECTED] To: Gelu [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, April 21, 2002 8:24 AM Subject: Re: Got an error reading communication packets ... Gelu wrote: Hi, Problems on the network.High risq for corrupting tables. What kind of network problem it should be because the clients are on the local machine. Regards, @+ -- DouRiX Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Do-Risika RAFIEFERANTSIARONJY [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, April 20, 2002 6:15 PM Subject: Got an error reading communication packets ... Hi all, Does somebody know what cause these errors ? (the option 'warnings' is turned on) It's debian 3.0, mysql 3.23.47-log, the application which use mysql are freeradius, postfix and courier (all in localhost). 020420 16:45:57 Aborted connection 172 to db: 'radius' user: 'radiusd' host: `localhost' (Got an error reading communication packets) 020420 16:45:57 Aborted connection 171 to db: 'radius' user: 'radiusd' host: `localhost' (Got an error reading communication packets) 020420 16:45:57 Aborted connection 170 to db: 'radius' user: 'radiusd' host: `localhost' (Got an error reading communication packets) 020420 16:45:57 Aborted connection 178 to db: 'radius' user: 'radiusd' host: `localhost' (Got an error reading communication packets) 020420 16:45:57 Aborted connection 177 to db: 'radius' user: 'radiusd' host: `localhost' (Got an error reading communication packets) 020420 16:45:57 Aborted connection 179 to db: 'radius' user: 'radiusd' host: `localhost' (Got an error reading communication packets) 020420 16:47:37 Aborted connection 165 to db: 'mail' user: 'smtpd' host: `simicro-193-251-140-214.simicro.net' (Got an error reading communication packets) 020420 16:47:37 Aborted connection 164 to db: 'mail' user: 'smtpd' host: `simicro-193-251-140-214.simicro.net' (Got an error reading communication packets) 020420 16:47:37 Aborted connection 166 to db: 'mail' user: 'smtpd' host: `simicro-193-251-140-214.simicro.net' (Got an error reading communication packets) 020420 16:47:38 Aborted connection 168 to db: 'mail' user: 'smtpd' host: `simicro-193-251-140-214.simicro.net' (Got an error reading communication packets) 020420 16:47:38 Aborted connection 167 to db: 'mail' user: 'smtpd' host: `simicro-193-251-140-214.simicro.net' (Got an error reading communication packets) 020420 16:50:23 Aborted connection 199 to db: 'mail' user: 'smtpd' host: `simicro-193-251-140-214.simicro.net' (Got an error reading communication packets) 020420 16:50:23 Aborted connection 198 to db: 'mail' user: 'smtpd' host: `simicro-193-251-140-214.simicro.net' (Got an error reading communication packets) Regards, -- Do-Risika RAFIEFERANTSIARONJY, SysAdmin mailto:[EMAIL PROTECTED] Simicro Internet, mailto:[EMAIL PROTECTED], http://internet.simicro.mg Tel : (+261) 20 22 648 83 (GMT +3), Fax : (+261) 20 22 661 83 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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-Risika RAFIEFERANTSIARONJY, SysAdmin mailto:[EMAIL PROTECTED] Simicro Internet, mailto:[EMAIL PROTECTED], http://internet.simicro.mg Tel : (+261) 20 22 648 83 (GMT +3), Fax : (+261) 20 22 661 83 - Before posting, please check:
MySQL, MyODBC and MS Access
Hello! You are my last chance, reading FAQs and asking in newsgroups gives no effect. I have a problem when connecting a MySQL table in MS Access (2000) through MyODBC. MySQL is ver. 3.23.44 running on FreeBSD 4.5 box. Description of the problem: I connect the table and Access correctly retrieves data. But when user tries to add data or to change any field, access performs an error box that some another user has changed this field when you were changing it, but actually nobody was connected to MySQL at that time. This problem takes place only in Windows'98. When I perform the same operation from Windows XP all is correct. Maybe I have to make some additional settings for MyODBC (version 2.50.39-win95) in Windows98? Please help. Thanks in advance! -- Alexandre Iakovlev System administrator of R D work group Lumex ltd. (www.lumex.ru) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
no subject
I try to compile mysql-2.23.49 but configure process stopped for an error: checking for termcap functions library... configure:error/No curses/termcap library found I have gcc 2.95.3, make 3.79.1 on linux ppc 2000 with 2.2.x linux kernel. Can you help me? Thanks Filippo Trocca - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 transactions with Connection Pooling
Jeremy, - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, April 22, 2002 9:37 AM Subject: Re: InnoDB transactions with Connection Pooling On Mon, Apr 22, 2002 at 09:02:54AM +0300, Heikki Tuuri wrote: Mark, if you do not explicitly do SET AUTOCOMMIT=0 then MySQL automatically calls COMMIT after every SQL statement. Make that: SET AUTOCOMMIT=1 MySQL has AUTOCOMMIT=1 as the default. Thus if you do not explicitly change the value with SET AUTOCOMMIT=0, then MySQL calls commit after each SQL statement. Heikki is probably low on coffee. :-) Jeremy, it is midnight there, morning here :). Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 73 days, processed 1,941,489,847 queries (304/sec. avg) Regards, Heikki - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Syntax error with merge tables
Hi! Eric == Eric Thelin [EMAIL PROTECTED] writes: Eric On Sat, 20 Apr 2002 [EMAIL PROTECTED] wrote: I always get a syntax error when using INSERT_METHOD in creating merge tables. If I leave off the INSERT_METHOD part it works fine. I have tried this on many versions in the past and now on 3.23.49a. I am running on Mandrake Linux 8.1 but have seen this same error on other linux distros. It is my understanding from reading the manual that the following should work but it doesn't. cut CREATE TABLE mytable ( aINTEGER NOT NULL PRIMARY KEY, bCHAR(18) NOT NULL ) TYPE=MERGE UNION=(mytable0, mytable1, mytable2) INSERT_METHOD=LAST; Since the .MRG files are plain text could someone send me what the INSERT_METHOD part is supposed to look like so I can do it manually if needed. Thanks. The problem is that INSERT_METHOD only works in MySQL 4.0, not in 3.23 If you need this feature, then you should download the MySQL 4.0.1 distribution and try this out. The MySQL 4.0 series has been out a while now and has in practice proven to be be quite stable.. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to speed up mods to large table?
Hi! Nick == Nick Arnett [EMAIL PROTECTED] writes: Nick I haven't been able to dig up any specific information about how to get Nick maximum performance when making changes to large tables. I have a table Nick that's close to 4 GB, which I'm altering to come up with the best trade-off Nick between performance and speed. Dropping a column or an index seems Nick exceedingly slow and I'm wondering what parameters matter for this. I'm Nick already using the highest-performance drive I can lay my hands on. What Nick else matters? MySQL currently almost always recreates the full index and data tables when you do an alter table (to be fixed in 4.1). To speed this up for MyISAM tables, you can set up the myisam_sort_buffer_size to a much larger value. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL, MyODBC and MS Access
Hi !! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 21, 2002 11:52 PM To: [EMAIL PROTECTED] Subject: MySQL, MyODBC and MS Access Hello! You are my last chance, reading FAQs and asking in newsgroups gives no effect. I have a problem when connecting a MySQL table in MS Access (2000) through MyODBC. MySQL is ver. 3.23.44 running on FreeBSD 4.5 box. Description of the problem: I connect the table and Access correctly retrieves data. But when user tries to add data or to change any field, access performs an error box that some another user has changed this field when you were changing it, but actually nobody was connected to MySQL at that time. This problem takes place only in Windows'98. When I perform the same operation from Windows XP all is correct. Maybe I have to make some additional settings for MyODBC (version 2.50.39-win95) in Windows98? Please help. Thanks in advance! You should set the OPTION=2. I think its listed in the FAQ too. Coming to XP, whats your Access version on XP ? (that might be a latest version, which has many fixes towards ODBC that exists in older versions :) Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
InnoDB, BDB
Hello, This question is probably repeated each week, but I am an absolute beginner with MySQL. Sorry for that. I've installed the precompiled binaries for Win, and I am very satisfied with MySQL. The only thing I couldn't find is support for transactions, although it was written in the documentation that support for BDB and InnoDB table types is activated in precompiled binaries. Is there something I've missed to configure (I've configured the necessary innodb_data_file_path and innodb_data_home_dir for InnoDB) or do I have to recompile MySQL with support for BDB and InnoDB activated? I've tried mysqld-max-nt and mysqld-max, but have_bdb and have_innodb variables were 'NO'. I use version 3.23.49. Thanks! Samim - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
functions
maybe i'm wishing on a star here. but is there any way that you can write functions for mysql to perform daily operations.. for example. at a certain time each day mysql automatically ran a query to delete records past a certain date.. ? dan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Got an error reading communication packets ...
Hi, In my case i replace the network switch(fault in power charge module). 'really strange ... ...and if we think about network mechanism(IP address mapping,network/broadcast ,) it seems it doesn't sound so weird. Good luck, Gelu - Original Message - From: Do-Risika RAFIEFERANTSIARONJY [EMAIL PROTECTED] To: Gelu [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, April 22, 2002 9:50 AM Subject: Re: Got an error reading communication packets ... Gelu wrote: Hi, I know , sound strange.I life the same experience and my problem was , the first network switch, near the server machine(big responding time on the network - over 5.000 msec).What is was really oddly, not all the time the network have the same behaviour. The network interfaces , mounted on the server machine , can be influence by this behaviour.So, the client doesn't matter where is runnig (on the localhost or another host). Hi, 'really strange ... And do you have any solution for this ? Thanks for your answers and regards, @+ -- DouRiX Good luck, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Do-Risika RAFIEFERANTSIARONJY [EMAIL PROTECTED] To: Gelu [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, April 21, 2002 8:24 AM Subject: Re: Got an error reading communication packets ... Gelu wrote: Hi, Problems on the network.High risq for corrupting tables. What kind of network problem it should be because the clients are on the local machine. Regards, @+ -- DouRiX Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Do-Risika RAFIEFERANTSIARONJY [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, April 20, 2002 6:15 PM Subject: Got an error reading communication packets ... Hi all, Does somebody know what cause these errors ? (the option 'warnings' is turned on) It's debian 3.0, mysql 3.23.47-log, the application which use mysql are freeradius, postfix and courier (all in localhost). 020420 16:45:57 Aborted connection 172 to db: 'radius' user: 'radiusd' host: `localhost' (Got an error reading communication packets) 020420 16:45:57 Aborted connection 171 to db: 'radius' user: 'radiusd' host: `localhost' (Got an error reading communication packets) 020420 16:45:57 Aborted connection 170 to db: 'radius' user: 'radiusd' host: `localhost' (Got an error reading communication packets) 020420 16:45:57 Aborted connection 178 to db: 'radius' user: 'radiusd' host: `localhost' (Got an error reading communication packets) 020420 16:45:57 Aborted connection 177 to db: 'radius' user: 'radiusd' host: `localhost' (Got an error reading communication packets) 020420 16:45:57 Aborted connection 179 to db: 'radius' user: 'radiusd' host: `localhost' (Got an error reading communication packets) 020420 16:47:37 Aborted connection 165 to db: 'mail' user: 'smtpd' host: `simicro-193-251-140-214.simicro.net' (Got an error reading communication packets) 020420 16:47:37 Aborted connection 164 to db: 'mail' user: 'smtpd' host: `simicro-193-251-140-214.simicro.net' (Got an error reading communication packets) 020420 16:47:37 Aborted connection 166 to db: 'mail' user: 'smtpd' host: `simicro-193-251-140-214.simicro.net' (Got an error reading communication packets) 020420 16:47:38 Aborted connection 168 to db: 'mail' user: 'smtpd' host: `simicro-193-251-140-214.simicro.net' (Got an error reading communication packets) 020420 16:47:38 Aborted connection 167 to db: 'mail' user: 'smtpd' host: `simicro-193-251-140-214.simicro.net' (Got an error reading communication packets) 020420 16:50:23 Aborted connection 199 to db: 'mail' user: 'smtpd' host: `simicro-193-251-140-214.simicro.net' (Got an error reading communication packets) 020420 16:50:23 Aborted connection 198 to db: 'mail' user: 'smtpd' host: `simicro-193-251-140-214.simicro.net' (Got an error reading communication packets) Regards, -- Do-Risika RAFIEFERANTSIARONJY, SysAdmin mailto:[EMAIL PROTECTED] Simicro Internet, mailto:[EMAIL PROTECTED], http://internet.simicro.mg Tel : (+261) 20 22 648 83 (GMT +3), Fax : (+261) 20 22 661 83 - Before posting, please check: http://www.mysql.com/manual.php (the manual)
Re: group by help?
You're right, it wasn't the answer I wanted to hear ;-) But it has a ring of truth to it. Thanks for all your help Mick Paul DuBois wrote: At 13:34 +0100 4/19/02, Mick Watson wrote: Thank you :-) I do realise the SQL is not being used as it should be, but as it is not my database and nor is it my SQL, there's not much I can do to really change either of these I merely have to work with a database that has been produced by a third party group, and I must say at this point that I have nothing but praise for the ensembl group for the difficult job that they have done very well (see http://www.ensembl.org) So, I realise this is not the problem of mySQL, but what I want to try and find out is really the internal workings of mySQL when it performs this operation so that I can understand why my copy of ensembl, which is produced from direct dumps of the main ensembl, behaves differently to the main ensembl. I guess you won't want to hear this, but that is completely the wrong approach. You *might* be able to achieve the same query output on both machines by dumping the database on one machine, then dropping and reloading the tables on both machines using the same copy of the dump. Then presumably both tables will have both records loaded in the same order, and the query *might* produce the same result on both machines. - ...until the table gets modified - ...until MySQL is upgraded on one machine and not the other, and something happens in the query optimizer that changes the query output - ...etc. The group you're working with *must* change the queries to be correct. Otherwise, you're entirely at the mercy of any number of external factors that can change the output and over which you have no control. I guess from what you are saying, that the data is stored randomly, that there is very little I can do to actually make my database behave the same as the main database? Could it be affected in any way by operating system and/or file system? Superficially the data is organised in exactly the same way in both databases, but I have no doubt that things like memory locations are completely different, but possibly if I could understand what the variables are that affect this behaviour I could minimise the inconsistancy...? Thanks for your time Mick Richard Emery wrote: mysql is acting correctly. GROUP BY is used to consolidate data for SUMming, COUNTing, etc. Your SELECT statement makes not such request. You have simply requested the value of a specific field. Data are stored in mysql databases randomly. Therefore, when you request a field's data, you are getting whatever is first in the list of records matching your WHERE clause. Bottom line: you are NOT using GROUP BY as it is supposed to be used. Your SQL is in error, not mysql. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
server disconnect
hi everybody, Can anyone tell whats wrong with the server..the connection to server disconnect automaticaly.we have to press refresh button again and again until the its show all the folders...is there anything wrong with installationcan anyone help me sql,query thanks in advance _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
New Setup
I thank anyone in advance who may be able to help me iron this out. 1. I am setting up mysql on my apache server. I have had it there for a while, but haven't really done much with getting my head round it. 2. I have figured out some shell commands, and have been able to set a root password. 3. I have also been able to use phpMyAdmin - which I had to modify to take into account the root password etc that is now in place. 4. I can create a database table using the phpMyAdmin forms - and it was relatively easy. However, when I go back to try and set up a new user who has permission to do a range of things on this database, (using shell now), I am given an error ERROR 1044: Access denied for user: 'root@localhost' to database 'cbaa' Shell command I am using mysql GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP - ON cbaa.* - TO cbaa@localhost - IDENTIFIED BY 'itsmeolord'; This seems strange to me, as I figured that root would have permission to do anything (even if it were 'inappropriate'. Any guidance would be appreciated. Ian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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, BDB
Samim, - Original Message - From: Samim [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Monday, April 22, 2002 11:31 AM Subject: InnoDB, BDB Hello, This question is probably repeated each week, but I am an absolute beginner with MySQL. Sorry for that. I've installed the precompiled binaries for Win, and I am very satisfied with MySQL. The only thing I couldn't find is support for transactions, although it was written in the documentation that support for BDB and InnoDB table types is activated in precompiled binaries. Is there something I've missed to configure (I've configured the necessary innodb_data_file_path and innodb_data_home_dir for InnoDB) or do I have to recompile MySQL with support for BDB and InnoDB activated? I've tried mysqld-max-nt and mysqld-max, but have_bdb and have_innodb variables were 'NO'. I use version 3.23.49. the following manual section is a guide to creating an InnoDB database. If you have already installed mysqld... as a service, stop the service from the Control Panel of Windows. Start mysqld-max.exe from an MS-DOS prompt as instructed below. 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 [mysqld] # You can write your other MySQL server options here # ... # innodb_data_home_dir = c:\ibdata #Data files must be able to #hold your data and indexes innodb_data_file_path = ibdata1:2000M;ibdata2:2000M #Set buffer pool size to 50 - 80 % #of your computer's memory set-variable = innodb_buffer_pool_size=70M set-variable = innodb_additional_mem_pool_size=10M innodb_log_group_home_dir = c:\iblogs #.._log_arch_dir must be the same #as .._log_group_home_dir innodb_log_arch_dir = c:\iblogs innodb_log_archive=0 set-variable = innodb_log_files_in_group=3 #Set the log file size to about #15 % of the buffer pool size set-variable = innodb_log_file_size=10M set-variable = innodb_log_buffer_size=8M #Set ..flush_log_at_trx_commit to #0 if you can afford losing #a few last transactions innodb_flush_log_at_trx_commit=1 set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 Note that InnoDB does not create directories: you have to create them yourself. Use the Unix or MS-DOS mkdir command to create the data and log group home directories. Check also that the MySQL server has the rights to create files in the directories you specify. Note that data files must be 2G in some file systems! The combined size of data files must be = 10 MB. The combined size of the log files must be 4G. If you do not specify innodb_data_home_dir, then the default is that InnoDB creates its data files to the datadir of MySQL. Then you cannot use absolute file paths in innodb_data_file_path. When you the first time create an InnoDB database, it is best that you start the MySQL server from the command prompt. Then InnoDB will print the information about the database creation to the screen, and you see what is happening. See below in section 3 what the printout should look like. For example, in Windows you can start mysqld-max.exe with: your-path-to-mysqldmysqld-max --standalone --console Where to put my.cnf or my.ini in Windows? The rules for Windows are the following: Only one of my.cnf or my.ini should be created. The my.cnf file should be placed in the root directory of the drive C:. The my.ini file should be placed in the WINDIR directory, e.g, C:\WINDOWS or C:\WINNT. You can use the SET command of MS-DOS to print the value of WINDIR. If your PC uses a boot loader where the C: drive is not the boot drive, then your only option is to use the my.ini file. Thanks! Samim - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
InnoDB and Fulltext Search
Hi, Quote from mysql online documentations: As of Version 4.0.1, MySQL can also perform boolean full-text searches using the IN BOOLEAN MODE modifierA boolean full-text search can also work even without a FULLTEXT index, although it would be slow. I know that InnoDB does not support FULLTEXT INDEXING but can i perform a fulltext search on an InnoDB table? I tried but it doesn't seem to work. The 'match... against()' returns a value of '-1'. Any idea? Thanx. ahk __ Do You Yahoo!? Yahoo! Messenger - Instant Messaging, Instant Gratification. (Now with new emoticons!) http://messenger.yahoo.com.sg/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 libmysqlclient_r.so
Hi, I use mysql++ And each object Connection use own MYSQL mysql; mysql_init called in Connection constructor. Hi, You use and two different mysql_init ? Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Andrey Kotrekhov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, April 21, 2002 4:55 PM Subject: problem with libmysqlclient_r.so Hello, All! I have program which try to connect to different mysql servers twice at the same time. When I use libmysqlclient.so sometimes one or two mysql connection freeze in mysql_real_connect But when I try to use libmysqlclient_r.so program crash in my_fopen this is stack of program : (gdb) bt #0 0x180ef7f2 in my_fopen () from /usr/local/mysql/lib/libmysqlclient_r.so.10 #1 0x180f0b20 in search_default_file () from /usr/local/mysql/lib/libmysqlclient_r.so.10 #2 0x180f085f in load_defaults () from /usr/local/mysql/lib/libmysqlclient_r.so.10 #3 0x180e776b in mysql_read_default_options () from /usr/local/mysql/lib/libmysqlclient_r.so.10 #4 0x180e8054 in mysql_real_connect () from /usr/local/mysql/lib/libmysqlclient_r.so.10 #5 0x1812f940 in MysqlConnection::real_connect (this=0x80c8c18, db=0x80fd8b0 kuku, host=0x80fa040 xxx.xxx.net, user=0x80fd910 test, passwd=0x80c1bca , port=3306, compress=1, connect_timeout=60, socket_name=0x80c1bde , client_flag=0) at connection.cc:52 #6 0x8082dc3 in QueueModule::Run (this=0x80c8c00) at QModule.cc:138 #7 0x8068a8f in start_Module (ptr=0x80c8c00) at Module.cc:23 #8 0x181fce73 in _thread_start () from /usr/lib/libc_r.so.4 #9 0x0 in ?? () (gdb) frame 5 #5 0x1812f940 in MysqlConnection::real_connect (this=0x80c8c18, db=0x80fd8b0 stat, host=0x80fa040 skynet.alkar.net, user=0x80fd910 stat, passwd=0x80c1bca , port=3306, compress=1, connect_timeout=60, socket_name=0x80c1bde , client_flag=0) at connection.cc:52 52 if (mysql_real_connect(mysql,host,user,passwd,db, port,socket_name,client_flag)) (gdb) p host $1 = (cchar *) 0x80fa040 xxx.xxx.net (gdb) p user $2 = (cchar *) 0x80fd910 test (gdb) p passwd $3 = (cchar *) 0x80c1bca (gdb) p db $4 = (cchar *) 0x80fd8b0 kuku (gdb) p port $5 = 3306 (gdb) p socket_name $6 = 0x80c1bde (gdb) p client_flag $7 = 0 (gdb) OS FreeBSD 4.4-RC mysql version 3.23.42, but I try to use 3.23.49 with the same effect Will anybody help me? 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 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
Re: problem with libmysqlclient_r.so
Hi, OK.I don't have(NULL) mysql++ experience.Anyway, i believe is something wrong with MYSQL structure initialisation(referencing pointer or some like that).I don't see other reason, considering mysql++ use functions from libmysqlclient too. Good luck, Gelu - Original Message - From: Andrey Kotrekhov [EMAIL PROTECTED] To: Gelu [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, April 22, 2002 12:30 PM Subject: Re: problem with libmysqlclient_r.so Hi, I use mysql++ And each object Connection use own MYSQL mysql; mysql_init called in Connection constructor. Hi, You use and two different mysql_init ? Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Andrey Kotrekhov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, April 21, 2002 4:55 PM Subject: problem with libmysqlclient_r.so Hello, All! I have program which try to connect to different mysql servers twice at the same time. When I use libmysqlclient.so sometimes one or two mysql connection freeze in mysql_real_connect But when I try to use libmysqlclient_r.so program crash in my_fopen this is stack of program : (gdb) bt #0 0x180ef7f2 in my_fopen () from /usr/local/mysql/lib/libmysqlclient_r.so.10 #1 0x180f0b20 in search_default_file () from /usr/local/mysql/lib/libmysqlclient_r.so.10 #2 0x180f085f in load_defaults () from /usr/local/mysql/lib/libmysqlclient_r.so.10 #3 0x180e776b in mysql_read_default_options () from /usr/local/mysql/lib/libmysqlclient_r.so.10 #4 0x180e8054 in mysql_real_connect () from /usr/local/mysql/lib/libmysqlclient_r.so.10 #5 0x1812f940 in MysqlConnection::real_connect (this=0x80c8c18, db=0x80fd8b0 kuku, host=0x80fa040 xxx.xxx.net, user=0x80fd910 test, passwd=0x80c1bca , port=3306, compress=1, connect_timeout=60, socket_name=0x80c1bde , client_flag=0) at connection.cc:52 #6 0x8082dc3 in QueueModule::Run (this=0x80c8c00) at QModule.cc:138 #7 0x8068a8f in start_Module (ptr=0x80c8c00) at Module.cc:23 #8 0x181fce73 in _thread_start () from /usr/lib/libc_r.so.4 #9 0x0 in ?? () (gdb) frame 5 #5 0x1812f940 in MysqlConnection::real_connect (this=0x80c8c18, db=0x80fd8b0 stat, host=0x80fa040 skynet.alkar.net, user=0x80fd910 stat, passwd=0x80c1bca , port=3306, compress=1, connect_timeout=60, socket_name=0x80c1bde , client_flag=0) at connection.cc:52 52 if (mysql_real_connect(mysql,host,user,passwd,db, port,socket_name,client_flag)) (gdb) p host $1 = (cchar *) 0x80fa040 xxx.xxx.net (gdb) p user $2 = (cchar *) 0x80fd910 test (gdb) p passwd $3 = (cchar *) 0x80c1bca (gdb) p db $4 = (cchar *) 0x80fd8b0 kuku (gdb) p port $5 = 3306 (gdb) p socket_name $6 = 0x80c1bde (gdb) p client_flag $7 = 0 (gdb) OS FreeBSD 4.4-RC mysql version 3.23.42, but I try to use 3.23.49 with the same effect Will anybody help me? 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 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: New Setup
Hi, Only the root with the '%' character on the host field from table mysql.user have full priveleges.Try to connect with -h option and specify the Host_Name of your server.Should be work. Eg: mysql -u root -h Your_Server_Name Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Ian Phillips [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 22, 2002 11:58 AM Subject: New Setup I thank anyone in advance who may be able to help me iron this out. 1. I am setting up mysql on my apache server. I have had it there for a while, but haven't really done much with getting my head round it. 2. I have figured out some shell commands, and have been able to set a root password. 3. I have also been able to use phpMyAdmin - which I had to modify to take into account the root password etc that is now in place. 4. I can create a database table using the phpMyAdmin forms - and it was relatively easy. However, when I go back to try and set up a new user who has permission to do a range of things on this database, (using shell now), I am given an error ERROR 1044: Access denied for user: 'root@localhost' to database 'cbaa' Shell command I am using mysql GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP - ON cbaa.* - TO cbaa@localhost - IDENTIFIED BY 'itsmeolord'; This seems strange to me, as I figured that root would have permission to do anything (even if it were 'inappropriate'. Any guidance would be appreciated. Ian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: New Setup
I think you have to use the -p option too and type your password because the GRANT statement specified a password mysql -u root -h Your_Server_Name -p Borus Hi, Only the root with the '%' character on the host field from table mysql.user have full priveleges.Try to connect with -h option and specify the Host_Name of your server.Should be work. Eg: mysql -u root -h Your_Server_Name Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Ian Phillips [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 22, 2002 11:58 AM Subject: New Setup I thank anyone in advance who may be able to help me iron this out. 1. I am setting up mysql on my apache server. I have had it there for a while, but haven't really done much with getting my head round it. 2. I have figured out some shell commands, and have been able to set a root password. 3. I have also been able to use phpMyAdmin - which I had to modify to take into account the root password etc that is now in place. 4. I can create a database table using the phpMyAdmin forms - and it was relatively easy. However, when I go back to try and set up a new user who has permission to do a range of things on this database, (using shell now), I am given an error ERROR 1044: Access denied for user: 'root@localhost' to database 'cbaa' Shell command I am using mysql GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP - ON cbaa.* - TO cbaa@localhost - IDENTIFIED BY 'itsmeolord'; This seems strange to me, as I figured that root would have permission to do anything (even if it were 'inappropriate'. Any guidance would be appreciated. Ian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: checksum errors
Resent, because of attachment problem. At 09:52 17-4-2002, Michael Widenius shared with all of us: Melvyn Hi Monty / list, Melvyn I still didn't change anything with the software, and now other tables, Melvyn also with FT indexes are crashing - these tables have never had any Melvyn problems at AIX. Also - the replica (2 servers are in replication with Melvyn eachother) doesn't expose this error. Hardware, OS etc. is exactly the Melvyn same. Built from a make clean make, on the exact same source tree. I'm Melvyn totally baffeled. First, this email list is dedicated for repeatable bug reports. In the future, please use [EMAIL PROTECTED] instead of this list when you have general problems with MySQL. For me - it IS repeatable, just don't know how - exactly, but found a clue: 020416 18:27:25 Error reading packet from server: Lost connection to MySQL server during query (read_errno 0,server_errno=2013) 020416 18:27:25 Slave: Failed reading log event, reconnecting to retry, log 'rep_log.003' position 186510180 020416 18:27:25 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'rep_log.003' at position 186510180 020416 18:27:59 read_next_with_key: Got error 126 when reading table ./forum/hardware I think I solved that problem, by upping the openfiles as per your suggestion. (You can of course also get in direct contact with the MySQL developers by buying support from https://order.mysql.com ...) When this persists on AIX, I'll definitely do that. cut Melvyn Didn't find any fields in table 'babbelbox' Have you checked your 'hostname'.err file for errors ? The above error normally means that you have not given MySQL enough file descriptors. This is a common problem on BSD and is fully documented in the online manual, under openbsd. Upped it and restarted mysql. Melvyn Here's the strange part: mysql CHECK TABLE hardware; Melvyn ++---+--++ Melvyn | Table | Op| Msg_type | Msg_text | Melvyn ++---+--++ Melvyn | forum.hardware | check | warning | Table is marked as crashed | Melvyn | forum.hardware | check | error| Found 16426 keys of 16428 | Melvyn | forum.hardware | check | error| Corrupt| Melvyn ++---+--++ Melvyn 3 rows in set (1.33 sec) The above shows the symptoms, but not the reason for the crash :( When you have problems that mysqld hangs, or becomes unresponsible you should definitely look at the following MySQL entries: not applicable. MySQL keeps running - even the slave, which is kindof strange. Melvyn I have a few more tables to go. Melvyn Is there enough room, to roughly upload the binary versions of these index Melvyn files, or doesn't this help you? Melvyn I can upload the 'before' and 'after' version, so you're able to determin Melvyn the difference. If you have something that we can use to repeat the problem, we are interested in looking at this! In this case it's enough to have the original tables + a set of commands to get corrupted tables. Before and after tables will not help us :( I don't get the checksum errors anymore - after I changed the table def. However - myisamchk is not doing a good job with the large keys (restored them by LOAD TABLE hardware FROM MASTER which produced the correct size), plus keys become corrupted when a replication packet is not received correctly, plus: mysql SHOW VARIABLES LIKE '%ft%'; Empty set (0.07 sec) The myisamchck is certainly reproducable, as is the missing ft_ variables, resulting in no way to set ft_min_word_len. Should I re-report those bugs, so they are easier to process for you? Today I think I found something interesting: Some tables kept crashing, with incorrect keyfiles. Verifying the CREATE TABLE statement, there's was 1 correlation: The tables all had a second index on the primary key (for what reason? I don't know - legacy probably - I think the primary key, was dual-fielded at some point). Combining that with the other table that kept crashing there seems to be a problem, with the situation, where one field is indexed more than one time. The first table to crash, did so at a point, where openfiles could never have been a problem, since it was like 6:30 in the morning and no visiting spider anywhere which could have upped the number of open tables. Best regards, Melvyn Sopacua WebMaster IDG.nl _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ If it applies, where it applies - this email is a personal contribution and does not reflect the views of my employer IDG.nl. \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To
RE: Selecting Information Just Inserted
Isn't it true that for last_insert_id to work that it gets this value from a connection, so if you are using a database library that uses separate connections to the database between server trips that this function does not work (like when doing web programming)? Scott -Original Message- From: Erik Price [mailto:[EMAIL PROTECTED]] Sent: Friday, April 19, 2002 2:40 PM To: Andrew Kuebler Cc: [EMAIL PROTECTED] Subject: Re: Selecting Information Just Inserted On Friday, April 19, 2002, at 02:10 PM, Andrew Kuebler wrote: I'm inserting data with an AUTO_INCREMENT column and immediately after I need to use that new number for a corresponding record in another table. How am I able to extract that new number quickly? I could run a SELECT query after the INSERT using the MAX command, but if at a busy time another record is entered while the first record was being entered, it's possibly I may get the wrong number. If there a way to use the INSERT command and extract the new AUTO_INCREMENT all in one command? LAST_INSERT_ID() returns the last auto-incremented number for your database connection. Yes, this means that even if you execute this and someone else has auto-incremented the table in the meantime, you will still have your auto-incremented number (not the new, higher one). That is why this function is better than doing SELECT MAX() on that column. Erik Erik Price Web Developer Temp Media Lab, H.H. Brown [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: GUI for mySQL
I would not look at front ends to mySQL. Instead, I would let them keep using access to do this and link them to the mySQL database or get an SQL query tool that allows for graphical queries. Scott -Original Message- From: Pierre du Parte [mailto:[EMAIL PROTECTED]] Sent: Saturday, April 20, 2002 3:06 AM Cc: MySQL Subject: GUI for mySQL I am gradually winning the war in promoting opensource to a number of my key customers. Notably a couple have made the move to OpenOffice.org, albeit on Windows. I am currently re-writing a key application to use mySQl (previously Access), so in all I'm pleased. However, the head bean counter in one office tackled me on this - In Access I can quickly create queries and export the results in all manner of ways. What do I do if we let you talk us into mySql? Where indeed? Are there any nice, user friendly GUI available for mySQL ad-hoc query and report design? Thanks -- Pierre du Parté Final Filer Software Worrigee, NSW, Australia 2540 http://www.finalfiler.com If it feels good, do it! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
load data infile problems
I'm having difficulties with loading values from a text file into my databse. I've tried the following and got these errors. last one is with full path === mysql LOAD DATA INFILE months.txt INTO TABLE months; ERROR 1105: File './date1/months.txt' not found (Errcode: 2) mysql LOAD DATA INFILE /months.txt INTO TABLE months; ERROR 13: Can't get stat of '/months.txt' (Errcode: 2) mysql LOAD DATA INFILE /home/danjar/months.txt INTO TABLE months; ERROR 13: Can't get stat of '/home/danjar/months.txt' (Errcode: 13) can anyone assit? thanks dan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: New Setup
Thanks for the idea -- still stuck though Tried connecting to mysql using the -h option, but I still had the same response. (with the -p option as well thanks Borus). Let me check - Your_Server_Name I think in my case is localhost I had a look (using the phpMyAdmin tool) at the records in the user table. There are four records - two of which are localhost - one which is root, with password (all privileges), and the second no user no password - no privileges. The other two records are similar, but my server's domain name appears in these two records. I could not see any % mark in the user table - however I did find the % mark in the mysql.host table - two records - one for localhost and the other my domain name, and the % mark was in the db column. Ian - Original Message - From: Gelu [EMAIL PROTECTED] To: Ian Phillips [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, April 22, 2002 9:05 PM Subject: Re: New Setup Hi, Only the root with the '%' character on the host field from table mysql.user have full priveleges.Try to connect with -h option and specify the Host_Name of your server.Should be work. Eg: mysql -u root -h Your_Server_Name Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Ian Phillips [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 22, 2002 11:58 AM Subject: New Setup I thank anyone in advance who may be able to help me iron this out. 1. I am setting up mysql on my apache server. I have had it there for a while, but haven't really done much with getting my head round it. 2. I have figured out some shell commands, and have been able to set a root password. 3. I have also been able to use phpMyAdmin - which I had to modify to take into account the root password etc that is now in place. 4. I can create a database table using the phpMyAdmin forms - and it was relatively easy. However, when I go back to try and set up a new user who has permission to do a range of things on this database, (using shell now), I am given an error ERROR 1044: Access denied for user: 'root@localhost' to database 'cbaa' Shell command I am using mysql GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP - ON cbaa.* - TO cbaa@localhost - IDENTIFIED BY 'itsmeolord'; This seems strange to me, as I figured that root would have permission to do anything (even if it were 'inappropriate'. Any guidance would be appreciated. Ian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Strange behaviour with SQL vars and order by
Hi, I'm having a strange problem using SQL vars (@variable) and an order by expression. I have a query that returns a record for each day. Each record has a date (data), a column with the daily total value (uv_views) and other with the accumulated value until the current day (acc_views). The other columns are IDs. The problem is that if i only order by date, the results are ok... If i order by date,Site.nome (you would say Site.name) the results are wrong and i don't know where it got those results. Here is the output. I have limited the values to 4 (it only returns rows with 0 but it doesn't matter). In the second big (not so big) query, look at acc_views accumulated value... How can it be ?!?! Thank you in advance for trying to help. mysql select @diario_views:=0,@acc_views:=0; +--+---+ | @diario_views:=0 | @acc_views:=0 | +--+---+ |0 | 0 | +--+---+ 1 row in set (0.00 sec) mysql SELECT data, @diario_views:=uv_views as views, @acc_views:=@acc_views+@diario_views as acc_views, secloc.site_id,secloc.section_id,secloc.location_id FROM secloc,Site,Section,Location WHERE secloc.campaign_id='9' and secloc.site_id=Site.site_id and secloc.section_id=Section.section_id and secloc.location_id=Location.location_id ORDER BY data LIMIT 4; ++---+---+-++-+ | data | views | acc_views | site_id | section_id | location_id | ++---+---+-++-+ | 2001-09-20 | 0 | 0 | 2 | 1 | 4 | | 2001-09-20 | 0 | 0 | 3 | 1 | 4 | | 2001-09-20 | 0 | 0 | 4 | 1 | 4 | | 2001-09-20 | 0 | 0 | 6 | 1 | 4 | ++---+---+-++-+ 4 rows in set (0.02 sec) mysql select @diario_views:=0,@acc_views:=0; +--+---+ | @diario_views:=0 | @acc_views:=0 | +--+---+ |0 | 0 | +--+---+ 1 row in set (0.00 sec) mysql SELECT data, @diario_views:=uv_views as views, @acc_views:=@acc_views+@diario_views as acc_views, secloc.site_id,secloc.section_id,secloc.location_id FROM secloc,Site,Section,Location WHERE secloc.campaign_id='9' and secloc.site_id=Site.site_id and secloc.section_id=Section.section_id and secloc.location_id=Location.location_id ORDER BY data,Site.nome LIMIT 4; ++---+---+-++-+ | data | views | acc_views | site_id | section_id | location_id | ++---+---+-++-+ | 2001-09-20 | 0 |227815 | 3 | 1 | 4 | | 2001-09-20 | 0 |263822 | 4 | 1 | 4 | | 2001-09-20 | 0 | 0 | 2 | 1 | 4 | | 2001-09-20 | 0 |331278 | 6 | 1 | 4 | ++---+---+-++-+ 4 rows in set (0.04 sec) mysql -- dsoares (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
A couple of InnoDB questions
Hi! I run MySQL 3.23.49 with InnoDB tables on a AlphaServer 4100 with 4 x 600 MHz EV5.6 CPUs with 8 MB cache. The machine has 4 GB memory. There are about 8 tables. The tables are small in size (only 1-5 GB each) but has alot of rows (usually 4 million each). There are only a few concurrent select users. Inserts are done by batch from about 70 systems every 5 minute. The systems are spread out during those 5 minute so the inserst come in a constant flow of about 10 per second in average. bin-log is turned off as the machine is unable to keep up with the insert rate with logging turned on. I have a couple of questions related to the cache settings in my.cnf. I need to tune it to give as good a select performance as possible, and also ensure that insert is as fast as possible. The machine ins't doing much else, so I can use close to all memory. Except for the default MySQL table with users etc., I only have InnoDB tables. In the my-huge.cnf example there are some of the settings : set-variable= key_buffer=384M set-variable= max_allowed_packet=1M set-variable= table_cache=512 set-variable= sort_buffer=2M set-variable= record_buffer=2M set-variable= thread_cache=8 set-variable= thread_concurrency=8 set-variable= myisam_sort_buffer_size=64M How many of these needs to be big in relation to a InnoDB only setup ? ...and can I reduce some of them without problems ? I assume the key_buffer isn't used at all since InnoDB has its own, right ? ...and then the InnoDB specific. They are equal (and very low) on all example files : set-variable = innodb_mirrored_log_groups=1 set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=5M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_archive=0 set-variable = innodb_buffer_pool_size=16M set-variable = innodb_additional_mem_pool_size=2M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 What would be a good startup for these given my current hardware database ? The database layout and a online interface is available at http://statdb.dassic.com/ for those who want to see the table index design etc. etc. It's not the mentioned machine, but it runs the same database solution. Recommendations related to the solution are welcome...it's OpenSource. /Jesper - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 data files created but not used...how to fix ?
Hi! A couple of days ago I stopped a MySQL server to change a couple of parameters in the my.cnf file and to add 2 data files (InnoDB). When restarting it, MySQL exited because I'd resized the log file size but forgot to delete/move the old ones. Secondly, I had another error because I allocated more memory than ulimit allowed. I fixed both, restarted, but then it exited because it had created the first datafile with a size of 0. I deleted the ibdata file and restarted, and now it created both data files and started correctly. However, the two new datafiles are not used, and the data they were supposed to add doesn't show up in a show table status. I've later created another data file, and this one works. ...so the question is : How to fix those two ? Can I just shutdown MySQL, rename them and then re-start MySQL and have the files re-created, or is there another solution ? /Jesper - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
VIRUS IN YOUR MAIL
V I R U S A L E R T Our viruschecker found the W32/Nimda.gen@MM virus(es) in your email to the following recipient(s): - [EMAIL PROTECTED] Please check your system for viruses, or ask your system administrator to do so. For your reference, here are the headers from your email: - BEGIN HEADERS - Return-Path: [EMAIL PROTECTED] Received: from work.mysql.com (work.mysql.com [192.58.197.161]) by pillemati.cafe.ee (8.11.6/8.11.6av) with ESMTP id g3MCjlR14021 for [EMAIL PROTECTED]; Mon, 22 Apr 2002 15:45:47 +0300 (EEST) (envelope-from [EMAIL PROTECTED]) From: [EMAIL PROTECTED] Received: from HUMANOID ([195.239.131.6]) by work.mysql.com (8.11.6/8.11.6) with SMTP id g3MCdk524163 for [EMAIL PROTECTED]; Mon, 22 Apr 2002 14:39:46 +0200 Date: Mon, 22 Apr 2002 14:39:46 +0200 Message-Id: [EMAIL PROTECTED] Subject: March Adult News letter. ADV/ADULT MIME-Version: 1.0 Content-Type: multipart/related; type=multipart/alternative; boundary=_ABC123456j7890DEF_ X-Priority: 3 X-MSMail-Priority: Normal X-Unsent: 1 To: undisclosed-recipients:; -- END HEADERS -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MyODBC multiple connection
I am writing web page using VB script ASP, and cannot work with MyODBC 2.5 of MySQL but can work with 3.5.1 the previous problem is : I made a page using ASP MyODBC, it is working then I try multiple connection, the second trial to open the page failed with a disastrous error do anyone know why? thanks Borus - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: no subject
I just had the same exact error two days ago. td checking for termcap functions library... checking for tgetent in -lncurses... no td checking for tgetent in -lcurses... no td checking for tgetent in -ltermcap... no td configure: error: No curses/termcap library found BWhen you installed your RH system, did you install the curses/termcap development tools? /B Some packages are split into runtime and development kits, so people who aren't interested in development don't need to waste the diskspace. The libtermcap libraries are in the libtermcap-devel package: $ rpm -ql libtermcap-devel /usr/include/termcap.h /usr/lib/libtermcap.a /usr/lib/libtermcap.so Make sure that package is installed. You'll also need the ncurses package, of course, but you probably already have that (so many things depend on it). The Key was I was missing the libtermcap-devel files. So download them, and this solved the problem. I also posted this here http://apachetoolbox.com/board/viewthread.php?FID=1TID=927 Thank You Daniel Negrón Lotus Notes Administrator / Developer KB Electronics, Inc. 954.346.4900x122 http://www.kbelectronics.com |+ || Trocca Filippo| || ftrocca@inwin| || d.it | ||| || 04/22/02 03:07| || AM| ||| |+ -| | | | To: [EMAIL PROTECTED] | | cc: | | Subject: no subject | -| I try to compile mysql-2.23.49 but configure process stopped for an error: checking for termcap functions library... configure:error/No curses/termcap library found I have gcc 2.95.3, make 3.79.1 on linux ppc 2000 with 2.2.x linux kernel. Can you help me? Thanks Filippo Trocca - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: GUI for mySQL
Watch out with using the Jet database engine this way. MS Access tries to keep linked external table views in sync, which means that with large tables and several PCs running Access linked to MySQL over ODBC driver it will bring your network to its knees. The Jet engine will constantly be scanning tables on the database server, generating GIGANTIC amounts of traffic. I've seen 100mb ethernet completely swamped by just 3 or 4 clients. There are probably work-arounds for that, but you should definitely test first, MS Access is a very badly behaved piece of KAKA. On Monday 22 April 2002 07:29, Hathaway, Scott L wrote: I would not look at front ends to mySQL. Instead, I would let them keep using access to do this and link them to the mySQL database or get an SQL query tool that allows for graphical queries. Scott -Original Message- From: Pierre du Parte [mailto:[EMAIL PROTECTED]] Sent: Saturday, April 20, 2002 3:06 AM Cc: MySQL Subject: GUI for mySQL I am gradually winning the war in promoting opensource to a number of my key customers. Notably a couple have made the move to OpenOffice.org, albeit on Windows. I am currently re-writing a key application to use mySQl (previously Access), so in all I'm pleased. However, the head bean counter in one office tackled me on this - In Access I can quickly create queries and export the results in all manner of ways. What do I do if we let you talk us into mySql? Where indeed? Are there any nice, user friendly GUI available for mySQL ad-hoc query and report design? 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: New Setup
Yes - but I haven't got the picture of what you're trying to communicate. I thought I would have to log in as root, to be able to create the user cbaa and allow that user to access the cbaa database. Ian - Original Message - From: ÅÇ´f¼Ù (Borus.Kung) [EMAIL PROTECTED] To: Ian Phillips [EMAIL PROTECTED] Sent: Monday, April 22, 2002 10:23 PM Subject: Re: New Setup I found that you Grant to cbaa user but use root to login check it Borus ;) Thanks for the idea -- still stuck though Tried connecting to mysql using the -h option, but I still had the same response. (with the -p option as well thanks Borus). Let me check - Your_Server_Name I think in my case is localhost I had a look (using the phpMyAdmin tool) at the records in the user table. There are four records - two of which are localhost - one which is root, with password (all privileges), and the second no user no password - no privileges. The other two records are similar, but my server's domain name appears in these two records. I could not see any % mark in the user table - however I did find the % mark in the mysql.host table - two records - one for localhost and the other my domain name, and the % mark was in the db column. Ian - Original Message - From: Gelu [EMAIL PROTECTED] To: Ian Phillips [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, April 22, 2002 9:05 PM Subject: Re: New Setup Hi, Only the root with the '%' character on the host field from table mysql.user have full priveleges.Try to connect with -h option and specify the Host_Name of your server.Should be work. Eg: mysql -u root -h Your_Server_Name Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Ian Phillips [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 22, 2002 11:58 AM Subject: New Setup I thank anyone in advance who may be able to help me iron this out. 1. I am setting up mysql on my apache server. I have had it there for a while, but haven't really done much with getting my head round it. 2. I have figured out some shell commands, and have been able to set a root password. 3. I have also been able to use phpMyAdmin - which I had to modify to take into account the root password etc that is now in place. 4. I can create a database table using the phpMyAdmin forms - and it was relatively easy. However, when I go back to try and set up a new user who has permission to do a range of things on this database, (using shell now), I am given an error ERROR 1044: Access denied for user: 'root@localhost' to database 'cbaa' Shell command I am using mysql GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP - ON cbaa.* - TO cbaa@localhost - IDENTIFIED BY 'itsmeolord'; This seems strange to me, as I figured that root would have permission to do anything (even if it were 'inappropriate'. Any guidance would be appreciated. Ian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: joins vs excess fields
I disagree. Joins can be expensive. Now PERHAPS Tom's suggestion is a good one, but its hard to say. Remember, excess fields can always be left out of a SELECT, so they don't neccessarily cause a performance problem. Some things are true though, fixed length records are more efficient, so if you have varchar fields it might be more efficient to put those in a seperate table. Remember though, when you denormalize like this you risk data integrity and you increase the number of queries your database will handle, which can itself cause a bottleneck. Disk drives for instance can only do so many reads per second, so many small requests for data can cause an I/O bottleneck long before the bandwidth of IDE or SCSI is reached. The only real way to tell if denormalization will help is to try it. build a test database both ways and run some realistic load tests. On Monday 22 April 2002 02:22, Toomas Vendelin wrote: Hello olinux, If I were in your shoes, I would put not only paths to images into a separate table, but also a field called content and probably title, summary, author and linked all this stuff together via ID-like fields which are primary keys in those new tables. Then articles table can be searched through much faster, and title, summary, author data can be quickly retrieved using primmary keys ONLY when this data is needed. So you first search a very compact table where most of the fields are indexes or parts of indexes, and THEN, using primary keys, retrieve big pieces of data which you do not have to search through (and nothing, I guess, works faster in MySQL than retrieval of a single record by it's primary key). Run your queries with EXPLAIN, it will probably explain it less verbously than me :). Regards, Tom Monday, April 22, 2002, 6:29:52 AM, you wrote: o Hello, o I have a table with a large number of news articles. o Articles of type 'feature' (identified in the o article_type field) will have the path to an image o associated with the article stored. The question is o whether to 1) add a field to the database that most o records will not use OR 2) add a table to hold image o path names and require a JOIN in order to retrieve. o I am thinking that the join query will be best. Thanks o for any help. o olinux o Table setup is: o CREATE TABLE articles ( o id int(12) NOT NULL auto_increment, o type varchar(15) NOT NULL default '', o region smallint(1) NOT NULL default '0', o date varchar(35) NOT NULL default '0', o author varchar(30) NOT NULL default '', o title varchar(90) NOT NULL default '', o summary varchar(255) NOT NULL default '', o content text NOT NULL, o keywords varchar(150) NOT NULL default '', o filename varchar(30) NOT NULL default '', o PRIMARY KEY (id,id) o ) TYPE=MyISAM; - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 libmysqlclient_r.so
Andrey Kotrekhov writes: Hello, All! I have program which try to connect to different mysql servers twice at the same time. When I use libmysqlclient.so sometimes one or two mysql connection freeze in mysql_real_connect But when I try to use libmysqlclient_r.so program crash in my_fopen this is stack of program : (gdb) bt #0 0x180ef7f2 in my_fopen () from /usr/local/mysql/lib/libmysqlclient_r.so.10 #1 0x180f0b20 in search_default_file () from /usr/local/mysql/lib/libmysqlclient_r.so.10 [skip] Hi! First of all, what version of limysql are you using ?? Second, please do : frame 1 and let us know the values for the following parameters : const char *dir, const char *config_file, const char *ext, TYPELIB *group) OS FreeBSD 4.4-RC mysql version 3.23.42, but I try to use 3.23.49 with the same effect Will anybody help me? Best regards. ___ Andrey Kotrekhov [EMAIL PROTECTED] ISP Alkar Teleport ÔÅÌ. +380 562 34-00-44 -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: New Setup
### db set up [Linux] mysql -h localhost -u root mysql create database db_abc; ### grant to user mysqlgrant all on db_abc.* to pp@localhost - identified by 'pp_pwd'; ### ppp login [Linux] mysql -h localhost -u pp -p db_abc this is what I had done, have a look the message is becoming messy, may be I made a mistake about how u check the login :) Borus (leaving office, cu) Yes - but I haven't got the picture of what you're trying to communicate. I thought I would have to log in as root, to be able to create the user cbaa and allow that user to access the cbaa database. Ian - Original Message - From: ÅÇ´f¼Ù (Borus.Kung) [EMAIL PROTECTED] To: Ian Phillips [EMAIL PROTECTED] Sent: Monday, April 22, 2002 10:23 PM Subject: Re: New Setup I found that you Grant to cbaa user but use root to login check it Borus ;) Thanks for the idea -- still stuck though Tried connecting to mysql using the -h option, but I still had the same response. (with the -p option as well thanks Borus). Let me check - Your_Server_Name I think in my case is localhost I had a look (using the phpMyAdmin tool) at the records in the user table. There are four records - two of which are localhost - one which is root, with password (all privileges), and the second no user no password - no privileges. The other two records are similar, but my server's domain name appears in these two records. I could not see any % mark in the user table - however I did find the % mark in the mysql.host table - two records - one for localhost and the other my domain name, and the % mark was in the db column. Ian - Original Message - From: Gelu [EMAIL PROTECTED] To: Ian Phillips [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, April 22, 2002 9:05 PM Subject: Re: New Setup Hi, Only the root with the '%' character on the host field from table mysql.user have full priveleges.Try to connect with -h option and specify the Host_Name of your server.Should be work. Eg: mysql -u root -h Your_Server_Name Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Ian Phillips [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 22, 2002 11:58 AM Subject: New Setup I thank anyone in advance who may be able to help me iron this out. 1. I am setting up mysql on my apache server. I have had it there for a while, but haven't really done much with getting my head round it. 2. I have figured out some shell commands, and have been able to set a root password. 3. I have also been able to use phpMyAdmin - which I had to modify to take into account the root password etc that is now in place. 4. I can create a database table using the phpMyAdmin forms - and it was relatively easy. However, when I go back to try and set up a new user who has permission to do a range of things on this database, (using shell now), I am given an error ERROR 1044: Access denied for user: 'root@localhost' to database 'cbaa' Shell command I am using mysql GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP - ON cbaa.* - TO cbaa@localhost - IDENTIFIED BY 'itsmeolord'; This seems strange to me, as I figured that root would have permission to do anything (even if it were 'inappropriate'. Any guidance would be appreciated. Ian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try:
RE: GUI for mySQL
Hi Pierre, If you goto the Contribute or Portal section of the MySQL web you'll find many good win32 GUI's. Our own is one of the oldest (since March 2000) and best available with lots of support, features and many awards below the belt, it is currently being ported to Linux as well, see: http://www.scibit.com/Mascon (a free version is also available). Kind Regards SciBit MySQL Team -Original Message- From: Pierre du Parte [EMAIL PROTECTED] To: CC: MySQL [EMAIL PROTECTED] Subject: GUI for mySQL Sent: Sat, 20 Apr 2002 08:05:31 GMT Received: Sat, 20 Apr 2002 08:12:10 GMT Read: Sat, 30 Dec 1899 00:00:00 GMT I am gradually winning the war in promoting opensource to a number of my key customers. Notably a couple have made the move to OpenOffice.org, albeit on Windows. I am currently re-writing a key application to use mySQl (previously Access), so in all I'm pleased. However, the head bean counter in one office tackled me on this - In Access I can quickly create queries and export the results in all manner of ways. What do I do if we let you talk us into mySql? Where indeed? Are there any nice, user friendly GUI available for mySQL ad-hoc query and report design? Thanks -- Pierre du Parté Final Filer Software Worrigee, NSW, Australia 2540 http://www.finalfiler.com If it feels good, do it! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: GUI for mySQL
I have to concur, MS Access with ODBC linked tables is not a good solution when those tables contain large amounts of data. I had queries run for hours and then come up with a simple ODBC Failed message at the end of it. Maybe Access has improved though. Tod Harter wrote: Watch out with using the Jet database engine this way. MS Access tries to keep linked external table views in sync, which means that with large tables and several PCs running Access linked to MySQL over ODBC driver it will bring your network to its knees. The Jet engine will constantly be scanning tables on the database server, generating GIGANTIC amounts of traffic. I've seen 100mb ethernet completely swamped by just 3 or 4 clients. There are probably work-arounds for that, but you should definitely test first, MS Access is a very badly behaved piece of KAKA. On Monday 22 April 2002 07:29, Hathaway, Scott L wrote: I would not look at front ends to mySQL. Instead, I would let them keep using access to do this and link them to the mySQL database or get an SQL query tool that allows for graphical queries. Scott -Original Message- From: Pierre du Parte [mailto:[EMAIL PROTECTED]] Sent: Saturday, April 20, 2002 3:06 AM Cc: MySQL Subject: GUI for mySQL I am gradually winning the war in promoting opensource to a number of my key customers. Notably a couple have made the move to OpenOffice.org, albeit on Windows. I am currently re-writing a key application to use mySQl (previously Access), so in all I'm pleased. However, the head bean counter in one office tackled me on this - In Access I can quickly create queries and export the results in all manner of ways. What do I do if we let you talk us into mySql? Where indeed? Are there any nice, user friendly GUI available for mySQL ad-hoc query and report design? Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Inserting a BLOB using MySQL++
All, I created a C++ class containing a variety of member variables of varying types such as float, int, char *, etc. If I instantiate an object of this class, how should I insert this object into my database table? I can retrieve the individual members and insert them that way, but I feel it would be more efficient to insert the object as a BLOB, but I don't exactly know how to do that. Basically, I want to insert the object as is so that I can retrieve it as is and not have to bother with calling the member setting functions to populate the class members. I looked at the MySQL++ example for loading a binary file, but am unsure how to apply that to my needs. I also looked through the mail archives and was unsuccessful in finding a solution, so any assistance would be much appreciated. Thanks in advance. Regards, Thi - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: joins vs excess fields
A quick note, I've read Tom's email about using a hanger table and simply don't agree. From: olinux [EMAIL PROTECTED] I have a table with a large number of news articles. For my curiosity, how many article records is a large number? A few thousand, or tens of millions? The question is whether to 1) add a field to the database that most records will not use This is the option that will create the fewest records. If you need to make a single query and be finished, this is the way I'd go. 2) add a table to hold image path names and require a JOIN in order to retrieve. Let's figure what type of JOIN you mean. The MySQL docs seem to indicate that a LEFT JOIN isn't all that bad to run, but my benchmarking doesn't agree. So let's assume you want a straight join. If you were doing that, then you'd only get back articles which have an image path defined because of this type of a joining predicate: articles.id = article_images.article_id In that case, why are you taking the overhead of scanning two tables? Why not scan one table with a predicate like: AND article_type = 'feature' I'm betting that typical usage for you will be a single query something like this: SELECT * FROM articles WHERE keywords like '%good article%' Then you'll display all the records that you've gotten. If this assumption is correct, then I'd strongly suggest compacting your data as much as possible. That is, use one table for data that is on a one-to-one relationship and not related to anything else. Of course, the best thing to do after all of the discussion is to simply try it out. I had a very simular situation a month or two back where I was told that the JOINs weren't a problem. I redisigned the schema in the way that I've indicated and got an improvement of many times (5-12 times faster). In short, we can add up what the docs say all we like, but nothing beats actuall clinical testing. --- Rodney Broom - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: functions
Good morning Daniel, From: Daniel Jarrett [EMAIL PROTECTED] ...for mysql to perform daily operations.. You bet, it's called 'cron'. MySQL doesn't have anything like scheduling built in. And, arguably, it shouldn't. Since that type of functionality is the responsibility of the operating envoriment and not of the application. If you are using a UNIX like OS, type 'man cron'. If not UNIX, hollar and I'm sure that somebody can tell you how to work it out on your system. --- Rodney Broom 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: New Setup
Hi, OK.If you connect from localhost and use the option -h you must put the alias name from /etc/hosts(if OS is Unix).Try next; use mysql; select Host from user where User='root'; and response is (on my server): %- this is if i wish to connect from any host myx - this is if i wish to connect from myx(is the alias from /etc/hosts) host So now i can try : mysql -u root -h myx I don't use -p because i don't have set the password. Good luck, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Ian Phillips [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 22, 2002 3:17 PM Subject: Re: New Setup Thanks for the idea -- still stuck though Tried connecting to mysql using the -h option, but I still had the same response. (with the -p option as well thanks Borus). Let me check - Your_Server_Name I think in my case is localhost I had a look (using the phpMyAdmin tool) at the records in the user table. There are four records - two of which are localhost - one which is root, with password (all privileges), and the second no user no password - no privileges. The other two records are similar, but my server's domain name appears in these two records. I could not see any % mark in the user table - however I did find the % mark in the mysql.host table - two records - one for localhost and the other my domain name, and the % mark was in the db column. Ian - Original Message - From: Gelu [EMAIL PROTECTED] To: Ian Phillips [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, April 22, 2002 9:05 PM Subject: Re: New Setup Hi, Only the root with the '%' character on the host field from table mysql.user have full priveleges.Try to connect with -h option and specify the Host_Name of your server.Should be work. Eg: mysql -u root -h Your_Server_Name Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Ian Phillips [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 22, 2002 11:58 AM Subject: New Setup I thank anyone in advance who may be able to help me iron this out. 1. I am setting up mysql on my apache server. I have had it there for a while, but haven't really done much with getting my head round it. 2. I have figured out some shell commands, and have been able to set a root password. 3. I have also been able to use phpMyAdmin - which I had to modify to take into account the root password etc that is now in place. 4. I can create a database table using the phpMyAdmin forms - and it was relatively easy. However, when I go back to try and set up a new user who has permission to do a range of things on this database, (using shell now), I am given an error ERROR 1044: Access denied for user: 'root@localhost' to database 'cbaa' Shell command I am using mysql GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP - ON cbaa.* - TO cbaa@localhost - IDENTIFIED BY 'itsmeolord'; This seems strange to me, as I figured that root would have permission to do anything (even if it were 'inappropriate'. Any guidance would be appreciated. Ian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail
Re: load data infile problems
i figured it out.. it worked when i used local. although I keep getting a whole heap of warnings and skipping of records. i think i've got the layout of my txt file wrong.. can anyone direct me to something that'll show me how to format my text file for loading. i find mysql manual a bit cryptic dan - Original Message - From: Melvyn Sopacua [EMAIL PROTECTED] To: Daniel Jarrett [EMAIL PROTECTED] Cc: MySQL General [EMAIL PROTECTED] Sent: Monday, April 22, 2002 9:48 PM Subject: Re: load data infile problems The errorcodes in the brackets below indicate the error. You can find a human description, in /usr/include/errno.h For instance: grep 13 /usr/include/errno.h #define EACCES 13 /* Permission denied */ if there is no errno.h, use `locate' to locate it or try `man errno'. Daniel Jarrett said at 13:31 22-4-2002: I'm having difficulties with loading values from a text file into my databse. I've tried the following and got these errors. last one is with full path === mysql LOAD DATA INFILE months.txt INTO TABLE months; ERROR 1105: File './date1/months.txt' not found (Errcode: 2) mysql LOAD DATA INFILE /months.txt INTO TABLE months; ERROR 13: Can't get stat of '/months.txt' (Errcode: 2) mysql LOAD DATA INFILE /home/danjar/months.txt INTO TABLE months; ERROR 13: Can't get stat of '/home/danjar/months.txt' (Errcode: 13) can anyone assit? thanks dan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Best regards, Melvyn Sopacua WebMaster IDG.nl _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ If it applies, where it applies - this email is a personal contribution and does not reflect the views of my employer IDG.nl. \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: load data infile problems
Disregard my last post.. - Original Message - From: Daniel Jarrett [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 22, 2002 11:44 PM Subject: Re: load data infile problems i figured it out.. it worked when i used local. although I keep getting a whole heap of warnings and skipping of records. i think i've got the layout of my txt file wrong.. can anyone direct me to something that'll show me how to format my text file for loading. i find mysql manual a bit cryptic dan - Original Message - From: Melvyn Sopacua [EMAIL PROTECTED] To: Daniel Jarrett [EMAIL PROTECTED] Cc: MySQL General [EMAIL PROTECTED] Sent: Monday, April 22, 2002 9:48 PM Subject: Re: load data infile problems The errorcodes in the brackets below indicate the error. You can find a human description, in /usr/include/errno.h For instance: grep 13 /usr/include/errno.h #define EACCES 13 /* Permission denied */ if there is no errno.h, use `locate' to locate it or try `man errno'. Daniel Jarrett said at 13:31 22-4-2002: I'm having difficulties with loading values from a text file into my databse. I've tried the following and got these errors. last one is with full path === mysql LOAD DATA INFILE months.txt INTO TABLE months; ERROR 1105: File './date1/months.txt' not found (Errcode: 2) mysql LOAD DATA INFILE /months.txt INTO TABLE months; ERROR 13: Can't get stat of '/months.txt' (Errcode: 2) mysql LOAD DATA INFILE /home/danjar/months.txt INTO TABLE months; ERROR 13: Can't get stat of '/home/danjar/months.txt' (Errcode: 13) can anyone assit? thanks dan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Best regards, Melvyn Sopacua WebMaster IDG.nl _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ If it applies, where it applies - this email is a personal contribution and does not reflect the views of my employer IDG.nl. \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
sub selects
I know that mysql does not support sub selects but I want to be able to do the following: I have a table with all my leads in called leads. The table has a unique ref for each lead called refnumberid I have a table with leads in and products that leads have asked not to be mailed on the table has a field called leadid which stores the value of refnumberid above. I want to select records from the table leads provided they do not have a record in the table blacklist. I have used the following select statement which produces no results. The intro screen collects the value of adate and acountry sql2= SELECT leads.* from leads,blacklist WHERE leads.date1stcontact = 'adate' and leads.country = 'acountry' and leads.refnumberid blacklist.leadid and leads.productname blacklist.productOR leads.date1stcontact = 'adate' and leads.refnumberid blacklist.leadid and leads.productname blacklist.product and 'acountry' = 'ALL' set rs22=Server.CreateObject(ADODB.Recordset) rs22.open sql2,db,0,1 Can anyone help? Regards Michael Johnson Managing Director Humphrey Consulting Limited BPEnet 13 Austin Friars London EC2N 2JX Tel +44(0)1323 438975 Fax +44(0)1323 738355 Email [EMAIL PROTECTED] URL www.bpenet.net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Inserting a BLOB using MySQL++
Thi Cao writes: All, I created a C++ class containing a variety of member variables of varying types such as float, int, char *, etc. If I instantiate an object of this class, how should I insert this object into my database table? I can retrieve the individual members and insert them that way, but I feel it would be more efficient to insert the object as a BLOB, but I don't exactly know how to do that. Basically, I want to insert the object as is so that I can retrieve it as is and not have to bother with calling the member setting functions to populate the class members. I looked at the MySQL++ example for loading a binary file, but am unsure how to apply that to my needs. I also looked through the mail archives and was unsuccessful in finding a solution, so any assistance would be much appreciated. Thanks in advance. Regards, Thi Hi! Take a look in reset_db.cc and load_file.cc example files. In any case, you always have to escape a binary string prior to inserting it. As it is seen in cgi_image.cc example, you will always get back from MySQL your BLOB in en-escaped, original form. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem with libmysqlclient_r.so
äÏÂÒÙÊ ÄÅÎØ. Andrey Kotrekhov writes: Hello, All! I have program which try to connect to different mysql servers twice at the same time. When I use libmysqlclient.so sometimes one or two mysql connection freeze in mysql_real_connect But when I try to use libmysqlclient_r.so program crash in my_fopen this is stack of program : (gdb) bt #0 0x180ef7f2 in my_fopen () from /usr/local/mysql/lib/libmysqlclient_r.so.10 #1 0x180f0b20 in search_default_file () from /usr/local/mysql/lib/libmysqlclient_r.so.10 [skip] Hi! First of all, what version of limysql are you using ?? ? this example is from mysql 3.23.42 libmysqlclient_r.so.10 Second, please do : frame 1 and let us know the values for the following parameters : const char *dir, const char *config_file, const char *ext, TYPELIB *group) #1 0x180f0b20 in search_default_file () from /usr/local/mysql/lib/libmysqlclient_r.so.10 Will I need to compile mysql with --with-debug option to see parameters? OS FreeBSD 4.4-RC mysql version 3.23.42, but I try to use 3.23.49 with the same effect Will anybody help me? Best regards. ___ Andrey Kotrekhov [EMAIL PROTECTED] ISP Alkar Teleport ÔÅÌ. +380 562 34-00-44 -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com 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
Re: problem with libmysqlclient_r.so
Andrey Kotrekhov writes: äÏÂÒÙÊ ÄÅÎØ. #1 0x180f0b20 in search_default_file () from /usr/local/mysql/lib/libmysqlclient_r.so.10 Will I need to compile mysql with --with-debug option to see parameters? Best regards. ___ Andrey Kotrekhov [EMAIL PROTECTED] ISP Alkar Teleport ÔÅÌ. +380 562 34-00-44 Yes, including libmysys source files . -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysql Bug Report, Random crashes, reason unknown
Description: MySQL Crashes often. How-To-Repeat: Don't know Fix: Don't know Submitter-Id: Gavin Woodhatch Originator: Organization: NetZone Ltd. MySQL support: [none] Synopsis: Random MySQL crashes (1-2 every 24h) Severity: [ serious ] Priority: [ medium ] Category: mysql Class: [ sw-bug ] Release: mysql-3.23.49a (Official MySQL Binary) Environment: System: Linux db1 2.4.10-4GB #1 Tue Sep 25 12:33:54 GMT 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i486-suse-linux/2.95.3/specs gcc version 2.95.3 20010315 (SuSE) Compilation info: CC='gcc' CFLAGS='-Wimplicit -Wreturn-type -Wid-clash-51 -Wswi tch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wimplicit-function-dec -Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings -Wunused -mcpu=penti umpro -O3 -fno-omit-frame-pointer' CXX='gcc' CXXFLAGS='-Wimplicit -Wreturn-typ e -Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wi mplicit-function-dec -Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings -Woverloaded-virtual -Wextern-inline -Wsign-promo -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors -fno-exceptions -fno-rtti -mcpu=pentium pro -O3 -fno-omit-frame-pointer' LDFLAGS='' LIBC: -rwxr-xr-x1 root root 1384168 Sep 20 2001 /lib/libc.so.6 -rw-r--r--1 root root 25215580 Sep 20 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 Sep 20 2001 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql --enable-assembler --wi th-extra-charsets=complex --enable-thread-safe-client --with-mysqld-ldflags=-all -static --with-client-ldflags=-all-static --with-other-libc=/usr/local/mysql-gli bc '--with-comment=Official MySQL Binary' --prefix=/usr/local/mysql --with-extra -charset=complex --enable-thread-safe-client --enable-local-infile 'CFLAGS=-Wimp licit -Wreturn-type -Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subsc ripts -Wformat -Wimplicit-function-dec -Wimplicit-int -Wparentheses -Wsign-compa re -Wwrite-strings -Wunused -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' 'CXXFL AGS=-Wimplicit -Wreturn-type -Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W -Wc har-subscripts -Wformat -Wimplicit-function-dec -Wimplicit-int -Wparentheses -Ws ign-compare -Wwrite-strings -Woverloaded-virtual -Wextern-inline -Wsign-promo -W reorder -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors -fno-excepti ons -fno-rtti -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' CXX=gcc Attached Here are the last two Stack Traces, and logfile entrys i dont know if there right, i grabbed the mysqld.sym from the server.rpm, but am using the tar.gz binary package. I did not find the mysqld.sym.gz in the tar.gz archiv. here is the bit of the log file for our last crash: mysqld got signal 4; snip key_buffer_size=16773120 record_buffer=1044480 sort_buffer=4194296 max_used_connections=29 max_connections=150 threads_connected=19 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 783778 K snip Stack range sanity check OK, backtrace follows: 0x806db54 0x811c328 0x806afdd 0x808fb1d 0x8092cb8 0x808c1db 0x807472a 0x8078828 0x8073904 0x8072cb7 Stack trace seems successful - bottom reached snip Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x83a9c78 = SELECT id FROM dvdone_rented WHERE id_movie = '10089' and state != 'back' thd-thread_id=23860 And here is the resolved Stack Trace .. (hope its right ..) db1:/tmp # /usr/local/mysql/bin/resolve_stack_dump -s /tmp/mysqld.sym -n /tmp/mysql.stack1 0x806db54 server_init__Fv + 8 0x811c328 pthread_mutex_trylock + 8 0x806afdd mysql_lock_tables__FP3THDPP8st_tableUi + 573 0x808fb1d make_join_select__FP4JOINP10SQL_SELECTP4Item + 713 0x8092cb8 create_myisam_tmp_table__FP8st_tableP15TMP_TABLE_PARAMUi + 336 0x808c1db mysql_select__FP3THDP13st_table_listRt4List1Z4ItemP4ItemP8st_orderT4T3T4UiP13select_result + 3611 0x807472a do_command__FP3THD + 3466 0x8078828 add_table_to_list__FP11Table_identP10lex_stringb13thr_lock_typePt4List1Z6StringT4 + 280 0x8073904 mysql_table_dump__FP3THDPcT1i + 260 0x8072cb7 check_for_max_user_connections__FPCciT0 + 311 Here is some more info on the 2nd last crash mysqld got signal 11; snip key_buffer_size=16773120 record_buffer=1044480 sort_buffer=4194296 max_used_connections=28 max_connections=150 threads_connected=19 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 783778 K bytes of memory Hope that's ok, if not, decrease some variables in the equation snip Stack range sanity check OK, backtrace follows: 0x806db54 0x811c328 0xb3 0x806981c 0x8069726 0x80679f2 0x809827d 0x8092f76 0x8092c80 0x808c1db 0x807472a 0x8078828 0x8073904 0x8072cb7 Stack trace seems
Re: InnoDB, BDB
Samim, Monday, April 22, 2002, 11:20:48 AM, you wrote: S This question is probably repeated each week, but I am an absolute beginner S with MySQL. Sorry for that. I've installed the precompiled binaries for Win, S and I am very satisfied with MySQL. The only thing I couldn't find is S support for transactions, although it was written in the documentation that S support for BDB and InnoDB table types is activated in precompiled binaries. S Is there something I've missed to configure (I've configured the necessary S innodb_data_file_path and innodb_data_home_dir for InnoDB) or do I have to S recompile MySQL with support for BDB and InnoDB activated? I've tried S mysqld-max-nt and mysqld-max, but have_bdb and have_innodb variables were S 'NO'. I use version 3.23.49. You should install MySQL-Max for InnoDB and BDB tables support, you can read about mysqld-max at: http://www.mysql.com/doc/m/y/mysqld-max.html If you want to use InnoDB tables you must specify startup options in my.cnf file. You can find examples and info about configuration parameters at: http://www.mysql.com/doc/I/n/InnoDB_start.html S Thanks! S Samim -- For technical support contracts, goto https://order.mysql.com/ 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: Running Mysql On Host other than localHost
Kevin, Sunday, April 21, 2002, 11:27:06 PM, you wrote: KF I have the standard tarbal install of mysql. I want to know how do I start KF the server so that I can access it from another machine. I am running on a KF linux 6.2 server where the local ip address of the box is 192.168.1.150 and KF the hostname is MysqlServer. I need to be able to change the host that ir KF start with from localhost to something else. I don't see anywhere in the KF docs that show how to do this. KF I can conect and do all db work on the linux console but cannot seem to KF connect from anyother box into the linux box to access the Mysql Server. You should specify host in the privilege tables to allow user to connect from that host. As Rodney Broom advice you, look at the manual. There is enough info about access verification in the section 4.2 General Security Issues and the MySQL Access Privilege System: http://www.mysql.com/doc/P/r/Privilege_system.html If you specify host name and you can't connect to the MySQl server from remote host, try to remove 'skip-networking' entry from my.cnf file ... -- For technical support contracts, goto https://order.mysql.com/ 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: load data infile problems
Daniel, Monday, April 22, 2002, 2:31:15 PM, you wrote: DJ I'm having difficulties with loading values from a text file into my DJ databse. DJ I've tried the following and got these errors. last one is with full path DJ === DJ mysql LOAD DATA INFILE months.txt INTO TABLE months; DJ ERROR 1105: File './date1/months.txt' not found (Errcode: 2) DJ mysql LOAD DATA INFILE /months.txt INTO TABLE months; DJ ERROR 13: Can't get stat of '/months.txt' (Errcode: 2) DJ mysql LOAD DATA INFILE /home/danjar/months.txt INTO TABLE months; DJ ERROR 13: Can't get stat of '/home/danjar/months.txt' (Errcode: 13) DJ DJ can anyone assit? Check your permissions... Seems MySQL has no permissions on those files ... DJ thanks DJ dan -- For technical support contracts, goto https://order.mysql.com/ 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: server disconnect
saraswathy, Monday, April 22, 2002, 11:57:14 AM, you wrote: ss Can anyone tell whats wrong with the server..the connection to server ss disconnect automaticaly.we have to press refresh button again and again ss until the its show all the folders...is there anything wrong with ss installationcan anyone help me You gave not enough info ... How have you connected to the MySQL server? Disconnection from the sever appears immediately or in certain period of time? What is the version of the MySQL server? What OS do you use? Take a look at: http://www.mysql.com/doc/G/o/Gone_away.html It may help you ... ss sql,query ss thanks in advance -- For technical support contracts, goto https://order.mysql.com/ 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: min() bug
Artem, Friday, April 12, 2002, 8:05:37 PM, you wrote: AVR min return not value from table. AVR mysql select min(ord) from cSectText where SectID=932; AVR +-+ AVR | min(ord)| AVR +-+ AVR | -20020412051744 | AVR +-+ AVR 1 row in set (0.00 sec) AVR mysql select ord from cSectText where SectID=932 order by ord limit 10; AVR +-+ AVR | ord | AVR +-+ AVR | -20020412051754 | AVR | -20020412051752 | AVR | -20020412051750 | AVR | -20020412051748 | AVR | -20020412051746 | AVR | -20020412051744 | AVR | -20020412051742 | AVR | -20020412051740 | AVR | -20020412051738 | AVR | -20020412051730 | AVR +-+ AVR 10 rows in set (0.00 sec) AVR mysql select ord from cSectText where SectID=1 order by ord limit 10; AVR +-+ AVR | ord | AVR +-+ AVR | -20020412051794 | AVR | -20020412051754 | AVR | -20020412051752 | AVR | -20020412051750 | AVR | -20020412051748 | AVR | -20020412051746 | AVR | -20020412051744 | AVR | -20020412051742 | AVR | -20020412051740 | AVR | -20020412051738 | AVR +-+ AVR 10 rows in set (0.00 sec) AVR mysql select min(ord) from cSectText where SectID=1; AVR +-+ AVR | min(ord)| AVR +-+ AVR | -20020412051808 | AVR +-+ AVR 1 row in set (0.00 sec) AVR mysql select * from cSectText where ord=-20020412051808 and SectID=1; AVR Empty set (0.00 sec) AVR mysql show create table cSectText; AVR | cSectText | CREATE TABLE `cSectText` ( AVR `SectID` int(11) NOT NULL default '0', AVR `ID` int(11) NOT NULL default '0', AVR `Date` date NOT NULL default '-00-00', AVR `ord` bigint(17) NOT NULL default '0', AVR PRIMARY KEY (`ID`,`SectID`), AVR UNIQUE KEY `d` (`SectID`,`ord`), AVR UNIQUE KEY `a` (`SectID`,`Date`,`ID`) AVR ) TYPE=MyISAM COMMENT='ÓÓÓ' | AVR 1 row in set (0.00 sec) AVR mysql show variables like 'version'; AVR +---++ AVR | Variable_name | Value | AVR +---++ AVR | version | 3.23.49yes-log | AVR +---++ AVR 1 row in set (0.00 sec) As Monty explained: The problem is not with min() function. MySQL 3.23 doesn't support the full range for bigint. Despite the fact that in v3.23 all comparisons are done with double arithmetic it's not enough to be able to be able to handle the above. In some cases it temporary fixed adding around the bigint string. -- For technical support contracts, goto https://order.mysql.com/ 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
Problem with select statements in Visual Basic
I have a problem in VB trying to use select statements with MySQL. My problem does not occur only with the example below but with ANY select statement I try to make against my MySQL database. Much thanks in advance to anyone that can help me out with this :) This is my code: Private Sub optNoTech_Click() Adodc1.RecordSource = Select * from usermanager where techstatus = 'U' Adodc1.Refresh DataGrid1.Refresh End Sub I keep getting this error: [MySQL][ODBC 3.51 Driver][mysqld-3.23.49.nt]You have an error in your SQL syntax near Select * from usermanager where techstatus = 'U' at line 1. Thanks :) -Trevor - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
how to add a special function into MySQL as a command
Hello all , I am now trying to add a special function into MySQL as a command. Anyone who good at it , please give me some precious suggestions , including the related document or some webs which explains it . thank u very much . -- Best regards, isp01ljl mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL fails to correctly index decimal datatype columns
A test SQL script which duplicates this problem is available via anonymous FTP at the following location: Hostname: ftp.visi.com Directory: /users/chris Filename: test.sql Run the script like this to see the error: mysql -t temp test.sql The second select statement returns only 2 of the 6 rows that it should have found. This problem was reported by me and fixed in 3.23.23. It appears from the changelog that MySQL developers also had problems in this area with release 3.23.14. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 Bug Report, Random crashes, reason unknown
Gavin, Monday, April 22, 2002, 6:29:08 PM, you wrote: GW Description: GW MySQL Crashes often. GW How-To-Repeat: GW Don't know GW Fix: GW Don't know GWSubmitter-Id: Gavin Woodhatch GWOriginator: GWOrganization: NetZone Ltd. GWMySQL support: [none] GWSynopsis: Random MySQL crashes (1-2 every 24h) GWSeverity: [ serious ] GWPriority: [ medium ] GWCategory: mysql GWClass: [ sw-bug ] GWRelease: mysql-3.23.49a (Official MySQL Binary) GWEnvironment: GW System: Linux db1 2.4.10-4GB #1 Tue Sep 25 12:33:54 GMT 2001 i686 unknown GW Architecture: i686 GW I hope someone can help us on this one .. i guess i am lost. GW The distribution we are using is SuSE 7.3 Signal 4 means illegal instruction, when your binary is not compatible with your architecture... Signal 11 means Segmentation fault, when the program cames out of it's address space. In your case, the combination of these two most likely means broken hardware as SIGILL is _very_ unlikely to happen, if not impossible. GW Thanks for your Help in advance. GW Gavin Woodhatch GW NetZone Ltd. -- For technical support contracts, goto https://order.mysql.com/ 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: InnoDB and Fulltext Search
Ang, Monday, April 22, 2002, 12:24:58 PM, you wrote: AHK Quote from mysql online documentations: AHK As of Version 4.0.1, MySQL can also perform boolean AHK full-text AHK searches using the IN BOOLEAN MODE modifierA AHK boolean full-text AHK search can also work even without a FULLTEXT index, AHK although it would AHK be slow. AHK I know that InnoDB does not support FULLTEXT INDEXING AHK but can i AHK perform a fulltext search on an InnoDB table? I tried AHK but it doesn't AHK seem to work. The 'match... against()' returns a value AHK of '-1'. Any AHK idea? No, Full-text search still works only on MyISAM tables ... AHK Thanx. AHK ahk -- For technical support contracts, goto https://order.mysql.com/ 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: InnoDB data files created but not used...how to fix ?
Jesper, what may have happened is that InnoDB created the data files, but because memory ran out, it did not have time to update the tablespace header to reflect the size increase by those two data files. Later when you added yet another data file, it increased the size stored in the tablespace header. The new data you have added has probably gone to those two data files you added first. InnoDB is aware of the data files you specify, but it thinks that the tablespace size is smaller than the combined size of the data files! What to do? The safest solution is to dump your tables and recreate the whole InnoDB tablespace. If you can afford losing the data in the database, then you can experiment by removing 1 or 2 last files from innodb_data_file_path and look if the database crashes in an assertion failure when you insert new data. Regarding your other question about my.cnf parameter, section 2 of http://www.innodb.com/ibman.html is your best help. 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: [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Monday, April 22, 2002 3:35 PM Subject: InnoDB data files created but not used...how to fix ? Hi! A couple of days ago I stopped a MySQL server to change a couple of parameters in the my.cnf file and to add 2 data files (InnoDB). When restarting it, MySQL exited because I'd resized the log file size but forgot to delete/move the old ones. Secondly, I had another error because I allocated more memory than ulimit allowed. I fixed both, restarted, but then it exited because it had created the first datafile with a size of 0. I deleted the ibdata file and restarted, and now it created both data files and started correctly. However, the two new datafiles are not used, and the data they were supposed to add doesn't show up in a show table status. I've later created another data file, and this one works. ...so the question is : How to fix those two ? Can I just shutdown MySQL, rename them and then re-start MySQL and have the files re-created, or is there another solution ? /Jesper - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL 3.23.44 not using indexes
MySQL 3.23.44 isn't using indexes when it should and could, even when I try to force it via a USE INDEX clause in the SELECT statement. For example, here is what EXPLAIN gives me on a query containing the clause USE INDEX (bug_status) on the bugs table: mysql EXPLAIN SELECT DISTINCT bugs.bug_id, bugs.groupset, substring(bugs.bug_severity, 1, 3), substring(bugs.priority, 1, 3), substring(bugs.rep_platform, 1, 3), map_assigned_to.login_name, substring(bugs.bug_status,1,4), substring(bugs.resolution,1,4), substring(bugs.short_desc, 1, 60) FROM bugs USE INDEX (bug_status), profiles map_assigned_to, profiles map_reporter LEFT JOIN profiles map_qa_contact ON bugs.qa_contact = map_qa_contact.userid WHERE ((bugs.groupset 0) = bugs.groupset ) AND bugs.assigned_to = map_assigned_to.userid AND bugs.reporter = map_reporter.userid AND (bugs.bug_status = 'NEW' OR bugs.bug_status = 'ASSIGNED' OR bugs.bug_status = 'REOPENED') ORDER BY bugs.priority, bugs.bug_severity; +-++-+-+-+--++-+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +-++-+-+-+--++-+ | bugs| ALL| assigned_to,bug_status,reporter | NULL |NULL | NULL | 139031 | where used; Using temporary; Using filesort | | map_assigned_to | eq_ref | PRIMARY | PRIMARY | 3 | bugs.assigned_to | 1 | | | map_reporter| eq_ref | PRIMARY | PRIMARY | 3 | bugs.reporter| 1 | Using index; Distinct | | map_qa_contact | eq_ref | PRIMARY | PRIMARY | 3 | bugs.qa_contact | 1 | Using index; Distinct | +-++-+-+-+--++-+ 4 rows in set (0.09 sec) On MySQL 3.23.41, however, MySQL uses the index I tell it to use (and also uses it without me having to tell it): mysql EXPLAIN SELECT DISTINCT bugs.bug_id, bugs.groupset, substring(bugs.bug_severity, 1, 3), substring(bugs.priority, 1, 3), substring(bugs.rep_platform, 1, 3), map_assigned_to.login_name, substring(bugs.bug_status,1,4), substring(bugs.resolution,1,4), substring(bugs.short_desc, 1, 60) FROM bugs USE INDEX (bug_status), profiles map_assigned_to, profiles map_reporter LEFT JOIN profiles map_qa_contact ON bugs.qa_contact = map_qa_contact.userid WHERE ((bugs.groupset 0) = bugs.groupset ) AND bugs.assigned_to = map_assigned_to.userid AND bugs.reporter = map_reporter.userid AND (bugs.bug_status = 'NEW' OR bugs.bug_status = 'ASSIGNED' OR bugs.bug_status = 'REOPENED') ORDER BY bugs.priority, bugs.bug_severity; +-++-++-+--+---+-+ | table | type | possible_keys | key| key_len | ref | rows | Extra | +-++-++-+--+---+-+ | bugs| range | assigned_to,bug_status,reporter | bug_status | 1 | NULL | 22665 | where used; Using temporary; Using filesort | | map_assigned_to | eq_ref | PRIMARY | PRIMARY| 3 | bugs.assigned_to | 1 | | | map_reporter| eq_ref | PRIMARY | PRIMARY| 3 | bugs.reporter| 1 | Using index; Distinct | | map_qa_contact | eq_ref | PRIMARY | PRIMARY| 3 | bugs.qa_contact | 1 | Using index; Distinct | +-++-++-+--+---+-+ 4 rows in set (0.01 sec) Is this a bug in MySQL, a problem with how I migrated the data, or some other issue? How can I fix it? -myk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: joins vs excess fields
Hmm, That's what I thought I was doing by putting the common fields of each article type in a single table. I do need to rethink the search functions. Was thinking of a fulltext index on title and article_content fields. basic table is id | type | author | date | last_update | title | keywords | article_content Since most frequent request will be on the date field, that will be first, but I need to put learn more of fulltext indexes and probably index keywords, title, article content. Thanks much, olinux --- Toomas Vendelin [EMAIL PROTECTED] wrote: Hello olinux, If I were in your shoes, I would put not only paths to images into a separate table, but also a field called content and probably title, summary, author and linked all this stuff together via ID-like fields which are primary keys in those new tables. Then articles table can be searched through much faster, and title, summary, author data can be quickly retrieved using primmary keys ONLY when this data is needed. So you first search a very compact table where most of the fields are indexes or parts of indexes, and THEN, using primary keys, retrieve big pieces of data which you do not have to search through (and nothing, I guess, works faster in MySQL than retrieval of a single record by it's primary key). Run your queries with EXPLAIN, it will probably explain it less verbously than me :). Regards, Tom Monday, April 22, 2002, 6:29:52 AM, you wrote: o Hello, o I have a table with a large number of news articles. o Articles of type 'feature' (identified in the o article_type field) will have the path to an image o associated with the article stored. The question is o whether to 1) add a field to the database that most o records will not use OR 2) add a table to hold image o path names and require a JOIN in order to retrieve. o I am thinking that the join query will be best. Thanks o for any help. o olinux o Table setup is: o CREATE TABLE articles ( o id int(12) NOT NULL auto_increment, o type varchar(15) NOT NULL default '', o region smallint(1) NOT NULL default '0', o date varchar(35) NOT NULL default '0', o author varchar(30) NOT NULL default '', o title varchar(90) NOT NULL default '', o summary varchar(255) NOT NULL default '', o content text NOT NULL, o keywords varchar(150) NOT NULL default '', o filename varchar(30) NOT NULL default '', o PRIMARY KEY (id,id) o ) TYPE=MyISAM; __ Do You Yahoo!? Yahoo! Games - play chess, backgammon, pool and more http://games.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 3.23.44 not using indexes
I have some more information about the problem. It seems to be caused by the presence of an OR or IN clause in the WHERE portion of the query. Without the clause, 2.23.44 uses the appropriate indexes, but with the clause it does not. 2.23.41 uses the appropriate indexes in both cases. Here are some simple queries that demonstrate this: 2.23.44: mysql EXPLAIN SELECT DISTINCT bugs.bug_id FROM bugs USE INDEX (bug_status) WHERE bugs.bug_status = 'NEW'; +---+--+---++-+---+---+-+ | table | type | possible_keys | key| key_len | ref | rows | Extra | +---+--+---++-+---+---+-+ | bugs | ref | bug_status| bug_status | 1 | const | 18269 | where used; Using temporary | +---+--+---++-+---+---+-+ 1 row in set (0.03 sec) mysql EXPLAIN SELECT DISTINCT bugs.bug_id FROM bugs USE INDEX (bug_status) WHERE bugs.bug_status IN ('NEW', 'ASSIGNED', 'REOPENED'); +---+--+---+--+-+--++-+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +---+--+---+--+-+--++-+ | bugs | ALL | bug_status| NULL |NULL | NULL | 139031 | where used; Using temporary | +---+--+---+--+-+--++-+ 1 row in set (0.06 sec) 2.23.41: mysql EXPLAIN SELECT DISTINCT bugs.bug_id FROM bugs USE INDEX (bug_status) WHERE bugs.bug_status = 'NEW'; +---+--+---++-+---+---+-+ | table | type | possible_keys | key| key_len | ref | rows | Extra | +---+--+---++-+---+---+-+ | bugs | ref | bug_status| bug_status | 1 | const | 13904 | where used; Using temporary | +---+--+---++-+---+---+-+ 1 row in set (0.00 sec) mysql EXPLAIN SELECT DISTINCT bugs.bug_id FROM bugs USE INDEX (bug_status) WHERE bugs.bug_status IN ('NEW', 'ASSIGNED', 'REOPENED'); +---+---+---++-+--+---+-+ | table | type | possible_keys | key| key_len | ref | rows | Extra | +---+---+---++-+--+---+-+ | bugs | range | bug_status| bug_status | 1 | NULL | 22665 | where used; Using temporary | +---+---+---++-+--+---+-+ 1 row in set (0.00 sec) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
versions
Hi, Has anybody heard how the next version of either MyODBC (3.51) or MySQL (4.0.1) are coming along and when they will be declared stable? I started developing with 4.0.1, and although I have had no failures to date, I was said that they would be declared stable in dec/jan. it is now several months later and my product is very close to some deployments. It would be quite comforting to hear that they are in the stable tree. Thanks Rich - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysql / Job
I am in need of a data base for a website(Php/Mysql), this would be for job posting and advertising by recrutiers. anyone intrested e-mail me direct at [EMAIL PROTECTED] Thank you for your time __ Do You Yahoo!? Yahoo! Games - play chess, backgammon, pool and more http://games.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
ERROR 1045: Access denied for user: 'root@localhost'
Hello, i'm having a problem accessing mysql database. I don't recall setting a password for root, but when i try to set that password. This is happening right after i run mysql_install_db [root@omsrh etc]# mysql -u root -p Enter password:** ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) [root@omsrh etc]# mysql ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) I was able access Mysql not being root, but couldn't get access to 'mysql' database to change user options and all. When accessing mysql as a user, I am unable to create databases. When using skip-grant-table i get ... [root@omsrh etc]# mysql -u root mysql: unrecognized option `--skip-grant-table' Your help will be greatly appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQLdb Exception Documentation
Hello All: I'm just learning to use Andy Dustman's MySQLdb for Python. Very easy for this mysql-dummy to learn! It would be very helpful for me to find documentation on the Exceptions thrown by Python for this API. Any advice would be greatly appreciated. TIA -- Tim Johnson [EMAIL PROTECTED] http://www.alaska-internet-solutions.com http://www.johnsons-web.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: Inserting a BLOB using MySQL++
Probably the best bet would be to write the individual attributes to respective database columns. It keeps a few things simpler. It would also allow you to update the database from multible sources (many threads, or many users on the database). Other wise, you would have to serialize the object to a binary object and write that to the BLOB field. When you imported it back, you would have to deserialize. Some languages call this pickeling. As I have not touched C++ code for a while, I'm not sure what classes are availible to do this for you. The BLOB way of doing it would force you read/write the entire thing everytime you update the object, unless you are just using the database to store it for backup. -Opus On 22 Apr 2002 at 8:21, Thi Cao wrote: All, I created a C++ class containing a variety of member variables of varying types such as float, int, char *, etc. If I instantiate an object of this class, how should I insert this object into my database table? I can retrieve the individual members and insert them that way, but I feel it would be more efficient to insert the object as a BLOB, but I don't exactly know how to do that. Basically, I want to insert the object as is so that I can retrieve it as is and not have to bother with calling the member setting functions to populate the class members. I looked at the MySQL++ example for loading a binary file, but am unsure how to apply that to my needs. I also looked through the mail archives and was unsuccessful in finding a solution, so any assistance would be much appreciated. Thanks in advance. Regards, Thi --Opus-- Government is not reason, it is not eloquence- it is force. - George Washington Get added to my Humor list: mailto:[EMAIL PROTECTED]?subject=ADD_HUMOR Get added to my Neat list: mailto:[EMAIL PROTECTED]?subject=ADD_NEAT Get my PGP public key: mailto:[EMAIL PROTECTED]?subject=PSENDbody=send%20PublicKEY.asc Visit My Home Page: http://value.net/~opus/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: functions
For NT and 2000 machines, use the AT command if you want a command line scheduler. The syntax is actually different between them though. I found that it is actually easier to schedule a process to schedule other processes instead of having the process schedule itself again. The FOR command in Batch files works REALLY well for that! On 22 Apr 2002 at 6:47, Rodney Broom wrote: Good morning Daniel, From: Daniel Jarrett [EMAIL PROTECTED] ...for mysql to perform daily operations.. You bet, it's called 'cron'. MySQL doesn't have anything like scheduling built in. And, arguably, it shouldn't. Since that type of functionality is the responsibility of the operating envoriment and not of the application. If you are using a UNIX like OS, type 'man cron'. If not UNIX, hollar and I'm sure that somebody can tell you how to work it out on your system. --- Rodney Broom sql --Opus-- Why program by hand in five days what you can spend five years of your life automating? - Terence Parr Get added to my Humor list: mailto:[EMAIL PROTECTED]?subject=ADD_HUMOR Get added to my Neat list: mailto:[EMAIL PROTECTED]?subject=ADD_NEAT Get my PGP public key: mailto:[EMAIL PROTECTED]?subject=PSENDbody=send%20PublicKEY.asc Visit My Home Page: http://value.net/~opus/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: functions
Actually, W2K has a scheduler built in that works pretty well for basic scheduling needs. If you are using NT 4.0, try and upgrade to SP6a. That SP has the scheduler of W2K built in as well. Bruce - Original Message - From: Opus [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 22, 2002 3:17 PM Subject: Re: functions For NT and 2000 machines, use the AT command if you want a command line scheduler. The syntax is actually different between them though. I found that it is actually easier to schedule a process to schedule other processes instead of having the process schedule itself again. The FOR command in Batch files works REALLY well for that! On 22 Apr 2002 at 6:47, Rodney Broom wrote: Good morning Daniel, From: Daniel Jarrett [EMAIL PROTECTED] ...for mysql to perform daily operations.. You bet, it's called 'cron'. MySQL doesn't have anything like scheduling built in. And, arguably, it shouldn't. Since that type of functionality is the responsibility of the operating envoriment and not of the application. If you are using a UNIX like OS, type 'man cron'. If not UNIX, hollar and I'm sure that somebody can tell you how to work it out on your system. --- Rodney Broom sql --Opus-- Why program by hand in five days what you can spend five years of your life automating? - Terence Parr Get added to my Humor list: mailto:[EMAIL PROTECTED]?subject=ADD_HUMOR Get added to my Neat list: mailto:[EMAIL PROTECTED]?subject=ADD_NEAT Get my PGP public key: mailto:[EMAIL PROTECTED]?subject=PSENDbody=send%20PublicKEY.asc Visit My Home Page: http://value.net/~opus/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
New Setup
Egor By default user 'root' has all privileges... Egor Show me the output of following: Egor SHOW GRANTS FOR 'root'@'localhost'; mysql show grants for 'root'@'localhost' - ; +--- --+ | Grants for root@localhost | +--- --+ | GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD 'password_obscured' | +--- --+ 1 row in set (0.00 sec) Ian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Having lots of tables
Hi, I have a question on a project i am currently on. I am adapting Phorum (www.phorum.org) to my own portal and have a doubt about MySQL. Phorum creates a table for each discussion forum. However, in the portal i work for, i currently have thousands of items that would potentially need a table (with a very little amount of records, rarely more than 10). I am talking of a maximun of 1 tables. Is there any reason to avoid having a large number of tables (which have the same structure)? Are there any considerations that I should have? Would doing just-one-big-table (with a forum-id) be advisable? 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
C MYSQL Struct
I am having trouble accessing the data in the MySQL struct for C (included in the mysqlclient libraries). I am specifically unable to access the *fields (array?) within the struct. My program fails with segmentation faults whenever I try to access any variables within *fields. Does the mysql_init( ) function or mysql_connect( ) function allocate memory for this variable. How does one access the data stored in *fields? Andrew - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Having lots of tables
From: Agustín Fernández [EMAIL PROTECTED] Is there any reason to avoid having a large number of tables (which have the same structure)? You might run into a limit on the number of open file handles, but you'd have to check the MySQL docs for how he handles it, and possibly your OS docs to see what the limit is. Would doing just-one-big-table (with a forum-id) be advisable? Very possibly. 100,000 records isn't huge, but it could be big enough to put a load on your machine. Unless you find a definative answer in the docs, I'd try testing both. --- Rodney Broom Programmer, R.Broom Consulting - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
table lock - which connection id own's it
AntiSpam - mysql, sql, query Version: 3.23.49a, MyISAM, NT, Solaris My app is 150 daemons writing logs to mysql. The main table is of fixed size but depends on four other tables for foreign keys (hash tables). These tables are uploaded once to the daemon at start-up. Occasionally, a new entry must be written into these hash tables. The procedure is to lock the table, insert entry, get the key (auto-increment field) and release the lock. But what if the connection dies during the update process. If this happens, how can I tell which connection id has the lock so I can kill it? I have tried: show full processlist - shows connection id's - no lock info show table status;- will not display until lock is removed show open tables - shows open table with comment in_use=1 but this could be normal operation. My understanding is that the lock will be removed once the connection dies (sql command kill id or the server terminates connection via timeout). I would to detect when the lock is on for a long period of time. Any ideas? Suggestions? David --- David E Lopez Org: SPS-ASP-SOC ATIC-CSAM Phone: 480-413-6251 email: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Execute Queries through Files
Hi everyone, I know that one can execute queries through files. can anyone please tell me how to do that. I am working on sgi-irix and mysql 3.22.*. also how can i view previous messages on mailing list since i just joined the list yesterday. SMIB, Univ of nebraska. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
aggregate functions, source code
Hi, I'm trying to convert a database I have from M$ Access to Mysql. I've done this pretty successfully but have come across a couple of sticky problems. I have been using first last aggregate functions within Access for some certain complex queries. It would make my life a lot simpler and more efficient if I could create/find a similar function with mysql. I have spent the last couple of days searching the net for some information on this issue and have found that short of writing my own in gcc I out of luck. I have managed to compile the udf_example.cc libraries that come with Mysql. I was wondering, has anyone out there got some source code for a first last function? I haven't done any C programming for 7+ years and even then it was only minimal. So I'm only a newbe in that area. I would love to get our database ported to Mysql but without this its going to make it pretty difficult. Ideas or alternative solutions anyone? Thanks Heaps Cheers Miles Roper - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Execute Queries through Files
Q1: I am not sure what you mean by executing queries through files. Do you mean being able to run a query from a script like this? #!/bin/sh mysql -t -p password -u usename databasename EOF Select * From mytable; EOF Q2: There are mailing list archives available at http://lists.mysql.com . ..chris - Original Message - From: Imrani Baig Shah Masroor [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Execute Queries through Files I know that one can execute queries through files. can anyone please tell me how to do that. I am working on sgi-irix and mysql 3.22.*. also how can i view previous messages on mailing list since i just joined the list yesterday. SMIB, Univ of nebraska. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 crashes by large UPDATE in binlog!
Hello! I have a multi-server setup running replication. For some while now the slave server has started flipping out, and we have narrowed it down to that it gets a quite heavy update of several (5000) UPDATE blabla WHERE ID=1 OR ID=2 OR..ID=4999 the slave says segmentation fault and restarts due to safe_mysqld. nothing more than mysql ended is logged.. is there a bugfix for this, or does anyone at least know how to bypass this crash? we have at least one other slave that do not crash. rgards, Johan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Complex selection
Well..complex..for me at least! I have a table containing story's All storys have one unique `storyID` I have another table where I keep track of user's favorite story's. This table has two columns `clientID`and `storyID` after a while, you could end up having the following rows in favorite documents `clientID` `storyID` 15 119 16 12 23 219 388 f.e. if you select from the `library' story 19, you get the content, the author, the date etc... if you select from clients, client 2, you'll get all the client's information. But!! I want to select all the story's from favorite documents where `clientID` = 1; In this, I get the content, the author, etc..etc from storyID 5, 19, 6 and 2 (the above example) Do you understand all this? Or is it big blurry thing? I could send you print out's from my database... Thank in advance!!! Thijs Thiessens (mySQL is gd!!) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Execute Queries through Files
do you mean to execute a query that's written in a file? if so, there are two ways: for bournse shell type shells ( including WinNT/2K ) mysql --user=myname --password=mypassword -D dbname -v file.sql outfile.log21 for c-shell based shells mysql --user=myname --password=mypassword -D dbname -v file.sql outfile.log or from inside a session: mysql \T outfile.log mysql \. file.sql copy of query and output captured in outfile.log. At 4/22/2002 05:38 PM, you wrote: Hi everyone, I know that one can execute queries through files. can anyone please tell me how to do that. I am working on sgi-irix and mysql 3.22.*. also how can i view previous messages on mailing list since i just joined the list yesterday. SMIB, Univ of nebraska. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Question about mysql++ and g++
Ok, i downloaded the mysql++-1.7.8-1.i386.rpm ftp://ftp.rpmfind.net/linux/MySQL/mysql++/mysql++-1.7.8-1.i386.rpm rpm file from RpmFind.net. I have mysql installed already on my machine, o ya and im running linux. I have gcc installed, version 2.96, i think everything installed correctly when i ran the rpm. But i am not sure. I made a simple program, here it is: #include sqlplus.hh int main() { return 0; } When i tried to compile it using g++ mysql.cpp i got a bunch of errors saying mysql.h not found (errors are printed on bottom of email). So i tried doing a locate mysql.h and it only found the mysql.h file from my windows partition (i have mysql++ installed on windows...). I am not sure if its my compiler, or the version of mysql++ i installed. Another question i have is it says to reset my database using reset-db, where would i do that? The mysql command line? If anyone can help me, give me some ideas if my install went wrong, or if i need to update gcc, or get a different compiler (i dont know any for linux yet! ) id appreciate it very much! ~Mike -ERRORS-- [stigmasix@localhost practice]$ g++ mysql.cpp In file included from /usr/include/sqlplus.hh:9, from mysql.cpp:1: /usr/include/defs:5:19: mysql.h: No such file or directory In file included from /usr/include/coldata1.hh:8, from /usr/include/sqlplus.hh:12, from mysql.cpp:1: /usr/include/type_info1.hh:10:19: mysql.h: No such file or directory In file included from /usr/include/vallist1.hh:6, from /usr/include/row1.hh:11, from /usr/include/compare1.hh:5, from /usr/include/sqlplus.hh:13, from mysql.cpp:1: /usr/include/manip1.hh:10:19: mysql.h: No such file or directory In file included from /usr/include/sqlplus.hh:14, from mysql.cpp:1: /usr/include/connection1.hh:10:19: mysql.h: No such file or directory In file included from /usr/include/connection1.hh:20, from /usr/include/sqlplus.hh:14, from mysql.cpp:1: /usr/include/query1.hh:10:19: mysql.h: No such file or directory In file included from /usr/include/query1.hh:13, from /usr/include/connection1.hh:20, from /usr/include/sqlplus.hh:14, from mysql.cpp:1: /usr/include/result1.hh:12:19: mysql.h: No such file or directory In file included from /usr/include/sqlplus.hh:57, from mysql.cpp:1: /usr/include/coldata3.hh:10:19: mysql.h: No such file or directory - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Complex selection
Well..complex..for me at least! I have a table containing story's All storys have one unique `storyID` I have another table where I keep track of user's favorite story's. This table has two columns `clientID`and `storyID` after a while, you could end up having the following rows in favorite documents `clientID` `storyID` 15 119 16 12 23 219 388 f.e. if you select from the `library' story 19, you get the content, the author, the date etc... if you select from clients, client 2, you'll get all the client's information. But!! I want to select all the story's from favorite documents where `clientID` = 1; In this, I get the content, the author, etc..etc from storyID 5, 19, 6 and 2 (the above example) Do you understand all this? Or is it big blurry thing? I could send you print out's from my database... Thank in advance!!! Thijs Thiessens (mySQL is gd!!) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Complex selection
JOIN is what you need. http://www.mysql.com/doc/J/O/JOIN.html Some examples: mysql SELECT * FROM table1,table2 WHERE table1.id=table2.id; mysql SELECT * FROM table1 LEFT JOIN table2 ON table1.id=table2.id; mysql SELECT * FROM table1 LEFT JOIN table2 USING (id); mysql SELECT * FROM table1 LEFT JOIN table2 ON table1.id=table2.id - LEFT JOIN table3 ON table2.id=table3.id; mysql SELECT * FROM table1 USE INDEX (key1,key2) - WHERE key1=1 AND key2=2 AND key3=3; mysql SELECT * FROM table1 IGNORE INDEX (key3) - WHERE key1=1 AND key2=2 AND key3=3; Mike T.Thiessens wrote: Well..complex..for me at least! I have a table containing story's All storys have one unique `storyID` I have another table where I keep track of user's favorite story's. This table has two columns `clientID`and `storyID` after a while, you could end up having the following rows in favorite documents `clientID` `storyID` 15 119 16 12 23 219 388 f.e. if you select from the `library' story 19, you get the content, the author, the date etc... if you select from clients, client 2, you'll get all the client's information. But!! I want to select all the story's from favorite documents where `clientID` = 1; In this, I get the content, the author, etc..etc from storyID 5, 19, 6 and 2 (the above example) Do you understand all this? Or is it big blurry thing? I could send you print out's from my database... Thank in advance!!! Thijs Thiessens (mySQL is gd!!) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
multiple mysql daemons in process
Hello list, I have 38 mysqld processes running in one single machine, is it normal? 11:48:43 up 49 days, 15:11, 34 users, load average: 0.02, 0.06, 0.00 275 processes: 265 sleeping, 1 running, 9 zombie, 0 stopped CPU states: 3.2% user, 4.3% system, 0.0% nice, 92.5% idle Mem:900464K total, 840808K used,59656K free, 277532K buffers Swap: 498004K total, 327808K used, 170196K free, 221132K cached PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND 31277 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:04 mysqld 31279 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:07 mysqld 31280 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:00 mysqld 31281 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:00 mysqld 31282 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:00 mysqld 31283 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:00 mysqld 31284 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:00 mysqld 31285 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:12 mysqld 31286 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:02 mysqld 31287 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:01 mysqld 31288 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:00 mysqld 31738 mysql 9 0 300M 30M 3004 S 0.0 3.5 4:11 mysqld 7110 mysql 10 0 300M 30M 3004 S 0.5 3.5 6:22 mysqld 12137 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:59 mysqld 16802 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:02 mysqld 16841 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:02 mysqld It seems mysqld has used all of my memory. Any idea? -- Patrick Hsieh [EMAIL PROTECTED] GPG public key http://pahud.net/pubkeys/pahudatezplay.gpg -- Patrick Hsieh [EMAIL PROTECTED] GPG public key http://pahud.net/pubkeys/pahudatpahud.gpg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Cant connect using socket ''(111) for Mysqlgui on linux
Hello All Is there any installation instructions for Mysqlgui1.7.5 on linux. Also i have installed it and while trying to connect it says couldnt connect using Socket''(111) and also can some one throw light on sql command on connet or Socket dialog in options window and what showuld really go in there thanks in advance Krishna Kumar S. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: multiple mysql daemons in process
This is an artifact of Linux's thread implementation. man 2 clone Also it's not using -that- much memory. Note the SHARE (for memory shared between processes) column. It's not pretty, but it's totally harmless. NOTE: There's always -some- weirdness that goes on with threads implementations between different systems. On Linux, this is it. -M On Tue, Apr 23, 2002 at 11:51:49AM +0800, Patrick Hsieh wrote: I have 38 mysqld processes running in one single machine, is it normal? 11:48:43 up 49 days, 15:11, 34 users, load average: 0.02, 0.06, 0.00 275 processes: 265 sleeping, 1 running, 9 zombie, 0 stopped CPU states: 3.2% user, 4.3% system, 0.0% nice, 92.5% idle Mem:900464K total, 840808K used,59656K free, 277532K buffers Swap: 498004K total, 327808K used, 170196K free, 221132K cached PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND 31277 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:04 mysqld 31279 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:07 mysqld 31280 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:00 mysqld 31281 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:00 mysqld 31282 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:00 mysqld 31283 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:00 mysqld 31284 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:00 mysqld 31285 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:12 mysqld 31286 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:02 mysqld 31287 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:01 mysqld 31288 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:00 mysqld 31738 mysql 9 0 300M 30M 3004 S 0.0 3.5 4:11 mysqld 7110 mysql 10 0 300M 30M 3004 S 0.5 3.5 6:22 mysqld 12137 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:59 mysqld 16802 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:02 mysqld 16841 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:02 mysqld It seems mysqld has used all of my memory. Any idea? -- Patrick Hsieh [EMAIL PROTECTED] GPG public key http://pahud.net/pubkeys/pahudatezplay.gpg -- Patrick Hsieh [EMAIL PROTECTED] GPG public key http://pahud.net/pubkeys/pahudatpahud.gpg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Michael Bacarella | Netgraft Corporation | 545 Eighth Ave #401 Systems Analysis | New York, NY 10018 Technical Support | 212 946-1038 | 917 670-6982 Managed Services | [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 3.23.44 not using indexes
A search for 'indexes' brings this as the first result: 5.4.3 How MySQL Uses Indexes http://www.mysql.com/doc/M/y/MySQL_indexes.html Inside the page: Any index that doesn't span all AND levels in the WHERE clause is not used to optimise the query. In other words: To be able to use an index, a prefix of the index must be used in every AND group. [Note: optimize is spelled wrong in the manual.] The corollary to the above quote is that MySQL can not use indexes with an OR clause at the base level. It would be a worthy optimization to make. MySQL could order the items in the OR clause of the query, skipping ahead when one section is complete and on to the next (assuming a single index would be used). Or it could internally create a temp table and break the WHERE clause into several smaller queries that do use indexes. In fact, you can do that yourself as well (either using temp tables or UNIONs in version 4). Makes for messy SQL writing to work around this optimization issue, so I'm sure someone will add it to MySQL some day. Maybe it will be you! :) Sincerely, Steven Roussey http://Network54.com/?pp=e - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 3.23.44 not using indexes
On Mon, Apr 22, 2002 at 10:26:22PM -0700, Steven Roussey wrote: Inside the page: Any index that doesn't span all AND levels in the WHERE clause is not used to optimise the query. In other words: To be able to use an index, a prefix of the index must be used in every AND group. [Note: optimize is spelled wrong in the manual.] It is spelt in English, not American. That is not wrong! -- John Birrell http://r1-magic.ws/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php