Re: Query Not Using Indexing
Hi! Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes: Sinisa Adam Douglas writes: I'm running MySQL v3.22.32. Here's my problem I run the following select query and both CompanyRep and PostalCodeInfo tables are not using my Indexing. Why? How can I get these two tables to use indexing to speed up my query. You can look at my indexing on the two tables below the query. Any help would be greatly appreciated, thanks! SELECT Company.Company_Name, CompanyShipInfo.Ship_Addr1, CompanyShipInfo.Ship_Addr2, CompanyShipInfo.Ship_City, ProvincesStates.Prov_State_Name, Countries.Country_Name, CompanyShipInfo.Ship_Postal_Code, Company.Phone, Company.Fax, Company.Email, Company.Web_Page FROM CompanyRep, Company, CompanyShipInfo, PostalCodeInfo, ProvincesStates, Countries WHERE ( CompanyShipInfo.Prov_State_ID=PostalCodeInfo.Prov_State_ID AND PostalCodeInfo.Postal_Code=98188 AND CompanyRep.Company_ID=Company.Company_ID AND CompanyShipInfo.Company_ID=Company.Company_ID AND CompanyShipInfo.Prov_State_ID=ProvincesStates.Prov_State_ID AND CompanyShipInfo.Country_ID=Countries.Country_ID AND Company.Company_Status_ID=1 AND CompanyRep.Invoice_Only=0 AND CompanyRep.Wholesale_Rep=-1 ) Sinisa Hi! Sinisa You have 6 tables in a join. Sinisa Possible causes of not using indices could be some index missing or Sinisa low number of rows. Sinisa Beside that, you do have Cartesian product as there are some tables Sinisa not related. Try running an EXPLAIN for the query to verify which indexes are used. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
new installation
I downloaded, compiled, and installed the latest MySQL release from the source code at www.mysql.com last night. I was running through the tests documented in the INSTALL-SOURCE file, and I've found that mysqladmin -u root shutdown does not work. I've done a ps and I can still see the mysqld running... more telling is that mysqladmin has not quit yet (I put the command in about 30 minutes ago). My computer has been restarted since I installed mysql. I'm running MacOS X 10.0.4 (*not* MacOS X Server). If anyone could give me some advice on this, I'd appreciate it. Please send e-mail to: [EMAIL PROTECTED] Thank you. 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
binary test failed on Mac OS X Server 1.2
Description: binary test failed on Mac OS X Server 1.2 using mysql 3.23.40. Problem appears with both binary distribution and built from source according to manual instructions. How-To-Repeat: make test Fix: not known. Submitter-Id: submitter ID Originator:David Cake Organization: System Administration team tomandandy MySQL support: none Synopsis: fails binary test on Mac OS X Server 1.2 Severity: serious Priority: high Category: mysql Class: sw-bug Release: mysql-3.23.40 (Source distribution) Environment: Power Computing, Mac OS X Server 1.2, rhapsody-ppc-5.6, pcthreads lib System: Rhapsody duchamp 5.6 Kernel Release 5.6: Tue Nov 23 15:07:38 PST 1999; root(rcbuilder):Objects/kernel-187.obj~2/RELEASE_PPC Copyright (c) 1988-1995,1997-1999 Apple Computer, Inc. All Rights Reserved. Power Macintosh Some paths: /usr/bin/perl /bin/make /usr/bin/cc Compilation info: CC='cc' CFLAGS='-O2 -fomit-frame-pointer' CXX='cc' CXXFLAGS='-O2 -fomit-frame-pointer' LDFLAGS='' LIBC: Configure command: ./configure --prefix=/usr/local/mysql --with-extra-charsets=complex --disable-shared Perl: This is perl, version 5.005_02 built for rhapsody - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Crazy Threads
I was watching the log for errors, but none occurred. I absolutely lost at what this could be. I just did a mysql_install_db (and deleted the old) thinking maybe a permission might be messed up. We'll see if that helps. Chris Hilbert -Original Message- From: Werner Stuerenburg [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 02, 2001 8:46 AM To: Chris Hilbert Cc: [EMAIL PROTECTED] Subject: Re: Crazy Threads Chris Hilbert schrieb am Donnerstag, 2. August 2001, 12:54:55: Its seems like the only way to watch the process list would be to do something like mysqladmin -uroot -i 1 processlist. Since I can't show processlist when it won't connect to it (I tried to do it while it was dead). Still, this would consume a lot of resource and might not even work right...since I'd technically have to wait an hour or so for it to crash. Any other ideas? You could watch the log file and error log. Those grow pretty big very fast, so you could rename the old ones and start new ones. Data from an hour should be easy to manage. Hence you will see exactly what mysql does and what kind of errors occur, if any. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 . Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: '/tmp/mysql.sock' (111)
sarahana schrieb am Freitag, 3. August 2001, 03:07:31: If mysql is shown when runnnig phpinfo() - does it mean that its installed, and if yes, why this error? this only shows that php is compiled with mysql support. thanks, what needs to ben done? I assume you work under win. You need to start mysql - which is done with the executable mysqld - clear to unix users, unfamiliar to win users - means mysql daemon. This is done in a dos window. You should place it into your autostart group or use WinMySQLadmin to do this for you - quite handy, as this program takes care of closing mysql during shutdown - otherwise you have to do it yourself, and if you don't, you may damage your tables. Get yourself WinMySQLadmin from http://mysql.com Also, make sure you read all readmes and install guides and docs that came with the installation. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Delete
Hello, I just checked the list for answer to this question and looks like there hasn't been one. I have a similar problem, I want to delete a record from a table where the value of the field is equal to the value of a field in another table. delete from table1 where table1.column = table2.column; Any thoughts? Thanks, Eric -Original Message- From: Jeremy Morano [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 26, 2001 1:30 PM To: [EMAIL PROTECTED] Subject: Delete Hi, im trying to delete a record from a table where the value of a field must be equal to the value of a field of another table.I know this is wrong but I need to show you what I mean. I think I'm missing a very important select statement to join them...can anyone help me out? Delete from table1 where table1.value = table2.value - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Delete
On Sat, Aug 04, 2001 at 12:46:06AM -0700, Eric Fegraus wrote: I just checked the list for answer to this question and looks like there hasn't been one. I have a similar problem, I want to delete a record from a table where the value of the field is equal to the value of a field in another table. delete from table1 where table1.column = table2.column; Any thoughts? You can't do it (yet) in MySQL. If you're using a programming language of any sort to get to MySQL, though, it'd be trivial to do it in 2 separate queries. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 -- NEW MySQL 3.23.29: up 48 days, processed 390,289,076 queries (92/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Embedded SQL?
On Fri, Aug 03, 2001 at 03:35:11PM -0700, L. S. wrote: Is there Embedded SQL support for MySQL? There is some embedded work goin on in the 4.0 (development) branch of MySQL. The manual describes how to get access to the 4.0 tree if you'd like to check it out. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 -- NEW MySQL 3.23.29: up 48 days, processed 390,305,509 queries (92/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Query Not Using Indexing
Adam Douglas writes: Ahh what do you mean all tables are not related with common columns? They are not suppose to be related with a common columns. PostalCodeInfo and Company table are completely two different things. Yes that is correct, I've resolved the issue with PostalCodeInfo for indexing in the query. I had column types not matching the same through my tables. But I'm still lost as to why I can not get CompanyShipInfo to use indexing in the query. That's find but shouldn't I still be able to go down even further as to how many rows are analyzed? CompanyShipInfo has 235 rows and all are being read by the query. Here's the new explain of the query below. Another thing that happens is when I tried to ALTER PostalCodeInfo and PostalCodeReps table schemas MySQL seemed to be hung and put the CPU usage at 99.0% to 99.02% (never ending it seems). Both those tables only have 42657 rows each. Any ideas why these two tables seem to hang when anything major is done on them? Funny thing is it seems to be random when you execute a query that uses these two tables. Is there something I'm missing for MySQL configuration or bad table design? I'll post the table schema's below the explain query. MySQL is truly doing it's best in your case. If of 6 tables you have a broken chain of relations, you will have a Cartesian product. Regarding ALTER TABLE, that is also expected behaviour, as MySQL is re-building indices and has to use lot's of CPU. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Kernel crash caused by mysql?
On Fri, Aug 03, 2001 at 03:42:28AM -0700, Van wrote: Mario Witte wrote: Memory or motherboard. How many sticks of RAM do you have in the machine? Are they the same speed (p100/p133, etc.)? What kind of motherboard? Is updatedb running at this time? (might be a hard-drive croaking while trying to update the locate database). There are 2x256 MB and 2x128MB sticks in there, all at a spped of 133. Please don't ask me what kind of motherboard we're running in there, but that shouldn't be a problem. Updatedb is running around midnight, but I just found out that cron.hourly could be a problem in there as we experienced another crash tonight which was at 1:59, the crash yesterday occured at 4:59. Always around the full hour. I've tried and disabled cron.hourly for now, hoping it will help. Seems like it wasn't a problem of mysql, it was just mysql which was killed and thus appeared in the kerne ltrace or something. Seems your machine might have a wrong hardware component somewhere. I'd check it out if it's a production machine. We sure will, but the system is located about 500 kilometers from where our bureau is, so I hope it will stay alive at least over the weekend :-) mysqld can't run as the only service. You can't run anything without initd. Ok, you won! ;) Thanks for your fast help, With regards, -- Mario Witte [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
perforamnce
What is better: CREATE INDEX ix1(field1, field2, field3); or CREATE INDEX ix1(field1), ix2(field2), ix3(field3); I have a large table of some 30,000,000 records and am wondering which indexing gives better performance and why. How do I optimize search on this table - I'm using lots of OR statements in WHERE clause. Thanks in advance, Tadej
Re: Kernel crash caused by mysql?
Mario Witte wrote: On Fri, Aug 03, 2001 at 03:42:28AM -0700, Van wrote: Mario Witte wrote: Memory or motherboard. How many sticks of RAM do you have in the machine? Are they the same speed (p100/p133, etc.)? What kind of motherboard? Is updatedb running at this time? (might be a hard-drive croaking while trying to update the locate database). There are 2x256 MB and 2x128MB sticks in there, all at a spped of 133. Please don't ask me what kind of motherboard we're running in there, but that shouldn't be a problem. Couple months ago I had 256 MBytes in my Slackware Athlon workstation labeled 100MHz-128MBytes on both chips. Turns out one of the chips was 133MHz and the other was 100MHz (Fry's electronics labeling dep't). Sadly, the bucks I spent on a new PIII true Intel Board qualified the chips and I put the 2 133MHz chips into the Athlon and the 2 qualified P100Mhz chips into the PIII Intel board. Honestly, my Athlon was crashing on Slackware and the Intel was crashing on Advanced Server regularly. Slackware with 2.4.1 kernel sometimes twice; sometimes 3 times in a day; sometimes would go for a few days; The Advanced Server couldn't stay up long enough to show a login without a BSOD, except randomly sometimes. Switched the chips after verifying them, and now the Athlon can run 3 weeks at a time vanboers@sedona:~$ w 4:06am up 22 days, 13:27, 0 users, load average: 1.10, 1.24, 1.14 USER TTY FROM LOGIN@ IDLE JCPU PCPU WHAT (developer machine, what can I say? 1+ Load Avg due to SetiAtHome, BTW) and I've seen the Advanced server run close to a month (between virus patches and IIS security updates). On average, the developer Athlon machine still beats the Advanced Server machine on uptime, but the point is that the memory was killing both of them. Don't take the label for granted. I can't tell you how much time I wasted determining this. I can tell you I lost over $5k US in billing, though because I assumed the label was correct. I lost the time because I assumed I was doing something wrong and couldn't bill my client for development during the month it took me to find out what the problem was; disparate memory on the same motherboard. If the labeling had been correct; I would have just swapped the chips. Hope that makes sense. Updatedb is running around midnight, but I just found out that cron.hourly could be a problem in there as we experienced another crash tonight which was at 1:59, the crash yesterday occured at 4:59. Always around the full hour. I've tried and disabled cron.hourly for now, hoping it will help. Seems like it wasn't a problem of mysql, it was just mysql which was killed and thus appeared in the kerne ltrace or something. You're probably onto something here. Great forensics work! I have experience with the cron.hourly/cron.daily/etc. processes that fire up when you have the logrotate packages installed. It's been a while, but while I was using RedHat at Intel I convinced them these crons and the logrotate packages should either be audited thoroughly, or pitched because of the second-guessing they do to the admin of the machine/network. Intel opted to replace logrotate with an implementation (msgarch) I've had running on all of my production machines for several years on some of their monitoring servers in the division in which I was working. (Intel applied my implementation on modified Red Hat and Slackware monitoring servers at that time. I have no idea what they've done with their Red Hat implementations and don't know if they currently deploy Slackware servers at this point in that division). I haven't been at Intel for over 4 months, so I have no idea what they're up to with their server software in that division, at this point. If logrotate is the cause, I'll send you msgarch and the cron entries for msgarch. Sorry I didn't OSS msgarch before, but I hadn't heard of many complaints on logrotate. The BSD people use it also and most with a certain level of satisfaction. msgarch is my own recipe, but has been implemented by many of my affiliates for many years. I just didn't OSS it because most people have been using LogRotate and I thought it redundant to toss msgarch to the community. If that assumption was wrong, let me know. I'll pitch msgarch into the community. Seems your machine might have a wrong hardware component somewhere. I'd check it out if it's a production machine. We sure will, but the system is located about 500 kilometers from where our bureau is, so I hope it will stay alive at least over the weekend :-) This is a problematic situation. Hardware is SO important in remote deployments. I hate to say this, but my most important machine is 2000 miles away from me, but I tested it locally for 2 months on the hardware I put it on before I deployed it. That might be the lesson, here. The hardware didn't fail after 2 months testing. Not comprehensive, but might
Re: perforamnce
Well, sometimes I use all of the fields in the SELECT statement, sometimes just one. How about if I create both indexes? How would it affect the performance? I don't care about update time as i insert or update records at night only once a day. Thanks for the answer - Original Message - From: Kahled Al Sahmaa [EMAIL PROTECTED] To: Tadej Guzej [EMAIL PROTECTED] Sent: Saturday, August 04, 2001 12:25 PM Subject: Re: perforamnce Hello... that related to your select statement which you are use, if you have field1, field2 and field3 in the where section then the first index: CREATE INDEX ix1(field1, field2, field3); will be better for you, but if you are using select statements which has been used one of that fields alon then the secound choice will be better. - Original Message - Subject: perforamnce Sent: Sat, 4 Aug 2001 12:53:15 +0100 From: Tadej Guzej [EMAIL PROTECTED] To: [EMAIL PROTECTED] What is better: CREATE INDEX ix1(field1, field2, field3); or CREATE INDEX ix1(field1), ix2(field2), ix3(field3); I have a large table of some 30,000,000 records and am wondering which indexing gives better performance and why. How do I optimize search on this table - I'm using lots of OR statements in WHERE clause. Thanks in advance, Tadej Sincerely, Khaled Al-Sham'aa http://www.mazadmaktoob.com _ Send Your favorite Arabic Card from Maktoob Cards, http://cards.maktoob.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: Delete
Eric Fegraus writes: Hello, I just checked the list for answer to this question and looks like there hasn't been one. I have a similar problem, I want to delete a record from a table where the value of the field is equal to the value of a field in another table. delete from table1 where table1.column = table2.column; Any thoughts? Thanks, Eric Beside Jeremy's valuable comment, you should know that the above is already possible in 4.0. 4.0 will be released this autumn. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: floor/ceiling with myodbc
Kevin X Lin writes: Hi there, I'm running into problems with functions floor/ceiling when I use Visual Basic to talk to mySQL through myODBC. My code looks like this: sSQL = select floor(3.2) Set rs = MySQL_conn.Execute(sSQL) I got rs.eof = true after execution of the query. However the following codes works fine. sSQL = select round(3.2) Set rs = MySQL_conn.Execute(sSQL) rs.fields(0)=3 Can anyone tell if this is a bug of myODBC or VB's problem? Sorry, but what is your problem ?? round(3.2) = 3 The above is quite true. As you have not specified number of decimals, MySQL is using default of 0, which conforms with SQL 92 standard. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Thinking of switching from MyISAM to InnoDB
Nick Seidenman writes: Apparentlly there's a 4 GB limit to a MyISAM file when the table it contains has VARCHAR, TEXT, or BLOB columns. In order to get around this limitation I was looking to switching to InnoDB table types. As this looks like a relatively new subsystem I'm wondering if it is stable enough for production systems, or is it still too new (and too feature-prone.) I'd appreciate hearing feedback on this. If I do wind up switching, it won't be for at least a month. TiA, nick Nick Seidenman, CISSP Director of Software Development Hyperon, Inc. www.hyperon.com There is no 4 Gb limit in MyISAM with later 3.23 versions. This limit is imposed by a filesystem only. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: socket error: Can't connect to local MySQL server through socket '' (111)
Charles Mégnin writes: I am getting an error message Can't connect to local MySQL server through socket '' (111) trying to connect via mySQLgui on my Linux box running RH6.2 I do have a /tmp/mysql.sock with proper authorizations and have no problem connecting to the serverwithout the client. Thanks for your clues Charles All you have to do is follow instructions from README that came with mysqlgui. This is a relevant excerpt: When you start mysqlgui for the first time, you'll need to tell it how to connect to the MySQL server. To do this, click on the ``Options'' button. Select the ``Server'' tab and fill in the fields that indicate where to find the server. On Unix, if you have problems with mysqlgui not knowing the location of the socket file for connections to localhost, enter the full pathname of the socket file in the ``SQL command on the start-up'' field. On Windows, this field is used if you wish to specify the named pipe option. Then select the ``Client'' tab and fill in your MySQL user name. Take care to select the right value for the ``Ask for password'' button, depending on whether or not you want mysqlgui to prompt you for your MySQL password. After you have filled in the server and client values, click on the ``Save'' button. From then on, each time mysqlgui starts up, it will connect to the MySQL server automatically. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Thinking of switching from MyISAM to InnoDB
Nick: What O/S are you running ... Windows? To the best of my knowledge, MySQL doesn't impose file size limits ... that is dictated by the O/S's file system. Switching to InnoDB wouldn't change that. Gerald Jensen - Original Message - From: Nick Seidenman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 03, 2001 6:44 PM Subject: Thinking of switching from MyISAM to InnoDB Apparentlly there's a 4 GB limit to a MyISAM file when the table it contains has VARCHAR, TEXT, or BLOB columns. In order to get around this limitation I was looking to switching to InnoDB table types. As this looks like a relatively new subsystem I'm wondering if it is stable enough for production systems, or is it still too new (and too feature-prone.) I'd appreciate hearing feedback on this. If I do wind up switching, it won't be for at least a month. TiA, nick Nick Seidenman, CISSP Director of Software Development Hyperon, Inc. www.hyperon.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Bug report.
I have a reproducible but it's not easy to reproduce. It involves a complex transaction that gets rolled back instead of committed. Cal Innobase: Assertion failure in thread 8201 in file trx0roll.c line 887 Innobase: we intentionally generate a memory trap. Innobase: Send a bug report to [EMAIL PROTECTED] mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died. 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... Stack range sanity check OK, backtrace follows: 0x4007c552 0x8178fea 0x813d2b7 0x813dc9e 0x8177851 0x8179310 0x811aaec 0x81122b1 0x80d3233 0x80d4889 0x80cfc39 0x80cf16e Stack trace successful, trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x83540c0 = rollback thd-thread_id = 1 Successfully dumped variables, if you ran with --log, take a look at the details of what thread 1 did to cause the crash. In some cases of really bad corruption, this value may be invalid Please use the information above to create a repeatable test case for the crash, and send it to [EMAIL PROTECTED] Cal http://www.calevans.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: Thinking of switching from MyISAM to InnoDB
On Saturday 04 August 2001 09:25, Sinisa Milivojevic wrote: Nick Seidenman writes: Apparentlly there's a 4 GB limit to a MyISAM file when the table it contains has VARCHAR, TEXT, or BLOB columns. In order to get around this There is no 4 Gb limit in MyISAM with later 3.23 versions. I an running version 3.23.32. This limit is imposed by a filesystem only. Don't think so. When I do a SHOW TABLE STATUS I have several tables that are well in excess of 4 GB (2^32-1), as well as those that show exactly 4GB. The difference is that the larger tables are of fixed type while the smaller ones are of dynamic type. It is one of the dynamic tables that repeatedly runs into space problems. This one happens to have a TEXT column in it the values for which can be (and often are) in excess of 2 KB. Nick Seidenman, CISSP Director of Software Development Hyperon, Inc. www.hyperon.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: Bug report.
Hi! What InnoDB version you are using? A bad rollback bug was fixed in version 3.23.39. Regards, Heikki At 05:40 PM 8/4/01 +0300, you wrote: Content-Type: message/rfc822 Content-Description: forwarded message Content-Transfer-Encoding: 7bit MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Subject: Bug report. From: Cal Evans [EMAIL PROTECTED] To: Mysql [EMAIL PROTECTED] Date: Sat, 4 Aug 2001 09:25:55 -0500 I have a reproducible but it's not easy to reproduce. It involves a complex transaction that gets rolled back instead of committed. Cal Innobase: Assertion failure in thread 8201 in file trx0roll.c line 887 Innobase: we intentionally generate a memory trap. Innobase: Send a bug report to [EMAIL PROTECTED] mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died. 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... Stack range sanity check OK, backtrace follows: 0x4007c552 0x8178fea 0x813d2b7 0x813dc9e 0x8177851 0x8179310 0x811aaec 0x81122b1 0x80d3233 0x80d4889 0x80cfc39 0x80cf16e Stack trace successful, trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x83540c0 = rollback thd-thread_id = 1 Successfully dumped variables, if you ran with --log, take a look at the details of what thread 1 did to cause the crash. In some cases of really bad corruption, this value may be invalid Please use the information above to create a repeatable test case for the crash, and send it to [EMAIL PROTECTED] Cal http://www.calevans.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 Content-Type: text/plain; charset=us-ascii Content-Description: message body and .signature Content-Transfer-Encoding: 7bit Something for you ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
libmysqlclient[_r].so + pthreads + gdb
Description: mysql refuses connection [local/unix-socket] when client is ran under GDB, and linked with pthread library. It doesn't need to call any pthread_*() function, it just fails when linked with it. How-To-Repeat: #include stdio.h #include mysql/mysql.h main() { MYSQL m; if(mysql_connect(m, NULL, root, mysqlroot)) { printf(Connect okay\n); mysql_close(m); } else { fprintf(stderr, MYSQL:%d %s\n, mysql_errno(m), mysql_error(m)); } } gcc m2.c -o m2 -D_REENTRANT -lmysqlclient_r gdb ./m2 run Fix: Don't know. Submitter-Id: submitter ID Originator:root Organization: == Mail : [EMAIL PROTECTED] WWW : http://www.mindnever.org Phone : +381 63 550 161 ICQ : 15414204 == MySQL support: [none] Synopsis: libmysqlclient_r + pthreads + gdb fails to connect to server Severity: critical Priority: high Category: mysql Class: sw-bug Release: mysql-3.23.36 (Linux-Mandrake MySQL RPM) Environment: machine, os, target, libraries (multiple lines) System: Linux noteboox 2.4.4 #3 Sat Jul 21 21:12:31 CEST 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i586-mandrake-linux/2.96/specs gcc version 2.96 2731 (Linux-Mandrake 8.0 2.96-0.48mdk) Compilation info: CC='gcc' CFLAGS='-O3 -fomit-frame-pointer -pipe -mcpu=pentiumpro -march=i586 -ffast-math -fno-omit-frame-pointer' CXX='g++' CXXFLAGS='-O3 -fomit-frame-pointer -pipe -mcpu=pentiumpro -march=i586 -ffast-math -fno-omit-frame-pointer' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Apr 27 02:08 /lib/libc.so.4 - libc.so.4.7.6 -rwxr-xr-x 1 root root 634880 Apr 29 1996 /lib/libc.so.4.7.6 lrwxrwxrwx 1 root root 13 May 2 02:37 /lib/libc.so.6 - libc-2.2.2.so -rwxr-xr-x 1 root root 1216268 Feb 21 11:38 /lib/libc-2.2.2.so -rw-r--r-- 1 root root 26366908 Feb 21 11:31 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Feb 21 11:31 /usr/lib/libc.so Configure command: ./configure --enable-shared --enable-thread-safe-client --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/share/info --includedir=/usr/include --mandir=/usr/share/man --with-berkeley-db --without-innobase '--with-comment=Linux-Mandrake MySQL RPM' Perl: This is perl, version 5.005_03 built for i586-linux a -- == Mail : [EMAIL PROTECTED] WWW : http://www.mindnever.org Phone : +381 63 550 161 ICQ : 15414204 == - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Bug report.
Hi, Sorry to have bothered everyone. I was using .38. I just noticed that and am currently building .40. Cal http://www.calevans.com -Original Message- From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 04, 2001 9:59 AM To: Sinisa Milivojevic; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Bug report. Hi! What InnoDB version you are using? A bad rollback bug was fixed in version 3.23.39. Regards, Heikki At 05:40 PM 8/4/01 +0300, you wrote: Content-Type: message/rfc822 Content-Description: forwarded message Content-Transfer-Encoding: 7bit MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Subject: Bug report. From: Cal Evans [EMAIL PROTECTED] To: Mysql [EMAIL PROTECTED] Date: Sat, 4 Aug 2001 09:25:55 -0500 I have a reproducible but it's not easy to reproduce. It involves a complex transaction that gets rolled back instead of committed. Cal Innobase: Assertion failure in thread 8201 in file trx0roll.c line 887 Innobase: we intentionally generate a memory trap. Innobase: Send a bug report to [EMAIL PROTECTED] mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died. 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... Stack range sanity check OK, backtrace follows: 0x4007c552 0x8178fea 0x813d2b7 0x813dc9e 0x8177851 0x8179310 0x811aaec 0x81122b1 0x80d3233 0x80d4889 0x80cfc39 0x80cf16e Stack trace successful, trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x83540c0 = rollback thd-thread_id = 1 Successfully dumped variables, if you ran with --log, take a look at the details of what thread 1 did to cause the crash. In some cases of really bad corruption, this value may be invalid Please use the information above to create a repeatable test case for the crash, and send it to [EMAIL PROTECTED] Cal http://www.calevans.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 Content-Type: text/plain; charset=us-ascii Content-Description: message body and .signature Content-Transfer-Encoding: 7bit Something for you ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
missing setup.dll
please, i downloaded the mysql 3.23 from your site and i made the unzip and when i begin to make setup i found error: missing setup.dll what can i do? please reply fast [EMAIL PROTECTED] yasmeen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: missing setup.dll
At 18:29 04/08/2001 +0300, Hiba Muhrez wrote: Hi, When you unzipped the 3.23.40 distribution file you should have the following files: 02/08/2001 00:31 128 DATA.TAG 02/08/2001 00:31 11.535.662 data1.cab 30/05/1997 11:314.557 lang.dat 02/08/2001 00:31 386 layout.bin 06/05/1997 14:15 417 os.dat 08/02/2001 04:07 62.646 SETUP.BMP 19/11/1997 16:09 59.904 SETUP.EXE 02/08/2001 00:31 90 SETUP.INI 14/06/2001 03:56 57.122 setup.ins 02/08/2001 00:31 49 setup.lid 19/11/1997 16:05 300.178 _INST32I.EX_ 19/11/1997 16:058.192 _ISDEL.EXE 19/11/1997 16:08 11.264 _setup.dll 02/08/2001 00:31 186.302 _sys1.cab 02/08/2001 00:31 45.137 _user1.cab Compare the size with your ones. If you see different sizes, means that your download got a corrupt file. Regards, Miguel please, i downloaded the mysql 3.23 from your site and i made the unzip and when i begin to make setup i found error: missing setup.dll what can i do? please reply fast mailto:[EMAIL PROTECTED][EMAIL PROTECTED] yasmeen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Thinking of switching from MyISAM to InnoDB
On Sat, Aug 04, 2001 at 09:15:52AM -0500, Gerald R. Jensen wrote: To the best of my knowledge, MySQL doesn't impose file size limits ... that is dictated by the O/S's file system. Switching to InnoDB wouldn't change that. But InnoDB would let you use multiple tablespaces to get around any such limitation. In this case, however, that's probably not the problem anyway. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 -- NEW MySQL 3.23.29: up 49 days, processed 393,812,934 queries (92/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
New member question
I have just subscribed to this list, so forgive me if my question has been answered many times before but I was not sure where else to find this information. I am new to mysql and am going to be using it on a website that I maintain. My question is, is there a program/utility or easy way to convert an MS Access database to mysql format? Thanks, Chris --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.265 / Virus Database: 137 - Release Date: 7/18/01 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: New member question
there are a number of ways you could accomplish this. depending on how large the database is, you may want to try exporting it to csv (comma separated value) format, and then importing it into mysql, using either the load command, or a third-party utility like phpmyadmin (which is what i generally use for tasks like that). another way is if you are indeed using php and you have odbc support compiled in... you could simply read from the access database and simultaneously write it to a new mysql table. that's what i could think of offhand..someone else out there might have a better solution or three. =) ~shawn On Sat, 4 Aug 2001, RCA Webmaster wrote: I have just subscribed to this list, so forgive me if my question has been answered many times before but I was not sure where else to find this information. I am new to mysql and am going to be using it on a website that I maintain. My question is, is there a program/utility or easy way to convert an MS Access database to mysql format? Thanks, Chris --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.265 / Virus Database: 137 - Release Date: 7/18/01 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Char Set (Arabic) question
Greetings ALL: I am developing a database application using mySQL php for a client that requires data entry (at least) to be in Arabic. I am know that mySQL supports charsets, but it is not clear if it supports charsets that are not left-to-right, such as Arabic. If the answer to this is obvious and documented then please accept my apologies, and direct me to the right resource(s). Please respond to this list, and to me directly @ mailto:[EMAIL PROTECTED] TIA KHaled. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Char Set (Arabic) question
On 04 Aug 2001 22:57:39 +0300, Khaled I. Hammouda wrote: Greetings ALL: I am developing a database application using mySQL php for a client that requires data entry (at least) to be in Arabic. I am know that mySQL supports charsets, but it is not clear if it supports charsets that are not left-to-right, such as Arabic. If the answer to this is obvious and documented then please accept my apologies, and direct me to the right resource(s). I didn't knew also and searched manual for word arabic. There was nothing about this. So if this charset not called somehow different then it is not supported. But if this an true we are really interested about information, how Arabic language is organized. Maybe you can point to some source on the web? Changing left-right directions seems easy to me on first look. We need information: Is Arabic an single or multibyte character set? In which order these characters should appear? (prorably some national standard describes this) Also we need information about upper-lower conversion if it is applicable at all. And after all the smallest thing is translating about 220 error messages to Arabic. This is the part we cannot do as nobody of us can speak this language as far I know :( -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Thinking of switching from MyISAM to InnoDB
On 04 Aug 2001 16:25:14 +0300, Sinisa Milivojevic wrote: There is no 4 Gb limit in MyISAM with later 3.23 versions. This limit is imposed by a filesystem only. and RAIDed table can help to build aby size tables if only index file doesn't get too big. Actually InnoDB is nice thing. Just bith MyISAM and InnoDB have good advantages and you should decide, which ones you need more. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Thinking of switching from MyISAM to InnoDB
Is there a place that outlines the advantages/disadvantages of both MyISAM and InnoDB? Thanks, Chris -Original Message- From: Tonu Samuel [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 04, 2001 2:34 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Thinking of switching from MyISAM to InnoDB On 04 Aug 2001 16:25:14 +0300, Sinisa Milivojevic wrote: There is no 4 Gb limit in MyISAM with later 3.23 versions. This limit is imposed by a filesystem only. and RAIDed table can help to build aby size tables if only index file doesn't get too big. Actually InnoDB is nice thing. Just bith MyISAM and InnoDB have good advantages and you should decide, which ones you need more. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
portable query?
hi all... i have a mysql query as follows: SELECT *, ( if((description LIKE '%keyword_one%'), 1, 0)+ if((description LIKE '%keyword_two%'), 1, 0)+ if((description LIKE '%keyword_three%'), 1, 0)+ if((description LIKE '%keyword_four%'), 1, 0) ) as keyword_score, FROM table WHERE ( (description LIKE '%keyword_one%) OR (description LIKE '%keyword_two%) OR (description LIKE '%keyword_three%) OR (description LIKE '%keyword_four%) ) GROUP BY ref ORDER BY keyword_score DESC; this query is great for my search engine because it ranks the results based on how many keywords were found in each row (users love this). i know have to think about making it portable (i found the if() statement didnt work in PostgreSQL). are there any portable equivilents to this MySQL specific query? thanks for your thoughts, jamie burns. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Thinking of switching from MyISAM to InnoDB
If you want a MyISAM table to grow larger than 4GB you have to do alter table tablename max_rows=1 or maybe its 'maxrows'... Once you do that, you will be able to stuff the table as full as the OS will let you. Innobase will allow you to get around this by making a bunch of smaller files to create a larger table space... but keep in mind the max size for a blob is 4GB.. (yah that is pretty damn huge tho heh). Im not sure what the max size for a MyISAM blob is. Hope this helps. ryan - Original Message - From: Nick Seidenman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, August 04, 2001 9:54 AM Subject: Re: Thinking of switching from MyISAM to InnoDB On Saturday 04 August 2001 09:25, Sinisa Milivojevic wrote: Nick Seidenman writes: Apparentlly there's a 4 GB limit to a MyISAM file when the table it contains has VARCHAR, TEXT, or BLOB columns. In order to get around this There is no 4 Gb limit in MyISAM with later 3.23 versions. I an running version 3.23.32. This limit is imposed by a filesystem only. Don't think so. When I do a SHOW TABLE STATUS I have several tables that are well in excess of 4 GB (2^32-1), as well as those that show exactly 4GB. The difference is that the larger tables are of fixed type while the smaller ones are of dynamic type. It is one of the dynamic tables that repeatedly runs into space problems. This one happens to have a TEXT column in it the values for which can be (and often are) in excess of 2 KB. Nick Seidenman, CISSP Director of Software Development Hyperon, Inc. www.hyperon.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
problem with mysqldump
Hi everybody, I got a problem with the mysqldump function. I connect to mySql trough phpMyAdmin, select the database xyz, which is the only database on the server. Then I enter the following string into the text field Run SQL query/queries on database xyz:: mysqldump xyz | mysql --host=XXX.168.XXX.14 --port=3306 --socket=/var/mysql/mysql.sock --username=X --password[X] xyz I want to copy the whole databse from one server to the other, but i always get th error message, MySQL said: You have an error in your SQL syntax near 'mysqldump catfxpboard | mysql --host=194.168.102.14 --port=3306 --socket=/var/my' at line 1 But I can't find a mistake there!? Can you helpp me? Thanks! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Link request.
Hello! Let me introduce myself. My name is Mr. Rajesh Tavakari from www.website-promotion-ranking-services.com, and you can contact me at [EMAIL PROTECTED] or [EMAIL PROTECTED] I enjoyed visiting your interesting site at http://www.mysql.com/documentation/. You may know that having high link popularity can help you in the search engine ranking. Link popularity is defined as the number of web sites that link back to your site. Links from other pages are one of the main sources of web traffic, and they are becoming increasingly important for other reasons. There have been studies that show the majority of traffic to web sites comes from people clicking on links from other sites. The Search engines are also beginning to use the number (and in some cases quality) of links to your pages to assist in their ranking of your site. For these reasons and others, you need to have links to your site from other sites if you want to increase traffic to your site. I am looking forward to add your URL to our website at http://www.website-promotion-ranking-services.com/links.htm. To add your website link to our website please visit : http://www.website-promotion-ranking-services.com/links.htm. It would be kind of you, if you could link back to me, thus increasing link popularity of both sites. As soon as you add our link on your website, You Get 3 Bonus : 1. Submission of your website in the appropriate categories. Our SEO Experts will submit your individual link pages in appropriate category every 15 days for 1 month. 2. Basic Directory Listing with 6 month Classified Ad* with Sunny Side Business Directory 3. FREE ! Three Ultimate E-books on Web promotion and Optimization worth 125 $. Best Regards, Rajesh. V. Tavakari [ Specialist in Web Promotion Web Optimization ] CEO - WebPromotionGuru.com - Website-Promotion-Ranking-Services.com. Address : B-I/3, P T Quarters. Kavalbyrasandra. R.T Nagar Post. BANGALORE - 32. State : Karnataka. INDIA. E-Mail : [EMAIL PROTECTED] E-Mail : [EMAIL PROTECTED] URL : www.Website-Promotion-Ranking-Services.com URL : www.WebPromotionGuru.com Phone : ( 00 91 ) 9845089687. Contact Us Online at : ICQ : 19511229. Yahoo Messenger : [EMAIL PROTECTED] MSN : [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