Re: JBuilder6 and mm.mysql-2.0.11
TAKAHASHI, Tomohiro wrote: Do you want to use mm mysql Driver with JB6's DataPilot? What kind of error does DataPilot say? Here is the stack trace: See com.borland.dx.dataset.DataSetException error code: BASE+82 com.borland.dx.dataset.DataSetException: The driver: org.git.mm.mysql.Driver could not be loaded. This could be a problem with the driver itself, or that the driver is not found on the classpath. at com.borland.dx.dataset.DataSetException.a(Unknown Source) at com.borland.dx.dataset.DataSetException.driverNotLoadedInDesign(Unknown Source) at com.borland.dx.sql.dataset.Database.addDriver(Unknown Source) at com.borland.dx.sql.dataset.Database.addDrivers(Unknown Source) at com.borland.dx.sql.dataset.Database.openConnection(Unknown Source) at com.borland.jdbcx.metadata.DatabaseInfo.openConnection(Unknown Source) at com.borland.jdbcx.metadata.e.run(Unknown Source) -- Lonnie Wormley [EMAIL PROTECTED] [Linux and Java] [EMAIL PROTECTED] [Window$ and graphics] http://www.launi.com http://www.zaramyth.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
random (load-related?) unknown database errors
MySQL every so often will return unknown database errors for no apparent reason on a FreeBSD 4.4 (and earlier 4.x versions) server I maintain. This affects different user, scripts, and databases. One user says there is a big slowdown around each event, perhaps a load issue, but at least when I check the symptoms are gone. The databases clearly haven't moved. What could cause this? Are there any fixes or workarounds? I also see the 99% CPU issue frequently, but as I see in the list archive that hasn't been tracked down yet. -- Jeff DeFouw [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[3]: group by timestamp field
Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: Hi, Field1 (varchar) , Field 2 (timestamp) . I want to do : select count(*) , field1 , group by field1 . That's ok , but i'd like to get results like : 2002-01-01 3 2002-01-02 4 . How can i do that considering the timestamp field which stores date like (20020314184748) , thus containg the hour , second , etc ? Try something like: select substring(field2, 1, 8), count(*) from yourtable group by substring(field2, 1, 8); Regards, Sasa - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
All threads used up!
We have a problem with other system.. When a service that uses the MySQL database loops and so creates to many connects to the DB it uses up all the available connections. So we have DOS from aware own server. I know that we can limit the connections used over 1 hour but I need to set a max connections for each server. Is there a way to limit connections to one port per IP? FreeBSD 4.4 MySQL Latest Stable Thanks Simon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 do when the table files become bigger and bigger
Hi, all: I am doing a project that we will insert a lot of data to mysql by C API everyday, so the table files will become bigger and bigger, it will not only takea long time to query,but also lead to the file size limits. In order to query fast and avoid leading to the file size limits, I have several ways to resolve it: 1) create all the tables in that database every month. 2) create a new database every month. 3) other ways that I don't know. Would you please give some advise on which one should I choose? Are there some artiles related? Thanks for any help. B.R. budingc - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
keeping given order in resulset
Hello ! I got a table having an auto_increment field, let's say 'id'. tis table has a varchar field too, let's say 'name'. Is there a way to do something like: select id, name from table where id in (5,3,7) AND that mysql orders the results the way I gave into the 'IN(...)' clause ? So I would have resultset like: | id | name | | 5 | 'foo' | | 3 | 'bar' | | 7 | 'foobar' | Thanks, Mickael - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: keeping given order in resulset
On Friday, 22. March 2002 10:43, Mickael Bailly wrote: Hello ! I got a table having an auto_increment field, let's say 'id'. tis table has a varchar field too, let's say 'name'. Is there a way to do something like: select id, name from table where id in (5,3,7) AND that mysql orders the results the way I gave into the 'IN(...)' clause ? Hi Mickael, you can use the find_in_set function e.g. select id,name from table where find_in_set (id, 5,3,7); But you can't order them in the order specified in set. Regards Georg Only for the spam filter: mysql rulez! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: group by timestamp field
Hi!! You can try select format_date(field2, '%m %d %Y)as timestamp, count(*), field1 from mad group by field1 all the best, Jayasimhan A - Original Message - From: cristian ditoiu [EMAIL PROTECTED] To: mysql [EMAIL PROTECTED] Sent: Friday, March 22, 2002 1:20 PM Subject: group by timestamp field I have MySql database containing a table mad by several fields among wich : Field1 (varchar) , Field 2 (timestamp) . I want to do : select count(*) , field1 , group by field1 . That's ok , but i'd like to get results like : 2002-01-01 3 2002-01-02 4 . How can i do that considering the timestamp field which stores date like (20020314184748) , thus containg the hour , second , etc ? Thank you - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Boolean Fulltext in 4.0.2 bug
Hi, I know, many fulltext bugs fixed last two weeks, thanks! But this nice mysql4 feature are critical for us, we plan to use it in many projects... and we test it again and again... :) My test case: http://www.graphit.ru/fulltext402.tar.gz test.res - output from 4.0.2 cloned 2002-03-21. With best wishes, Alexander Hmm, there were bugs quite similar to this one fixed recently. Can you create a test case ? Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: keeping given order in resulset
Try order by id. All the best, Jayasimhan A - Original Message - From: Mickael Bailly [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 22, 2002 3:13 PM Subject: keeping given order in resulset Hello ! I got a table having an auto_increment field, let's say 'id'. tis table has a varchar field too, let's say 'name'. Is there a way to do something like: select id, name from table where id in (5,3,7) AND that mysql orders the results the way I gave into the 'IN(...)' clause ? So I would have resultset like: | id | name | | 5 | 'foo' | | 3 | 'bar' | | 7 | 'foobar' | Thanks, Mickael - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
pruning
Placed At : MAA Vijay T@SATYAM 03/22/2002 04:30 PM Hi I have to delete the unwanted things from my mysql db pls sugges me to go ahead thanks vijayt - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: keeping given order in resulset
Hello, there is no difference between select id, name from table where id in (5,3,7) and select id,name from table where find_in_set (id, 5,3,7); Or I didn't see it... anyway this doesn't solve my problem. Mickael On Friday 22 March 2002 11:32, Georg Richter wrote: On Friday, 22. March 2002 10:43, Mickael Bailly wrote: Hello ! I got a table having an auto_increment field, let's say 'id'. tis table has a varchar field too, let's say 'name'. Is there a way to do something like: select id, name from table where id in (5,3,7) AND that mysql orders the results the way I gave into the 'IN(...)' clause ? Hi Mickael, you can use the find_in_set function e.g. select id,name from table where find_in_set (id, 5,3,7); But you can't order them in the order specified in set. Regards Georg Only for the spam filter: mysql rulez! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- NetClub'ment votre, Mickael Bailly - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: keeping given order in resulset
Hello, the 'order by' clause just order my results by ascending value, but don't keep the order I gave in the 'IN(...)' clause.. So it doesn't solve my problem. Mickael On Friday 22 March 2002 12:08, Jayasimhan A wrote: Try order by id. All the best, Jayasimhan A - Original Message - From: Mickael Bailly [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 22, 2002 3:13 PM Subject: keeping given order in resulset Hello ! I got a table having an auto_increment field, let's say 'id'. tis table has a varchar field too, let's say 'name'. Is there a way to do something like: select id, name from table where id in (5,3,7) AND that mysql orders the results the way I gave into the 'IN(...)' clause ? So I would have resultset like: | id | name | | 5 | 'foo' | | 3 | 'bar' | | 7 | 'foobar' | Thanks, Mickael - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 -- NetClub'ment votre, Mickael Bailly - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 hangs on reqular SQL-query
Hi all, I have a problem with a table in the database. I created it a while ago (a month maby) and then everything worked fine. Now however, every time I query the table the query hangs and I don't know why. I understand that it's difficult to tell me what the problem is based on that little information. But could someone tell me where I should start looking? Can I give some more information about the table, query or database that would help tracing the problem? My mysql version: Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686) This is the table: CREATE TABLE FOR_SALE ( ISBN VARCHAR(10) NOT NULL, STOREID MEDIUMINT(8) UNSIGNED NOT NULL, MYDATE DATE NOT NULL, PRICE SMALLINT UNSIGNED NOT NULL, PRIMARY KEY (ISBN, STOREID, MYDATE) ); FOR_SALE has about 20 rows. These are the processes: mysql SHOW PROCESSLIST; +-+-+---+-+-+--+---+---+ | Id | User| Host | db | Command | Time | State | Info | +-+-+---+-+-+--+---+ ---+ | 5393322 | jacob | localhost | jacob | Query | 564 | Waiting for table | Select count(*) from FOR_SALE | | 5394177 | jacob | localhost | jacob | Query | 0| NULL | SHOW PROCESSLIST | +-+-+---+-+-+--+---+ ---+ 2 rows in set (0.00 sec) I've been using the mysql db for almost 2 years now and this thing has never happened before. Please help me finding the problem. Thanks, Jacob _ Chatta med vänner online, prova MSN Messenger: http://messenger.msn.se - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Optimizing tables
Placed At : MAA Vijay T@SATYAM 03/22/2002 04:44 PM Hi how do i optimize mysql tables vijay - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 hangs on reqular SQL-query #2
Hi again, Little more information about the problem that I wrote about in my last email. As I said before, the database wont accept any query to that table. It just hangs. However I'm not sure of which query that is executed the first time the table hangs. I'm not sure if this matters. But if it do I might be able to find out. Thanks, Jacob _ MSN Photos är det enklaste sättet att dela ut och skriva ut foton: http://photos.msn.se/Support/WorldWide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Optimizing tables
Hi, What about taking a look at the manuel before ? ;) http://www.mysql.com/doc/ Regards, Jocelyn Fournier - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 22, 2002 12:14 PM Subject: Optimizing tables Placed At : MAA Vijay T@SATYAM 03/22/2002 04:44 PM Hi how do i optimize mysql tables vijay - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Serious performance problems when using InnoDB
Hi, I'm using a db with few tables, one of which is reported below: CREATE TABLE `keywords` ( `keyword` varchar(128) NOT NULL default '', `codice` varchar(16) NOT NULL default '', `timestamp` int(11) NOT NULL default '0', `soundekw` varchar(32) NOT NULL default '', PRIMARY KEY (`keyword`,`codice`), KEY `codice` (`codice`) ) TYPE=InnoDB | My problem is that after having inserted more than 2-3 times roughly 70 records in it, every operation such as DELETE from keywords; or SELECT count(*) from keywords; slows to a crawl: it takes 15 minutes or so to complete. Sometimes I even have to dump, zap, recreate and reimport the db. My system is redhat linux 7.2, Mysql-Max 3.23.46 (official rpm) on a Dual PIII 550, 256 MB ram, Raid 1 on a Mylex Raid card and the following configuration for Innodb: innodb_data_home_dir = /home/share/innodb/ innodb_data_file_path = ibdata1:512M set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = /home/share/innodb/log/ 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=0 innodb_log_arch_dir = /home/share/innodb/log/ innodb_log_archive=1 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 I know this configurations doesn't look aggressive at all, but it shouldn't even lead to such a slow-down. Can anyone help me please? Thanks, Nico - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqldump : help needed very urgent
Hi, I am using Mysql version 3.23.47-Max client and server and using Innodb table type. I am doing my database backup using the mysqldump utility. Once I have done with database backup, I am deleting all my database and again recovering(creating) the database using the dumped file. Now, the question is after recovery of the database, I am not getting the foreign key relationship between the tables. Why this happens...? is it the problem with mysqldump...?? and if it really the case then how can i re-create my whole database and keep all my database retaining the foreign keys. If anyone can suggest me alternative method for doing the same then it will be very usful for me. Waiting for response. Thanks and Regards, Chetan Lavti - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Access denied on use mysql;
--- Kathy Reyes [EMAIL PROTECTED] wrote: Now I have a different problem. When I type mysql it gives me the message Access denied for user: 'root@localhost' (Using password: NO) how do I get it to use the password. When I type mysql -u root -p I get in... ^ What do you mean? Can you see the mysql prompt. If you acn then what's the problem. type 'use mysql' then type 'show tables' then do select * from .. so on - Original Message - From: alan4100 [EMAIL PROTECTED] To: Kathy Reyes [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 2:55 PM Subject: Re: Access denied on use mysql; Kathy I see. - Original Message - From: Kathy Reyes [EMAIL PROTECTED] To: alan4100 [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 12:48 PM Subject: Re: Access denied on use mysql; I just gave up, everything that I tried did not work. I killed mysql and then started with safe_mysql --skip-grant-tables then I was able to connect to mysql without an error. But when I tried to Grant all on mysql.* to root@localhost identified by password; it gave me the message Unknown Command. - Original Message - From: alan4100 [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 11:07 AM Subject: Re: Access denied on use mysql; mysql Hello Kathy, How have you made out with access to 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 __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.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 4.0.1-Alpha: Union + Limit bug.
[EMAIL PROTECTED] writes: Description: Take two tables (call them a and b), which have identical structures. Table a has no rows, table b has some (say 10) rows. If you do this: select * from a union select * from b limit 0,5 It works as expected. Now do this: select * from a union select * from b limit 5,5 Now you get _zero_ rows. In version 4.0.0, this worked as expected. Hi! Thank you for your bug report. This is a known bug and is already fixed. Fix will come up in 4.0.2 which should be out in two weeks or less. -- 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: JBuilder6 and mm.mysql-2.0.11
Hi, Lonnie Lonnie Wormley wrote: TAKAHASHI, Tomohiro wrote: Do you want to use mm mysql Driver with JB6's DataPilot? What kind of error does DataPilot say? Here is the stack trace: See com.borland.dx.dataset.DataSetException error code: BASE+82 com.borland.dx.dataset.DataSetException: The driver: org.git.mm.mysql.Driver could not be loaded. This could be a problem org.gjt.mm.mysql.Driver ^ Thanks. -- TAKAHASHI, "KEN", Tomohiro - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: keeping given order in resulset
* Mickael Bailly I got a table having an auto_increment field, let's say 'id'. tis table has a varchar field too, let's say 'name'. Is there a way to do something like: select id, name from table where id in (5,3,7) AND that mysql orders the results the way I gave into the 'IN(...)' clause ? So I would have resultset like: | id | name | | 5 | 'foo' | | 3 | 'bar' | | 7 | 'foobar' | Yes, you can use the FIELD() function: select id, name from table where id in (5,3,7) order by field(id,5,3,7); -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Tables stops at row 126
Hi, I'm new to DB's and MySQL I encountered a problem with my pictures-DB which I with PHP. The table's stops at row 126, all photos I store in DB afterwards all get the ID 127. I don't know if it's php or MySQL causing this. My table structure is field typeAllow Nulls Key Default Value Albumid tinyint(4) No None0 Any solution Best regards Mikael - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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
Thank you for your bug report.
This bug is now fixed in 3.23.50, which will very soon be available.
This is a patch that fixes a bug :
--- 1.12/sql/item.ccWed May 23 02:32:52 2001
+++ 1.13/sql/item.ccFri Mar 22 14:03:42 2002
@@ -59,12 +59,28 @@
}
}
-bool Item::eq(const Item *item) const // Only doing this on conds
+/*
+ This function is only called when comparing items in the WHERE clause
+*/
+
+bool Item::eq(const Item *item, bool binary_cmp) const
{
return type() == item-type() name item-name
!my_strcasecmp(name,item-name);
}
+bool Item_string::eq(const Item *item, bool binary_cmp) const
+{
+ if (type() == item-type())
+ {
+if (binary_cmp)
+ return !stringcmp(str_value, item-str_value);
+return !sortcmp(str_value, item-str_value);
+ }
+ return 0;
+}
+
+
/*
Get the value of the function as a TIME structure.
As a extra convenience the time structure is reset on error!
@@ -202,7 +218,7 @@
return result_field-val_int();
}
-bool Item_field::eq(const Item *item) const
+bool Item_field::eq(const Item *item, bool binary_cmp) const
{
return item-type() == FIELD_ITEM ((Item_field*) item)-field == field;
}
@@ -245,7 +261,8 @@
str-append('\'');
}
-bool Item_null::eq(const Item *item) const { return item-type() == type(); }
+bool Item_null::eq(const Item *item, bool binary_cmp) const
+{ return item-type() == type(); }
double Item_null::val() { null_value=1; return 0.0; }
longlong Item_null::val_int() { null_value=1; return 0; }
/* ARGSUSED */
--- 1.12/sql/item.h Wed Oct 31 18:27:48 2001
+++ 1.13/sql/item.h Fri Mar 22 14:03:42 2002
@@ -56,7 +56,7 @@
virtual void save_org_in_field(Field *field)
{ (void) save_in_field(field); }
virtual bool send(String *str);
- virtual bool eq(const Item *) const;
+ virtual bool eq(const Item *, bool binary_cmp) const;
virtual Item_result result_type () const { return REAL_RESULT; }
virtual enum Type type() const =0;
virtual double val()=0;
@@ -109,7 +109,7 @@
{}
Item_field(Field *field);
enum Type type() const { return FIELD_ITEM; }
- bool eq(const Item *item) const;
+ bool eq(const Item *item, bool binary_cmp) const;
double val();
longlong val_int();
String *val_str(String*);
@@ -138,7 +138,7 @@
Item_null(char *name_par=0)
{ maybe_null=null_value=TRUE; name= name_par ? name_par : (char*) NULL;}
enum Type type() const { return NULL_ITEM; }
- bool eq(const Item *item) const;
+ bool eq(const Item *item, bool binary_cmp) const;
double val();
longlong val_int();
String *val_str(String *str);
@@ -247,6 +247,7 @@
void make_field(Send_field *field);
enum Item_result result_type () const { return STRING_RESULT; }
bool basic_const_item() const { return 1; }
+ bool eq(const Item *item, bool binary_cmp) const;
Item *new_item() { return new Item_string(name,str_value.ptr(),max_length); }
String *const_string() { return str_value; }
inline void append(char *str,uint length) { str_value.append(str,length); }
@@ -306,7 +307,8 @@
Item_ref(Item **item, char *table_name_par,char *field_name_par)
:Item_ident(NullS,table_name_par,field_name_par),ref(item) {}
enum Type type() const { return REF_ITEM; }
- bool eq(const Item *item) const { return (*ref)-eq(item); }
+ bool eq(const Item *item, bool binary_cmp) const
+ { return (*ref)-eq(item, binary_cmp); }
~Item_ref() { if (ref) delete *ref; }
double val()
{
--- 1.46/sql/item_func.cc Thu Dec 27 02:04:27 2001
+++ 1.47/sql/item_func.cc Fri Mar 22 14:03:42 2002
@@ -148,7 +148,7 @@
str-append(')');
}
-bool Item_func::eq(const Item *item) const
+bool Item_func::eq(const Item *item, bool binary_cmp) const
{
/* Assume we don't have rtti */
if (this == item)
@@ -160,7 +160,7 @@
func_name() != item_func-func_name())
return 0;
for (uint i=0; i arg_count ; i++)
-if (!args[i]-eq(item_func-args[i]))
+if (!args[i]-eq(item_func-args[i], binary_cmp))
return 0;
return 1;
}
@@ -1882,7 +1882,7 @@
str-append(')');
}
-bool Item_func_get_user_var::eq(const Item *item) const
+bool Item_func_get_user_var::eq(const Item *item, bool binary_cmp) const
{
/* Assume we don't have rtti */
if (this == item)
@@ -2135,7 +2135,7 @@
return 1;
}
-bool Item_func_match::eq(const Item *item) const
+bool Item_func_match::eq(const Item *item, bool binary_cmp) const
{
if (item-type() != FUNC_ITEM)
return 0;
@@ -2146,7 +2146,7 @@
Item_func_match *ifm=(Item_func_match*) item;
if (key == ifm-key table == ifm-table
- key_item()-eq(ifm-key_item()))
+ key_item()-eq(ifm-key_item(), binary_cmp))
return 1;
return 0;
--- 1.24/sql/item_func.hThu Dec 27 02:04:27 2001
+++ 1.25/sql/item_func.hFri Mar 22 14:03:42 2002
@@ -98,7 +98,7 @@
void make_field(Send_field *field);
table_map used_tables() const;
void update_used_tables();
- bool eq(const
querying check constraints
Hi,
I have created a table as below:
create table myTable
(
Field1 int auto_increment not null,
Field2 varchar(25) not null,
Field2 enum('Fair','Good','Excellent'),
primary key (Field1))
auto_increment=1
I would like to know how to query the table for only
the enum values I have created.
Sukhdev.
__
Do You Yahoo!?
Yahoo! Movies - coverage of the 74th Academy Awards®
http://movies.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: Tables stops at row 126
On Friday, 22. March 2002 14:04, [EMAIL PROTECTED] wrote: Hello, I encountered a problem with my pictures-DB which I with PHP. The table's stops at row 126, all photos I store in DB afterwards all get the ID 127. I don't know if it's php or MySQL causing this. My table structure is field typeAllow Nulls Key Default Value Albumid tinyint(4) No None0 Any solution please read the manual section column types: http://www.mysql.com/doc/C/o/Column_types.html tinyint has a range from -128 to 127. If you have more rows than 127 use unsigned tinyint (0..255) or int. Regards Georg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 2005: Unknown MySql Server Host 'host' (11001).
Hi there, I have gone thru the pdf doc's etc and i have been playiing around with devshed articles as well as being a db programmer using PostgreSql v7 on my Linux Box and that horrible thingy called M$ Access 2000 ( The non-cocurrent issue) on my Win98 Box. Nevertheless i have been ok so far upto now! The problem is that when i try to run mysql server i get the following error ERROR 2005: Unknown MySql Server Host 'host' (11001). Setup - Mysql v3 O/S Win 98 utilising the mysqladmin mysqlManager I have tried from ms-dos C:\mysql\bin msqladmin everthings fine C:\mysql\bin\mysqladmin - h host -u user -p prompt for password still ok then i get the above error so i am unable to go in as root. I know that the default port 3306 and i believe that i have host as localhost correctly When i go via mysql \ bin mysqld \ i am unable to enter any commands thus have to \c to clear buffer. and when i get the mysql prompt which to me indicates the MySql is running agian on command \s states that the current user is ODBC@localhost (I installed that driver to hook up to my M$ Access mdb. Thus i have tried that telnet thing and don't get much of info back as below telnet feedback. *** 2 3.23.49-max-debug[] ecCbgGxH [] weired hey *** Any suggestions as i would like to take this tool forward as it's clearly a powerful db (Once i can drive i'll d/load MySql v4 ) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Access denied on use mysql;
Kathy, Thursday, March 21, 2002, 7:48:10 PM, you wrote: KR I just gave up, everything that I tried did not work. KR I killed mysql and then KR started with safe_mysql --skip-grant-tables KR then I was able to connect to mysql without an error. KR But when I tried to KR Grant all on mysql.* to root@localhost identified by password; KR it gave me the message Unknown Command. Kathy, if you start mysqld with --skip-grant-tables option you should do FLUSH PRIVILEGES before using GRANT statement. -- 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
pruning
Vijay, Friday, March 22, 2002, 1:00:24 PM, you wrote: V I have to delete the unwanted things from my mysql db Use DELETE statement. You can find description of it in the manual: http://www.mysql.com/doc/D/E/DELETE.html V thanks V vijayt -- 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
Compile time issue?
Aragon, Thursday, March 21, 2002, 10:35:06 PM, you wrote: AA I have compiled mysql-3.23.49 from source distribution on a NetBSD AA 1.5.2 (sparc) box. Everything compiled fine, no-errors. Installed fine, AA no-errors. Starts and Stops fine no-errors. But when I go to run mysql or AA mysqladmin I get the following error: AA # /usr/local/mysql/bin/mysql AA Cannot open ../libmysql/.libs/libmysqlclient.so AA So I created a link from /usr/local/mysql/lib/mysql to AA /usr/local/mysql/libmysql/.libs AA This fixes the problem if I am physically in the /usr/local/mysql/bin AA directory. But obviously I would prefer to be able to run them from AA anywhere. AA I am assuming this can be fixed by recompiling, but havn't been able to AA locate where to make the fix. You should add '/usr/local/lib' in the /etc/ld.so.conf After that execute 'ldconfig' command as root. AA Thanks in advance, AA -Kyle -- 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: Server startup error on Linux
Rance, Thursday, March 21, 2002, 9:30:26 PM, you wrote: RH I issued the chown command as indicated by Andreas RH but it doesnt help RH I still get the Table mysql.hosts doesnt exist RH I know that all the tables created by mysql_install_db are infact owned by RH mysql RH but the server daemon still cant find them Give me complete output of the error message - show us the contents of the .err file RH what next? -- 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
Optimizing tables
Vijay, Friday, March 22, 2002, 1:14:33 PM, you wrote: V how do i optimize mysql tables I think chapter 4.4.6.10 Table Optimization in MySQL manual will be useful for you. Look at: http://www.mysql.com/doc/O/p/Optimisation.html V vijay -- 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
load data local - strange message. ERROR 1148
Art, Friday, March 22, 2002, 7:10:24 AM, you wrote: AL I ran into the same problem you did. After some searching on the web, this AL is what I came up with: AL First save the text file in the directory corresponding to the database you AL are currently using (menagerie). So the file will be be AL c:\mysql\data\menagerie\pet.txt AL I then typed: AL mysql LOAD DATA INFILE pet.txt INTO TABLE pet; AL Notice I left out the LOCAL. I was having trouble specifying the file if AL the location was somewhere other than the directory corresponding to the AL database in question, but this will at least work. Give it a try and let me AL know how it works! Since 3.23.49 version of MySQL and newer for using LOAD DATA LOCAL you should start mysqld and mysql with '--local-infile' option. You can read more about LOAD DATA LOCAL at: http://www.mysql.com/doc/L/O/LOAD_DATA_LOCAL.html AL Hope this helped. AL -Art -- 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
Where can I get max backlog?
í¼ø¹Î, Friday, March 22, 2002, 8:48:56 AM, you wrote: I've set backlog of mysql to 100. And now I need to increase it. But I don't know how many backlog my OS can support. Where can I get that information and how can improve it. Although I use Red Hat 7.2, other OS's informations are also Okay. Run mysqld with -0 back_log=number_back_logs. Maximum length of the queue can be set using by tcp_max_syn_backlog. You can read about it in the man pages for Red Hat (man 2 listen). Any replys would be welcome. -- 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: Tables stops at row 126
* [EMAIL PROTECTED] I encountered a problem with my pictures-DB which I with PHP. The table's stops at row 126, all photos I store in DB afterwards all get the ID 127. I don't know if it's php or MySQL causing this. My table structure is field typeAllow Nulls Key Default Value Albumid tinyint(4) No None0 Any solution The datatype tinyint can only hold values from -128 to 127, unless it is defined as unsigned, then the range is 0-255. Change the datatype to something capable of holding bigger numbers...: alter table tablename change Albumid Albumid smallint unsigned; (Note that the field name is repeated, this is not a mistake.) The unsigned smallint datatype has a range 0-65535. This is in The Fine Manual... URL: http://www.mysql.com/doc/C/o/Column_types.html -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: ERROR 2005: Unknown MySql Server Host 'host' (11001).
* Chuck Amadi Nevertheless i have been ok so far upto now! The problem is that when i try to run mysql server i get the following error ERROR 2005: Unknown MySql Server Host 'host' (11001). Setup - Mysql v3 O/S Win 98 utilising the mysqladmin mysqlManager I have tried from ms-dos C:\mysql\bin msqladmin everthings fine C:\mysql\bin\mysqladmin - h host -u user -p prompt for password still ok then i get the above error so i am unable to go in as root. Unless you actually have a host called 'host', you should put your actual host name where the documentation says 'host'... if you are using localhost (server running on the machine you are using), you should not use the -h argument at all...: C:\ cd mysql\bin C:\mysql\bin mysql -u root -p -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
getting a bit confusing -
Hi me again , regarding my situation i was able to get a responce via mysql \r library(eexample db) localhost thus used the select cmd select * from members; and everthings fine . From the manual it does mention that certian installations allow user to connect as anonymous unamed user to the server running on the localhost thus i need no options . I basically want to enter MySql as the administrator thus utilise the cmd mysql -u root mysql this all worked fine but i have amended the host table with the sql data staements sql schema statemets except alter. ie i mean select, inser, update, delete, and also create and drop_priv using the insert into command. Have caused any major problem that can be reversed Cheers Chuckie Amadi Systems Programmer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: help with index/query
Using select Url from table where Ref like 'foo' gives these results: 1 row in set (2 min 11.54 sec) Using select Url from table where Ref = 'foo' gives these results: 1 row in set (8 min 47.69 sec) The same foo was used for each one of those queries. I believe the time problem has to do with the indexes - particularly the cardinality. But I am not sure based on the documentation. I am also a little reluctant to use myisamchk -a because I am afraid it will take a long time. So my questions again are: Is having a NULL CARDINALITY bad? Do I have to rebuild the index each time I dump the entire table and insert millions of rows? If so, what is the best way to do that? myisamchk -a? Duncan -- Duncan Salada | Titan | www.titan.com/testeval Email: [EMAIL PROTECTED] | Voice: 301-925-3222x375 | Fax: 301-925-3216 -Original Message- From: Gerald Clark [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 11:11 AM To: Salada, Duncan Cc: '[EMAIL PROTECTED]' Subject: Re: help with index/query what about select Url from table where Ref = 'foo' Salada, Duncan wrote: I am hoping I can get some help with a difficulty I am having with a table of mine. I am going to give a lot of background info, so please bear with me. First, let me say that I using 3.23.49. Now some info about the table. It currently has 5687391 rows. There are 3 columns in the table: ID (int), Url (varchar(255)), and Ref (varchar(255)). There are two indexes for the table: one on ID and the other on the first 15 characters of Ref. Now my problem: select queries on this table with no joins searching for a constant in the Refs column only are extremely slow. Here is what all the sql statements look like select Url from table where Ref like 'foo'. Pretty simple right? Here's the deal this table is used only by a little app that I wrote. Each time the app runs it queries this table as shown above about 4600 times with different values for foo. Each query seems to be taking about 2 minutes to execute. This seems odd to me because I tested it while I was writing the app and the queries were taking a little over a second. So I took a look at my table structure and my indexes. I noticed from SHOW INDEX that the CARDINALITY for the index on the Ref column is NULL. From reading about CARDINALITY in the manual that NULL value seems like a very bad thing. Every time my app runs (about once a month) I dump all of the rows in this table and insert about 5 million new rows. I do not drop the table and recreate it. I began thinking that perhaps the dumping and inserting is perhaps creating havoc with my index on the Ref column. So without further ado, here are my questions for the list: Is having a NULL CARDINALITY bad? Do I have to rebuild the index each time I dump the entire table and insert millions of rows? If so, what is the best way to do that - myisamchk -a? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Compiling on apache.
I have a problem with compiling mysql on HP-UX. I can't compile because it doesn't know that I have gcc. I have this error with ./configure : checking for gcc... cc checking whether the C compiler (cc -Ae -D_REENTRANT ) works... yes checking whether the C compiler (cc -Ae -D_REENTRANT ) is a cross-compiler... no checking whether we are using GNU C... no checking whether cc accepts -g... yes checking for c++... aCC checking whether the C++ compiler (aCC -D_REENTRANT ) works... no configure: error: installation or configuration problem: C++ compiler cannot create executables. what do i have to do ? tks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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
There might be a better way but here's a suggestion: When I needed to switch from an Access db to mysql I couldn't find any docs about exporting the table structures from Access to mysql, so I documented the Access db and manually built the same table structures in mysql. Then export the Access data as comma delimited files and import them into mysql. If you want to do this on a regular basis you could set a schedule(either human or with crontab) to periodically export the Access contents and reload the mysql tables. Andrew Hazen -Original Message- From: Mark Stringham [mailto:[EMAIL PROTECTED]] Sent: Friday, March 22, 2002 3:11 AM To: MySQL Subject: MySQL, MyODBC and MS Access I have a project where I may need to connect an MS ACCESS db and MySQL. I have read some pretty good documentation and know that is possible to take an existing Access db and export it to MYSQL. I have a few questions and wondered if someone might offer some insight. 1. Where must the Access db reside in order to talk with MySQL? 2. After the import to MySQL, if I insert new data into MySQL will the Access db be updated as well? I am looking for a way to access live MS Access data from the web. Obviously, I could connect directly to the Access db itself but with limited connections, I would think it would be hard to share the data . My thought was when someone updated the Access db, the data is then exported to MySQL. I then could use php, JSP or whatever to access the data from the web without having to worry about odbc connections. Am I way off here? Any help is appreciated. thanks Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 startup error on Linux
Ok Egor, here goes (not that it will give you any better information than I did already but since you asked...) exerpt from .err file follows 020318 14:30:48 mysqld started 020318 14:30:49 /usr/libexec/mysqld: Table 'mysql.host' doesn't exist 020318 14:30:49 mysqld ended exerpt from .err file ended because I have about 18 similar blocks in my .err file for each time I tried to start the server to see if I fixed the problem coping the entire .err file didnt make any sense. Again, this is after running the mysql_install_db and verifing that permissions to the files created by mysql_install_db are correct. --skip-grant-tables will allow the server to start, but a normal start is impossible Rance From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Server startup error on Linux Date: Fri, 22 Mar 2002 15:38:03 +0200 Rance, Thursday, March 21, 2002, 9:30:26 PM, you wrote: RH I issued the chown command as indicated by Andreas RH but it doesnt help RH I still get the Table mysql.hosts doesnt exist RH I know that all the tables created by mysql_install_db are infact owned by RH mysql RH but the server daemon still cant find them Give me complete output of the error message - show us the contents of the .err file RH what next? _ Send and receive Hotmail on your mobile device: http://mobile.msn.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
All threads used up
We have a problem with other system.. When a service that uses the MySQL database loops and so creates to many connects to the DB it uses up all the available connections. So we have DOS from aware own server. I know that we can limit the connections used over 1 hour but I need to set a max connections for each server. Is there a way to limit connections to one port per IP? FreeBSD 4.4 MySQL Latest Stable Thanks Simon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can you Change Nulls in the MySQLDump from \N?
On 21 Mar 2002, at 12:11, David M. Peak wrote: Is there a way to tell MySQL to put a blank space instead of \N in the tab-delimited files when it does a dump? I'm working on a MySQL to SQL Server migration and having problems with the output files. If you don't care about the distinction between nulls and blanks, then just change the table. If you do care, how do you plan to distinguish between them on import? Maybe you're just talking about numeric fields. I guess you could do the dump as a series of SELECT ... INTO OUTFILE statements and transform the NULLs into whatever you wanted, rather than using mysqldump. I'm doing this all in batch fellas so I'm not finding a good search and replace utility. (perl, c++, and other langs are not an option..) Why aren't they an option? Perl is an extremely easy solution to your problem (you can use a one-liner in your batch file), and if you don't tell us why it won't work we can't know what other solutions you've arbitrarily excluded. -- Keith C. Ivey [EMAIL PROTECTED] Washington, DC - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Windows 95 / Latest stable MySQL server start
I know I'm new to this and despite checking FAQs and the manual, am having difficulties getting MySQL to work properly under Windows 95. Unfortunately, I don't have a choice of operating system, even though I'm developing for Windows NT/2000. Anyway I have started the server with mysqld, a fact that can be proven (allegedly) by using a MySQL ping. WinMySQLAdmin 1.4 seems to think everything is okay, yet when I try to create a database I'm told the server must be started. Has anyone using MySQL had these problems with Windows 95? Or is it just me... Paul. This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Rotation of binary logs on replication master?
On Thu, 2002-03-21 at 13:07, Shawn McCool wrote: /usr/local/bin/mysql -hhostname -uusername -ppassword -e flush logs; I guess I wasn't clear that I wanted old binary logs removed. I don't want to have to manually worry about disk space due to ever increasing binary logs. It seems to me FLUSH LOGS just opens a new binary log. The old, unused ones are still left in place. I'm looking for a rotating set of say 4 kept. Anything older is deleted. Logrotate does this for Apache's logs for example. The RESET command seems to delete all binary logs. I don't want them all deleted, just very old ones. Any ideas? Thanks. Flush logs did the following: [root@nachos root]# du -h /var/lib/mysql/nachos* 4.0k/var/lib/mysql/nachos-bin.001 700M/var/lib/mysql/nachos-bin.002 4.0k/var/lib/mysql/nachos-bin.003 1.1G/var/lib/mysql/nachos-bin.004 350M/var/lib/mysql/nachos-bin.005 4.0k/var/lib/mysql/nachos-bin.006 189M/var/lib/mysql/nachos-bin.007 384M/var/lib/mysql/nachos-bin.008 4.0k/var/lib/mysql/nachos-bin.009 1.1G/var/lib/mysql/nachos-bin.010 289M/var/lib/mysql/nachos-bin.011 1.1G/var/lib/mysql/nachos-bin.012 1.1G/var/lib/mysql/nachos-bin.013 684M/var/lib/mysql/nachos-bin.014 4.0k/var/lib/mysql/nachos-bin.index 332k/var/lib/mysql/nachos-slow.log 4.0k/var/lib/mysql/nachos.us.pason.com.pid mysql FLUSH LOGS; [root@nachos root]# du -h /var/lib/mysql/nachos* 4.0k/var/lib/mysql/nachos-bin.001 700M/var/lib/mysql/nachos-bin.002 4.0k/var/lib/mysql/nachos-bin.003 1.1G/var/lib/mysql/nachos-bin.004 350M/var/lib/mysql/nachos-bin.005 4.0k/var/lib/mysql/nachos-bin.006 189M/var/lib/mysql/nachos-bin.007 384M/var/lib/mysql/nachos-bin.008 4.0k/var/lib/mysql/nachos-bin.009 1.1G/var/lib/mysql/nachos-bin.010 289M/var/lib/mysql/nachos-bin.011 1.1G/var/lib/mysql/nachos-bin.012 1.1G/var/lib/mysql/nachos-bin.013 684M/var/lib/mysql/nachos-bin.014 4.0k/var/lib/mysql/nachos-bin.015 4.0k/var/lib/mysql/nachos-bin.index 332k/var/lib/mysql/nachos-slow.log 4.0k/var/lib/mysql/nachos.us.pason.com.pid -- Guy Davis Phone: (403) 301-3426 Pason Systems Fax: (403) 301-3499 PGP: 65BA 484B 0B96 5F3B 4D40 DCA2 B2AE 6B5A F52B 1445 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: querying check constraints
I don't understand your question
-Original Message-
From: Sukhdev Sethi [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 22, 2002 7:20 AM
To: [EMAIL PROTECTED]
Subject: querying check constraints
Hi,
I have created a table as below:
create table myTable
(
Field1 int auto_increment not null,
Field2 varchar(25) not null,
Field2 enum('Fair','Good','Excellent'),
primary key (Field1))
auto_increment=1
I would like to know how to query the table for only
the enum values I have created.
Sukhdev.
__
Do You Yahoo!?
Yahoo! Movies - coverage of the 74th Academy Awards®
http://movies.yahoo.com/
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Serious performance problems when using InnoDB
At 05:53 AM 3/22/2002, you wrote: Hi, I'm using a db with few tables, one of which is reported below: CREATE TABLE `keywords` ( `keyword` varchar(128) NOT NULL default '', `codice` varchar(16) NOT NULL default '', `timestamp` int(11) NOT NULL default '0', `soundekw` varchar(32) NOT NULL default '', PRIMARY KEY (`keyword`,`codice`), KEY `codice` (`codice`) ) TYPE=InnoDB | My problem is that after having inserted more than 2-3 times roughly 70 records in it, every operation such as DELETE from keywords; or SELECT count(*) from keywords; slows to a crawl: it takes 15 minutes or so to complete. Delete from Table and and Select count(*) from Table works differently in InnoDb than MyISAM tables. With MyISAM both of these operations are instantaneous. With InnoDb they must delete each record individually or count each record individually and is much slower. If you need to delete all the rows from a large InnoDb table it is recommended that you drop the table and recreate it. (This is what Delete from MyISAMTable does behind the scenes.) How much faster are these operations after you re-import the data? Have you tried a show table status to determine how much data is actually being used? I noticed your configuration is set to innodb_data_file_path = ibdata1:512M and there is no reserve space. Granted you're probably using only 256MB of your 512MB, it is customary to define at least 2 file spaces as in: innodb_data_file_path = ibdata1:512M;ibdata2:512M You could as a last resort, dump all your data using MySQLDump, then shut down the MySQL server, backup your ibdata files to another drive, then drop your InnoDb tables (to get rid of the MySQL FRM files), drop the database, then delete the ibdata files, DEFRAG your drive, then recreate them from scratch using the 2 filespaces outlined above. Technically you don't have to blow away your database before expanding the InnoDb files, but starting from scratch will eliminate any prior problems with the disk space. One thing to watch out for with InnoDb is you can't drop a database without first dropping all the tables, otherwise the table space is still there. I don't know if this still applies to the latest version or not but it was going to be fixed sometime in the future. So starting from scratch after your volume has been defragged may speed things up for you. It will take you an hour or two, but then you will be starting from a clean slate. Now unless this table is going to have a lot of updates from a large number of users at the same time, you might be happier with a MyISAM table. InnoDB is great for multiple updates because of its record locking, but is much slower for updates from a single user and selects from multiple users. And from what I can remember, MyISAM tables don't require table locks when inserting new data. You only need table locks when deleting or updating existing rows. So if you're not doing a lot of deletes or updates, MyISAM might be a better choice. Just something to consider. Brent Sometimes I even have to dump, zap, recreate and reimport the db. My system is redhat linux 7.2, Mysql-Max 3.23.46 (official rpm) on a Dual PIII 550, 256 MB ram, Raid 1 on a Mylex Raid card and the following configuration for Innodb: innodb_data_home_dir = /home/share/innodb/ innodb_data_file_path = ibdata1:512M set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = /home/share/innodb/log/ 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=0 innodb_log_arch_dir = /home/share/innodb/log/ innodb_log_archive=1 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 I know this configurations doesn't look aggressive at all, but it shouldn't even lead to such a slow-down. Can anyone help me please? Thanks, Nico - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Unix Jobs?
I'm currently working as a e-commerce web programmer specializing in PHP, MySQL, and Apache systems. I've had experience on FreeBSD and Linux systems, and now the company I work for seems to be being bought out at which point, several of us may lose our jobs. Now, I've been searching all over Monster.com, HeadHunter.net, etc... for a compatible job in my area, but it just isn't panning out - most employers are Java and ASP hungry, and I couldn't classify myself as an expert on either at this point, even though I've worked with VB for a bit. My question is this: are there any job sites out there that deal more exclusively with the Unix world so I could find one in my area (Orange County, CA)? Also, is there anyone on this list that is currently looking to hire on a programmer like me? If you can answer yes to my second question, please respond in private - I don't want the MySQL mailing list to start flaming this post for some reason. Thanks! - Jonathan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: outer joins
Hi, did you get any answer ? I'm having the same problem. If i wanted all results from table1, even if they don't appear in table2 i would do like: SELECT . FROM table1 LEFT JOIN table2 ON (table1.id=table2.id) ... But how to join SELECT . FROM table1 LEFT JOIN table2 ON (table1.id=table2.id) ... and SELECT . FROM table2 LEFT JOIN table2 ON (table1.id=table2.id) ... ??? I have 2 solutions and don't like any of them. 1st SELECT ... FROM table3 LEFT JOIN table1 ON (table3.id=table1.id ..) LEFT JOIN table2 ON (table3.id=table2.id ..) but, obviously, this doesn work in cases of counts and sums.. (because table2 and table3 weren joined very well). 2nd Creating one temporary table with all keys that i want and with data table1. Idem for table2. Then, joining those 2 temporary tables will simple join will give me what i want. I simply don't like any of this solutions. Did you find a better solution ? Thanx in advance, On Thu, 2002-03-21 at 07:08, Van Overbeke, Tom wrote: Hi, I have two tables that i want to link via an outer join: mysql desc active_monitors; ++--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | ++--+--+-+-+---+ | monitor_id | int(7) | | PRI | 0 | | | endpoint | char(16) | | PRI | | | | monitor| char(75) | YES | | NULL| | | last_value | char(10) | YES | | NULL| | | last_update| datetime | YES | | NULL| | | sentry_profile | char(80) | | PRI | | | | status | char(10) | YES | | NULL| | ++--+--+-+-+---+ and mysql desc endpoints_defined_monitors; ++--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | ++--+--+-+-+---+ | monitor_id | int(7) | | PRI | 0 | | | monitor| char(75) | YES | | NULL| | | endpoint | char(16) | | PRI | | | | sentry_profile | char(80) | | PRI | | | ++--+--+-+-+---+ i link these tables with the following sql statement: select D.monitor, D.endpoint, A.monitor from endpoints_defined_monitors D, active_monitors A where A.monitor_id = D.monitor_ID and A.endpoint = D.endpoint and A.sentry_profile = D.sentry_profile however, in some cases, there is a record in endpoints_defined_monitors that doesn't exist in active_monitors, or maybe even the other way round. Can someone tell me how I can adapt my sql statement so that I also get these records (with the field 'monitor' having a NULL value ?). Thanks, Tom. Tom Van Overbeke Atos Origin Managed Services Unix/WAN/Tivoli Minervastraat 7 B-1930 Zaventem Tel. : +32 (2) 712 2650 Fax: +32 (2) 712 2622 E-mail : [EMAIL PROTECTED] -- 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
Re: mysql bug
Hi Sinisa! Thank you for your bug report. Thank /you/ for MySQL (: tam -- eCS 1.00, Ducati 750SS '92 up and running http://tam.belchenstuermer.de/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL, MyODBC and MS Access
hello mark, been doing this quite a bit recently but i cheat a bit... 1st step is to export the table from access as a text file - delimited by comma's. if you load up phpMyAdmin (available at http://www.phpwizard.net/projects/phpMyAdmin/), create your database and then mimic the table set up from access, you can then use the 'Insert textfiles into table' function to load all the information. a bit time consuming but it does work! phpMyAdmin is wicked as well hope this helps, jake I have a project where I may need to connect an MS ACCESS db and MySQL. I have read some pretty good documentation and know that is possible to take an existing Access db and export it to MYSQL. I have a few questions and wondered if someone might offer some insight. 1. Where must the Access db reside in order to talk with MySQL? 2. After the import to MySQL, if I insert new data into MySQL will the Access db be updated as well? I am looking for a way to access live MS Access data from the web. Obviously, I could connect directly to the Access db itself but with limited connections, I would think it would be hard to share the data . My thought was when someone updated the Access db, the data is then exported to MySQL. I then could use php, JSP or whatever to access the data from the web without having to worry about odbc connections. Am I way off here? Any help is appreciated. thanks Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Database thrash/load spikes under RedHat 7.1
Hi, We just moved our operation to a new hosting company, and in the process went from an old version of Slackware linux running MySQL 3.22.xx to systems running RedHat 7.1 and MySQL 3.23.37. When I do a large LOAD DATA INFILE or something else that puts a tidbit of strain on the database, all of a sudden mysql spins out of control, with connections piling up and the load meter spiking, until we hit the connection limit and then things start to calm back down. But it means that our website is more or less unavailable for 15 minutes or so. The database is running on its own server, a 1GHz machine with 1 GB of RAM. The disk is SCSI RAID 5. I've tried cranking up the various tuning parameters, based on the my-huge.cnf that comes with the source distribution. The binary we're running on is the one that comes with the system. I've already tried --memlock, as I've seen reports of the 2.4 linux kernel causing problems when it gets overly agressive about swapping things out. I've also managed to make my RH 7.2 box do this on a smaller scale, running the latest binary RPM from MySQL. Am I missing something obvious? 99% of the time the server is completely bored. Given that we've doubled our RAM and doubled our processor speed on the same size database, there's no reason the server should be running out of gas. -- Christopher Manly Akademos, Inc. 438 West State Street Ithaca, New York 14850 607-269-0180 ext. 16 [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, MyODBC and MS Access
I'm doing something similar, with an Access front-end and mysql back-end. -Original Message- From: Mark Stringham [mailto:[EMAIL PROTECTED]] Sent: Friday, March 22, 2002 3:11 AM To: MySQL Subject: MySQL, MyODBC and MS Access I have a project where I may need to connect an MS ACCESS db and MySQL. I have read some pretty good documentation and know that is possible to take an existing Access db and export it to MYSQL. I have a few questions and wondered if someone might offer some insight. 1. Where must the Access db reside in order to talk with MySQL? It doesn't matter. As long as you install Myodbc on the client with Access, then myodbc can talk to mysql. 2. After the import to MySQL, if I insert new data into MySQL will the Access db be updated as well? Not automatically. If you want the databases each to be updated automatically, I don't think you can replicate between Access and Mysql. Either both dbs have to be Access or both Mysql. I am looking for a way to access live MS Access data from the web. Obviously, I could connect directly to the Access db itself but with limited connections, I would think it would be hard to share the data . My thought was when someone updated the Access db, the data is then exported to MySQL. I then could use php, JSP or whatever to access the data from the web without having to worry about odbc connections. We're doing the exact same thing. We have Access as a front-end, and myodbc installed with the client (on the front end). In Myodbc, you specify a data source with an IP address and database name. That connects to a Mysql server running on the same IP address. The only problem we're having is how to encrypt the data between the client (Access) and server (mysql). Mysql supports SSL but Access does not. We're looking at using stunnel (which uses openssl, www.openssl.org), which is like a gateway between Access and Mysql. Chuck - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 use checker to debug mysql applications
Hi, is there any way to debug a c-programm that uses the mysql c-api? I want to use checker for memleak checking but it seems to be impossible to compile the mysql client libraries using checker. The reason seems to be some assembly language parts. All other libraries I need compile. Did anybody hack up some stubs to use checker for mysql applications? Best regards, Carsten Hammer PS: This is pointer to mysql http://www.mysql.com, for checker there seems to be no URL, I use debian. There is a package for it available. What the readme contains is only Tristans email address: [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: Optimizing tables
Ok this works on myisam tables, but what about InnoDB On Fri, 22 Mar 2002, Egor Egorov wrote: Date: Fri, 22 Mar 2002 15:38:03 +0200 From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Optimizing tables Vijay, Friday, March 22, 2002, 1:14:33 PM, you wrote: V how do i optimize mysql tables I think chapter 4.4.6.10 Table Optimization in MySQL manual will be useful for you. Look at: http://www.mysql.com/doc/O/p/Optimisation.html V vijay -- 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 Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: still no umlauts in mysql --experts help needed
Am Freitag, 22. März 2002 11:58 schrieben Sie: Egor: Thanks for the hint. I browsed the manual for readline(3) and for /etc/inputrc, but found nothing wrong with it. I can enter umlauts in all other programs and from the bash command-line - only in mysql they don't work. Where else might I look for the source of the problem? Schreib doch mal sowas wie INSERT INTO test (t) VALUES (ÄÖÜäüß); in eine Datei und ruf dann mysql test datei auf. Was passiert dann? It works -- I'm sure I tested it already with negative results, but now it works. [So much for being sure.] So I can enter umlauts with a file redirection, but not directly in the mysql client. This is good enough for a work-around, but still I'd really like to fix this problem at it's source. s.m. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can you Change Nulls in the MySQLDump from \N?
Well I was able to fix the problem by doing a Select into Outfile and specifying in my select list and using IF... thanks - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: David M. Peak [EMAIL PROTECTED]; MySQL List [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 4:24 PM Subject: Re: Can you Change Nulls in the MySQLDump from \N? At 12:11 -0800 3/21/02, David M. Peak wrote: Is there a way to tell MySQL to put a blank space instead of \N in the tab-delimited files when it does a dump? Nope. You'll have to postprocess the files somehow. I'm working on a MySQL to SQL Server migration and having problems with the output files. I'm doing this all in batch fellas so I'm not finding a good search and replace utility. (perl, c++, and other langs are not an option..) 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 3.23.22
I recently installed MySQL version 3.23.22 on a Linux server. It used to run fine. The problem is when I run a php query on a database it returns the error Cannot connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) Hmm. My mysql.sock file is located in /tmp/mysql.sock. The databases don't even seem to be located correctly. They reside in /usr/local/var along with my .err file. Anyone have any ideas? I configured using --prefix=/usr/local/. TIA Ed Curtis Kuntrynet Internet Services - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
FreeBSD+MySQL
Hi, I'm currently running FreeBSD 4.3-stable with MySQL 3.23.39. My problem is weird an unpreditable. I have a database driven website which has several hundred visitors per day. After viewing my logs on a daily basis, I see a Unknown database error appear from time to time. Now, I also have a script set in cron which accesses the database every so often an I see the same Unknown database error from time to time when this script is ran. The error is completely spuradic and unpredictable. Sometimes I go for days without seeing the problem. Not only that, if I notice the problem immediately and check things out, I can connect to the database. So within a matter of minutes it goes from an Unknown database to a database that is alive and accessible. I've tried upping the mbufs, checking the file descriptors, tweaking the mysqld server params, applying soft-updates, and turning off Apache::DBI, nothing seems to work. I've seen at least 2 other mailing list entries where people have the exact same problem. The only solution I received was to switch to a Linux OS. I've also read that there is a threading problem with FreeBSD+MySQL on an SMP machine. I'm running a machine with only 1 processor. Do you have any idea as to what may be causing this problem and if so, do you have a suggested solution? Any help you may be able to give will certainly be appreciated. Thanks, Ozette Brown - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 3.23.22
you can create my.cnf file with the contents [mysqld] socket=/var/lib/mysql/mysql.sock and put it in path. In case you need to know where the my.cnf file should be put, execute: mysqld --help | grep my.cnf or with your command line mysql binary do mysql -uusername -p -S=/tmp/mysql.sock - Original Message - From: Kuntrynet Office [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 22, 2002 11:59 AM Subject: Problem with 3.23.22 I recently installed MySQL version 3.23.22 on a Linux server. It used to run fine. The problem is when I run a php query on a database it returns the error Cannot connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) Hmm. My mysql.sock file is located in /tmp/mysql.sock. The databases don't even seem to be located correctly. They reside in /usr/local/var along with my .err file. Anyone have any ideas? I configured using --prefix=/usr/local/. TIA Ed Curtis Kuntrynet Internet Services - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem with 3.23.22
This happened on our server, and we had to reload the grant table (mysqladmin reload). Also, the mysql directories were owned by root so we had to chown them to the mysql user. I hope that helps, Martin Kuntrynet Office wrote: I recently installed MySQL version 3.23.22 on a Linux server. It used to run fine. The problem is when I run a php query on a database it returns the error Cannot connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) Hmm. My mysql.sock file is located in /tmp/mysql.sock. The databases don't even seem to be located correctly. They reside in /usr/local/var along with my .err file. Anyone have any ideas? I configured using --prefix=/usr/local/. TIA Ed Curtis Kuntrynet Internet Services - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Remote connection to MySQL Server using MS Access 2002
Hi, Can someone tell me how to configure the MySQL ODBC (v3.51) Driver so I can connect to a remote MySQL database. I have tried putting an IP address in that I found by lookup of the domain name, and I entered the database name and password, but I get an error saying connection from ~db_name~@~whatever_ISP~ was refused, what am I doing wrong. I do not know the actual servr name that the MySQL database lives on, so what options do I have, this must be possible so how do I do it. Alternativly, if anyone knows of any alternative tools (not phpMyAdmin (ie: not browser based)) that will allow me to look at, and work with the data, even if only in a read only enviroment at this time, though full access is desired. I would mych appreciate it. Thnx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: FreeBSD+MySQL
äÏÂÒÙÊ ÄÅÎØ. I have the same problem. We increase max number of users in the kernel config and recompile. The problem is solve at most. Try to increase max number of open files in kernel. Hi, I'm currently running FreeBSD 4.3-stable with MySQL 3.23.39. My problem is weird an unpreditable. I have a database driven website which has several hundred visitors per day. After viewing my logs on a daily basis, I see a Unknown database error appear from time to time. Now, I also have a script set in cron which accesses the database every so often an I see the same Unknown database error from time to time when this script is ran. The error is completely spuradic and unpredictable. Sometimes I go for days without seeing the problem. Not only that, if I notice the problem immediately and check things out, I can connect to the database. So within a matter of minutes it goes from an Unknown database to a database that is alive and accessible. I've tried upping the mbufs, checking the file descriptors, tweaking the mysqld server params, applying soft-updates, and turning off Apache::DBI, nothing seems to work. I've seen at least 2 other mailing list entries where people have the exact same problem. The only solution I received was to switch to a Linux OS. I've also read that there is a threading problem with FreeBSD+MySQL on an SMP machine. I'm running a machine with only 1 processor. Do you have any idea as to what may be causing this problem and if so, do you have a suggested solution? Any help you may be able to give will certainly be appreciated. Thanks, Ozette Brown - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Server startup error on Linux
Rance, Friday, March 22, 2002, 4:53:41 PM, you wrote: RH here goes (not that it will give you any better information than I did RH already but since you asked...) RH exerpt from .err file follows RH 020318 14:30:48 mysqld started RH 020318 14:30:49 /usr/libexec/mysqld: Table 'mysql.host' doesn't exist RH 020318 14:30:49 mysqld ended RH exerpt from .err file ended RH because I have about 18 similar blocks in my .err file for each time I tried RH to start the server to see if I fixed the problem coping the entire .err RH file didnt make any sense. RH Again, this is after running the mysql_install_db and verifing that RH permissions to the files created by mysql_install_db are correct. RH --skip-grant-tables will allow the server to start, but a normal start is RH impossible Rance, are you sure that table 'host' really exists? Take a look at mysql datadir if there are the grant tables like 'host.frm', 'host.MYD', 'host.MYI'. RH Rance -- 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: Unix Jobs?
try: http://www.justunixjobs.com http://www.dice.com -amen PS If you know php, you can learn asp easy. On Fri, 22 Mar 2002, Jonathan Hilgeman wrote: I'm currently working as a e-commerce web programmer specializing in PHP, MySQL, and Apache systems. I've had experience on FreeBSD and Linux systems, and now the company I work for seems to be being bought out at which point, several of us may lose our jobs. Now, I've been searching all over Monster.com, HeadHunter.net, etc... for a compatible job in my area, but it just isn't panning out - most employers are Java and ASP hungry, and I couldn't classify myself as an expert on either at this point, even though I've worked with VB for a bit. My question is this: are there any job sites out there that deal more exclusively with the Unix world so I could find one in my area (Orange County, CA)? Also, is there anyone on this list that is currently looking to hire on a programmer like me? If you can answer yes to my second question, please respond in private - I don't want the MySQL mailing list to start flaming this post for some reason. Thanks! - Jonathan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: FreeBSD+MySQL
Andrey Kotrekhov wrote: äÏÂÒÙÊ ÄÅÎØ. I have the same problem. We increase max number of users in the kernel config and recompile. The problem is solve at most. Try to increase max number of open files in kernel. Hi, I'm currently running FreeBSD 4.3-stable with MySQL 3.23.39. My problem is weird an unpreditable. I have a database driven website which has several hundred visitors per day. After viewing my logs on a daily basis, I see a Unknown database error appear from time to time. Now, I also have a script set in cron which accesses the database every so often an I see the same Unknown database error from time to time when this script is ran. The error is completely spuradic and unpredictable. Sometimes I go for days without seeing the problem. Not only that, if I notice the problem immediately and check things out, I can connect to the database. So within a matter of minutes it goes from an Unknown database to a database that is alive and accessible. I've tried upping the mbufs, checking the file descriptors, tweaking the mysqld server params, applying soft-updates, and turning off Apache::DBI, nothing seems to work. I've seen at least 2 other mailing list entries where people have the exact same problem. The only solution I received was to switch to a Linux OS. I've also read that there is a threading problem with FreeBSD+MySQL on an SMP machine. I'm running a machine with only 1 processor. Do you have any idea as to what may be causing this problem and if so, do you have a suggested solution? Any help you may be able to give will certainly be appreciated. Thanks, Ozette Brown - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Andrey, Thank you for the reply. I read somewhere that when checking your maximum file descriptors your kern.maxfiles should be greater than kern.maxfilesperproc. My settings are: kern.maxfiles = 8232 kern.maxfilesperproc = 8232 So, with that said, my kern.maxfiles should be much higher, no (based on your reply)? When I check my maximum file descriptors, I should see: somenumber / what I set my kern.maxfiles to be example: 535/8232 Is this correct? Also, are you running the same version of FreeBSD (4.3-stable) and MySQL (3.23.39)? Thanks, Ozette - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: FreeBSD+MySQL
In the last episode (Mar 22), Ozette Brown said: Andrey, Thank you for the reply. I read somewhere that when checking your maximum file descriptors your kern.maxfiles should be greater than kern.maxfilesperproc. My settings are: kern.maxfiles = 8232 kern.maxfilesperproc = 8232 So, with that said, my kern.maxfiles should be much higher, no (based on your reply)? If you're really hitting the system's open-file limit, you will see file table full errors in /var/log/messages. I really doubt this, though, because you would have problems running anything on the system if this were the case. You're probably hitting a per-user resource limit or need to bump up table_cache in mysql. What do the following print out (run them after the server has been up a while): sysctl kern.maxfiles kern.maxfilesperproc kern.openfiles limits -n mysql -e show variables like 'table_cache' mysql -e show status like 'Open%' -- Dan Nelson [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: JBuilder6 and mm.mysql-2.0.11
On Fri, 22 Mar 2002, TAKAHASHI, Tomohiro wrote: Hi, Lonnie Lonnie Wormley wrote: TAKAHASHI, Tomohiro wrote: Do you want to use mm mysql Driver with JB6's DataPilot? What kind of error does DataPilot say? Here is the stack trace: See com.borland.dx.dataset.DataSetException error code: BASE+82 com.borland.dx.dataset.DataSetException: The driver: org.git.mm.mysql.Driver could not be loaded. This could be a problem org.gjt.mm.mysql.Driver ^ Man this hurts, I'm being bit by a typo. Thanks I'll try this soon. -- Lonnie Wormley [EMAIL PROTECTED] [Linux and Java] [EMAIL PROTECTED] [Window$ and graphics] http://www.launi.com http://www.zaramyth.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: Remote connection to MySQL Server using MS Access 2002
There are other windows front ends to mysql, but this one is the best: http://ems-hitech.com/mymanager/ Are you sure the server allows remote connections? Ken Charles McGrotty wrote: Hi, Can someone tell me how to configure the MySQL ODBC (v3.51) Driver so I can connect to a remote MySQL database. I have tried putting an IP address in that I found by lookup of the domain name, and I entered the database name and password, but I get an error saying connection from ~db_name~@~whatever_ISP~ was refused, what am I doing wrong. I do not know the actual servr name that the MySQL database lives on, so what options do I have, this must be possible so how do I do it. Alternativly, if anyone knows of any alternative tools (not phpMyAdmin (ie: not browser based)) that will allow me to look at, and work with the data, even if only in a read only enviroment at this time, though full access is desired. I would mych appreciate it. Thnx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 datbase backups
I am still a new to mysql. What is the syntax for backing up a table and how do I make it no-lock while doing so. I need the tables to still be able to be written to. I know that this will make my backup a little unaccurate but that doesnt really matter... Kathy Reyes Live Technology International 2975 Westchester Avenue Suite 103 Purchase, NY 10577 Tel: (914) 490-7096 [EMAIL PROTECTED] www.LiveTechnology.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: Connecting to a remote MySql server
You have written the following: Hi! I am running Apache on Linux and MySql database is running on a windows200 server. Is there a way to connect to that database using the IP address ? Thanks for your help! Paul - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Post installation problems in MySQL
Sir/Madam I installed the binary version of (MySQL) mysql-3.23.49a-pc-linux-gnu-i686.tar.gz. The steps followed to install are: tar xvzf mysql-3.23.49a-pc-linux-gnu-i686.tar.gz. cd mysql-3.23.49a-pc-linux-gnu-i686 ./configure scripts/mysql_install_db cp support-files/my_medium.cnf/etc/my.cnf ./bin/safe_mysqld After installing, I tried to start mysqld daemon using the command ./bin/safe_mysqld. The message obtained is given below. Starting mysqld daemon with the databases from /usr/local/mysql-3.23.49a-pc-linux-gnu-i686/data 020322 13:31:50 mysqld ended Then directly I tried to start the mysqld with the command ./bin/mysqld In this case the error message obtained is: ./bin/mysqld: Fatal error: Can't find message file '/usr/local/mysql/share/mysql/english/errmsg.sys' Actually the errmsg.sys file is located in the path '/usr/local/mysql-3.23.49a-pc-linux-gnu-i686/share/mysql/english/errmsg.sys' and not in '/usr/local/mysql/share/mysql/english/errmsg.sys'. I need help to resolve this problem Thanks -Sri - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: FreeBSD+MySQL
Dan Nelson wrote: In the last episode (Mar 22), Ozette Brown said: Andrey, Thank you for the reply. I read somewhere that when checking your maximum file descriptors your kern.maxfiles should be greater than kern.maxfilesperproc. My settings are: kern.maxfiles = 8232 kern.maxfilesperproc = 8232 So, with that said, my kern.maxfiles should be much higher, no (based on your reply)? If you're really hitting the system's open-file limit, you will see file table full errors in /var/log/messages. I really doubt this, though, because you would have problems running anything on the system if this were the case. You're probably hitting a per-user resource limit or need to bump up table_cache in mysql. What do the following print out (run them after the server has been up a while): sysctl kern.maxfiles kern.maxfilesperproc kern.openfiles limits -n mysql -e show variables like 'table_cache' mysql -e show status like 'Open%' -- Dan Nelson [EMAIL PROTECTED] Dan, I guess I'm not hitting my systems openfile limit because I do not see file table full in my /var/log/messages. Here's the other info you inquired about: m1# sysctl kern.maxfiles kern.maxfilesperproc kern.openfiles kern.maxfiles: 8232 kern.maxfilesperproc: 8232 kern.openfiles: 808 m1# limits -n limits: option requires an argument -- n Resource limits (current): openfiles8232 m1# mysql -e show variables like 'table_cache' +---+---+ | Variable_name | Value | +---+---+ | table_cache | 256 | +---+---+ m1# mysql -e show status like 'Open%' +---+---+ | Variable_name | Value | +---+---+ | Open_tables | 256 | | Open_files| 446 | | Open_streams | 0 | | Opened_tables | 6114 | +---+---+ Any ideas? Ozette - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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
Chuck - I am looking for a way for both MS access and MySQL to share realtime data so that if someone where to insert (through a web based admin) or update table in a MySQL db you could open your Access db and see the same data. I don't know if it is possible but that way there wouldn't be an export to MySQL procedure. Does that make sense? I don't know much about Myodbc except it allows you to export your Access database to MySQL. My question is if MySQL gets updated does Access get updated too? I have a client who wants everyone in the office to have the ability to update and view data in an Access db. My understanding of how access works is only one person can be connected or update the db at a time.(depending on the # of odbc connection you have) My thought was if we got Access and MySQL talking, I could create a web based admin that would allow many folks to query and update the MySQL db and if MySQL and Access are talking then the data in the Access db would get updated as well. Really just trying to create a remote way to access and update from the Access db. Sorry for the long story but is this something you've done or is it not at all possible? Any ideas? Thanks Mark At Friday, 22 March 2002, Chuck Roberts [EMAIL PROTECTED] wrote: I'm doing something similar, with an Access front-end and mysql back-end. -Original Message- From: Mark Stringham [mailto:[EMAIL PROTECTED]] Sent: Friday, March 22, 2002 3:11 AM To: MySQL Subject: MySQL, MyODBC and MS Access I have a project where I may need to connect an MS ACCESS db and MySQL. I have read some pretty good documentation and know that is possible to take an existing Access db and export it to MYSQL. I have a few questions and wondered if someone might offer some insight. 1. Where must the Access db reside in order to talk with MySQL? It doesn't matter. As long as you install Myodbc on the client with Access, then myodbc can talk to mysql. 2. After the import to MySQL, if I insert new data into MySQL will the Access db be updated as well? Not automatically. If you want the databases each to be updated automatically, I don't think you can replicate between Access and Mysql. Either both dbs have to be Access or both Mysql. I am looking for a way to access live MS Access data from the web. Obviously, I could connect directly to the Access db itself but with limited connections, I would think it would be hard to share the data . My thought was when someone updated the Access db, the data is then exported to MySQL. I then could use php, JSP or whatever to access the data from the web without having to worry about odbc connections. We're doing the exact same thing. We have Access as a front-end, and myodbc installed with the client (on the front end). In Myodbc, you specify a data source with an IP address and database name. That connects to a Mysql server running on the same IP address. The only problem we're having is how to encrypt the data between the client (Access) and server (mysql). Mysql supports SSL but Access does not. We're looking at using stunnel (which uses openssl, www.openssl.org), which is like a gateway between Access and Mysql. Chuck - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-mstringham=edeasolutions. com@lists. mysql.com Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Regards, Mark Stringham 801.602.8791 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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
Your client won't drop Access in favor of a faster, more secure database like mySQL? Why is your client stuck on Access? The data can be dumped and make the GUI web based to look just like the Access one... Stick in on a Intranet server, and lock it down... I would rather have that than a slow, unsecure, limited DB like Access... Back to a solution... The problem is that you would need to run a query to pull the data from the Access db to the mySQL one, which could be automated in Access. Just add a few extra lines in your code for each form and should work beautifully. A problem that may or may not occur is the fact that Access uses different kinds of datatypes in its tables. If these datatypes are in the Access DB tables, using a myODBC connection, all the data transferring will fail because mySQL doesn't recognize the datatypes -Original Message- From: Mark Stringham [mailto:[EMAIL PROTECTED]] Sent: Friday, March 22, 2002 1:51 PM To: Chuck Roberts Cc: Mysql; Mark Stringham Subject: RE: MySQL, MyODBC and MS Access Chuck - I am looking for a way for both MS access and MySQL to share realtime data so that if someone where to insert (through a web based admin) or update table in a MySQL db you could open your Access db and see the same data. I don't know if it is possible but that way there wouldn't be an export to MySQL procedure. Does that make sense? I don't know much about Myodbc except it allows you to export your Access database to MySQL. My question is if MySQL gets updated does Access get updated too? I have a client who wants everyone in the office to have the ability to update and view data in an Access db. My understanding of how access works is only one person can be connected or update the db at a time.(depending on the # of odbc connection you have) My thought was if we got Access and MySQL talking, I could create a web based admin that would allow many folks to query and update the MySQL db and if MySQL and Access are talking then the data in the Access db would get updated as well. Really just trying to create a remote way to access and update from the Access db. Sorry for the long story but is this something you've done or is it not at all possible? Any ideas? Thanks Mark At Friday, 22 March 2002, Chuck Roberts [EMAIL PROTECTED] wrote: I'm doing something similar, with an Access front-end and mysql back-end. -Original Message- From: Mark Stringham [mailto:[EMAIL PROTECTED]] Sent: Friday, March 22, 2002 3:11 AM To: MySQL Subject: MySQL, MyODBC and MS Access I have a project where I may need to connect an MS ACCESS db and MySQL. I have read some pretty good documentation and know that is possible to take an existing Access db and export it to MYSQL. I have a few questions and wondered if someone might offer some insight. 1. Where must the Access db reside in order to talk with MySQL? It doesn't matter. As long as you install Myodbc on the client with Access, then myodbc can talk to mysql. 2. After the import to MySQL, if I insert new data into MySQL will the Access db be updated as well? Not automatically. If you want the databases each to be updated automatically, I don't think you can replicate between Access and Mysql. Either both dbs have to be Access or both Mysql. I am looking for a way to access live MS Access data from the web. Obviously, I could connect directly to the Access db itself but with limited connections, I would think it would be hard to share the data . My thought was when someone updated the Access db, the data is then exported to MySQL. I then could use php, JSP or whatever to access the data from the web without having to worry about odbc connections. We're doing the exact same thing. We have Access as a front-end, and myodbc installed with the client (on the front end). In Myodbc, you specify a data source with an IP address and database name. That connects to a Mysql server running on the same IP address. The only problem we're having is how to encrypt the data between the client (Access) and server (mysql). Mysql supports SSL but Access does not. We're looking at using stunnel (which uses openssl, www.openssl.org), which is like a gateway between Access and Mysql. Chuck - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-mstringham=edeasolutions. com@lists. mysql.com Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Regards, Mark Stringham 801.602.8791 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL
Re: Compiling on apache.
You have to tell it to use gcc. It doesn't look like you're following the directions for compiling on HP-UX. See http://www.mysql.com/doc/H/P/HP-UX_10.20.html or http://www.mysql.com/doc/H/P/HP-UX_11.x.html If you need help after that, specify your version of HP-UX, version of MySQL, version of gcc, and copy/paste your configure command. That way, we can see how to help. Michael On Fri, 22 Mar 2002, Stephane JEAN BAPTISTE wrote: I have a problem with compiling mysql on HP-UX. I can't compile because it doesn't know that I have gcc. I have this error with ./configure : checking for gcc... cc checking whether the C compiler (cc -Ae -D_REENTRANT ) works... yes checking whether the C compiler (cc -Ae -D_REENTRANT ) is a cross-compiler... no checking whether we are using GNU C... no checking whether cc accepts -g... yes checking for c++... aCC checking whether the C++ compiler (aCC -D_REENTRANT ) works... no configure: error: installation or configuration problem: C++ compiler cannot create executables. what do i have to do ? tks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 replication
After much stress, I finally found the answer to my problem. Here is the error message that I was getting: 020322 11:54:29 Slave: Failed reading log event, reconnecting to retry, log 'bend149-bin.002' position 2407727 020322 11:54:29 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'bend149-bin.002' at position 2407727 020322 11:54:29 Slave: received 0 length packet from server, apparent master shutdown: (0) and the solution that I found was to make sure the all of the servers in the system, including the master db server, had unique server id's. it took me a while to realize that the master and one of the slaves had the same id. this is in part because we had to switch out the old master db and replace it with one of the slave machines and then built a new machine to take the place of the missing slave. This is just to help out the next person that comes across this problem. it took me a while to find the solution and I hope this makes their search much shorter. Jim Lucas www.bend.com sql, query, select, insert, update, replace, etc... is that enough... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
problems running ./configure
I am not sure what the heck the problem is. I'm trying to install mysql (client) on a RH 7.2 box. When I run ./configure --without-server I get a bunch of messages about mysql passwords being changed and mysql daemon being started -- sorry I can't include the exact messages but I have no way of retrieving the messages from that box. I then try to run make I get: make: *** no targets specified and no makefile found. Stop. I would be very grateful for any ideas as to what the problem might be even any hints or pointers, as I am totally clueless. Richard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Access denied on use mysql;
On Thu, Mar 21, 2002 at 08:13:16PM -0500, alan4100 wrote: mysql Hi Colin, I wish I can be able to live chat with you, but because of my hearing impaired...it would not be possible..But what is the real problem? A few days ago I got assistance from others on my Mysql problem. It has been fixed and everything works fine. I _think_, when he said 'live chat', that he meant an IRC channel. 'Internet Relay Chat'. Just lots of typing. :) -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Please Help. Problem installing
I am not sure what the heck the problem is. I'm trying to install mysql (client) on a RH 7.2 box. When I run ./configure --without-server I get a bunch of messages about mysql passwords being changed and mysql daemon being started with databases from /install directory -- sorry I can't include the exact messages but I have no way of retrieving the messages from that box. I then try to run make I get: make: *** no targets specified and no makefile found. Stop. I would be very grateful for any ideas as to what the problem might be even any hints or pointers, as I am totally clueless. Richard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: FreeBSD+MySQL
In the last episode (Mar 22), Ozette Brown said: Dan, I guess I'm not hitting my systems openfile limit because I do not see file table full in my /var/log/messages. Here's the other info you inquired about: m1# sysctl kern.maxfiles kern.maxfilesperproc kern.openfiles kern.maxfiles: 8232 kern.maxfilesperproc: 8232 kern.openfiles: 808 m1# limits -n limits: option requires an argument -- n Resource limits (current): openfiles8232 Looks good. m1# mysql -e show variables like 'table_cache' +---+---+ | Variable_name | Value | +---+---+ | table_cache | 256 | +---+---+ m1# mysql -e show status like 'Open%' +---+---+ | Variable_name | Value | +---+---+ | Open_tables | 256 | | Open_files| 446 | | Open_streams | 0 | | Opened_tables | 6114 | +---+---+ Ok, this is bad :) I should have also asked what your mysqld uptime was at this point. 6144 table opens is pretty high even for a couple days of uptime, though. Try bumping table_cache up to 512 and see what happens. Keep bumping it up until Opened_tables stops increasing. /var/db/mysql/my.cnf : [mysqld] set-variable = table_cache=512 -- Dan Nelson [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL oddity
Below is a table declaration in a database I just created. The oddity is the 2 fields, CL_FIRST_TS and CL_LAST_TS, are automatically marked as Required in the table's Validity Checks listing. This means that I have to add a value to both of them each time I insert a new record. They are involved in a legacy issue by old input devices or I would remove them. Nothing I do will change this behavior. Can anybody please explain to me why they are the only ones in the whole database to do this? The database consists of 90 tables with this one being number 9. I have tried this under MySQL v3.23 and v4.01 and get the same results. DROP TABLE IF EXISTS char_limits; CREATE TABLE CHAR_LIMITS ( CHAR_ID INTEGER NOT NULL, ENG_HIGH DOUBLE PRECISION, NOMINAL DOUBLE PRECISION, ENG_LOW DOUBLE PRECISION, CL_UPPER DOUBLE PRECISION, CL_CENTER DOUBLE PRECISION, CL_LOWER DOUBLE PRECISION, SCL_UPPER DOUBLE PRECISION, SCL_CENTER DOUBLE PRECISION, SCL_LOWER DOUBLE PRECISION, CL_CALC_METHOD VARCHAR(32), CL_FIRST_SG_TS TIMESTAMP NULL, CL_LAST_SG_TS TIMESTAMP NULL, REAS_HIGH DOUBLE PRECISION, REAS_LOW DOUBLE PRECISION, LIMITS_TS TIMESTAMP NOT NULL, TOTAL_LIMIT DOUBLE PRECISION, TOTAL_LIMIT_TYPE VARCHAR(16), CL_CALC_SG_SIZE INTEGER, CAUTION_PERCENT SMALLINT, CAUTION_TYPE VARCHAR(16), RANGE_UPPER DOUBLE PRECISION, RANGE_CENTER DOUBLE PRECISION, RANGE_LOWER DOUBLE PRECISION, SIGMA_UPPER DOUBLE PRECISION, SIGMA_CENTER DOUBLE PRECISION, SIGMA_LOWER DOUBLE PRECISION, ACC_DEFECT_PERCENT DOUBLE PRECISION, ACC_CONFID_PERCENT DOUBLE PRECISION, PRIMARY KEY (CHAR_ID)); CREATE UNIQUE INDEX CHARLIMITS_PK ON CHAR_LIMITS( CHAR_ID); /*/ Steven Gearhart Gearhart, Inc. Phone/Fax: 770.466.2898 Email: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL Tip: Faster Updates
This *might* make your updates a bit faster. I don't think MySQL optimizes updates this way (it would be nice if it did.) Depending on your data it may be possible to eliminate updating some of the rows if the row already has the new value. As strange as this seems, something as simple as: update table set column = x where column x can eliminate some of the work involved in updating of the row (and perhaps the locking) just by checking to see if the row already has the value that you're updating it to. It is faster to put this logic in the Where clause than have MySQL try to optimize it during the update. This seems like an incredibly simple solution that can save you time when updating a table. Brent _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Server startup error on Linux
Egor: Yes, im sure that the host.xxx tables are in the directory I specified to the mysql_install_db script. One thing to note.. This is a software package for my distro... I did not compile from source so I dont know what options were used in the compile process. It may be that the server is unable to look in the dir where the files are... if this is the case then this would explain why the server cant find the host.xxx databases. I have tried to run safe_mysqld --datadir=/path/to/data but that doesnt help Do you think I should just uninstall the package, and download the sources and start over? Im at the end of my rope with this, Its just dumb to me that the server cant find something that I can find, even after I tell it where to look. There must be something more wrong that just a simple chown command, or file permissions or something like that. Just my opinion. Thoughts? From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Server startup error on Linux Date: Fri, 22 Mar 2002 20:32:00 +0200 Rance, Friday, March 22, 2002, 4:53:41 PM, you wrote: RH here goes (not that it will give you any better information than I did RH already but since you asked...) RH exerpt from .err file follows RH 020318 14:30:48 mysqld started RH 020318 14:30:49 /usr/libexec/mysqld: Table 'mysql.host' doesn't exist RH 020318 14:30:49 mysqld ended RH exerpt from .err file ended RH because I have about 18 similar blocks in my .err file for each time I tried RH to start the server to see if I fixed the problem coping the entire .err RH file didnt make any sense. RH Again, this is after running the mysql_install_db and verifing that RH permissions to the files created by mysql_install_db are correct. RH --skip-grant-tables will allow the server to start, but a normal start is RH impossible Rance, are you sure that table 'host' really exists? Take a look at mysql datadir if there are the grant tables like 'host.frm', 'host.MYD', 'host.MYI'. RH Rance _ 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
--extended-insert vs. performance
Hi, sorry to bother you with this, but one thing one might look into is: When table was dumped with --extended-insert option, that the server importing the table does NOT perform well. In the output from `vmstat 1` each second there's a lot of I/O, and at least on linux 2.4.19-pre1 it runs more easily out of memory. On the other hand, when omitting --extended-insert, I get: 1 0 0 19520 9552 19216 922272 0 0 0 4692 1852 3323 23 10 67 1 0 0 19520 9460 19220 922300 4 0 4 0 1850 3385 27 6 67 1 0 0 19520 9472 19220 922260 0 0 0 0 1789 3206 21 8 71 1 0 0 19520 9440 19220 922240 0 0 0 0 2040 3879 33 7 60 1 0 0 19520 9440 19220 922216 0 0 0 0 1994 3747 26 7 67 1 0 0 19520 9504 19264 922064 0 0 0 3668 1784 3268 22 7 70 0 0 0 19520 9520 19264 922004 0 0 0 0 1810 3323 28 10 62 1 0 0 19520 9516 19268 921956 0 0 0 0 2125 3105 25 6 68 1 0 0 19520 9536 19268 921892 0 0 0 0 2096 3136 23 6 71 1 0 0 19520 9440 19268 921964 0 0 0 0 2076 3066 25 6 69 1 0 0 19520 9552 19312 921756 0 0 0 3796 2081 3105 24 8 68 procs memoryswap io system cpu r b w swpd free buff cache si sobibo incs us sy id 1 0 0 19520 9564 19316 921700 0 0 0 0 2012 3097 25 8 67 1 0 0 19520 9456 19316 921760 0 0 0 0 1992 3140 24 7 69 1 0 0 19520 9468 19316 921712 0 0 0 0 1835 3171 26 12 61 1 0 0 19520 9472 19316 921680 0 0 0 0 2032 3287 18 5 76 0 0 0 19520 9508 19364 921544 0 0 0 3796 2375 3221 23 9 68 0 0 0 19520 9448 19364 921564 0 0 0 0 2424 3187 23 9 68 0 0 0 19520 9508 19364 921460 0 0 0 0 2467 3199 22 9 68 0 0 0 19520 9516 19364 921416 0 0 0 0 2207 3301 23 7 69 0 0 0 19520 9484 19364 921404 0 0 0 0 1879 3327 30 7 63 1 0 0 19520 9524 19412 921276 0 0 0 4316 1874 3294 24 8 68 1 0 0 19520 9692 19408 921068 0 0 0 0 1822 3389 26 7 67 0 0 0 19520 9608 19408 921228 0 0 4 0 2002 3623 29 9 62 1 0 0 19516 9832 19240 921256 0 0 0 0 1826 3385 26 8 66 1 0 0 19516 9764 18904 921636 0 0 0 0 1794 3348 26 8 66 1 0 0 19516 9976 18232 922060 0 0 0 4316 2358 3489 21 9 70 0 0 0 19736 10544 17592 922160 0 0 0 0 2253 3470 26 4 70 I do not want to stop my import script to send you the output what happens in case 1 above. Sorry, that's just a note. So just time to time we read data(and/or) write them. I guess read is via network. Checking iostat output tells me, that every about 4 seconds a lot of data is written to the disk and zero activity at all in between. --- Second point would be, that there's a lot of table locks issued when importing table. It looks every row equals to one lock ( I use mysqldump | mysql ) to import data. The shell command is executed on remote host, I'm talking about mysqld on target, not source. And, once I have seen: ++--++---+-+--++--+ | Id | User | Host | db| Command | Time | |State | Info || ++--++---+-+--++--+ | 4 | pedant | xx | Bordetella_pertussis_Tohama_I | Query | 0| |Locked | INSERT INTO `blast` VALUES (42171,5097,0,'BP','orf188','PIR:A49936',319,'9e-86',39,54,56,595,540,550 | | 7 | bioadmin | 127.0.0.1 | | Query | 0| || show processlist | | ++--++---+-+--++--+ I can exclude the possibility that someone else had locked this table temporarily as the traffic on server who query usually this box is redirected to another db server. My question is initiated because the number of Table_locks_immediate is growing very fast while importing data. Maybe both my question are poor misunderstanding. Please Cc: me in replies. TIA. (tested on Linux 2.4.19-pre1 and 3.23.49a) -- Martin Mokrejs - PGP5.0i key is at
encode invalid characters for mysql in c++
I'm looking for a function that will take a string or char* of 256bit ascii (or other stuff) and convert it into something that can be inserted into a varchar type in mysql. Then when the data gets pulled out it would be converted back. I know I need to convert quotes and some control characters. Is there such a function in the mysqlc++ libraries or somewhere that I can use for this? What is done for binary files such as images? Thanks, Eric - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Access denied on use mysql;
mysql Brian, Fine...lots of typing.:)
How to quickly Update a table based on tally from another
I'm coming up empty on this one and it should be quite simple. Maybe because it's Friday?? I have 2 tables, Dept and Employee. I want to count the # of employees in each dept and store it in the corresponding Dept row. To do the tally it is simply creating a temporary table: drop table if exists empl_count; create table empl_count select dept_id, count(*) num from employee group by dept_id; create index dept_ndx on empl_count (dept_id); Ok, now that I have the empl_count table, now what? I can write a PHP program to go through the dept table and lookup each num in empl_count for each dept_id, but there has to be an easier way to do this. Is there any way to quickly update the dept table with the results of the tally? Can I eliminate the empl_count table entirely and update the dept table directly? The empl_count table could have 100k rows so I don't want to do any looping in PHP if at all possible. TIA Brent sql.query _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: hi
--- [EMAIL PROTECTED] wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards? http://movies.yahoo.com/ __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.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: outer joins
On Fri, Mar 22, 2002 at 04:37:07PM +, ds wrote: Hi, did you get any answer ? I'm having the same problem. If i wanted all results from table1, even if they don't appear in table2 i would do like: SELECT . FROM table1 LEFT JOIN table2 ON (table1.id=table2.id) ... But how to join SELECT . FROM table1 LEFT JOIN table2 ON (table1.id=table2.id) ... and SELECT . FROM table2 LEFT JOIN table2 ON (table1.id=table2.id) ... table1. Idem for table2. Outer join: SELECT ... FROM ... LEFT JOIN ON ... UNION SELECT ... FROM... RIGHT JOIN ON ...; Bob Hall -- sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Segmentation fault and core dump at daemon startup
Description: Whenever I try to start up the daemon it gives a 'Segmentation fault core dumped' message and shuts down. How-To-Repeat: Just try to start the daemon up Fix: ? Submitter-Id: [EMAIL PROTECTED] Originator: [EMAIL PROTECTED] Organization: none MySQL support: none Synopsis: Segmentation fault and core dump at daemon startup Severity: critical Priority: high Category: mysql Class:sw-bug Release: mysql-3.22.32 (Official MySQL RPM) Environment: Alpha noname, linux System: Linux 2.4.0 #3 Wed Mar 20 19:01:07 WET 2002 alpha unknown Architecture: alpha Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/local/bin/gcc GCC: Reading specs from /usr/local/lib/gcc-lib/alpha-unknown-linux-gnu/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='egcs' CFLAGS=' -O6 -fomit-frame-pointer' CXX='egcs' CXXFLAGS=' -O6 -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man '--with-comment=Official MySQL RPM' Perl: This is perl, version 5.004_04 built for alpha-linux - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
