Re: help on setup
> Hi All, > > First I am brand new to the list. I have looked at all the FAQ and the docs > on mysql.com for this one. > > I have set up mysql before on 2 different machines with no problems so I am > not new at this. > > I am setting up a cluster of servers. 3 web, 1 development and 2 database > servers. I am installing mysql-3.23.47 source on all of the servers which > are all linux. I have set up the server on the database server and clients > on the rest. I have been able to start the server manually and set up the > start up script in /etc/rc.d/init.d with no problem on the database server. > I re-booted the linux server and mysql is now a part of the start up. I > have also installed Data-Dumper, DBI and Msql-Mysql-modules. Ran all tests > successfully. Then ran-all-tests under sql-bench with no problems. When I > use bin/mysqladmin version I get the correct results. > > Here is the problem. Normally I type mysql at the command line and get the > mysql promt. On some of my servers I use mysql -p database and then enter > the password and get the prompt. > > On this new installation when I type mysql I get: > bash: mysql: command not found check to see if mysql is in your path do a find / -name "mysql" and if it shows up add the directory to your path. display your path with 'echo $PATH' add that to your .bash_profile file in your home dir > > I am lost at what I did wrong or where to begin. > > HELP!!! > > Thanks in advance. > Joe > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
help on setup
Hi All, First I am brand new to the list. I have looked at all the FAQ and the docs on mysql.com for this one. I have set up mysql before on 2 different machines with no problems so I am not new at this. I am setting up a cluster of servers. 3 web, 1 development and 2 database servers. I am installing mysql-3.23.47 source on all of the servers which are all linux. I have set up the server on the database server and clients on the rest. I have been able to start the server manually and set up the start up script in /etc/rc.d/init.d with no problem on the database server. I re-booted the linux server and mysql is now a part of the start up. I have also installed Data-Dumper, DBI and Msql-Mysql-modules. Ran all tests successfully. Then ran-all-tests under sql-bench with no problems. When I use bin/mysqladmin version I get the correct results. Here is the problem. Normally I type mysql at the command line and get the mysql promt. On some of my servers I use mysql -p database and then enter the password and get the prompt. On this new installation when I type mysql I get: bash: mysql: command not found I am lost at what I did wrong or where to begin. HELP!!! Thanks in advance. Joe - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Version 4 Schedule RE: Roadmap
On Sat, Jan 19, 2002 at 09:51:39AM +0200, Emmanuel van der Meulen wrote: > Hello all, > > On 19 January 2002 09:28, Jeremy Zawodny wrote; > > > > On Sat, Jan 19, 2002 at 09:22:38AM +0200, Emmanuel van der Meulen wrote: > > > Hello all, > > > > > > To both above topics there have been answers, thank you, but these > > > answers are not clear at all. > > > > That's because preicting the future is rather difficult. It's a fuzzy > > system, so there are few clear answers. > > > > Jeremy > > Then let me phrase my question differently; > > Version 4.1 is earmarked to have 'stored procedures'. So I'm keen to know > when that version is planned for release. > > Some indication based on previous timings would suffice, and I understand > this to be a difficult question, thus in the spirit of all of above, I would > not hold such timing indication against anyone if it turns out before or > later. > > Would MySQL consider to publish something like the following as found at > Netbeans; > http://www.netbeans.org/articles/roadmap.html > and even though their roadmap is not specific, some indication of timing is > derive-able? Hey, that's pretty cool. There's a more low-tech version for MySQL here, I guess: http://www.mysql.com/doc/T/O/TODO.html It's the same idea. > If MySQL policy is to refrain from getting into timing questimates, > it is 100% understandable and acceptable, then please merely state > it as such. Well, I can say that they've given dates in the past, but Murpy's Law tends to get in the way. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 17 days, processed 406,765,826 queries (272/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: permission to lock tables
On Sun, Jan 20, 2002 at 03:46:14AM +, Arne Mueller wrote: > Hi All, > > I've just migrated from mysql-3.12 to 4.0.1 and despite a mysqld crash a > few minutes ago there is a strange problem I've never had in mysql > version 3: > > mysql> lock table .develop.Pseq read; > ERROR 1064: You have an error in your SQL syntax near '.Pseq read' at > line 1 > > Any idea what's wrong here? How about LOCK TABLES: http://www.mysql.com/doc/L/O/LOCK_TABLES.html Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 17 days, processed 406,741,655 queries (272/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
FYI - Kylix2 and MySQL 4.0.1 Max - works
I have this stuff... http://sourceforge.net/projects/directsql I had to make only a very small change in their demok, Char() typecast in one .pas file, globally, and presto... As this is a native .pas type of interface to MySQL I feel comfortable helping fix it no problemo, going forward. FYI - Someone had bitched about this earlier. If you can't figure it out in 10 minutes with this then "you're not worthy" ;)- I'll take a few questions if the guys at the project above are too busy. They have no listserv... it seems... still tinkering around. -AEF -- "When I took off my space suit helmet, I let out a sigh. At least that's what I told the martians..." - Jack Handy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
permission to lock tables
Hi All, I've just migrated from mysql-3.12 to 4.0.1 and despite a mysqld crash a few minutes ago there is a strange problem I've never had in mysql version 3: mysql> lock table .develop.Pseq read; ERROR 1064: You have an error in your SQL syntax near '.Pseq read' at line 1 Any idea what's wrong here? thanks a lot for help, Arne user name is 'bmm', here's the ysql table: mysql> select * from user where user = 'bmm' and Host = 'localhost'; +---+--+--+-+-+-+-+-+---+-+---+--+---++-+++ | Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +---+--+--+-+-+-+-+-+---+-+---+--+---++-+++ | localhost | bmm | 006d987861784d38 | N | N | N | N | N | N | Y | N | Y| Y | N | N | N | N | +---+--+--+-+-+-+-+-+---+-+---+--+---++-+++ mysql> select * from user where user = 'bmm'; ++--+--+-+-+-+-+-+---+-+---+--+---++-+++ | Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | ++--+--+-+-+-+-+-+---+-+---+--+---++-+++ | localhost | bmm | 006d987861784d38 | N | N | N | N | N | N | Y | N | Y| Y | N | N | N | N | | %.lif.icnet.uk | bmm | 006d987861784d38 | N | N | N | N | N | N | Y | N | Y| Y | N | N | N | N | | %.mimcluster | bmm | 006d987861784d38 | N | N | N | N | N | N | Y | N | N| N | N | N | N | N | ++--+--+-+-+-+-+-+---+-+---+--+---++-+++ mysql> select * from host where Host = 'localhost'; +---++-+-+-+-+-+---++-+++ | Host | Db | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +---++-+-+-+-+-+---++-+++ | localhost | % | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | +---++-+-+-+-+-+---++-+++ -- Arne Mueller Biomolecular Modelling Laboratory Imperial Cancer Research Fund 44 Lincoln's Inn Fields London WC2A 3PX, U.K. phone : +44-(0)207 2693405 | fax :+44-(0)207-269-3534 email : [EMAIL PROTECTED] | http://www.bmm.icnet.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
debian smp
hi, I have a new dual cpu server with debian 2.2.19 smp kernel and with 1G ram. my question is: need i apply the threads-patch or the fork-patch from mysql manual 2.6.1 before i compile my kernel and the mysql source? (i use max 500 connections). cheers, ati - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Off-topic: AOL Red Hat???
A front-page article in this morning's Durham (NC, USA) Herald-Sun reports: "AOL Time Warner Inc. is in talks to buy Red Hat Inc., a prominent distributor of a Linux-based computer operating system, an acquisition that would position the media giant to challenge archrival Microsoft Corp., according to sources familiar with the matter." Is this A Good Thing? A Bad Thing? Does it make any difference? Is MySQL AB next? Would that make any difference? What if PostgreSQL, not MySQL, were next? Has this story been widely reported? Is this just a big yawner for the MySQL community? It seems to me that if AOL Time Warner had not only Netscape, but also the whole Linux-Apach-MySQL-PHP brigade in their hands, they would indeed have a powerful armamentarium for challenging Microsoft. I am not currently a Linux or MySQL user. But I have been seriously considering using Linux and MySQL for several personal and speculative projects, as a way of breaking free of bloatware and of corporate hegemony. This news does not seem to me to bode well. How open are the major open source players likely to remain? What do others here (most of whom are clearly more knowledgeable than I) think? Perhaps I should add that Durham, NC, is the home of Red Hat, Inc., and is also my home. --Erv Young - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Help with Database structure..
> We thought about having one massive file for all this data, BUT, we archive > something like 100,000 articles a day. We store articles for 6 months, so > this table would very quickly have 18,000,000 rows. Now, we need to select > a group of articles based on source and date. We also need to select based > on url. Shouldn't be a problem. You can put the whole thing in one table with indexes on the various columns you'll be selecting on. In my experience it's best to tokenise the source, date and url information in a seperate table, thus storing the filename, and three integers. 1st integer - Days since 1st Jan 1980 (for example). If you don't need to store the full datetime field, then don't bother, just store a bigint. 2nd integer - Contains a reference to the source. You can store the actual source name in another table, with this reference number against it. (indexed of course). 3rd integer - Same as #2, but contains a reference number for the url. The url being held elsewhere. This will keep the indexes you lookup on nice and small as they store 3 integer values, (make sure you use the correct type of integer, BIGINT probably). If you always lookup on all three values, an index on all three is best. To lookup articles based on url, you check the url_table for the correct reference number. Then run a query on the big_table looking for that reference number. If you have duplicate urls, only store them once in the url_table, as it's just wasteful otherwise. This also makes for a faster url lookup. > I can only imagine how long it would take to search 18,000,000 rows for a > specific url. Checking the larger table with 18M rows would typically come back in well under a second on a 200Mhz PC, although you need around 80M index cache. If all the urls are unique, this table will become pretty large, and you'll need a fair sized index on that too. I would imagine 300M extra would do the trick, if you only index the first 14 characters or so. These figures scale up pretty well, until you run out of memory, when it all gets a bit sluggish. If that's the case, you can store the different tables on seperate PCs to speed up retrieval. After all -- you aren't doing any JOINs. Where it gets interesting is when you get a request to search all of these documents a la dejanews. It's actually not too difficult to build a very fast word search algorithm, but you'll start to deal with proper BIG tables, with billions of rows... You also need to factor in how reliable you want the system to be, and what your acceptable down-time is BTW - Loading tables over 1M records can be a pain in the arse when you need to recover, and there's no easy way to make it quicker. Russ. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Help with Database structure..
I need some help with a database design question: To summarize our design (I'll spare you a lot of the details.) We collect text files from 20,000 different sources every day. The actual file is stored as a text file. Each source has its own table which contains a list of the text files, date, title, url, etc. We thought about having one massive file for all this data, BUT, we archive something like 100,000 articles a day. We store articles for 6 months, so this table would very quickly have 18,000,000 rows. Now, we need to select a group of articles based on source and date. We also need to select based on url. I can only imagine how long it would take to search 18,000,000 rows for a specific url. Our CURRENT concept is to have one table for each of the 20,000 sources. This way we can just query the matching table for what we need. The problem is that 20,000 tables can be a bit unwieldy for mysql to handle. If you have any ideas, I would love to hear them. Thanks, -N - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: error
Look in archive: http://www.geocrawler.com/archives/3/8/2001/6/0/6076299/ - Original Message - From: "Saulius Kavoliunas" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, January 19, 2002 9:14 PM Subject: error > Hello mysql, > > I have a problem with starting mysql, I'm using winXP and when I try > to start mysql on administrative tools\services I get a box with an > error 1067, nothing else is written :(, what is the problem can you > suggest me waht to do. > Tkank you, > -- > Best regards, > Saulius mailto:[EMAIL PROTECTED] > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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-starting mySQL on a Macintosh
There is a link at http://www.entropy.ch/software/macosx/mysql/ for a startup items package. This will cause MySQL to start when you restart the Mac OS X system. On 1/19/2002 3:07 PM, "Antonio Flores Aldama" <[EMAIL PROTECTED]> wrote: > Hello I need help to startup My SQL in my OS X Server 10.1 box.. > > Some idea of what can I do? > > Greetings > Antonio > > > - > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Jim Dickenson mailto:[EMAIL PROTECTED] Computers for Marketing Corporation http://www.cfmc.com/ eFax: 1-419-791-8924 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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-starting mySQL on a Macintosh
Hello I need help to startup My SQL in my OS X Server 10.1 box.. Some idea of what can I do? Greetings Antonio - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
tunneling mysql client connections with ssh
Hy all, i am just trying to tunnel a mysql client connection via ssh. i am behind a firewall that doesn't let mysql connections through to the outer world. But i can do ssh to the host i want connect to. Tunneling http port 80 with the command ssh [EMAIL PROTECTED] -L 8:localhost:80 gives me access to the http port of the remote machine via port 8 on my local machine. so fra , so good. Then doing # ssh [EMAIL PROTECTED] -L 8:localhost:3306 and connecting to port 8 on my machine with telnet gives me something like Trying ::1... Connected to localhost. Escape character is '^]'. , 3.23.47-log$jhbjhb%kj which i suppose is a prompt from the remote mysql service but then trying to connect to that port with the mysql client i get: # mysql -u username -p -h my.local.hostname -P 8 Enter password: ERROR 2003: Can't connect to MySQL server on 'my.local.hostname' (111) could it be that the mysql client does some extra checks, so maybe the server sends his real hostname or ip address in binary form (thats the signs at the end of the telnet prompt?) and the client realizes that he is not connected to that machine, but to another and breaks up? can i, if this is so, disable that check? I saw some information which said that forwarding mysql connections is possible, but cannot get this to work properly. TIA, henning - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Column Alias Bug??
Steve, Thanks for this. I took another breeze through but didn't spot it - at least what I had in mind. Somewhere I've seen a short pithy summary/list, giving the sequence. Had a flip through the book too, but failed to spot it. Hence the request. Never mind, I'll spot in again one day, and then no one will ask such a question for a clear two weeks!!! Regards, =dn - Original Message - From: "Steve Rapaport" <[EMAIL PROTECTED]> To: "DL Neil" <[EMAIL PROTECTED]> Cc: "Rick Emery" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; "Paul DuBois" <[EMAIL PROTECTED]> Sent: 19 January 2002 21:18 Subject: Re: Column Alias Bug?? > > > Somewhere there's a 'table' or list showing the sequence that the various clauses >are evaluated/executed. Is it > > in the manual or in your book Paul? If it's online, it would be useful to know >where so that a link can be added > > to answers to such questions... > > > > Anyone remember where? > > > This might do, it's in the SELECT syntax. It lists all the > options and mentions that they must be in THAT ORDER. > > http://www.mysql.com/doc/S/E/SELECT.html > > > > -- > Steve Rapaport > still at large > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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: Column Alias Bug??
> Somewhere there's a 'table' or list showing the sequence that the various clauses >are evaluated/executed. Is it > in the manual or in your book Paul? If it's online, it would be useful to know where >so that a link can be added > to answers to such questions... > > Anyone remember where? This might do, it's in the SELECT syntax. It lists all the options and mentions that they must be in THAT ORDER. http://www.mysql.com/doc/S/E/SELECT.html -- Steve Rapaport still at large - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Code Contrib: Simple powerful hotcopy
Dear Group: I have been doing a lot of experimenting with a rather huge database, and I need to recover from mistakes when necessary. I need to make live copies. After spending too long trying unsuccessfully to load DBD::mysql and DBI.pm on my machine (for mysqlhotcopy), and and wasting a lot of time recreating indexes, and a lot of disk space & time using BACKUP, I finally wrote a little shell script to simply copy a large table and indexes from one database to another. It works. 70 lines. I used the hotcopy code as a guide. It's particularly good when you want to copy a huge database before doing a potentially damaging operation like ALTER TABLE to it. My database is already 2G data and 2G index, so I don't have time to fiddle with backup to text. This solution is optimized for big tables. It doesn't require Perl. Other major advantages of this script over backup or mysqlhotcopy include: 1. Creates the new database and table if necessary (but won't overwrite them) +. Puts the copied table into a [possibly new] database and checks it's valid. 2. Simple as hell, 70 lines, at least as fast as hotcopy. 3. No options: Usage line sufficient. 4. Doesn't need perl or DBI or DBD::mysql installed to work 5. Keeps the INDEXES intact (for large tables this is *important*) 6. Hotcopy safe, works with mysqld running, uses LOCK and FLUSH same as hotcopy. 7. Tells you what it's doing, and what the problems are, in English. "How do I copy a table?" is a FAQ, I hope this is a simple answer. The others never worked too well for me. Of course it's a first cut, and I'm not a shell script expert. The if/fi syntax is quite ugly and there's probably a better idiom. There's very little checking or flexibility. Corrections welcome. Steve ---cut here-- #!/bin/bash # copytable olddb newdb table # (c) Steve Rapaport, 2002. # Use as desired, keep the credits intact. set -x fromdb=$1 todb=$2 table=$3 #=== dbdir="/var/lib/mysql/" topath="${dbdir}${todb}/" frompath="${dbdir}${fromdb}/" if [ ! -f $frompath$table.MYD ] ; then echo "source table ($table.MYD) not found"; echo "Usage: $0 fromdb todb table" exit 1 fi if [ -f "${topath}${table}.MYD" ] ; then echo "Please delete destination table files $table.* first"; echo "Won't overwrite" exit 1 fi mysql -e "create database $todb;" if ! mysql -e "use $todb" ; then echo "Can't use or create database $todb" exit 1 fi mysql -e "use $fromdb; LOCK TABLES $table READ; FLUSH TABLES; FLUSH LOGS;" if ! mysqldump -d --add-drop-table $fromdb $table > "$table.sql" ; then echo "schema dump failed"; exit 1 fi if ! mysql -e "use ${todb}; source ${table}.sql;" ; then echo "schema copy failed"; exit 1 fi if ! cp ${frompath}${table}.MYI ${topath}${table}.MYI ; then echo "index copy failed"; exit 1 fi if ! cp ${frompath}${table}.MYD ${topath}${table}.MYD ; then echo "data copy failed"; exit 1 fi if ! cp ${frompath}${table}.frm ${topath}${table}.frm ; then echo ".frm copy failed"; exit 1 fi mysql -e "use $fromdb; UNLOCK TABLES;" echo "Done. Checking the new table." if ! mysql -e "use $todb; check table $table;" ; then echo "table check failed"; exit 1 fi exit 0 -- Steve Rapaport still at large - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: LOAD DATA INFILE Problem
Sorry, my fault, realised the file I was writing for VB was cocking it up. I was adding chr(13) at the end, but the FileSystemObject write method seemed to be putting the carriage return in too, so MYSQL didn't get the newline character. I changed to use the Print command in VB instead just writing Chr(13) at the end of the line, and it works. Hope that helps somebody else, just took me HOURS to figure it out. Well, I will remember it next time!!! Bye for now -Original Message- From: johnlucas-Arluna [mailto:[EMAIL PROTECTED]] Sent: 19 January 2002 20:47 To: [EMAIL PROTECTED] Subject: LOAD DATA INFILE Problem Stupid problem this one no doubt. I have a find in mysql\bin called words.txt The file contains tab separated values with a newline character at the end: 225 20 Residence 73.563.580 187.5 225 20 Planibel195.5 63.579.5289 When I do LOAD DATA LOCAL INFILE "words.txt" INTO TABLE tblftpagewordpos I get lots of warnings and when I query the table, the values are all zeros (when I have a default value set) I am no doubt doing something stupid, but it is doing my head in now. Any help really appreciated. Many thanks John. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
LOAD DATA INFILE Problem
Stupid problem this one no doubt. I have a find in mysql\bin called words.txt The file contains tab separated values with a newline character at the end: 225 20 Residence 73.563.580 187.5 225 20 Planibel195.5 63.579.5289 When I do LOAD DATA LOCAL INFILE "words.txt" INTO TABLE tblftpagewordpos I get lots of warnings and when I query the table, the values are all zeros (when I have a default value set) I am no doubt doing something stupid, but it is doing my head in now. Any help really appreciated. Many thanks John. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
error
Hello mysql, I have a problem with starting mysql, I'm using winXP and when I try to start mysql on administrative tools\services I get a box with an error 1067, nothing else is written :(, what is the problem can you suggest me waht to do. Tkank you, -- Best regards, Saulius mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Why does DISTINCT take so long time ??
Anvar had some very good explanations about the time it takes to run the queries. ##Here are some work arounds: ##If you need to have these columns (mot, date, numresponse) in the group by clause, ##try putting an index on each of them to speed it up. mysql>>alter table searchhardwarefr3 >>add index idx_mot(mot); ##... etc. ##this should speed up the 1st query for sure. ##if the second query is still slow, (i'm not sure about the exact details of mysql, so this might or might not make a difference) ## put the results from your first query into a temporary table (mytemp): mysql>>create temporary table mytemp >> SELECT COUNT(*) as count, numreponse FROM searchhardwarefr3 >>GROUP BY mot,date,numreponse HAVING count>1 LIMIT 100; ## then explicitly index both columns mysql >>alter table mytemp >> add index idx_count(count); mysql >>alter table mytemp >> add index idx_numresponse(numresponse) ##and then run the following query mysql>>select distinct count, numresponse from temp (mytemp) ##by the way, I don't think the HAVING clause is redundant. Good Luck. - Original Message - From: "Anvar Hussain K.M." <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, January 19, 2002 2:27 AM Subject: Re: Why does DISTINCT take so long time ?? > Hi, > > Yes, the reason for the time difference is that for distinct query, as > Sinisa noted, it has to reiterate. > > For the output to generate, first the rows have to be ordered ( in this > case since count(*) is given every column > should be present in the comparison.) using a temp table (or any other > mechanism to keep rows ordered). > > For the first query also there should be an intermediate temp table to > order rows but here it is only necessary to > consider the columns in the group by clause. > > Considering these, a rough and primitive estimate of the time taken to > execute the query can be found. > > Suppose the average length of a row is 300 bytes and the three columns in > the group by clause takes > 30 bytes average. Then if the first query takes 15 minutes, the second > query will take 150 minutes. > > > This may not be the real scenario with mysql but some thing similar. > The having clause I feel, is redundant. the 15 min for the first qurey > seem too much, perhaps indexing might > help. > > Hope somebody else has a better explanation. > Anvar. > > At 02:41 AM 18/01/2002 +0100, you wrote: > >Hi, > > > >I've notice sometimes DISTINCT clause take a really high amount of time to > >remove duplicates whereas it should be really quick (I assume it should be > >;)) > > > >My first query is : > > > >mysql> SELECT COUNT(*) as count, numreponse FROM searchhardwarefr3 GROUP BY > >mot,date,numreponse HAVING count>1 LIMIT 100; > > > >it returns : > > > >+---++ > >| count | numreponse | > >+---++ > >| 2 | 111239 | > >| 2 | 108183 | > >| 2 | 73 | > >| 2 | 111383 | > > > >| 2 | 111239 | > >| 2 | 111760 | > >| 3 | 109166 | > >| 2 | 09 | > >| 3 | 109166 | > >+---++ > >58 rows in set (14 min 51.15 sec) > > > >My second query is : > > > > > >mysql> SELECT DISTINCT COUNT(*) as count, numreponse FROM searchhardwarefr3 > >GROUP BY mot,date,numreponse HAVING count>1 LIMIT 100; > > > >Well I'm not enough patient to wait, but when I stop the querie, it has been > >running for more than 3500 seconds... (and more than 45mn in 'Removing > >duplicates' state...) > > > >mysql> EXPLAIN SELECT DISTINCT COUNT(*) as count, numreponse FROM > >searchhardwarefr3 GROUP BY mot,date,numreponse HAVING count>1 LIMIT 100; > >+---+---+---+-+-+--+--- - > >-+--+ > >| table | type | possible_keys | key | key_len | ref | > >rows| Extra| > >+---+---+---+-+-+--+--- - > >-+--+ > >| searchhardwarefr3 | index | NULL | PRIMARY | 75 | NULL | > >2026032 | Using index; Using temporary | > >+---+---+---+-+-+--+--- - > >-+--+ > >1 row in set (0.00 sec) > > > >mysql> EXPLAIN SELECT COUNT(*) as count, numreponse FROM searchhardwarefr3 > >GROUP BY mot,date,numreponse HAVING count>1 LIMIT 100; > >+---+---+---+-+-+--+--- - > >-+--+ > >| table | type | possible_keys | key | key_len | ref | > >rows| Extra| > >+---+---+---+-+-+--+--- - > >-+--+ > >| searchhardwarefr3 | index | NULL | PRIMARY | 75 | NULL | > >2026032 | Using index; Using temporary | > >+---+---+---+-+--
Problem Upgrading
Friday, January 18, 2002, 10:36:46 PM, you wrote: Ieoen> I had 3.23.41 installed. It came with Rh7.2. I had some mistakes in initial Ieoen> start up . So I thought i would reinstall it. I downloaded the rpm for Ieoen> 3.23.47. And ran the rpm installation. I am not sure if it did the whole Ieoen> install. Now I have a safe_mysqld and 2 other mysqld process runinng. But I Ieoen> can't start using mysql. If i try to uninstall it says package is not Ieoen> install. And if i try to install it says it is already installed. I am not Ieoen> sure whats wrong here. Please, show us the output of the following: rpm -qf /usr/lib/libmysql* rpm -q MySQL It shall give us more information about your problem. -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
no umlauts in mysql client
sascha, Friday, January 18, 2002, 12:18:43 PM, you wrote: sm> help! I upgraded to the most recent version of mysql client (3.23.47) under sm> SuSE linux 7.1. sm> now the client does not accept any 8-bit characters any more - any special sm> character input is discarded (from the keyboard and from the clipboard as sm> well). how can I change that? Looks like it's not a MySQL problem, but looks like a question of readline/locale. sm> sascha mantscheff -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Installing of MySQL on redhat 7,2
Nasser, Friday, January 18, 2002, 12:01:02 PM, you wrote: NR> By the way I run my application which should run on MySQL, I get the error NR> message which includes that libmysqlclient.so.6 NR> could not find!!! NR> What I have down wrong? How did you install MySQL? Have you installed the rpm packages downloaded from mysql site or you have compiled the server on your own? NR> Nasser -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
console hang.
Larry, Thursday, January 17, 2002, 12:45:49 AM, you wrote: LB> I am running MySQL on Redhat and when I use the script that comes with MySQL LB> (mysql.server) or safe_mysqld the command runs and starts the server. LB> However; the prompt does not return. I have to switch consoles. (bash) LB> Does anyone have any idea how I can avoid this? (the script from the rpm is LB> not an option in this particular case). Run it in background: safe_mysqld & -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ID in table
DL, Friday, January 18, 2002, 1:25:11 AM, you wrote: DN> KISS principle! ... You can also examine the -A option of myisamchk. -A, --set-auto-increment[=value] Force auto_increment to start at this or higher value If no value is given, then sets the next auto_increment value to the highest used value for the auto key + 1. DN> =dn -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL and PHP on a RaQ Server
James, Friday, January 18, 2002, 8:11:09 AM, you wrote: JR> We have a RaQ4i 400MHz server with 512MB of RAM running PHP4.03p1 JR> and MySQL 3.23.43 if memory serves correctly. JR> We are looking at bringing on a client who uses 1 MySQL database JR> and PHP to host a news site similar to Slashdot, the OpenSource app he JR> uses is called GeekLog, if anyone has heard of it. JR> He gets about 5000 unique visitors a day and about 10 page JR> views per day. JR> My question is - what is the opinion that our server can handle JR> this site. In mind and experience there should be no problem with a site JR> as this. You should tell us more about the load that your scripting software generates on MySQL server and on the system in general. We at Ensita use a couple of Cobalt RaQ that work under a similar load, MySQL is used heavily and they perform perfectly. Generaly, I can presume that 100,000 views per day (using MySQL) should run perfectly on that hardware. JR> James Riordon -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL on RH7.0 Alpha permissions don't work? Second try
John, Saturday, January 19, 2002, 12:18:26 AM, you wrote: JD> I tried putting passwords on the grant statements, but I can't log in as a JD> different user using a password -- it never authenticates. And as any other JD> user than root it won't let me access any tables. Are you sure you are running a client with the right options? Foe example, if you set a password for user zuka and do something like mysql -uzuka buka it will never allow you to access database "buka", because you have to supply the password: mysql -uzuka -pkuka buka or mysql -uzuka -p buka In the second case, client will ask you for the password from the console. JD> Am I doing something wrong, Provide us with the examples of GRANT statements you use so we could provide you with more help. JD> John Dudeck -- Egor Egorov [EMAIL PROTECTED] MySQL AB / Ensita.net For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / / /|_/ / // /\ \/ /_/ / /__ /_/ /_/\_, /___/\___\_\___/ <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
can login only as root
Hello Luie, Saturday, January 19, 2002, 11:03:23 AM, you wrote: LdS> REALFROM: "Luie delos Santos" <[EMAIL PROTECTED]> LdS> HOUR: 2002011911 LdS> hello all, LdS> I recently installed mysql on a RedHat7.2 box. I was able to login to it as *root*. LdS> I created another user (user1) using "GRANT all to user1 identified by 'password';", but when I tried to login as *user1*, access denied message is displayed. You should set privileges (global, database etc) by using ON. You can find more information about it here: http://www.mysql.com/doc/A/d/Adding_users.html -- Victoria Reznichenko [EMAIL PROTECTED] MySQL AB / Ensita.net For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / / /|_/ / // /\ \/ /_/ / /__ /_/ /_/\_, /___/\___\_\___/ <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Premature end of script
Hi, I'm trying to use phpmyadmin 2.2.3 on a debian 2.2 box with Mysql 3.22.32, php 3.0.18, and apache 1.3.9-14. After installing phpmyadmin per Documentation.txt and creating the standard user, I get a "premature end of script headers: /usr/lib/cgi-bin/phpadmin/index.php3" This is from the /var/log/apache/error.log file. Any ideas what might be going wrong? TIA. -- David S. Jackson[EMAIL PROTECTED] =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Nirvana? That's the place where the powers that be and their friends hang out. -- Zonker Harris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 *HAD* a problem running the setup - but found a solution, thought i'd share it with you!
Hi! I downloaded your mySQL for windows (32-bit). I unziped the files into the directory named just the same as the file had (mysql-3.23.47-win). When i then tried to run the setup.exe i got an error saying "can't run 16-bit windows program". This was an extremely irritating thing, since i then couldn't develop anything at home - and had to travel to work in order to be able to do anything (even just slight modifications). So i just let things be that way and went on to work in order to do some work. A few weeks (today that means) later i thought about installing it again, and finding out what was the problem. After some time scanning through your searchable database i couldn't find anything about this problem. I had also been looking for info on the net, and many pages came up with suggestions like replacing certain dll-files in the %systemroot\system32\-directory (Unacceptable for me). After a while of searching, skimming through newsgroups i found this site on the net. http://www.rsc-east-midlands.ac.uk/officeapps.htm My problem was solved. Long filenames brought the whole "unable to run 16-bit windows-programs"-issue to light. The solution for me was to just rename the directory which the setup-files was in to something short like "a", and then everything run perfectly. Some systems info: -Windows 2000 professional edition -mysql-3.23.47-win Now running perfect. I thought i'd let you know, since this was a problem *HARD* to find solutions to. Have a nice day. -Odd Arne- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Full Text Search with and without index - possible bug?
Hi! On Jan 19, Gordan Bobic wrote: > Hi! > > The part that I thought could be a "bug" was the one you didn't quote. I still remeber that part, there's no need to explain it again :-) > > It's not a "known" bug as the code is rather new. > > Can you create a test case for this ? > > Possibly, but it could be difficult as my data set changes daily. It looks > like a problem that ought to be replicable with fairly generic data. You've said that SELECT with index returns ~20 rows, and w/o 7 rows. Create a table with those rows and send it to me... I hope that will be a test case. > Incidentally, could it be caused by the fact that I am using a multi-column > FTS? Could this be where the operation without the index is falling over? It could, of course. But it shouldn't. And the probability is low. > Another thing - is it possible to combine a FULLTEXT index with another > column/index to achieve a multi-column index with FTS capabilities? It just > seems wrong that FTS should take a fixed amount of time regardless of what > other indexable restrictions are made on the data set, and if there is a > limitation on 1 index per table per query, then the multi-column index is the > only way around it. In boolean FTS, fulltext index works almost like normal index, that is the list of documents is NOT computed in advance. as for combined index, it's possible to do, I think. But I have some plans of changing index structure. This will result in faster searches and smaller index files. With this index structure it would be impractical to introduce compined indexes. Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: can login only as root
check out the docs at http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm inistration.html#GRANT Thanks, Sherwin Ang Web Programmer / Systems Administrator Alchemy Solutions http://www.alchemy.com.ph Creative. Technology. Tridel Technologies, Inc. 7th Floor Hanston Building Emerald Ave., Ortigas Center Pasig City Tel: (632) 634-5141/ (632) 634-5140 Fax: (632) 634-5139 - Original Message - From: "Gerald R. Jensen" <[EMAIL PROTECTED]> To: "Luie delos Santos" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Saturday, January 19, 2002 10:21 PM Subject: Re: can login only as root > Luie: > > Here is a grant script we use ... check the syntax against the query you > were using: > > USE mysql; > > GRANT ALL PRIVILEGES ON *.* TO username@localhost IDENTIFIED BY 'userpwd'; > GRANT ALL PRIVILEGES ON *.* TO username@"%" IDENTIFIED BY 'userpwd'; > GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY > 'userpwd'; > GRANT RELOAD,PROCESS ON *.* TO username@localhost; > > Be careful ... the use created with this script has full access to all > databases on your server. > > Gerald Jensen > > - Original Message - > From: "Luie delos Santos" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Saturday, January 19, 2002 3:03 AM > Subject: can login only as root > > > hello all, > > I recently installed mysql on a RedHat7.2 box. I was able to login to it as > *root*. > I created another user (user1) using "GRANT all to user1 identified by > 'password';", but when I tried to login as *user1*, access denied message is > displayed. > I've tried *flush privileges* but I'm still unable to login as user1. > > hope somebody can shed some light on this. > thanks in advance... > > > luie > > __ > www.edsamail.com > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Version number after '!' : what is the good syntax ?
Hi, Ok, it's 40001 according to #define MYSQL_VERSION_ID 40001 ;) Regards, Jocelyn - Original Message - From: "Fournier Jocelyn [Presence-PC]" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, January 19, 2002 3:03 PM Subject: Version number after '!' : what is the good syntax ? > Hi, > > I'm wondering what is the good syntax with version number after '!' with > MySQL 4 : > > Should I use : > > /*!40001 SQL_CALC_FOUND_ROWS */ > > or > > /*!401 SQL_CALC_FOUND_ROWS */ > > Thank you ! > > Regards, > > Jocelyn Fournier > Presence-PC > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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: can login only as root
Luie: Here is a grant script we use ... check the syntax against the query you were using: USE mysql; GRANT ALL PRIVILEGES ON *.* TO username@localhost IDENTIFIED BY 'userpwd'; GRANT ALL PRIVILEGES ON *.* TO username@"%" IDENTIFIED BY 'userpwd'; GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY 'userpwd'; GRANT RELOAD,PROCESS ON *.* TO username@localhost; Be careful ... the use created with this script has full access to all databases on your server. Gerald Jensen - Original Message - From: "Luie delos Santos" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, January 19, 2002 3:03 AM Subject: can login only as root hello all, I recently installed mysql on a RedHat7.2 box. I was able to login to it as *root*. I created another user (user1) using "GRANT all to user1 identified by 'password';", but when I tried to login as *user1*, access denied message is displayed. I've tried *flush privileges* but I'm still unable to login as user1. hope somebody can shed some light on this. thanks in advance... luie __ www.edsamail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Version number after '!' : what is the good syntax ?
Hi, I'm wondering what is the good syntax with version number after '!' with MySQL 4 : Should I use : /*!40001 SQL_CALC_FOUND_ROWS */ or /*!401 SQL_CALC_FOUND_ROWS */ Thank you ! Regards, Jocelyn Fournier Presence-PC - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Full Text Search with and without index - possible bug?
Hi! > > 1.1) Full Text Search can, according to the manual, be performed without > > the FTS index, but it is slower. > > 1.2) MySQL can only use 1 index per join per table. > > > > => This means that if I specify the USE INDEX (some_non_fulltext_index), > > the FTS will be performed without the index, and this will only work IN > > BOOLEAN MODE. Otherwise, MySQL returns an error, complaining about the > > lack of an index. > > Gordan, you're right. It's the way it was expected to behave :-) The part that I thought could be a "bug" was the one you didn't quote. The problem I am experiencing is that the boolean MATCH/AGAINST FTS WITH an FTS index doesn't match the results returned WITHOUT the FTS index when the same query/parameters are used. I don't know if this is the case when there is no index at all (it would be difficult to test, too). I just found this out by using the USE INDEX clause to switch to using different indices. Incidentally, I have set the fts minimum word length to 1, so the cause of this is not the fact that the index skips some values. In fact, it is the unindexed search that seems to get things wrong. The indexed FTS verifiably works on my data set. The un-indexed FTS demonstrably doesn't work as expected. The unindexed search returns much fewer values. > It's not a "known" bug as the code is rather new. > > Can you create a test case for this ? Possibly, but it could be difficult as my data set changes daily. It looks like a problem that ought to be replicable with fairly generic data. Incidentally, could it be caused by the fact that I am using a multi-column FTS? Could this be where the operation without the index is falling over? Anyway, from what I can see, the indexed FTS works great. The unindexed FTS doesn't (both in boolean mode). Another thing - is it possible to combine a FULLTEXT index with another column/index to achieve a multi-column index with FTS capabilities? It just seems wrong that FTS should take a fixed amount of time regardless of what other indexable restrictions are made on the data set, and if there is a limitation on 1 index per table per query, then the multi-column index is the only way around 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: Column Alias Bug??
> >Is this a bug? I can't find an answer to this question in FAQs or archives. > > > >CREATE TABLE aa ( a int); > >INSERT INTO aa VALUES (1),(2),(3),(2),(4),(5),(1),(6),(3); > > > >the following : > >mysql> select a,count(*) as z from aa where z>1 group by a; > > > >displays this error: > >ERROR 1054: Unknown column 'z' in 'where clause' > > > >Why isn't z recognized as a column identifier? > > As others have pointed out, your query requires a HAVING rather than a > WHERE. What hasn't been pointed out, which is worth knowing, is that > column aliases cannot be used in *any* WHERE clause. ...because the WHERE clause is processed first, and the SELECT evaluated later. Similarly GROUP BY is processed before HAVING (which is why that suggestion works). Somewhere there's a 'table' or list showing the sequence that the various clauses are evaluated/executed. Is it in the manual or in your book Paul? If it's online, it would be useful to know where so that a link can be added to answers to such questions... Anyone remember where? =dn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Understanding throughput with JDBC
Hello all, Could anyone please assist me to understand this. I want to understand where the time is going to and whether there is something I can do about it, with the following query when using JDBC; Here is the table declaration; CREATE TABLE Memberships ("EMAIL CHAR(60) NOT NULL, NAME CHAR(50) NOT NULL, MIDDLEINITIAL CHAR(1) NULL, SURNAME CHAR(50) NOT NULL, NEWSLETTER CHAR(1) NOT NULL, USERNAME CHAR(15) NOT NULL, PASSWORD CHAR(15) NOT NULL, COUNTRY CHAR(50) NOT NULL, PRIMARY KEY (EMAIL)) TYPE=InnoDB" MySQL table memberships has 110080 rows. Here is the select statement I use with JDBC; SELECT * FROM memberships ORDER BY EMAIL Same select statement I use from the MySQL 'commandline'; mysql> select * into outfile 'mysql20.txt' from memberships order by email limit 20; My observations; A. When running the SQL from the MySQL 'commandline' with above statement this is the response; mysql> select * into outfile 'mysql20.txt' from memberships order by email l imit 20; Query OK, 110080 rows affected (1.27 sec) B. When running the exact same select as stated above in a java program using JDBC, from when issuing, ResultSet rs = stmt.executeQuery(query) until the java program gets control back, to create the resultset, takes 23-25 seconds; I ran program several times. Please advise whether this is to be expected, or whether I could alter anything to get comparable results via JDBC as with MySQL 'commandline'? Kind regards Emmanuel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
job application
Dear Sir/Madam, I am looking for a telecommute job as a Java or C Programmer anywhere in the world. As a first step, I enlose my resume. I will consider any offer from you. I am ready even to pay part of my future income to you, if you find me a job. Thank you in advance. Sincerely Yours, Alex Duras. RESUME Alex Duras 7A Grygorenko St., apt.83 02068 Kyiv, Ukraine phone: +380 44 572 4082 email: [EMAIL PROTECTED] Objective: To obtain a position of a Java or C Programmer. Professional experience: March 1998 - till now Java Programmer at Infocom JV (Kyiv, Ukraine). My main duties include: java programming for the Billing Department and the Infocom ISP. I usually program in Java, C/C++, Perl. I also dealt with the Oracle management and SQL. February 1996 - April 1998 Head of the Technical Department at Infocom JV (Kyiv, Ukraine). My responsibilities include: supervising of the Technical Department which run national data public X.25 and Frame Relay network and the Internet. February 1994 - January 1996 Network Engineer at Infocom JV (Kyiv, Ukraine). I dealt with the data public X.25 and Frame Relay network UKRPACK and the Internet: network configuration, installation and design, technical customer support. July 1993 - January 1994 Research Engineer at Kyiv State University (the laboratory of optical signal processing). My responsibilities include: special digital electronics hardware design and testing, programming in the x86 Intel assembler and C languages. Education: September 1988 - June 1993 Kyiv State University, Radiophysics Department. Master Degree in Radiophysics and Electronics. September 1978 - June 1988 Secondary School in Zashkiv, Ukraine. Diploma of Secondary Education. Languages: Fluent English, Ukrainian, Russian, initial French. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
job application
Dear Sir/Madam, I am looking for a telecommute job as a Java or C Programmer anywhere in the world. As a first step, I enlose my resume. I will consider any offer from you. I am ready even to pay part of my future income to you, if you find me a job. Thank you in advance. Sincerely Yours, Alex Duras. RESUME Alex Duras 7A Grygorenko St., apt.83 02068 Kyiv, Ukraine phone: +380 44 572 4082 email: [EMAIL PROTECTED] Objective: To obtain a position of a Java or C Programmer. Professional experience: March 1998 - till now Java Programmer at Infocom JV (Kyiv, Ukraine). My main duties include: java programming for the Billing Department and the Infocom ISP. I usually program in Java, C/C++, Perl. I also dealt with the Oracle management and SQL. February 1996 - April 1998 Head of the Technical Department at Infocom JV (Kyiv, Ukraine). My responsibilities include: supervising of the Technical Department which run national data public X.25 and Frame Relay network and the Internet. February 1994 - January 1996 Network Engineer at Infocom JV (Kyiv, Ukraine). I dealt with the data public X.25 and Frame Relay network UKRPACK and the Internet: network configuration, installation and design, technical customer support. July 1993 - January 1994 Research Engineer at Kyiv State University (the laboratory of optical signal processing). My responsibilities include: special digital electronics hardware design and testing, programming in the x86 Intel assembler and C languages. Education: September 1988 - June 1993 Kyiv State University, Radiophysics Department. Master Degree in Radiophysics and Electronics. September 1978 - June 1988 Secondary School in Zashkiv, Ukraine. Diploma of Secondary Education. Languages: Fluent English, Ukrainian, Russian, initial French. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Suse V/S Redhat - mysql performance difference.
Hi list, I have 2 servers 1 running redhat 7.2 and the other running suse 7.3. the hardware config is : RH7.2: Fast desktop (IDE HDD/128 MB memory PIII 550 MHz). Suse 7.3: Low end server (Ultra SCSI 2, PIII 850 MHz, 256 MB RAM). Now i expect to see the suse server go faster than RH, but i am having the reverse happening. The RH server returns a query about 5 times faster. For eg: on RH: mysql> select straight_join docm.document_id, docm.document_title, docm.document_date, sources.source_name, cliptypes.cliptype, byline.byline from keywords, documents_7 as docm use index (PRIMARY), dockeys_7 as dock, sources, cliptypes, byline where keywords.keyword_id=dock.keyword_id and docm.document_id=dock.document_id and docm.document_source_id = sources.source_id and docm.document_cliptype_id = cliptypes.cliptype_id and docm.document_byline_id = byline.byline_id and ( keywords.keyword="assam" ) order by docm.document_id; | 219401 | WRONG POLICIES ARE THE BANE OF ASSAM | 2000-08-21| THE HINDUSTAN TIMES (DELHI)| N. A.| PARASHAR, UTPAL| +-+--+---++--++ 276 rows in set (2.78 sec) same query on suse: | 219401 | WRONG POLICIES ARE THE BANE OF ASSAM | 2000-08-21| THE HINDUSTAN TIMES (DELHI)| N. A.| PARASHAR, UTPAL| +-+--+---++--++ 276 rows in set (7.06 sec) This happens for all queries. Of course the data is the same on both systems. The mysqld is what comes with the distrib. (RH - mysql-3.23.22-6 / Suse - mysql-3.23.41-17). I did try to use the official binaries from mysql.com but, i get the same results on both systems. I will probably install Redhat on the suse system, but can anyone think of why this happens and what can i do to improve the response. As of now the rowcount for the largest table is 221165. Has anyone else noticed similar results? Thanks for any replies Jatin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Compiling problem: error in type_info1.hh
Hi! Try adding : using namespace std; Are you using VC++ 6.0 ??? That port is not intended for other versions of VC++. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Compiling problem: error in type_info1.hh
I downloaded these files but there are still some errors when I run the program: Thanks for the help Configuration: prog - Win32 Debug Compiling... prog.cpp c:\sqlplus\include\type_info1.hh(39) : warning C4800: 'int' : forcing value to bool 'true' or 'false' (performance warning) c:\sqlplus\include\type_info1.hh(159) : warning C4800: 'unsigned int' : forcing value to bool 'true' or 'false' (performance warning) c:\sqlplus\include\type_info1.hh(172) : warning C4800: 'int' : forcing value to bool 'true' or 'false' (performance warning) c:\sqlplus\include\type_info1.hh(176) : warning C4800: 'int' : forcing value to bool 'true' or 'false' (performance warning) c:\sqlplus\include\type_info1.hh(180) : warning C4800: 'int' : forcing value to bool 'true' or 'false' (performance warning) c:\sqlplus\include\type_info1.hh(184) : warning C4800: 'int' : forcing value to bool 'true' or 'false' (performance warning) c:\sqlplus\include\const_string1.hh(70) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\const_string1.hh(70) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\null1.hh(26) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\null1.hh(26) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\null1.hh(32) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\null1.hh(32) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\null1.hh(38) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\null1.hh(38) : error C2872: 'ostream' : ambiguous symbol c:\program files\microsoft visual studio\vc98\include\strstream(52) : error C2039: 'openmode' : is not a member of 'ios' c:\program files\microsoft visual studio\vc98\include\ios.h(106) : see declaration of 'ios' c:\program files\microsoft visual studio\vc98\include\strstream(52) : error C2061: syntax error : identifier 'openmode' c:\program files\microsoft visual studio\vc98\include\strstream(54) : error C2039: 'openmode' : is not a member of 'ios' c:\program files\microsoft visual studio\vc98\include\ios.h(106) : see declaration of 'ios' c:\program files\microsoft visual studio\vc98\include\strstream(54) : error C2061: syntax error : identifier 'openmode' c:\program files\microsoft visual studio\vc98\include\strstream(91) : error C2629: unexpected 'class std::ostrstream (' c:\program files\microsoft visual studio\vc98\include\strstream(91) : error C2238: unexpected token(s) preceding ';' c:\program files\microsoft visual studio\vc98\include\strstream(109) : error C2629: unexpected 'class std::strstream (' c:\program files\microsoft visual studio\vc98\include\strstream(109) : error C2238: unexpected token(s) preceding ';' c:\sqlplus\include\datetime1.hh(18) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\datetime1.hh(18) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\datetime1.hh(43) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\datetime1.hh(43) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\datetime1.hh(66) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\datetime1.hh(66) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\datetime1.hh(75) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\datetime1.hh(75) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\datetime1.hh(97) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\datetime1.hh(97) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\datetime1.hh(112) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\datetime1.hh(112) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\datetime1.hh(117) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\datetime1.hh(117) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\set1.hh(52) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\set1.hh(55) : see reference to class template instantiation 'MysqlSet' being compiled c:\sqlplus\include\set1.hh(52) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\set1.hh(55) : see reference to class template instantiation 'MysqlSet' being compiled c:\sqlplus\include\set1.hh(61) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\set1.hh(61) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\manip1.hh(23) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\manip1.hh(24) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\manip1.hh(27) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\manip1.hh(45) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\manip1.hh(50) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\manip1.hh(50) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\manip1.hh(52) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\manip1.hh(52) : error C2872: 'ostream' : ambiguous s
Re: Porting from MS SQL to MySQL
You could design your app using a database abstraction so you can port your app from one database to another. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
can login only as root
hello all, I recently installed mysql on a RedHat7.2 box. I was able to login to it as *root*. I created another user (user1) using "GRANT all to user1 identified by 'password';", but when I tried to login as *user1*, access denied message is displayed. I've tried *flush privileges* but I'm still unable to login as user1. hope somebody can shed some light on this. thanks in advance... luie __ www.edsamail.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
Help: Innodb warning operating error number 3
I got this error when I was trying to get INNODB working on my machine: I am using mysql version 4.0.1 alpha = Regards, Investorclb __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: innodb and vbulletin 1.1
I work for vBulletin and have some input on this. First off, you really should look into upgrading to version 2.2.x, as not only are there many new features, but there have been a number of performance enhancements done that may help your situation. You also might want to take a look at the vBulletin forums ( http://www.vbulletin.com/forums/ ) for MySQL & Server Configuration, where we might be able to give some more tuning help specific to vBulletin. I know a few sites that are using InnoDB, or have tested using InnoDB tables. vBulletin will run just fine in this configuration, however there is one issue many users have run into: InnoDB does not store table counts, so select count(*) from table-name statements can take a while, and there three of these statements on the main index.php page for the total number of users, threads and posts. There are some workarounds you could look into, read this thread for more information on that: http://www.vbulletin.com/forum/showthread.php?s=&threadid=36219 >From the InnoDB manual: InnoDB does not keep internally a count of rows in a table, which would actually be somewhat complicated because of multiversioning. To answer a query SELECT COUNT(*) FROM T InnoDB has to scan one index of the table, which will take some time if the table is not entirely in the buffer pool. To get a fast count you have to use a counter table you create yourself, and let your application update it according to the inserts and deletes it does. A way to eliminate the bottleneck posed by lock waits for the counter is to create a whole set of counters. The application can choose one at random each time. To get the count, just sum the counters: SELECT SUM(counter_column) FROM your_counter_table. Hope this helps, Chris Schreiber -Original Message- From: Byron Albert [mailto:[EMAIL PROTECTED]] Sent: Friday, January 19, 2001 3:03 AM To: [EMAIL PROTECTED] Subject: innodb and vbulletin 1.1 Hello, I have a few questions. First I work on a very high traffic site that uses vbulletin 1.1 to run its bb. The bb is very high traffic around 60-200 concurrent users. We are starting to run into some serious locking issues, and I am thinking about converting the high use tables(maby all) to innodb. My first question is will this break anything in the application layer? Second we may be moving this to a new serve where I could have 6+ disks. I have done some testing and found that after all the importing into innodb all the data is around 1gb. Would it be helpful to add these extra disks creating 1+gb raw partition on each one to spread the io across the disks and controllers. And how does innodb distribute the data through the table spaces? Thanks for any help Byron [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
innodb and vbulletin 1.1
Hello, I have a few questions. First I work on a very high traffic site that uses vbulletin 1.1 to run its bb. The bb is very high traffic around 60-200 concurrent users. We are starting to run into some serious locking issues, and I am thinking about converting the high use tables(maby all) to innodb. My first question is will this break anything in the application layer? Second we may be moving this to a new serve where I could have 6+ disks. I have done some testing and found that after all the importing into innodb all the data is around 1gb. Would it be helpful to add these extra disks creating 1+gb raw partition on each one to spread the io across the disks and controllers. And how does innodb distribute the data through the table spaces? Thanks for any help Byron [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