Mysql vs MySQL max
Hi Probably a stupid question, but which is best to have on ones server, the old mysql, or max. I.O.W, if you install MAX and never use innodb or berkeley tables, will it be equivalent to a normal mysql installation wrt performance and stability? I'm asking from an ISP's point of view, if that makes any difference ( obviously if from developer it will depend on the needs of the app..) Thanks sql, mysql, 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
Mysql 4.0
Hi All In MySql 3.23.51 , i was able to add values into the child table I have created a table parent and also another table child where parentid column in child is a foreign key to the id column in parent table It was possible that i have no entries in parent table , and i was able to insert null values for parentid in child table.. This was a feature in 3.23.51 whereas this was not available in 3.23.49 When i tried MySQL 4.0.1 , i was shocked to see that i was not able to insert null values in the child table which was supported in 3.23.51 Any ideas -Arul sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: SQL - Fulltext search
I would use WHERE skill LIKE %powerpoint% OR skill LIKE %PHP% but that is because I don't know the better way, which must be there, I feel it .. anybody? -- Alle door mij verzonden email is careware. Dit houdt in dat het alleen herlezen en bewaard mag worden als je goed omgaat met al het leven op aarde en daar buiten. Als je het hier niet mee eens bent dien je mijn mailtje binnen 24 uur terug te sturen, met opgaaf van reden van onenigheid. All email sent by me is careware. This means that it can only be reread and kept if you are good for all the life here on earth and beyond. If you don't agree to these terms, you should return this email in no more than 24 hours stating the reason of disagreement. -Oorspronkelijk bericht- Van: Peter Engström [mailto:[EMAIL PROTECTED]] Verzonden: zondag 30 juni 2002 20:32 Aan: [EMAIL PROTECTED] Onderwerp: SQL - Fulltext search Hi! I have a table called 'candidate_skill' id (autoincrement) candidateID (link to candidate), skill (tinytext) Query: SELECT * FROM candidate_skill WHERE candidateID='2' Result: 134 | 2 | Powerpoint 223 | 2 | PHP 313 | 2 | Lotus Notes Is it possible to do a fulltext search. I want to search for skills. Something like this: +php +powerpoint ...and then get a list of all candidates that have php and powerpoint as a skill. Is there a way to do this? Best regards /Peter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: SQL - Fulltext search
Pada Mon, 1 Jul 2002 09:01:13 +0200 Wouter van Vliet [EMAIL PROTECTED] menulis : I would use WHERE skill LIKE %powerpoint% OR skill LIKE %PHP% where skill REGEXP powerpoint or skill REGEXP php -- #ifdef STUPIDLY_TRUST_BROKEN_PCMD_ENA_BIT 2.4.0-test2 /usr/src/linux/drivers/ide/cmd640.c sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: high level: enabling transactions in mysql-max with WebLogic TX datasource?
Hi, all you have to do use a transaction enabled data-source and use the Mm-MysqlDriver for your JDBC connections. (http://mmmysql.sourceforge.net/) Best is to read the InnoDB documentation carefully (http://www.innodb.com), as you cannot choose from a wide variety of transaction-levels ... in my experience, most of the detailed transaction-handling can only be done at mysql-query level. To test wether your datasource supports the transactions, do a test and look at the InnoDB-logfiles, it should indicate some thing like SET AUTOCOMMIT=0 and COMMIT. Greetz, CB. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 30, 2002 22:33 To: [EMAIL PROTECTED] Subject: high level: enabling transactions in mysql-max with WebLogic TX datasource? One thing that I find a little confusing is the notion of transactional behavior in mySQL. I read that it's possible to enable transactions in mySQL-max, however, it's never really been clear to me exactly what I'm supposed to do, or whether I have to do anything. If I'm using a transactional datasource in WebLogic, on top of mySQL, I need to make sure mySQL supports that transactional behavior. Is there a section of the mySQL documentation, or some other documentation, which explains these issues clearly? -- === David M. Karr ; Java/J2EE/XML/Unix/C++ [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem with MySQLImport utility
* [EMAIL PROTECTED] Hie I'm new in MySQL.anyone out there can help please? I'm actually experimenting with the mysqlimport utility to import data from a text file.however i'm always getting this error upon the command c:\mysql\binmysqlimport - - local - -fields-terminated-by=, test newtest.txt ERROR: The used command is not allowed with this MySQL version, when using table: newtest P.S. My SQL version is Ver. 11.16 Distrib 3.23.49 for Win95/98 (i32) Also i created a txt file with the following structure 100,200 200,200 300,300 . My table is newtest with 2 fields of char datatype of size 10. From the manual: In MySQL 3.23.49 and MySQL 4.0.2 LOCAL will only work if you have not started mysqld with --local-infile=0 or if you have not enabled your client to support LOCAL. See section 4.2.4 Security issues with LOAD DATA LOCAL. (There is probably a typo here... I guess LOCAL will only work if you HAVE enabled your client to support LOCAL... AND you have not started the server with --local-infile=0...) URL: http://www.mysql.com/doc/L/O/LOAD_DATA.html URL: http://www.mysql.com/doc/L/O/LOAD_DATA_LOCAL.html Beware that there was done some changes to LOAD DATA LOCAL in version 3.23.49, and some bugs was intrudused (--enable-local-infile (and --local-infile) did not work, IIRC). These bugs was fixed in version 3.23.50. URL: http://www.mysql.com/doc/N/e/News-3.23.49.html URL: http://www.mysql.com/doc/N/e/News-3.23.50.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
Speed issue
Hi I am trying to move an Access 2000 database into MYSQL 3.27.47nt running on a Win2K machine. MYODBC with the 3.51 drivers is also installed. MYSQL is running and readily responds to SQL queries using the DOS window at the mysql prompt. However, when linking the MYSQL database with ADO and VB6 the response is slow and there is a lot of disk activity before an answer is returned. It is a lot slower than the original Access2000/VB6 setup. A DSN-less code is being used to link VB6/ADO to MYSQL. The connection string is listed below: con.ConnectionString = DRIVER={MySQL ODBC 3.51 Driver}; _ SERVER=localhost; _ DATABASE=GIS; _ UID=Admin;PWD=africa; OPTION=16386 If of any relevance, within the WinMySQLAdmin on the Environment Tab, MYODBC is stated as not found eventhough it has been loaded. Any pointers on how to get rid of the disk churning and get a normal response in this set up would be much appreciated. 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
mysql 4.0.2
Hi As i already stated , i am not able to insert a null value in a child table in 4.0.1 which i was able to do in 3.23.51 I have created a table parent and also another table child where parentid column in child is a foreign key to the id column in parent table It was possible that i have no entries in parent table , and i was able to insert null values for parentid in child table.. This was a feature in 3.23.51 whereas this was not available in 3.23.49 Any idea whether this will be supported in 4.0.2 and where i can get that from.. In the MySQL site i could see only upto 4.0.1 alpha release.. -Arul sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Speed issue
From: Simon Ashby [mailto:[EMAIL PROTECTED]] Sent: 01 July 2002 10:58 To: MYSQL Subject: Speed issue Any pointers on how to get rid of the disk churning and get a normal response in this set up would be much appreciated. Turn off OBDC logging. Tim Ward Brett Ward Limited - www.brettward.co.uk --- This e-mail and the information it contains are confidential and may be privileged. If you have received this e-mail in error please notify us immediately. You should not copy it for any purpose, or disclose its contents to any other person. All emails to and from ip.access may be monitored and stored for audit and other legal reasons. --- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: fulltext searching
hi all... i can't seem to get the fulltext searching working perfectly... single search terms it works fine, multiple search terms it also seems to be ok - finding records with any of the search terms. however, if i try the boolean mode it gives out garbage all the time. i try for example an sql query like this: select * from mytable where match(file_text) against('+findthis +andthis -notthis' in boolean mode); various variants of this never find the records, or find ALL the records in the database... when such filters should throw out a couple of records at least. i'm running mysql 4.0.1-alpha on freebsd... and i've set up the tables for fulltext indexes. is this still heavy work-in-progress or should it work? does it work for anyone? thanks, marko - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Foriegn Key
Hi All, Can anybody tell mysql supports foreign constraints. If i use Referential Integrity cascade then, will MySql delete the same record in another table? Thanks in advance. Regards Daya Krishan Dubey - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: SQL - Fulltext search
hmm, but still sticking to that you'll have to specify a new WHERE argument for each thing you want to test on. Isn't there maybe some way to do it like this WHERE skill IN (regexp(powerpoint, php)) I know this thing won't work, becuase I don't know if you can do regular expressions on WHERE ... IN thingies. But, such a thing would be very handy ... even more when MySQL intruduces the subselect in WHERE .. IN thingies. Some other question, why us using REGEXP in this case better than LIKE ? is it faster, more efficient, something with case-sensitivity maybe? I'd really like to know Greetz, Wouter -- Alle door mij verzonden email is careware. Dit houdt in dat het alleen herlezen en bewaard mag worden als je goed omgaat met al het leven op aarde en daar buiten. Als je het hier niet mee eens bent dien je mijn mailtje binnen 24 uur terug te sturen, met opgaaf van reden van onenigheid. All email sent by me is careware. This means that it can only be reread and kept if you are good for all the life here on earth and beyond. If you don't agree to these terms, you should return this email in no more than 24 hours stating the reason of disagreement. -Oorspronkelijk bericht- Van: Dicky Wahyu Purnomo [mailto:[EMAIL PROTECTED]] Verzonden: maandag 1 juli 2002 09:13 Aan: [EMAIL PROTECTED] CC: [EMAIL PROTECTED]; [EMAIL PROTECTED] Onderwerp: Re: SQL - Fulltext search Pada Mon, 1 Jul 2002 09:01:13 +0200 Wouter van Vliet [EMAIL PROTECTED] menulis : I would use WHERE skill LIKE %powerpoint% OR skill LIKE %PHP% where skill REGEXP powerpoint or skill REGEXP php -- #ifdef STUPIDLY_TRUST_BROKEN_PCMD_ENA_BIT 2.4.0-test2 /usr/src/linux/drivers/ide/cmd640.c 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Foriegn Key
Hi Dubey Actually foreign keys are supporte dfor INNODB Table types.. Whats the version of MYSQL u r using -Arul - Original Message - From: D.K.Dubey [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Sent: Monday, July 01, 2002 4:18 PM Subject: Foriegn Key Hi All, Can anybody tell mysql supports foreign constraints. If i use Referential Integrity cascade then, will MySql delete the same record in another table? Thanks in advance. Regards Daya Krishan Dubey - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Foriegn Key
Hi Arul, Thanks, I m using MySQl 3.23. Will u please tell me how it is possible. Regards D K Dubey - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Strange behaviour of mysqld after adding/dropping a column
Description: The ALTER TABLE command behaves very strange when stopping and restarting the MySQL server afterwards. I noticed this after having rebooted my PC (which means that the MySql server is stopped and restarted). Before the reboot I dropped a column in one of my tables. After I had done this all the data was available in mytable. However after have been rebooting my PC all the data was gone !!! It even becomes crazier. After the second reboot the data was visisble again. The tests I have executed showed that this problem shows up for both adding and deleting a column of a table. Also I noticed that when you add data after have been stopping the MySQL server the first time this data is dissapeared after a second stop of the MySQL server. How-To-Repeat: mysql create database findBug; mysql use findBug mysql create table metatable(objid BIGINT not null, tablename varchar(64), field varchar(64), type varchar(50), PRIMARY KEY (objid)) type=BDB; mysql create table metaindex(objid BIGINT not null, indexname varchar(64), ref_metatable DOUBLE not null, PRIMARY KEY (objid)) type=BDB; mysql create table metaoid(objid BIGINT not null, tablename varchar(64), oid BIGINT not null, PRIMARY KEY (objid), UNIQUE(tablename)) type=BDB; mysql insert into metaoid values(1, metaoid,4); mysql insert into metaoid values(2, metatable,1); mysql insert into metaoid values(3, metaindex,1); mysql select * from metaoid; +---+---+-+ | objid | tablename | oid | +---+---+-+ | 1 | metaoid| 4 | | 2 | metatable | 1 | | 3 | metaindex | 1 | +---+---+-+ mysql alter table metaoid add column test varchar(255); mysql select * from metaoid; +---+---+-+--+ | objid | tablename | oid | test | +---+---+-+--+ | 1 | metaoid | 4 | NULL | | 2 | metatable | 1 | NULL | | 3 | metaindex | 1 | NULL | +---+---+-+--+ mysql quit; C:\net stop mysql C:\net start mysql mysql select * from metaoid; Empty set (0.01 sec) mysql quit; C:\net stop mysql C:\net start mysql mysql select * from metaoid; +---+---+-+--+ | objid | tablename | oid | test | +---+---+-+--+ | 1 | metaoid | 4 | NULL | | 2 | metatable | 1 | NULL | | 3 | metaindex | 1 | NULL | +---+---+-+--+ mysql alter table metaoid drop column test; mysql quit; C:\net stop mysql C:\net start mysql mysql select * from metaoid; Empty set (0.01 sec) mysql insert into metaoid values (5,test,1); mysql select * from metaoid; +---+---+-+ | objid | tablename | oid | +---+---+-+ | 5 | test | 1 | +---+---+-+ mysql quit; C:\net stop mysql C:\net start mysql mysql select * from metaoid; +---+---+-+ | objid | tablename | oid | +---+---+-+ | 1 | metaoid | 4 | | 2 | metatable | 1 | | 3 | metaindex | 1 | +---+---+-+ Fix: Restarting the server twice after have dropped/added a column is the only solution I have found for this problem. Synopsis: Strange behaviour of MySQL after dropping/adding column. Submitter-Id: Originator: Ismaël Cams Organization: Siemens Atea MySQL support: license Severity: critical Priority: high Category: mysqld Class: sw-bug Release: mysql-3.23.51. Executable: mysqld Environment: 512 MB RAM, PII System: Win2000 and NT Compiler: VC++ 6.0 Architecture: i Kind regards, Ismaël - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: AUOT_INCREMENT from the beginning
César, Thursday, June 27, 2002, 8:41:25 PM, you wrote: CA Hi all. I have multiple tables in which I need to delete rows from the CA beginning. I have them stored with an auto_increment id but I don't want CA the records to start from 5 but from 1... is there a way to use CA something like ALTER TABLE tablename AUTO_INCREMENT = 1; but also that CA will make the counting start truly from 1??? You can also run myisamchk with --set-auto-increment option. -A or --set-auto-increment[=value] Force AUTO_INCREMENT to start at this or higher value. If no value is given, then sets the next AUTO_INCREMENT value to the highest used value for the auto key + 1. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Fwd: Re: Foreign key
Elby, Friday, June 28, 2002, 11:13:52 PM, you wrote: EV create table person( EV id_person smallint not null primary key auto_increment, EV name varchar(10)); EV create table friends( EV id_friend smallint not null primary key auto_increment, EV age smallint, EV id_person smallint not null, EV foreign key (id_person) references person (id_person)); EV For example: EV I put a row in table PERSON with id_person = 1 EV If I try to put in table FRIENDS id_person = 7, I get...why? EV Should not give error? EV And the referential integrity? I guess your table is not InnoDB, they are MyISAM :) If you want to have foreign key constraints, you must use InnoDB table type: http://www.mysql.com/doc/S/E/SEC446.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql.sock
Rahadul, Saturday, June 29, 2002, 12:08:50 AM, you wrote: RK I have mysql running on RaQ4 system. I tried to move /var/lib/mysql to RK /home/mysql and then change the datadir to /home/mysql in safe_mysqld RK file, but it didn't work. so I copied back the /home/mysql to RK /var/lib/myql, and now when I try to start the server by using RK mysql.server start i get the following error messages RK 020627 16:47:53 Can't start server : Bind on unix socket: Permission RK denied RK 020627 16:47:53 Do you already have another mysqld server running on RK socket: /v RK ar/lib/mysql/mysql.sock ? RK 020627 16:47:53 Aborting MySQL should be owner of /var/lib/mysql and all file there. Check your permissions. RK I ca see that mysql.socket also disappeared from /var/lib/mysql/ RK directory. does anyone know whats going on. please help mysql.sock is created when mysqld strats. You mysqld isn't running that is why you can't find mysql.sock anywhere. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ERROR 2006:MySQL server has gone away
Anil, Friday, June 28, 2002, 8:57:06 PM, you wrote: AG I have a table with the following description: AG mysql describe xoops_groups_modules_link; AG +-+-+--+-+-+---+ AG | Field | Type| Null | Key | Default | Extra | AG +-+-+--+-+-+---+ AG | groupid | int(5) | | MUL | 0 | | AG | mid | int(5) | | | 0 | | AG | type| char(1) | | | | | AG +-+-+--+-+-+---+ AG with the folloing contents in it: AG mysql select * from xoops_groups_modules_link; AG +-+-+--+ AG | groupid | mid | type | AG +-+-+--+ AG | 1 | 1 | A| AG | 1 | 2 | A| AG | 1 | 1 | R| AG | 1 | 2 | R| AG | 2 | 1 | R| AG | 2 | 2 | R| AG | 3 | 1 | R| AG | 3 | 2 | R| AG +-+-+--+ AG Now, when i run the following query: AG mysql select * from xoops_groups_modules_link where type='R' and mid=2 and AG groupid=3 ; AG ERROR 2006: MySQL server has gone away AG No connection. Trying to reconnect... AG Connection id:1 AG Current database: xoops AG ERROR 2013: Lost connection to MySQL server during query AG I cant find out why its happening so!! AG Can someone plz help me. AG Infact this table is dumped from a dump. If i create a same table by myself AG and then run the same query it executes fine. Isn't that strange!! Check your table with CHECK TABLE statement, is there any error in the output? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: fulltext searching
Hi! On Jul 01, Marko Djukic wrote: i can't seem to get the fulltext searching working perfectly... single search terms it works fine, multiple search terms it also seems to be ok - finding records with any of the search terms. however, if i try the boolean mode it gives out garbage all the time. i try for example: select * from mytable where match(file_text) against('+findthis +andthis -notthis' in boolean mode); various variants of this never find the records, or find ALL the records in the database... when such filters should throw out a couple of records at least. i'm running 4.0.1-alpha on freebsd... and i've set up the tables for fulltext indexes. is this still heavy work-in-progress or should it work? does it work for anyone? It is supposed to work :) See mysql-test/t/fulltext.test file to see that it does work. So, you probably, found a bug. Would you mind creating a repeatable 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
blob versus file
Hi there, I am wondering if anybody has experiance in saving images to blob in mysql. I do save images with 1 K and 4 KB to blob fields while I used to save them to file. It seams to me that this is much slower accessing the files. The images take a bit (really short but absolutly noticable) to show up on the site. Is there a way to improve the performance, and why is this happening? I thought the performance might even boost after storing them to blobs. Thank you for any comments on that, Andy PS: I was planing to store all the other images (20 - 50 KB) to blobs as well (thousands) but after this first experiance I am a bit confused if the performance would even more suffer. Would you guys recommend this? query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql wont start
Hi! You can put this into /etc/my.cnf: [mysqld] user=root This will allow to run mysqld as root. However, consider running it under another account, it is safer. Satish Santhakumar wrote: Hi Guys, MySQL wont start it says 'Security' error cannot start mysql. Read the MySQL manual on security to start the server as a root. What is the problem here?? I cannt seem to figure out it was working fine sometime ago. This is urgent please help. -SS = The only person in the world who is enviable is one who does not envy others __ Satish Santhakumar Graduate Student IIT, Chicago and Computer Programmer University of Chicago. __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Barkov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia ___/ www.mysql.com +7-902-856-80-21 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Left outer join
Hi Can i use left outer join in MySQL. Like i have one condition in Oracle ex: select * from user,company where u.companyid = c.companyid (+) can i rephrase the query in mysql like this select * from user left outer join company c using (companyid) -Arul sql , query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: need your attn: can mysql support japanese and korean simultaneouslyin same database
Hi! Joel is right. You can store both, however in 3.23.x and 4.0.x mysqld can use rules of the only one charset for things like GROUP BY, ORDER BY, DISTINCT, etc. In upcoming 4.1, it's possible to have fields of different charsets at the same table. So, japanese and korean sorting will be possible even without Unicode, one needs just to create two fields: in korean and japanese charsets. All operartion with korean field will use korean collation rules. Correspindingly, all operation with japanese field will use japanese collation rules. Joel Rees wrote: i am working on a project in which db is mysql and it should support japanese and korean simultaneously I have mysql 3.23.36 running on red_hat_linux_7.1_sea-wolf and default ecoding for mysql is sjis Kindly tell meif is it possible to make a database support japanese and korean both languages simultaneously I don't really know much, but from what I understand, the answer to your question is probably not. If you want to sort and collate both at the same time, in the same tables, you'll need the Unicode support that is scheduled for ver. 4.1. You can store both at the same time. (You may have some problems with the drivers, but it appears that those problems can be fixed or worked around.) You can also search, if you don't care about missing a few sometimes, or if you can write a little external code to pick up some oddball cases. Or, you might consider keeping the Japanese and Korean data in separate tables on separate servers. From what I understand, that should be possible. -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Barkov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia ___/ www.mysql.com +7-902-856-80-21 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 wont start on SUSE
Anybody had a problem with MySQL that does not start on SUSE 8 with default installation? If yes, what was the problem? Thanks Jacques ___ Jacques Steyn +27 (0)11 478-1259 http://www.knowsystems.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL and ADO:Bug?
Hi, I have been trying for 4 days but I can't solve this problem and I don't know why. It's a bug? I have a table (children) which has a field called borough; I have to extract the sum of the children of each borough so I use this simple query: select count(*) , borough from children group by borough order by borough that works. If I try to call this query from a VB6 project it doesn't work, that is, it returns an empty recordset. This is the code that I'm using Dim rec As ADODB.Recordset Dim cnn As ADODB.Connection Dim cmd As ADODB.Command Dim GlConnString as String Dim strSQL As String Set rec = New ADODB.Recordset Set cnn = New ADODB.Connection Set cmd = New ADODB.Command strSQL = select count(*) , borough from children group by borough order by borough GlConnString = server=localhost;db=MyDB;driver={MySQL};uid=root;pwd=MyPwd;OPTION=35 cnn.CursorLocation = adUseClient cnn.ConnectionString = GlConnString cnn.Open cmd.CommandType = adCmdText cmd.CommandText = STRsql Set cmd.ActiveConnection = cnn Set rec = cmd.Execute ---at this point I have an empty recordset If I try with this query select borough from children group by borough order by borough that is, removing count(*) works! I'm using Windows 2000 MySQL 3.23.49 MyODBC 2.50.39 ADO 2.52.6019.1 Help me, please! Thanks Teo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 wont start on SUSE
What's your log file say? * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -Original Message- From: Jacques Steyn [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 8:28 AM To: Alexander Barkov Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: mysql wont start on SUSE Anybody had a problem with MySQL that does not start on SUSE 8 with default installation? If yes, what was the problem? Thanks Jacques ___ Jacques Steyn +27 (0)11 478-1259 http://www.knowsystems.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: Strange behaviour of mysqld after adding/dropping a column
Two questions : * have you installed MySQL as a service ?? * have you stopeed a service prior to rebooting ?? -- 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: Speed issue
Simon, Several issues come to mind. First, as Tim suggested, make sure ODBC logging is turned off. It should be by default but if you turn it on, it will whip your HD like a bad puppy. Second, run MySQL on a different machine. More importantly, understand the difference between Access and MySQL (If you do already then skip this chapter) MySQL is a database server. Access is a desktop database. It takes more horses to run MySQL than Access because it does more. If all you need is a single user database running on your desktop (Keep your recipes, checkbook, etc.) Then Access is an adequate tool. (I prefer Visual FoxPro for these tasks, but that's just me) If however, you are developing any sort of multi-user application then you'd be a fool to use Access. Like FoxPro and dBase before it, it just was not designed to run like that. Yes, it has been patched and kludged to death to make it seem like this works but when you get right down to it, it just can't do the job. So you turn to a database server. In walks MySQL. MySQL will not allow you to pain forms and reports. It is first and foremost a database engine with EVERYTHING else left for a client to do. It will allow you to safely store and retrieve your data, assign rights to multiple users, and - if compiled correctly - give you a transaction safe environment for your work. So it may seem that on your machine, with both MySQL and Access loaded together Access runs ever so much faster. However, you are comparing single use Access to single use MySQL. (also, once mysql starts caching things, it gets faster. The more you use it, the faster it runs!) Also, once you get MySQL into it's native environment (server class machine or at least one where nothing else is going on) it will run like a screaming banshee. At the risk of pissing off all your windows users out there (Check my headers, created with Outlook, I use it too) Run MySQL on a *nix box of some kind. Without the overhead of the graphical interface, which just gets in the way on a server, you have more horses/RAM to run the important stuff. In short: MySQL != Drop in replacement for desktop database =C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -Original Message- From: Simon Ashby [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 4:58 AM To: MYSQL Subject: Speed issue Hi I am trying to move an Access 2000 database into MYSQL 3.27.47nt running on a Win2K machine. MYODBC with the 3.51 drivers is also installed. MYSQL is running and readily responds to SQL queries using the DOS window at the mysql prompt. However, when linking the MYSQL database with ADO and VB6 the response is slow and there is a lot of disk activity before an answer is returned. It is a lot slower than the original Access2000/VB6 setup. A DSN-less code is being used to link VB6/ADO to MYSQL. The connection string is listed below: con.ConnectionString = DRIVER={MySQL ODBC 3.51 Driver}; _ SERVER=localhost; _ DATABASE=GIS; _ UID=Admin;PWD=africa; OPTION=16386 If of any relevance, within the WinMySQLAdmin on the Environment Tab, MYODBC is stated as not found eventhough it has been loaded. Any pointers on how to get rid of the disk churning and get a normal response in this set up would be much appreciated. 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Can't start MySQL server
Dear all: I have just removed an old version of mysql and install MySQL3.23.51 (tarball). After installation, I tried to start the server: % bin/safe_mysqld It can't be started. Message stored in file: /mysql/var/hostname.err asking Do you already have another mysqld server running on port: 3306? Aborting. I have tried hours to install it but I just could not succeed. Could anyone kindly help me out? THank you very much for your help! Frank _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Mysql 4.0.2
Unless I've misread your post, this was not so much a feature in .51 as it was a bug. If you have a FK contraint then you should never be able to insert a record into the child table that does not have a matching FK in the parent table. (Null does not mean no matching record.) Either remove the constraint, add a dummy record into the parent table or re-think what you are trying to do. (You've put on a constraint and now you are trying to break it!) =C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -Original Message- From: Arul [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 9:14 AM To: MySQL Subject: Mysql 4.0.2 Hi As i already stated , i am not able to insert a null value in a child table in 4.0.1 which i was able to do in 3.23.51 I have created a table parent and also another table child where parentid column in child is a foreign key to the id column in parent table It was possible that i have no entries in parent table , and i was able to insert null values for parentid in child table.. This was a feature in 3.23.51 whereas this was not available in 3.23.49 Any idea whether this will be supported in 4.0.2 and where i can get that from.. In the MySQL site i could see only upto 4.0.1 alpha release.. -Arul 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mtop (MySQL top) v0.6.2 released
mtop (MySQL top) monitors a MySQL database showing the queries which are taking the most amount of time to complete. Features include 'zooming' in on a process to show the complete query, 'explaining' the query optimizer information for a query and 'killing' queries. In addition, server performance statistics, configuration information, and tuning tips are provided. New 0.6.2 features: Comments are now stripped from monitor window. Comments will still appear in the zoom/explain views. Also removed leading spaces from display columns. More information available at: http://mtop.sourceforge.net/ mtop is released under the GPL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql query for next unique ID
Hi all, Does anybody know if there is a function to retrieve the next unique ID number for a record to be made in the future? thx. Wilbert mysql query for next unique ID - Pas de Deux Van Mierisstraat 25 2526 NM Den Haag tel 070 4450855 fax 070 4450852 http://www.pdd.nl [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 4.0.2
Arul, Monday, July 01, 2002, 1:25:38 PM, you wrote: A As i already stated , i am not able to insert a null value in a child table A in 4.0.1 which i was able to do in 3.23.51 A I have created a table parent and also another table child where parentid A column in child is a foreign key to the id column in parent table A It was possible that i have no entries in parent table , and i was able to A insert null values for parentid in child table.. A This was a feature in 3.23.51 whereas this was not available in 3.23.49 A Any idea whether this will be supported in 4.0.2 A and where i can get that from.. A In the MySQL site i could see only upto 4.0.1 alpha release.. Yes, it will be in 4.0.2, too . At present time you can get 4.0.2 from development source tree: http://www.mysql.com/doc/I/n/Installing_source_tree.html Binary distribution will come very soon. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: install
Page, Saturday, June 29, 2002, 8:06:56 PM, you wrote: PWWSI'm a newbie at this, so here's a newbie question. I have installed PWWS MySql on a Cobalt Raq 4 running Linux via a .pkg file. All seemed to go PWWS well, I am able to get into the MySql directory via telnet but no commands PWWS seem to work. See session below. Can anyone help me with putting a root PWWS pass word on this? PWWS [admin admin]$ mysql PWWS Welcome to the MySQL monitor. Commands end with ; or \g. PWWS Your MySQL connection id is 10 to server version: 3.23.37 PWWS Type 'help;' or '\h' for help. Type '\c' to clear the buffer PWWS mysql bin/mysqladmin -password testpassword; PWWS ERROR 1064: You have an error in your SQL syntax near PWWS 'bin/mysqladmin -password PWWS testpassword' at line 1 PWWS mysql bin/safe_mysqld ; PWWS ERROR 1064: You have an error in your SQL syntax near 'bin/safe_mysqld ' at PWWS line 1 PWWS mysql bin/safe_mysqld \g PWWS ERROR 1064: You have an error in your SQL syntax near 'bin/safe_mysqld ' at PWWS line 1 PWWS mysql bin/safe_mysqld PWWS ERROR 1064: You have an error in your SQL syntax near 'bin/safe_mysqld ' at PWWS line 1 mysqladmin, safe_mysqld are not SQL commands. mysqladmin is a client-side program: http://www.mysql.com/doc/m/y/mysqladmin.html safe_mysqld is a script that run mysqld: http://www.mysql.com/doc/s/a/safe_mysqld.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql wont start on SUSE
Jacques, Monday, July 01, 2002, 4:28:25 PM, you wrote: JS Anybody had a problem with MySQL that does not start on SUSE 8 with default JS installation? JS If yes, what was the problem? What do you mean does not start? If you get any error please provide more info. Check also you host_name.err file in the MySQL data dir. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Strange behaviour of mysqld after adding/dropping a column
Cams Ismael writes: * I have indeed installed MySQL as a service. That's why I use 'net stop mysql' and 'net start mysql' to start and stop the MySQL server. * I have done nothing special before rebooting my PC. The problem doesn't seem to lay in rebooting the PC, but in stopping andstarting the MySQL service. Rebooting the PC causes this service to stop and to start. Kind regards, Ismaël Sorry, but this is not reliable enough on any Windows, including W2K. You have to stop a service before re-booting. Only then you will have no problems with MySQL. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql wont start on SUSE
Have you went into YaST and turn it on? I won't run until you do so. You can start it yourself as well; /etc/rc.d/mysql start Chuck Payne On Monday, July 1, 2002, at 09:47 AM, Cal Evans wrote: What's your log file say? * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -Original Message- From: Jacques Steyn [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 8:28 AM To: Alexander Barkov Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: mysql wont start on SUSE Anybody had a problem with MySQL that does not start on SUSE 8 with default installation? If yes, what was the problem? Thanks Jacques ___ Jacques Steyn +27 (0)11 478-1259 http://www.knowsystems.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 mysql-unsubscribe- [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 mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql query for next unique ID
Try this query: SELECT yourcolumn+1 FROM yourtable ORDER BY id desc LIMIT 1; greetings, 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
Help, Function Sequence Error
Hey all, I'm having problems ! , my app was running fine until this morning. I receive following error : Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Driver Manager] Function sequence error /clientenrollment.asp, line 67 the line 67 for that file is oRS1.movefirst here is a snip of the code : SNIP oRS1.open SELECT * from enrollment where ClientID='varclientID', DSN=CCMS;uid=web_user;pwd=web_user if oRS1.EOF then response.write FONT SIZE=3Client is not currently enrolled in any programs click a href=javascript:popUp1() class=submenuhere/a to add a program else 'LINE67: oRS1.movefirst response.write TABLE WIDTH=80% BORDER=1 CELLSPACING=0 response.write TRTD ALIGN=CENTERBProgram Name/B/TDTD ALIGN=CENTERBTherapist/B/TD ALIGN=CENTERBStart Date/B/TDTD ALIGN=CENTERBEnd Date/B/TDTD ALIGN=CENTERBFunding/B/TDTDnbsp;/TD ALIGN=CENTER/TR Do while not oRS1.EOF response.write TRTDoRS1(program_name)nbsp;/TDTDoRS1(providerID)nbsp; /TDTDoRS1(start_date)nbsp;/TDTDoRS1(end_date)nbsp;/TD TDoRS1(funderID)/TDTDnbsp; if oRS1(active) = 1 then response.write Font COLOR=REDActive/FONT/TR else response.write /TR End If oRS1.MoveNext Loop response.write /TABLE End If /SNIP I didnt change anything on the server, have tried a reboot, but to no avail, MYSQL is running on w2k 2000 server and the ASP with through IIS. Please if anyone has any idea what I am doing wrong, please let me know. Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
AW: mysql wont start on SUSE
Yes, I have go to my.cnf and write [mysqld] user=root then start the server with mysqld. This works on my computer, but I'm not sure if the right way cause the the server shouldn't use with the user root but for a test it's ok. Have you already started the script mysql_install_db? It's necessary. Macloy -Ursprungliche Nachricht- Von: Jacques Steyn [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 1. Juli 2002 15:28 An: Alexander Barkov Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Betreff: mysql wont start on SUSE Anybody had a problem with MySQL that does not start on SUSE 8 with default installation? If yes, what was the problem? Thanks Jacques ___ Jacques Steyn +27 (0)11 478-1259 http://www.knowsystems.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql wont start on SUSE
SuSE 8 and for that matter all version of SuSE MySQl doesn't run until you use YaST to turn it. That why it's not starting. You can start it your by the following command; /etc/rc.d/mysql start If there is no problem with mysql you should see this mysqld done By going into YaST2/YaST and telling it to start mysql it will start it from boot up. For more help with SuSE and start up daemons feel free to write me ok. This isn't really mysql fault, it the way SuSE control things. Chuck Payne Magi Design and Support SuSE user from the past 5 years. On Monday, July 1, 2002, at 10:34 AM, Egor Egorov wrote: Jacques, Monday, July 01, 2002, 4:28:25 PM, you wrote: JS Anybody had a problem with MySQL that does not start on SUSE 8 with default JS installation? JS If yes, what was the problem? What do you mean does not start? If you get any error please provide more info. Check also you host_name.err file in the MySQL data dir. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [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: Speed issue
So it may seem that on your machine, with both MySQL and Access loaded together Access runs ever so much faster. However, you are comparing single use Access to single use MySQL. (also, once mysql starts caching things, it gets faster. The more you use it, the faster it runs!) Also, once you get MySQL into it's native environment (server class machine or at least one where nothing else is going on) it will run like a screaming banshee. I'll second that ;) We use MySQL extensively here, and we also use Access for the small stuff. Occasionally we will build an Access database, then link tables to MySQL via the MyODBC driver, then do database stuff as usual with VB6. Same with proof-of-concept or demo stuff that we want to upscale quickly. By the way, if you're going to use VB, I'd strongly suggest setting the dbSQLPassThru option on your queries and such, it will speed things up tremendously. If you don't, VB will bring down the entire table or tables to your desktop, then work on the data locally, a HUGE waste of time and bandwidth. You also don't have to use ADO if you don't want to - I use DAO and with passthru turned on, it works just fine ;) -- Ed Carp, N7EKG http://www.pobox.com/~erc 214/986-5870 Director, Software Development Escapade Server-Side Scripting Engine Development Team Pensacola - Dallas - London - Dresden - Paris http://www.squishedmosquito.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: Lost Connection to mysql server during query
Hi, Thanx for your mail You are rightin my case the mysqld is getting restarted. But, whey is mysqld getting restarted and giving the Lost Connection error. How can i avoid that?? Thanx anil - Original Message - From: Dicky Wahyu Purnomo [EMAIL PROTECTED] To: Anil Garg [EMAIL PROTECTED] Sent: Saturday, June 29, 2002 9:04 AM Subject: Re: Lost Connection to mysql server during query Pada Thu, 27 Jun 2002 10:59:48 -0400 Anil Garg [EMAIL PROTECTED] menulis : Now when i try to insert by using the following query: INSERT INTO 1_polls VALUES (1,'This web site is...',1,1,7,20011223105127); It gives the error: Error 2013 at line 235: Lost connection to MySQL server during query If i decrease the lenght of time stamp in the INSERT query INSERT INTO 1_polls VALUES (1,'This web site is...',1,1,7,2001122); it works fine. Can anyone help me by telling wots going wrong here!! Have you retry the first query again ? Usually, Lost Connection happens because your query process has been killed by someone else (or even the system - maybe something related to query timeout values) or the mysqld was restarted. -- People disagree with me. I just ignore them. -- Linus Torvalds, regarding the use of C++ for the Linux kernel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: blob versus file
Andy, File Systems are made to store and retrieve files in an efficient way. You may not expect better performance when you put a database in between. When speed is an issue you should use MySQL to store and retrieve filenames and something like ReiserFS, RAID and good hardware to store images. Thomas Spahni On Mon, 1 Jul 2002, andy wrote: Hi there, I am wondering if anybody has experiance in saving images to blob in mysql. I do save images with 1 K and 4 KB to blob fields while I used to save them to file. It seams to me that this is much slower accessing the files. The images take a bit (really short but absolutly noticable) to show up on the site. Is there a way to improve the performance, and why is this happening? I thought the performance might even boost after storing them to blobs. Thank you for any comments on that, Andy PS: I was planing to store all the other images (20 - 50 KB) to blobs as well (thousands) but after this first experiance I am a bit confused if the performance would even more suffer. Would you guys recommend this? 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
MySQL
I've tried to get MySQL to install and run from source. I configured and compiled without any errors. However when trying to start the service i get the following: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Can anyone help me please? I'm running SuSE Enterprise 7.3 Regards Nigel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: RE: Foriegn Key
D.K.Dubey, Monday, July 01, 2002, 2:13:25 PM, you wrote: DKD Thanks, I m using MySQl 3.23. Will u please tell me how it is possible. It's possible to set ON DELETE CASCADE since 3.23.50: http://www.mysql.com/doc/S/E/SEC446.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: redudancy / high availability
Hi all, I want to setup (on linux systems) a pair of redundant mysql servers, working this way : * one master and one backup * the master handles all the requests, the backup updates its data frequently (and, if possible, CONSISTENTLY) from the master * on failure of the master, the backup comes and handles all the requests, as if it was the master. * when the master server comes back, it updates itself from the backup, and then restarts to work normally I think the slave/master system of MySQL is not sufficient (the master does not updates itself after coming back). Did anybody manage to setup such a system ? Please explain me how, with what kind of scripts or tools. Thanks Mathieu D. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 keeps crashing
I have mySQL 3.23.49 which seems to be crashing a lot. What is happening is I'm using a web-based application written in perl using the perl DBI interface for mySQL. It seems like whenever I make a change to the database via this application the database develops corrupted tables. I am using the most recent perl modules from CPAN (this is a Linux server) for the perl DBD and DBI. Where should I start looking to find the problem? heheh. Hope that isn't too broad a question... Brett Ussher ITS, Matrix Maricopa Community College District (480) 731-8691 [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
Stupid backup/restore question
I have a working server and a development server. From time to time I'd like to refresh the content of my development server with what's on my working server. So I take one of my regular backups, that I get by doing mysqldump database dbbackupJuly1-02. Then I gzip this, ftp it over to my development server, gunzip it, and try mysql database dbbackupJuly1-02, and immediately get an ERROR 1050 at line 11: Table 'firsttable' already exists message. What should I be doing instead? The docs don't seem to specify this, and there doesn't seem to be an ignore or replace option for the mysql command. Do I actually have to drop all the tables on my development box before loading in from the backup? Jesse Sheidlower [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
On Mon, 1 Jul 2002, Nigel George wrote: I've tried to get MySQL to install and run from source. I configured and compiled without any errors. However when trying to start the service i get the following: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Can anyone help me please? I'm running SuSE Enterprise 7.3 Nigel look in /usr/share/doc/packages/mysql/README.SuSE what they are using to compile it. Then check /etc/my.cnf and your ~/.my.cnf for proper values. Thomas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can't start MySQL server
Hi! It seems you still have an old mysqld running. Check this: ps ax | grep mysqld and kill it if it does really present. duo fu wrote: Dear all: I have just removed an old version of mysql and install MySQL3.23.51 (tarball). After installation, I tried to start the server: % bin/safe_mysqld It can't be started. Message stored in file: /mysql/var/hostname.err asking Do you already have another mysqld server running on port: 3306? Aborting. I have tried hours to install it but I just could not succeed. Could anyone kindly help me out? THank you very much for your help! Frank _ 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 -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Barkov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia ___/ www.mysql.com +7-902-856-80-21 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Help?
Hi all, anyone know why this error would come up. This is running on a Linux box [admin admin]$ scripts/mysql_install_db bash: scripts/mysql_install_db: No such file or directory Shawn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
efficiency of mysql 2.23
Dear group. I have on server Intel Pentium IV 1,8 GHz, 1GB RAM. I would like to set some efficiency settings into my my_multi.conf of mysql .3.23 BUT although I read docs (unclear for me ;-)) I don't know how to set proper values and where to set ones. Problem is that servers stops answering for ~2 or 3 seconds when a lot of users are connected. Stop answering - I mean that ex. when I'm working on console (doing another then selecting activity) ex. during opening config file server show me ingredience after 2 or 3 seconds. I don't tell about working on end user application because from consum of time during makeing selects point of view delays are not objective. OK. Let say there is such section It is common section. #[mysqld] #port = 3306 #socket = /tmp/mysql.sock #skip-locking #set-variable = key_buffer=16K #set-variable = max_allowed_packet=1M #set-variable = thread_stack=64K #set-variable = table_cache=4 #set-variable = sort_buffer=64K set-variable= net_buffer_length=2K #server-id = 1 It is commented because the final are like for 0 server [mysqld0] socket = /tmp/mysql.sock.0 port = 3306 pid-file = /usr/local/mysql/var2/hostname.pid.0 3datadir= /mnt/mysql language = /usr/local/mysql/share/mysql/english but nowhere was written if any efficency variables can be puted into. Please show me UNDERSTENDABLE information for meaning of those variables OR just tell me what values should be puted into config file to satisfy users regarding ability of my server machine. Another question is that whether storing on fisical the same drive system and mysql data base datas have influence on efficiency ? I can try if I will separate it and system will start from hda and datas will be stored on hdb for ex. would incease flexibility of data flow. --- Marek Wysmu³ek - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Stupid backup/restore question
Jesse, try to make dump (mysqldump) with option --add-drop-table or --opt (it will be faster). Description of this options see here http://www.mysql.com/doc/m/y/mysqldump.html Best regards, Mikhail. - Original Message - From: Jesse Sheidlower [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 01, 2002 6:30 PM Subject: Stupid backup/restore question I have a working server and a development server. From time to time I'd like to refresh the content of my development server with what's on my working server. So I take one of my regular backups, that I get by doing mysqldump database dbbackupJuly1-02. Then I gzip this, ftp it over to my development server, gunzip it, and try mysql database dbbackupJuly1-02, and immediately get an ERROR 1050 at line 11: Table 'firsttable' already exists message. What should I be doing instead? The docs don't seem to specify this, and there doesn't seem to be an ignore or replace option for the mysql command. Do I actually have to drop all the tables on my development box before loading in from the backup? Jesse Sheidlower [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Help! MySQL overloading my system
Alors! I run MySQL-3.23.41 on FreeBSD-4.5-STABLE but everytime I get my system slowing down and on checking with `top` I see MySQL as the culprit: cut last pid: 29586; load averages: 1.41, 1.45, 1.48 up 28+10:55:17 20:10:59 90 processes: 3 running, 83 sleeping, 1 stopped, 3 zombie CPU states: 16.7% user, 0.0% nice, 51.4% system, 0.4% interrupt, 31.5% idle Mem: 249M Active, 36M Inact, 71M Wired, 16M Cache, 48M Buf, 1960K Free Swap: 1374M Total, 58M Used, 1316M Free, 4% Inuse PID USERNAME PRI NICE SIZERES STATE C TIME WCPUCPU COMMAND 28687 mysql 63 0 40604K 5940K RUN0 27.8H 88.23% 88.23% mysqld 29489 wash 10 0 12944K 12420K nanslp 0 0:04 23.89% 11.43% perl 29424 wash 10 0 12904K 12376K nanslp 1 0:04 10.06% 6.54% perl 29382 root 30 0 2072K 1200K CPU0 0 0:02 3.50% 2.83% top 29511 exim2 0 3692K 2240K select 1 0:01 3.84% 1.51% exim 29576 exim2 0 3700K 2240K select 0 0:00 9.74% 0.93% exim 41215 www18 0 41056K 24592K lockf 1 0:40 0.29% 0.29% httpd 41216 www18 0 39980K 24316K lockf 1 0:23 0.15% 0.15% httpd 684 root2 0 1492K 840K select 1 110:49 0.10% 0.10% tpop3d Could someone more knowledgeable point me in the right direction towards isolating what could be causing this load. I have several databases on this box, TWO of which are very busy as the SMTP/POP3 daemons both interact with it as this is the main server. Thanking you in advance. -Wash -- Odhiambo Washington [EMAIL PROTECTED]The box said 'Requires Wananchi Online Ltd. www.wananchi.com Windows 95, NT, or better,' Tel: 254 2 313985-9 Fax: 254 2 313922 so I installed FreeBSD. GSM: 254 72 743 223 GSM: 254 733 744 121 This sig is McQ! :-) Westheimer's Discovery: A couple of months in the laboratory can frequently save a couple of hours in the library. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Stupid backup/restore question
use the --opt option for mysqldump. --opt Same as --add-drop-table --add-locks --all --extended-insert --quick --lock-tables Other than that, it's the method I use. =C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -Original Message- From: Jesse Sheidlower [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 11:30 AM To: [EMAIL PROTECTED] Subject: Stupid backup/restore question I have a working server and a development server. From time to time I'd like to refresh the content of my development server with what's on my working server. So I take one of my regular backups, that I get by doing mysqldump database dbbackupJuly1-02. Then I gzip this, ftp it over to my development server, gunzip it, and try mysql database dbbackupJuly1-02, and immediately get an ERROR 1050 at line 11: Table 'firsttable' already exists message. What should I be doing instead? The docs don't seem to specify this, and there doesn't seem to be an ignore or replace option for the mysql command. Do I actually have to drop all the tables on my development box before loading in from the backup? Jesse Sheidlower [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Stupid backup/restore question
On 1 Jul 2002, at 12:30, Jesse Sheidlower wrote: What should I be doing instead? The docs don't seem to specify this, and there doesn't seem to be an ignore or replace option for the mysql command. Do I actually have to drop all the tables on my development box before loading in from the backup? Have you seen the --add-drop-table option (see http://www.mysql.com/doc/m/y/mysqldump.html), or is that what you mean by your reference to dropping the tables? Without dropping the tables, how would you get rid of records that have been deleted? (Still writing for Copy Editor?) [Filter fodder: SQL] -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re:Speed Issue - Thanks
Thanks to all who responded to this posting. The problem was due to ODBC logging turned on. When this was rectified the system flew along like a greyhound! I appreciate the other helpful suggestions given. The reason for moving from Access to MYSQL is that I am moving a GIS application developed on a standalone computer to a network environment. There is a potential of 1.9 m employee records a year to be entered into the database - something that Access cannot handle as I have found out to my cost! The final set up will be a dedicated server (Linux is the aim) with clients linking in. I take on board the issue of bandwidth and using the dbSQLPassThru option. A fellow student put me onto MYSQL, which is proving to be the answer to my database problems, especially with such a supportive user group out there! Regards Simon Ashby - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: efficiency of mysql 2.23
Marek, check this URL http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html Best regards, Mikhail. - Original Message - From: Marek Wysmulek [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 01, 2002 6:56 PM Subject: efficiency of mysql 2.23 Dear group. I have on server Intel Pentium IV 1,8 GHz, 1GB RAM. I would like to set some efficiency settings into my my_multi.conf of mysql .3.23 BUT although I read docs (unclear for me ;-)) I don't know how to set proper values and where to set ones. Problem is that servers stops answering for ~2 or 3 seconds when a lot of users are connected. Stop answering - I mean that ex. when I'm working on console (doing another then selecting activity) ex. during opening config file server show me ingredience after 2 or 3 seconds. I don't tell about working on end user application because from consum of time during makeing selects point of view delays are not objective. OK. Let say there is such section It is common section. #[mysqld] #port = 3306 #socket = /tmp/mysql.sock #skip-locking #set-variable = key_buffer=16K #set-variable = max_allowed_packet=1M #set-variable = thread_stack=64K #set-variable = table_cache=4 #set-variable = sort_buffer=64K set-variable= net_buffer_length=2K #server-id = 1 It is commented because the final are like for 0 server [mysqld0] socket = /tmp/mysql.sock.0 port = 3306 pid-file = /usr/local/mysql/var2/hostname.pid.0 3datadir= /mnt/mysql language = /usr/local/mysql/share/mysql/english but nowhere was written if any efficency variables can be puted into. Please show me UNDERSTENDABLE information for meaning of those variables OR just tell me what values should be puted into config file to satisfy users regarding ability of my server machine. Another question is that whether storing on fisical the same drive system and mysql data base datas have influence on efficiency ? I can try if I will separate it and system will start from hda and datas will be stored on hdb for ex. would incease flexibility of data flow. --- Marek Wysmu³ek - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Help?
If the file is actually there... make sure the first line actually points to the perl binary. - Johnny Withers [EMAIL PROTECTED] p. 601.853.0211 c. 601.209.4985 -Original Message- From: Page Works Web Solutions [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 11:48 AM To: [EMAIL PROTECTED] Subject: Help? Hi all, anyone know why this error would come up. This is running on a Linux box [admin admin]$ scripts/mysql_install_db bash: scripts/mysql_install_db: No such file or directory Shawn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Case Insensitivity of queries and record lookup
New binary character set should appear in next release. It provides case-sensitive comparisons. It even doesn't require recompiling mysqld, you need just to put binary.conf file into /share directory of mysql installation, then restart mysqld with --default-character-set=binary argument. If you would like me to send binary.conf file, please let me know. Keith C. Ivey wrote: On 28 Jun 2002, at 14:27, Mark Hennessy wrote: I have noticed after migrating my database from mSQL to MySQL that queries are providing lookup results in a case-insensitive manner. To avoid that, make your CHAR and VARCHAR columns BINARY, or if you only want to make *some* comparisons case-sensitive, use BINARY in your query: http://www.mysql.com/doc/C/H/CHAR.html http://www.mysql.com/doc/C/a/Case_Sensitivity_Operators.html -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Barkov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia ___/ www.mysql.com +7-902-856-80-21 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
looking for sql gui application
Hi Everybody, My organization is looking for some secure GUI tool for MYSql. If possible, something which use SSH. I am new to MySql. Can anybody highlight on this and suggest some tools. We use lynix with apache, tomcat installed on it and installed ver 3.23 of Mysql. Thanks in advance Roma - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Stupid backup/restore question
On Mon, Jul 01, 2002 at 01:23:38PM -0400, Keith C. Ivey wrote: On 1 Jul 2002, at 12:30, Jesse Sheidlower wrote: What should I be doing instead? The docs don't seem to specify this, and there doesn't seem to be an ignore or replace option for the mysql command. Do I actually have to drop all the tables on my development box before loading in from the backup? Have you seen the --add-drop-table option (see http://www.mysql.com/doc/m/y/mysqldump.html), or is that what you mean by your reference to dropping the tables? Thanks to all who responded with this general suggestion. I had looked at the --opt option, but ignored it as speed wasn't a real issue for this. And it didn't occur to me that this would be something to specify in the backup, rather than the restore. Without dropping the tables, how would you get rid of records that have been deleted? Well, I said in the subject line it was a stupid question! (Still writing for Copy Editor?) Yup. Jesse MySQL Query Sheidlower [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: Help! MySQL overloading my system
Hi, As a first step I would find out what mysql is doing, Use either 'show processlist' or using mysqladmin 'mysqladmin proc'. Or even better install mytop (cd /usr/ports/databases/mytop; make install; ). This program sorts the output for you. There does seem to be a sometimes bug with mysql that 'may' be related to the thread cache. If you have increased the thread cahce (which is mostly not needed) Try reducing the thread cache to 2, but make sure that it is not just a slow query causing the problem. Hope this helps, Ken - Original Message - From: Odhiambo Washington [EMAIL PROTECTED] To: mySQL [EMAIL PROTECTED] Cc: FBSD-Q [EMAIL PROTECTED] Sent: Monday, July 01, 2002 1:17 PM Subject: Help! MySQL overloading my system Alors! I run MySQL-3.23.41 on FreeBSD-4.5-STABLE but everytime I get my system slowing down and on checking with `top` I see MySQL as the culprit: cut last pid: 29586; load averages: 1.41, 1.45, 1.48 up 28+10:55:17 20:10:59 90 processes: 3 running, 83 sleeping, 1 stopped, 3 zombie CPU states: 16.7% user, 0.0% nice, 51.4% system, 0.4% interrupt, 31.5% idle Mem: 249M Active, 36M Inact, 71M Wired, 16M Cache, 48M Buf, 1960K Free Swap: 1374M Total, 58M Used, 1316M Free, 4% Inuse PID USERNAME PRI NICE SIZERES STATE C TIME WCPU CPU COMMAND 28687 mysql 63 0 40604K 5940K RUN0 27.8H 88.23% 88.23% mysqld 29489 wash 10 0 12944K 12420K nanslp 0 0:04 23.89% 11.43% perl 29424 wash 10 0 12904K 12376K nanslp 1 0:04 10.06% 6.54% perl 29382 root 30 0 2072K 1200K CPU0 0 0:02 3.50% 2.83% top 29511 exim2 0 3692K 2240K select 1 0:01 3.84% 1.51% exim 29576 exim2 0 3700K 2240K select 0 0:00 9.74% 0.93% exim 41215 www18 0 41056K 24592K lockf 1 0:40 0.29% 0.29% httpd 41216 www18 0 39980K 24316K lockf 1 0:23 0.15% 0.15% httpd 684 root2 0 1492K 840K select 1 110:49 0.10% 0.10% tpop3d Could someone more knowledgeable point me in the right direction towards isolating what could be causing this load. I have several databases on this box, TWO of which are very busy as the SMTP/POP3 daemons both interact with it as this is the main server. Thanking you in advance. -Wash -- Odhiambo Washington [EMAIL PROTECTED]The box said 'Requires Wananchi Online Ltd. www.wananchi.com Windows 95, NT, or better,' Tel: 254 2 313985-9 Fax: 254 2 313922 so I installed FreeBSD. GSM: 254 72 743 223 GSM: 254 733 744 121 This sig is McQ! :-) Westheimer's Discovery: A couple of months in the laboratory can frequently save a couple of hours in the library. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
ER Diagram.
Could you please let me know that how will I design ER diagram in MySQL. Abhi _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql query for next unique ID
On Monday 01 July 2002 10:29, W. Enserink wrote: Hi all, You would just do something like SELECT max(idcolumn)+1 as nextvalue FROM tablename where idcolumn is the name of the column and tablename is the name of your table, but remember that you may need to serialize this, since probably the NEXT thing you're going to do is insert into another table using that id number, and you don't want someone else to grab it in the meantime. The traditional way is to issue a lock on the table, but with InnoDB tables you should be able to do it with a transaction. Does anybody know if there is a function to retrieve the next unique ID number for a record to be made in the future? thx. Wilbert mysql query for next unique ID - Pas de Deux Van Mierisstraat 25 2526 NM Den Haag tel 070 4450855 fax 070 4450852 http://www.pdd.nl [EMAIL PROTECTED] - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: ER Diagram.
http://www.thekompany.com/products/dataarchitect/ $49.00 - Well worth it even with it's flaws. =C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -Original Message- From: abhishek sahay [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 1:33 PM To: [EMAIL PROTECTED] Subject: ER Diagram. Could you please let me know that how will I design ER diagram in MySQL. Abhi _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
er diagramming
ERwin, in which I did the logical data model for a MySQL database, doesn't support MySQL data types or specific MySQL code export. Do any tools? Notepad and vi look like my best physical design tools at this point, which is okay. But I wanted to be sure I wasn't missing anything out there -- along the lines of ERwin but with MySQL support. Thanks. -billb - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: er diagramming
PowerDesigner from Sybase is awesome. Nilesh -Original Message- From: Bill Bernat [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 3:25 PM To: [EMAIL PROTECTED] Subject: er diagramming ERwin, in which I did the logical data model for a MySQL database, doesn't support MySQL data types or specific MySQL code export. Do any tools? Notepad and vi look like my best physical design tools at this point, which is okay. But I wanted to be sure I wasn't missing anything out there -- along the lines of ERwin but with MySQL support. Thanks. -billb - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
synopsis of the problem (one line)
Description: How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:Michael Heinrich Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-3.23.41 (Source distribution) Environment: System: Linux gromit 2.4.10-4GB #1 Thu Oct 25 17:06:37 GMT 2001 i586 unknown Architecture: i586 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i486-suse-linux/2.95.3/specs gcc version 2.95.3 20010315 (SuSE) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='-O2 -mcpu=i486 -march=i486 -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE' LDFLAGS='' LIBC: -rwxr-xr-x1 root root 1384168 Sep 20 2001 /lib/libc.so.6 -rw-r--r--1 root root 25215580 Sep 20 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 Sep 20 2001 /usr/lib/libc.so -rw-r--r--1 root root 856542 Sep 24 2001 /usr/lib/libc-client.a lrwxrwxrwx1 root root 20 Nov 27 2001 /usr/lib/libc-client.so - libc-client.so.2000c -rwxr-xr-x1 root root 718160 Sep 24 2001 /usr/lib/libc-client.so.2000c Configure command: ./configure --disable-shared --with-mysqld-ldflags='-all-static' --with-client-ldflags='-all-static' --without-berkeley-db --without-innodb --enable-assembler --enable-large-files --infodir=/usr/share/info --libdir=/usr/lib --libexecdir=/usr/sbin --localstatedir=/var/lib/mysql --mandir=/usr/share/man --prefix=/usr --sysconfdir=/etc --with-mysqld-user=mysql --without-debug --datadir=/usr/share --includedir=/usr/include --with-extra-charsets=complex --with-unix-socket-path=/var/lib/mysql/mysql.sock --with-libwrap - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: RecordCount
- Original Message - From: Steve Edberg [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, June 28, 2002 1:49 PM Subject: RE: RecordCount I assume you are using ODBC to access MySQL; I have had this problem before (sorry, don't remember the details...it was several years ago). Some ODBC drivers don't return the record count - they return -1 instead. You might need to update your driver. The myodbc mailing list might be of more help... -steve The ADO rs.recordCount method returns the correct value only when you are using the client side cursor, but server side cursor will always return -1 as the total number of rows in the current resultset, and this is a known issue. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL client unusable with large data sets
Hi, -Original Message- From: Dave Harms [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 26, 2002 9:05 AM To: [EMAIL PROTECTED] Subject: MySQL client unusable with large data sets I've been a loyal MySQL fan for a few years now, and use it extensively in web site development. But I've run into a problem now (MyODBC 3.51.03) that is making me reconsider my choice. Most of my database access is local using JDBC, but I have some critical Windows software that relies on MyODBC. On small result sets, no problem. But on large result sets, where MySQL should shine, queries take far too long to complete because MyODBC uses mysql_store_result instead of mysql_use_result. If I change the driver to use mysql_use_result, I run into the Commands out of sync; You can't run this command now error, presumably because there's a new query executing before the first one has been fully fetched. This appears to be a fundamental weakness in the MySQL client library design. The only way MyODBC will be usable to me in the future is if it can retrieve records only as needed by the client, and can do this from multiple tables without closing each query first. Is such a thing possible? If possible, will it happen soon? Thanks. We will be considering this option in the next release, 3.51.04, so that one can enable either cache(mysql_store_result) based or non-cache based(mysql_use_result) resultset handling through the connection flag(OPTION parameter). Actually this implementation was added to 3.51.03 itself, but at the last minute the new code base is removed due to some consistency issues. Currently we suggest you to use option 1+2+2048+ 8192 (only for systems that supports named pipes) in accessing large tables. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Odp: mysql.sock and other small animals
permissin problem - Original Message - From: Christopher Marsh-Bourdon [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 28, 2002 12:22 PM Subject: mysql.sock and other small animals I have a bit of an issue: I have just upgraded my version of MySQL on my Cobalt Qube Linux server, and the installation would appear to have removed (or not created) a mysql.sock file in the /var/lib/mysql/ directory. It has created a link in the /tmp/ directory. I have verified that there are no cron jobs running that would remove this file (as the help suggests on the MySQL site). Has anyone got any suggestions as to what I should do (create a new file etc.)? Cheers Christopher Marsh-Bourdon Pyplia Limited site: www.pyplia.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 --- Super promocyjna oferta dla mieszkancow Krakowa http://www.promocja.kki.pl/radio.html --- --- Super promocyjna oferta dla mieszkancow Krakowa http://www.promocja.kki.pl/radio.html --- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: redudancy / high availability
On Mon, Jul 01, 2002 at 06:24:45PM +0200, Mathieu DESPRIEE - NO SPAM wrote: Hi all, I want to setup (on linux systems) a pair of redundant mysql servers, working this way : * one master and one backup * the master handles all the requests, the backup updates its data frequently (and, if possible, CONSISTENTLY) from the master * on failure of the master, the backup comes and handles all the requests, as if it was the master. * when the master server comes back, it updates itself from the backup, and then restarts to work normally I think the slave/master system of MySQL is not sufficient (the master does not updates itself after coming back). What if you use a dual-master setup? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.51: up 32 days, processed 706,435,121 queries (248/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL AB: Need documentation clarification
On Tue, Jun 11, 2002 at 03:58:14PM -0700, Jeff Kilbride wrote: both InnoDB and MyISAM keep also dynamically statistics about tables. In most cases running ANALYZE TABLE does not bring any benefit in query optimization. Personally, I'm pretty shocked to hear you say this. I was under the impression that running ANALYZE TABLE was a good thing and helped ensure the key distribution for the table in question was up to date. You're correct. There are times when the MyISAM table handler looses touch with what the table really contains. Running ANALYZE or OPTIMIZE will fix that. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.51: up 32 days, processed 706,777,053 queries (248/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql query for next unique ID
W., Monday, July 01, 2002, 5:29:41 PM, you wrote: WE Does anybody know if there is a function to retrieve the next unique ID WE number for a record to be made in the future? Nope. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Hidden rows in table.
Jonas, Saturday, June 29, 2002, 12:20:41 PM, you wrote: JO I have just started to use MySQL and I have come up with a strange JO problem. JO I have a table with 28 rows. When I do 'SELECT * FROM table_name;' in JO the MySQL client it only shows 12 of these rows. But if i specify one of JO the rows that are not shown with the first command, like 'SELECT * FROM JO table_name WHERE id='25';' this row is shown. JO Any suggestions what might be wrong? Can you send me a dump of your table for testing? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: er diagramming
Somewhere within www.mysql.com is a link to a site that has an ERD tool that supports MySQL...think the name is Dezigner or EasyDezign or something like that. Search through the MySQL site and you'll find it. Free trial version (limited entities) and the full tool isn't very expensive. - Original Message - From: Bill Bernat [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 01, 2002 3:25 PM Subject: er diagramming ERwin, in which I did the logical data model for a MySQL database, doesn't support MySQL data types or specific MySQL code export. Do any tools? Notepad and vi look like my best physical design tools at this point, which is okay. But I wanted to be sure I wasn't missing anything out there -- along the lines of ERwin but with MySQL support. Thanks. -billb - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: er diagramming
http://www.datanamic.com/ DeZign for Databases... - Original Message - From: Bill Bernat [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 01, 2002 3:25 PM Subject: er diagramming ERwin, in which I did the logical data model for a MySQL database, doesn't support MySQL data types or specific MySQL code export. Do any tools? Notepad and vi look like my best physical design tools at this point, which is okay. But I wanted to be sure I wasn't missing anything out there -- along the lines of ERwin but with MySQL support. Thanks. -billb - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: high level: enabling transactions in mysql-max with WebLogic TX datasource?
Bert == Bert VdB [EMAIL PROTECTED] writes: Bert Hi, Bert all you have to do use a transaction enabled data-source and use the Bert Mm-MysqlDriver Bert for your JDBC connections. (http://mmmysql.sourceforge.net/) Bert Best is to read the InnoDB documentation carefully (http://www.innodb.com), Bert as you cannot choose from a wide Bert variety of transaction-levels ... in my experience, most of the detailed Bert transaction-handling Bert can only be done at mysql-query level. Bert To test wether your datasource supports the transactions, do a test and look Bert at the InnoDB-logfiles, it should Bert indicate some thing like SET AUTOCOMMIT=0 and COMMIT. Ok, I determined that innodb wasn't being initialized because I didn't have innodb_data_file_path set in my.ini. I added the following line to my.ini in mysqladmin: innodb_data_file_path = ibdata1:30M:autoextend After I restarted the service and created some tables (not adding any rows yet), I noticed the following files in the data subdirectory: --- total 41004 drwxr-xr-x2 dmkarr None 8192 Jul 1 15:01 mysql/ -rw-r--r--1 dmkarr None 2461 Jul 1 14:59 mysql.err -rw-r--r--1 dmkarr None 5242880 Jul 1 14:59 ib_logfile0 -rw-r--r--1 dmkarr None 31457280 Jul 1 14:59 ibdata1 drwxr-xr-x4 dmkarr None 4096 Jul 1 14:59 ./ -rw-r--r--1 dmkarr None25088 Jul 1 14:59 ib_arch_log_00 -rw-r--r--1 dmkarr None 5242880 Jul 1 14:59 ib_logfile1 drwxr-xr-x 11 dmkarr None 4096 Jun 29 11:30 ../ drwxr-xr-x2 dmkarr None0 Jun 29 11:07 test/ --- However, I don't know how to check the log files for those strings, as they appear to be binary. A simple grep didn't find anything. Is there a special viewer for mysql log files? -- === David M. Karr ; Java/J2EE/XML/Unix/C++ [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
procedure analyze()
I ran this on several of my tables... I expected it to give me reccomendations on how to improve my tables performance... SELECT * FROM `5323` PROCEDURE ANALYSE() It returned no results ever am I doing something wrong? Or, is this feature simply not enabled on my system? Running MySQL 3.23.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: er diagramming
Yeah, found it (per your other message), Dezign for Databases, looks great for what I need to do and although I haven't had a chance to do much with it it seems to work for basic entity relationships. I never seem to use the full $3000++ functionality of Erwin/ER Designer, etc., which don't have MySQL support ... eventually they'll have to add it though. -billb -Original Message- From: MikeParton [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 2:11 PM To: Bill Bernat; [EMAIL PROTECTED] Subject: Re: er diagramming Somewhere within www.mysql.com is a link to a site that has an ERD tool that supports MySQL...think the name is Dezigner or EasyDezign or something like that. Search through the MySQL site and you'll find it. Free trial version (limited entities) and the full tool isn't very expensive. - Original Message - From: Bill Bernat [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 01, 2002 3:25 PM Subject: er diagramming ERwin, in which I did the logical data model for a MySQL database, doesn't support MySQL data types or specific MySQL code export. Do any tools? Notepad and vi look like my best physical design tools at this point, which is okay. But I wanted to be sure I wasn't missing anything out there -- along the lines of ERwin but with MySQL support. Thanks. -billb - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
innodb @ windows xp
hi guys, i have installed mysql v 3.23.44-nt on my XP using *Binary* distribution, how can i now develop an InnoDB tables? thanks very much sql -- Hytham Shehab --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.372 / Virus Database: 207 - Release Date: 20/06/2002 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
URL for detailed description of SQL left/right inner/outer join concepts?
Is there a good URL that explains in detail exactly the concepts of SQL left/right inner/outer join? I've found several that give very high-level hints, but nothing that really summarizes exactly what these do. -- === David M. Karr ; Java/J2EE/XML/Unix/C++ [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: URL for detailed description of SQL left/right inner/outer join concepts?
Books on Line for Microsoft SQL server explain it nicely, and are free whether you use SQL Server or not at http://www.microsoft.com/sql/techinfo/productdoc/2000/default.asp -billb -Original Message- From: David M. Karr [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 3:56 PM To: [EMAIL PROTECTED] Subject: URL for detailed description of SQL left/right inner/outer join concepts? Is there a good URL that explains in detail exactly the concepts of SQL left/right inner/outer join? I've found several that give very high-level hints, but nothing that really summarizes exactly what these do. -- === David M. Karr ; Java/J2EE/XML/Unix/C++ [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: er diagramming
I would think the incremental cost of adding support (both forward and reverse engineering) for databases such as MySQL would be minimal for Computer Associates and other's who provide robust ERD apps like ERWin. Perhaps we haven't been vocal enough with mainstream tool companies aboout the need to support open source dbs. Mike mysql,sql,query - Original Message - From: Bill Bernat [EMAIL PROTECTED] To: MikeParton [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, July 01, 2002 6:46 PM Subject: RE: er diagramming Yeah, found it (per your other message), Dezign for Databases, looks great for what I need to do and although I haven't had a chance to do much with it it seems to work for basic entity relationships. I never seem to use the full $3000++ functionality of Erwin/ER Designer, etc., which don't have MySQL support ... eventually they'll have to add it though. -billb -Original Message- From: MikeParton [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 2:11 PM To: Bill Bernat; [EMAIL PROTECTED] Subject: Re: er diagramming Somewhere within www.mysql.com is a link to a site that has an ERD tool that supports MySQL...think the name is Dezigner or EasyDezign or something like that. Search through the MySQL site and you'll find it. Free trial version (limited entities) and the full tool isn't very expensive. - Original Message - From: Bill Bernat [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 01, 2002 3:25 PM Subject: er diagramming ERwin, in which I did the logical data model for a MySQL database, doesn't support MySQL data types or specific MySQL code export. Do any tools? Notepad and vi look like my best physical design tools at this point, which is okay. But I wanted to be sure I wasn't missing anything out there -- along the lines of ERwin but with MySQL support. Thanks. -billb - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: innodb @ windows xp
You need to determine if your MySQL is reading it's directives from my.ini or my.cnf. In the correct one, make sure you have commented out or removed any line that reads skip-innodb. then make sure you have directories set up for the innodb files and that you've edited the paths to point to these directories. HTH Mike - Original Message - From: Hytham Shehab [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 01, 2002 6:54 PM Subject: innodb @ windows xp hi guys, i have installed mysql v 3.23.44-nt on my XP using *Binary* distribution, how can i now develop an InnoDB tables? thanks very much sql -- Hytham Shehab --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.372 / Virus Database: 207 - Release Date: 20/06/2002 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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_real_query, insert floats as binary
No takers? Any thoughts would be great. -- David A. C. Beck [EMAIL PROTECTED] Valerie Daggett Laboratory Biomolecular Structure and Design Program Department of Medicinal Chemistry University of Washington, Seattle On Thu, 27 Jun 2002, Dave Beck wrote: the question: I am trying to use the C API to insert floating (4 byte) point data into a mysql table. It is very desirable to put the data in as the binary representation and not as a sprintf family converted string (to maintain precision improve performance). My initial attempt is below - perhaps I have misunderstood the usage of mysql_real_query? I should make two notes on the following code: the host and source are the same machine so endianism is (should) not be an issue and I am also trying to insert two integers in the same manner. With the code as it is I get an error in mysql statement. the table description: +---+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-+---+ | frame | int | | MUL | 0 | | | atom | int | | MUL | 0 | | | x | float | | | 0 | | | y | float | | | 0 | | | z | float | | | 0 | | +---+-+--+-+-+---+ the code: char insert_format[] = INSERT INTO %s VALUES (%hhd%hhd%hhd%hhd, %hhd%hhd%hhd%hhd, %hhd%hhd%hhd%hhd, %hhd%hhd%hhd%hhd,%hhd%hhd%hhd%hhd); int build_real_insert(char *query, char *table, int frame, int atom, float x, float y, float z) { unsigned char *fbp = (unsigned char *)frame; unsigned char *abp = (unsigned char *)atom; unsigned char *xbp = (unsigned char *)x; unsigned char *ybp = (unsigned char *)y; unsigned char *zbp = (unsigned char *)z; return sprintf(query, insert_format, table, fbp[0], fbp[1], fbp[2], fbp[3], abp[0], abp[1], abp[2], abp[3], xbp[0], xbp[1], xbp[2], xbp[3], ybp[0], ybp[1], ybp[2], ybp[3], zbp[0], zbp[1], zbp[2], zbp[3]); } in the body: query_len = build_real_insert(query,table_name,frame,i,x[i],y[i],z[i]); if(mysql_real_query(mysql,query,query_len)) { // error handling Many thanks, David -- David A. C. Beck [EMAIL PROTECTED] Valerie Daggett Laboratory Biomolecular Structure and Design Program Department of Medicinal Chemistry University of Washington, Seattle - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Unsigned Int / Signed Int issue when using MyODBC2.5
G'day, I've got a problem with the ODBC driver for MySQL, in that when I use an SQL select statement on a field of type UNSIGNED INTEGER, the resulting recordset in asp uses SIGNED INTEGER data types, so any data 2^31 is dropped by asp. The offending code is as follows: Set sqlCommand = Server.CreateObject(ADODB.Command) sqlCommand.ActiveConnection = MyDatabase sqlCommand.CommandText = SELECT * FROM SQLTable Where DataDate = StartDate and DataDate = EndDate ORDER BY DataDate Set rs = sqlCommand.Execute The database design: mysql describe SQLTable; +--+--+--+-+-+---+ | Field| Type | Null | Key | Default | Extra | +--+--+--+-+-+---+ | DataDate | int(10) unsigned | YES | | NULL| | | DataIn | int(10) unsigned | YES | | NULL| | | DataOut | int(10) unsigned | YES | | NULL| | | Elapsed | int(10) unsigned | YES | | NULL| | +--+--+--+-+-+---+ 4 rows in set (0.00 sec) Unfortunatly, whenever the data in any of the fields exceeds 2,147,483,648 it is dropped from the resulting recordset. ... And just to throw a spanner in the works, that code works perfactly on our development PC, but not on the production server. Does anyone have any idea why this would be failing, or know a better way to select the code and drop it into a recordset (or array) in asp? Thanks for any help. Will Lotto Systems Administrator - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 query for next unique ID
Does anybody know if there is a function to retrieve the next unique ID number for a record to be made in the future? I believe you can reliably allocate sequence numbers from a sequence table (a table used only to dole out sequence numbers) like this: create table sequence ( seq int not null auto_increment primary key); (depending on intended use, you may need to change the size of the integer type, or use an unsigned type). When you wish to get a sequence number, issue these three queries: #1: insert into sequence values (null); #2: select last_insert_id(); Fetch the single-row result from this and put it in variable $s, which gets substituted into the following query before sending it: #3: delete from sequence where seq = $s; Now use $s as your sequence number to insert into another table. Note that this still works if several clients try this sequence of queries on different connections, WITHOUT transactions and WITHOUT any explicit locking between the queries, but with arbitrary interleaving between queries by different clients. Query #1 establishes the sequence number (implicit locking during that query prevents handing out duplicate numbers). Query #2 fetches it, and since last_insert_id() is connection-specific, nothing another connection does will affect the result. Query #3 cleans up the sequence table. Since only one client was handed the sequence number for this row, only one client will try to delete it. Normally the table will only have entries for clients executing between query #1 and query #3, or clients that bombed between query #1 and query #3 (thus, during a lull in activity, the steady state of the sequence table should be empty). Gordon L. Burditt - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
file upload ..... ????
hi everyone function calls is workin fine now thnx a million :( a new problem im trying to upload a file from client and i want it to be stored in mysql db table type myisam is that possible right now my code only copies the file on the disk simple text but i want it in my data base and then : its going to be in unicode so how do i get about it id really appriciate any help with this plz if there is some meterial on this do direct me to it thnx a million toby . _ 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
Load data infile problem
I am trying to import a text file that is tab delimited. I am using the following , but it only returns one line. LOAD DATA INFILE '/Users/martinsc/documents/jillslist.txt' INTO TABLE Customers FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n'; Why would it do one line and then stop? MySQL indicates one line affected. The database is not empty and at first I suspected that the import stopped due to the same Customer_ID but that is not the case as the ID's for the first records do not exist in the database as they were deleted records. Thank you Martin -- Failure is an editorial judgement imposed by others - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php