RE: How to speed things up in MySQL ?
Thomas, Just a thought: In your Delphi/cgi script, how do you define/call the database-server? Meaning, do you use the IP address, localhost, a domain name, a server name etc.? Can it be that it's not the query but the time to establish a connection or resolve the name that is so long? I've seen that on a Windows SAP DB server once, and it turned out to be a DNS issue. Once fixed, everything ran perfectly well. Markus -Original Message- From: Thomas Kvamme [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 25, 2003 6:27 PM To: Bhavin Vyas; [EMAIL PROTECTED] Subject: Re: How to speed things up in MySQL ? Hi Bhavin. Thanks for taking interest in my problem... Here is the table definition as requested. I'm sorry I could take a full dump... Each record consist of approx 600 KB (just as in the Paradox table) so the file would be very big. (200 MB). Kind Regards Thomas Kvamme [EMAIL PROTECTED] BEGIN *** -- MySQL dump 9.07 -- -- Host: localhostDatabase: tdd - -- Server version 4.0.9-gamma-nt -- -- Table structure for table 'dvd' -- CREATE TABLE dvd ( ID int(11) NOT NULL auto_increment, Title varchar(100) default NULL, ProductionYear varchar(4) default NULL, TagLine varchar(200) default NULL, NorwegianTitle varchar(100) default NULL, NorwegianTagLine varchar(200) default '', Director varchar(100) default '', Story varchar(100) default '', Producer varchar(100) default '', Genre varchar(100) default '', Production varchar(200) default '', Distribution varchar(200) default '', NorwegianDistribution varchar(200) default '', ScreenFormat varchar(50) default '16:9 Anamorphic Widescreen', AspectRatio varchar(10) default '2:35:1', DVDDiscType char(2) default '9', DVDRegion char(1) default '2', RunningTime time default '00:00:00', IMDB varchar(20) default '', Starring blob, SoundTracks blob, Subtitles blob, SpecialFeatures blob, Comments blob, PlotOutline blob, FullCredits longblob, Cover longblob, THXCertified enum('False','True') default 'False', DDEX enum('False','True') default 'False', DTS enum('False','True') default 'False', MPEG enum('False','True') default 'False', Recommended enum('False','True') default 'False', Added datetime default '-00-00 00:00:00', Updated datetime default '-00-00 00:00:00', PRIMARY KEY (ID), KEY Added (Added), KEY Title (Title,ProductionYear), KEY NorwegianTitle (NorwegianTitle,ProductionYear) ) TYPE=MyISAM; * END - Original Message - From: Bhavin Vyas [EMAIL PROTECTED] To: Thomas Kvamme [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, January 25, 2003 5:15 PM Subject: Re: How to speed things up in MySQL ? Sounds weird. Can you e-mail us a 'mysqldump' of the table defination with the data? Thanks, Bhavin. - Original Message - From: Thomas Kvamme [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, January 25, 2003 7:36 AM Subject: How to speed things up in MySQL ? Hello, While reading this you may think this is off-topic... but please read on.. I'll get on-topic in the end :-)) First of all I have Web Server on which I have a Paradox table with 320 records. I also have a CGI Script (or program if you like) I made in Borland Delphi which I use to access the Table... When I enter the address of my CGI-script in my Internet Browser the following happens: The CGI script on the Web Server is starting. The CGI script reads the SQL command to execute passed on to the script through the HTTP protocol. The CGI script establish connection with the Borland Database Engine (Loading BDE dll's etc..) The CGI script opens/initialize the Paradox Table. The CGI script execute the SQL command sent to it. The CGI script sends back the result of the SQL command to the Browser (HTTP protocol). The CGI script closes down (shutting down db connection etc..). My PC and my Web Server is connected on the same LAN (switched 100 MBit/s) All of the above is completed in 1.5 seconds. ** here the fun begins ** I have now successfully installed MySQL (on the same WebServer) and converted the Paradox Table to MySQL Table type: MyISAM. Database Name: TDD Table Name: DVD This new Table contains the same 320 records using the same field definition as in the Paradox Table. On my Web Server I go into \MySQL\bin\ and start mysql -uroot -p and execute the same SQL command as sent to the Paradox table through the CGI script. see screen dump below for result. SCREEN DUMP ** F:\MySQL\binmysql -uroot -p Enter password: ** Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3726 to server version: 4.0.9-gamma-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql use tdd Database changed mysql select count(id) as
mysql@lists.mysql.com
×ð¾´µÄmysql:ÄúºÃ! ÎÒÃÇÏòÄúÌṩÀ¥Ã÷µØÇø¾ÆµêÔ¤¶©·þÎñ£¬¼Û¸ñµÍµÃÁîÈËÄÑÒÔÖÃÐÅ£¡ ÎåÐǼ¶¾Æµê280Ôª£¬ËÄÐǼ¶¾Æµê180Ôª£¬3ÐǼ¶¾Æµê140Ôª¡¡ Ïêϸ×ÊÁÏÇëÀ´µçÀ´ÓÊË÷È¡¡£ ·þÎñÈÈÏߣº0871-3562788 ·þÎñ´«Õ棺0871-3570448 E-mail: [EMAIL PROTECTED] Ö Àñ! KMCTRIP 2003-01-26 Èç¹ûÕâ·âÐÅ´òÈÅÁËÄú£¬ÎÒÃÇÍò·Ö±§Ç¸²¢·³ÄúËæÊÖɾ³ý¡£ Èç¹ûÄú²»Ï£ÍûÊÕµ½ÀàËƵÄÓʼþ£¬Çë»Ø¸´µ½ÏÂÃæµÄµØÖ·£º [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: Need nulls in my join
Seeing a little more data on your situation does change things quite a bit. It sounds like you are also needing to use a SELECT DISTINCT of specific criteria, so that you avoid pulling the same thing more than once. What those criteria are, naturally depends on what the various possibilities are and how (exactly) you want to pull the data. -- Loren McDonald AKA MisterrMac [EMAIL PROTECTED] -Original Message- From: Hoffman, Geoffrey [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 25, 2003 3:48 PM To: [EMAIL PROTECTED] Subject: RE: Need nulls in my join Unfortunately I tried to implement what you suggested, but in my case it didn't work. I have stories that can have zero or more photos, one or more author, one or more sections, and one or more active dates. Trying to join all those items together using your suggestion actually did return stories with no photo, but I would then get 3 copies of a story that had 3 photos, and 6 copies of a 2-photo story that appears on 3 days. What I really need is mysql 4's SELECT blah WHERE (SELECT blah) subselect feature, but that's not an option either due to the host I'm using. I ended up writing a simpler query get all the unique story id's for a section, then doing a foreach loop in PHP to query for all the additional data for the story where ID = $loopindex. I'm sure there's a supermysqlguru out there who cringes when you issue a bunch of queries in a PHP loop, but it works fine for now. Thanks though - I'm sure I'll use your suggestion somewhere in the app I'm working on. Geoff -Original Message- From: Loren McDonald [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 25, 2003 1:41 PM To: Hoffman, Geoffrey; [EMAIL PROTECTED] Subject: RE: Need nulls in my join Oopssorry. That should have been GROUP BY and not GROUP ON That's what I get for answering a post at 2am. :) -- Loren McDonald AKA MisterrMac [EMAIL PROTECTED] This one is relatively simple: Drop the WHERE evtphoto.phtusage = 1. SELECT it and then GROUP ON it. -- Loren McDonald AKA MisterrMac - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: How to speed things up in MySQL ?
Just to toss something into the fray: I had a similar problem, where any query was taking a very long time to run. I never did discover what the problem was but suddenly, one day later the problem was gone. I had rebooted my server twice in the mean time with no resolve. There is quite a bit running on the server but for the first week or two of testing I hadn't experienced any kind of slow down. Obviously, for me, something in the background WAS getting in the way, but I couldn't figure out what in the short amount of time is was a problem. -- Loren McDonald [EMAIL PROTECTED] -Original Message- Hi. On Sat 2003-01-25 at 13:36:01 +0100, [EMAIL PROTECTED] wrote: [...] mysql select count(id) as Films, ProductionYear from DVD - group by ProductionYear - order by ProductionYear desc; [...] 39 rows in set (13.32 sec) mysql *** How is this possible ?? 13.32 seconds ??? Good question. I do not know the answer, but I can tell you that there is something seriously screwed up. It should only take a fraction of a second. When I run a similar query on my database, it displays 0.00 sec, i.e. it took less than 0.01 secs. The same query on a database with 600.000 records takes about 4.7 secs. And this was when I was directly logged on to the Database (via Localhost)! When Using my Paradox table this took 1.5 second through my CGI script over the Intranet. [...] What can I do to speed this up ? As I said, I am not sure. This is not a question of optimizing your database or queries. Your installation of MySQL does not behave normally. Usually, there is no way any operation on 320 records would take more than at most 0.1 seconds or such. PS: The DVD table containing the 320 records is the only table on the server. (except from the MySQL database and the empy Test Database). Both the Paradox Table and the MySQL server is installed on the same Harddrive so harddisk speed shouldn't be a factor. Harddrive speed shouldn't be a factor at all, as 320 records need so few memory that they usually are kept in memory after first access. Appreciate any help to solve the above :-))) Just to be sure to exclude anything I might not have thought of, can you post the result of EXPLAIN for the select above SHOW CREATE TABLE DVD SHOW INDEX FROM DVD SHOW TABLE STATUS LIKE 'DVD' Is there anything running on the server while you do your tests? Regards, Benjamin. -- [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: weird comparison problem
From the manual: 6.3.2.2 Case-Sensitivity BINARY The BINARY operator casts the string following it to a binary string. This is an easy way to force a column comparison to be case-sensitive even if the column isn't defined as BINARY or BLOB: mysql SELECT a = A; - 1 mysql SELECT BINARY a = A; - 0 -- Loren McDonald [EMAIL PROTECTED] -Original Message- Am having a bit of a weird problem with a SELECT on my MYSQL database: If i use this: SELECT * FROM tablehere WHERE userid = '$uid' AND password = '$pwd' with $uid and $pwd being vars from a login form, and Miguel being userid on the table, i can login if i type miguel on the form. No matter if i type uppercase or lowercase, it always logs in, how can that be? Miguel is != to miguel. (but if i misspel it, it fails, as it should :-) How can i make a correct check with upper case distinction? Thanks Pag - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: How to speed things up in MySQL ?
Hi. On Sun 2003-01-26 at 00:26:32 +0100, [EMAIL PROTECTED] wrote: Here is the table definition as requested. I'm sorry I could take a full dump... Each record consist of approx 600 KB (just as in the Paradox table) so the file would be very big. (200 MB). Well, you should have told us that to begin with. ;) 600KB/record is not that usual. You are querying for ProductionYear but have no usuable index for it. That results in a full table scan, which has to read 200MB from disk, which is not unreasonble to take 13 secs, depending on your hardware. Btw, this also means that you can disregard my comment from the other mail about disk usage. I really did not expect your rows being so large without you mentioning it. Don't know why Paradox is faster. Maybe it can make partial use of one of the combined indexes which contain ProductionYear. Anyhow, creating an index on ProductionYear will do the job, so that the query runs fast. I am not sure if referring to ID in count(ID) is a problem. If so, replace it by count(*) additionally. If you often have to query on non-indexed fields, the usual solution is to split up the table into two: one containing the fields on which you want to query, the other the fields which you only query by primary key (probably most blob fields). And use a join if you want some blob depending on one of the query fields. This way the table size to read for full table scans will be much smaller. Btw, this is not MySQL-specific, but true for any database. It would also get the times with Paradox in the sub-second range. HTH, Benjamin. PS: Why don't you use a (small)int for ProductionYear? CREATE TABLE dvd ( ID int(11) NOT NULL auto_increment, Title varchar(100) default NULL, ProductionYear varchar(4) default NULL, [...] Starring blob, SoundTracks blob, Subtitles blob, SpecialFeatures blob, Comments blob, PlotOutline blob, FullCredits longblob, Cover longblob, [...] PRIMARY KEY (ID), KEY Added (Added), KEY Title (Title,ProductionYear), KEY NorwegianTitle (NorwegianTitle,ProductionYear) ) TYPE=MyISAM; * END [...] mysql select count(id) as Films, ProductionYear from DVD - group by ProductionYear - order by ProductionYear desc; [...] -- [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: Slave on same machine?
- Original Message - From: Paul DuBois [EMAIL PROTECTED] To: Mark [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, January 26, 2003 4:29 AM Subject: Re: Slave on same machine? At 5:07 +0100 1/25/03, Mark wrote: Hi, I know, it sounds a bit like a stupid question, but can I run a slave mysqld server on the same machine? Sure. They have to be using different ports, of course. Good! Thanks. :) I think I'm gonna give this a try. That way backups can be made without any down-time. :) - Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 with 4.0.9 c API or user
In the last episode (Jan 25), sam said: I am getting the following message when submitting the following: [sam@linux sam]$ make gcc -o listener main.o common.o -L/usr/lib/mysql -lmysqlclient -lm /usr/lib/mysql/libmysqlclient.a(my_compress.o): In function `my_uncompress': my_compress.o(.text+0xaa):undefined reference to `uncompress' /usr/lib/mysql/libmysqlclient.a(my_compress.o): In function `my_compress_alloc': my_compress.o(.text+0x13c): undefined reference to `compress' collect2: ld returned 1 exit status make: *** [listener] Error 1 Add -lz to your link line after -lmysqlclient. Your system is apparently one where libraries cannot tell the linker what other libraries they depend on, so you have to do it yourself. -- Dan Nelson [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Cannot connect from WInXp MYSQL server - help - cont.
I ahve upgraded to gcc v 3.2.7:- Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.2/specs Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking --host=i386-redha t-linux --with-system-zlib --enable-__cxa_atexit Thread model: posix gcc version 3.2 20020903 (Red Hat Linux 8.0 3.2-7) I have also added the line:= set-variable = thread_stack=256K// Thats a uppercase 'K' in my my.cnf file Same bloady error. Ideas? Scott - Original Message - From: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED] To: Scott Lewis [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, January 25, 2003 10:48 PM Subject: Re: Cannot connect from WInXp MYSQL server - help Scott, most probably, you've got a glibc problem on your Red Hat box. Try upgrading to a newer version of glibc, and if the problem (mysqld dies when trying to connect from anywhere else than localhost) has gone, I was right :) (There was a very similar question a couple of days ago on this list. I don't know if the Red Hat problem is exactly the same as the SuSE problem I could solve by updating glibc, but the symptom is the same.) Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Scott Lewis [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, January 25, 2003 6:51 PM Subject: Cannot connect from WInXp MYSQL server - help OK, I have a mysql server running on my home server. The main os is Redhat8. I know that Mysql is running on port 3306 as its showing as listening. I ahve opened the tcp port for boh internal and external connections - fione. I ahve also disbaled it to test aswell. Anyway - I have loaded several MYsql clients on my winxp pro pc on my home LAN, eg Dbmanager. I ahve set the settinsg fine, and each time I try and connection I get the error:- Lost connection to mysql durring query. In the loags it says:- Number of processes running now: 1 mysqld process hanging, pid 2522 - killed 030125 17:49:36 mysqld restarted /usr/libexec/mysqld: ready for connections So - its killing the pid, which I assume is my connections. Any ideas on what to look for. Scott www.toptravelsites.net www.myeyes-youreyes.co.uk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Segmentation fault when scanning mysqld port
Manuel, Benjamin, /usr/local/mysql/3.23.55/bin/safe_mysqld: line 280: 1757 Segmentation fault And again, this looks like the SuSE bug to me. Here's my posting about an error like this on Red Hat: cite who=myself Synopsis: Server crashes on remote connection I'm not a Unix guru but I experienced the same sympton on SuSE Linux 8.0/8.1, and I heard of people reporting the same of Red Hat Linux 7.x/8.x. MySQL runs stable, you can connect from localhost via socket and tcp/ip, but as soon as you try a connect from some other machine, mysqld segfaults. In all cases I heard of, the problem was some glibc version that caused all the trouble. You say you use glibc-2.2.93-5 This version # looks a bit strange to me, well ... In a SuSE Linux Newsgroup I heard that everything's okay if you use = 2.2.5-151. We use glibc-2.2.5-164 on SuSE Linux 8.1, and with our 3.23.54, we've had no problems at all. /cite HTH, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Benjamin Pflugmann [EMAIL PROTECTED] To: Manuel Kiessling [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, January 25, 2003 9:44 PM Subject: Re: Segmentation fault when scanning mysqld port On Sat 2003-01-25 at 14:16:35 +0100, [EMAIL PROTECTED] wrote: Hello, i just installed MySQL 3.23.55 on a SuSE Linux 8.1 system (compiled myself), and after firing up mysqld and starting a scan (via nmap; my server has no firewall) from another server, i get the following message: /usr/local/mysql/3.23.55/bin/safe_mysqld: line 280: 1757 Segmentation fault $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking $err_log 21 Number of processes running now: 1 mysqld process hanging, pid 1760 - killed 030125 15:06:29 mysqld restarted Hope someone can say something to this. Try a pre-compiled binary? Without testing, I simply presume that such an obvious bug would not stay long. So your binary looks shaky. Okay, I tested against the older 3.23.49 and cannot reproduce this. HTH, Benjamin. -- [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
Backing up mysql databases
Whats the best way to backup the mysql databses. I was thinking along the lines of adding something to my crons cript that will backup all the databases, permissions etc and copy then to an external hard drive, which I do at the moment for other files Can anyone advise? Scott www.toptravelsites.net www.myeyes-youreyes.co.uk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Segmentation fault when scanning mysqld port
Hi, found some advise here (in german): http://groups.google.de/groups?q=suse+glibc+mysqlhl=delr=ie=UTF-8oe=UTF-8selm=apkaeo%242cspr%242%40ID-121729.news.dfncis.dernum=3 -- Manuel Kiessling - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Is there anything like Query Analyser for MySQl
I was wondering, is there a program simialar to MS SQL server - Query Analyser, where you can write sql queries to query MySQl databases? 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
MySQl and webpages
As you can tell - very new to Mysql. I was wondering, has anyone some links to howto or even better examples of databases and webpages that I can install, and see the web interaction with webpages and a mysql database. Looking at going down that road as exaaples would help. 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
Re: GPL online backup for innodb tables
Salvatore, - Original Message - From: Salvatore Enrico Indiogine [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Saturday, January 25, 2003 6:22 AM Subject: GPL online backup for innodb tables Greetings! I would like to know whether in MySQL I can do an online (hot) backup of innodb type tables using a 'free' (GPL) tool. Or even if it is possible by writing my own shell script as you can do in Oracle with: alter tablespace tablespace_name_1 begin backup; then use cp to copy the tablespace file alter tablespace tablespace_name_1 end backup; alter tablespace tablespace_name_2 begin backup; and so on for all tablespaces. mysqldump is one. InnoDB Hot Backup is a way to make binary backups whose restoration is faster than table dumps. Thanks in advance. Enrico Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com sql query -- Enrico Indiogine Systems Analyst Information Systems Eastern New Mexico University - Roswell 505-624-7493 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 connect from WInXp MYSQL server - help
I've been having the same problem with WinXP to MySQL running under a totally up2date-ed Red Hat 8 installation. What I did was to modify my /etc/my.cnf to look like: [mysqld] datadir=/raid/mysql socket=/raid/mysql/mysql.sock set-variable=max_allowed_packet=10M set-variable=thread_stack=1M [mysql.server] user=mysql basedir=/raid [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid [client] port=3306 socket=/raid/mysql/mysql.sock That, according to a Bugzilla note at Red Hat (which, IIRC, mentions the problem being with glibc) should fix the problem. And it did - sort of. The MySQLGUI.exe Windows client could connect from WinXP, but Access databases through MyODBC would not. After taking a close look at the c:\my.cnf file: [mysqld] datadir=/raid/mysql socket=/raid/mysql/mysql.sock [mysql.server] user=mysql basedir=/raid [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid seems correct to me. There was one thing missing: When configuring the MyODBC driver, I had to check the option Read options from C:\my.cnf for this to work. The **really** strange thing is that I have a different database on the same RedHat 8 server, and I **didn't** have to select that option for it to connect... Cheers, Mike -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 25, 2003 7:18 PM To: Scott Lewis; [EMAIL PROTECTED] Subject: Re: Cannot connect from WInXp MYSQL server - help Scott, most probably, you've got a glibc problem on your Red Hat box. Try upgrading to a newer version of glibc, and if the problem (mysqld dies when trying to connect from anywhere else than localhost) has gone, I was right :) (There was a very similar question a couple of days ago on this list. I don't know if the Red Hat problem is exactly the same as the SuSE problem I could solve by updating glibc, but the symptom is the same.) Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Scott Lewis [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, January 25, 2003 6:51 PM Subject: Cannot connect from WInXp MYSQL server - help OK, I have a mysql server running on my home server. The main os is Redhat8. I know that Mysql is running on port 3306 as its showing as listening. I ahve opened the tcp port for boh internal and external connections - fione. I ahve also disbaled it to test aswell. Anyway - I have loaded several MYsql clients on my winxp pro pc on my home LAN, eg Dbmanager. I ahve set the settinsg fine, and each time I try and connection I get the error:- Lost connection to mysql durring query. In the loags it says:- Number of processes running now: 1 mysqld process hanging, pid 2522 - killed 030125 17:49:36 mysqld restarted /usr/libexec/mysqld: ready for connections So - its killing the pid, which I assume is my connections. Any ideas on what to look for. Scott www.toptravelsites.net www.myeyes-youreyes.co.uk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Segmentation fault when scanning mysqld port
Manuel, And again, this looks like the SuSE bug to me. that's good news, at least now i know it's not just me. Anyone has a good tutorial about updating glibc? :-) If you're lucky, you might be able to use this RPM: ftp://ftp.suse.com/pub/suse/i386/update/8.1/rpm/i586/glibc-2.2.5-161.i58 Now, this seems like version ...-161 to me. On my linux box, I have ...-164 right now. No problem with MySQL. (I wonder why SuSE and - supposedly - Red Hat put old glibc's in their dists. There seems no good reason for doing this.) Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Manuel Kiessling [EMAIL PROTECTED] To: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED] Cc: Benjamin Pflugmann [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, January 26, 2003 11:07 AM Subject: Re: Segmentation fault when scanning mysqld port hello, Stefan Hinz, iConnect (Berlin) wrote: Manuel, Benjamin, And again, this looks like the SuSE bug to me. that's good news, at least now i know it's not just me. Anyone has a good tutorial about updating glibc? :-) -- Manuel Kiessling - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Needed: Working VB6 example of DAO DSN LESS connection using MyODBC to MySQL preferably with passthruquery
Thanks, Barry G. Sumpter Proud Tritoneer President - Triton Woodworkers Club Holmesglen THE TRITONEER Woodworking Australia Bulletin Board Triton Owners and Users Forum Holmesglen Short/DIY Courses Triton Weekend Workshop Triton Woodworking Systems I Triton Woodworking Systems II [EMAIL PROTECTED] (613) 9889-6727 0407 856 646 -Original Message- From: Barry G. Sumpter [mailto:[EMAIL PROTECTED]] Sent: Sunday, 26 January 2003 2:33 PM To: '[EMAIL PROTECTED]' Subject: Needed: Working VB6 example of DAO DSN LESS connection using MyODBC to MySQL preferably with passthruquery This message intended for MyODBC questions list. Hello VB6, MySQL, and DAO developers, A very simple example of my problem: Dim ws As Workspace Dim conn As Connection Dim str As String Set ws = DBEngine.CreateWorkspace(testing, , , dbUseODBC) str = odbc;driver={MySQL ODBC 3.51 Driver}; _ SERVER=localhost; _ DATABASE=test; _ UID=;PWD=;OPTION=3 Set conn = ws.OpenConnection(test, dbDriverNoPrompt, False , str) 'this last line errors with ' -- Run-time error '3146' - ODBC--Call Failed. 'if I use: ' Set conn = ws.OpenConnection(test, dbDriverPrompt, False , str) 'and just select OK on the ODBC Connection Manager ' everything work properly - I can't figure out why. ' Maybe because this turns my connection into a DSN connection. I'm using all the latest and gratest installs on a MS WIndows 2000. Does anyone know OFFICIALLY if the DAO DSN LESS openconnection is supposed to work or not? If so, could you please post hyperlink for all to share? Can anyone please test this OpenConnection on their PC? Can you get it to work? If so, Could you please post the working code here for all to share? Does anyone have DAO DSN LESS openconnection code working? If so, Could you please post your working code here for all to share? I'm interested in working/tested/proven code examples. Also, could someone please point me in the right direction for setting the passthruquery flag? Where do I set the flag? MySQL or maybe in the connection settings? If you don't know what DSN LESS means then please post your question in another thread. If you want to discuss ADO over DAO please post your question in another thread. Thanks, Barry G. Sumpter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: How to speed things up in MySQL ?
Zak Greant wrote: I am coming in a bit late on this - however, did you send in a copy of the table structure? It sounds like you don't have indexes on the tables. --zak On Sun, Jan 26, 2003 at 12:59:31AM +0100, Thomas Kvamme wrote: Hi again, Just did another test which I find very interesting Using the Paradox table instead of the MySQL table I managed to load each and every record search through every field (including all the text in all the blob field) in just 6 seconds. and still doing a simple group SELECT GROUP BY on the same table in MySQL takes 13 seconds... still can't belive it. -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com MySQL Tip: Impress your friends with nifty MySQL one-liners % mysql --execute \u mysql; SELECT DISTINCT user FROM user ORDER BY user; Support Global Human Rights - Amnesty International (http://amnesty.org) Hi, I do have indexes... ID - PRIMARY KEY Secondary Indexes: Title (Title, ProductionYear) NorwegianTitle (NorwegianTitle, ProductionYear) I even added anotherr Index: ProductionYear (ProductionYear) The GROUP BY still takes more than 10 seconds. I guess the reason for this is that the I have a some blob fields whitch are all used.. (each record consist of approx 600 KB...) But since I donesn't include any of the blob fields in the SELECT statement I can't see no reason why MySQL should scan all the fields. ** Table Dump * BEGIN *** -- MySQL dump 9.07 -- -- Host: localhostDatabase: tdd - -- Server version 4.0.9-gamma-nt -- -- Table structure for table 'dvd' -- CREATE TABLE dvd ( ID int(11) NOT NULL auto_increment, Title varchar(100) default NULL, ProductionYear varchar(4) default NULL, TagLine varchar(200) default NULL, NorwegianTitle varchar(100) default NULL, NorwegianTagLine varchar(200) default '', Director varchar(100) default '', Story varchar(100) default '', Producer varchar(100) default '', Genre varchar(100) default '', Production varchar(200) default '', Distribution varchar(200) default '', NorwegianDistribution varchar(200) default '', ScreenFormat varchar(50) default '16:9 Anamorphic Widescreen', AspectRatio varchar(10) default '2:35:1', DVDDiscType char(2) default '9', DVDRegion char(1) default '2', RunningTime time default '00:00:00', IMDB varchar(20) default '', Starring blob, SoundTracks blob, Subtitles blob, SpecialFeatures blob, Comments blob, PlotOutline blob, FullCredits longblob, Cover longblob, THXCertified enum('False','True') default 'False', DDEX enum('False','True') default 'False', DTS enum('False','True') default 'False', MPEG enum('False','True') default 'False', Recommended enum('False','True') default 'False', Added datetime default '-00-00 00:00:00', Updated datetime default '-00-00 00:00:00', PRIMARY KEY (ID), KEY Added (Added), KEY Title (Title,ProductionYear), KEY NorwegianTitle (NorwegianTitle,ProductionYear) ) TYPE=MyISAM; * END - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: How to speed things up in MySQL ?
Benjamin Pflugmann [EMAIL PROTECTED] wrote: Hi. Hi Benjamin :-) On Sun 2003-01-26 at 00:26:32 +0100, [EMAIL PROTECTED] wrote: Here is the table definition as requested. I'm sorry I could take a full dump... Each record consist of approx 600 KB (just as in the Paradox table) so the file would be very big. (200 MB). Well, you should have told us that to begin with. ;) Sorry about that.. but since the Paradox table have the same size and aprarently not the problem so I didn't think it was necessary. 600KB/record is not that usual. You are querying for ProductionYear but have no usuable index for it. That results in a full table scan, which has to read 200MB from disk, which is not unreasonble to take 13 secs, depending on your hardware. Btw, this also means that you can disregard my comment from the other mail about disk usage. I really did not expect your rows being so large without you mentioning it. Why does MySQL needs to scan the Entire Table (all 200 MB) when I only have selected ID ProductionYear in the SELECT statement ?? Paradox BDE only scans/read the selected fields. (otherwise Paradox would use the same amount of time of course). Don't know why Paradox is faster. Maybe it can make partial use of one of the combined indexes which contain ProductionYear. I added another Index KEY (ProductionYear). Well... It gave me 3 seconds... so still the commands takes more than 10 seconds to complete. I tested this on Paradox as well... I removed ALL index and tried again... still the same greate speed even without indexes. and I think - this becasue it doesn't need to read/scan all the fields not specified in the SELECT statement. I guess it would be too much to ask the MySQL development team to re-organize MySQL on a file-level *lol* But I think the problem here is that the table consist of 1 big file that way MySQL must to read the entire record so the file pointer is at the beginning of the next record and ready to read it. In Paradox all Non-Fixed-Length fields such as Blob fields etc. are stored in a separate file... while the primary file only contains pointers to the Dynamic file if you like So taking a full scan doesn't require it to read/scan through Blob fields unless they are specified within the SELECT statement. Kind Regards Thomas Kvamme [EMAIL PROTECTED] Anyhow, creating an index on ProductionYear will do the job, so that the query runs fast. I am not sure if referring to ID in count(ID) is a problem. If so, replace it by count(*) additionally. Tested this... didn't make any difference (even on MySQL nor Paradox). If you often have to query on non-indexed fields, the usual solution is to split up the table into two: one containing the fields on which you want to query, the other the fields which you only query by primary key (probably most blob fields). And use a join if you want some blob depending on one of the query fields. This way the table size to read for full table scans will be much smaller. Btw, this is not MySQL-specific, but true for any database. It would also get the times with Paradox in the sub-second range. HTH, Benjamin. PS: Why don't you use a (small)int for ProductionYear? CREATE TABLE dvd ( ID int(11) NOT NULL auto_increment, Title varchar(100) default NULL, ProductionYear varchar(4) default NULL, [...] Starring blob, SoundTracks blob, Subtitles blob, SpecialFeatures blob, Comments blob, PlotOutline blob, FullCredits longblob, Cover longblob, [...] PRIMARY KEY (ID), KEY Added (Added), KEY Title (Title,ProductionYear), KEY NorwegianTitle (NorwegianTitle,ProductionYear) ) TYPE=MyISAM; * END [...] mysql select count(id) as Films, ProductionYear from DVD - group by ProductionYear - order by ProductionYear desc; [...] -- [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
Red Hat 8.0 problems installing from source
I am installing MySQL 4.0.9 on a server running Red Hat 8.0 but am running into some showstoppers. I seem to have success compiling - no warnings are raised - but mysql_install_db will crash when installing the grant tables. Initially I thought it may have been the hardware configuration (I have had some hardware and driver issues) however testing on other systems of different configurations end in the same result. Installing the binary distribution will work fine, but unfortunately I need to modify the stopword list in ft_static.c Is anyone else experiencing these problems under Red Hat 8.0? I notice from mailing lists there are some known issues but these seem to be of a different nature to the ones I am experiencing. Here is my configure line: ./configure --prefix=/usr/local/mysql --localstatedir=/home/database/mysql --enable-assembler --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --enable-thread-safe-client Here is the output from mysql_install_db: # ./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 mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=8388600 read_buffer_size=131072 sort_buffer_size=2097144 max_used_connections=0 max_connections=100 threads_connected=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 225791 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=0x83b1720 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, fp=0xbf5fea88, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x8088860 0x822b9b8 0x8242336 0x80980fd 0x809adde 0x8097f1c 0x80929c0 0x8226e0d 0x82629da ./scripts/mysql_install_db: line 1: 24876 Segmentation fault /usr/local/mysql/libexec/mysqld --bootstrap --skip-grant-tables --basedir=/usr/local/mysql --datadir=/home/database/mysql --skip-innodb --skip-bdb Installation of grant tables failed! Here is some additional information from mysqlbug: Release:mysql-4.0.9-gamma (Source distribution) C compiler: gcc (GCC) 3.2 20020903 (Red Hat Linux 8.0 3.2-7) C++ compiler: g++ (GCC) 3.2 20020903 (Red Hat Linux 8.0 3.2-7) System: Linux minime 2.4.18-14 #1 Wed Sep 4 13:35:50 EDT 2002 i686 i686 i386 GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.2/specs Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking --host=i386-redhat-linux --with-system-zlib --enable-__cxa_atexit Thread model: posix gcc version 3.2 20020903 (Red Hat Linux 8.0 3.2-7) Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' ASFLAGS='' LIBC: lrwxrwxrwx1 root root 14 Jan 25 17:36 /lib/libc.so.6 - libc-2.2.93.so -rwxr-xr-x1 root root 1235468 Sep 5 23:12 /lib/libc-2.2.93.so -rw-r--r--1 root root 2233342 Sep 5 22:59 /usr/lib/libc.a -rw-r--r--1 root root 178 Sep 5 22:50 /usr/lib/libc.so Configure command: ./configure '--prefix=/usr/local/mysql' '--localstatedir=/home/database/mysql' '--enable-assembler' '--disable-shared' '--with-mysqld-ldflags=-all-static' '--with-client-ldflags=-all-static' '--enable-thread-safe-client' I hope this information is helpful to anyone who might be willing to have a look into this. If there is any other assistance I can provide please let me know. Cheers, Duncan [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: How to speed things up in MySQL ?
Hi. On Sun 2003-01-26 at 15:22:06 +0100, [EMAIL PROTECTED] wrote: Benjamin Pflugmann [EMAIL PROTECTED] wrote: [...] Why does MySQL needs to scan the Entire Table (all 200 MB) when I only have selected ID ProductionYear in the SELECT statement ?? Because you have a table with variable-width records and there is no way to easily find out where a field of a record is stored without reading all. Paradox BDE only scans/read the selected fields. (otherwise Paradox would use the same amount of time of course). Well, I suggest to stop thinking about low-level properties in the Paradox way. That Paradox can do such scans is a side-effect or their low-level design decisions. Those are almost always trade-offs. I am sure there other use cases where MySQL is faster than Paradox due to the same design decisions. I presume they store blobs in their own tablespace/segment and therefore can treat the rest of the table as fixed length for the purpose of this discussion. It's obvious that this will be slower, when you access these blobs. [...] I added another Index KEY (ProductionYear). Well... It gave me 3 seconds... so still the commands takes more than 10 seconds to complete. That's still much too slow. The query you posted last time, should only use the index file to be resolved. Can you post the result of EXPLAIN for the query? I tested this on Paradox as well... I removed ALL index and tried again... still the same greate speed even without indexes. and I think - this becasue it doesn't need to read/scan all the fields not specified in the SELECT statement. Sounds true. I guess it would be too much to ask the MySQL development team to re-organize MySQL on a file-level *lol* But I think the problem here is that the table consist of 1 big file that way MySQL must to read the entire record so the file pointer is at the beginning of the next record and ready to read it. Correct. In Paradox all Non-Fixed-Length fields such as Blob fields etc. are stored in a separate file... while the primary file only contains pointers to the Dynamic file if you like Ah. As I thought. If that is for all non-fixed-length fields, then Title (VARCHAR) should be such a field and selecting records based on Title is slow on Paradox, too? Or do they waste space by treating it like a fixed CHAR(100) field? So taking a full scan doesn't require it to read/scan through Blob fields unless they are specified within the SELECT statement. Well, as I said last time, the way to archieve full speed with other database engines is to split the table into two, based on size and on whether the field will be used in the WHERE clause. In your case it should be enough to move the biggest fields to a seperate table. Anyhow, creating an index on ProductionYear will do the job, so that the query runs fast. I am not sure if referring to ID in count(ID) is a problem. If so, replace it by count(*) additionally. Tested this... didn't make any difference (even on MySQL nor Paradox). It should. There is something else wrong. Regards, Benjamin. If you often have to query on non-indexed fields, the usual solution is to split up the table into two: one containing the fields on which you want to query, the other the fields which you only query by primary key (probably most blob fields). And use a join if you want some blob depending on one of the query fields. This way the table size to read for full table scans will be much smaller. Btw, this is not MySQL-specific, but true for any database. It would also get the times with Paradox in the sub-second range. HTH, Benjamin. -- [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: Is there anything like Query Analyser for MySQl
Scott, I was wondering, is there a program simialar to MS SQL server - Query Analyser, where you can write sql queries to query MySQl databases? It's called EXPLAIN. More info: http://www.mysql.com/doc/en/EXPLAIN.html Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Scott Lewis [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, January 26, 2003 11:25 AM Subject: Is there anything like Query Analyser for MySQl I was wondering, is there a program simialar to MS SQL server - Query Analyser, where you can write sql queries to query MySQl databases? 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 and webpages
For decent explanations of concepts and practicalities, try http://www.webmasterbase.com/subcats/53 and more specifically http://www.webmasterbase.com/article/228 There are also good and more advanced tutorials at http://www.onlamp.com/ http://www.devshed.com/ These are superficial scratches on the surface for web-based tutorials. Enjoy, Doug On Sun, 26 Jan 2003 11:00:18 -, Scott Lewis wrote: As you can tell - very new to Mysql. I was wondering, has anyone some links to howto or even better examples of databases and webpages that I can install, and see the web interaction with webpages and a mysql database. Looking at going down that road as exaaples would help. 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
Using LIMIT in simple query gives error
Hi, I have a simple query utilizing LIMIT: SELECT * FROM quotes ORDER BY RAND() LIMIT 1; I've actually had this query on a page for a while now, but all of a sudden ALL my queries with LIMIT in them give this error: You have an error in your SQL syntax near 'LIMIT -1' at line 1 I don't know where to begin to try and solve this problem. Thanks for any help. G --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.445 / Virus Database: 250 - Release Date: 1/21/2003 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: How to speed things up in MySQL ?
Hi! I guess the reason for this is that the I have a some blob fields whitch are all used.. (each record consist of approx 600 KB...) Yes, it's the reason. 600K per record... But since I donesn't include any of the blob fields in the SELECT statement I can't see no reason why MySQL should scan all the fields. Because MyISAM always reads the record as a whole, it cannot read only selected fields. You can convert your table to InnoDB table type - as InnoDB *can* read only selected fields. Actually, it's useful optimization to store big, rarely selected fields in the separate table. This will also help to speed things up. 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: Is there anything like Query Analyser for MySQl
Hey Try SQLyog at http://www.webyog.com/sqlyog Similar interface like MS Query Analyzer and extremely fast. Karam --- Scott Lewis [EMAIL PROTECTED] wrote: I was wondering, is there a program simialar to MS SQL server - Query Analyser, where you can write sql queries to query MySQl databases? 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 __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.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
Re: Segmentation fault when scanning mysqld port
Hello, yep, this one fixed it: ftp://ftp.suse.com/pub/suse/i386/update/8.1/rpm/i586/glibc-2.2.5-161.i586.rpm mysql - gotta love that filter -- Manuel Kiessling - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fw: How to speed things up in MySQL ?
[...] Why does MySQL needs to scan the Entire Table (all 200 MB) when I only have selected ID ProductionYear in the SELECT statement ?? Because you have a table with variable-width records and there is no way to easily find out where a field of a record is stored without reading all. Paradox BDE only scans/read the selected fields. (otherwise Paradox would use the same amount of time of course). Paradox stores blob fields in another file !!! (.MB I guess) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: How to speed things up in MySQL ?
Sergei Golubchik [EMAIL PROTECTED] wrote: Because MyISAM always reads the record as a whole, it cannot read only selected fields. You can convert your table to InnoDB table type - as InnoDB *can* read only selected fields. Actually, it's useful optimization to store big, rarely selected fields in the separate table. This will also help to speed things up. Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ AAAhhh This is orgasmic :-)) Using the MySQL CC I just changed the table type from MyISAM to InnoDB re-issued the SQL Query Here is the result: [TDD - DVD] 39 rows in set (0.02) sec But the field had to be indexed... I tried the same command using Group by Director and it was about 15 seconds again.. then I added a Index for Director... and walla 0.02 seconds. I can index the entire table if necessary :-)) So the question is then... why is MyISAM the default table type ?? I guess it's the preferred table since it is the default talbe but Why ? Using MyISAM it seems that all the tables are stored under a directory reflecting the Database Name. which was nice.. Using InnoDB I now have 4 new files in the \MySql\Data\ directory... and of course unable to tell which table it belong to reading the name of it. Another question: When I use SELECT COUNT(ID) FROM DVD I always get 320 records as the result. But in MySQL CC when I Right-Click on the Table and Select Refresh the field Records always changes and its incorrect.. -- Thomas Kvamme [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
[50 character or so descriptive subject here (for reference)]
Description: How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:Yuriy Povhanich Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-3.23.49 (Source distribution) Environment: System: FreeBSD iserver.perechin.com.ua 4.2-RELEASE FreeBSD 4.2-RELEASE #0: Fri Dec 6 01:22:41 EET 2002 [EMAIL PROTECTED]:/usr/src/sys/compile/ISERVER i386 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Using builtin specs. gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: -r--r--r-- 1 root wheel 1169076 Nov 20 2000 /usr/lib/libc.a lrwxrwxrwx 1 root wheel 9 Jan 11 00:56 /usr/lib/libc.so - libc.so.4 -r--r--r-- 1 root wheel 559196 Nov 20 2000 /usr/lib/libc.so.4 Configure command: ./configure --prefix=/usr/local/mysql --enable-assembler --with-unix-socket-path=/tmp/mysql.socket --with-mysqld-user=mysql Perl: This is perl, version 5.005_03 built for i386-freebsd - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
problem
Zdravo mysql, I tried to install MySQL mysql-3.23.55-win on WinXp Platform. I did installed it but I can't start MySQL...??? Can You Help me??? +++Info About this E-mail+ +Poruka je napisana u 11:57:54 + +Dana Sunday, January 26, 2003 + +Files in this E-mail massage+ +none + ++ +Email: [EMAIL PROTECTED] + ++ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Make fails when compiling 4.0.9 on Mac OS X 10.2.3
Hello: I've recently upgraded my OS to Jaguar. I tried to compile the latest MySQL (4.0.9). However, make fails because it can't find dlfcn.h . I'm certain this is NOT present in Jaguar (OS 10.2.4) even with the latest developer tools installed. I think from the responses on the Apple discussion boards that users that are using either Fink or Darwin Ports will have this installed. However the install documents with the source code should note this for Mac OS X users. The fix is to install this package from Darwin.org: http://www.opendarwin.org/projects/dlcompat/ With this installed MySQL compiles and installs successfully. David Fedoruk, B.Mus. [EMAIL PROTECTED] [EMAIL PROTECTED] 604 687-7689 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Is there anything like Query Analyser for MySQl
That seems to be a dead download link. -- Loren McDonald AKA MisterrMac Gods Of Music Reviewer/Editor [EMAIL PROTECTED] http://www.GodsOfMusic.com -Original Message- From: Karam Chand [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 26, 2003 11:42 AM To: Scott Lewis; [EMAIL PROTECTED] Subject: Re: Is there anything like Query Analyser for MySQl Hey Try SQLyog at http://www.webyog.com/sqlyog Similar interface like MS Query Analyzer and extremely fast. Karam --- Scott Lewis [EMAIL PROTECTED] wrote: I was wondering, is there a program simialar to MS SQL server - Query Analyser, where you can write sql queries to query MySQl databases? 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
Re: How to speed things up in MySQL ?
I guess the reason for this is that the I have a some blob fields whitch are all used.. (each record consist of approx 600 KB...) There it is. MySQL's MyISAM will get the whole record even if it only needs a part. You can try InnoDB as it does it differently. [At some point I may try and add that capability to MyISAM. I've been researching good ways to compress text and still search it in its compressed state. Then I hope to add the ability of MyISAM tables to automatically compress TEXT/VARCHAR/CHAR (non binary) fields without worrying about uncompressing everything if someone does a LIKE on that field. BLOBs can use gzip type compression. And neither the data nor decompression should occur if the field is not used. When I get more time...] However, back to your issue. Have you tried adding INDEX(ProductionYear,ID)? That would prevent MySQL from having to read the datafile at all, since it could find everything it needs in the index file. My speed guesses: o If you didn't change the structure of the table or add an index, then switching to InnoDB would improve performance quite a bit. o Adding an index(ProductionYear) to the above InnoDB table would speed things even more. o Adding INDEX(ProductionYear,ID) to the MyISAM table would be even faster still. -steve- http://Network54.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: Is there anything like Query Analyser for MySQl
I've just downloaded it and it works for me. Thanks, Barry G. Sumpter -Original Message- From: Loren McDonald [mailto:[EMAIL PROTECTED]] Sent: Monday, 27 January 2003 7:26 AM To: 'Karam Chand'; 'Scott Lewis'; [EMAIL PROTECTED] Subject: RE: Is there anything like Query Analyser for MySQl That seems to be a dead download link. -- Loren McDonald AKA MisterrMac Gods Of Music Reviewer/Editor [EMAIL PROTECTED] http://www.GodsOfMusic.com -Original Message- From: Karam Chand [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 26, 2003 11:42 AM To: Scott Lewis; [EMAIL PROTECTED] Subject: Re: Is there anything like Query Analyser for MySQl Hey Try SQLyog at http://www.webyog.com/sqlyog Similar interface like MS Query Analyzer and extremely fast. Karam --- Scott Lewis [EMAIL PROTECTED] wrote: I was wondering, is there a program simialar to MS SQL server - Query Analyser, where you can write sql queries to query MySQl databases? 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 and webpages
www.php.net -- links www.google.com -- search for tutorials mysql php --B. -Oorspronkelijk bericht- Van: Doug Thompson [mailto:[EMAIL PROTECTED]] Verzonden: zondag 26 januari 2003 16:39 Aan: [EMAIL PROTECTED]; Scott Lewis Onderwerp: Re: MySQl and webpages For decent explanations of concepts and practicalities, try http://www.webmasterbase.com/subcats/53 and more specifically http://www.webmasterbase.com/article/228 There are also good and more advanced tutorials at http://www.onlamp.com/ http://www.devshed.com/ These are superficial scratches on the surface for web-based tutorials. Enjoy, Doug On Sun, 26 Jan 2003 11:00:18 -, Scott Lewis wrote: As you can tell - very new to Mysql. I was wondering, has anyone some links to howto or even better examples of databases and webpages that I can install, and see the web interaction with webpages and a mysql database. Looking at going down that road as exaaples would help. 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
Strange behaviuor in ver. 4.1(maybe dusty)
Hi, Something very strange was happened on my production server where i have mounted MySQL ver. 4.1 (latest pull on Jan 25, 12:00 GMT) Unfortunatelly i'm not able(a...i didn't start with --log) to reproduce the exact sequence of queries which was send to the server. MySQL was down on this query: SELECT * FROM stoc LIMIT 1; ...where table stoc is MyISAM and has aprox.150.000 of rows(stoc.MYD -14 MB,stoc.MY-23 MB). IMHO: I'm sure that is nothing wrong with this query because after mysql daemon was restarting, it was successfully executed. Anyhow,mysqld log said: == Alarm status: Active alarms: 1 Max used alarms: 3 Next alarm time: 28765 cNewCount: 45 Memory that was not free'ed (402786381 bytes): 1024 bytes at 0x008424df8, allocated at line 79 in 'hash_filo.h' 8152 bytes at 0x008882a88, allocated at line 2368 in 'sql_acl.cc' 8 bytes at 0x0088b1ac0, allocated at line 277 in 'array.c' 12 bytes at 0x008882a58, allocated at line 277 in 'array.c' 56 bytes at 0x0088b1b68, allocated at line 277 in 'array.c' 368 bytes at 0x0088b1930, allocated at line 277 in 'array.c' 968 bytes at 0x00889f1b0, allocated at line 94 in 'my_alloc.c' 24 bytes at 0x0088b1b30, allocated at line 277 in 'array.c' 2048 bytes at 0x0088b05d0, allocated at line 79 in 'hash_filo.h' 8 bytes at 0x0088af718, allocated at line 545 in 'sql_db.cc' 16384 bytes at 0x0088b67c8, allocated at line 154 in 'sql_string.h' 4112 bytes at 0x0088b5798, allocated at line 40 in 'my_alloc.c' 8208 bytes at 0x0088b3768, allocated at line 40 in 'my_alloc.c' 5 bytes at 0x0088b3740, allocated at line 201 in 'sql_parse.cc' 11 bytes at 0x00889c038, allocated at line 517 in 'sql_parse.cc' 16391 bytes at 0x0088ab5e8, allocated at line 90 in 'net_serv.cc' 84 bytes at 0x00889bbc8, allocated at line 129 in 'vio.c' 32768 bytes at 0x0088a35c8, allocated at line 178 in 'mf_iocache.c' 3 bytes at 0x00889bba0, allocated at line 66 in 'mf_cache.c' 6 bytes at 0x00889bb78, allocated at line 65 in 'mf_cache.c' 128 bytes at 0x00889bad8, allocated at line 147 in 'sql_class.cc' 3072 bytes at 0x0088a29a8, allocated at line 283 in 'sql_list.h' 256 bytes at 0x008887ce8, allocated at line 132 in 'sql_udf.cc' 496 bytes at 0x008878dd0, allocated at line 54 in 'queues.c' 800 bytes at 0x008878988, allocated at line 318 in 'sql_parse.cc' 8136 bytes at 0x0088769a0, allocated at line 94 in 'my_alloc.c' 8136 bytes at 0x0088749b8, allocated at line 94 in 'my_alloc.c' 248 bytes at 0x0088748a0, allocated at line 43 in 'ft_stopwords.c' 18599440 bytes at 0x059359020, allocated at line 119 in 'mf_keycache.c' 384053248 bytes at 0x042515020, allocated at line 117 in 'mf_keycache.c' 256 bytes at 0x008874780, allocated at line 814 in 'ha_innodb.cc' 24 bytes at 0x008422f20, allocated at line 700 in 'ha_innodb.cc' 1024 bytes at 0x008425218, allocated at line 209 in 'repl_failsafe.cc' 4224 bytes at 0x008423cb8, allocated at line 54 in 'sql_base.cc' 128 bytes at 0x008422710, allocated at line 49 in 'my_bitmap.c' 530 bytes at 0x008422c50, allocated at line 599 in 'charset.c' 672 bytes at 0x008422208, allocated at line 1402 in 'set_var.cc' 128 bytes at 0x00841e658, allocated at line 1621 in 'item_func.cc' 13411 bytes at 0x00841ed80, allocated at line 83 in 'derror.cc' 6 bytes at 0x00841e2d8, allocated at line 4947 in 'mysqld.cc' 6 bytes at 0x00841e2b0, allocated at line 51 in 'mf_tempdir.c' 4 bytes at 0x00841e288, allocated at line 32 in 'mf_tempdir.c' 456 bytes at 0x00841eb98, allocated at line 94 in 'my_alloc.c' 456 bytes at 0x00841e9b0, allocated at line 94 in 'my_alloc.c' 456 bytes at 0x00841e7c8, allocated at line 94 in 'my_alloc.c' Maximum memory usage: 409950738 bytes (400343k) 030126 23:47:13 /mysql-4.1/libexec/mysqld: Normal shutdown 030126 23:47:13 InnoDB: Starting shutdown... 030126 23:47:14 InnoDB: Shutdown completed 030126 23:48:59 mysqld started 030126 23:49:03 InnoDB: Started /mysql-4.1/libexec/mysqld: ready for connections = Maybe this help. Best regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [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: problem
On Sun, 2003-01-26 at 15:58, Beogradjanin wrote: Zdravo mysql, I tried to install MySQL mysql-3.23.55-win on WinXp Platform. I did installed it but I can't start MySQL...??? Can You Help me??? What happens when you try Startup-AdminTools-Services-mysql-start? -- __ / \\ @ __ __@ Adolfo Bello [EMAIL PROTECTED] / // // /\ / \\ // \ // Bello Ingenieria S.A, ICQ: 65910258 / \\ // / \\ / // // / //cel: +58 416 609-6213 /___// // / _/ \__\\ //__/ // fax: +58 212 952-6797 www.bisapi.com //pager: www.tun-tun.com (# 609-6213) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problems downloading myodbc
Dear Sir or Madam, I have been having problems downloading myodbc from your website. I went to web page http://www.mysql.com/downloads/api-myodbc-2.50.html. I then selected the option MyODBC 2.50.39NT/2000/XP full setup (1.5M)Download As a result of a number of attempts one of two things happened: Thing 1: A message in the download window appears that says Click open to launch the application associated with . . . When I did this a dos box opened and a message in the ISP window indicated that data was coming. The count (in the ISP window) increased over time indicating that a transfer of some kind was indeed taking place. After waiting for nearly two hours the transfer did not terminate - I had to manually interrupt it. A 28Kbyte file MyODBC had been down loaded but not the 1.5 Mbytes file expected. And when this file is run, the dos box as described above opens. Thing 2: I clicked the open button and a WinZip dialog box appeared. When I tried to unzip the file WinZip said that it could not do so because the file was an unrecognisable format. Please advise me as to what to do to successfully download the myodbc driver. Finally, am I correct in thinking that the myodbc driver must be installed in Windows 2000 in order to access an SQL database via MYSQL from a Windows application? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem connecting to DB
Zdravo mysql, Hi I have problem connectong to DB MySQL Attempting to attach to database... The database has failed to connect because you do not have permission to connect to the server. Please go back to the last step and ensure that you have entered all your login details correctly. I did all of it still can;t connect tell me what to do ? +++Info About this E-mail+ +Poruka je napisana u 17:38:31 + +Dana Sunday, January 26, 2003 + +Files in this E-mail massage+ +none + ++ +Email: [EMAIL PROTECTED] + ++ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Is there anything like Query Analyser for MySQl
Have a look at urSQL -- http://www.urbanresearch.com/ursql --- Scott Lewis [EMAIL PROTECTED] wrote: I was wondering, is there a program simialar to MS SQL server - Query Analyser, where you can write sql queries to query MySQl databases? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: How to speed things up in MySQL ?
Steven Roussey wrote: I guess the reason for this is that the I have a some blob fields whitch are all used.. (each record consist of approx 600 KB...) There it is. MySQL's MyISAM will get the whole record even if it only needs a part. You can try InnoDB as it does it differently. Hi Steve, Yes I tried changing the table to InnoDB and I got a great speed at once... if the ProductionYear field was indexed. But on Non-indexed field it actually seemed to be a bit slover than the MyISAM. [At some point I may try and add that capability to MyISAM. I've been researching good ways to compress text and still search it in its compressed state. Then I hope to add the ability of MyISAM tables to automatically compress TEXT/VARCHAR/CHAR (non binary) fields without worrying about uncompressing everything if someone does a LIKE on that field. BLOBs can use gzip type compression. And neither the data nor decompression should occur if the field is not used. When I get more time...] Yes.. This sound like a nice feature. :-) However, back to your issue. Have you tried adding INDEX(ProductionYear,ID)? That would prevent MySQL from having to read the datafile at all, since it could find everything it needs in the index file. My ID field has always been the Primary Key and I added ProductionYear as a INDEX. Like this INDEX(ProductionYear). I just tried adding the ID to that index as you suggest above and I got the desired speed right away :-))) And when I did an Explain select... the Type changed from ALL to Index :-) My speed guesses: o If you didn't change the structure of the table or add an index, then switching to InnoDB would improve performance quite a bit. Tested Verified :-) o Adding an index(ProductionYear) to the above InnoDB table would speed things even more. Tested Verified :-) o Adding INDEX(ProductionYear,ID) to the MyISAM table would be even faster still. Tested Verified :-) -steve- http://Network54.com Thanks to all of you who have spent time in my problem... I now consider the problem as solved :-) If I want to have all my data in one table as inteded I have now received 3 possible solution to gain maximum speed. 1.Modify Index to INDEX(ProductionYear, ID) - and conintue to use MyISAM 2.Convert Table to InnoDB and Add INDEX(ProductionYear). 3.Split up the table and e.g. keep blob fields etc. in a separate table. I very mutch like the file structure used by MyISAM table compared to InnoDB and will therefore stay with the MyISAM Table Type :-) And I will Add the ID field to my ProductionYear Index. I will also as people have suggested split up my table moving my biggest field (Cover blob) to a separate table. I actially tested this: Before I added ID to the Index which required the select command to do a full scan I got a greate speed by just moving the Cover field to a separate table... and by adding the ID to the Index I gained another fraction of second :-) Again.. Thanks to you all for the support Kind Regards Thomas Kvamme [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
LWE - Dinner with Richard Stallman
I wanted to thank Monty, Dave Axmart and the MYSQL team for coming to support the NYLXS - Free Software Institute in NYC this past week after LWE!! Monty - Your the greatest... but we all knew that Ruben -- __ Brooklyn Linux Solutions __ DRM is THEFT - We are the STAKEHOLDERS http://fairuse.nylxs.com http://www.mrbrklyn.com - Consulting http://www.inns.net -- Happy Clients http://www.nylxs.com - Leadership Development in Free Software http://www2.mrbrklyn.com/resources - Unpublished Archive or stories and articles from around the net http://www2.mrbrklyn.com/downtown.html - See the New Downtown Brooklyn 1-718-382-0585 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Is there anything like Query Analyser for MySQl
You're right. Perhaps it had something to do with the massive worm attack yesterday. It was erroring out with a file not found when I tried last night, but today it worked. -- Loren McDonald [EMAIL PROTECTED] -- Loren McDonald AKA MisterrMac Gods Of Music Reviewer/Editor [EMAIL PROTECTED] http://www.GodsOfMusic.com -Original Message- From: Barry G. Sumpter [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 26, 2003 5:06 PM To: [EMAIL PROTECTED]; 'Karam Chand'; 'Scott Lewis'; [EMAIL PROTECTED] Subject: RE: Is there anything like Query Analyser for MySQl I've just downloaded it and it works for me. Thanks, Barry G. Sumpter -Original Message- From: Loren McDonald [mailto:[EMAIL PROTECTED]] Sent: Monday, 27 January 2003 7:26 AM To: 'Karam Chand'; 'Scott Lewis'; [EMAIL PROTECTED] Subject: RE: Is there anything like Query Analyser for MySQl That seems to be a dead download link. -- Loren McDonald AKA MisterrMac Gods Of Music Reviewer/Editor [EMAIL PROTECTED] http://www.GodsOfMusic.com -Original Message- From: Karam Chand [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 26, 2003 11:42 AM To: Scott Lewis; [EMAIL PROTECTED] Subject: Re: Is there anything like Query Analyser for MySQl Hey Try SQLyog at http://www.webyog.com/sqlyog Similar interface like MS Query Analyzer and extremely fast. Karam --- Scott Lewis [EMAIL PROTECTED] wrote: I was wondering, is there a program simialar to MS SQL server - Query Analyser, where you can write sql queries to query MySQl databases? 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-mysql- [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
Weird Problem.
Ok, I have a program I am working on, there is probably just something I don't understand about the behaviour of the C API and not a bug with MySQL's C api. I have an app that listens on a specified TCP port, once a user connects and successfully authenticates, two more processes are spawned (leaving the single original process to accept new connections), one process sits with a blocking read() on the tcp socket with the user, and just waits to recieve text data from the user, the other process waits till it has text data to write() to the user's socket. This program uses a MySQL backend to manage things like usernames and passwords, etc. If the user sends data just for the server, there is no problem working with MySQL, if the user recieves data from another user, there is still no trouble, but when the user sends data to another user, and then makes a request to the server that results in the server calling mysql_real_connect(), mysql_real_connect() just hangs indefinately (the mysql_init() call prior to the call to mysql_real_connect() appears to work fine though). I really have no idea why either, I've found nothing in the docs or mailing list archives that seems anything like the trouble I am experiencing. Let me try to explain the problem more clearly: User A recieves data from User B, no MySQL trouble, User A sends data to the server, no MySQL trouble, User A sends data to User B, we have trouble (and of course, User B has trouble if he sends data to User A). User A-TCPsocketA-processA read()-processA connect to process B's unix socket-processB read() read data from unix socket from processA- processB write()-TCPsocketB-User B And this causes mysql_real_connect() to hang if User A makes a request that causes the server to attempt to mysql_real_connect. I've run tcpdump and I've seen that mysql_real_connection seems to work at first, there is some talking between the client and MySQL, but then things just stop working, I also have this problem if I do a local connection with MySQL as well. Here are my system specs: mysqld Ver 3.23.54 for pc-linux-gnu on i686 I've tried with kernel 2.5.59 as well, I'm currently using: 2.4.21-pre3 I have dual pentium III 800 mhz cpu's (133 fsb) 1 GB of pc133 ram If more info is needed, I will glady provide it. Thanks. -Cameron --- Oh what is this test, Knights Who say... Oh Knights who until recently, said Ni? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Lack of DBD support for mysql in Windows XP?
I tried in vain to get DBD::mysql installed on a Windows XP machine running mysql. I used ppm to download DBD, and DBD::mysql and DBD-mysql, etc. and got the following errors. 'Error installing package 'DBD' : Could not locate a PPD file for package DBD. I know this is really a PERL problem, but wondered if anyone has a solution or work-around. I want to install IKONBOARD, but can't without a functional database. Steve Scanlan _ The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Server Down - Need Help
Hello all: I have a production server that is currently down and am looking for help. WIN2k Server, mysql 3.23 The background is this - I was creating an index, and someone decided to reboot the system. When the system came back up, mysql would not start. When we looked at the service, it indicates it is marked for deletion, and the path/exe information is trashed. The path exe do not exist. Any ideas/help would be greatly appreciated. Carlin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Will MYSQL scale to 100 million+ records for an online content exchangebased on something like oscommerce?
Hello! I very much appreciate the threads on similar topics, and I apologize if this seems redundant. Suppose I am using something like oscommerce.com for an online stock photography site. I have bugun modifying oscommerce for such a purpose at http://vvgallery.org . Does anyone have any feeling regarding whether it will scale to a hundred million images? It's not a Wall Street bank, so the typical transaction will be under a hundred dollars. We'll have somewhere between 10-100 million records describing basic digital rights of media files. Ideally the code would be optimized for transactions. Anyone interested in helping out? My hunch is that the shopping cart software at OSCOMMERCE.COM, running on a monster machine(s) and with some tweaking to handle transactions, could handle quite a lot of traffic. We have resources for a couple monster machines--either dual or quad xeons. The functionality of MYSQL 4.1 seems pretty adequate for our needs. We could perhaps be looking to compensate someone who would enjoy taking such a project on, or consulting about it. If you see any bugs at vvgallery, please let me know at [EMAIL PROTECTED] I'd like to iron the bugs out before releasing the mods. Vincent Van Gallery facilitates stock photography shops and digital media libraries. Users can browse thumbnailed and watermarked images, fill a cart with selections, and pay to download high resolution originals in a zipped bundle. Based upon oscommerce (mostly) and gallery (more and more in coming months), vvgallery is written in php and mysql upon a LAMP platform. vvgallery uses GD and NetPBM to provide image manipulation, thumbnailing, and watermarking. RSS, RDF, and the Dublin Core are being integrated to manage basic digital rights associated with media. The Creative Commons licenses will be included as rights options. Please contact [EMAIL PROTECTED] with any questions. We'll be rolling it out piece by piece, and your help at sourceforge would be very much appreciated! In future releases I'll be using the download attribute in oscommerce. I'd like to eventually make all the vvgallery mods official contributions. I think a lot of this functionality could be integrated into oscommerce in the coming months. VVGALLERY FEATURES GOALS # 0. Make VVGallery scalable to 100 million images. # 1. Support all types of media. (pdf, mp3, jpg, mov, wav, doc, etc.) # 2. Offer syndicated commerce for media collections via RSS/RDF. # 3. Offer customers the option of receiving media on a CD ROM. # 4. Allow satellite galleries to interact with VVGallery via RSS/RDF and REST, XML-RPC, or SOAP. # 5. Offer full integration of the Dublin Core and rights management. # 6. Integrate the Creative Commons licenses. # 7. Mass importing and exporting of entire media libraries, via RSS/RDF. # 8. Offer watermarking (visible invisible) and manipulation with exif, GD library, and netPBM. # 9. Release VVGallery as modules for oscommerce, gallery, and then postnuke would follow. Thanks again for your time. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: copying innodb data
Hello Pippin I installed MySQLFront and can connect to my remote LinuxBox DB server. But I cant connect to my local machine with MySQLFront. My LinuxBOX server is listening to port 3316. My WinNTBOX server is listening to port 3306 But using PhpMyAdmin I can connect to both the servers from my WinNtBox. Any suggestions? regards KayambooSuresh - Original Message - From: Scott Pippin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, January 25, 2003 12:30 AM Subject: Re: copying innodb data I need to move my database from a WindowsNT environment to a Linux RedHat7.0 Box. I am now using innodb tables. Is there any easy way of copying my existing tables in NT Box to Linux? Download MySQLFront from: http://mysqlfront.sstienemann.de/ Install it on your windows machine and log in to the MySQL server on your windows machine. Then open another window and log in to your linux box in MySQLFront. Click on the Import/Export option and select Export tables. Select the Another Host/Db option. I hope this works, let me know if you have any other problems. Scott Pippin [EMAIL PROTECTED] (sql, query, mysql) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: copying innodb data
Hello Scott Pippin A small mistake on myside. Everything worked fine. Thanks for the suggestions. regards KayambooSuresh - Original Message - From: Scott Pippin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, January 25, 2003 5:54 AM Subject: Re: copying innodb data Hello folks I need to move my database from a WindowsNT environment to a Linux RedHat7.0 Box. I am now using innodb tables. Is there any easy way of copying my existing tables in NT Box to Linux? 1. Download MysqlFront from http://mysqlfront.sstienemann.de/ 2. Install on Windows machine. Open a connection window to both your windows MySQL server and your Linux MySQL server. 3. Click on the import/export menu and select export tables. 4. click on the Another Host/db option and select you Linux MySQL Server, then copy the tables over. This worked a lot better for me than mysqldump. The larger tables seemed to transfer faster than with mysqldump. Let me know if you have any other questions. Scott Pippin [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql.sock is missing
Hi, I'm staring mysql with mysql -u root mysql but I'm geting this error message: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'. I cannot find Mysql.sock anywhere, but I was running mysql before reboot the linux sytem. What can I do to recover/reinstall/run the mysql server again? I didn't find mysql.server, but I do have mysql.server* on dir /usr/share/mysql. I'm running Mandrake 9 and Mysql-323.54a (rpm). Thank you in advance Pedro - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Need Help!!!
Hi to All, I've been a member of this mailing list for quite a long time and very thankful that most of my difficulty in creating queries are being answered by just reading responses to questions. Right now I have a problem in creating a query (in fact I'm not sure if this is possible) that will get data from two tables and display its row from one table followed by the same row number of the other table. Table1 col_1 col_2col_3col_4 AAAA AAAA AAAA AAAA AAAA AAAA AAAA . . . Table2 col_1 col_2col_3col_4 B BBB B BBB B BBB B BBB B BBB B BBB B BBB . . . Query result col_1 col_2col_3col_4 AAAA B BBB AAAA B BBB AAAA B BBB AAAA . . . I will really appreciate any of your help in accomplishing this. Thanks in advance, Richard [This e-mail is confidential and may also be privileged. If you are not the intended recipient, please delete it and notify us immediately; you should not copy or use it for any purpose, nor disclose its contents to any other person. Thank you.] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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£ºÄúºÃ£¡ ¸Û°ÄµçÄÔÍøµÍÓÚÊг¡¼Û50%µÄ¼Û¸ñÏúÊ۱ʼDZ¾µçÄÔ,ÊÖ»ú, ͶӰÒÇ,ÊýÂëÉãÏñ»ú,ÊýÂëÏà»ú, ɨÃèÒÇ,·þÎñÆ÷,´òÓ¡»ú,µçÄÔÅä¼þCPU,Ö÷°å,ÄÚ´æ,Ó²ÅÌ,¹âÇý,DVD,¿Ì¼»ú,ÈíÇý,ÏÔ¿¨,Éù¿¨,»úÏä,ÏÔʾÆ÷,µçÔ´,ÍâÖô洢É豸,½ú,̨ʽ»ú,Ó²Å̺Ð,Ä«ºÐ,Îø¹Ä,¼¯ÏßÆ÷,ÉãÏñÍ·, ÊýÂë¼·Å»ú,¹âÅÌƬµÈϵÁвúÆ·; IBM±Ê¼Ç±¾R32GEC/7000Ôª;R32B4C/6300Ôª;R32C7C/7300Ôª; A31JGC/7500Ôª;A31CGC/8200Ôª;Ë÷ÄáU1/4300Ôª;GRX3UCP/9500Ôª;R505MXC/7900Ôª;R505DS/8200Ôª;R505TE/6000Ôª;¶«Ö¥£ºT9100/12300Ôª;5100DVD/10500Ôª;S1400/4200Ôª;TE2100/7000Ôª;ºê»ù£º630XV/5500Ôª;1400XV/5000Ôª;1203X/3500Ôª;363EV/5500Ôª£»´÷¶û£ºV740/6300Ôª;C840/7300Ôª;8200/7000Ôª;2650/5500Ôª;ÊýÂëÏà»ú: ¸»Ê¿40I/1400Ôª;6900/2300Ôª;S602/2500Ôª;Ä῵e995/2200Ôª;LS420/1500Ôª;DX3600/1300Ôª;Ë÷ÄáDSC-F717/3700Ôª;DSC-P71/1300Ôª;DSC-P1/1700Ôª;¶«Ö¥PDR-T10/900Ôª;PDR-M25/900Ôª;PDR-M71/1200Ôª;ÊýÂëÉãÏñ»ú:Ë÷ÄáRV15E/2500Ôª;DCR-TRV16E/2600Ôª;PC115E/5000Ôª; JVC:709ED/3800Ôª;120ED/2000Ôª;ÊÖ»úϵÁÐ:ĦÍÐÂÞÀT720/1200Ôª;V60i/1300Ôª;V60/1150Ôª;V70/1550Ôª;T190/300Ôª;V998/550Ôª;ŵ»ùÑÇ7210/1800Ôª;7650/1850Ôª;3510/550Ôª 8310/1000Ôª;ÈýÐÇT208/2850Ôª; T108/2350Ôª£¬A408/1300Ôª;R208/650Ôª;CDMAϵÁÐ:ĦÍÐÂÞÀV730/1650Ôª£¬V680/1300Ôª£¬V8060/400Ôª;ÈýÐÇX199/1250Ôª;A599/1950Ôª;A539/1750Ôª; ÒÔÉÏÉÌÆ·±¨¼ÛÊôÈ«ÐÂÔ×°»ú£¬È«Ì×ÅäÖã¬ÈçÓÐÖÊÁ¿ÎÊÌâÈý¸öÔÂÄÚ°üÍË°ü»»£¬ÑùÆ·¿ÉÓʼĹºÂò¡£¸ü¶àµÄÐͺźÍÏêϸÅäÖñ¨¼ÛÇë¹âÁÙÎÒÃǵÄÍøÕ¾£ºhttp://www.wy688.com »áÈÃÄãÓÐÒâÍâµÄÊÕ»ñ¡£ÁªÏµÈË:ºØС½ã;ÒµÎñרÏß: 0131-78278629; Email:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php