Innobase on WinNt.
I am trying to install Mysql (3.23.36) on windows NT. I have installed the software, but cannot find how to use the Innobase table structure. Can someone please point me in the right direction (apart from installing it on something else). I have tried putting in the setting from the 8.7.2 INNOBASE startup options chapter in the manual, exchanging the linux paths for windows paths, but the service dies unexpectedly whenever I try to start it. thanks in advance len.
concatenate with group by
Hi, All. Do you know how make concatenate of column values (TEXT type) with group by other column? I need do it use only SQL query!!! For clearness, please, take a look on example. I have table: idc1c2 11"apple" 21"plum" 31"vine" 42"apple" 52"pear" 63"vine" 73"ananas" I wash get a temporary: t1t2 1"apple", "plum", "vine" 2"apple", "pear" 3"vine", "ananas" Best regards. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Starting Mysql with system
How can i put mysql to start with my system, i´m worcking with RedHat Linux 7.0 , and nowadays i´m starting the daemon manually trhough mysqld. Thanks in advance, Gabriel. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 MS Access
Hi, I am trying to access a Mysql database from MS Access using the Mysql ODBC driver. I can connect to the database and open the table and browse the data but I can not modify anything (the file is read only). The username I am connecting with have Select, Insert, Update and Delete permissions. Any idea on how I can open the database in Read/Write mode? Thanks Ramzi
Is updating a subsection of a field possible?
I've got a table with 500+ records in it now... and I need to update just a small section of one of the fields (an URL) to change a parameter on it... I know I'm probably going to be told "NO", but I thought I'd ask before I go start writing a program to do this Is it possible to update just a small subsection of a field automagically via SQL and the mysql query language extensions? I'd need some sort of regex intervention, such that the text that surrounds the text I need to change isnt affected - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Q: How to set autocommit in my.cnf and etc
Hi, everybody, I have a couple of quesitons 1. From the mysql manual, if I want to use 'autocommit=0', it says that I type 'set autocommit=0' and this only applies to a session. So, when I want to back up data using 'shell>mysql datablse < data.sql', do I need to add 'set autocommit=0' at the begining of data.sql? 2. Is there a way to change the default value of 'autocommit' whenever mysql starts? Like 'set-variable = autocommit = 0' in 'my.cnf'. Also, how can I know the mysql is using 'autocommit=0 or 1' since there is no mysql command that shows that particular info, or since 'set autocommit=0 or 1' is session based, we reset the 'autocommit' at each session. Yours Ryu
Termcap not found in install...
Hi everybody... I'm pretty much trying to install MySQL by compiling the sources (I like to avoid RMPs as much as I can), but I'm getting an error at configure time. This is what I do: # ./configure --prefix=/usr/local/mysql --with-mysqld-user=mysql There is some output and then it stops at the following line: checking for termcap functions library... configure: error: No curses/termcap library found Obviously the termcap functions library is missing in my system, but I've got no clue as to what it is, what it does and where to find it... Can anyone help? Best regards. __ Pedro Fonseca ([EMAIL PROTECTED]) Mob.: (+351)964598357 http://www.pedrofonseca.com ADETTI/ISCTE (Instituto Superior de Ciências do Trabalho e da Empresa) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
possible deady
I am curious if any knows of possible deadlock conditions that can ocurr when using the lock tables command in MySQL when you are referenceing multiple tables? _ Get your FREE download of MSN Explorer at http://explorer.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: most viewed
Sorry...I guess I just figured it'd be something a little more than SELECT and LIMIT. I was trying stuff like this: SELECT views,count(*) AS MAXIMAL FROM $mysql_table GROUP BY views ORDER BY MAXIMAL DESC LIMIT 10 My bad. tyler -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of --==[bMan]==-- Sent: Sunday, April 01, 2001 4:37 PM To: Tyler Longren Cc: MySQL List Subject: Re: most viewed You should definitely read up the manual. If you don't do this, will not do you homework and simply expect an answer handed down to you, you might get disappointed. Question you have asked is like MySQL 101. To get you started this time, however, here it is: select * from table bands order by views DESC limit 2; Tyler Longren wrote: > I've got a table that contains a list of bands. There's a field named > views. This field contains how many times each band's page has been viewed. > > Ex: > id artist views > 1 No names6 > 2 WISH10 > 3 Deftones45 > > What's the SQL to select the top 2 most viewed bands(which would be WISH & > Deftones)? I've tried a few things, but haven't gotten anything to work > correctly for me. Thanks. > > Tyler Longren > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Bolek, URL: http://www.bolek.com URL: http://slash.bolek.com e-mail: [EMAIL PROTECTED] ICQ: 4086197, Address: 402905326 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: mysqld daemon ended
"Graham Nichols" <[EMAIL PROTECTED]> wrote: > I have installed mysql 3.22.32 on our local intranet for testing and it > runs ok. Then, I transferred the same .tar file to a linux server of the > 'net and installed as before. When I run ./scripts/safe_mysqld & > from the mysql-3.22.32 directory I get a message telling me that the > daemon has started and then it appears to die with a 'mysqld > daemon ended' message. Does anyone know what may be wrong > please? You have to be logged in to the server as the user that MySQL is installed to run as. If mysql is installed to run as root, then 'su root', if as user mysql, 'su mysql'. It could be a different problem all together, but that's my first guess. -- Steve Werby President, Befriend Internet Services LLC http://www.befriend.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: most viewed
You should definitely read up the manual. If you don't do this, will not do you homework and simply expect an answer handed down to you, you might get disappointed. Question you have asked is like MySQL 101. To get you started this time, however, here it is: select * from table bands order by views DESC limit 2; Tyler Longren wrote: > I've got a table that contains a list of bands. There's a field named > views. This field contains how many times each band's page has been viewed. > > Ex: > id artist views > 1 No names6 > 2 WISH10 > 3 Deftones45 > > What's the SQL to select the top 2 most viewed bands(which would be WISH & > Deftones)? I've tried a few things, but haven't gotten anything to work > correctly for me. Thanks. > > Tyler Longren > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Bolek, URL: http://www.bolek.com URL: http://slash.bolek.com e-mail: [EMAIL PROTECTED] ICQ: 4086197, Address: 402905326 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: most viewed
"Tyler Longren" <[EMAIL PROTECTED]> wrote: > I've got a table that contains a list of bands. There's a field named > views. This field contains how many times each band's page has been viewed. > > Ex: > id artist views > 1 No names 6 > 2 WISH 10 > 3 Deftones 45 > > > What's the SQL to select the top 2 most viewed bands SELECT artist FROM my_table ORDER BY views DESC LIMIT 2 -- Steve Werby President, Befriend Internet Services LLC http://www.befriend.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqld daemon ended
Hi, I have installed mysql 3.22.32 on our local intranet for testing and it runs ok. Then, I transferred the same .tar file to a linux server of the 'net and installed as before. When I run ./scripts/safe_mysqld & from the mysql-3.22.32 directory I get a message telling me that the daemon has started and then it appears to die with a 'mysqld daemon ended' message. Does anyone know what may be wrong please? Many thanks, Graham
most viewed
I've got a table that contains a list of bands. There's a field named views. This field contains how many times each band's page has been viewed. Ex: id artist views 1 No names6 2 WISH10 3 Deftones45 What's the SQL to select the top 2 most viewed bands(which would be WISH & Deftones)? I've tried a few things, but haven't gotten anything to work correctly for me. Thanks. Tyler Longren - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[Fwd: Odd mysqlhotcopy behavior]
I'm still having bizarre problems with mysqlhotcopy and I'm wondering if there is an underlying problem MySQL 3.23.36 (happened on 35 too) mysqlhotcopy v1.11 RH 6.1, updated as necessary Perl 5.6.0 DBI/DBD up to date. I backup around 10 databases with a total of 188 tables. Most tables are small except for one with around 55,000 rows. I've done a bunch more debugging with no luck. When mysqlhotcopy runs as a cron job at night as the mysql userid, it usually fails when it tries to lock the tables. Most of the time I get "do failed "Incorrect information in file" at line 381 (which is the LOCK TABLES command) The table it fails at is never the same. It seems random across various databases, even one which never gets used. After I see the cron log, I'll login, switch to my mysql user (which the cron job runs as too), and run the backup manually. It'll work fine!! But the backup fails again that night. For kicks, I modified mysqlhotcopy to LOCK the tables one database at a time since that is where the error occurs. I thought maybe there was a problem locking 188 tables at once (Though I realize SQL commands can be very very long) I took this modified script and had it run 4 times via cron, five minutes apart. Generally, the first occurance would run fine. But the next 3 would all fail. Once in a while I'll get an Error 126, unable to open file, which seems to be some type of table problem that was caused by a previous failed hotcopy attempt. At this point, even a manual backup fails on the same table. myisamchk -r fixes that, then the hotcopy will run once via cron, then start failing again with teh 'Incorrect Information in file' on a random table. >From the command line, the problem rarely if ever occurs. It takes about 10 seconds to backup all the files. So I sat down, did a myisamchk -r for good measure, and ran the backup dozens of times from a Xterm. (Hit up arrow, hit enter) It ran fine, didn't fail once. This makes no sense. How could running mysqlhotcopy from cron (as the same user I used above when it worked) make a difference? I've checked to see if maybe there was something else fighting with the backup - nope - no cron jobs scheduled near it. I thought maybe something I was running was corrupting a table - but it happens across the databases, once of which isn't used anymore. Has anyone else seen this type of behavior? It has me totally confused and ready to switch back to mysqldump. mysqldump would work fine - never had a problem with it. What exactly does 'Incorrect information in file' indicate anyway? Still plugging away Mike Original Message Subject: Odd mysqlhotcopy behavior Date: Fri, 30 Mar 2001 10:28:28 -0500 From: Mike Baptiste <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] For the longest time, I'v ebacked up my various MySQL databases using mysqldump. However, I hated restarting the database each night (on a few occasions it would restart but the databases could not be accessed until it was restarted again) Plus I think mysqlhotcopy is a more elegant solution. OK, so I recently went ahead and tried using mysqlhotcopy. Nothing fancy. /usr/bin/mysqlhotcopy -u user -p pw --allowold --flushlog [names of 10 databases] /home/mysql/backup When I run it manually, it works great. Locks all the tables, copies the files, wonderful. However, I'm having trouble running it via a cron job. My /etc/crontab entry runs the above command as user mysql (which has full access to all the database files and the backup directory) I always get the same error: DBD::mysql::db do failed: Incorrect information in file: './slash/sortcodes.frm' at /usr/bin/mysqlhotcopy line 381. It occurs on different lines and on different tables in different databases. When I run the command manually the next morning - it works MOST of the time though sometimes I do get the Incorrect information error then too - trying again usually fixes it. I've myisamchk'ed the tables - thinking that might be the issue - nope. I searched the archives - couldn't really find anything about this. Its a RedHat 6.2 box running 3.23.35 and now .36 I'm using Perl 5.6.0 and my version of DBI and DBD are up to date according to CPAN. Any ideas? Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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/unsubsc
Mail Marshall E-mail Viruses - An Apology
Hi, My apologies on behalf of Mail Marshall for the flood of virus alerts. They started at 0:01 on1/4/01 NZST (hmm... maybe there is something there), and continued until our support staff re-installed the latest virus ID file - we didn't have time to find out why it happened. So, to those of you that sent sympathetic messages saying "Its probably not your fault, but " - thanks and apologies. To those of you that sent Unsubscribe messages - Come the .com revolution, you'll first against the wall and blasted with my "Super-Charged Geek Blaster with rocket launcher attachment". (What do you mean, I missed the .com revolution ???) Back to work. Quentin Bennett Transport Systems Division Infinity Solutions web http:\\www.infinity.co.nz mailto:[EMAIL PROTECTED] Phone : +64 9 358 9720 Fax : +64 9 309 4142 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How do I
I am using the following command to import date. The teldirt.txt file is just a list of commands to remove 4 existing tables in the TelDir database and then the SQL statements to add the tables and new data... mysql --user=root --password=** TelDir < d:\database\teldirt.txt >> d:\database\import.log The import works fine and I am happy with it. However, there is a problem if there are any users using the database with MySQL itself. It won't allow me to remove the tablles and import data (Sharing error?) To get round this, before I run the mysql command I have i n my batch file the commands NET STOP MYSQL NET START MYSQL Immediately before the mysql import line. This makes sure that there are no active connetions. Question is, is there a way to remove all active connections to the database without having to run the NET STOP and START commands as they seem a bit harsh, and if someone reconnects to the database straight away, the mysql import still fails! Any help appreciated Richard
Re: Restore from Logs?
It seems to me that you have misunderstood the manual. As you have pointed out yourself, you are running MysQL on Windows platform. The syntax you are referring below is for UNIX/Linux systems... (shell> means current shell in use your system and the rest are commands available on UNIX systems). Lee Jenkins wrote: > Hello, > > I'm having some trouble understanding the syntax for populating a backup > with logged updates. In the manual, is says: > > shell> ls -1 -t -r file_name.[0-9]* | xargs cat | mysql > > I'm running MySQL on Win98 and Win2000. I've tried using the syntax above, > but to no avail. > Any help would be greatly appreciated as I am in a crunch. > Lee Jenkins -- Bolek, URL: http://www.bolek.com URL: http://slash.bolek.com e-mail: [EMAIL PROTECTED] ICQ: 4086197, Address: 402905326 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Still can't get it working.
"Tatti" <[EMAIL PROTECTED]> wrote: > Edit the `bin/mysqlaccess' script at approximately line 18. Search for a > line that looks like this: > $MYSQL = '/usr/local/bin/mysql';# path to mysql executable" > > Guess what? Ther is no such line in my mysqlaccess.conf The file it's referring to isn't myslaccess.conf. It's 'mysqlaccess' in the source code's 'scripts' directory. > For some strange reason following the manual step by step doesn't work. > Half the commands come back with a "no such command" How familiar are you with working from the commandline in Linux/Unix? Without more details it's hard to say what the problem is, but if the program you're trying to access isn't in your PATH then you need to either call it using its full path or be in the directory containing the program and call it like this: ./program. > As far as I know the machine I'm installing on is running > RedHat(I think) and apache. To get better help from the list please find out what your operating system is (name and version). > I have full rights to my account and can do what I want in it. Are you the root user of the server? If you don't have root user privileges you may not be able to install MySQL. > [stage1@butler .www]$ chown -R root mysql > chown: mysql: Operation not permitted You are logged in as user 'stage1'. To change the ownsership of the mysql directory to 'root' you have to be logged in as the user 'root'. Also, it's a better idea to install MySQL to run as a non-privileged user (like 'mysql', which you may have to create) than 'root' for security reasons, in which case you'd be doing a 'chown -R mysql mysql' in that step. If you're not able to login as the user root, I suggest contacting the system administrator of the server to see if there's a MySQL install available to you or if MySQL can be installed for you to use. I don't think you'll be able to install MySQL otherwise. -- Steve Werby President, Befriend Internet Services LLC http://www.befriend.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Restore from Logs?
Hello, I'm having some trouble understanding the syntax for populating a backup with logged updates. In the manual, is says: shell> ls -1 -t -r file_name.[0-9]* | xargs cat | mysql I'm running MySQL on Win98 and Win2000. I've tried using the syntax above, but to no avail. Any help would be greatly appreciated as I am in a crunch. Lee Jenkins
RMON to mySQL
Hi All, I am interested if anyone knows of any product which can grab RMON II data from switches and store the data into a mySQL database? Thanks Solomon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
what is this message ?!
Hi , I have posted a message to list that contain a question about a message the shows for one of my clients that a Cistron radius patched to authenticate through MySQL . this is message is : 010401 22:18:51 Aborted connection 6202623 to db: 'morva' user: 'radius ' (Got an error reading communication packets) that I have always get this in my error log . I have several connection to MySQL server through diffrent kind of programs such as perl , php , c , ... but this happen only for this client . what is this message mean and when this error ocured ?! what is the solutions the get this fixed !? -- Regards / Seyyed Hamid Reza/WINDOWS FOR NOW !!/ / Hashemi Golpayegani / Linux for future , FreeBSD for ever / /Morva System Co. / - / / Network Administrator/ [EMAIL PROTECTED] , ICQ# : 42209876 / === - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Still can't get it working.
Lindsay and Eric has been ever so helpful but no matter what I do I can't get this installation right. I am no on my sixth re-installation. In the manual it says: "If you would like to use mysqlaccess and have the MySQL distribution in some nonstandard place, you must change the location where mysqlaccess expects to find the mysql client. Edit the `bin/mysqlaccess' script at approximately line 18. Search for a line that looks like this: $MYSQL = '/usr/local/bin/mysql';# path to mysql executable" Guess what? Ther is no such line in my mysqlaccess.conf Do I really need to change that? For some strange reason following the manual step by step doesn't work. Half the commands come back with a "no such command" As far as I know the machine I'm installing on is running RedHat(I think) and apache. I have full rights to my account and can do what I want in it. Anyway - so if I skip the above thing and go on (I'm trying to install as I type this so you lot is gatting a first hand look at how I'm doing - screendumps and all.) Running the mysql_install_db gives the following: [stage1@butler mysql]$ scripts/mysql_install_db Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: ./bin/mysqladmin -u root -p password 'new-password' ./bin/mysqladmin -u root -h butler -p password 'new-password' See the manual for more instructions. Please report any problems with the ./bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at https://order.mysql.com Fine. No problem here, from what I can tell. So I keep going. Step 9 in the manual. [stage1@butler .www]$ chown -R root mysql chown: mysql: Operation not permitted Ok, forget it. Moving on to next step. [stage1@butler mysql]$ Starting mysqld daemon with databases from /home/stage1/.www/mysql-3.23.32-pc-linux-gnu-i686/data rm: cannot unlink `/tmp/mysql.sock': Operation not permitted 010401 18:13:05 mysqld ended [1]+ Donebin/safe_mysqld --user=mysql Okej. That doesn't work either. So I guess I give up yet again, remove everything and start all over for the seventh time. *sighing desperatly* Tatti - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RMON to mySQL
Hi All, I am interested if anyone knows of any product which can grab RMON II data from switches and store the data into a mySQL database? Thanks Solomon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Choosing between the three types of transaction-supporting table
Hi folks, The recent additions of storage handler for transaction-supporting table confuses us. From what I read on the list, Innobase is generally much faster than BerkeleyDB. But I can live with slower speed since my application will not be expecting high rates. It is reliability and tested product which I am more concerned with. Could somebody provide a general overview and comparison of BerkeleyDB, Innobase, and the upcoming Gemini? Regarding speed, space efficiency, recovery, and memory footprint. Better still if it ends with the practical advice on choosing between them (i.e.: you should choose Innobase if ..., but use BerkeleyDB if ...). I believe that is also a manual/FAQ material. Thanks in advance! Steve - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Dual Processor and MySQL !
> -Original Message- > From: Hamid Hashemi Golpayegani [mailto:[EMAIL PROTECTED]] > Sent: domingo, 01 de abril de 2001 15:07 > To: Nemholt, Jesper Frank; [EMAIL PROTECTED] > Subject: RE: Dual Processor and MySQL ! > > > Hi , > > Thank you very much for your compelete description about > MySQL and multi > processor platforms . > According to your mail if I have several connection to my SQL > server and I > have more than 1 CPU and installed the SMP on my machine the MySQL > performance will be better than a single CPU and If I have > only 1 connection > to my SQL server then single and dual CPU are not import for > this situation Correct. > . > So it is ok ! cause I have about 200 concurrence connection to my SQL > machine and it seems that be better to have more that one CPU . Yes, with more than one concurrent query running, you'll benefit from SMP. Exactly how much depends on many things (table locking is one critical thing with MySQL), but with 200 concurrent connections, you'll get pretty close to 100% benefit, which means if you go from one 500 MHz to two 500 MHz CPUs, you'll get close to twice the performance. ...but the execution time of one singlethreaded SQL on a idle machine will not get faster. To get this you need a faster CPU, not more CPUs. Try to run a "show processlist" every now & then and see how many connections you have, and how many of those are active or sleeping/waiting for a table to be unlocked. Depending on database design, you might find, with MySQL, that most of the time is spent waiting for a table to unlock. There are some guidelines in the MySQL manual on how to avoid this (by inserting into temporary tables and the likes), but most of these solutions will get rather ugly. Other SQL servers ike Oracle lock on row level which is _much_ better. I hope this will come in MySQL soon. > About other SQL servers that you said support multi > processing alone without > depending on OS and SMP . Can you tell me them ?! > I thinks that Oracle would be one of them . All of them (well, those I know) rely on the SMP support in the operating system. In fact, the SQL server doesn't need to know about SMP (or how many CPUs the machine have). The only place I know of where the SMP support is built into the application is on MacOS nad applications like Adobe Photoshop. This is a very ugly hack and only made because Adobe needed the speed, there were SMP hardware, but the OS didn't support SMP. What is important is whether the SQL server is multithreaded or not (and support the thread implementation on the operating system it runs on). If it is multithreaded and dedicate a thread to every query, or maybe is even able to split a query into several threads, then it'll utilize whatever SMP is offered by the OS. Beware that many OSes don't support SMP or have pathetic thread support. You'll find fairly good SMP & thread support in most commercial unix versions (Solaris, HP-UX, Tru64, AIX etc.), Windows NT/2000 and recent versions of Linux. Most of the *BSD implementations, and Windows 9x doesn't support SMP, and some not even threads. What I don't know about MySQL is how well (if at all) it is able to split up a query into several threads. On a SQL server like Oracle I know that complex queries with several subselects and things like that are divided into several threads which improve performance alot on a SMP machine. The DBAs where I work use this extensively when they create their SQL statements in order to get the most performance out of the machine (and the query result as fast as possible). Most of your production machines have more than 8 CPUs, so there is alot to win on them. -- Un saludo / Venlig hilsen / Regards Jesper Frank Nemholt Unix System Manager Compaq Computer Corporation Phone : +34 699 419 171 E-Mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Cannot find mysql.sock
Michael Tefft wrote: > > Can't connect to local MySQL server through socket > '/var/lib/mysql/mysql.sock' (2)' Check that mysqld is running and that > the socket: '/var/lib/mysql/mysql.sock' exists! Is mysqld up and running? If yes, try starting the server next time with the option "--socket=/var/lib/mysql/mysql.sock". cu, Bernhard -- see me today at http://www.geo.tu-freiberg.de/~fuerst/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SQL Import on MySQL
There are a number of syntax differences between MSSQL and MySQL ... if you are going to be doing a lot of conversion work, grab a copy of MS's help file so you can compare it to the functions in the MySQL manual. To answer you question more directly, MySQL doesn't need the dbo (database object) prefix, and treats autoincrementing and setting the primary key differently. This script creates your tables in MySQL: CREATE TABLE Articles ( ArticleID int (1) NOT NULL auto_increment, Title char (100) NOT NULL , AuthorID int NOT NULL , Date datetime NOT NULL , SubjectID int NOT NULL , Pages int NOT NULL , Image text NOT NULL , ManuID int NULL , Publish char (10) NULL , BuyText char (100) NULL , BuyLink text NULL, PRIMARY KEY (ArticleID) ); CREATE TABLE Authors ( AuthorID int (1) NOT NULL auto_increment, AuthorName char (50) NOT NULL , AuthorEmail char (50) NOT NULL, PRIMARY KEY (AuthorID) ); G. Jensen - Original Message - From: "Ryan Shrout" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, April 01, 2001 2:28 AM Subject: SQL Import on MySQL I have a SQL file that I generated on MS SQL 7. The file looks like this (a portion): CREATE TABLE [dbo].[Articles] ( [ArticleID] [int] IDENTITY (1, 1) NOT NULL , [Title] [char] (100) NOT NULL , [AuthorID] [int] NOT NULL , [Date] [datetime] NOT NULL , [SubjectID] [int] NOT NULL , [Pages] [int] NOT NULL , [Image] [text] NOT NULL , [ManuID] [int] NULL , [Publish] [char] (10) NULL , [BuyText] [char] (100) NULL , [BuyLink] [text] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[Authors] ( [AuthorID] [int] IDENTITY (1, 1) NOT NULL , [AuthorName] [char] (50) NOT NULL , [AuthorEmail] [char] (50) NOT NULL ) ON [PRIMARY] GO I am using phpMyAdmin and attempting to run the SQL query on the database that has already been created. I get the error: MySQL said: You have an error in your SQL syntax near '[dbo].[Articles] ( [ArticleID] [int] IDENTITY (1, 1) NOT NULL , [Title] [cha' at line 1 What is the syntax problem that I am missing? And can I make MS SQL output the sql file in the correct way? Ryan Shrout Athlonmb.com Production Manager http://www.athlonmb.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
Re: limit text column
you probably want something like: select substring_index( mycolumn, ". ", 2) from mytable; Regards, Gary "SuperID" Huntress === FreeSQL.org offering free database hosting to developers Visit http://superid.dyndns.org:8080/freesql/index.php - Original Message - From: "Mike Baerwolf" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, April 01, 2001 12:38 PM Subject: limit text column Hello, Is it possible to limit the output of a text column to the first two sentences in the column? Thanks for the Help, Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
limit text column
Hello, Is it possible to limit the output of a text column to the first two sentences in the column? Thanks for the Help, Mike
Re: Mac OS X
There is a binary tarball on www.mysql.com that works on the retail release of Mac OS X. I have also built from the .36 source, but that requires editing one line of source code. Here are directions: http://www.mysql.com/doc/M/a/Mac_OS_X_Public_Data.html Look at the user comments. The line in mysqld.cc is actually 1241 in .36, IIRC. Once you make that edit mysql compiles and runs. I haven't done extensive benchmarking, but it does work. HTH. Zach On Saturday, March 31, 2001, at 02:29 PM, Erick Schmidt wrote: > Can anyone tell me where to get and how to install MySQL on the new Mac > OS X? > > Thanks for your help!! > > [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
Cannot find mysql.sock
I have installed the latest stabel MySQL server and client. When I try to run mysqladmin, I keep getting the following message: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! When I switch to /var/lib/mysql there is a linux.err file but no mysql.sock. I started mysqld with safe_mysqld & Any help would be greatly appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Patch: Slow 'sending data'
Hi! While extending our multi-thread test suite for MySQL I noticed a that during some conditions simple SELECT's could sometimes take a long time. I found the problem to be the following: If you do a FLUSH TABLE, CHECK table or REPAIR table, tables that are waiting for a lock will have to reopen the table. In this case the next query (just the next) will not use any keys for the table that was forced to be reopened. If you are using any of the above commands (for example mysqlhotcopy uses FLUSH TABLES) this could explain why you sometimes get a query that takes a long time performance (in this case MySQL will do a table scan). Here is a patch that fixes this: (It will be in 3.23.37) = sql/sql_base.cc 1.72 vs edited = *** /tmp/sql_base.cc-1.72-26630 Tue Mar 27 13:05:48 2001 --- edited/sql/sql_base.cc Sun Apr 1 15:04:18 2001 *** *** 940,962 goto end; } ! tmp.key_length=table->key_length; ! tmp.in_use=table->in_use; ! tmp.used_keys=tmp.keys_in_use; ! tmp.reginfo.lock_type=table->reginfo.lock_type; ! tmp.version=refresh_version; ! tmp.next=table->next; ! tmp.prev=table->prev; ! ! /* This list copies varibles set by open_table */ tmp.tablenr=table->tablenr; - tmp.tmp_table= table->tmp_table; tmp.used_fields=table->used_fields; tmp.const_table=table->const_table; tmp.outer_join= table->outer_join; tmp.null_row= table->null_row; tmp.status= table->status; tmp.grant= table->grant; if (table->file) VOID(closefrm(table));// close file, free everything --- 941,967 goto end; } ! /* This list copies variables set by open_table */ tmp.tablenr=table->tablenr; tmp.used_fields=table->used_fields; tmp.const_table=table->const_table; tmp.outer_join= table->outer_join; tmp.null_row= table->null_row; + tmp.maybe_null= table->maybe_null; tmp.status= table->status; + tmp.keys_in_use_for_query=tmp.used_keys=tmp.keys_in_use; + + /* Get state */ + tmp.key_length= table->key_length; + tmp.in_use= table->in_use; + tmp.reginfo.lock_type=table->reginfo.lock_type; + tmp.version=refresh_version; + tmp.tmp_table= table->tmp_table; tmp.grant= table->grant; + + /* Replace table in open list */ + tmp.next=table->next; + tmp.prev=table->prev; if (table->file) VOID(closefrm(table));// close file, free everything (Basicly the above just sets one variable that we had forgot to set, but the diff is a bit bigger than actually needed as I also added some comments and rearranged the variable setting to be a little more logical) Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Locked tables while "Sending data" !?
Hi! > I just come across this old email: > > On Thu, Mar 09, 2000 at 03:14:28PM +0200, sinisa wrote: > > > > This happens in the case when mysql does not have to create temporrary > > tables in order to obtain result set, but is reading from the live > > table itself. > > > > Changing a table during such reading operation would break things. > > It would be helpful if there was a simple efficient way to force > the use of a temporary table for these situations. > > Using an ORDER BY would be inefficient. Would adding "HAVING 1=1" > (without a group by) work? > > Tim. The SELECT option SQL_BUFFER_RESULT will force MySQL to create a temporary table for the results and unlock the other tables involved in the query as soon as all rows have been fetched. Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
add index on text
Hi Can anyone help me? I'm trying to put an index on a text column named invariant. I tried this command : alter table cinvariant add index (invariant); I got this: ERROR 1170: BLOB column 'invariant' used in key specification without a key length ok so I tried this alter table cinvariant add index (invariant(375)); I got this: ERROR 1089: Incorrect sub part key. The used key part isn't a string or the used length is longer then the key part i don't get it the length should be something around 2^16. Please give me an advice! Thanks in advance dacian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Id of row
Thank for the answer to my last question, but now I have another one : I'm searching for a data type that represents the Id of a row. Like rowid in oracle database. rowid is a string that represents block id, row id and more ( I really don't remember the exact arguments). Does mySql contains that kind of type/representation ? Thanks, Einav. Einav Lavi-Pdut software engineer [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: Dual Processor and MySQL !
Hi , Thank you very much for your compelete description about MySQL and multi processor platforms . According to your mail if I have several connection to my SQL server and I have more than 1 CPU and installed the SMP on my machine the MySQL performance will be better than a single CPU and If I have only 1 connection to my SQL server then single and dual CPU are not import for this situation . So it is ok ! cause I have about 200 concurrence connection to my SQL machine and it seems that be better to have more that one CPU . About other SQL servers that you said support multi processing alone without depending on OS and SMP . Can you tell me them ?! I thinks that Oracle would be one of them . -- Regards / Seyyed Hamid Reza/WINDOWS FOR NOW !!/ / Hashemi Golpayegani / Linux for future , FreeBSD for ever / /Morva System Co. / - / / Network Administrator/ [EMAIL PROTECTED] , ICQ# : 42209876 / === -Original Message- From: Nemholt, Jesper Frank [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 01, 2001 3:25 PM To: 'Hamid Hashemi Golpayegani'; [EMAIL PROTECTED] Subject: RE: Dual Processor and MySQL ! > -Original Message- > From: Hamid Hashemi Golpayegani [mailto:[EMAIL PROTECTED]] > Sent: sábado, 31 de marzo de 2001 17:09 > To: [EMAIL PROTECTED] > Subject: Dual Processor and MySQL ! > > > Hi , > > Sorry for this question may be this question asked before but > I can't find > it . > I want to know that an SMP Dual CPU machine for a MySQL > server is better > that a single CPU machine ?! > I mean is the MySQl use the both CPU's for processing or not ? > and how much affect on the responding and which parameters > are going better > in this case ?! As said by other, if the OS supports SMP, MySQL will benefit from this, since MySQL is a threaded application. However, a singlethreaded SQL (ie. a SQL MySQL is unable to break up into several parts) will only run on one CPU at a time, and this is the situation you will see most of the time. In fact I'm not even sure MySQL does try to break up SQLs into >1 threads, but I know other database servers do. A SQL with several subselects is a good example. Every subselect can run as a seperate thread, but as you probably know, MySQL doesn't support subselects, so there... So, you should not expect to get better single SQL performance from a SMP machine. Where you will get better performance is if you have >1 concurrent user or rather >1 concurrent SQL (who don't lock each others tables), because MySQL (or rather the OS) then will balance the SQLs between the available CPUs. You will allways get better performance out of a single CPU machine rather than a SMP machine if the CPU type is the same and the single processor is about the same clock frequency as the SMP processors combined. A single Pentium III 1 GHz will in single threaded tasks be a little more than twice as fast as a dual Pentium III 500 MHz, and in every case allways faster. If you serve a single threaded task to a dual Pentium III 500 MHz, it perform like a single Pentium III 500 MHz. If you serve a multithreaded task to it, it'll perform somewhere between 500 MHz and close to 1 GHz. SMP should only be considered when you can't get any faster with a single CPU machine, and if you need that extra performance, you should still use the fastest clocked CPUs for SMP, because if you don't it'll feel slow in singlethreaded performance. I've run MySQL on machines with between 2 & 12 CPUs running either Linux, Solaris or Tru64. With one SQL active at any given time, I've never seen MySQL use more than one CPU. With two SQLs active at the same time, it uses 2 CPUs and so forth, unless the SQLs lock each others tables, which in fact, for me, is a major problem in MySQL. You need a recent MySQL to fully benefit from SMP, since older 3.22.x doesn't have any configure options to control SMP behavior. Secondly, on some platforms it is quite important to compile MySQL with the right flags in order to get the best SMP/thread performance. -- Un saludo / Venlig hilsen / Regards Jesper Frank Nemholt Unix System Manager Compaq Computer Corporation Phone : +34 699 419 171 E-Mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Dual Processor and MySQL !
> -Original Message- > From: Hamid Hashemi Golpayegani [mailto:[EMAIL PROTECTED]] > Sent: sábado, 31 de marzo de 2001 17:09 > To: [EMAIL PROTECTED] > Subject: Dual Processor and MySQL ! > > > Hi , > > Sorry for this question may be this question asked before but > I can't find > it . > I want to know that an SMP Dual CPU machine for a MySQL > server is better > that a single CPU machine ?! > I mean is the MySQl use the both CPU's for processing or not ? > and how much affect on the responding and which parameters > are going better > in this case ?! As said by other, if the OS supports SMP, MySQL will benefit from this, since MySQL is a threaded application. However, a singlethreaded SQL (ie. a SQL MySQL is unable to break up into several parts) will only run on one CPU at a time, and this is the situation you will see most of the time. In fact I'm not even sure MySQL does try to break up SQLs into >1 threads, but I know other database servers do. A SQL with several subselects is a good example. Every subselect can run as a seperate thread, but as you probably know, MySQL doesn't support subselects, so there... So, you should not expect to get better single SQL performance from a SMP machine. Where you will get better performance is if you have >1 concurrent user or rather >1 concurrent SQL (who don't lock each others tables), because MySQL (or rather the OS) then will balance the SQLs between the available CPUs. You will allways get better performance out of a single CPU machine rather than a SMP machine if the CPU type is the same and the single processor is about the same clock frequency as the SMP processors combined. A single Pentium III 1 GHz will in single threaded tasks be a little more than twice as fast as a dual Pentium III 500 MHz, and in every case allways faster. If you serve a single threaded task to a dual Pentium III 500 MHz, it perform like a single Pentium III 500 MHz. If you serve a multithreaded task to it, it'll perform somewhere between 500 MHz and close to 1 GHz. SMP should only be considered when you can't get any faster with a single CPU machine, and if you need that extra performance, you should still use the fastest clocked CPUs for SMP, because if you don't it'll feel slow in singlethreaded performance. I've run MySQL on machines with between 2 & 12 CPUs running either Linux, Solaris or Tru64. With one SQL active at any given time, I've never seen MySQL use more than one CPU. With two SQLs active at the same time, it uses 2 CPUs and so forth, unless the SQLs lock each others tables, which in fact, for me, is a major problem in MySQL. You need a recent MySQL to fully benefit from SMP, since older 3.22.x doesn't have any configure options to control SMP behavior. Secondly, on some platforms it is quite important to compile MySQL with the right flags in order to get the best SMP/thread performance. -- Un saludo / Venlig hilsen / Regards Jesper Frank Nemholt Unix System Manager Compaq Computer Corporation Phone : +34 699 419 171 E-Mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Show grants ??? Doubt
Whoof What a relief But one more doubt is "mysqlaccess" not shipped with on win32 platforms.The version i'm using is 3.22.32 shareware. I don't seem to find it Cheers Sajan - Original Message - From: Benjamin Pflugmann <[EMAIL PROTECTED]> To: P.V. Sajan <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday, April 01, 2001 1:10 PM Subject: Re: Show grants ??? Doubt > Hello. > > You seem to use an older version of MySQL which did not support SHOW > GRANTS. Too see when a feature was introduced, have a look at the > Changes History section in the fine manual. > > Bye, > > Benjamin. > > On Sun, Apr 01, 2001 at 12:27:13PM +0530, [EMAIL PROTECTED] wrote: > > Hello all !! > > mysql> show grants for root@localhost; > > ERROR 1064: You have an error in your SQL syntax near 'grants for > > root@localhost ' at line 1 > > > > Could anyone please tell me where i'm going wrong .. > > Thank you > > Sajan > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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
perror
Hello All !! C:\mysql\bin>perror 1064 Illegal error code: 1064 This is impossible but its true as i've simply pasted the screenshot. I guess 1064 error stands for syntax.error The version i'm using is 3.22.32 shareware.on win98 Could anyone please explain this weird thing coz . 1064 is a very comman error. Thank you Best regards Sajan Cheers Sajan - God gimme patience er... But Hurry up !!! --- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 with EJB CMP
Hello all , Can anybody tell me what to do to setup MySql with EJB ? It is running very fine for creation of the CMPs but it is not getting the DATA while executing FindByPrimaryKey option , it is able to create the instance of the Interface but could not get the DATA from it. Neelesh - Original Message - From: "Bernhard Fuerst" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, April 01, 2001 3:07 PM Subject: mySQL and MacOS X: very slow > Hi all, > > I benchmarked mySQL 3.23.36 on the new MacOS X and got the following > results: > > ATIS : 101.00 > alter-table: 767.00 > big-tables :90.00 > connect: 178.00 > create : 957.00 > insert : 38029.00 > select : +3274.00 > wisconsin : 307.00 > > That's too slow especially the time it needs for inserts (compared to > http://www.mysql.com/information/benchmark-results/result-mysql-platform-rel ative.html) > > Do anyone has an idea why it is so slow?? > > Here some config details: > > The machine is a PowerBook G3 (Firewire) with 400 Mhz PowerPC G3 and 265 > MB RAM. When I run the benchmark there was approximately 150 MB of free > RAM (reported by 'top'). I did nothing on the machine in this time. > > I configured and compiled mySQL with the following parameters: > CFLAGS="-O4 -fomit-frame-pointer" \ > CXXFLAGS="-O4 -fomit-frame-pointer -felide-constructors -fno-exceptions > -fno-rtti" \ > ./configure \ > --prefix=/usr/local/mysql \ > --with-mysqld-ldflags=-all-static \ > --without-debug \ > --with-extra-charset=complex \ > --enable-assembler > > > mysqld is configured as follows: > ansi_mode | OFF > back_log| 50 > basedir | /usr/local/ > binlog_cache_size | 32768 > character_set | latin1 > character_sets | latin1 dec8 dos german1 hp8 koi8_ru latin2 > swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr > win1251ukr greek win1250 croat cp1257 latin5 | > concurrent_insert | ON > connect_timeout | 5 > datadir | /usr/local/var/ > delay_key_write | ON > delayed_insert_limit| 100 > delayed_insert_timeout | 300 > delayed_queue_size | 1000 > flush | OFF > flush_time | 0 > have_bdb| NO > have_gemini | NO > have_innobase | NO > have_isam | YES > have_raid | NO > have_ssl| NO > init_file | > interactive_timeout | 28800 > join_buffer_size| 131072 > key_buffer_size | 8388600 > language| /usr/local/share/mysql/english/ > large_files_support | ON > locked_in_memory| OFF > log | OFF > log_update | OFF > log_bin | OFF > log_slave_updates | OFF > long_query_time | 10 > low_priority_updates| OFF > lower_case_table_names | 0 > max_allowed_packet | 1048576 > max_binlog_cache_size | 4294967295 > max_binlog_size | 1073741824 > max_connections | 100 > max_connect_errors | 10 > max_delayed_threads | 20 > max_heap_table_size | 16777216 > max_join_size | 4294967295 > max_sort_length | 1024 > max_user_connections| 0 > max_tmp_tables | 32 > max_write_lock_count| 4294967295 > myisam_recover_options | OFF > myisam_sort_buffer_size | 8388608 > net_buffer_length | 16384 > net_read_timeout| 30 > net_retry_count | 10 > net_write_timeout | 60 > open_files_limit| 0 > pid_file| /usr/local/var/localhost.pid > port| 3306 > protocol_version| 10 > record_buffer | 131072 > query_buffer_size | 0 > safe_show_database | OFF > server_id | 0 > skip_locking| OFF > skip_networking | OFF > skip_show_database | OFF > slow_launch_time| 2 > socket | /tmp/mysql.sock > sort_buffer | 2097144 > table_cache | 64 > table_type | MYISAM > thread_cache_size | 0 > thread_stack| 65536 > transaction_isolation | READ-COMMITTED > tmp_table_size | 1048576 > tmpdir | /var/tmp/ > version | 3.23.36 > wait_timeout| 28800 > > Thanks, > Bernhard > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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 <[E
mySQL and MacOS X: very slow
Hi all, I benchmarked mySQL 3.23.36 on the new MacOS X and got the following results: ATIS : 101.00 alter-table: 767.00 big-tables :90.00 connect: 178.00 create : 957.00 insert : 38029.00 select : +3274.00 wisconsin : 307.00 That's too slow especially the time it needs for inserts (compared to http://www.mysql.com/information/benchmark-results/result-mysql-platform-relative.html) Do anyone has an idea why it is so slow?? Here some config details: The machine is a PowerBook G3 (Firewire) with 400 Mhz PowerPC G3 and 265 MB RAM. When I run the benchmark there was approximately 150 MB of free RAM (reported by 'top'). I did nothing on the machine in this time. I configured and compiled mySQL with the following parameters: CFLAGS="-O4 -fomit-frame-pointer" \ CXXFLAGS="-O4 -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti" \ ./configure \ --prefix=/usr/local/mysql \ --with-mysqld-ldflags=-all-static \ --without-debug \ --with-extra-charset=complex \ --enable-assembler mysqld is configured as follows: ansi_mode | OFF back_log| 50 basedir | /usr/local/ binlog_cache_size | 32768 character_set | latin1 character_sets | latin1 dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 | concurrent_insert | ON connect_timeout | 5 datadir | /usr/local/var/ delay_key_write | ON delayed_insert_limit| 100 delayed_insert_timeout | 300 delayed_queue_size | 1000 flush | OFF flush_time | 0 have_bdb| NO have_gemini | NO have_innobase | NO have_isam | YES have_raid | NO have_ssl| NO init_file | interactive_timeout | 28800 join_buffer_size| 131072 key_buffer_size | 8388600 language| /usr/local/share/mysql/english/ large_files_support | ON locked_in_memory| OFF log | OFF log_update | OFF log_bin | OFF log_slave_updates | OFF long_query_time | 10 low_priority_updates| OFF lower_case_table_names | 0 max_allowed_packet | 1048576 max_binlog_cache_size | 4294967295 max_binlog_size | 1073741824 max_connections | 100 max_connect_errors | 10 max_delayed_threads | 20 max_heap_table_size | 16777216 max_join_size | 4294967295 max_sort_length | 1024 max_user_connections| 0 max_tmp_tables | 32 max_write_lock_count| 4294967295 myisam_recover_options | OFF myisam_sort_buffer_size | 8388608 net_buffer_length | 16384 net_read_timeout| 30 net_retry_count | 10 net_write_timeout | 60 open_files_limit| 0 pid_file| /usr/local/var/localhost.pid port| 3306 protocol_version| 10 record_buffer | 131072 query_buffer_size | 0 safe_show_database | OFF server_id | 0 skip_locking| OFF skip_networking | OFF skip_show_database | OFF slow_launch_time| 2 socket | /tmp/mysql.sock sort_buffer | 2097144 table_cache | 64 table_type | MYISAM thread_cache_size | 0 thread_stack| 65536 transaction_isolation | READ-COMMITTED tmp_table_size | 1048576 tmpdir | /var/tmp/ version | 3.23.36 wait_timeout| 28800 Thanks, Bernhard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: data types
On Sun, Apr 01, 2001 at 11:02:22AM +0100, Einav Lavi-Lapidot wrote: > Hi all , > > Can I get a list of all data types at mySql 3.23 ? I'm starting to > work with it, and it would be very helpful. Thanks, einav. Certainly. They're all documented in the manual: http://www.mysql.com/doc/ 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
data types
Hi all , Can I get a list of all data types at mySql 3.23 ? I'm starting to work with it, and it would be very helpful. Thanks, einav. Einav Lavi-Pdut software engineer [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
mysqladmin question
Hello, I have an error when the system (Linux 7)goes to rotate the logs. I get an error sent to me by cron daemon that access is denied for user root @ localhost using password=no. I had this same problem when I first installed the RPM when I was trying to set a root password. when I issued the mysqladmin command to set password I got the same message. I ended up setting the password manually in the mysql database using sql. Has anyone heard of this or had this problem? Please Help! My log file is HUGE! Thanks, Scott - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
confirm subscribe to mysql@lists.mysql.com
Hi! This is the ezmlm program. I'm managing the [EMAIL PROTECTED] mailing list. To confirm that you would like archive@jab.org added to the mysql mailing list, please send an empty reply to this address: [EMAIL PROTECTED] Usually, this happens when you just hit the "reply" button. If this does not work, simply copy the address and paste it into the "To:" field of a new message. This confirmation serves two purposes. First, it verifies that I am able to get mail through to you. Second, it protects you in case someone forges a subscription request in your name. Some mail programs are broken and cannot handle long addresses. If you cannot reply to this request, instead send a message to <[EMAIL PROTECTED]> and put the entire address listed above into the "Subject:" line. --- Administrative commands for the mysql list --- I can handle administrative requests automatically. Please do not send them to the list address! Instead, send your message to the correct command address: To subscribe to the list, send a message to: <[EMAIL PROTECTED]> To remove your address from the list, send a message to the address in the "List-Unsubscribe" header of messages from the list. If you don't know how to display headers and haven't changed E-mail addresses since subscribing, you'll be successful with an e-mail to: <[EMAIL PROTECTED]> Send mail to the following for info and FAQ for this list: <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> Similar addresses exist for the digest list: <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> To get messages 123 through 145 (a maximum of 100 per request), mail: <[EMAIL PROTECTED]> To get an index with subject and author for messages 123-456 , mail: <[EMAIL PROTECTED]> They are always returned as sets of 100, max 2000 per request, so you'll actually get 100-499. To receive all messages with the same subject as message 12345, send an empty message to: <[EMAIL PROTECTED]> The messages do not really need to be empty, but I will ignore their content. Only the ADDRESS you send to is important. You can start a subscription for an alternate address, for example "[EMAIL PROTECTED]", just add a hyphen and your address (with '=' instead of '@') after the command word: <[EMAIL PROTECTED]> To stop subscription for this address, mail: <[EMAIL PROTECTED]> In both cases, I'll send a confirmation message to that address. When you receive it, simply reply to it to complete your subscription. If despite following these instructions, you do not get the desired results, please contact my owner at [EMAIL PROTECTED] Please be patient, my owner is a lot slower than I am ;-) --- Enclosed is a copy of the request I received. Return-Path: <[EMAIL PROTECTED]> Received: (qmail 1758 invoked from network); 1 Apr 2001 08:50:27 - Received: from unknown (HELO flamingo.mkpi.co.id) (202.155.24.179) by www.mysql.com with SMTP; 1 Apr 2001 08:50:27 - Received: by flamingo.mkpi.co.id with Internet Mail Service (5.5.2650.21) id ; Sun, 1 Apr 2001 15:57:13 +0700 Message-ID: <[EMAIL PROTECTED]> From: Rika Hepianton <[EMAIL PROTECTED]> To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> Subject: Date: Sun, 1 Apr 2001 15:57:02 +0700 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2650.21) Content-Type: text/plain
Re: How to have faster select?
Read the manual, the most frequent words are stopped in index.
Chai-Hup Chen wrote:
> Hi,
> Thanks a lot, the select is much faster now. But I find something
> weird, it return nothing when match against the string "the", which
> return 255568 entries when select "% the %", is it possible mysql
> does not indexed some words for some reason?
>
>
> select count(*) from Books where match Title against ('cisco');
> +--+
> | count(*) |
> +--+
> | 222 |
> +--+
> 1 row in set (1.76 sec)
>
>
>
>
> select count(*) from Books where Title like "% the %";
> +--+
> | count(*) |
> +--+
> | 255568 |
> +--+
> 1 row in set (1 min 23.17 sec)
>
> select count(*) from Books where match Title against ('the');
> +--+
> | count(*) |
> +--+
> |0 |
> +--+
> 1 row in set (0.00 sec)
>
>> SELECT count(*) FROM Books WHERE MATCH Title AGAINST 'cisco'
>>
>> We use a FULLTEXT index search in a couple of our table for business referral
>> searches, and it works like a charm!
>>
>> Hope this helps
>>
Hi,
Here is the fulltext index I add:
CREATE TABLE Books (
isbn char(10) NOT NULL default '',
Title char(255) NOT NULL default '',
FULLTEXT KEY full_title (Title)
) TYPE=MyISAM;
select count(*) from Books --> 2028971
select count(*) from Books where Title like "% cisco %"
+--+
| count(*) |
+--+
| 86 |
+--+
1 row in set (1 min 15.58 sec)
Look like the fulltext index is not functioning ... Any idea?
>>>
>> Mike(mickalo)Blezien
>>
>> Thunder Rain Internet Publishing
>> Providing Internet Solutions that work!
>> http://www.thunder-rain.com
>> Tel: 1(225) 686-2002
>> =
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> -
>> Before posting, please check:
>>http://www.mysql.com/manual.php (the manual)
>>http://lists.mysql.com/ (the list archive)
>>
>> To request this thread, e-mail <[EMAIL PROTECTED]>
>> To unsubscribe, e-mail <[EMAIL PROTECTED]>
>> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
--
--
Antonio Gulli'Ideare S.p.a tel: (+39) 050 575300
[EMAIL PROTECTED] Lungarno Mediceo 56 fax: (+39) 050 575583
whois: AG2-ORG I-56126 Pisa, Italy http://www.ideare.com net:
print pack"C*",split/\D+/,`echo "16iII*o\U@{$/=$z;[(pop,pop,unpack"H*",<>
)]}\EsMsKsN0[lN*1lK[d2%Sa2/d0
