Poor Manual [Was: Why using filesort here?]
On Sat, Apr 20, 2002 at 05:16:46AM +0200, Benjamin Pflugmann wrote: Hi. [...] According to the MySQL doc (5.2.7, example 5) this should work using the index without any additional sorting. MySQL-3.23.49-max-log running on FreeBSD 4.4-RELEASE I assume you are referring to the online manual? It's documenting the most recent version. According to the change history (Appendix D), this optimization was introduced in version 4.0.2. I see, thanks for that one. This manual is f@#$% up, since it seems like there is no manual for stable versions online or at least some annotations that say in which version a feature was introduced (it's not nice to lookup every change in the ChangeLog). I suspected that the online version reflects the most recent stable not some development version. Regards Sven - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Poor Manual
On Sun, Apr 21, 2002 at 02:44:32PM +0200, Roger Baklund wrote: * Sven Huster This manual is f@#$% up, since it seems like there is no manual for stable versions online or at least some annotations that say in which version a feature was introduced (it's not nice to lookup every change in the ChangeLog). I suspected that the online version reflects the most recent stable not some development version. There is a full documentation in different formats, including HTML, following every distribution. The web based manual is a extra _free_ service provided by MySQL AB. The online docs needs to be of _some_ version, and it is obviously better to have the 'current' version than to have some random version used by some random user... agree? Disagree, if there is only one manual it *must* be, for my understanding, be of the current *stable* version. I do not suspect the random user to be a alpha release user. But one question here: Is it such big problem to put all versions on and create some hyperlinks to them? Seems like this, cause i thought it might be good practice to do so. I also thought it would have been nice to put on a release schedual on the web site. I suggested this to the MySQL AB representant for Germany (as i am located there) but never ever heard from him again. So any comment is better than no comment. Btw: The commuication was initiated by this guy. I agree that the annotations could have been better. But I disagree with the way you communicate this to MySQL AB the rest of the mysql community... :) I took this off-list, feel free to take it back to the list or to reply to me in private. So i say sorry to the community. That's the reason to put it on-list again. I think, I was driven by my bad expireance with the MySQL AB support of which I was a former paying customer. Regards Sven - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 using filesort here?
Hi there, please check below my table: CREATE TABLE `news` ( `news_id` int(11) NOT NULL auto_increment, `provider_id` int(11) NOT NULL default '0', `provider_news_id` char(50) default NULL, `category` char(50) NOT NULL default '', `heading` char(50) NOT NULL default '', `discription` char(255) default NULL, `link` char(255) NOT NULL default '', `source` char(50) NOT NULL default '', `date` timestamp(14) NOT NULL, `provider_date` datetime NOT NULL default '-00-00 00:00:00', PRIMARY KEY (`news_id`), UNIQUE KEY `provider_id` (`provider_id`,`provider_news_id`), KEY `provider_date` (`provider_date`), KEY `provider_news_id` (`provider_news_id`), KEY `category_provider_date` (`category`,`provider_date`) ) TYPE=MyISAM the keys: mysql show index from news; +---+++--+--+---+-+--++-+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | |Collation | Cardinality | Sub_part | Packed | Comment | +---+++--+--+---+-+--++-+ | news | 0 | PRIMARY|1 | news_id | A | |1930 | NULL | NULL | | | news | 0 | provider_id|1 | provider_id | A | |NULL | NULL | NULL | | | news | 0 | provider_id|2 | provider_news_id | A | |NULL | NULL | NULL | | | news | 1 | provider_date |1 | provider_date| A | |1930 | NULL | NULL | | | news | 1 | provider_news_id |1 | provider_news_id | A | |1930 | NULL | NULL | | | news | 1 | category_provider_date |1 | category | A | | 5 | NULL | NULL | | | news | 1 | category_provider_date |2 | provider_date| A | |1930 | NULL | NULL | | +---+++--+--+---+-+--++-+ 7 rows in set (0.00 sec) my query: select * from news where category = 'x' order by category DESC, provider_date DESC; explain query: mysql explain select * from news where category = 'x' order by category DESC, provider_date DESC; +---+--+++-+---+--++ | table | type | possible_keys | key| key_len | ref | |rows | Extra | +---+--+++-+---+--++ | news | ref | category_provider_date | category_provider_date | 50 | const | | 1 | where used; Using filesort | +---+--+++-+---+--++ 1 row in set (0.00 sec) Why is filesort used here? According to the MySQL doc (5.2.7, example 5) this should work using the index without any additional sorting. btw: MySQL-3.23.49-max-log running on FreeBSD 4.4-RELEASE Thanks Regards Sven Huster - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Enabling Logging of Slow Queries
i think the server does not run with privileges to write to /root regards Sven Huster Senior IT Systems Engineer Sven Huster Senior IT Systems Engineer -Original Message- From: Ryan Shrout [mailto:[EMAIL PROTECTED]] Sent: 30 August, 2001 20:51 To: [EMAIL PROTECTED] Subject: Enabling Logging of Slow Queries I have tried to enable slow query logging for a couple days now, with no success. I have tried adding the line to the my.cnf file as well as stoppign the service then starting it with the command line version. Both ways, the server refuses to restart. I have checked the syntax over and over and I think I have it correct! [mysqld] log-slow-queries=/root/slow-queries.log and /etc/usr/bin/safe_mysqld --log-slow-queries=/root/slow-queries.log Either way, the server will not start. I take the line out and it works again. What am I doing wrong? Ryan Shrout Owner - Amdmb.com http://www.amdmb.com/ [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql died with innodb
hi i got this on my mysql server (any ideas?): InnoDB: Assertion failure in thread 234323968 in file os0file.c line 637 InnoDB: We intentionally generate a memory trap. InnoDB: Send a detailed bug report to [EMAIL PROTECTED] mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked agaist is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail key_buffer_size=134213632 record_buffer=2093056 sort_buffer=2097144 max_used_connections=121 max_connections=360 threads_connected=106 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 1604185 K bytes of memory Hope that's ok, if not, decrease some variables in the equation 010615 08:09:27 mysqld ended System: FreeBSD 4.3-RELEASE MySQL: MySQL-Max-3.23.39 over nfs thanks regards Sven - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: auto_increment update
On Thu, Jun 14, 2001 at 07:30:01PM -0500, Paul DuBois wrote: *This message was transferred with a trial version of CommuniGate(tm) Pro* At 1:36 AM +0200 6/15/01, Sven Huster wrote: Hi there can i somehow easily recreate the auto_increment col if is was not correctly set? i just recognized that most rows contain 1 cause the primary key was set on the auto_increment col + another one. so mysql only creates a entry 1 if the other field was equal to another row. Well, that's what's supposed to happen if you have a primary key or unique key on multiple columns where the last column is an AUTO_INCREMENT value. If you want your AUTO_INCREMENT column to have unique values for each row, then you could drop that index and set up a PRIMARY KEY on just the AUTO_INCREMENT column. Actually, I'm not sure I understand what you want to do, so I'm just guessing. If that doesn't answer your question, please clarify. Hi i want to fix the auto_increment col to have unique entries, but if i drop the index there are double entries in for the col, so i dont think it works just by dropping the key. there is data in the table that i dont want to loose. regards sven - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
auto_increment update
Hi there can i somehow easily recreate the auto_increment col if is was not correctly set? i just recognized that most rows contain 1 cause the primary key was set on the auto_increment col + another one. so mysql only creates a entry 1 if the other field was equal to another row. thanks regards Sven Huster - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: load-balancing with NFS
Hi As far as i know, DON'T DO THIS mysql with serveral instances accessing the same database will not work as expected. check http://www.mysql.com/doc/M/u/Multiple_servers.html we run mysql over nfs but only with one instance. seems to be quite stable (db server freebsd - nfs server netapp filer) regards Sven Huster Senior IT Systems Engineer -Original Message- From: Wouter de Jong [mailto:[EMAIL PROTECTED]] Sent: 13 June, 2001 10:21 To: [EMAIL PROTECTED] Subject: load-balancing with NFS *This message was transferred with a trial version of CommuniGate(tm) Pro* Hello, I have an idea about setting up 1 machine that contains the var-directory (RAID5 for backup, etc). Then I mount the var directory from 2 (to explain now :) other servers, via NFS, and run mysqld on those. My question : is this going to work ? I mean, will mysqld allow me to have a shared /var/ directory for all databases inside ? I want load-balancing, cause my server can't handle the pressure good anymore. database-01 IN A 192.168.0.101 database-01 IN A 192.168.0.102 192.168.0.101: (running mysqld) 192.168.0.100:/opt/database/mysql/var /opt/database/mysql/var 192.168.0.102: (running mysqld) 192.168.0.100:/opt/database/mysql/var /opt/database/mysql/var 192.168.0.100: will be NFS-mounted by the 2 mysqld machines And how to configure MySQL with RAID(5) (3 disks, 1 spare) ? Is --with-raid anough, and everything will go automatically good ? I don't have to use other table-types then MyISAM ? Thanks for any input : -- Met vriendelijke groet/With kind regards, Cable Wirelesshttp://www.widexs.nl Wouter de Jong System-Administrator Tel +31 23 5698070 Fax +31 23 5698099 Bijlmermeerstraat 62, 2131 HG HOOFDDORP, NL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Root password forgotten in MySQL
At 15:13 12.04.2001, Sandeep Pachpande wrote: Hi, I have one problem regarding database creation. I am using MySQL on FreeBSD unix os. I have already created two databast in mysql. Now I want to create new database for same but i forgot my root mysql password. Please help me. Thanks in advance. Sandeep I think you can restart the server with --skip-grant-tables and change the password then. regards Sven Huster Senior IT Systems Administrator *BSD, Linux, Solaris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Creating database
Am 17:44 30.03.2001 schrieb Herman Pool: Hi out there, I'm new with MySQL. I have installed Linux 6.0 and MySQL 3.23.33 This happens when I want to create a database: [mysql@nestorix mysql]$ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 49 to server version: 3.23.33 Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql create database java_db; ERROR 1044: Access denied for user: '@localhost' to database 'java_db' mysql \q Bye [mysql@nestorix mysql]$ Why? What did I do wrong? Any ideas? with kind regards, Herman Pool Nibble Consultancy b.v. Oude Amersfoortseweg 22 1213 AD Hilversum The Netherlands tel: +31 (0)35 6217619 fax:: +31 (0)35 6219819 www.nibble.nl have you tried mysql -u root? Normally only user root has all privileges Create others with GRANT, check manual Check http://www.mysql.com/doc/A/c/Access_denied.html http://www.mysql.com/doc/G/R/GRANT.html Hope it helps regards Sven Huster Senior Unix System Administrator *BSD, Linux, Solaris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 over nfs on netapp filer
Hi there, i anybody out there running mysql on a netapp filer as data storage? regards Sven Huster Senior Unix System Administrator *BSD, Linux, Solaris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 over nfs on netapp filer
Am 00:20 30.03.2001 schrieb Joshua Chamas: *This message was transferred with a trial version of CommuniGate(tm) Pro* Sven Huster wrote: Hi there, i anybody out there running mysql on a netapp filer as data storage? Yes, I've done this for a client from a linux server. Worked fine as long as there was only one mysql server accessing the data. The network as 100 Mbs, and the SQL volume was pretty low. Hi, my problem is that now the second time the performance of my f740 goes down every day. i solved the prob with increasing maxfiles (no to the max for the volume). after that the cpu of the filer, which went up from 25% peak to 90% peak in 5 days, goes down again. any ideas why this happens? next time i will have no possiblity to increase maxfiles again. i am sure it depends on mysql cause the other things running there at the moment are doing nearly nothing. thanks regards Sven Huster Senior Unix System Administrator *BSD, Linux, Solaris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: HASH tables...
Am 22:21 19.03.2001 schrieb Dave Juntgen: *This message was transferred with a trial version of CommuniGate(tm) Pro* Hello, I would like to ask those of you who have used temporary hash tables in MySQL version 2.23.x if you have encountered any problems, concurs or known issues. I have been testing it myself and everything sees to working just fine. Please list your thoughts and comments on temporary hash tables. Thanks for your time, --Dave J. --- Dave W. Juntgen [EMAIL PROTECTED] Medical Informatics Engineering, Inc. http://www.mieweb.com/ 4101 W. Jefferson Blvd. Phone: 219-459-6270 Fort Wayne, IN 46804 Fax: 219-459-6271 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php maybe OT: but i am using it for session storage for www application since 2 month, not temp tables. no problem so far. works quite stable and really fast. Sven Huster Senior Unix System Administrator *BSD, Linux, Solaris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 on NetApp Filer - Urgent Problem
Hi there, i dont want to start a thread about MySQL over NFS, i did it and it runs pretty good, but now there is a problem i could not solve. the cpu on the filer goes up and up (15% per day) and i have no idea why. At the moment it hit 70% in peak time (5 min average) Seems to be the database cause everything else stays the same, but not more traffic on the db + if i switch the db of the cpu goes down to 1-5%. any ideas about this? MySQL server: FreeBSD 4-Stable regards Sven Huster Senior Unix System Administrator *BSD, Linux, Solaris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL on NetApp Filer - Urgent Problem
Am 11:22 16.03.2001 schrieben Sie: *This message was transferred with a trial version of CommuniGate(tm) Pro* Hi there, i dont want to start a thread about MySQL over NFS, i did it and it runs pretty good, but now there is a problem i could not solve. the cpu on the filer goes up and up (15% per day) and i have no idea why. At the moment it hit 70% in peak time (5 min average) Seems to be the database cause everything else stays the same, but not more traffic on the db + if i switch the db of the cpu goes down to 1-5%. any ideas about this? MySQL server: FreeBSD 4-Stable regards Sven Huster Senior Unix System Administrator *BSD, Linux, Solaris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php i forgot: nfs ops and network traffic for the filer stayed the same Sven Huster Senior Unix System Administrator *BSD, Linux, Solaris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL on NetApp Filer - Urgent Problem
Am 17:21 16.03.2001 schrieb Jeremy D. Zawodny: *This message was transferred with a trial version of CommuniGate(tm) Pro* On Fri, Mar 16, 2001 at 11:32:42AM +0100, Sven Huster wrote: Am 11:22 16.03.2001 schrieben Sie: *This message was transferred with a trial version of CommuniGate(tm) Pro* Hi there, i dont want to start a thread about MySQL over NFS, i did it and it runs pretty good, but now there is a problem i could not solve. the cpu on the filer goes up and up (15% per day) and i have no idea why. At the moment it hit 70% in peak time (5 min average) Seems to be the database cause everything else stays the same, but not more traffic on the db + if i switch the db of the cpu goes down to 1-5%. any ideas about this? i forgot: nfs ops and network traffic for the filer stayed the same Then it would seem to be a problem with the netapp, wouldn't it? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Jeremy, Finally you where right. I refused to believe it but the filer itself was the problem. it was running out of inodes. damn, sorry for bothering you Sven Huster Senior Unix System Administrator *BSD, Linux, Solaris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php