need mysql version newer than 3.23.38 for dec osf4.0
Hallo, I am new on this maillist. I need for my Dec-Server with OSF4.0 a newer version (binary) of mysql than 3.23.38 Where can I get such version. With source-code of Version 3.23.44 I have problems Mit frdl. Gruss Klaus Kunze === Dr. Klaus Kunze Tel. 97 33324 (0341) Rechenzentrum __o Universitaet Leipzig _`\,_ Augustusplatz 10/11 (+)/ (+) 04109 Leipzig e-mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: New fork of MySQL
Hmm, this has certainly been an interesting discussion. I personally think that forking the code accomplishes nothing at all. What's so tough about making a patch to 3.23 and sending it to the MySQL developers? I also doubt that anyone working on the new fork will be able to convince thousands of web hosts to replace MySQL with 'WSSQL', particularly if they start changing standard MySQL behavior and breaking existing applications. However, if Shelby manages to speed up MySQL by coding assembly for every platform MySQL runs on, than I for one will be impressed ; ) In fact, I already emailed the developers yesterday, and asked if I could pay to have the particular feature I wanted prioritized at this time. Strange how open source developers don't always answer to the almighty dollar, eh? In general though, I think it sort of like Windows. Every new release is a major cost to the installed base to upgrade. Many people here may not think twice about the cost of upgrading to 4.x, because many people here may enjoy the technology. But in business, we don't like change. We like the same thing to work the same way over and over again. The more repetitions we can get, then the higher the economy of scale and thus the higher the profit (and I lot more time for me to spend with my family). Oddly enough, the 4.0 releases won't change MySQL's behavior, unless of course you are utilizing the new features. Your changes DO affect its behavior, and may introduce new bugs into previously stable and well-tested code. Also, I'm not sure what the 'costs' of upgrading to version 4.0 might be. The 'cost' of new features? Or maybe a few extra megs of disk space? So my focus is more on taking what I already thought was wonderful (3.23) and focusing on making it perfect for the needs of what most people do with a database and a typical web site. And being able to that with less noise and more directness. I tend to think no one here will be interested in that kind of focus, because he sort of flies in the face of the granduer. I am not sure what this is supposed to mean, but I think that MySQL is a great example of a focused open-source project. It has clearly stated goals (speed, ease of use), and while new versions may add new features, they don't slow the database down or make it more difficult to use. OFF TOP MY HEAD: But I am keeping in mind that the people on this list are developers and knowledgeable users (or at least the ones paying attention to this topic). I think this is quite different from the needs that actual users might express. I think a lot of potential users want a database on their web site, and haven't the slightest clue how to achieve it. I could close that gab with my Cool Page product (have been planning something like this for a while, e.g. drag+drop forms and database integration). And I would like to have access to a database that wasn't trying to compete with Oracle, because I just don't feel those features will do anything for this market I see. And it just adds complexity. Adding subselects to MySQL is a feature that many, many people have requested; most of the other items on the to do list have been discussed extensively here as well. I haven't searched the list archives, but I've been subscribed to this list for a long time, and I can't recall even one other person requesting that the DEFAULT behavior be modified. Ben - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 mysql version newer than 3.23.38 for dec osf4.0
hi, found this on german mysql mirror ftp://ftp.kernelnotes.de/mysql.com/Downloads/MySQL-3.23/mysql-3.23.44-dec-osf5.1-alphaev6.tar.gz (6320kb). don't know if there might be problems with osf5.1 vs osf4. hope this helps, michael Klaus Kunze wrote: Hallo, I am new on this maillist. I need for my Dec-Server with OSF4.0 a newer version (binary) of mysql than 3.23.38 Where can I get such version. With source-code of Version 3.23.44 I have problems Mit frdl. Gruss Klaus Kunze === Dr. Klaus Kunze Tel. 97 33324 (0341) Rechenzentrum __o Universitaet Leipzig _`\,_ Augustusplatz 10/11 (+)/ (+) 04109 Leipzig e-mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 4.0 updated?
Hi, I think MySQL 4.0.0 is in it's alpha state. Wouldn't it be more right to get a 4.0.0 beta and several release candidates than a 4.0.1 version? Best regards Bernhard - Original Message - From: Mike Wexler [EMAIL PROTECTED] To: Mark Maunder [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, November 09, 2001 1:13 AM Subject: Re: MySQL 4.0 updated? When a new version is available it will have a new version number. The current version is 4.0.0 but there will almost certainly be a 4.0.1 soon. If you look at the change history in the documentation, there have already been changes put into 4.0.0. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 127.0.0.1 problem
Alex writes: Are there any obvious reasons why mysql -h localhost works and mysql -h 127.0.0.1 does not. Maybe not obvious, but a good reason nonetheless: The string 'localhost' has a special meaning to mysql: Connect locally using some platform-dependent means of IPC, such as unix sockets. It's special to the clients, but also to the privilege system. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Beginner question - getting last inserted ID
Hello! I am working on my first MySQL client. I have a number of tables, each containing a AUTO_INCREMENT PRIMARY KEY column. The client is built in Java and using a JDBC-bridge to connect to the database. When I do an insert in one of these tables the primary key column gets a new ID. How do I get this ID? I guess I cannot use SELECT MAX(id) FROM Table since old, deleted id's are reused for new rows. Please, help me! Regards, Anna - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 updated?
I think MySQL 4.0.0 is in it's alpha state. Wouldn't it be more right to get a 4.0.0 beta and several release candidates than a 4.0.1 version? 4.0 is in its alpha state. 4.0.0 is the first alpha release, and 4.0.1 the second and so on. It is, IMO, essential to give every release its own identifier, so that when a bug is reported you can say that was fixed in 4.0.2 rather than that was fixed in last thursdays release. However many fields you have in your version number, the last must change for every individual release, be it alpha, beta or full. Release numbers don't cost money, so we can be prodigal with them if it aids clarity. Alec Cawley - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Replicating from 3.23.42 to 4.0 - problem
Can I replicate a 3.23.42 database to a 4.0.0 server? I have not seen mentioned any place that you can not so I tried.. The error log on the slave say; 011108 15:54:17 Slave: connected to master 'user@master:32354', replication started in log 'FIRST' at position 4 011108 15:54:17 Could not parse log event entry, check the master for binlog corruption This may also be a network problem, or just a bug in the master or slave code. 011108 15:54:17 Error running query, slave aborted. Fix the problem, and re-start the slave thread with mysqladmin start-slave. We stopped at log 'FIRST' position 4 011108 15:54:17 Slave thread exiting, replication stopped in log 'FIRST' at position 4 I have tried SQL_SLAVE_SKIP_COUNTER=2; SLAVE START; as suggested in the manual, but without luck. I have also tried taking a new snapshot. BTW, the master is also replicated to another slave running 3.23.42. This works fine, so the master seems OK. All three servers are running on Slackware Linux 8. Regards, Arne K. Haaje - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SqlBuilder (Constructor) now support MySql
Ver 0.7 News 07/11/2001 http://www.geocities.com/b_asi2000/index.htm In addtion to BDE, direct Oracle, FlashFiler connectivity, now also support Add ADO support Add DAO support Add ODBC support Add direct DBISAM ver 2.x access (Local) Add direct DBISAM ver 3.x access (Client Server) Add direct MySql access Add direct Interbase access. Batch Test test series of queries with one click this option is a great tool to check index influence (add / remove) Improve: Expand the hint help text Its is highly recommended to scan SqlConstructor with the hint, you may turn the hint of from the main menu. Support FlashFiler 2.05 Drop a few tables at the same time to the visual query builder. Run SqlConstructor many times (More then one instance) Sql aliases are shown on the Popup Menu Query Editor Query Dataset Result is now automatically display on DBGrid , you may view the entire dataset on Grid (not data aware control) by choose this option from the submenu. Sort Columns on the Grid is according to the field type. Fields in the query builder tool is sort by alphabetic orders. Add more powerful file and directory picker. On the dataset Grid it is possible to search syntax. No need to send e-mail. Row may be mark by click on the first fixed column in the Grid. I would like to thank all users who provided feedback and helped me to steer the development of SqlConstructor . I look forward to your continued suggestions for all future development. If you use any other database the does not support by sqlConstructor , please let me know ASAP.(mail to Asi) http://www.geocities.com/b_asi2000/index.htm Best Regards Asi [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: C API mysql_query() malfunctioning (long)
I know KR (section 4.9, 2nd ed.) says char s[] = ...; is equivalent to char s[] = { . . . , '\0'} but I always explicitely attach the \0 just to be sure i.e. char s[] = ...\0; /* mysql, database (cheating the filter, human reader ignore) */ -- , M A R I O data miner, LIACC, room 221 tel 351+226078830, ext 121 A M A D O Rua Campo Alegre, 823 fax 351+226003654 A L V E S P-4150 PORTO, Portugalmob 351+939354002 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: OT: Default forced on MySQL;
On Friday 09 Nov 2001 03:36, DownloadFAST.com wrote: Mr. Bobic, [snip] The only thing that matters is that every time you respond on the list, you are only making a fool of yourself in the eyes of the many people who are lurking. They can see right thru your motives in sending this post below. LOL. So much for no personal attacks that you called for. At least you're being consistent, I suppose. As for growing up, the things that one tends to learn when they grow up is that life is about being reasonable and about compromise. Taking on the entire MySQL (or any established open source development effort) with the I want this feature, and I want it now, because I _know_ it must be simple to implement even though I haven't exactly looked at what is involved attitude isn't necessarily a compromising nor reasonable thing to do, in terms of time or effort. Considering the features you want (IIRC you only mentioned the default values in tables) - why don't you try PostgreSQL instead? I have said it before and I'll say it again - use the product that works best for YOUR particular application. There are at least 5 free open source SQL DBMSes (MySQL, PostgreSQL, SAP, Interbase, MiniSQL). Before you hopelessly start trying to make one into another, you may find that a more rewarding exercise in terms of your time is to just use the one that is better geared toward your target application. That would at least show that you have studied the problems in your application and done the relevant homework. Complacency, resistance to learning, just wanting a quick patch and the I'm OK, you are not OK attitude don't do much for the display of how serious you are being (or trying to be). The gauntlet has been thrown by you, and the response was your invitation to join the development effort (see Arjen's post on the list). The whole point of open source development is that if you don't like what something is like, you can just go and do it better. It's the ultimate put-up or shut-up competitive environment. You lead, you follow, or you get out of the way. To lead, you need followers that believe you are fit to do so. To follow, you need to find a leader you approve of and that approves of you. Getting out of the way is the easiest, but also the least rewarding action to take. Humble regards. Gordan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: New fork of MySQL
What's so tough about making a patch to 3.23 and sending it to the MySQL developers? 3.23 will not the most current cvs soon I assume. Or does MySQL actively support, debug, fix, and go back and maintain older releases? I also doubt that anyone working on the new fork will be able to convince thousands of web hosts to replace MySQL with 'WSSQL', Well I could own a growing host as well. For now, I gave all my users to let someone else run it: http://coolpagehosting.com I think there are several thousand users already and hasn't be up long. But the number of servers running MySQL is very small compared to the number of web sites. So the race is wide open still. If someone else were to present a better option to the millions of users, this could transform into popularity on the backend. To keep from getting too angry at me, think of these things in the context of the alternative. Microsoft .Net is coming. Take a look at the new toolbar in Hotmail, just to get an idea of how Microsoft is going to convert their 97% market share on the desktop and browser, into same on the backend. particularly if they start changing standard MySQL behavior and breaking existing applications. Ditto the above points. However, if Shelby manages to speed up MySQL by coding assembly for every platform MySQL runs on, than I for one will be impressed ; ) No comment. In fact, I already emailed the developers yesterday, and asked if I could pay to have the particular feature I wanted prioritized at this time. Strange how open source developers don't always answer to the almighty dollar, eh? I asked kindly that you not turn this into a personal attack on me. Can I please ask you to stop I am showing you respect by not responding on this point, other than to say please don't go there. Oddly enough, the 4.0 releases won't change MySQL's behavior, unless of course you are utilizing the new features. The mysql.com announcement about 4.0 disagrees with your assertion. Your changes DO affect its behavior, What changes? I did not make any yet. Are you dragging information from my other thread into this one? and may introduce new bugs into previously stable and well-tested code. Any changes by any one can do this. What is your point? Also, I'm not sure what the 'costs' of upgrading to version 4.0 might be. The 'cost' of new features? Or maybe a few extra megs of disk space? Time? Hassle? Compile issues? Etc. I am not sure what this is supposed to mean, but I think that MySQL is a great example of a focused open-source project. It has clearly stated goals (speed, ease of use), and while new versions may add new features, they don't slow the database down or make it more difficult to use. I agree. That doesn't mean though that the improvements schedule is meeting the needs of everyone who is already a user. Some users may have different priorities. Please respect our right to state our opinion and have discussions to determine whether there is enough reason to fork or not. It is a discovery process. I for one, do not have a closed-mind about it. Adding subselects to MySQL is a feature that many, many people have requested; How many? And how many users of MySQL are there? And how many of MySQL could there potentially be? These are very different numbers and very important distinctions. But I don't want to have this debate with you. If you aren't interested in this project, then kindly stay off this thread, or at least kindly do not take personal stabs at me. most of the other items on the to do list have been discussed extensively here as well. I will grant you that I was not here on this list when those discussions occurred. I haven't searched the list archives, but I've been subscribed to this list for a long time, and I can't recall even one other person requesting that the DEFAULT behavior be modified. That is my pet issue perhaps. Obviously one would not fork over one small issue like that. You are dragging the other thread into this one. I am thinking of a much wider issue, which is how can I be sure that my investment in and use of MySQL will not be overcome by other forces which desire that it be something very different. When I first authorized the use of MySQL, I was told that is was focused on simplicity, speed, and every improving SQL compliance (i.e. that the little thorns would not be ignored forever). You may very well be correct, that it is alarmist to assume that the little SQL mistakes won't be fixed fully soon. And that other little issues that keep a product from being perfect at the fundamental level, won't be ignored. You may be right about that. Then again, you may not be. But I have investment to worry about. For others who have investment to worry about, they may look at 4.0 and ask themselves what they are getting, and whether they feel secure about the improvement that has been
Re: Beginner question - getting last inserted ID
Anna Åhnberg writes: When I do an insert in one of these tables the primary key column gets a new ID. How do I get this ID? I guess I cannot use SELECT MAX(id) FROM Table since old, deleted id's are reused for new rows. Please, help me! I shall help you help yourself, for from that you will benefit in the long run, as will I. The manual has all the necessary information: http://www.mysql.com/doc/C/R/CREATE_TABLE.html http://www.mysql.com/doc/e/x/example-AUTO_INCREMENT.html The unofficial FAQ has a chapter on AUTO_INCREMENT: http://www.bitbybit.dk/mysqlfaq/faq.html#ch6_0_0 What you're looking for is probably LAST_INSERT_ID(), but I'll let you find it yourself. Oops, now I told you. :-P //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Transactions
Can anyone help? I'm trying to implement a transaction (using InnoDB tables ) in which everything done in it can be rolled back at any stage. There are several operations involved and I need to be able to undo all the work done so far at any point. In my code below, I've deliberately set the variable I use to check whether to go on with the transaction so that everything should get rolled back. However, only the last operation ( an INSERT ) gets rolled back. Please, is that MySQL's default behaviour or am I doing something wrong? ? include(transactions.inc); function PlaceOrder($MerchantName,$WalletID,$CartContents) { if(is_array($CartContents) sizeof($CartContents)0){ ConnectDBServer(); $DBName=MerchantDB($MerchantName); $i=1; $SQLQuery= SELECT id,name,description,price FROM products WHERE id IN(; foreach($CartContents as $CartItem){ if(is_array($CartItem)){ if($i!=1) $SQLQuery.=,; $SQLQuery.=$CartItem[pid]; $i++; } } $SQLQuery.=); //print $SQLQuery.br; //exit; if($i0){ $Products=array(); $result=mysql_db_query($DBName,$SQLQuery); while($row=mysql_fetch_array($result)){ $Products[$row[id]]=array(name=$row[name], description=$row[description], price=$row[price]); } mysql_free_result($result); } else return 'Items in cart are not recognizable!'; // Calculate cost of items in shopping cart $TotalCost=0; foreach($CartContents as $CartItem){ $price=$Products[$CartItem[pid]][price]; $qty=(int) $CartItem[qty]; $TotalCost+=$price*$qty; } /* // Get current value in Wallet $SQLQuery=SELECT value FROM wallets WHERE id=$WalletID; // LOCK IN SHARE MODE //print $SQLQuery.br; //exit; $result=mysql_db_query(paymentsystem,$SQLQuery); $CurrentValue=mysql_result($result,0); mysql_free_result($result); if($TotalCost=$CurrentValue){ */ $SQLQuery=SELECT id FROM merchants WHERE name='$MerchantName'; $result=mysql_db_query(paymentsystem,$SQLQuery); $MerchantID=mysql_result($result,0,id); mysql_free_result($result); mysql_select_db($DBName); // - TRANSACTION STARTS HERE --- mysql_query(set autocommit=0); // function I embedded the payment in before //$PaymentID=PaymentTransaction($WalletID,$MerchantID,$TotalCost); // code I used to replace the function call $Amount=$TotalCost; @mysql_select_db(paymentsystem); if(is_Wallet($WalletID)){ if(is_Merchant($MerchantID)){ if(is_numeric($Amount)){ //mysql_query(set autocommit=0); // from,to and amount are valid $SQLQuery= UPDATE wallets SET value=value-$Amount WHERE id=$WalletID AND value=$Amount; $DebitSucceeded=@mysql_query($SQLQuery); if($DebitSucceeded){ $SQLQuery= INSERT INTO payments(value,paymentdate,merchantid,walletid) VALUES($Amount,NOW(),$MerchantID,$WalletID); $RecordSucceeded=@mysql_query($SQLQuery); $PaymentID=@mysql_insert_id(); if($RecordSucceeded) mysql_query(COMMIT); else mysql_query(ROLLBACK); } else mysql_query(ROLLBACK); } } } // --- code to replace function call ends $PaymentID){ $SQLQuery=INSERT INTO orders(walletid,paymentid,dateplaced) VALUES($WalletID,$PaymentID,CURDATE()); $ParentDone=@mysql_db_query($DBName,$SQLQuery); // deliberate assignment to test how ROLLBACK works
Re: Beginner question - getting last inserted ID
The manual has all the necessary information: http://www.mysql.com/doc/C/R/CREATE_TABLE.html http://www.mysql.com/doc/e/x/example-AUTO_INCREMENT.html The unofficial FAQ has a chapter on AUTO_INCREMENT: http://www.bitbybit.dk/mysqlfaq/faq.html#ch6_0_0 What you're looking for is probably LAST_INSERT_ID(), but I'll let you find it yourself. Oops, now I told you. :-P //C His language might also have a function for it. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: varchar in the foodchain
On Friday 09 November 2001 12:23 am, Steve Meyers wrote: Tables with variable length rows can get ugly if not optimized frequently. We had one which was taking 2.5 sec to do an indexed query, and when we optimized the table it dropped to .2 sec. But as long as you keep your tables optimized, variable length rows can be faster. The main efficiency concern, though, is the size of your indexes. MySQL keeps your indexes in memory, so smaller indexes are better. That is why it is best to use hash values when indexing long character strings (or even fairly short ones). A 32-bit hash value of a 20-character field takes 1/5 the space. That means five times as much key can be in memory at once. Hope that makes sense... Steve Meyers Makes great sense to me, many thanks. I have often seen varchar used (on many DBs), and often wondered if it was just an easy way out. Most of what I am doing are of transactional nature vs. large char storage. For example, email addy, I've made as varchar(40). However, in light of this thread, I'll just make them char(40) and keep my indices int and bigint. The space savings and additional watchdogging for optimization, in my case do not warrant varchar (IMO). Many thanks. :-) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql corruption tables in production environment (Urgent)
Hi, We have several mysql server in production evironment, and most of them when they have millions of rows, they all get MyIsam tables corrupted. One of the servers has ext2 filesystem with scsi harddrives, after the myisamchk -r it repairs the table, but after a few inserts it will corrupt again. the file is not bigger than 2gb. all other servers have software raid5 and xfs filesystems, same situation as above happens, except for one of them that mysql segmentation faults if the /var/lib/mysql (databases dir) is on the raid partition, if we move them into a non-raid partition it will start mysql and function properly except for the corruption issue. We tried differente tests and in all tests, very huge tables get corrupted, all the tests were made with mysql-3.23.43 in redhat with xfs and ext2, and with raid and non raid partitions. All servers are intel pentium 3 based with mem from 512Mb up to 1Gb. I would expect some solutions or quick fixes for now so the tables don't corrupt so often, and would like to know if it is a mysql problem or a third party software, but all leads into a mysql problem. Thanks in advance. Rui Barreiros. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: New fork of MySQL
I will end my involvement in this thread, because I sense there is too much noise coming. If any one with good experience in the MySQL source code base would like to do some well paid, contracting work for me, please do not hesistate to email me privately. Thank you for your consideration of my proposal. We'll see what can be done to add some alternatives. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Still about MySQL Cluster
By using internal MySQL Replication, extra speed could be fetch by sending non-updates (INSERT, DELETE, UPDATE, ...) query to slave server BUT could MySQL engine do it transparently from user application ? If it can't, i suggest to insert this feature to TODO list -- ady -- email: ady at ebdesk.com adiwicaksono at yahoo.com ady at students.if.itb.ac.id homepage: http://ady97.hypermart.net/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: OT: Default forced on MySQL;
On Friday 09 Nov 2001 12:11, DownloadFAST.com wrote: Considering the features you want (IIRC you only mentioned the default values in tables) - why don't you try PostgreSQL instead? My understanding is it is much slower. That is what I am hoping for. Or rather, I am hoping that MySQL proves to be signifficantly faster, as that is the main reason for the migrtion I am testing at the moment. But the more important thing that has been learned here, is to find out what kind of people are in the community. Because one can learn a lot about the future direction and success based on the people who are involved. Indeed. All the MySQL developers who bothered responding to this thread completely stayed out of the somewhat heated discussion that we have recently been having. IMHO, that indicates a great amount of self-control and patience - all of which speak only the best for the MySQL development effort. And what I learned is that some (I don't know what % yet) are very dogmatic, closed-minded, intolerant, rude, unprofessional, and down right blood thirsty. Not the kind of people I would want to contribute to or be a part of. I think you may be (although I am not sure what particular responses have made you form that opinion) mistaking in your identification of the actual developers. As I am quite happy to confess, I am not a developer/contributor to the MySQL project - I just use it. I just wasn't happy with the way you attacked them, for no (IMHO) particularly good reason. This is not specifically related to any particular development effort. So, if you have a disagreement with my opinion, it would be a good idea not to make the mistake of assuming that is how the actual developers/contributors feel as well. I am sure it wasn't necessary for me to point this out, but I don't want my argument with you to be responsible for any sort of grudge against any of the hard working MySQL developers. And I also learned that MySQL has a license which says we can take their great work, and basically resell it and use it to make a profit for ourselves, as long as we give back any source code changes. Indeed - a growing number of companies are trying to do this sort of thing with other GPLed developments. In 3.23 they basically stabilized all the major issues for a typical low-end web database. So really the thing is there for the taking, if one wanted to just focus on a small set of goals. It may not be me, but someone else my have already started on that business opportunity. The problem is - what happnes when/if you start needing extra features that are not easy to just patch in? Personally, I would handle such minor lack of features in a database at the application level. When it comes to default values, I know I could handle that in just about all of my applications by fairly minor modifications to my code. In fact, that may well be what I will have to do to some extent when porting from PostgreSQL to MySQL. If nothing else, it seems like a much easier and quicker fix to the problem (or at least it is when your code is tidy) than insisting that a new feature be implemented, especially if it can be handled at the application level. In the end, I think we have come full circle here. The only way to really protect your investment is to take over all of the software development, and have a definite say in what happens. It just seems a little to excessive to fork off the whole project, when a patch to either MySQL or your application may well be the far less time consuming option... I really did not want to learn the source. I can certainly relate to that. But the alternatives often come to the rescue in that case. I have too many other things to do. But if I have to learn the source to protect my investment, then I might as well do action and not beg people who I do not like. That is a reasonable point, even if it may not be the most efficient (for want of better word) way do handle the problem. A slightly more cooperative attitude would have been much more likely to produce better results with less effort. The best way to erase all this noise and measure who is smarter, is in the competitive arena. Open source arena is both cooperative and competitive - that is why it works. Good luck with your forking efforts. Regards. Gordan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Keeping SQL dbs separated
Hello, I have been asked by a guy to rewrite his web site presently written by somebody else using ASP/NT/IIS/MS Access (by some other webmaster who vanished). I said, yes, I could do it but with PHP/MySQL, because that's what I know, and even more important I only have Linux/Apache at home to test the pages before uploading. The guy passed this request to the hosting company (which he doesn't want to change) and the answer is: if you *really* need to use PHP instead of ASP OK, but as far as MySQL is concerned we only have one customer using it now, and if we gave it to you too, then the two databases would be visible and writeable to each other users.. unless *your* new webmaster programs our MySQL by himself to avoid this problem. Now, leaving apart every comment on the quality of this ISP, what should I do on their server to make it so that I can indeed set my customer's PHP/MySQL pages without screwing anything up? I can usually find my way enough about MySQL, but this situation is entirely new to me. As a matter of fact, until yesterday I would have thought that it is more difficult to set up Mysql like this (or find real people doing it) than the other way around.. TIA, mweb - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Slooow InnoDB problem
Maciek, At 12:20 PM 11/9/01 +0100, you wrote: please show us the CREATE TABLE statements and what EXPLIN SELECT ... says about both table types. CREATE TABLE `stats_InnoDB` ( `id` int(10) unsigned NOT NULL auto_increment, `ident` char(100) NOT NULL default '', `class` int(2) unsigned NOT NULL default '0', `status` int(1) unsigned NOT NULL default '0', `last` int(6) unsigned NOT NULL default '0', `created` int(6) unsigned NOT NULL default '0', `counter` int(3) unsigned NOT NULL default '0', `stat_val_1` int(1) unsigned NOT NULL default '0', `stat_val_2` int(1) unsigned NOT NULL default '0', `stat_val_3` int(1) unsigned NOT NULL default '0', `stat_val_85` int(1) unsigned NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `ident` (`ident`,`class`), KEY `status` (`class`,`status`), KEY `last` (`last`) ) TYPE=InnoDB The MyISAM type table is exactly the same. MyISAM == EXPLAIN SELECT COUNT(*) FROM stats_MyISAM WHERE ( stats_val_20 = '1' ) AND ( stats_val_35 = '1' OR stats_val_37 = '1' OR stats_val_38 = '1' OR stats_val_42 = '1' OR stats_val_43 = '1' OR stats_val_44 = '1' OR stats_val_45 = '1' OR stats_val_47 = '1' OR stats_val_48 = '1' OR stats_val_50 = '1' OR stats_val_51 = '1' OR stats_val_52 = '1' ) AND NOT ( stats_val_51 = '1' ) +--+--+---+--+-+--+-+--- -+ | table| type | possible_keys | key | key_len | ref | rows| Extra | +--+--+---+--+-+--+-+--- -+ | stats_MyISAM | ALL | NULL | NULL |NULL | NULL | 1197337 | where used | +--+--+---+--+-+--+-+--- -+ +--+ | COUNT(*) | +--+ | 316055 | +--+ 1 row in set (31.24 sec) INNODB == EXPLAIN SELECT COUNT(*) FROM stats_InnoDB WHERE ( stats_val_20 = '1' ) AND ( stats_val_35 = '1' OR stats_val_37 = '1' OR stats_val_38 = '1' OR stats_val_42 = '1' OR stats_val_43 = '1' OR stats_val_44 = '1' OR stats_val_45 = '1' OR stats_val_47 = '1' OR stats_val_48 = '1' OR stats_val_50 = '1' OR stats_val_51 = '1' OR stats_val_52 = '1' ) AND NOT ( stats_val_51 = '1' ) +--+--+---+--+-+--+-+--- -+ | table| type | possible_keys | key | key_len | ref | rows| Extra | +--+--+---+--+-+--+-+--- -+ | stats_InnoDB | ALL | NULL | NULL |NULL | NULL | 1197337 | where used | +--+--+---+--+-+--+-+--- -+ +--+ | COUNT(*) | +--+ | 316055 | +--+ 1 row in set (4 min 25.65 sec) What is the CPU usage % given by 'top' when you run the queries? MyISAM type table - the CPU usage grows each time 'top' refreshes (up to 25-30% when the query ends) InnoDB type table - for a short time usage goes up, then falls down to about 10% ok, this may explain it. It is a disk-bound operation. Does the time change if you run the query twice? Have you inserted the rows in the order of the primary key? If yes, then it should be sequential disk read, which runs 3 - 10 MB / s. Strange that it takes so long: 246 seconds to read a table of 786 MB. Could there be some other disk i/o present at the same time? Swapping of virtual memory? Does it run faster if you make InnoDB buffer pool smaller, say set it to 100 MB, or if you set the buffer pool very big, say 800 MB? Since you are running MySQL/InnoDB-3.23.44, you could try running innodb_monitor during the operation. It reports a lot of statistics about file i/o. For example, we see how many OS file reads correspond to how many buffer pool page reads. How big is the table physically in bytes? stats_MyISAM.MYD - 463369419 bytes stats_InnoDB - 786432000 bytes ('Data length' from SHOW TABLE STATUS) More info that can be helpful: 1 * Pentium III Xeon 600Mhz 1GB RAM U2SCSI drives FreeBSD 4.4-STABLE MySQL 3.23.44 Regards, Heikki http://www.innodb.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: OT: Default forced on MySQL;
On Friday 09 Nov 2001 12:08, you wrote: MySQL On Friday 09 Nov 2001 11:37, you wrote: Note on what is going on here... The paragraph below was from a private email I sent to Gordon. And now Gordon just responded to it on the public list. Gordon, I was strongly hinting to you in private that it was time to stop now. Can you please stop?? My apologies for my rude behaviour. It was not my deliberate intention to mis-address the reply. :-( I agree with what you say here - let's stop this thread. Regards. Gordan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
??Sourcing in sections of a database create file
Years ago I worked on an RDBMS that had a feature to allow execution of 'sections' of a command file, avoiding others. I am still ign scanning the docs, but have not found anything similar in MySQL. For example, in a database creation table one could enter (in MySQL format) the following: mysql source master_DB_creation(table_a, table_c, consistency_check); Where the file master_DB_creation file would contain: --- ?section table_a drop table if exists table_a; create table table_a ( fooint not null auto_increment, barchar(12), primary key (foo) ); ?section table_b drop table if exists table_b; create table table_b ( fooint not null auto_increment, namechar(12), ... ... yada ... yada ..yoda... ... phone char(12), primary key (foo) ); ?section table_c drop table if exists table_c; create table table_c ( fooint not null auto_increment, namechar(12), streetchar(24), city char(18), state char(2), zipchar(9), PIN int, primary key (foo, int) ); ?section consistency_check select some context from database to ensure consistency, etc.. --- Does anyone know whether this functionality exists in MySQL? Regards, Tony - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Faking MS Access on MySQL linux box
Hello, I have another question about the situation explained in my other message Keeping SQL DBs separated. If it's not possible reconfigure SQL on the ISP server, then I will have to test on Linux/Apache some PHP/MySQL pages that will have to access via ODBC a MS Access database on an NT/IIS/PHP server. I would like to do it by writing PHP pages that access via ODBC some mysql or other database on my linux box, in such a way that, if it works there, I change some general setting, upload the pages and they work for sure on the MS Access thing (something like: ifdef LINUX then ODBC_ACCESSES_MYSQL ifdef NTthen ODBC_ACCESSES_MS_Access) I am sure that this must be possible, but would really appreciate some examples/pointers to specific tutorial/similar stories/etc. TIA, mweb - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Getting alll Tables from all Databases/catalogs
Hi, I am developing a application by using MySql database server. I have requierment in my application, that i need to know/show all the tables available in all the databases/catalogs of MySql. By using show tables from test i can get tables from test database. But I need to know all the tables from all the databases in a single shot/query. Please give me solution. Thanks Regards, Omkaram Sangem iNuCom (India) Ltd Secunderabad:53 Phones:+91-40-7893817/7812959 Fax:+91-40-7809071 Email: [EMAIL PROTECTED] www.inucom.com Quality is Everything - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
permissions for updating from one machine to another
I'm trying to set up a script for updating the tables on our production machine with work done on the test machine. The user that will be running the script, has SELECT privileges on the source database. What privileges does the user need for the target database? Can I get by with DELETE,INSERT? What would be a reasonable way to approach this? ari -- Ari Davidow Applications Administrator, Web Central Tufts University 617-627-4291 [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: Keeping SQL dbs separated
The guy passed this request to the hosting company (which he doesn't want to change) and the answer is: if you *really* need to use PHP instead of ASP OK, but as far as MySQL is concerned we only have one customer using it now, and if we gave it to you too, then the two databases would be visible and writeable to each other users.. unless *your* new webmaster programs our MySQL by himself to avoid this problem. That is one of the problem with most Virtual Hosting. The web server user is the often same for all users so you can use a scripting language to look at the files of other people's website. I'm talking about Unix/Apache server because it is what I know, but you can extrapolate to NT. For a script to access a database, it needs to write the connection on the files, and any other virtual user will therefore be able to see those files using php or asp. So any other user can read all access codes and duplicate them temselves. Which means having the same access to the database the other user has. You will also be able to write scripts to remove/add/modify any files that have the web server's permission. Worst, if your host gives a similar access code to your DB and FTP (which is often the case), you will be able to know your ftp user and pass. I must stress that this is not a MySQL issue, it is valid with any other database. I do work for various customers on various hosting systems and I must say that security within virtual hosting company is horrific between sites, regardless of OS. From their comment it seems their server is insecure although Microsoft has blinded them in a sense of false security and warned them about Open Source. The first thing you shoudl do is ask them how could you see the other person's db if you have different privileges. If they are able to answer this question and it makes sense; ask them why it isn't an issue on their MS server. I doubt they will answer well to those questions and you will have a extremelly valid point to request your customer to change provider: Security! regardless of the DB and script used. Now, leaving apart every comment on the quality of this ISP, what should I do on their server to make it so that I can indeed set my customer's PHP/MySQL pages without screwing anything up? I can usually find my way enough about MySQL, but this situation is entirely new to me. As a matter of fact, until yesterday I would have thought that it is more difficult to set up Mysql like this (or find real people doing it) than the other way around.. TIA, mweb - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: 127.0.0.1 problem
I would check the grant tables to see if host 127.0.0.1 has permission to access the DB. Even though they are the same thing, I don't know if mysqld treats them as the same thing. Eugene At 03:15 AM 11/09/2001 -0800, you wrote: Hello, Are there any obvious reasons why mysql -h localhost works and mysql -h 127.0.0.1 does not. It says : ERROR 2003: Can't connect to MySQL server on '127.0.0.1' (110) /etc/hosts contain : 127.0.0.1 localhost as a first line. -- To put my contact info into your Palm device, click here: http://signature.coola.com/?[EMAIL PROTECTED] Personal Signature Coolet - Eugene Mah, M.Sc., DABR [EMAIL PROTECTED] Medical Physicist/Misplaced Canuck[EMAIL PROTECTED] Department of Radiology For I am a Bear of Very Little Medical University of South Carolina Brain, and long words Bother Charleston, South Carolina me. Winnie the Pooh http://home.netcom.com/~eugenem/ PGP KeyID = 0x1F9779FD, 0x319393F4 PGP keys available on request ICQ 3113529 O- - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: New fork of MySQL
In fact, I already emailed the developers yesterday, and asked if I could pay to have the particular feature I wanted prioritized at this time. Strange how open source developers don't always answer to the almighty dollar, eh? I asked kindly that you not turn this into a personal attack on me. Can I please ask you to stop I am showing you respect by not responding on this point, other than to say please don't go there. Maybe you misinterpreted what he said -- I didn't read that as a personal attack. I think he was commenting on the MySQL developers, not you. Adding subselects to MySQL is a feature that many, many people have requested; How many? And how many users of MySQL are there? And how many of MySQL could there potentially be? Some of the most common newie questions on this list have to do with subselects -- even Access has subselects :) I haven't searched the list archives, but I've been subscribed to this list for a long time, and I can't recall even one other person requesting that the DEFAULT behavior be modified. That is my pet issue perhaps. Obviously one would not fork over one small issue like that. You are dragging the other thread into this one. I am thinking of a much wider issue, which is how can I be sure that my investment in and use of MySQL will not be overcome by other forces which desire that it be something very different. When I first authorized the use of MySQL, I was told that is was focused on simplicity, speed, and every improving SQL compliance (i.e. that the little thorns would not be ignored forever). Some of the biggest complaints about MySQL's SQL non-compliance have to do with subselects and referential integrity. You may very well be correct, that it is alarmist to assume that the little SQL mistakes won't be fixed fully soon. And that other little issues that keep a product from being perfect at the fundamental level, won't be ignored. You may be right about that. Then again, you may not be. But I have investment to worry about. For others who have investment to worry about, they may look at 4.0 and ask themselves what they are getting, and whether they feel secure about the improvement that has been made since the last major milestone. For me, I would have rather seen many issues towards further stability and correctness, versus launching into other huge markets (embedded and high-end servers). It is not like MySQL's market was any where near saturated before 4.0. In fact, one of the rules in business is if something is working then continue doing that thing. Don't break it. And take incremental steps away from current success. There is no way you launch into new markets without having growing pains. If you look at the historical record, you will see that MySQL kept on developing 3.22 until (and even a little beyond) when 3.23 was declared stable. Nobody pretends that 4.0 is stable yet, so I would imagine that active development will continue on 3.23 for some time. I'm sure the MySQL developers would appreciate your help in maintaining the current, stable 3.23 branch. I understand your concerns -- the company I used to work for took a long time to finally convert from 3.22 to 3.23. In fact, there are people on this mailing list still using 3.22. Perhaps you could contribute to the main 3.23 branch until 4.0 becomes stable, and then perhaps make a deal with MySQL to continue the active development on that branch for them. There are a lot of MySQL 3.23 users, and I would just like to see them all benefit from both your changes and the MySQL developers changes. Forking the code just makes that more difficult, as then a choice must be made as to which benefits you'd like to have. Anyway, as it's GPL'ed, you can pretty much do whatever you want, and my opinion is just one opinion among many, I'm sure! Good luck with whatever you do, but one way or another I hope we can all share the benefits of your changes. If you do fork, perhaps it would be appropriate to post announcements of new versions on this list? Steve Meyers - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to Create Tables ... and Clients using winmysqladmin
Hi, I am just install the mysql database and i start the system at dos prompt winmysqladmin i got the test tables with permissions and i have created my own database but iam unable to create table for that how can i create table and also i want create clients for my server and set the permission i tryed the artonic administrator but i can't understand how to create clients ,could tell me how to create tables and also there is an error some when i am starting mysqld-max-nt --standalone --console at prompt saying InnoDB is error with my.cnf showing different size Please send details to [EMAIL PROTECTED] regarding how to create tables and clients and how to work the clients with server using TCP/IP of windows Also please mention the ODBC connection string for connecting the ASP to mysql database not with respect to MyOLEDB connection Thanks R. Srinivas esimplest - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Connection timeout and pooling
IDE : JBuilder 4 prof I am using pooling in order to optimize database access. When everybody leaves the office for the weekend all my connection timeout. This is expected except I would like my connection pool to be able to test connections before passing them back to the requester. Whats the best way to do this? Cant say I like sending a (context dependent) query to the database because it makes my class not re-usable across applications. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
host.frm
Hello, I have to move a database from host with mysql 3.22.27 to a new host with mysql 3.23.36. After the install of mysql-3.23.36, I transfered the datadir that is running with the 3.23.36 on the new system and I restart mysqld. But the mysqld failed with error : root@reserv4:/var/lib/mysql# /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking --default-table-type=isam Can't initialize Innobase as 'innobase_data_file_path' is not set 011109 15:27:07 /usr/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 011109 15:27:07 /usr/sbin/mysqld: Normal shutdown I don't understant because I see the file host.frm if I list it : root@reserv4:/var/lib/mysql# ls -l ./mysql/host.frm -rw-rw1 root root 8958 Apr 26 2000 ./mysql/host.frm Could you help me ? Thanks, Dominique. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connection timeout and pooling
if you intend to use mysql you could send down for instance select 1 to the database.. but this is not database independent since not all databases might be albe to handle this type of query but it is application independent when using mysql. if you plan to use an other database some other form of sql query might be needed and now it might also be application dependant.. the other way to do it is to assume that after a while a connection will die and create a new connection every timeyou make an query to the database you store the timefor the connection (last used time) and every time you get a connection from the pool the time is checked against a timeout, if the current time - last used time is larger then the timeout, close the connection and make a new connection since I can find no standard keep alive system in jdbc (I'm using java) or sql/database I myself had to go for this last sollution.. hope it helps! /Christian Andersson - Original Message - From: Sylvain Hamel [EMAIL PROTECTED] To: MySQL Mailing list [EMAIL PROTECTED] Sent: Friday, November 09, 2001 3:50 PM Subject: Connection timeout and pooling IDE : JBuilder 4 prof I am using pooling in order to optimize database access. When everybody leaves the office for the weekend all my connection timeout. This is expected except I would like my connection pool to be able to test connections before passing them back to the requester. Whats the best way to do this? Cant say I like sending a (context dependent) query to the database because it makes my class not re-usable across applications. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Beginner question - getting last inserted ID
Anna Åhnberg writes: Thanks, I actually already found the chapters but now I also now how to use the function too! Let me quote from the manual: LAST_INSERT_ID([expr]) Returns the last automatically generated value that was inserted into an AUTO_INCREMENT column. mysql select LAST_INSERT_ID(); - 195 Thus you'd follow these steps: 1) INSERT into the table, and leave out the auto column or supply a value of 0 or NULL 2) Verify that the query succeeded 3) SELECT LAST_INSERT_ID() 4) Get the result of the SELECT. On success, the SELECT will return one row with one value in it. That is the number you're interested in knowing. If you were using MySQL's C API there is a function that returns the ID without the need for steps 3-4, but since you are communicating over JDBC I don't think there's a simpler solution available. The query in step 3 is extremely fast, so it doesn't really matter, except that it's a bit more work to make an extra query. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: run-all-tests always fails under reiserfs partition
Glad to here it. I hadn't tried it myself, but I heard that it helped under some circumstances. You'll take a small performance hit for the case where you're dealing with lots of small files I've heard. I haven't tried XFS. I Just installed RH7.2 on a box last weekend using the ext3 filesystem. This is the same box that had big problems with reiserfs. So far, everything looks fine, but I haven't stressed it to much yet. Eric Hi~: I do use a via chipset mother board. Today I tried the option notail, it really works!!! Thanks :) Julian PS: Do you have any idea about sgi's xfs? gratuitous keywordssql query table\gratuitous keywords - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Beginner question - getting last inserted ID
If you are using the Mark Matthews JDBC driver (MM.MySQL), there's another way to get the last insert id: instead of using a generic Statement object to execute the INSERT command, use an org.gjt.mm.mysql.Statement object. After executing an INSERT, the method getLastInsertID() will return the value of LAST_INSERT_ID. This value is sent to the client along with other status info after the INSERT command is executed, so the method does not require another call to the server. --Greg Johnson -Original Message- From: Carl Troein [mailto:[EMAIL PROTECTED]] Sent: Friday, November 09, 2001 10:41 AM To: [EMAIL PROTECTED] Subject:Re: Beginner question - getting last inserted ID Anna Åhnberg writes: Thanks, I actually already found the chapters but now I also now how to use the function too! Let me quote from the manual: LAST_INSERT_ID([expr]) Returns the last automatically generated value that was inserted into an AUTO_INCREMENT column. mysql select LAST_INSERT_ID(); - 195 Thus you'd follow these steps: 1) INSERT into the table, and leave out the auto column or supply a value of 0 or NULL 2) Verify that the query succeeded 3) SELECT LAST_INSERT_ID() 4) Get the result of the SELECT. On success, the SELECT will return one row with one value in it. That is the number you're interested in knowing. If you were using MySQL's C API there is a function that returns the ID without the need for steps 3-4, but since you are communicating over JDBC I don't think there's a simpler solution available. The query in step 3 is extremely fast, so it doesn't really matter, except that it's a bit more work to make an extra query. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MYSQL/ASP empty recordset - why
I have a strange problem, when I run the following SQL query: SELECT surname, Count(forename) FROM names GROUP BY surname; If I run this in a mysql DOS box I get a correct result showing the surnames and the appropriate number of people with that surname. If I run this same query through ASP, either MS or ChiliAsp! I get an empty recordset. I do not believe the ASP is at fault as the query works perfectly when I connect to an MS Access database. MySql version is 3.23.38 If anyone has any ideas why this is happening, or how I can work around it then please could you let me know. Regards, John Harman Infotex (UK) Limited www.infotex.co.uk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Offtopic JDBC
Hi I run mySQl on a Win98 machine,and cant get a connection. My sql runs fine, but I can´t connect to the database. I use the path jdbc:mysql//localhost:3360/...and so on. On win2k everything worked fine. Please give an advice! Othmar -- GMX - Die Kommunikationsplattform im Internet. http://www.gmx.net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ALTER Syntax Question
Is it legal to change a field name to the same name as in the following? ALTER TABLE t1 CHANGE a a INTEGER; Thanks, Brad This e-mail and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to whom they are addressed. This communication may contain material protected by legal privileges or statutory protections. If you are not the intended recipient or the individual responsible for delivering the e-mail to the intended recipient, please be advised that you have received this e-mail in error and that any use, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately notify us and delete the original message. Upon request, we will reimburse you for reasonable costs incurred in notifying us. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Table corruption 4.0
I am sending this mail in order to get things straight about table corruption which I am experiencing with 4.0(as well as previous versions). 1)System specs: PIII x1000MHz, 1GB RAM, HD 37GB SCSI, AHA29160N SCSI controller 2) Database MyISam tables, BUT 21000 tables in the database(this is for performance reasons. I need for each such table to run a number of queries and in this way I already have 'VIEWS', except they are permament). I could split that in 4 different databases if it is a problem. 3) I import the data from mysqldumps(that is, the program that reads the data does not directly import them in the database, partly because of the corruption problems, but also partly because I want backups anyway and instead produces files that are importable just like mysqldumps. These files are of the form 'INSERT INTO TABLE1 (.);' conceivably for all 21000 tables. 4) Corruption is a tossup. The import always works. However, when I run the queries sometimes they all run fine, while other times I get an error 127 on the table it is working on. myisamchk NEVER manages a complete recovery of all records(typically 25% of the records). This makes it hard to tell for sure if this has anythingto do with the size of data imported, since the more files I import the larger the probability of having corruption. I have had corruption on a single import too though. 5)Before writing a bug report(the problem may be that this is erratic and even on my PC corruption is not consistent, e.g. I may import a file and get corruption, or I may import another file without corruption) and hence reproducibility may be problematic., I would appreciiate someone setting me straight on the filedescriptor issues(thanks Sinisa thus far): -It is not clear to me if the problem may be that when mysql is importing data, it may be having more files open than it(or the fs-reiser in this case) can handle. Could this be the reason for (table)corruption? -If so, accordingto the manual, there are 2 ways around: either decrease table_cache in /etc/my.cnf (currently 512) which however may also affect performance as I have a lot of tables or increase ulimit/open-files-limit -The question on this first option(table_cache) is: if now I have 2000 open files and reduce the cache to 256 does it mean I will be getting half the open files? -Regarding the more desirable option of increasing the limit, are the two ways equivalent(that is, does open- file-limit call ulimit?) Is changing either of them enough , or-as I assume does one really have to change ulimit? -I have a ulimit -a limit giving a 1024 open file limit while cat /proc/sys/fs/file-nr gives a hard limit of 8192. However, the man page says the system may not allow you to change ulimit I did a ulimit -n 8192 as root then ulimit -a limit says 8192 but when I open a window as a regular user, and do ulimit -a limit it is still 1024. Rebooting comes back with 1024 Is it at all possible to change it? -Also, if I can/have to change open-files-limit, do I need to do it in /etc/my.cnf /usr/bin/mysqld_safe /both? Last, I have a start_Mysql=yes in rc.config but in contrast to other systems used mysql, mysql does not start when the system boots. Any ideas why? Sorry for the many questions. Thanks in advance S.Alexiou - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connection timeout and pooling
Hi, What is your Pooing Utility? Generally, JDBC Connection is TCP/IP's Socket. After the Socket has been disconnected, we can not detect it by JDBC interface. So, we have to detect it before we return a Connection to the client. Please see a source of my util class for Pooling, below. :-) [ Pseudo Code of My Connection Pooling Util Class ] public Connection getConnection() { put out 'Connection' as conn from pool; try { conn.setAutoCommit(false); conn.setAutoCommit(true); } catch(Excepion e) { Oh, it seems that conn has a problem!! discard conn which was putted out; create a new Connection, and return it; } it seems that conn has No Problem!! return conn; } Thanks. Sylvain Hamel wrote: IDE : JBuilder 4 prof I am using pooling in order to optimize database access. When everybody leaves the office for the weekend all my connection timeout. This is expected except I would like my connection pool to be able to test connections before passing them back to the requester. Whats the best way to do this? Cant say I like sending a (context dependent) query to the database because it makes my class not re-usable across applications. -- TAKAHASHI, Tomohiro - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Offtopic JDBC
Hi, 3360? 3306? Please try "jdbc:mysql//localhost:3306/..." ^^ Thanks. Othmar Stehlik wrote: Hi I run mySQl on a Win98 machine,and cant get a connection. My sql runs fine, but I can$B%((Bt connect to the database. I use the path jdbc:mysql//localhost:3360/...and so on. On win2k everything worked fine. Please give an advice! -- TAKAHASHI, Tomohiro - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ALTER Syntax Question
Sure is: http://www.mysql.com/doc/A/L/ALTER_TABLE.html John Barton [EMAIL PROTECTED] http://jbarton.technicalworks.net On Fri, 9 Nov 2001, Brad Harriger wrote: Is it legal to change a field name to the same name as in the following? ALTER TABLE t1 CHANGE a a INTEGER; Thanks, Brad This e-mail and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to whom they are addressed. This communication may contain material protected by legal privileges or statutory protections. If you are not the intended recipient or the individual responsible for delivering the e-mail to the intended recipient, please be advised that you have received this e-mail in error and that any use, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately notify us and delete the original message. Upon request, we will reimburse you for reasonable costs incurred in notifying us. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Beginner question - getting last inserted ID
Anna Åhnberg writes: Thanks, I actually already found the chapters but now I also now how to use the function too! Let me quote from the manual: LAST_INSERT_ID([expr]) Returns the last automatically generated value that was inserted into an AUTO_INCREMENT column. mysql select LAST_INSERT_ID(); - 195 Thus you'd follow these steps: 1) INSERT into the table, and leave out the auto column or supply a value of 0 or NULL 2) Verify that the query succeeded 3) SELECT LAST_INSERT_ID() 4) Get the result of the SELECT. On success, the SELECT will return one row with one value in it. That is the number you're interested in knowing. If you were using MySQL's C API there is a function that returns the ID without the need for steps 3-4, but since you are communicating over JDBC I don't think there's a simpler solution available. The query in step 3 is extremely fast, so it doesn't really matter, except that it's a bit more work to make an extra query. You can access the fast mode from JDBC if you are using the mm.mysql driver: if (stmt instanceof org.gjt.mm.mysql.Statement) // Fast fetch of clipID when using MySQL return (int) ((org.gjt.mm.mysql.Statement) auxStmt).getLastInsertID () ; else // slower, but portable, way of getting clipID { ResultSet rs = stmt.executeQuery (SELECT LAST_INSERT_ID ()) ; rs.next () ; //to first (only) row int res = rs.getInt (1) ; rs.close () ; return res ; } - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Get real mysqld hostname
In the last episode (Nov 08), Mike Broxterman said: I'm looking for a programatic way to obtain the real FQDN of the myqld server, not the one used to connect to the server. Here's the scenario, several servers running mysqld are behind a virtual IP so when you connect to mysqld you do not know which server you are really connected to. The get_host_info only returns the name used to connect to the virtual address. I've checked the variables table but the hostname is not there either. I can solve the problem by creating a database with the name of the host but that's not very elegant nor can I use dots for the IP or FQDN as the db name. Couple ideas: . Write a UDF that returns the value of gethostname() To use: SELECT gethostname(); . Put the hostname in a single-row table. To use: SELECT hostname FROM serverinfo; . Add a read-only mysql variable, submit patches back to mysql. To use: SHOW VARIABLES like 'hostname'; -- Dan Nelson [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL Transaction Problem
I'm sorry, but apparently I'm too green to be able to figure this out. You are right, when I do the SHOW CREATE TABLE, it tells me my table is MyISAM. If I use ALTER TABLE Episode TYPE=BDB;, it accepts the command but does not change the table type. I am using MySQLD-max-nt, which the manual says should support BDB tables. But apparently I am missing something, because on my system it doesn't. I read about configuring, but cannot figure out how to apply the /configure --with-berkeley-db option to an NT service. (This part of the manual appears to me to only to apply to *nix here, but maybe that just shows my ignorance.) The output from the executable tells me there is no such option, but suggests there is a -skip-bdb option to turn BDB off, which I *don't* want. How do I get BDB working under Windows 2000? Any help would be greatly appreciated. David Woods Wisconsin Center for Education Research University of Wisconsin, Madison I am writing a system that requires transactions. I understand that I need to use Transaction-safe tables, such as BDB or InnoDB, but even when I do, I get an error when I try to roll back my transaction. Here is some SQL that illustrates my problem: I create a table of type BDB (failure is the same if I use InnoDB): CREATE TABLE Episodes( EpisodeID varchar(100) NOT NULL, RecordLock varchar(25), Primary Key (EpisodeID)) TYPE=BDB ; If you issue a SHOW CREATE TABLE Episodes statement, does the output indicate that the table is indeed of type BDB? If your server wasn't compiled with support for transactional tables, the table may default to MyISAM (and you won't get a warning, alas). I put a couple of records in it to have something to work with: INSERT INTO Episodes (EpisodeID, RecordLock) VALUES ('Boychoir', ''); INSERT INTO Episodes (EpisodeID, RecordLock) VALUES ('Demo', ''); I start a transaction and look at the contents of my table: BEGIN; SELECT EpisodeID, RecordLock FROM Episodes; I change something in the table, still within the transaction and check that it is changed: UPDATE Episodes SET RecordLock = 'DavidW' WHERE EpisodeID = 'Boychoir'; SELECT EpisodeID, RecordLock FROM Episodes; I discover (programmatically) that I need to roll the transaction back, so I do: ROLLBACK; I get the following message: ERROR 1196: Warning: Some non-transactional changed tables couldn't be rolled back SELECT EpisodeID, RecordLock FROM Episodes; I check again, and indeed the data is changed and the rollback failed. What am I doing wrong? I am using version 3.23.43-nt under Windows 2000. Thanks for your help, David Woods, Ph.D. Wisconsin Center for Education Research - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Large MySQL setup
Hello again list. I sent this message yesterday and wasn't able to get an answer. Just curious to see if any of the gurus out there care to share some insight on a mid-level MySQL setup, and can offer some starting points for learning how to troubleshoot the same. | Begin message: I have a dedicated server (a Sun E4500 CPUs 4x400mhz w/ 4 gigs of ram and 8gigs of swap, which is connected to a 100+gig dothill RAID with its own controller. The only function of this server is to run MySQL. The tables run upwards of around 13-15 gigs each. The nature of the data forces me to search the entire contents (looking for unique values) around 3000 times a day. The server is running Solaris 2.8, with MySQL 3.9.43 compiled in 64bit mode. All tables are currently MyISAM tables. (Will probably be going with InnoDB, but large file support was -just- released). All of the documents (manuals, online forums, etc) I have looked through include the huge my.cnf configuration, but it isn't large enough for my hardware. So, in my limited knowledge of my.cnf settings, here is what I have currently: set-variable= key_buffer=3096M set-variable= max_allowed_packet=1M set-variable= table_cache=512 set-variable= sort_buffer=1024M set-variable= record_buffer=512M set-variable= thread_cache=32 # Try number of CPU's*2 for thread_concurrency set-variable= thread_concurrency=16 set-variable= myisam_sort_buffer_size=64M Can anyone show me a .cnf that would offer more performance? Also, I can't seem to get MySQL to use any of the other processors. I know that Solaris 2.8 has SMB and threads in it, as running dnetc tests show all four processors working together. However, running heavy CPU load MySQL selects (eg: select count(distinct(foo)) ) top shows a steady 75% idle, with a running iostat of near nothing, so it isn't disk bound. Running multiple intenses of the queries shows the same results, 75% idle, meaning only one CPU is being used. My installation of MySQL was compiled locally from source, with the following configuration options: ./configure --without-innodb --without-bench --without-debug Anything with that configuration that would be limiting me to just one CPU? Any and all advice is welcomed and appreciated. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Aaron Williams[EMAIL PROTECTED] Black Raven.com http://www.backraven.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: Offtopic JDBC
Hi Othmar, I'm sure its probably a typo in your message, but isn't the default port 3306 and not 3360? Also, isn't there a : after mysql? e.g. jdbc:mysql://localhost:3306/ If its not this then let me know and I'll try and suggest a solution. Best Regards, Chris -Original Message- From: Othmar Stehlik [mailto:[EMAIL PROTECTED]] Sent: 09 November 2001 16:02 To: [EMAIL PROTECTED] Subject: Offtopic JDBC Hi I run mySQl on a Win98 machine,and cant get a connection. My sql runs fine, but I cant connect to the database. I use the path jdbc:mysql//localhost:3360/...and so on. On win2k everything worked fine. Please give an advice! Othmar -- GMX - Die Kommunikationsplattform im Internet. http://www.gmx.net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Beginner question - getting last inserted ID
On Fri, 9 Nov 2001, Carl Troein wrote: Date: Fri, 09 Nov 2001 15:41:21 GMT From: Carl Troein [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Beginner question - getting last inserted ID Anna Åhnberg writes: Thanks, I actually already found the chapters but now I also now how to use the function too! Let me quote from the manual: LAST_INSERT_ID([expr]) Returns the last automatically generated value that was inserted into an AUTO_INCREMENT column. mysql select LAST_INSERT_ID(); - 195 Thus you'd follow these steps: 1) INSERT into the table, and leave out the auto column or supply a value of 0 or NULL 2) Verify that the query succeeded 3) SELECT LAST_INSERT_ID() 4) Get the result of the SELECT. On success, the SELECT will return one row with one value in it. That is the number you're interested in knowing. If you are using the mmysql jdbc driver you can directly access it. use import org.gjt.mm.mysql.Statement; instead of java.sql.Statement; Then after the insert long id = stmt.getLastInsertID(); Note: this is the only method to get a bigint unsigned index back accordign to the mm.mysql doc's . See source forge for details. If you were using MySQL's C API there is a function that returns the ID without the need for steps 3-4, but since you are communicating over JDBC I don't think there's a simpler solution available. The query in step 3 is extremely fast, so it doesn't really matter, except that it's a bit more work to make an extra query. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Keeping SQL dbs separated
Apache supports running cgi scripts as a designated user on a virtual host basis (only key is the files can be writable by ONLY the USER not his GROUP (toe badly stubbed making this mistake). However, why doesn't the isp create a separate mysql user for each client's database and restrict permissions that way? On Fri, 9 Nov 2001, Kodrik wrote: Date: Fri, 9 Nov 2001 06:13:56 -0800 From: Kodrik [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED], [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Keeping SQL dbs separated The guy passed this request to the hosting company (which he doesn't want to change) and the answer is: if you *really* need to use PHP instead of ASP OK, but as far as MySQL is concerned we only have one customer using it now, and if we gave it to you too, then the two databases would be visible and writeable to each other users.. unless *your* new webmaster programs our MySQL by himself to avoid this problem. That is one of the problem with most Virtual Hosting. The web server user is the often same for all users so you can use a scripting language to look at the files of other people's website. I'm talking about Unix/Apache server because it is what I know, but you can extrapolate to NT. For a script to access a database, it needs to write the connection on the files, and any other virtual user will therefore be able to see those files using php or asp. So any other user can read all access codes and duplicate them temselves. Which means having the same access to the database the other user has. You will also be able to write scripts to remove/add/modify any files that have the web server's permission. Worst, if your host gives a similar access code to your DB and FTP (which is often the case), you will be able to know your ftp user and pass. I must stress that this is not a MySQL issue, it is valid with any other database. I do work for various customers on various hosting systems and I must say that security within virtual hosting company is horrific between sites, regardless of OS. From their comment it seems their server is insecure although Microsoft has blinded them in a sense of false security and warned them about Open Source. The first thing you shoudl do is ask them how could you see the other person's db if you have different privileges. If they are able to answer this question and it makes sense; ask them why it isn't an issue on their MS server. I doubt they will answer well to those questions and you will have a extremelly valid point to request your customer to change provider: Security! regardless of the DB and script used. Now, leaving apart every comment on the quality of this ISP, what should I do on their server to make it so that I can indeed set my customer's PHP/MySQL pages without screwing anything up? I can usually find my way enough about MySQL, but this situation is entirely new to me. As a matter of fact, until yesterday I would have thought that it is more difficult to set up Mysql like this (or find real people doing it) than the other way around.. TIA, mweb - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql corruption tables in production environment (Urgent)
Rui Barreiros wrote: Hi, We have several mysql server in production evironment, and most of them when they have millions of rows, they all get MyIsam tables corrupted. One of the servers has ext2 filesystem with scsi harddrives, after the myisamchk -r it repairs the table, but after a few inserts it will corrupt again. the file is not bigger than 2gb. When I occasionally get tables like this: o Use mysqldump --opt db table /tmp/table.sql; mysql db table.sql to really fix it. If the table is big you may need to use the unix utility 'split'. Of course, please understand what the commands are doing before running them. And you may want to back up your db files before doing this. o If you still have problems, try adding a 'flush tables' after a bunch of inserts or before the program exits. --Bill - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Large MySQL setup
Aaron Williams wrote: Hello again list. I sent this message yesterday and wasn't able to get an answer. Just curious to see if any of the gurus out there care to share some insight on a mid-level MySQL setup, and can offer some starting points for learning how to troubleshoot the same. | Begin message: I have a dedicated server (a Sun E4500 CPUs 4x400mhz w/ 4 gigs of ram and 8gigs of swap, which is connected to a 100+gig dothill RAID with its own controller. The only function of this server is to run MySQL. The tables run upwards of around 13-15 gigs each. The nature of the data forces me to search the entire contents (looking for unique values) around 3000 times a day. The server is running Solaris 2.8, with MySQL 3.9.43 compiled in 64bit mode. All tables are currently MyISAM tables. (Will probably be going with InnoDB, but large file support was -just- released). All of the documents (manuals, online forums, etc) I have looked through include the huge my.cnf configuration, but it isn't large enough for my hardware. So, in my limited knowledge of my.cnf settings, here is what I have currently: set-variable= key_buffer=3096M set-variable= max_allowed_packet=1M set-variable= table_cache=512 set-variable= sort_buffer=1024M set-variable= record_buffer=512M set-variable= thread_cache=32 # Try number of CPU's*2 for thread_concurrency set-variable= thread_concurrency=16 set-variable= myisam_sort_buffer_size=64M Can anyone show me a .cnf that would offer more performance? Also, I can't seem to get MySQL to use any of the other processors. I know that Solaris 2.8 has SMB and threads in it, as running dnetc tests show all four processors working together. However, running heavy CPU load MySQL selects (eg: select count(distinct(foo)) ) top shows a steady 75% idle, with a running iostat of near nothing, so it isn't disk bound. Running multiple intenses of the queries shows the same results, 75% idle, meaning only one CPU is being used. My installation of MySQL was compiled locally from source, with the following configuration options: ./configure --without-innodb --without-bench --without-debug Anything with that configuration that would be limiting me to just one CPU? Any and all advice is welcomed and appreciated. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Aaron Williams[EMAIL PROTECTED] Black Raven.com http://www.backraven.com =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Hi, If you run a single query, MySQL will use only one processor. MySQL multithreading allows you to run multiple queries in parallel, one query per thread. Have you identified your bottleneck (CPU, filesystem I/O, swapping) ? What does 'mysqladmin extended-status' tell you ? (Allocating 3Gb of key_buffer only makes sense if you really need them). Is your query optimized ? What does EXPLAIN tell you ? It is hard to help you without any details since optimising my.cnf parameters not only depend your hardware configuration but also on your database usage pattern. Regards -- Joseph Bueno NetClub/Trader.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: Large MySQL setup
Aaron Williams wrote: The tables run upwards of around 13-15 gigs each. The nature of the data forces me to search the entire contents (looking for unique values) around 3000 times a day. The server is running Solaris 2.8, Do you have an index on the columns you are querying for unique values? That will help. If you do not need live and instant unique lists, you could (once every 30 minutes say) populate a special table with the unique values. With locking, etc. of course. with MySQL 3.9.43 compiled in 64bit mode. All tables are currently MyISAM tables. (Will probably be going with InnoDB, but large file support was -just- released). InnoDB might help because it does have row-level locking. isn't disk bound. Running multiple intenses of the queries shows the same results, 75% idle, meaning only one CPU is being used. AFAIK, 3.23.x only supports one CPU per thread/select. b. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
why index stops to work ?
Hello mysql list, Could anybody explain why index stops to work in the query SELECT SUM(...) WHERE ... with encreasing the size of range, but continue to work in the analog query SELECT COUNT(*) WHERE ... ? See later: In the table ip_summary_d: PRIMARY KEY = (date,): mysql explain select SUM(In_byts) from ip_summary_d where date '2001-10-26'; +--+---+---+-+-+--+-++ | table| type | possible_keys | key | key_len | ref | rows| Extra | | +--+---+---+-+-+--+-++ | ip_summary_d | range | PRIMARY | PRIMARY | 3 | NULL | 2366655 | where |used | +--+---+---+-+-+--+-++ 1 row in set (0.00 sec) mysql explain select SUM(In_byts) from ip_summary_d where date '2001-10-25'; +--+--+---+--+-+--+--++ | table| type | possible_keys | key | key_len | ref | rows | Extra | +--+--+---+--+-+--+--++ | ip_summary_d | ALL | PRIMARY | NULL |NULL | NULL | 13974447 | where used | +--+--+---+--+-+--+--++ 1 row in set (0.00 sec) BUT (!!!): mysql explain select count(*) from ip_summary_d where date '2001-10-25'; +--+---+---+-+-+--+-+-+ | table| type | possible_keys | key | key_len | ref | rows| Extra | | +--+---+---+-+-+--+-+-+ | ip_summary_d | range | PRIMARY | PRIMARY | 3 | NULL | 2572752 | where |used; Using index | +--+---+---+-+-+--+-+-+ 1 row in set (0.00 sec) WITH count(*) exept SUM(In_bytes) it WORKS AGAIN !!! EVEN MORE FOR ALL TABLE: mysql explain select count(*) from ip_summary_d where date '2001-1-1'; +--+---+---+-+-+--+--+-+ | table| type | possible_keys | key | key_len | ref | rows | Extra || +--+---+---+-+-+--+--+-+ | ip_summary_d | range | PRIMARY | PRIMARY | 3 | NULL | 13974447 | where |used; Using index | +--+---+---+-+-+--+--+-+ 1 row in set (0.00 sec) Adjusting key_buffer_size variable has no result. Other infomation: - mysql-3.23.44-pc-linux-gnu-i686 2*Pentium3-750Mhg 512Mb memory Large Mysql Model: set-variable= key_buffer=256M set-variable= max_allowed_packet=1M set-variable= table_cache=256 set-variable= sort_buffer=1M set-variable= record_buffer=1M set-variable= myisam_sort_buffer_size=64M set-variable= thread_cache=8 mysql show keys from ip_summary_d; +--++--+--+-+---+-+--++-+ | Table| Non_unique | Key_name | Seq_in_index | Column_name | Collation | |Cardinality | Sub_part | Packed | Comment | +--++--+--+-+---+-+--++-+ | ip_summary_d | 0 | PRIMARY |1 | date| A | | 128 | NULL | NULL | | | ip_summary_d | 0 | PRIMARY |2 | local | A | |3493611 | NULL | NULL | | | ip_summary_d | 0 | PRIMARY |3 | tosCO | A | |4658149 | NULL | NULL | | | ip_summary_d | 0 | PRIMARY |4 | tosTYPE | A | |13974447 | NULL | NULL | | | ip_summary_d | 0 | PRIMARY |5 | tosSLINK| A | |13974447 | NULL | NULL | | | ip_summary_d | 0 | PRIMARY |6 | tosDLINK| A | |13974447 | NULL | NULL | | | ip_summary_d | 1 | local|1 | local | A | | 48691 | NULL | NULL | | | ip_summary_d | 1 | local|2 | date| A | |3493611 | NULL | NULL | | +--++--+--+-+---+-+--++-+ -- Best regards, wk mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)
show processlist
How do I show processlist from a specific computer, not everything ? Thanks.
Lots of Aborted Connections and Signal 11s
I run PHP 4.0.3 and MySQL 3.23.32. I get a fair amount of traffic and host about 1000 very small sites on a fairly fast server with plenty of RAM and space. However, it keeps shutting down frequently and every time it shuts down, the binary log files rotate, and someone will probably try to access the database while it's down and they'll get an error. Here's a clip from my error log that seems to be repeated over and over and over again, just at different times: BEGIN SNIPPET 011109 7:27:33 Aborted connection 13073 to db: 'site_info' user: 'root' host: `localhost' (Got an error reading communication packets) 011109 7:59:00 Aborted connection 13081 to db: 'site_mails' user: 'root' host: `localhost' (Got an error reading communicat ion packets) 011109 7:59:00 Aborted connection 13080 to db: 'site_mails' user: 'root' host: `localhost' (Got an error reading communicat ion packets) mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died. 011109 08:20:45 mysqld restarted /usr/local/mysql/libexec/mysqld: ready for connections 011109 8:57:31 Aborted connection 1622 to db: 'site_mails' user: 'root' host: `localhost' (Got an error reading communicati on packets) 011109 8:57:31 Aborted connection 1654 to db: 'site_mails' user: 'root' host: `localhost' (Got an error reading communicati on packets) 011109 8:57:31 Aborted connection 1806 to db: 'site_users' user: 'root' host: `localhost' (Got an error reading communi cation packets) 011109 8:59:00 Aborted connection 1817 to db: 'site_mails' user: 'root' host: `localhost' (Got an error reading communicati on packets) mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died. 011109 09:01:37 mysqld restarted /usr/local/mysql/libexec/mysqld: ready for connections END SNIPPET Any ideas, anyone? I don't use persistent connections, by the way. There's only one page that does use them, and it is accessed about once every couple months. It is not part of the main sites that everyone surfs. - Jonathan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Mysql Innodb data files
Hello everyone, I have a question with regards to the InnoDB data files. I have the following in my.ini file. innodb_data_file_path = ibdata1:200M innodb_data_home_dir = c:/innodb_data I just want to know the following. Does it mean that I have 200Mb allocated space to store all the InnoDB data in? What happens if I exceed 200Mb? Can I alter the size in the future, once I define a size for it? Also, if I had innodb_data_file_path = ibdata1:200M; ibdata2:200M And my data exceeded 200M, would the rest of the data transfer over to data2? What is the best configuration, having multiple datafiles that are small in size or have one datafile which will be big. Thanks, Oganes Demirchyan Motorola Life Science 757 S.Raymond Pasadena, CA 91105 Tel: 626-584-5900 email: [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, November 09, 2001 9:59 AM To: Demirchyan Oganes-AOD098 Subject: Re: Mysql Innodb data files Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: database,sql,query,table If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: Hello everyone, I have a question with regards to the InnoDB data files. I have the following in my.ini file. innodb_data_file_path = ibdata1:200M innodb_data_home_dir = c:/innodb_data I just want to know the following. Does it mean that I have 200Mb allocated space to store all the InnoDB data in? What happens if I exceed 200Mb? Can I alter the size in the future, once I define a size for it? Also, if I had innodb_data_file_path = ibdata1:200M; ibdata2:200M And my data exceeded 200M, would the rest of the data transfer over to data2? What is the best configuration, having multiple datafiles that are small in size or have one datafile which will be big. Thanks, Oganes Demirchyan Oganes Demirchyan Motorola Life Science 757 S.Raymond Pasadena, CA 91105 Tel: 626-584-5900 email: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: show processlist
Stuart Scamman wrote: How do I show processlist from a specific computer, not everything ? Thanks. mysqladmin processlist |grep 'the.host.you.care.about' -- Bill Adams TriQuint Semiconductor - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: why index stops to work ?
wk writes: Could anybody explain why index stops to work in the query SELECT SUM(...) WHERE ... with encreasing the size of range, but continue to work in the analog query SELECT COUNT(*) WHERE ... ? Well, I can imagine that the optimizer chooses not to use the index for SUM() a lot sooner than from COUNT() since it will have to actually look at the values. Ideally, the time for a COUNT() WHERE value BETWEEN this AND that takes logarithmic time (log of the total number of rows in the table, that is), no matter how many rows are matched. SUM(), on the other hand, takes time proportional to the number of matched rows, and the overhead of using an index is something like a factor 2 or more of the time it takes to just use the data for the same number of rows. Thus if your WHERE matches more than a third of the rows, using the index is a bad idea. This is why it's pointless to index boolean columns, unless you have a very uneven distribution and run ANALYZE TABLE while you have such a distribution. Question to the list: Is the last part of what I said correct? //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 -server conflicts error
Hi All, I tried to upgrade mysql database from mysql-server-3.23.36-1 to mysql-3.23.43-1. However, when I downloaded and used rpm -i MySQL-3.23.43-1.i386.rpm I received the following error: error: failed dependencies: MySQL conflicts with mysql-3.23.36-1 MySQL -server conflicts with mysql-server-3.23.36-1 Please help! Thanks! Sunny Ouyang - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Large MySQL setup
Joseph Bueno wrote: Hi, If you run a single query, MySQL will use only one processor. MySQL multithreading allows you to run multiple queries in parallel, one query per thread. Right, that I understand. Even while running up to 30 queries it pegs the first CPU at max, and no other CPUs are getting any data to process. Have you identified your bottleneck (CPU, filesystem I/O, swapping) ? At this point, it is the CPU. Running a constant iostat -dxz 2 to show disk usage, it is near zero for most of the time. It will occasionally jump up a bit briefly, but nothing near what would be causing a bottleneck. What does 'mysqladmin extended-status' tell you ? (Allocating 3Gb of key_buffer only makes sense if you really need them). Which part of the extended-status would you like to see? All of it? In response to Bill Adams and to this question: nearly the entire table is indexed. The purpose of this table is to store RADIUS accounting records. The data is inserted into the table once per day, and is then bits of the data are extracted from it in large sections three times per day. The key_buffer, according to the docs, should be 80% of the physical system memory. I was a bit conservative and set it to be 75%.. 3 of 4 gigs. As data is only inserted once, and nearly all of the use of this table is for SELECTing, we indexed nearly all of it for speed reasons. The insert is done by perl scripts called from cron in the middle of the night, so speed, at that point, isn't nearly as important as it is when called by humans during the day hours. Is your query optimized ? What does EXPLAIN tell you ? We just bought this new server last month. Prior to it, we were doing the same queries on a 2x200mhx with 2gigs of ram, with the same RAID setup. So, as you can imagine, the queries themselves are extremely optimized. For several months we tried, and succeeded mostly, at optimizing the scripts and the queries, instead of just throwing more hardware at the problem. It is hard to help you without any details since optimising my.cnf parameters not only depend your hardware configuration but also on your database usage pattern. Ok, you have the hardware configuration, and I have described somewhat of how the database pattern of use is above. But, just to recap everything: Hardware: Sun E4500, 4x400mhz 4 gigs of RAM DotHill 100+ GIG RAID w/ controller, currently getting 16-18 megs per second io. Database setup: MyISAM tables. Roughly 10-13 gig .MYIs (data) Roughly 2-3 gig .MYDs (indexes) About 1 million rows are inserted once per day in the early hours. Tables are rolled into new tables at the beginning of each month. Then, periodically throughout the day SELECTs are run on the data, for all days from the beginning of the month up through and including today. As you might imagine, the queries get slower and slower as the month goes on, which is expected. There are two styles of queries done, a select unique (which has shown to be faster than 'select foo group by foo'.. which goes against the docs, but has proven faster over and over again). The second style is used to just search one day. I use temp tables for this, so it runs really fast already. Again: It is not really the queries I am worried about, but are provided to show the pattern of use. I am very confident with the actual syntax of the queries. My main concern is the my.cnf and why MySQL isn't using the other CPUs on the machine, even with many queries running. In response to Bill Adams: InnoDB might help because it does have row-level locking. Right, we will definitely be looking at InnoDB now that it supports file sizes large enough for us. AFAIK, 3.23.x only supports one CPU per thread/select. Understandable. MySQL is only going to be able to send one query to one CPU, no doubt there. Our problem is that even with 30 queries, MySQL is still only sending them to the first CPU. I appreciate the help so far, and will gladly supply any other information needed to help you narrow down my best options. Also, I mentioned above that select unique is faster than a group by. Another thing I have benchmarked and proven, at least on our setup, that goes against documentation, is with the Perl DBI. While it may be off-topic of this forum, I know many use it with MySQL. fetchrow_array has proven to be faster than fetchrow_arrayref, which, according to the docs, should be faster. Just thought it interesting. You find such stuff when squeezing very last ounce of performance from your software, or at least trying to. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Aaron Williams[EMAIL PROTECTED] Black Raven.com http://www.backraven.com =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list
RE: How to Create Tables ... and Clients using winmysqladmin
Hi Shekar, -Original Message- From: ChandraShekarReddy Talakola [mailto:[EMAIL PROTECTED]] Sent: Friday, November 09, 2001 6:50 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: How to Create Tables ... and Clients using winmysqladmin Hi, I am just install the mysql database and i start the system at dos prompt winmysqladmin i got the test tables with permissions and i have created my own database but iam unable to create table for that how can i create table and also i want create clients for my server and set the permission i tryed the artonic administrator but i can't understand how to create clients ,could tell me how to create tables and also there is an error some when i am starting mysqld-max-nt --standalone --console at prompt saying InnoDB is error with my.cnf showing different size Please send details to [EMAIL PROTECTED] regarding how to create tables and clients and how to work the clients with server using TCP/IP of windows Also please mention the ODBC connection string for connecting the ASP to mysql database not with respect to MyOLEDB connection All answers are in MySQL manual. You can find this from /docs subdirectory in the distribution or at www.mysql.com/doc 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 Transaction Problem
I got it figured out, sort of. My machine was not loading the version of MySQL I thought it was. Now it is, and I have BDB support. My rollbacks now work. Thanks for the help. David -Original Message- From: David Woods [mailto:[EMAIL PROTECTED]] Sent: Friday, November 09, 2001 10:25 AM To: 'Paul DuBois' Cc: [EMAIL PROTECTED] Subject: RE: MySQL Transaction Problem I'm sorry, but apparently I'm too green to be able to figure this out. You are right, when I do the SHOW CREATE TABLE, it tells me my table is MyISAM. If I use ALTER TABLE Episode TYPE=BDB;, it accepts the command but does not change the table type. I am using MySQLD-max-nt, which the manual says should support BDB tables. But apparently I am missing something, because on my system it doesn't. I read about configuring, but cannot figure out how to apply the /configure --with-berkeley-db option to an NT service. (This part of the manual appears to me to only to apply to *nix here, but maybe that just shows my ignorance.) The output from the executable tells me there is no such option, but suggests there is a -skip-bdb option to turn BDB off, which I *don't* want. How do I get BDB working under Windows 2000? Any help would be greatly appreciated. David Woods Wisconsin Center for Education Research University of Wisconsin, Madison I am writing a system that requires transactions. I understand that I need to use Transaction-safe tables, such as BDB or InnoDB, but even when I do, I get an error when I try to roll back my transaction. Here is some SQL that illustrates my problem: I create a table of type BDB (failure is the same if I use InnoDB): CREATE TABLE Episodes( EpisodeID varchar(100) NOT NULL, RecordLock varchar(25), Primary Key (EpisodeID)) TYPE=BDB ; If you issue a SHOW CREATE TABLE Episodes statement, does the output indicate that the table is indeed of type BDB? If your server wasn't compiled with support for transactional tables, the table may default to MyISAM (and you won't get a warning, alas). I put a couple of records in it to have something to work with: INSERT INTO Episodes (EpisodeID, RecordLock) VALUES ('Boychoir', ''); INSERT INTO Episodes (EpisodeID, RecordLock) VALUES ('Demo', ''); I start a transaction and look at the contents of my table: BEGIN; SELECT EpisodeID, RecordLock FROM Episodes; I change something in the table, still within the transaction and check that it is changed: UPDATE Episodes SET RecordLock = 'DavidW' WHERE EpisodeID = 'Boychoir'; SELECT EpisodeID, RecordLock FROM Episodes; I discover (programmatically) that I need to roll the transaction back, so I do: ROLLBACK; I get the following message: ERROR 1196: Warning: Some non-transactional changed tables couldn't be rolled back SELECT EpisodeID, RecordLock FROM Episodes; I check again, and indeed the data is changed and the rollback failed. What am I doing wrong? I am using version 3.23.43-nt under Windows 2000. Thanks for your help, David Woods, Ph.D. Wisconsin Center for Education Research - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Mysql Innodb data files
From: Demirchyan Oganes Hello everyone, I have a question with regards to the InnoDB data files. I have the following in my.ini file. innodb_data_file_path = ibdata1:200M innodb_data_home_dir = c:/innodb_data I just want to know the following. Does it mean that I have 200Mb allocated space to store all the InnoDB data in? What happens if I exceed 200Mb? Can I alter the size in the future, once I define a size for it? Yes you have 200MB allocated for the entire database. The transaction that would exceed the database space, hopefully, would be rolled back.(I don't know from experience). In any case you would be in trouble. You can add additional data files by changing the configuration file and restarting the database but you cannot remove or change the size of an existing file. Also, if I had innodb_data_file_path = ibdata1:200M; ibdata2:200M And my data exceeded 200M, would the rest of the data transfer over to data2? The say they fill the tablespace from the bottom up. I have not read all their docs yet but that could mean that the last named file is used first. In any case all the space would be available. What is the best configuration, having multiple datafiles that are small in size or have one datafile which will be big. That would depend on a lot of things. For linux/unix multiple tablespace files can be spread across different disks. That might give a performace improvement. Often the composition of the database determines what makes the most sense. Hardware limitations can be a factor. Experiment, trial and error are often the only way to answer such a question. I suggest you go to the following link. It looks like interesting reading. I am reading it as I have the time. http://www.innodb.com/ibman.html#InnoDB_overview - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Duplicate column names
How does MySQL handle duplicate column names? This e-mail and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to whom they are addressed. This communication may contain material protected by legal privileges or statutory protections. If you are not the intended recipient or the individual responsible for delivering the e-mail to the intended recipient, please be advised that you have received this e-mail in error and that any use, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately notify us and delete the original message. Upon request, we will reimburse you for reasonable costs incurred in notifying us. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How does authentication works with MYSQL??????
Can someone PLEASE explains how MySQL does authentication remotely After installing MYSQL I created a user root with xyzxyz password. The database allowed that. When I connect Mysql, via java codes, from the same machine it works perfectly. When I connect Mysql, via java codes, from a remote machine it does not work. How come the user is the same, the IP address is the same... It's getting confused with the original root user Iguess. Can someone give a hint on this??? Thanks Siomara _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How does authentication works with MYSQL??????
Look at the 'grant' commands in the mysql manual. You have to setup permissions if you want other hosts (other than localhost) to work, by assigning permissions to all domains or a list of ips or something. Its pretty complicated, but if you just want to give one user access from anywhere its not so bad. Chris When I connect Mysql, via java codes, from a remote machine it does not work. How come the user is the same, the IP address is the same... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Solaris 8 Mysql-3.23.44
Has anyone been able to get mysql-3.23.44 running on the Sparc platform Solaris 8? I've tried both binary and source distro's with no luck. I've made the recomended changes from the Readme's and Install files as well as searched google high and low. I still get the same failures. From the source distro I get the following durring ./configure SNIP checking return type of sprintf... configure: error: can not run test program while cross compiling From the binary distro I get the following scripts/mysql_install_db SNIP- Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables ld.so.1: ./bin/mysqld: fatal: libz.so.1: open failed: No such file or directory Killed Installation of grant tables failed! I went to zlib.org and got zlib and installed it but that doesn't seem to help. Any clues??? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
question
How can I fix this? Database: mysql_error:Host 'localhost.localdomain' is not allowed to connect to This mysql server Fatal Error, Quitting.. Snort: no process killed - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: New fork of MySQL
Steve Meyers wrote: The MySQL source is under the GPL. Any fork must also be under the GPL. You may sell your forked MySQL, but you must also provide the source code. Is it really, now? What are the rules about bundling now? If we distribute a (standalone) copy of MySQL with our product, does that expose our product to the GPL? Or is it just like distributing a copy of Emacs with your OS? (I.e. as long as you make the source available, it doesn't automatically GPL the rest of your OS?) What if the product is designed to work with many databases, but we want to distribute MySQL only as a default database (i.e. it doesn't depend on MySQL for its functionality - it's merely a convenience)? Does that change the GPL liability on our product? Who can answer these questions? -- Shankar. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Solaris 8 Mysql-3.23.44
Has anyone been able to get mysql-3.23.44 running on the Sparc platform Solaris 8? I've tried both binary and source distro's with no luck. I've made the recomended changes from the Readme's and Install files as well as searched google high and low. I still get the same failures. I went to zlib.org and got zlib and installed it but that doesn't seem to help. Any clues??? We have recently started using 2.8 and have noticed a few odd things like this. Almost always it tracks down to be a PATH problem. It seems that 2.8 handles it PATH set up a lot differently than the previous versions of Solaris. We had problems with the cross compiling error in the configure script for .43. Luckily for us, that was in the FAQ, and we were able to fix it pretty easily. I suspect that even after you installed zlib, that it might not have been in your PATH, thus MySQL had no idea where it was. Just an idea. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Aaron Williams[EMAIL PROTECTED] Black Raven.com http://www.backraven.com =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: OT: Default forced on MySQL;
DownloadFAST.com wrote: [...] why don't you try PostgreSQL instead? My understanding is it is much slower. No kidding? Why don't you fork the PostGreSQL codebase and apply your special assembly talents to speed it up by 50% or even 60%? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: question
Check your grants table in the mysql db...make sure you have given yourself permission to user said db from the specified host as that user... Wells, Kenneth L wrote: How can I fix this? Database: mysql_error:Host 'localhost.localdomain' is not allowed to connect to This mysql server Fatal Error, Quitting.. Snort: no process killed - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Duplicate column names
How does MySQL handle duplicate column names? You can't create two columns with the same name in one table. If you have a query that combines multiple tables, you reference them with the table name: ie select a.id, b.id as otherid from a, b where 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
How to improve FTI speed?
Hi. I've just set up my prototype so I can benchmark comparatively tthe profmance between PostgreSQL and MySQL. There's good news, and there's bad news. The good news is - MySQL is faster by about 2 times. The bad news is - MySQL is ONLY faster by about 2 times. Now, I DO understand that this is a LOT, but I'd really like to make this go faster. Here is the setup I have used: Number of Master records: 49,508 Number of FTI entries (PostgreSQL only): 1,574,136 Optimize/Vacuum ran just before the test: PostgreSQL: VACUUM VERBOSE ANALYZE; MySQL: OPTIMIZE TABLE Master The data set used on the prototype benchmark is a random set of old job adverts that I had lying around from a previous project. On PostgreSQL a custom subrouting was written to handle the FTI text splitting. Query used on PostgreSQL: SELECT DISTINCT Jobs.* FROMJobs, JobsFTI WHERE Retrieved '08-Nov-2000' AND Retrieved '10-Nov-2000AND Jobs.ID = JobsFTI.ID AND ( JobsFTI.String = 'perl' OR JobsFTI.String = 'linux'OR JobsFTI.String = 'apache' OR JobsFTI.String = 'html' OR JobsFTI.String = 'cgi' OR JobsFTI.String = 'mod_perl' OR JobsFTI.String = 'modperl' OR JobsFTI.String = 'postgres' OR JobsFTI.String = 'nt' OR JobsFTI.String = 'postgresql' ); Query used on MySQL: SELECT Jobs.* FROMJobs WHERE Retrieved '20001108' AND Retrieved '20001110 AND MATCH (Title, Description) AGAINST ('perl linux apache html cgi mod_perl modperl postgres postgresql nt'); The test machine is a dual P3/1GHz with 1 GB of RAM. In the test, a perl program using DBI executed the above queries 100 times. The test was ran twice on each database, to avoid any influence of disk access on the performance (i.e. it was all running from cache). The second value is reported here. Both PostgreSQL and MySQL were set to use 128 MB of buffer cache (key_buffer in MySQL, shared_buffers in PostgreSQL), with a similar amount of sort memory allowed. Results: PostgreSQL: 119 seconds. (1.19 seconds/query) MySQL: 58 seconds. (0.58 seconds/query) I must say I am impressed with the speed increase. In all honesty I expected less of a difference. I just tried reducing the query string to just 'perl linux', and now the time taken is 9 seconds for the test (100 runs), compared to 15 seconds for PostgreSQL. MySQL sits happily at about 16 MB memory consumption, while PostgreSQL consumes about 130 MB. The reason for this is, apparently, because PostgreSQL handles it's own caching (in addition to the OS). The figure of 0.09 seconds/query is very nice for a reasonable sounding case of two search parameters. With 35 search parameters MySQL reports 1.94 seconds search time, which is still impressive for such a large query. Now for the punch-line question - how do I speed this up further? I need to at least maintain this sort of performance on a signifficantly smaller server than this benchmark test-bed. Are there any tuning parameters I should be aware of? I have already gone through the documentation and applied reasonable sounding values to variables. Is there some sort of query profiling mechanism to try to see where things are taking longest? I'm using MySQL v4.0-alpha BTW. I will try recompiling with pgcc at some point with in-line functions, -O9, and without frame pointers etc, but it is likely that this system will eventually run on an AMD Athlon processor, so it may not work with pgcc. It is also almost certain that the database server will be separate from the application server, which is likely to slow things down further. I have just done strip on the mysqld. No percievable difference in my custom test. I compiled it all without debug options. I haven't compiled the server with -static. I haven't tried starting the deamon with --skip-safemalloc. Is this likely to make much difference/cause problems? How much difference is compiling with pgcc with -O9, in-line functions, and without frame pointers likely to make? Are any of those tweaks deprecated in v4? Or am I simply pushing against the limits of what is reasonably possible here? Thanks for any input you can provide. Regards. Gordan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: New fork of MySQL
Shankar Unni writes: What are the rules about bundling now? If we distribute a (standalone) copy of MySQL with our product, does that expose our product to the GPL? Or is it just like distributing a copy of Emacs with your OS? (I.e. as long as you make the source available, it doesn't automatically GPL the rest of your OS?) What if the product is designed to work with many databases, but we want to distribute MySQL only as a default database (i.e. it doesn't depend on MySQL for its functionality - it's merely a convenience)? Does that change the GPL liability on our product? Who can answer these questions? I believe the GPL FAQ tries to address these questions: http://www.gnu.org/licenses/gpl-faq.html#MereAggregation Specifically, this may be of interest to you: By contrast, pipes, sockets and command-line arguments are communication mechanisms normally used between two separate programs. So when they are used for communication, the modules normally are separate programs. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Duplicate column names
Brad Harriger [EMAIL PROTECTED] wrote: How does MySQL handle duplicate column names? Kind of open ended, but I'll give it a shot. MySQL doesn't allow duplicate column names within a table, but if you are referring to a query accessing multiple tables containing fields with the same name then you need to preface the field with the tablename so MySQL knows which you are referring to. SELECT tablea.id FROM tablea, tableb; SELECT tablea.id as a_id, tableb.id as b_id FROM tablea, tableb; HTH, -- Steve Werby President, Befriend Internet Services LLC http://www.befriend.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: New fork of MySQL
hi. regarding 'bundling' GPL products with commercial ones: http://www.gnu.org/licenses/gpl-faq.html#GPLInProprietarySystem to summarize, it's okay, if it's done properly. hth. -ravi. -Original Message- From: Shankar Unni [mailto:[EMAIL PROTECTED]] Sent: November 9, 2001 2:24 PM To: [EMAIL PROTECTED] Subject: Re: New fork of MySQL Steve Meyers wrote: The MySQL source is under the GPL. Any fork must also be under the GPL. You may sell your forked MySQL, but you must also provide the source code. Is it really, now? What are the rules about bundling now? If we distribute a (standalone) copy of MySQL with our product, does that expose our product to the GPL? Or is it just like distributing a copy of Emacs with your OS? (I.e. as long as you make the source available, it doesn't automatically GPL the rest of your OS?) What if the product is designed to work with many databases, but we want to distribute MySQL only as a default database (i.e. it doesn't depend on MySQL for its functionality - it's merely a convenience)? Does that change the GPL liability on our product? Who can answer these questions? -- Shankar. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: New fork of MySQL
I get the error 'Host 'emdtest.ncr.com' is not allowd to connect to this MySQL database server' How do I correct this??? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: New fork of MySQL
Wells, Kenneth L writes: I get the error 'Host 'emdtest.ncr.com' is not allowd to connect to this MySQL database server' whine First of all, I must ask you why you've posted this under a thread about forking off MySQL. This makes little sense to me. Secondly, since you just posted the same question, did you really have to post it again? /whine And finally, the answer you were waiting for: You haven't set up mysqld to accept connections from that host. You need to read the chapter in the manual about how to set up privileges using GRANT, and then turn your newfound knowledge into swift and merciless action. //C - always merciless, never swift. Or possibly the other way around. -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: New fork of MySQL
http://www.mysql.com/doc/G/R/GRANT.html You need to GRANT 'emdtest.ncr.com' permission to connect or a user from any box to connect with a user name and password. mysql GRANT ALL PRIVILEGES ON *.* TO kenneth@% IDENTIFIED BY 'some_pass' WITH GRANT OPTION; means kenneth can connect from box (%) with a password. Remember you need to Flush your new settings for them to take effect. Read Learn Live http://www.mysql.com/doc/A/d/Adding_users.html I get the error 'Host 'emdtest.ncr.com' is not allowd to connect to this MySQL database server' How do I correct this??? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: OT: Default forced on MySQL;
No kidding? Why don't you fork the PostGreSQL codebase and apply your special assembly talents to speed it up by 50% or even 60%? If you're willing to pay for quality, Oracle is an obvious choice. It's fast, it has all the features, there are numerous advanced tools to manage and develop your systems. MySQL is targeted for some needs, to which it answers very well, Postgres has some great strengh for which it has to sacrifice (which is why MySQL choose not to support some features), MSQL has heuh, hum, hmm, oh yes, the micosoft logo of quality and security. And there's Oracle. I don't see what's the dilema. Go for Oracle. With the advanced need you have for your advanced coding, I feel you will rapidly need some other critical features that MySQL lacks. And even if it is within your means to remove all the MySQL's limtations that you will encounter, I think you will get a greater return by developing more great products using Oracle than to waste precious coding time (which would mean less other great products you can make). Also, since your products wil probably be original and appealing, you will end up partner with Oracle on some of your products. Oracle has a great dynamic team (and the best campus) and they will be more willing than work with you in bringing your products to market. Imagine if you made Coolpage (and your other future products like the db/site maker) with an Oracle sponsorship, you will easily be able to sell your site makers to Oracle customers, and you will be able to charge much much much more than to MySQL users, who prefer to use open source software, even if it means more headach. It pains me to advice you against helping MySQL, especially with all you plan to do for it, but the most profitable business model for you would be to dedicate yourself to your products instead of the DB, and then show a beta to Oracle who I am sure will want to partner with you in distributing them. At the end, it woud be much more $$$ in your pocket for less work. Oracle is a powerful company with a great product. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Licensing question
Hi Shankar, - Original Message - From: Shankar Unni [EMAIL PROTECTED] What are the rules about bundling now? If we distribute a (standalone) copy of MySQL with our product, does that expose our product to the GPL? Or is it just like distributing a copy of Emacs with your OS? (I.e. as long as you make the source available, it doesn't automatically GPL the rest of your OS?) What if the product is designed to work with many databases, but we want to distribute MySQL only as a default database (i.e. it doesn't depend on MySQL for its functionality - it's merely a convenience)? Does that change the GPL liability on our product? There is a recently rewritten section of the manual about this: http://www.mysql.com/doc/L/i/Licensing_and_Support.html The licensing subsection has some examples on when a commercial license is required and when it is not. You will also find contact info there, in case you have more questions. Hope this helps. Regards, Arjen. -- MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia ___/ 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
Newbie MySQL Install Question
I have some experience with MySQL on MacOS X but that was with a pretty GUI installer. I am now trying to get MySQL installed on Redhat 7.0. I download the client and server versions and followed the install procedures. The problem I am having is with mysqladmin. The docs state that you need to set the root password with 'mysqladmin -u root -p password'. I enter this command, I am then prompted for the new password and then I get a 'could not connect to local host' error. I think I am missing something here. To make matters worse my Linux experience is pretty limited as well. Thanks, Dan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Newbie MySQL Install Question
Make sure that the mysql server has been started. - Original Message - From: Dan Tappin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, November 09, 2001 4:07 PM Subject: Newbie MySQL Install Question I have some experience with MySQL on MacOS X but that was with a pretty GUI installer. I am now trying to get MySQL installed on Redhat 7.0. I download the client and server versions and followed the install procedures. The problem I am having is with mysqladmin. The docs state that you need to set the root password with 'mysqladmin -u root -p password'. I enter this command, I am then prompted for the new password and then I get a 'could not connect to local host' error. I think I am missing something here. To make matters worse my Linux experience is pretty limited as well. Thanks, Dan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Newbie MySQL Install Question
Dan Tappin wrote: I have some experience with MySQL on MacOS X but that was with a pretty GUI installer. I am now trying to get MySQL installed on Redhat 7.0. I download the client and server versions and followed the install procedures. The problem I am having is with mysqladmin. The docs state that you need to set the root password with 'mysqladmin -u root -p password'. I enter this command, I am then prompted for the new password and then I get a 'could not connect to local host' error. I think I am missing something here. To make matters worse my Linux experience is pretty limited as well. You need to start mysql first with either safe_mysqld (3.23.x) or mysqld_safe (4.0). b. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: New fork of MySQL
%% Shankar Unni [EMAIL PROTECTED] writes: su Who can answer these questions? Well, the obvious place to look is the MySQL web site, http://www.mysql.com Click Products, then click MySQL Licensing Policy. -- --- Paul D. Smith [EMAIL PROTECTED] HASMAT--HA Software Mthds Tools Please remain calm...I may be mad, but I am a professional. --Mad Scientist --- These are my opinions---Nortel Networks takes no responsibility for them. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Newbie MySQL Install Question
I tried that but it came back with a 'mysqld is running already' error. Side Question: How can I allow a SSH connection from a remote machine? My linux box is in a locked server room and I would like to administer it from my office via a terminal. I tried via SSH from my MacOS X laptop but I get a secure connection refused message. Thanks, Dan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bill Adams Sent: Friday, November 09, 2001 2:10 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Newbie MySQL Install Question Dan Tappin wrote: I have some experience with MySQL on MacOS X but that was with a pretty GUI installer. I am now trying to get MySQL installed on Redhat 7.0. I download the client and server versions and followed the install procedures. The problem I am having is with mysqladmin. The docs state that you need to set the root password with 'mysqladmin -u root -p password'. I enter this command, I am then prompted for the new password and then I get a 'could not connect to local host' error. I think I am missing something here. To make matters worse my Linux experience is pretty limited as well. You need to start mysql first with either safe_mysqld (3.23.x) or mysqld_safe (4.0). b. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Newbie MySQL Install Question
How do I double check? LSOF? I tried that but I can't get the option right? Side Question: How can I allow a SSH connection from a remote machine? My linux box is in a locked server room and I would like to administer it from my office via a terminal. I tried via SSH from my MacOS X laptop but I get a secure connection refused message. Thanks, Dan -Original Message- From: Kelley Reynolds [mailto:[EMAIL PROTECTED]] Sent: Friday, November 09, 2001 2:07 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Newbie MySQL Install Question Make sure that the mysql server has been started. - Original Message - From: Dan Tappin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, November 09, 2001 4:07 PM Subject: Newbie MySQL Install Question I have some experience with MySQL on MacOS X but that was with a pretty GUI installer. I am now trying to get MySQL installed on Redhat 7.0. I download the client and server versions and followed the install procedures. The problem I am having is with mysqladmin. The docs state that you need to set the root password with 'mysqladmin -u root -p password'. I enter this command, I am then prompted for the new password and then I get a 'could not connect to local host' error. I think I am missing something here. To make matters worse my Linux experience is pretty limited as well. Thanks, Dan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Solaris 8 Mysql-3.23.44
Keith, It's a little hard to help, since you didn't provide the details of your attempt to install from source. (Compiler? command line for configure? ...) Searching Google groups on 'mysql solaris cross compiling', I found numerous related threads. It appears that everyone who reported this problem was using the gcc binary from sunfreeware. Is that the case for you? I used the sunfreeware gcc binary to build/install gcc from source (2.95.3). Using this, I successfully built mysql-3.23.44 (and it passed all tests) on Solaris 8 sparc (an E450) with the command recommended in the manual http://www.mysql.com/doc/S/o/Solaris.html: CC=gcc CFLAGS=-O3 \ CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti \ ./configure --prefix=/usr/local/mysql --with-low-memory --enable-assembler Michael === Michael Stassen University Information Technology Services Indiana University Bloomington [EMAIL PROTECTED] On Fri, 9 Nov 2001, Keith W wrote: Has anyone been able to get mysql-3.23.44 running on the Sparc platform Solaris 8? I've tried both binary and source distro's with no luck. I've made the recomended changes from the Readme's and Install files as well as searched google high and low. I still get the same failures. From the source distro I get the following durring ./configure SNIP checking return type of sprintf... configure: error: can not run test program while cross compiling From the binary distro I get the following scripts/mysql_install_db SNIP- Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables ld.so.1: ./bin/mysqld: fatal: libz.so.1: open failed: No such file or directory Killed Installation of grant tables failed! I went to zlib.org and got zlib and installed it but that doesn't seem to help. Any clues??? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Newbie MySQL Install Question
Port 3306 is open on the machine. Dan -Original Message- From: Kelley Reynolds [mailto:[EMAIL PROTECTED]] Sent: Friday, November 09, 2001 2:07 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Newbie MySQL Install Question Make sure that the mysql server has been started. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Newbie MySQL Install Question
Dan Tappin wrote: I tried that but it came back with a 'mysqld is running already' error. Actually your command is wrong. If you never set the password before it should be (without the -p): mysqladmin -u root password your?new.password note that 'password' IS the command. Side Question: How can I allow a SSH connection from a remote machine? My linux box is in a locked server room and I would like to administer it from my office via a terminal. I tried via SSH from my MacOS X laptop but I get a secure connection refused message. 1) Make sure you have a recent openssh that fixes the host access bug. 2) Check another list as I don't actually know off the top of my head. Basically you want to install openssh and run /etc/rc.d/init.d/sshd start (on a RH system). And read the man pages about how to limit access. And please direct further questions about ssh elsewhere. Thanks. b. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Newbie MySQL Install Question
I'm getting the sazme exact error, can anyone help us?? -Original Message- From: Kelley Reynolds [mailto:[EMAIL PROTECTED]] Sent: Friday, November 09, 2001 4:07 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Newbie MySQL Install Question Make sure that the mysql server has been started. - Original Message - From: Dan Tappin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, November 09, 2001 4:07 PM Subject: Newbie MySQL Install Question I have some experience with MySQL on MacOS X but that was with a pretty GUI installer. I am now trying to get MySQL installed on Redhat 7.0. I download the client and server versions and followed the install procedures. The problem I am having is with mysqladmin. The docs state that you need to set the root password with 'mysqladmin -u root -p password'. I enter this command, I am then prompted for the new password and then I get a 'could not connect to local host' error. I think I am missing something here. To make matters worse my Linux experience is pretty limited as well. Thanks, Dan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Newbie MySQL Install Question
DOH! :^) Thanks for the tips. Dan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bill Adams Sent: Friday, November 09, 2001 2:26 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Newbie MySQL Install Question Dan Tappin wrote: I tried that but it came back with a 'mysqld is running already' error. Actually your command is wrong. If you never set the password before it should be (without the -p): mysqladmin -u root password your?new.password note that 'password' IS the command. Side Question: How can I allow a SSH connection from a remote machine? My linux box is in a locked server room and I would like to administer it from my office via a terminal. I tried via SSH from my MacOS X laptop but I get a secure connection refused message. 1) Make sure you have a recent openssh that fixes the host access bug. 2) Check another list as I don't actually know off the top of my head. Basically you want to install openssh and run /etc/rc.d/init.d/sshd start (on a RH system). And read the man pages about how to limit access. And please direct further questions about ssh elsewhere. Thanks. b. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Active maintenance of 3.23 tree
Hi, - Original Message - From: DownloadFAST.com [EMAIL PROTECTED] To: Ben Gollmer [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Or does MySQL actively support, debug, fix, and go back and maintain older releases? That is indeed the case. The 3.23 and 4.0 branches co-exist, and we still do 3.23 releases for bugfixes, as you can see in the change log (http://www.mysql.com/doc/N/e/News-3.23.x.html). There have already been 3.23 releases since the release of 4.0.0. The two branches are quite inter-related. Fixes to one are also applied to the other, where appropriate. Do read some more about MySQL's design and development philosophy, there is lots of information about this throughout the manual (http://www.mysql.com/doc/). You can also download a recent version for offline perusal (http://www.mysql.com/documentation/mysql/alternate.html), for instance in HTMLs, or PDF format (if you want to print it for comfy reading). Regards, Arjen. -- MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia ___/ 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: Newbie MySQL Install Question
Dan Tappin writes: I tried that but it came back with a 'mysqld is running already' error. /me silently curses the bad quoting habits that Lookout causes, but knows what the thread was about, and so _please disregard_ this sentence unless you know what I'm talking about. Now where was I? Oh, yes, good, the server is running. I think I know what's wrong. As I recall, you typed mysqladmin -uroot -p password, but then you will be prompted for the old password, and if there is already a password and you enter it, you'll get an error because of a missing argument. The correct thing to type is this: mysqladmin -uroot password=your new password If you're slightly (or more) paranoid and don't want the password to be shown to the rest of the users for a brief moment (and to be stored in your shell history), you could start the mysql client (mysql -uroot) and set the password from there, although it'll still be stored in your .mysqlhistory (or whatever it's called). The bottom line: I don't know of any way to be prompted for your new password. There should be some way to avoid having to enter it on the command line. Does anyone on this list know how? Side Question: How can I allow a SSH connection from a remote machine? You need to install some SSH daemon. I bet there is one or two to choose from on the Redhat CDs. Have a look at what RPMs are named something that starts with ssh or SSH or something like that. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Newbie MySQL Install Question
Ok that worked... but now my SQL utility program returns a 'Host 192.168.0.74 (my local IP) is not allowed to connect to this MySQL server' I assume that I need to get into the grant tables. Is this just via mysqladmin -u root -p??? Thanks, Dan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bill Adams Sent: Friday, November 09, 2001 2:26 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Newbie MySQL Install Question Dan Tappin wrote: I tried that but it came back with a 'mysqld is running already' error. Actually your command is wrong. If you never set the password before it should be (without the -p): mysqladmin -u root password your?new.password note that 'password' IS the command. Side Question: How can I allow a SSH connection from a remote machine? My linux box is in a locked server room and I would like to administer it from my office via a terminal. I tried via SSH from my MacOS X laptop but I get a secure connection refused message. 1) Make sure you have a recent openssh that fixes the host access bug. 2) Check another list as I don't actually know off the top of my head. Basically you want to install openssh and run /etc/rc.d/init.d/sshd start (on a RH system). And read the man pages about how to limit access. And please direct further questions about ssh elsewhere. Thanks. b. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: New fork of MySQL
At 7:45 PM + 11/9/01, Carl Troein wrote: Shankar Unni writes: What are the rules about bundling now? If we distribute a (standalone) copy of MySQL with our product, does that expose our product to the GPL? Or is it just like distributing a copy of Emacs with your OS? (I.e. as long as you make the source available, it doesn't automatically GPL the rest of your OS?) What if the product is designed to work with many databases, but we want to distribute MySQL only as a default database (i.e. it doesn't depend on MySQL for its functionality - it's merely a convenience)? Does that change the GPL liability on our product? Who can answer these questions? I believe the GPL FAQ tries to address these questions: http://www.gnu.org/licenses/gpl-faq.html#MereAggregation Specifically, this may be of interest to you: By contrast, pipes, sockets and command-line arguments are communication mechanisms normally used between two separate programs. So when they are used for communication, the modules normally are separate programs. Compare that with this section of the manual: http://www.mysql.com/doc/U/s/Using_the_MySQL_server_under_a_commercial_license.html Which says: When you distribute a non-GPL application that ONLY works with the MySQL server and ships it with MySQL. This type of solution is actually considered to be linking even if it's done over a network. I believe that bit about even if it's done over the network was added sometime around last December. I'm not quite sure what to make of it, particularly in light of the paragraph from the GPL FAQ. //C -- Carl Troein - CÌrdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Solaris 8 Mysql-3.23.44
Actualy I did provide the things you mention. By stating that I've done all that was suggested in the Readme and Install documentation. That includes the compiler type and version etc and flags. On Fri, 9 Nov 2001, Michael Stassen wrote: Keith, It's a little hard to help, since you didn't provide the details of your attempt to install from source. (Compiler? command line for configure? ...) Searching Google groups on 'mysql solaris cross compiling', I found numerous related threads. It appears that everyone who reported this problem was using the gcc binary from sunfreeware. Is that the case for you? I used the sunfreeware gcc binary to build/install gcc from source (2.95.3). Using this, I successfully built mysql-3.23.44 (and it passed all tests) on Solaris 8 sparc (an E450) with the command recommended in the manual http://www.mysql.com/doc/S/o/Solaris.html: CC=gcc CFLAGS=-O3 \ CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti \ ./configure --prefix=/usr/local/mysql --with-low-memory --enable-assembler Michael === Michael Stassen University Information Technology Services Indiana University Bloomington [EMAIL PROTECTED] On Fri, 9 Nov 2001, Keith W wrote: Has anyone been able to get mysql-3.23.44 running on the Sparc platform Solaris 8? I've tried both binary and source distro's with no luck. I've made the recomended changes from the Readme's and Install files as well as searched google high and low. I still get the same failures. From the source distro I get the following durring ./configure SNIP checking return type of sprintf... configure: error: can not run test program while cross compiling From the binary distro I get the following scripts/mysql_install_db SNIP- Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables ld.so.1: ./bin/mysqld: fatal: libz.so.1: open failed: No such file or directory Killed Installation of grant tables failed! I went to zlib.org and got zlib and installed it but that doesn't seem to help. Any clues??? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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