C++ api Database Newbie
Hi I am starting with c++ api database and was wondering what lib to include in the compiling process im using borland 5.5 commandline compiler. Francois D. Barnard Property24 Webdeveloper/Programmer (011) 715 - 6809 083 380 6645 The information in this email is confidential and may also be privileged. If you are not the intended recipient please notify us immediately by contacting [EMAIL PROTECTED] Although this email and any attachments are believed to be virus-free, Property24 accepts no responsibility for any loss or damage arising in any way from receipt or use thereof. Property24 also accepts no liability for the unauthorized use of its email facility for the sending of chain letters, offensive material or any other communication that is not strictly for its own business purposes. ** Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you have received this message in error, you should destroy it and ensure the sender is notified. Agreements, conclusions and other information in this message not related to the official business of Media24 Ltd, Nasboek Ltd and Educor Ltd, shall be understood as neither given, nor endorsed nor authorised by it. Advise the sender immediately if you or your employer do not consent to internet email for communications of this kind. Reasonable care was taken to transmit this message free of damaging code, however Media24 Ltd, Nasboek Ltd and Educor Ltd and the sender does not make any warranties in this regard, and cannot be held liable for any loss or damages incurred by the recipient. Media24 Ltd, Nasboek Ltd and Educor Ltd retains the copyright in this message. Die deurkyk, aanstuur, verspreiding of enige ander gebruik van, of optrede na aanleiding van, die inligting in hierdie boodskap deur enige mens of entiteit buiten die bedoelde ontvanger word verbied. As u die boodskap verkeerdelik ontvang het, moet dit geskrap en die afsender verwittig word. Ooreenkomste, gevolgtrekkings en ander inligting in die boodskap wat nie verband hou met die amptelike sake van Media24 Bpk, Nasboek Bpk en Educor Bpk nie, sal geag word as nie verskaf , onderskryf of gemagtig deur Media24 Bpk, Nasboek Bpk en Educor Bpk nie. Stel die sender in kennis as u of u werkgewer nie gediend is met internet-e-pos van hierdie aard nie. Redelike voorsorg is getref om hierdie boodskap sonder skadelike kodes te stuur, maar Media24 Bpk, Nasboek Bpk en Educor Bpk en die afsender gee geen waarborge hieroor nie en kan nie verantwoordelik gehou word vir enige verliese of skade wat die ontvanger ly nie. Media24 Bpk, Nasboek Bpk en Educor Bpk behou die kopiereg van die boodskap. ** - 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: Odd fulltext matching
Hi! On Jan 18, Jason Morehouse wrote: Hello, Using a fulltext search on a products database I'm running into some rather strange results. I'm using MySQL 3.23.32 on a Redhat 7.1 Linux box. Thanks in advance for any help, Cheers, -Jason It looks like a bug to me (or two bugs). Can you create a testcase for it ? 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
C++ api libaries
Hi Im new at this c++ api and just like to know what lib to include when i compile the app.i have found 2 but evenn then i still get allot of errors when i compile. Francois D. Barnard Property24 Webdeveloper/Programmer/Database Admin (011) 715 - 6809 083 380 6645 The information in this email is confidential and may also be privileged. If you are not the intended recipient please notify us immediately by contacting [EMAIL PROTECTED] Although this email and any attachments are believed to be virus-free, Property24 accepts no responsibility for any loss or damage arising in any way from receipt or use thereof. Property24 also accepts no liability for the unauthorized use of its email facility for the sending of chain letters, offensive material or any other communication that is not strictly for its own business purposes. ** Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you have received this message in error, you should destroy it and ensure the sender is notified. Agreements, conclusions and other information in this message not related to the official business of Media24 Ltd, Nasboek Ltd and Educor Ltd, shall be understood as neither given, nor endorsed nor authorised by it. Advise the sender immediately if you or your employer do not consent to internet email for communications of this kind. Reasonable care was taken to transmit this message free of damaging code, however Media24 Ltd, Nasboek Ltd and Educor Ltd and the sender does not make any warranties in this regard, and cannot be held liable for any loss or damages incurred by the recipient. Media24 Ltd, Nasboek Ltd and Educor Ltd retains the copyright in this message. Die deurkyk, aanstuur, verspreiding of enige ander gebruik van, of optrede na aanleiding van, die inligting in hierdie boodskap deur enige mens of entiteit buiten die bedoelde ontvanger word verbied. As u die boodskap verkeerdelik ontvang het, moet dit geskrap en die afsender verwittig word. Ooreenkomste, gevolgtrekkings en ander inligting in die boodskap wat nie verband hou met die amptelike sake van Media24 Bpk, Nasboek Bpk en Educor Bpk nie, sal geag word as nie verskaf , onderskryf of gemagtig deur Media24 Bpk, Nasboek Bpk en Educor Bpk nie. Stel die sender in kennis as u of u werkgewer nie gediend is met internet-e-pos van hierdie aard nie. Redelike voorsorg is getref om hierdie boodskap sonder skadelike kodes te stuur, maar Media24 Bpk, Nasboek Bpk en Educor Bpk en die afsender gee geen waarborge hieroor nie en kan nie verantwoordelik gehou word vir enige verliese of skade wat die ontvanger ly nie. Media24 Bpk, Nasboek Bpk en Educor Bpk behou die kopiereg van die boodskap. ** - 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
3.23.40 overload
Hello Time to time I see strange overload of MySQL on dedicated server. The server is powerful enough to handle ~ 500 req/s. MySQL version is 3.23.40 and runs on Linux 2.4.16-SMP. The overload which I mean leds to stop answering to queries and looks like: 6:24pm up 6 days, 2:34, 2 users, load average: 164.18, 91.07, 39.56 270 processes: 73 sleeping, 197 running, 0 zombie, 0 stopped CPU0 states: 99.23% user, 0.15% system, 0.0% nice, 0.1% idle CPU1 states: 97.17% user, 2.21% system, 0.0% nice, 0.0% idle Mem: 513504K av, 50K used, 13504K free, 0K shrd, 22892K buff Swap: 1036184K av,7540K used, 1028644K free 305928K cached PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND 30453 mysql 14 0 19204 18M 2224 R 6.9 3.7 0:02 mysqld 30454 mysql 14 0 19204 18M 2224 R 6.9 3.7 0:02 mysqld [skip] 30460 mysql 16 0 19204 18M 2224 R 6.9 3.7 0:02 mysqld On the other hand I see Slow_launch_threads counter equal to 2 that means there were a problem with thread create (took more then 2 sec). Others thread-related counters: Threads_cached 59 Threads_created 68 Threads_connected 2 Threads_running 1 So what seems to be a source of the problem - linux kernel, MySQL 3.23.40 or wrong tunning ? Your comments/ideas are very welcome. -- Dimitry - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
console freezes when starting mysqld
I am running two different servers, one with the tarball distro and the other with an rpm. Both are on Redhat 7.1. Upon executing mysql.server or safe_mysqld the console executes the command but does not return to a prompt. I can change to another console and see the server started ok. I can log on etc. However, it locks the console I execute it on every time. This causes a problem when booting, as I run these commands from rc.local and it stops the boot process there. Using the built in script from the rpm that gets installed into init.d is not an option in these particular cases (long story) so I'm hoping to find out what I can do to get the prompt back. Larry S. Brown President/CEO Dimension Networks, Inc. Member ICCA (727) 723-8388 - 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: console freezes when starting mysqld
On Fri, 18 Jan 2002, Larry Brown wrote: I am running two different servers, one with the tarball distro and the other with an rpm. Both are on Redhat 7.1. Upon executing mysql.server or safe_mysqld the console executes the command but does not return to [...] let's start it with command like: # safe_mysqld best regards parys - 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
C++ API on MacOS X 10.1.1
Hi, I'm trying to use the mysql++ API on MacOS X with Project Builder, but I am not sure what to do to get started. Any suggestions? Thanks, - Chris -- Christopher Allum [EMAIL PROTECTED] Alluminity Solutions -- - 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
Ny otrolig Tipssensation reserverad bara dig!
PROFLEX-134 Plus en otrolig bonus. HELT GRATIS (se längre ner) Passa på nu när det är jackpott i helgen, Med vår hjälp kan du plocka hem de stora vinsterna! Detta är ett helt nytt sätt att spela på Tipset, Du kan vara bland de första att plocka hem dom stora vinsterna! Detta helt nya revolutionerande tipssystem är utan tvekan det absolut bästa som har tagits fram för detta ändamål. Det är helt individuellt anpassat bara för dig. Det är mycket enkelt att använda. Med PROFLEX-134 medföljer naturligvis en mycket lättförstålig svensk bruksanvisning och garantitabell. PROFLEX-134 levereras komplett med garantitabell och mycket lättförståeliga anvisningar. Dessutom lovar vi pengarna tillbaka som du har betalt för PROFLEX-134 om du inte får vinst redan den första veckan OBS!GLÖM INTE DIN OTROLIGA GRATIS BONUS LÄNGRE NER Beställ redan i dag och du har chans att vinna upp till 75 miljoner, eller ännu mer vid jackpott, redan nästa vecka. Du har inget att förlora utan allt att vinna! Beställer du dessutom inom 10 dagar får du utan extra kostnad; Det nya stryktips programmmet Olympia tips 2002. i en helt ny version bara det värt 999:- och som är ett enormt hjälpmedel för dig som föredrar att spela på stryktipset HELT GRATIS! Och det är inte nog med det: Vi skickar även med det fantasiska V75 Max för datorn. En spel sensation som på ett enkelt sätt hjälper dig att plocka ut de rätta hästarna. HELT GRATIS Kom ihåg att PROFLEX-134 sköter sig helt själv, Du behöver bara fylla i matcherna efter anvisningarna Ja Tack! Jag beställer PROFLEX-134 för introduktionspriset 298:- (Ord pris 999:-) Vid förskottsbetalning =, (skickas via din emejl) 298 : -tillkommer inga avgifter! Vid förskottsbetalning= Postgironummer 920 11 81-6 tillkommer inga avgifter (Glöm inte namn, adress och telenummer) Mot postförskott =, Pappers version = 298:- (plus posten fraktavg =+81:-) Du kan mejla in din order: Då är adressen : [EMAIL PROTECTED] Du kan även ringa: Order telefon 0300-71871 DYGNET RUNT (Ordermottagare) Naturligvis kan du även skriva in din beställning Skriv då på kuvertet : Svenskt Spelsystem , FRISVAR Box 10082, 434 21 Kungsbacka, så slipper du portot. Glöm inte skriva vilken produkt det gäller. (PROFLEX-134) OBS glöm inte skriva in namn och adress vid beställningen! PS! GLÖM INTE DIN OTROLIGA GRATIS BONUS Bifogar du dessutom 5 vänners emejladresser får du utan någon som helst kostnad 5 helt nya spelsystem , för V75, Stryktipset, Lotto, V64 och måltipset. HELT GRATIS! Dem börjar inte marknadföras fören tidigast 2002-09-15 så passa medans du är först. Med vänlig hälsning, och hopp om en trevlig vår önskar vi på Svenskt Spelsystem [EMAIL PROTECTED] Svenskt spelsystem är nu störst på spelsystem och spelhjälpmedel i Norden! (etablerat 1987) Vilket borgar för nöjda kunder och hög kvalitet! Leverans tiden kan variera Dock max 2 veckor - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fwd: RE: Optimization
Hi! I just forwarder your email about query caching (Yes, I know that the query cache in MySQL 4.0 has solved this for you but...) Hello all, I'm having real trouble trying to optimize MySQL cause I can't believe that MSSQL is faster. My configurations are as follows: MSSQL 2000 on W2K server. PIII 733 - 512 MB memory. MySQL-3.23.47-1 on Redhat 7.2. Dual PIII 1000 - 1.128 GB memory I have a PHP script that runs on a Redhat 7.1 - PIII 500 640 MB memory. The php script takes a username from a mysql table and runs a query for each of the usernames on another table. The test is that I have 2 different versions of the script that do the exactly same thing but one queries the MSSQL server and the other the MySQL. The MSSQL version takes 28 secs while the MySQL takes 34 secs. As you can see the MSSQL is much more slower with less RAM. I said what the heck I will use the my-huge.cnf to see if it makes any difference. Unfortunately nothing changed and then I started panicking.. It can't be true! I noticed that MSSQL caches the queries while MySQL doesn't. In my script I might have this: select emails from dbo_Company where username=''; come up 5 or even 10 times. If I run it on mysql It takes always 0.26 secs while it appears the MSSQL caches the result and doesn't take any time at all. Any chance you could give us a copy of the dbo_Company table to use for testing ? (If yes, please upload the .frm, .MYI and .MYD files to: ftp://support.mysql.com/pub/mysql/secret) According to tests I have done, for a simple query as the above, MySQL should usually be faster than MSSQL, even with MS-SQL query caching. (Look at: http://www.mysql.com/information/benchmark-results/result-db2,informix,ms-sql,mysql,solid,sybase-relative.html and the test for select_key, where MySQL is 3.52 times faster on simple key lookups) A couple of reasons for your results: - username is a primary key or the table is sorted according to the user name (explicite or implicit) in MS-SQL. - The query returns many rows, and they rows are far apart in the data file, so MySQL has to do many reads to fetch the rows. (In this case it's the file caching in Windows that is slow). In both cases, an OPTIMIZE TABLE or 'ALTER TABLE dbo_Company ORDER BY username' would speed up things considerably in MySQL. If the reason for the speed difference is that 'username' is a primary key and MS-SQL stores the row clustered together with the primary key, then by using the InnoDB table handler you should get the same benefit in MySQL as MS-SQL has. (The downside with this algorithm is that secondary keys are slower, but that is another issue) For example, MyISAM stores the rows separate from the keys. This makes the primary key slightly slower in MyISAM (except when you only want to have information from the primary key, then MyISAM should be faster), but instead all keys are equally fast and table scans are much faster. No sql server can be faster an ALL queries; Depending on the optimization engine and how rows are stored you get certain benefits but also some downsides. If MS-SQL is faster in this case, we would like to add a similar case to the MySQL benchmark suite because: - If MS-SQL is faster on this particular case, we want to acknowledge this fact (give credit where credit is due...) - We would like to know why MS-SQL is faster so that we can document this and provide workarounds - We will know about this and can in the future try to speed up MySQL for this case. - We will do the test with all the table handlers MySQL support; This will show if the speed of this test is dependent of how the rows are stored or by the optimizer. Thanks for any help you can give us regarding this! 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
Installing of MySQL on redhat 7,2
Hello! I have tried to install MySQL on my linux box. The problem is that files be installed on /usr/bin,why? By the way I run my application which should run on MySQL, I get the error message which includes that libmysqlclient.so.6 could not find!!! What I have down wrong? best regards Nasser - 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: console freezes when starting mysqld
On Fri, 18 Jan 2002, Larry Brown wrote: I just double checked and the doesn't make a difference. It still just hangs there after executing safe_mysql . let's try # exec safe_mysqld when starting from command prompt when from rc.x script put it on end of rc.local or in separate file like rc.mysqld best regardz Parys - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
no umlauts in mysql client
help! I upgraded to the most recent version of mysql client (3.23.47) under SuSE linux 7.1. now the client does not accept any 8-bit characters any more - any special character input is discarded (from the keyboard and from the clipboard as well). how can I change that? s.m. qualimedic ag sascha mantscheff telefon 02292-922 492 telefax 02292-922 493 mobil 0171-620 0380 e-Mail [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqlbug
Hai! I tried to install MySQL in my linux box (redhat 7.2) by using the rpm files. Where should the files get after installation. In mine the get to /usr/bin and when i use MySQL with som appliction,i get error message which includes somethings about could not find libmysqlclient.so.6 What is wrong here? best regards Nasser - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
What should I set in the mysql.user?
Hi We develop a commercial site, where the mysql db, and the apache will run on the same machine. We use PHP to process the data. What should I set in the mysql.user and mysql.db tables into the Host field if I want to enable the connections just from the same server not from everywhere? '%', or 'localhost', or 'www.servername.com' ??? Thanks in advance! Regards, Istvan - 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: What should I set in the mysql.user?
Takacs Istvan wrote: What should I set in the mysql.user and mysql.db tables into the Host field if I want to enable the connections just from the same server not from everywhere? '%', or 'localhost', or 'www.servername.com' ??? The safest and easiest way is to use the --skip-networking option to mysqld. Rune - 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
Checking if Replication really works
Hy, having Replication running now, I would like to know if there are ways to test if it all _really_ works ok. Things i know I could do: - checking that no errors occur in the logs on master and slave - testing some queries an see if the changes take effect on the master and the slave in the same manner - maybe testing the size of the database directories on the master and the slave (after doing the right flush commands and shuttong dowen master?!) or doing diffs of all the files in the databse directories - counting the number of rows in each table Can I use those all to check if everythings ok? Are there other testing mechanisms? Or can i just trust in Mysql that everything that _can_ go wrong will produce error messages? Another interesting question would be if i can configure mysql to send an email when an error occurs, or if i have to use third party software to watch the logs? TIA, henning - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Checking if Replication really works
I'm not using replication, but for a test if it really works I would do some data manipulations on the master and afterwards a complete mysqldump of master and replica and diff the result. s.m. - 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: Checking if Replication really works
sascha mantscheff wrote: I'm not using replication, but for a test if it really works I would do some data manipulations on the master and afterwards a complete mysqldump of master and replica and diff the result. ok, this is an new and interesting idea, has anyone an idea how long it can take to diff two mysqldumps of 300 mb on a AMD 600 with 196 MB RAM? henning - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Checking if Replication really works
Ihre Nachricht vom Friday 18 January 2002 12:14: sascha mantscheff wrote: I'm not using replication, but for a test if it really works I would do some data manipulations on the master and afterwards a complete mysqldump of master and replica and diff the result. ok, this is an new and interesting idea, has anyone an idea how long it can take to diff two mysqldumps of 300 mb on a AMD 600 with 196 MB RAM? henning does it matter? try it on some smaller tables first, then on the big ones, then on the whole bunch. it will take much less time then to fix any problems afterwards, in case that replication doesn't work as expected. s.m. - 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: Checking if Replication really works
sascha mantscheff wrote: Ihre Nachricht vom Friday 18 January 2002 12:14: sascha mantscheff wrote: I'm not using replication, but for a test if it really works I would do some data manipulations on the master and afterwards a complete mysqldump of master and replica and diff the result. ok, this is an new and interesting idea, has anyone an idea how long it can take to diff two mysqldumps of 300 mb on a AMD 600 with 196 MB RAM? henning does it matter? shure it does. first to say, it wasn't meant as a critical question, but as an informal question. it matters in the way that it is impractical if machines of this size just crash when trying such a diff (i accidentally opened such a file in vim, that was no fun!) or when the diff takes a week or so. try it on some smaller tables first, then on the big ones, then on the whole bunch. it will take much less time then to fix any problems afterwards, in case that replication doesn't work as expected. hmm, maybe, but maybe not, if diffs of this size would take a week i could only test it once and would then rely on the mysql error mechanism. if i'd insist in doing consistency checks on a regular basis i would maybe better try the old way of backup and zipping the datafiles once in a while... henning - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Two daemons, 1 data dir.
Hi, I've got 2 mysql server that I want to configure in a hot-standby config in the following manner: Two servers with a fibre channel connection to a central storage array. The data dir of the database is on this storage array. The OS (linux or solaris, haven't decided yet) sees this datadir as a normal part of its filesystem. The two servers are both connected to a layer 7 switch that can do loadbalancing and hotstandby switching. I'd like to configure the switch to do the last. The switch makes use of a virtual IP address an to this VIP a pool of real addresses is asigned. The switch is configured to 'route' all traffic on port 3306 via a primary path. In case of failure in this path (for instance by crashing of the mysqld) the switch wil start using the secondary path. This setup is completely transparant for the mysql client, because the client is communicating with the VIP of the switch. I'd like to use this setup because a master/slave config is too slow in case of failover for our situation (we need a very fast failover config). Now I'd like to know the following: Can two mysqld's use the same datadir/database (remember they are not writing to the same database at the same time!)? Which OS will support this best in terms of filelocking etc. Linux or Solaris (the fibre channel adapters are well supported in both OSes). Any other views on this type of setup. Regards, Danny - 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: Checking if Replication really works
Henning Sprang wrote: sascha mantscheff wrote: I'm not using replication, but for a test if it really works I would do some data manipulations on the master and afterwards a complete mysqldump of master and replica and diff the result. ok, this is an new and interesting idea, has anyone an idea how long it can take to diff two mysqldumps of 300 mb on a AMD 600 with 196 MB RAM? I think if there are just small differences the diff didn't take much longer than making a dump times two. But I got in throuble with this idea because after a mass update of records the subsequent diff used all memory an swap space. I think the size of the files should be less than the total RAM if you want to be sure that it will always work with the standard unix diff utility Rune - 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: Two daemons, 1 data dir.
Yes you can run two or more MySQLD's for one database. You seem to know the problems with this.. I would use Linux but I just find it easy to use mysqld is stable but if it is not you could just kill it and restart a new one. What is more important is the data, how are you protecting that? If mysqld if faulty it mite just damage the data? Simon PS mysql should not go down anyway :-) -Original Message- From: CyberSushi [mailto:[EMAIL PROTECTED]] Sent: 18 January 2002 11:39 To: mysql Subject: Two daemons, 1 data dir. Hi, I've got 2 mysql server that I want to configure in a hot-standby config in the following manner: Two servers with a fibre channel connection to a central storage array. The data dir of the database is on this storage array. The OS (linux or solaris, haven't decided yet) sees this datadir as a normal part of its filesystem. The two servers are both connected to a layer 7 switch that can do loadbalancing and hotstandby switching. I'd like to configure the switch to do the last. The switch makes use of a virtual IP address an to this VIP a pool of real addresses is asigned. The switch is configured to 'route' all traffic on port 3306 via a primary path. In case of failure in this path (for instance by crashing of the mysqld) the switch wil start using the secondary path. This setup is completely transparant for the mysql client, because the client is communicating with the VIP of the switch. I'd like to use this setup because a master/slave config is too slow in case of failover for our situation (we need a very fast failover config). Now I'd like to know the following: Can two mysqld's use the same datadir/database (remember they are not writing to the same database at the same time!)? Which OS will support this best in terms of filelocking etc. Linux or Solaris (the fibre channel adapters are well supported in both OSes). Any other views on this type of setup. Regards, Danny - 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 1114 table full with 14000 error??
Hi! You have hit the problem of easy installation of MySQL-4.0 :) From the manual at http://www.innodb.com/ibman.html : . 2 InnoDB startup options To use InnoDB tables in MySQL-Max-3.23 you MUST specify configuration parameters in the [mysqld] section of the configuration file my.cnf, or on Windows optionally in my.ini. At the minimum in 3.23 you must specify innodb_data_file_path. In MySQL-4.0 you do not need to specify even innodb_data_file_path: the default for it is to create a 64 MB file ibdata1 to the datadir of MySQL. But to get good performance you MUST explicitly set the InnoDB parameters listed below in the examples. MySQL-4.0 automatically creates a 64 MB data file ibdata1 if you do not specify any InnoDB startup options. When that file gets full, you will get the 'table is full error'. Please look in the manual and specify the InnoDB options in my.cnf as recommended. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB [EMAIL PROTECTED] wrote in message ... I am running Mysql 4.0 with InnoDB on a linux 2.4.0 machine I am doing a mass import of a file with some 40 inserts and I get a strange unknown error 1114 Interestingly enough , this is not exactly reproducible, i.e. the error occurs in slightly different import positions. I have been able thus far to successfully import at least 10 such files with the same size with no problems. Any ideas of what is wrong?? Thanks, S.Alexiou sp@qu5:~/NEW4 perror 1114 Error code 1114: Unknown error 1114 sp@qu5:~/NEW4 su Password: root@qu5:/home/sp/NEW4 ulimit -n 8192 root@quy5:/home/sp/NEW4 ulimit -a limit core file size (blocks) 0 data seg size (kbytes) unlimited file size (blocks) unlimited max locked memory (kbytes) unlimited max memory size (kbytes)unlimited open files 8192 pipe size (512 bytes) 8 stack size (kbytes) unlimited cpu time (seconds) unlimited max user processes 32767 virtual memory (kbytes) unlimited root@qu5:/home/sp/NEW4 cat /proc/sys/fs/file-nr 140273 8192 root@qu5:/home/sp/NEW4 root@qu5:/home/sp/NEW4 mysql -u sp -p DB1 newbackfrom20011009_ermsc1.sql Enter password: ERROR 1114 at line 111235: The table 'DR_OUTGOING_49_1' is full root@qu5:/home/sp/NEW4 vi newbackfrom20011009_ermsc1.sql root@qu5:/home/sp/NEW4 mysql -u sp -p DB1 newbackfrom20011009_ermsc1.sql Enter password: ERROR 1114 at line 119737: The table 'DR_TRANSIT_78_0' is full root@quality5:/home/sp/NEW4 How big is that table? from kmysqladmin I get: SELECT * FROM CDR_TRANSIT_78_0 ORDER BY anum LIMIT 9 46942 row(s) found The table newbackfrom20011009_ermsc1.sql looks like this: -- set autocommit=0; INSERT INTO DATES (donedate) VALUES('2001-10-09') ; INSERT INTO DR_TR_389_0 UES( '','389222963',4129,5857,2,'2001-10- 08','22:59:35',0,0,0,0.205625057220459,0,28,4,'AAA1',1,0 ,3,'','','',10,0,'1','1',2,'','','20011009_ermsc1',1 ,0,'','','','','-128-144-163-49-2-0-90-58-6-68-3-87-0- 0-',3,'','' ); commit; --- Similarly, I get the same type of error when doing a report vi a gui-driven perl script on a differnt table: Tk::Error: DBD::mysql::st execute failed: The table 'TMP2' is full at report79.pl line 404. [\\main::__ANON__] SELECT * FROM TMP2 ORDER BY date LIMIT 9 16019 row(s) found --- sp@qu5:~/QUER df -h FilesystemSize Used Avail Use% Mounted on /dev/sda6 9.7G 4.8G 4.9G 49% / /dev/sda7 4.6G 3.0G 1.6G 66% /var /dev/sda1 23M 4.8M 16M 22% /boot /dev/sda8 20G 14G 5.6G 72% /home /dev/fd0 1.4M 821k 603k 58% /floppy Here i s/etc/my.cnf # Example mysql config file for very large systems. # # This is for large system with memory of 1G-2G where the system runs mainly # MySQL. # # You can copy this file to # /etc/mf.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options (in this # installation this directory is /var/lib/mysql) or # ~/.my.cnf to set user-specific options. # # One can in this file use all long options that the program supports. # If you want to know which options a program support, run the program # with --help option. # The following options will be passed to all MySQL clients [client] #password = your_password port = 3306 socket = /var/lib/mysql/mysql.sock # Here follows entries for some specific programs # The MySQL server [mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock skip-locking set-variable = key_buffer=384M set-variable = max_allowed_packet=1M set-variable = table_cache=512 set-variable = sort_buffer=2M set-variable = record_buffer=2M set-variable = thread_cache=8 set-variable = thread_concurrency=2 # Try number of CPU's*2
Re: Checking if Replication really works
Ihre Nachricht vom Friday 18 January 2002 12:14: sascha mantscheff wrote: I'm not using replication, but for a test if it really works I would do some data manipulations on the master and afterwards a complete mysqldump of master and replica and diff the result. ok, this is an new and interesting idea, has anyone an idea how long it can take to diff two mysqldumps of 300 mb on a AMD 600 with 196 MB RAM? henning additional idea: if your concern is memory, gzip or compress both dumps and then compare them. or, write a small tool which chops the dumps in equal chunks of 1 MB or so and compare the chunks. s.m. - 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: Two daemons, 1 data dir.
Hi, I'm not sure if I understand you but you can't have the datadir/database filesystem monted read-write on the two servers at the same time. At least not with consistensy. Perhaps with innodb on raw devices? /Jörgen CyberSushi wrote: Hi, I've got 2 mysql server that I want to configure in a hot-standby config in the following manner: Two servers with a fibre channel connection to a central storage array. The data dir of the database is on this storage array. The OS (linux or solaris, haven't decided yet) sees this datadir as a normal part of its filesystem. The two servers are both connected to a layer 7 switch that can do loadbalancing and hotstandby switching. I'd like to configure the switch to do the last. The switch makes use of a virtual IP address an to this VIP a pool of real addresses is asigned. The switch is configured to 'route' all traffic on port 3306 via a primary path. In case of failure in this path (for instance by crashing of the mysqld) the switch wil start using the secondary path. This setup is completely transparant for the mysql client, because the client is communicating with the VIP of the switch. I'd like to use this setup because a master/slave config is too slow in case of failover for our situation (we need a very fast failover config). Now I'd like to know the following: Can two mysqld's use the same datadir/database (remember they are not writing to the same database at the same time!)? Which OS will support this best in terms of filelocking etc. Linux or Solaris (the fibre channel adapters are well supported in both OSes). Any other views on this type of setup. Regards, Danny - 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
compiling and/or running 64-bit MySQL on Solaris 8/sparc?
Is it possible to compile and run MySQL as a 64-bit program on Solaris 8? If so, are there precompiled bits available? The primary reason for doing this is to determine if a 64-bit version would allow the database to be larger than 4-gig. I have been told by another member of our team MySQL has such a limit, and he suggested a 64-bit build might overcome it. Is this correct? I've been attempting to compile MySQL 3.23.47 and 4.0.1 as a 64-bit program using gcc 3.0.3. To build the GCC 3.0.3 with 64 bit capabilities I believe I followed the example found here faithfully: http://www.well.com/~jax/rcfb/solaris_tips/build_gcc_3.0_64bit.html http://www.well.com/~jax/rcfb/solaris_tips/build_gcc_3.0_64bit.html When I attempt to build the MySQL I get an argument from the ./configure script telling me checking return type of sprintf... configure: error: can not run test program while cross compiling. I'm not an expert in the area of gcc and the gnu tools, so I may well have done something wrong somewhere along the line. I'd like to know if I am attempting something that can be accomplished. Has anybody got this working? Here is the complete dump of the configure script: bash-2.03# ./configure --prefix=/opt/ --host=sparcv9-sun-solaris2 loading cache ./config.cache checking host system type... sparcv9-sun-solaris2 checking target system type... sparcv9-sun-solaris2 checking build system type... sparcv9-sun-solaris2 checking for a BSD compatible install... (cached) /usr/local/bin/install -c checking whether build environment is sane... yes checking whether make sets ${MAKE}... (cached) yes checking for working aclocal... found checking for working autoconf... found checking for working automake... found checking for working autoheader... found checking for working makeinfo... missing checking whether to enable maintainer-specific portions of Makefiles... no checking whether build environment is sane... yes checking whether make sets ${MAKE}... (cached) yes checking for gawk... (cached) nawk checking for gcc... (cached) gcc checking whether the C compiler (gcc ) works... yes checking whether the C compiler (gcc ) is a cross-compiler... no checking whether we are using GNU C... (cached) yes checking whether gcc accepts -g... (cached) yes checking for c++... (cached) c++ checking whether the C++ compiler (c++ ) works... yes checking whether the C++ compiler (c++ ) is a cross-compiler... yes checking whether we are using GNU C++... (cached) yes checking whether c++ accepts -g... (cached) yes checking how to run the C preprocessor... (cached) gcc -E checking for ranlib... (cached) ranlib checking for ld used by GCC... (cached) /usr/ccs/bin/ld checking if the linker (/usr/ccs/bin/ld) is GNU ld... (cached) no checking for BSD-compatible nm... (cached) /usr/local/bin/nm -B checking whether ln -s works... (cached) yes loading cache ./config.cache within ltconfig checking for object suffix... o checking for executable suffix... (cached) no checking for gcc option to produce PIC... -fPIC checking if gcc PIC flag -fPIC works... yes checking if gcc supports -c -o file.o... yes checking if gcc supports -c -o file.lo... yes checking if gcc supports -fno-rtti -fno-exceptions ... yes checking if gcc static flag -static works... none checking if the linker (/usr/ccs/bin/ld) is GNU ld... no checking whether the linker (/usr/ccs/bin/ld) supports shared libraries... yes checking command to parse /usr/local/bin/nm -B output... ok checking how to hardcode library paths into programs... immediate checking for /usr/ccs/bin/ld option to reload object files... -r checking dynamic linker characteristics... solaris2 ld.so checking if libtool supports shared libraries... yes checking whether to build shared libraries... yes checking whether to build static libraries... yes checking for objdir... .libs creating libtool loading cache ./config.cache checking for a BSD compatible install... /usr/local/bin/install -c checking for bison... bison -y checking for pdftex... no checking return type of sprintf... configure: error: can not run test program while cross compiling bash-2.03# - 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
find double
hi, i have a mysql table with 10 millions rows. Response time is perfect, but i have some duplicated entries inside ... (maybe 100 - 200 rows) how can i find them using only SQL ? i can do it with php but really don't know if it is possible using only a SQL query ... best regards. Jean-Fabrice Leoni AXSMARINE Paris Cyber Village 204 rue de Crimée 75019 Paris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Compiling on Solaris
Brad Teale writes: A couple of questions about compiling on Solaris. 1) Are the Sun Workshop 6 compilers supported for MySQL and MySQL++? 1a) Can you use the -native flag without problems? 2) Is the binary distribution compiled with Sun or GNU compilers? Background Info: We are currently trying to ingest 1.5M/sec of weather data into a database, and we have had luck using MySQL 3.23.4x on a Linux 800Mhz machine with 256M of RAM. However, this machine is basically useless for anything else, and it is my desktop. We have several Sun servers with 4+ procs and 4+Gb of RAM, and I thought one would make a good ingest machine. So I would like to compile MySQL and MySQL++ with the Sun compilers to take full advantage of everything the platform has to offer. Any help would be great. Thanks, Brad Teale Universal Weather and Aviation, Inc. mailto:[EMAIL PROTECTED] Hi! The answers to your questions : 1) Yes with MySQL, no with MySQL++. Nobody had ported it to the later 2) GNU You would be better with our binaries. They have been built optimally ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Compiling on Solaris
Brad Teale writes: I found the answers to my previous question about MySQL in the manual. Doh! However, when I tried to compile MySQL, I ran into the following error: [skip] processors hash.c, line 189: reference to static variable hash_key in inline extern function hash.c, line 229: cannot recover from previous errors cc: acomp failed for hash.c make[2]: *** [hash.lo] Error 1 make[2]: Leaving directory `/export/home/bteale/pkgs/mysql-3.23.47/libmysql' make[1]: *** [all-recursive] Error 1 Thanks, Brad Teale Universal Weather and Aviation, Inc. mailto:[EMAIL PROTECTED] Hi! Solution to the problem is to #define _FORTREC_ in config.h and my_config.h. We have fixed configure for Sun C++ only recently, so the fix will appear in the next version. But I repeat again, you would be better off with our binaries ... -- Consider taking our support. Visit : https://order.mysql.com 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
Fwd: Re: compiling and/or running 64-bit MySQL on Solaris 8/sparc?
Forgot to CC to the list. Here it goes, in case anyone else has these problems: -- Forwarded Message -- Subject: Re: compiling and/or running 64-bit MySQL on Solaris 8/sparc? Date: Fri, 18 Jan 2002 15:06:57 +0200 From: Markus Lervik [EMAIL PROTECTED] To: Hatton Steven [EMAIL PROTECTED] On Friday 18 January 2002 13:57, you wrote: [BIG snip] checking return type of sprintf... configure: error: can not run test program while cross compiling bash-2.03# [/snip] Try adding export LDFLAGS='-R/usr/local/lib' or export LDFLAGS='-R/opt/sfw/lib' before ./configure. Cheers, Markus -- Markus Lervik UNIX-administrator with a kungfoo grip Vaasa City Library - Regional Library [EMAIL PROTECTED] +358-6-325 3589 / +358-40-832 6709 - 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: find double
you should make a self-join to find the duplicates in one table. -Original Message- From: Jean Fabrice Leoni [mailto:[EMAIL PROTECTED]] Sent: Friday, January 18, 2002 2:00 PM To: [EMAIL PROTECTED] Subject: find double hi, i have a mysql table with 10 millions rows. Response time is perfect, but i have some duplicated entries inside ... (maybe 100 - 200 rows) how can i find them using only SQL ? i can do it with php but really don't know if it is possible using only a SQL query ... best regards. Jean-Fabrice Leoni AXSMARINE Paris Cyber Village 204 rue de Crimée 75019 Paris - 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
Porting from MS SQL to MySQL
Hello all! We've requested a database from different companies, and specifically said we wanted MySQL or PostgreSQL because of the open source angle and we're a library. One company offered MS SQL as the platform and said that they can later on port it to MySQL. For this they wanted 18 000 euro. Now, what I want to know is, how easy is it to port a (fairly complicated) database from MS SQL to MySQL? It can't be work worth 18 000 euro, now can it? Cheers, Markus -- Markus Lervik Linux-administrator with a kungfoo grip Vaasa City Library - Regional Library [EMAIL PROTECTED] +358-6-325 3589 / +358-40-832 6709 - 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: Porting from MS SQL to MySQL
Hi first of all it is ridiculus of the company to offer something other than your specifications. if they want to offer you a solution other than what you need, they have to change the software at their cost not at yours. in my opinion it is better to not accept this solution at all and look for other options. you will definitely get lots of options. for starters go thru freshmeat.net. Jatin On Friday 18 January 2002 18:46, Markus Lervik wrote: Hello all! We've requested a database from different companies, and specifically said we wanted MySQL or PostgreSQL because of the open source angle and we're a library. One company offered MS SQL as the platform and said that they can later on port it to MySQL. For this they wanted 18 000 euro. Now, what I want to know is, how easy is it to port a (fairly complicated) database from MS SQL to MySQL? It can't be work worth 18 000 euro, now can it? Cheers, Markus - 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: Porting from MS SQL to MySQL
On Friday 18 January 2002 15:58, you wrote: On Fri, Jan 18, 2002 at 03:16:15PM +0200, Markus Lervik wrote: We've requested a database from different companies, and specifically said we wanted MySQL or PostgreSQL because of the open source angle and we're a library. One company offered MS SQL as the platform and said that they can later on port it to MySQL. For this they wanted 18 000 euro. Now, what I want to know is, how easy is it to port a (fairly complicated) database from MS SQL to MySQL? It can't be work worth 18 000 euro, now can it? That's a bit strange. If the app is built with MySQL in mind, porting it should be very, very easy. But if they're going to build the app with MySQL in mind anyway, it doesn't make much sense to do so on a platform other than MySQL, does it? One wouldn't think it does. It raises a few questions. Mainly one of trying to rip us off. The main reason we want the database on MySQL or PostgreSQL (apart from the speed issue) is that our Win2K server is going to be buried and a nice, shiney Linux-server is taking it's place next to the one we already got. Being involved in this project, one becomes amazed with the amout of eye-pissing companies really can get away with. And respected companies too. (I won't mention any names, I don't want any lawsuits : ) For instance, one offered to come and sit down and discuss our needs with us (they calculated that it'd take about 40h for us to repeat what we've already said) and wanted 28 000 euro for it. Cheers, Markus -- Markus Lervik Linux-administrator with a kungfoo grip Vaasa City Library - Regional Library [EMAIL PROTECTED] +358-6-325 3589 / +358-40-832 6709 - 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: Porting from MS SQL to MySQL
If you know you're going to port it, it really shouldn't be too difficult. In fact, if you're creating it with the intention of porting it, you can (and should) use MSSQL datatypes that are compatible with MySQL. If you do this, porting is a trivial task at best. 18,000 euro seems a bit steep for a couple hours of work... By-the-way: there doesn't seem to be any obvious reason to create the database in MSSQL (other than a 18,000 euro conversion project later). You might consider developing the database using MySQL or PostgreSQL initially and eliminate the conversion issue... On Fri, 18 Jan 2002, Markus Lervik wrote: One company offered MS SQL as the platform and said that they can later on port it to MySQL. For this they wanted 18 000 euro. Now, what I want to know is, how easy is it to port a (fairly complicated) database from MS SQL to MySQL? It can't be work worth 18 000 euro, now can it? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Porting from MS SQL to MySQL
Jeremy Zawodny wrote: On Fri, Jan 18, 2002 at 03:16:15PM +0200, Markus Lervik wrote: Hello all! We've requested a database from different companies, and specifically said we wanted MySQL or PostgreSQL because of the open source angle and we're a library. One company offered MS SQL as the platform and said that they can later on port it to MySQL. For this they wanted 18 000 euro. Now, what I want to know is, how easy is it to port a (fairly complicated) database from MS SQL to MySQL? It can't be work worth 18 000 euro, now can it? That's a bit strange. If the app is built with MySQL in mind, porting it should be very, very easy. But if they're going to build the app with MySQL in mind anyway, it doesn't make much sense to do so on a platform other than MySQL, does it? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 15 days, processed 362,696,624 queries (268/sec. avg) I agree. If they are a seriuos company they should build it after the customers wishes i.e if you want mysql the company should build it with mysql. For 18,000 euro i could build the system myself:) My two cents /PM\ - 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
replication between two databases on single server?
Is it possible to replicate between two databases on a single server, and if not, then what is the next best solution? I administer a Bugzilla installation with about 1.8GB in a MySQL database. Bugzilla has a built-in replication solution that copies data from a primary database optimized for updates to a shadow database optimized for reads. This replication solution has a few hard-to-find bugs that cause periodic data corruption in the shadow database. We work around these problems by recreating the shadow database from scratch every night, but that causes its own problems with disk space availability (for the dump file) and downtime (it takes up to an hour without compression and up to 1.5 hours with gzip compression to dump the data into a dump file and then import it into the shadow database, and night for the bulk of our users is day for our other users around the world). So, I'm looking for a better solution. It's possible that I could obtain a second server and hack Bugzilla to handle it, but first I want to find an easier solution if one exists. Is there a way to use MySQL's built-in replication to replicate two databases residing on the same server? If not, is there another replication solution that could do the job? If not, could mysqlhotcopy solve my problems with the nightly shadow database rebuild at least, and if so do I need to do anything more (i.e. lock that database) than point the script at the shadow database directory and let it overwrite those files? -myk - 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 in join on bdb table
Hi, I just experienced the following bug in tables created as berkeley tables: on bdb tables: mysql SELECT jobs.number,jobs.status,jobs.filename,jobs.source_file,verarbeitung.name FROM verarbeitung right join jobs on (verarbeitung.verarbeitung = jobs.verarbeitung) order by jobs.number; +++---+--+--+ | number | status | filename | source_file | name | +++---+--+--+ | 1 | 1 | NULL | NULL | NULL | | 2 | 1 | /u/lpqueues/debis/data.40 | /etc/hosts | NULL | | 3 | 1 | /u/lpqueues/debis/data.41 | /etc/hosts | NULL | | 4 | 1 | /pfad/zum/datenfile | DEFSYSM.SAF0006.SAF00066.JOB07513.D103.? | NULL | | 5 | 1 | /pfad/zum/ogottogott | DEFSYSM.SAF0006.SAF00064.JOB07514.D103.? | NULL | +++---+--+--+ 5 rows in set (0.15 sec) on isam,bdb tables: mysql SELECT jobs.number,jobs.status,jobs.filename,jobs.source_file,verarbeitung.name FROM verarbeitung right join jobs on (verarbeitung.verarbeitung = jobs.verarbeitung) order by jobs.number; +++--+--++ | number | status | filename | source_file | name | +++--+--++ | 1 | 1 | NULL | NULL | NULL | | 2 | 1 | /pfad/zum/datenfile | DEFSYSM.SAF0006.SAF00066.JOB07513.D103.? | ICOM | | 2 | 1 | /pfad/zum/datenfile | DEFSYSM.SAF0006.SAF00066.JOB07513.D103.? | CR-LF | | 3 | 1 | /pfad/zum/ogottogott | DEFSYSM.SAF0006.SAF00064.JOB07514.D103.? | CR-LF | | 4 | 1 | /pfad/zum/datenfile | /etc/hosts | NULL | +++--+--++ 5 rows in set (0.15 sec) This is on mysql 3.23.47, I did not use exactly be same rows in the comparison above but get the point. Just compare the rows with filename = /pfad/zum/ogottogott in both select statements. The information in the jobs and verarbeitung table are identical and the tables have been created this way for the second select statement, for the first statement they both have been created using bdb: drop table if exists verarbeitung; create table verarbeitung ( id int auto_increment not null primary key, verarbeitung int, priority int, name char(50), submission timestamp, filename char(100), params char(255)) type=isam; drop table if exists jobs; create table jobs ( number int auto_increment not null primary key, queuename char(50), verarbeitung smallint default 0, status smallint default 0, submission timestamp, filename char(100), host_name char(32), user_name char(32), job_name char(100), class_banner char(32), print_banner char(32), free_file char(32), source_file char(132), printf_format char(32), printf_unformat char(32), optionT char(132), datat char(2), fileformat char(7), cc char(4), cctype char(2), chars char(18), pagedef char(9), trc char(4), ff char(9), cop smallint default 1, jobn char(9), us char(9), no char(9), pr char(32), ro char(32), forms char(5), class char(2), destination char(9)) type=bdb; Is it in general dangerous to use bdb tables? Best regards, Carsten Hammer - 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: Porting from MS SQL to MySQL
I can't say that I am a database specialist, but I still think that there will be some problems porting a MSSQL to mysql, and this because it seems that MSSQL is very linked to the operating systems it runs on, i.e. Windows (only think to the security for MSSQL). -Original Message- From: Markus Lervik [mailto:[EMAIL PROTECTED]] Sent: Friday, January 18, 2002 3:06 PM To: [EMAIL PROTECTED] Subject: Re: Porting from MS SQL to MySQL On Friday 18 January 2002 15:58, you wrote: On Fri, Jan 18, 2002 at 03:16:15PM +0200, Markus Lervik wrote: We've requested a database from different companies, and specifically said we wanted MySQL or PostgreSQL because of the open source angle and we're a library. One company offered MS SQL as the platform and said that they can later on port it to MySQL. For this they wanted 18 000 euro. Now, what I want to know is, how easy is it to port a (fairly complicated) database from MS SQL to MySQL? It can't be work worth 18 000 euro, now can it? That's a bit strange. If the app is built with MySQL in mind, porting it should be very, very easy. But if they're going to build the app with MySQL in mind anyway, it doesn't make much sense to do so on a platform other than MySQL, does it? One wouldn't think it does. It raises a few questions. Mainly one of trying to rip us off. The main reason we want the database on MySQL or PostgreSQL (apart from the speed issue) is that our Win2K server is going to be buried and a nice, shiney Linux-server is taking it's place next to the one we already got. Being involved in this project, one becomes amazed with the amout of eye-pissing companies really can get away with. And respected companies too. (I won't mention any names, I don't want any lawsuits : ) For instance, one offered to come and sit down and discuss our needs with us (they calculated that it'd take about 40h for us to repeat what we've already said) and wanted 28 000 euro for it. Cheers, Markus -- Markus Lervik Linux-administrator with a kungfoo grip Vaasa City Library - Regional Library [EMAIL PROTECTED] +358-6-325 3589 / +358-40-832 6709 - 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: Two daemons, 1 data dir.
My concern would be, what is the mysqld without a database going to do. Wouldn't it need some kind of dummy data dir. I'm sure the daemon does some random checks of its data to ensure that it is still there. If this is not a problem then this seems fine. As far as the OS goes, I would like to suggest Linux, but I would think that the file locking is better in SOlaris. Hope this is helpful. John Lodge -Original Message- From: CyberSushi [mailto:[EMAIL PROTECTED]] Sent: Friday, January 18, 2002 11:39 AM To: mysql Subject: Two daemons, 1 data dir. Hi, I've got 2 mysql server that I want to configure in a hot-standby config in the following manner: Two servers with a fibre channel connection to a central storage array. The data dir of the database is on this storage array. The OS (linux or solaris, haven't decided yet) sees this datadir as a normal part of its filesystem. The two servers are both connected to a layer 7 switch that can do loadbalancing and hotstandby switching. I'd like to configure the switch to do the last. The switch makes use of a virtual IP address an to this VIP a pool of real addresses is asigned. The switch is configured to 'route' all traffic on port 3306 via a primary path. In case of failure in this path (for instance by crashing of the mysqld) the switch wil start using the secondary path. This setup is completely transparant for the mysql client, because the client is communicating with the VIP of the switch. I'd like to use this setup because a master/slave config is too slow in case of failover for our situation (we need a very fast failover config). Now I'd like to know the following: Can two mysqld's use the same datadir/database (remember they are not writing to the same database at the same time!)? Which OS will support this best in terms of filelocking etc. Linux or Solaris (the fibre channel adapters are well supported in both OSes). Any other views on this type of setup. Regards, Danny - 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: console freezes when starting mysqld
It will write a status message over the '# prompt. Hit enter. Does the prompt return? Larry Brown wrote: I just double checked and the doesn't make a difference. It still just hangs there after executing safe_mysql . Larry S. Brown President/CEO Dimension Networks, Inc. Member ICCA (727) 723-8388 - 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: Why does DISTINCT take so long time ??
Fournier Jocelyn [Presence-PC] writes: Hi, I've notice sometimes DISTINCT clause take a really high amount of time to remove duplicates whereas it should be really quick (I assume it should be ;)) [skip] Why does it take so much time to remove duplicates in only 58 rows ?? Thank you :) Regards, Jocelyn Fournier Presence-PC Hi! Because it has to make first a temporary table with 2 million rows. And is it 4.0.1 ? -- 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: Why does DISTINCT take so long time ??
Hi, Yes it is 4.0.1. But the first query has also to make a temporary table with 2 million rows, it's why I don't understand the delta between the query without DISTINCT and the query with DISTINCT. The remove duplicates doesn't occurs after the join was performed ?? (it should be really fast in this case) Regards, Jocelyn - Original Message - From: Sinisa Milivojevic [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, January 18, 2002 3:57 PM Subject: Re: Why does DISTINCT take so long time ?? Fournier Jocelyn [Presence-PC] writes: Hi, I've notice sometimes DISTINCT clause take a really high amount of time to remove duplicates whereas it should be really quick (I assume it should be ;)) [skip] Why does it take so much time to remove duplicates in only 58 rows ?? Thank you :) Regards, Jocelyn Fournier Presence-PC Hi! Because it has to make first a temporary table with 2 million rows. And is it 4.0.1 ? -- 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: C++ API on MacOS X 10.1.1
Chris Allum writes: Hi, I'm trying to use the mysql++ API on MacOS X with Project Builder, but I am not sure what to do to get started. Any suggestions? Thanks, - Chris -- Christopher Allum [EMAIL PROTECTED] Alluminity Solutions -- Hi! MySQL++ can easily be used on MacOS X with GNU 2.95.* and 3.0.* compilers. There is also a binary library for 2.95.2 on MySQL++ page for your OS. -- 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
How do I verify it's a 64-bit build
Sorry about the previous, seemingly stupid question asking for clarification on the LDFLAGS. I was not able to hit http://home.earthlink.net/~jaymzh666/mysql.html , so I did not realize that answer was there. I now seem to have a successfully built MySQL 3.23.47 using what I believe is a 64-bit capable gcc-3.0.3. How might I verify that I indeed have a 64-bit MySQL? TIA, Steven - 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: Re: compiling and/or running 64-bit MySQL on Solaris 8/sparc?
-Original Message- From: Markus Lervik [mailto:[EMAIL PROTECTED]] Sent: Friday, January 18, 2002 8:08 AM To: [EMAIL PROTECTED] Subject:Fwd: Re: compiling and/or running 64-bit MySQL on Solaris 8/sparc? On Friday 18 January 2002 13:57, you wrote: [BIG snip] checking return type of sprintf... configure: error: can not run test program while cross compiling bash-2.03# [/snip] Try adding export LDFLAGS='-R/usr/local/lib' or export LDFLAGS='-R/opt/sfw/lib' before ./configure. Cheers, Markus Markus, Thank you for the reply. I'm not sure of the reason for the LDFLAGS variable. What library files should I be pointing to with it? I put my gcc in /opt/gcc-3.0.3-64. Will this influence the proper choice of value for LDFLAGS? Steven - 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: Porting from MS SQL to MySQL
- Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, January 18, 2002 2:14 PM Subject: Re: Porting from MS SQL to MySQL Jeremy Zawodny wrote: On Fri, Jan 18, 2002 at 03:16:15PM +0200, Markus Lervik wrote: Hello all! We've requested a database from different companies, and specifically said we wanted MySQL or PostgreSQL because of the open source angle and we're a library. One company offered MS SQL as the platform and said that they can later on port it to MySQL. For this they wanted 18 000 euro. Now, what I want to know is, how easy is it to port a (fairly complicated) database from MS SQL to MySQL? It can't be work worth 18 000 euro, now can it? That's a bit strange. If the app is built with MySQL in mind, porting it should be very, very easy. But if they're going to build the app with MySQL in mind anyway, it doesn't make much sense to do so on a platform other than MySQL, does it? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 15 days, processed 362,696,624 queries (268/sec. avg) I agree. If they are a seriuos company they should build it after the customers wishes i.e if you want mysql the company should build it with mysql. For 18,000 euro i could build the system myself:) My two cents /PM\ What about the customer who asks a car company to make the vehicle's tryes out of velvet? Would you go off in a huff if they refused and demand they do it? There are obviously issues here that we are not privy to; there *must* be logic behind the choice of SQLServer. Are they saying that mySQL isn't upto it? Porting a DB takes more 'than a couple of hours'. What about the written procedures, the security mappings, the back up and recovery procs, the fallback arrangements, the testing etc. If you think E18k is a lot then ask for a detailed task plan with effort; find out what they are asking you to pay for. The DB was described as 'fairly complicated' whatever that may mean. Perhaps - and we are all guesing - there are remote data issues, views, stored procs, java and god knows what else that all needs to be integrated. Bottom line when you get a quote is find out what they want to do task by task and then cut it down from there. Tony - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Why does DISTINCT take so long time ??
Fournier Jocelyn [Presence-PC] writes: Hi, Yes it is 4.0.1. But the first query has also to make a temporary table with 2 million rows, it's why I don't understand the delta between the query without DISTINCT and the query with DISTINCT. The remove duplicates doesn't occurs after the join was performed ?? (it should be really fast in this case) Regards, Jocelyn DISTINCT simply has to re-iterate. -- 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: Why does DISTINCT take so long time ??
I understand it has to re-iterate if the number of rows in the result without DISTINCT is greater than the limit clause, but if the result without DISTINCT is lower, it should be faster to perform the DISTINCT on the result directly (or perhaps I'm missing something ? ;)). - Original Message - From: Sinisa Milivojevic [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, January 18, 2002 4:27 PM Subject: Re: Why does DISTINCT take so long time ?? Fournier Jocelyn [Presence-PC] writes: Hi, Yes it is 4.0.1. But the first query has also to make a temporary table with 2 million rows, it's why I don't understand the delta between the query without DISTINCT and the query with DISTINCT. The remove duplicates doesn't occurs after the join was performed ?? (it should be really fast in this case) Regards, Jocelyn DISTINCT simply has to re-iterate. -- 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 - 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: Porting from MS SQL to MySQL
On Fri, 18 Jan 2002, Markus Lervik wrote: Hello all! We've requested a database from different companies, and specifically said we wanted MySQL or PostgreSQL because of the open source angle and we're a library. One company offered MS SQL as the platform and said that they can later on port it to MySQL. For this they wanted 18 000 euro. Now, what I want to know is, how easy is it to port a (fairly complicated) database from MS SQL to MySQL? It can't be work worth 18 000 euro, now can it? I'm not sure I'm understaidning your question completely, but I'll try to answer it anyway. 1) Porting from MS SQL to MySQL is not the easiest of things. There are several options, and they include connecting to both via MS Access and ODBC, or using the Sybase perl drivers with the FreeTDS library to get it to talk to MS SQL. They you can write a program in perl to port the data. 2) If you want MySQL or PostgreSQL, why exactly would you want to install MSSQL, and then upgrade later? Both PostgreSQL and MySQL will run on Windows (although again, I'm not sure why you would want to do that if you have a choice). All in all, it can be complicated and time consuming. You don't want to go there. Just get MySQL or PostgreSQL in the first place, and save yourself the trouble of porting the data later. If you are about to implement a system from scratch, it's is always easiest and cheapest to do it right in the first place, with the software you want. Regards. Gordan - 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: Porting from MS SQL to MySQL
SNIPSNIP:) I agree. If they are a seriuos company they should build it after the customers wishes i.e if you want mysql the company should build it with mysql. For 18,000 euro i could build the system myself:) My two cents /PM\ What about the customer who asks a car company to make the vehicle's tryes out of velvet? Would you go off in a huff if they refused and demand they do it? There are obviously issues here that we are not privy to; there *must* be logic behind the choice of SQLServer. Are they saying that mySQL isn't upto it? Ah but if i say i want a mysql server and costs for it they shouldnt say we can do it in mssql I think they should give me an estimate on the costs for what i want then i can discuss how to get the cost down Porting a DB takes more 'than a couple of hours'. What about the written procedures, the security mappings, the back up and recovery procs, the fallback arrangements, the testing etc. If you think E18k is a lot then ask for a detailed task plan with effort; find out what they are asking you to pay for. The DB was described as 'fairly complicated' whatever that may mean. Perhaps - and we are all guesing - there are remote data issues, views, stored procs, java and god knows what else that all needs to be integrated. Mysql has always filled my need (wich is with perl,java,php) Granted it would be better to know exactly what fairly complicated is Bottom line when you get a quote is find out what they want to do task by task and then cut it down from there. I have to agree with this but i dont think you should pay for getting a workdescription from them (ofcourse i dont know much about administrating papperwork i am a technichian) Tony - 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
Compiling problem: error in type_info1.hh
Hello, I have troubles compiling this program: #include iostream.h #include iomanip.h #include c:/sqlplus/sqlplus.hh int main() {return(0);} As you can see, the program itself isn't very complicated. When I run this program (using MS Visual C++), here are the errors I get. Can anybody help me please. I would really appreciate it. You can reply me using my mail adress: [EMAIL PROTECTED] Thanks Configuration: prog - Win32 Debug Compiling... prog.cpp c:\sqlplus\type_info1.hh(31) : error C2758: '_base_type' : must be initialized in constructor base/member initializer list c:\sqlplus\type_info1.hh(27) : see declaration of '_base_type' c:\sqlplus\type_info1.hh(31) : error C2758: '_default' : must be initialized in constructor base/member initializer list c:\sqlplus\type_info1.hh(28) : see declaration of '_default' c:\sqlplus\type_info1.hh(69) : error C2252: 'offset' : pure specifier can only be specified for functions c:\sqlplus\type_info1.hh(70) : error C2258: illegal pure syntax, must be '= 0' c:\sqlplus\type_info1.hh(70) : error C2252: 'unsigned_offset' : pure specifier can only be specified for functions c:\sqlplus\type_info1.hh(71) : error C2258: illegal pure syntax, must be '= 0' c:\sqlplus\type_info1.hh(71) : error C2252: 'null_offset' : pure specifier can only be specified for functions c:\sqlplus\type_info1.hh(72) : error C2258: illegal pure syntax, must be '= 0' c:\sqlplus\type_info1.hh(72) : error C2252: 'unsigned_null_offset' : pure specifier can only be specified for functions c:\sqlplus\type_info1.hh(79) : error C2258: illegal pure syntax, must be '= 0' c:\sqlplus\type_info1.hh(79) : error C2252: 'string_type' : pure specifier can only be specified for functions c:\sqlplus\type_info1.hh(163) : warning C4800: 'unsigned int' : forcing value to bool 'true' or 'false' (performance warning) c:\sqlplus\type_info1.hh(176) : warning C4800: 'int' : forcing value to bool 'true' or 'false' (performance warning) c:\sqlplus\type_info1.hh(180) : warning C4800: 'int' : forcing value to bool 'true' or 'false' (performance warning) c:\sqlplus\type_info1.hh(184) : warning C4800: 'int' : forcing value to bool 'true' or 'false' (performance warning) c:\sqlplus\type_info1.hh(188) : warning C4800: 'int' : forcing value to bool 'true' or 'false' (performance warning) c:\sqlplus\coldata1.hh(60) : error C2039: 'string_type' : is not a member of 'mysql_type_info' c:\sqlplus\type_info1.hh(62) : see declaration of 'mysql_type_info' c:\sqlplus\coldata1.hh(125) : see reference to class template instantiation 'mysql_ColDataStr' being compiled c:\sqlplus\coldata1.hh(63) : error C2039: 'string_type' : is not a member of 'mysql_type_info' c:\sqlplus\type_info1.hh(62) : see declaration of 'mysql_type_info' c:\sqlplus\coldata1.hh(125) : see reference to class template instantiation 'mysql_ColDataStr' being compiled c:\program files\microsoft visual studio\vc98\include\strstream(52) : error C2039: 'openmode' : is not a member of 'ios' c:\program files\microsoft visual studio\vc98\include\ios.h(106) : see declaration of 'ios' c:\program files\microsoft visual studio\vc98\include\strstream(52) : error C2061: syntax error : identifier 'openmode' c:\program files\microsoft visual studio\vc98\include\strstream(54) : error C2039: 'openmode' : is not a member of 'ios' c:\program files\microsoft visual studio\vc98\include\ios.h(106) : see declaration of 'ios' c:\program files\microsoft visual studio\vc98\include\strstream(54) : error C2061: syntax error : identifier 'openmode' c:\program files\microsoft visual studio\vc98\include\strstream(91) : error C2629: unexpected 'class std::ostrstream (' c:\program files\microsoft visual studio\vc98\include\strstream(91) : error C2238: unexpected token(s) preceding ';' c:\program files\microsoft visual studio\vc98\include\strstream(109) : error C2629: unexpected 'class std::strstream (' c:\program files\microsoft visual studio\vc98\include\strstream(109) : error C2238: unexpected token(s) preceding ';' c:\program files\microsoft visual studio\vc98\include\xtree(118) : warning C4786: 'std::_Treestd::basic_stringchar,std::char_traitschar,std::allocatorchar ,std::pairstd::basic_stringchar,std::char_traitschar,std::allocatorchar const , int,std::mapstd::basic_stringchar,std::char_traitschar,std::allocatorchar ,int,std::lessstd::basic_stringchar,std::char_traitschar,std::allocatorchar ,std::allocatorint ::_Kfn,std::lessstd::basic_stringchar,std::char_traitscha r,std::allocatorchar ,std::allocatorint ' : identifier was truncated to '255' characters in the debug information c:\program files\microsoft visual studio\vc98\include\map(46) : see reference to class template instantiation 'std::_Treestd::basic_stringchar,std::char_traitschar,std::allocatorchar ,std::pairstd::basic_stringchar,std::char_traits char,std::allocatorchar const
Version 4 Schedule
Hello- I've done some searching through archive and the website but can't seem to find a semi-concrete answer. What's the schedule, if any, for version 4.0 to go stable? Thanks for any help or pointers. Steve - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Memory limit issue with mysql.3.23.41
We are running an extremely large instance of mysql version 3.23.41 on Solaris 2.8 and have been experiencing memory related server crashes. The behavior suggests that we are running out of memory / swap, but we have over 2 gig of memory and 10 gig of swap free. Our server settings are: key_buffer=5120M max_allowed_packet=1M table_cache=1024 sort_buffer=6M record_buffer=4M thread_cache=12 thread_concurrency=12 myisam_sort_buffer_size=512M The server tends to crash upon reaching a total memory usage of around 4 GB Here is the output from the error log. Of particular interest to us is the negative key_buffer_size quoted. The same value (-4096) appears with each crash. Is there some sort of memory limit imposed on the server or do you have suggestions for debugging this problem? Thank you, Kevin Franklin 020117 18:19:58 Out of memory; Check if mysqld or some other process uses all available memory. If not you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space 020117 18:19:58 Out of memory; Check if mysqld or some other process uses all available memory. If not you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked agaist is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail key_buffer_size=-4096 record_buffer=4190208 sort_buffer=6291448 max_used_connections=308 max_connections=1024 threads_connected=309 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 2093044 K bytes of memory Hope that's ok, if not, decrease some variables in the equation 020117 18:19:58 Out of memory; Check if mysqld or some other process uses all available memory. If not you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space 020117 18:19:58 Out of memory; Check if mysqld or some other process uses all available memory. If not you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space 020117 18:20:00 mysqld restarted - 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 do I verify it's a 64-bit build
Hatton Steven writes: Sorry about the previous, seemingly stupid question asking for clarification on the LDFLAGS. I was not able to hit http://home.earthlink.net/~jaymzh666/mysql.html , so I did not realize that answer was there. I now seem to have a successfully built MySQL 3.23.47 using what I believe is a 64-bit capable gcc-3.0.3. How might I verify that I indeed have a 64-bit MySQL? TIA, Steven Run file command on the binary. -- 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: bug in join on bdb table
Carsten Hammer writes: Hi, I just experienced the following bug in tables created as berkeley tables: [skip] Is it in general dangerous to use bdb tables? Best regards, Carsten Hammer No, it is not dangerous to use bdb tables. Can you upload gzipped dump of the tables to : ftp://support.mysql.com:/pub/mysql/Incoming and let me know a file name. -- 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: Porting from MS SQL to MySQL
- Original Message - From: [EMAIL PROTECTED] To: Tony Buckley [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, January 18, 2002 3:34 PM Subject: Re: Porting from MS SQL to MySQL SNIPSNIP:) I agree. If they are a seriuos company they should build it after the customers wishes i.e if you want mysql the company should build it with mysql. For 18,000 euro i could build the system myself:) My two cents /PM\ What about the customer who asks a car company to make the vehicle's tryes out of velvet? Would you go off in a huff if they refused and demand they do it? There are obviously issues here that we are not privy to; there *must* be logic behind the choice of SQLServer. Are they saying that mySQL isn't upto it? Ah but if i say i want a mysql server and costs for it they shouldnt say we can do it in mssql I think they should give me an estimate on the costs for what i want then i can discuss how to get the cost down Unless they are saying they doubt that mySQL is upto, it so it's no good quoting. They may have a room full of SQLServer people twiddling their thumbs in which case I agree with you, they are not bucking for the customer here. On the other hand they have very real doubts that mySQL is upto the job; they may be wrong on this last point, but at least they are being honest in their beliefs. Who knows! Porting a DB takes more 'than a couple of hours'. What about the written procedures, the security mappings, the back up and recovery procs, the fallback arrangements, the testing etc. If you think E18k is a lot then ask for a detailed task plan with effort; find out what they are asking you to pay for. The DB was described as 'fairly complicated' whatever that may mean. Perhaps - and we are all guesing - there are remote data issues, views, stored procs, java and god knows what else that all needs to be integrated. Mysql has always filled my need (wich is with perl,java,php) Granted it would be better to know exactly what fairly complicated is Bottom line when you get a quote is find out what they want to do task by task and then cut it down from there. I have to agree with this but i dont think you should pay for getting a workdescription from them (ofcourse i dont know much about administrating papperwork i am a technichian) 100% agree. Planning, including bidding for a job, is an overhead. There should be no charge for this. IBM would disagree with us however :-) Tony - 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 do I verify it's a 64-bit build
you could use: file /path-to/mysqld the output will tell you if mysqld is a 32 or 64 bit ELF executable. Hatton Steven wrote: Sorry about the previous, seemingly stupid question asking for clarification on the LDFLAGS. I was not able to hit http://home.earthlink.net/~jaymzh666/mysql.html , so I did not realize that answer was there. I now seem to have a successfully built MySQL 3.23.47 using what I believe is a 64-bit capable gcc-3.0.3. How might I verify that I indeed have a 64-bit MySQL? TIA, Steven - 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: Porting from MS SQL to MySQL
Porting a DB takes more 'than a couple of hours'. What about the written procedures, the security mappings, the back up and recovery procs, the fallback arrangements, the testing etc. Yes, porting a database that was written for MSSQL with no intention of porting can be a painful proposition. However, if you have control over how the system is developed, you can easily design the system to be compatible with EITHER MSSQL or MySQL (the differeces are well-documented). If you develop your system with porting in mind (ie the original post of they'll develop in SQLServer and port it to MySQL later) porting should not take more than a couple of hours. You simply choose appropriate datatypes and don't use MSSQL-specific extensions... On Fri, 18 Jan 2002, Tony Buckley wrote: - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, January 18, 2002 2:14 PM Subject: Re: Porting from MS SQL to MySQL What about the customer who asks a car company to make the vehicle's tryes out of velvet? Would you go off in a huff if they refused and demand they do it? There are obviously issues here that we are not privy to; there *must* be logic behind the choice of SQLServer. Are they saying that mySQL isn't upto it? Porting a DB takes more 'than a couple of hours'. What about the written procedures, the security mappings, the back up and recovery procs, the fallback arrangements, the testing etc. If you think E18k is a lot then ask for a detailed task plan with effort; find out what they are asking you to pay for. The DB was described as 'fairly complicated' whatever that may mean. Perhaps - and we are all guesing - there are remote data issues, views, stored procs, java and god knows what else that all needs to be integrated. Bottom line when you get a quote is find out what they want to do task by task and then cut it down from there. Tony - 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
DBGRID displays only (MEMO)
Hallo, I am developing a database application using Kylix ver.1 and MySQL 4.23.41-log . I can connect and execute the query but the problem is my DBGRID only displays (MEMO) . Some of my friends said that perhaps it is caused by the datatype of the field but I tried to change the datatype of the field from ftmemo into ftstring over fielddefs but.. once I restarted the database connection... the datatype of my field is automatically changed back into ftmemo and again my DBGRID doesn't display the queried table but only diplay (MEMO) in each of its cells. Is it because I have determined a wrong datatype on my MySQL ? I am using text and longtext datatype for the troubled queried table on my MySQL. So which datatype of the field do I have to use to make my DATAGRID can display my table properly ? Thank you very much for your help. __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Porting from MS SQL to MySQL
Unless they are saying they doubt that mySQL is upto, it so it's no good quoting. They may have a room full of SQLServer people twiddling their thumbs in which case I agree with you, they are not bucking for the customer here. On the other hand they have very real doubts that mySQL is upto the job; they may be wrong on this last point, but at least they are being honest in their beliefs. Who knows! This doesn't make much sense. If they're being honest and they believe MySQL can't handle it, why would they offer to port it to MySQL for 18,000 euro? On Fri, 18 Jan 2002, Tony Buckley wrote: - Original Message - From: [EMAIL PROTECTED] To: Tony Buckley [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, January 18, 2002 3:34 PM Subject: Re: Porting from MS SQL to MySQL ...[cut]... - 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
softupdates problem?
These two queries were execute one after the other. I am the only one who updates this table. I have seen this happen before, and people have said that perhaps it's a problem with softupdate. I haven't been able to address it. I am on FreeBSD 4.2 FreeBSD 3.23.35 There is quite a bit of load on the machine, but that table is not user updateable (except by me :-)). Anyone see this problem before? - mysql update tblZips set szURL = '/cgi-bin/showPage.cgi?szNextPage=placead.htmlszAction=NEWszURL=MI2' where szURL = '/cgi-bin/index.cgi?url=MI2szAction=goto+site'; Query OK, 0 rows affected (0.09 sec) mysql update tblZips set szURL = '/cgi-bin/showPage.cgi?szNextPage=placead.htmlszAction=NEWszURL=MI2' where szURL = '/cgi-bin/index.cgi?url=MI2szAction=goto+site'; Query OK, 58 rows affected (2.43 sec) - 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: Porting from MS SQL to MySQL
I agree. I have more experience with MS SQL than mySQL, but there are some MS SQL specifics that can cause hiccups. But these hiccups can be avoided with a bullet proof project plan and excellent documentation. You may not be able to automate all the project procedures and a lot of the database re-construction, which is OK. Make sure you run a test system to see if the migration is successful. Migrations are my specialty! Good luck, and don't be afraid to ask questions on the migration! -Original Message- From: j.urban [mailto:[EMAIL PROTECTED]] Sent: Friday, January 18, 2002 10:08 AM To: Tony Buckley Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Porting from MS SQL to MySQL Porting a DB takes more 'than a couple of hours'. What about the written procedures, the security mappings, the back up and recovery procs, the fallback arrangements, the testing etc. Yes, porting a database that was written for MSSQL with no intention of porting can be a painful proposition. However, if you have control over how the system is developed, you can easily design the system to be compatible with EITHER MSSQL or MySQL (the differeces are well-documented). If you develop your system with porting in mind (ie the original post of they'll develop in SQLServer and port it to MySQL later) porting should not take more than a couple of hours. You simply choose appropriate datatypes and don't use MSSQL-specific extensions... On Fri, 18 Jan 2002, Tony Buckley wrote: - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, January 18, 2002 2:14 PM Subject: Re: Porting from MS SQL to MySQL What about the customer who asks a car company to make the vehicle's tryes out of velvet? Would you go off in a huff if they refused and demand they do it? There are obviously issues here that we are not privy to; there *must* be logic behind the choice of SQLServer. Are they saying that mySQL isn't upto it? Porting a DB takes more 'than a couple of hours'. What about the written procedures, the security mappings, the back up and recovery procs, the fallback arrangements, the testing etc. If you think E18k is a lot then ask for a detailed task plan with effort; find out what they are asking you to pay for. The DB was described as 'fairly complicated' whatever that may mean. Perhaps - and we are all guesing - there are remote data issues, views, stored procs, java and god knows what else that all needs to be integrated. Bottom line when you get a quote is find out what they want to do task by task and then cut it down from there. Tony - 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: Compiling problem: error in type_info1.hh
Guy-Maurice Lepoutre writes: Hello, I have troubles compiling this program: #include iostream.h #include iomanip.h #include c:/sqlplus/sqlplus.hh int main() {return(0);} As you can see, the program itself isn't very complicated. When I run this program (using MS Visual C++), here are the errors I get. Can anybody help me please. I would really appreciate it. You can reply me using my mail adress: [EMAIL PROTECTED] Thanks Please download and use version of MySQL++ ported for VC++ from MySQL++ page. I think it is version 1.7.1. -- 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
Disabling foreign keys
Is there a way to disable foreign keys temporarily? Specifically, I'm running 3.23.47 with InnoDB tables, and I need to periodically dump and reload a table that has foreign key dependencies on it. Thanks, Philip * Philip Molter * Texas.net Internet * http://www.texas.net/ * [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: Porting from MS SQL to MySQL
- Original Message - From: j.urban [EMAIL PROTECTED] To: Tony Buckley [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, January 18, 2002 4:07 PM Subject: Re: Porting from MS SQL to MySQL Porting a DB takes more 'than a couple of hours'. What about the written procedures, the security mappings, the back up and recovery procs, the fallback arrangements, the testing etc. Yes, porting a database that was written for MSSQL with no intention of porting can be a painful proposition. However, if you have control over how the system is developed, you can easily design the system to be compatible with EITHER MSSQL or MySQL (the differeces are well-documented). If you develop your system with porting in mind (ie the original post of they'll develop in SQLServer and port it to MySQL later) porting should not take more than a couple of hours. You simply choose appropriate datatypes and don't use MSSQL-specific extensions... I still don't agree with this. Yes you can ease the passage by considering all the issues up front but it is still not a trivial job for a database of any consequence. There is more to a database than a physical schema - what about all the administration procedures that sit around it, what about tuning the new physical implementation, what about reviewing the access paths and optimisation, what about the redevelopment of data loading scripts. As I have said in another post, it's futile arguing about it because we don't know enough about the technical situation let the business/political one. Are you seriously saying you could sit down in front a reasonably sized DB you had never seen before and understand all the business issues and pick it up and ship to a new RDBMS and platform, rewrite the document, replan what I have stated above, and get it back up and running in two hours? Perhaps I am getting too old and slow but it would take me longer :-) I am not saying it's a huge task to do any of this but whoever said, I could do it in a couple of hours, doesn't understand the background that led to a company quoting E18k; nor do any of us, and for anything other than a very very trivial system, two hours seems inadequate. This is an area that interests me, because I directly bid for work such as this, and when tendering you usually find the bloke down the road working out of his spare bedroom that thinks he can do it for a tenner over one day. The company requesting the work then thinks that everyone else is overinflating their prices so goes cheap and pays for it big time downstream. Cheapest and quickest is rarely best. On the flip side, nor is most expensive. Tricky world init. Tony - 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: Porting from MS SQL to MySQL
- Original Message - From: j.urban [EMAIL PROTECTED] To: Tony Buckley [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, January 18, 2002 4:10 PM Subject: Re: Porting from MS SQL to MySQL Unless they are saying they doubt that mySQL is upto, it so it's no good quoting. They may have a room full of SQLServer people twiddling their thumbs in which case I agree with you, they are not bucking for the customer here. On the other hand they have very real doubts that mySQL is upto the job; they may be wrong on this last point, but at least they are being honest in their beliefs. Who knows! This doesn't make much sense. If they're being honest and they believe MySQL can't handle it, why would they offer to port it to MySQL for 18,000 euro? I don't know. Perhaps they are offering not just to port to mySQL but redesign the bits that they believed made an impractical initial mySQL installation. Perhaps 'impractical' because of time and MSSQL would be faster. Perhaps impractical because the CEO is shagging the marketing manager of MSSQL and didn't want to upset her. We don't know!!! My point is that the originator of the question didn't seem to have a clear idea of what was being offered for E18k but that could be an entirely reasonable bid for the work and application required. Just because it looks like a 'big number' doesn't mean that isn't what it will cost. All of a bit of a futile argument really without knowing a lot more. Tony - 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: Porting from MS SQL to MySQL
I would say it would take a month at least to complete the job correctly. I have seen some top OLAP developers take 3 months to complete a 30gb DB2 to an Essbase migration including all documentation and politics involved. Two hours? You should be fired for just thinking that! Just kidding. The whole project scope of a migration is HUGE! Here would be a vague outline of this type of project: 1. Politics 2. What can mySQL do that MS SQL cannot do? 3. Technical issues 4. Documentation 5. Schemas 6. admin functions 7. training 8. post installation testing 9. pre install testing, Beta 10. load testing 11. get the picture? This is NOT a two hour job! -Original Message- From: Tony Buckley [mailto:[EMAIL PROTECTED]] Sent: Friday, January 18, 2002 10:56 AM To: j.urban Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Porting from MS SQL to MySQL - Original Message - From: j.urban [EMAIL PROTECTED] To: Tony Buckley [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, January 18, 2002 4:07 PM Subject: Re: Porting from MS SQL to MySQL Porting a DB takes more 'than a couple of hours'. What about the written procedures, the security mappings, the back up and recovery procs, the fallback arrangements, the testing etc. Yes, porting a database that was written for MSSQL with no intention of porting can be a painful proposition. However, if you have control over how the system is developed, you can easily design the system to be compatible with EITHER MSSQL or MySQL (the differeces are well-documented). If you develop your system with porting in mind (ie the original post of they'll develop in SQLServer and port it to MySQL later) porting should not take more than a couple of hours. You simply choose appropriate datatypes and don't use MSSQL-specific extensions... I still don't agree with this. Yes you can ease the passage by considering all the issues up front but it is still not a trivial job for a database of any consequence. There is more to a database than a physical schema - what about all the administration procedures that sit around it, what about tuning the new physical implementation, what about reviewing the access paths and optimisation, what about the redevelopment of data loading scripts. As I have said in another post, it's futile arguing about it because we don't know enough about the technical situation let the business/political one. Are you seriously saying you could sit down in front a reasonably sized DB you had never seen before and understand all the business issues and pick it up and ship to a new RDBMS and platform, rewrite the document, replan what I have stated above, and get it back up and running in two hours? Perhaps I am getting too old and slow but it would take me longer :-) I am not saying it's a huge task to do any of this but whoever said, I could do it in a couple of hours, doesn't understand the background that led to a company quoting E18k; nor do any of us, and for anything other than a very very trivial system, two hours seems inadequate. This is an area that interests me, because I directly bid for work such as this, and when tendering you usually find the bloke down the road working out of his spare bedroom that thinks he can do it for a tenner over one day. The company requesting the work then thinks that everyone else is overinflating their prices so goes cheap and pays for it big time downstream. Cheapest and quickest is rarely best. On the flip side, nor is most expensive. Tricky world init. Tony - 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: Porting from MS SQL to MySQL
I wasn't talking about migration of a 30gb DB2 system. I was talking about porting a system that was specifically designed to be ported. If you design it correctly up front, you can port it very painlessly. You can easily develop a system that uses the proper datatypes and does NOT use MSSQL-specific extensions. This type of system can easily be ported. Porting a legacy application that someone else developed is likely to be a duanting task, I agree. But I'm talking about a system that has not been developed and can be designed with porting in mind. I just finished a system that was developed 100% for MySQL. It was ported to work with MSSQL and now works with either. There was exactly ONE column change and the actual porting of the database and the back-end code was 2 hours max. This is because there is almost nothing to do provided you've designed the system with porting in mind... You've seen some OLAP developers take 3 months to complete a migration, and I've seen (at least one) company take over 6 months to convert a Paradox system to MSSQL. Neither example is relevant to the current discussion. An MSSQL system can be designed and developed with porting in mind and porting can be painless. On Fri, 18 Jan 2002, Todd Williamsen wrote: I would say it would take a month at least to complete the job correctly. I have seen some top OLAP developers take 3 months to complete a 30gb DB2 to an Essbase migration including all documentation and politics involved. Two hours? You should be fired for just thinking that! Just kidding. The whole project scope of a migration is HUGE! Here would be a vague outline of this type of project: 1. Politics 2. What can mySQL do that MS SQL cannot do? 3. Technical issues 4. Documentation 5. Schemas 6. admin functions 7. training 8. post installation testing 9. pre install testing, Beta 10. load testing 11. get the picture? This is NOT a two hour job! -Original Message- From: Tony Buckley [mailto:[EMAIL PROTECTED]] Sent: Friday, January 18, 2002 10:56 AM To: j.urban Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Porting from MS SQL to MySQL - Original Message - From: j.urban [EMAIL PROTECTED] To: Tony Buckley [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, January 18, 2002 4:07 PM Subject: Re: Porting from MS SQL to MySQL Porting a DB takes more 'than a couple of hours'. What about the written procedures, the security mappings, the back up and recovery procs, the fallback arrangements, the testing etc. Yes, porting a database that was written for MSSQL with no intention of porting can be a painful proposition. However, if you have control over how the system is developed, you can easily design the system to be compatible with EITHER MSSQL or MySQL (the differeces are well-documented). If you develop your system with porting in mind (ie the original post of they'll develop in SQLServer and port it to MySQL later) porting should not take more than a couple of hours. You simply choose appropriate datatypes and don't use MSSQL-specific extensions... I still don't agree with this. Yes you can ease the passage by considering all the issues up front but it is still not a trivial job for a database of any consequence. There is more to a database than a physical schema - what about all the administration procedures that sit around it, what about tuning the new physical implementation, what about reviewing the access paths and optimisation, what about the redevelopment of data loading scripts. As I have said in another post, it's futile arguing about it because we don't know enough about the technical situation let the business/political one. Are you seriously saying you could sit down in front a reasonably sized DB you had never seen before and understand all the business issues and pick it up and ship to a new RDBMS and platform, rewrite the document, replan what I have stated above, and get it back up and running in two hours? Perhaps I am getting too old and slow but it would take me longer :-) I am not saying it's a huge task to do any of this but whoever said, I could do it in a couple of hours, doesn't understand the background that led to a company quoting E18k; nor do any of us, and for anything other than a very very trivial system, two hours seems inadequate. This is an area that interests me, because I directly bid for work such as this, and when tendering you usually find the bloke down the road working out of his spare bedroom that thinks he can do it for a tenner over one day. The company requesting the work then thinks that everyone else is overinflating their prices so goes cheap and pays for it big time downstream. Cheapest and quickest is rarely best. On the flip side, nor is most expensive. Tricky world init. Tony
Re: Porting from MS SQL to MySQL
Are you seriously saying you could sit down in front a reasonably sized DB you had never seen before and understand all the business issues and pick it up and ship to a new RDBMS and platform, rewrite the document, replan what I Absolutely not. I am saying that if I am tasked with developing a NEW database of any size (10 tables or 100 tables or more) and you tell me UP FRONT, we'd like to be able to port this MSSQL database to MySQL the system can be designed to make the port very painless. I am not saying it's a huge task to do any of this but whoever said, I could do it in a couple of hours, doesn't understand the background that led to a company quoting E18k; nor do any of us, and for anything other than a very very trivial system, two hours seems inadequate. You're correct, I don't understand the background that led to a company quoting 18,000 euro -- that's what we're trying to figure out. On Fri, 18 Jan 2002, Tony Buckley wrote: I still don't agree with this. Yes you can ease the passage by considering all the issues up front but it is still not a trivial job for a database of any consequence. There is more to a database than a physical schema - what about all the administration procedures that sit around it, what about tuning the new physical implementation, what about reviewing the access paths and optimisation, what about the redevelopment of data loading scripts. As I have said in another post, it's futile arguing about it because we don't know enough about the technical situation let the business/political one. Are you seriously saying you could sit down in front a reasonably sized DB you had never seen before and understand all the business issues and pick it up and ship to a new RDBMS and platform, rewrite the document, replan what I have stated above, and get it back up and running in two hours? Perhaps I am getting too old and slow but it would take me longer :-) I am not saying it's a huge task to do any of this but whoever said, I could do it in a couple of hours, doesn't understand the background that led to a company quoting E18k; nor do any of us, and for anything other than a very very trivial system, two hours seems inadequate. This is an area that interests me, because I directly bid for work such as this, and when tendering you usually find the bloke down the road working out of his spare bedroom that thinks he can do it for a tenner over one day. The company requesting the work then thinks that everyone else is overinflating their prices so goes cheap and pays for it big time downstream. Cheapest and quickest is rarely best. On the flip side, nor is most expensive. Tricky world init. Tony - 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: Tergat MySQL Studio
So basically, if you already own Mascon (or buy it from http://www.scibit.com/ for $49.00), and download the latest installable binary releases of MySQL, Apache, etc, you've got the MySQL Studio, and as a bonus, it features a clean, standard UI, with the standard Windows style widgets. Ah, this is good to know. I wasn't interested in the binary installers or the Apache/MySQL since I build those myself. But I keep hoping for an enterprise level tool that works with MySQL. ER Studio and other packages really simplify my life with SQL Server, so I am greedy and want the same kind of design and management tools for MySQL :) c -- Chris Lott http://www.chrislott.org/ - 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: Disabling foreign keys
Philip, DROP TABLE always succeeds even if you would have child rows referring to it. Thus the way is dump + DROP + CREATE + import Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB Philip Molter wrote in message ... Is there a way to disable foreign keys temporarily? Specifically, I'm running 3.23.47 with InnoDB tables, and I need to periodically dump and reload a table that has foreign key dependencies on it. Thanks, Philip * Philip Molter * Texas.net Internet * http://www.texas.net/ * [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: Innodb funny error
I've had a similar error when creating innodb tables, using a 4.0.1 client, and a .47 server, if I loaded my create statement from a text file, the innodb table wouldn't create. Change the type to myisam and it worked fine. If I wound up creating it line by line, it worked fine. This might go along with what you're looking at. On Thursday 17 January 2002 02:50 pm, you wrote: Hi Heikki, Thought you might want to hear this one, I was trying to mysqldump our support database (all tables innodb) WHen I got the following error: bash-2.04$ mysqldump --opt -uken -p supportdb terms supportdb.dump Enter password: mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table 'terms' at row: 0 The server did not restart, all other tables would dump fine, but terms would not. I then altered the table type to myisam: alter table terms type=myisam --- then back to innodb alter table terms type=innodb And then the dump proceeded with no error! Are you aware of any problems like this? If it happens again would you like any other info? Ken P.S. Here is version info (running FreeBSD 4.4-stable) this is our internal test server bash-2.04$ mysqladmin -uken -p ver Enter password: mysqladmin Ver 8.23 Distrib 4.0.1-alpha, for unknown-freebsdelf4.4 on i386 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 4.0.1-alpha-debug-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 19 hours 48 min 33 sec Threads: 34 Questions: 161144 Slow queries: 5 Opens: 719 Flush tables: 1 Open tables: 522 Queries per second avg: 2.260 bash-2.04$ - Ken Menzel ICQ# 9325188 www.icarz.com [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Jayce^ - 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
record navigation on a webpage
hi list! I have been working with mysql and php for sometime now and I have this problem: I query the server for records and I know the result is more than a thousand records. How do I seperate them so I can display a fixed number per page and allow record navigation on my website? I hope there is some way out of this. Thanks for reading. ___ Join the Space Program: Get FREE E-mail at http://www.space.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
Version 4 Schedule
Hello Steve, Friday, January 18, 2002, 5:33:38 PM, you wrote: SS REALFROM: Steve Suehring [EMAIL PROTECTED] SS HOUR: 2002011817 SS Hello- SS I've done some searching through archive and the website but can't seem to SS find a semi-concrete answer. What's the schedule, if any, for version 4.0 SS to go stable? As Monty recently mentioned: if you mean stable as well tested and suitable for production uses - this is true for almost every MySQL version, even for alpha ones. :-) You can find more about it here: http://www.mysql.com/doc/W/h/Which_version.html http://www.mysql.com/doc/N/u/Nutshell_Ready_for_Immediate_Development_Use.html -- Victoria Reznichenko [EMAIL PROTECTED] MySQL AB / Ensita.net For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / / /|_/ / // /\ \/ /_/ / /__ /_/ /_/\_, /___/\___\_\___/ ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqlbug
Nasser, Friday, January 18, 2002, 12:26:09 PM, you wrote: NR I tried to install MySQL in my linux box (redhat 7.2) by using the rpm NR files. NR Where should the files get after installation. NR In mine the get to /usr/bin and when i use MySQL with som appliction,i get NR error message which includes somethings about could not find NR libmysqlclient.so.6 NR What is wrong here? Installation from MySQL's rpms should go clear. Are you sure you have installed the MySQL distributive correctly (rpm --install..)? Please tell us more about the problem appeared. About /etc/ld.so.conf, and ls /usr/lib/libmysqlclient* -- Egor Egorov [EMAIL PROTECTED] MySQL AB / Ensita.net For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / / /|_/ / // /\ \/ /_/ / /__ /_/ /_/\_, /___/\___\_\___/ ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Memory limit issue with mysql.3.23.41
If you only have 2GB of RAM and you are allocating 5120M (=5GB) for the key_buffer, you have a problem. That should make your system swap like mad and everything slow to a crawl. Also, note that some of these config options may effect per-thread allocation. I don't know which ones off the top of my head, but I think the manual makes it clear. Things to remember: MySQL stores index data in the key_buffer. It does not store data there. MySQL does not cache data. If you tell it to allocate more memory than the system has, you'll use up all memory for the index, allocate swap for it (really slow), and leave no space for the OS to cache data. We usually allocate between 30 and 50% of the available DRAM for the index and leave the remaining things much smaller. This lets the OS do some caching on its own. If you take all the memory for the indexes of MySQL, I am amazed that it was able to run with any speed at all. What it looks like is that you allocated your 2G of memory and then wandered quickly into the weeds. Swap != RAM. Best, Kyle On Friday 18 January 2002 07:37, Franklin, Kevin wrote: [snip] The behavior suggests that we are running out of memory / swap, but we have over 2 gig of memory and 10 gig of swap free. If you hit swap, you hit the wall in performance and go splat. We run PCs with this much RAM. RAM=Performance with MySQL. Even for Sun's RAM is pretty cheap. Our server settings are: key_buffer=5120M Danger Will Robinson! This is larger than your RAM! max_allowed_packet=1M table_cache=1024 sort_buffer=6M This is pretty big and allocated on a thread by thread basis I think. record_buffer=4M This might be allocated on a thread by thread basis too, but I can't remember. Hmm, looks like it is. Do you run absolutely huge queries? Do you really need 10MB _per thread_? thread_cache=12 thread_concurrency=12 You have a lot of processors? If so, you don't have much RAM. myisam_sort_buffer_size=512M This is somewhat high given that you've already use all available RAM for indexes more than twice over. The server tends to crash upon reaching a total memory usage of around 4 GB I am surprised that it responds at all after it uses up RAM and starts to swap. You must have a good disk subsystem. Here is the output from the error log. Of particular interest to us is the negative key_buffer_size quoted. The same value (-4096) appears with each crash. Is there some sort of memory limit imposed on the server or do you have suggestions for debugging this problem? I think that you rolled a 32-bit integer somewhere. Try setting key_buffer to 1G. This could be a bug in MySQL. See below. This might mean that it is a 32-bit executable. mysqld got signal 11; That's not good. Is your ulimit set to 2G for MySQL. Is MySQL actually a 64-bit executable? Perhaps it is a 32-bit executable. key_buffer_size=-4096 This doesn't look good. record_buffer=4190208 sort_buffer=6291448 max_used_connections=308 max_connections=1024 threads_connected=309 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 2093044 K bytes of memory Read this line carefully. I think the server is trying to tell you something. Note that it is really using -4096 as the key_buffer_size in the calculation above. Note that the math seems to be wrong too since you set record_buffer to 4M and sort_buffer to 6M, you should be allocating 10M per thread. That's a lot of RAM for a system with only 2G. Hope that's ok, if not, decrease some variables in the equation I think it has the right idea here. Best, Kyle -- Cut costs, Fax smart. Use iPrint2Fax worldwide and save! - iPrint2Fax software is FREE, no fax modem required. - FREE iPrint2Fax to a single email address. - iPrint2Fax to PSTN based Fax (Up to 95% Savings) - iPrint2Fax Broadcasting: Send 100s of faxes and fax to emails in the time it takes to send just one! == FREE software download available at www.iPrint2Fax.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: Porting from MS SQL to MySQL
You can easily develop a system that uses the proper datatypes and does NOT use MSSQL-specific extensions. This type of system can easily be ported. Yes, and such an application is likely not to be nearly as efficient on the original platform. I can see where this kind of design is useful... if you KNOW you are going to port to MySQL in the future. But in that case, why not design there in the first place? Otherwise, if I am using SQL Server, I am going to take advantage of true foreign keys, stored procedures, and other SQL Server attributes that make for a more easily supported and performance-enhanced system. This is not going to lead to a system that is easy to port :) c -- Chris Lott http://www.chrislott.org/ - 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: Porting from MS SQL to MySQL
original platform. I can see where this kind of design is useful... if you KNOW you are going to port to MySQL in the future. But in that case, why not design there in the first place? I have no idea and I didn't suggest this was a good solution, but the question was posed, so I simply stated that it's possible to develop your MSSQL system with a MySQL port in mind. I agree completely, if you're going to port it anyway, it should simply be developed for MySQL from the beginning. But who knows? As others have stated, there may be a good reason to do this that we don't know about... On Fri, 18 Jan 2002, Chris Lott wrote: You can easily develop a system that uses the proper datatypes and does NOT use MSSQL-specific extensions. This type of system can easily be ported. Yes, and such an application is likely not to be nearly as efficient on the original platform. I can see where this kind of design is useful... if you KNOW you are going to port to MySQL in the future. But in that case, why not design there in the first place? Otherwise, if I am using SQL Server, I am going to take advantage of true foreign keys, stored procedures, and other SQL Server attributes that make for a more easily supported and performance-enhanced system. This is not going to lead to a system that is easy to port :) c -- - 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: record navigation on a webpage
How do I seperate them so I can display a fixed number per page and allow record navigation on my website? Use LIMIT in your database query, keeping track of the offset with a variable. A simple example here (I am sure there are many more out there): http://www.it-development.de/scripts/demoBrowsDB.sphp3 c -- Chris Lott http://www.chrislott.org/ - 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: Memory limit issue with mysql.3.23.41
Kevin, The Mysql documentation suggests you use no more than 75% or 80% of physical memory to allocate for key_buffer. As Heikki and Jeremy confirmed for me this week, sort_buffer and record_buffer are the ones that grow per thread - Heikki suggested 1Mb for each of those. Using swap as RAM (as Kyle suggests) is not a good idea for any process, as it will certainly slow your system. John Kyle Hayes wrote: If you only have 2GB of RAM and you are allocating 5120M (=5GB) for the key_buffer, you have a problem. That should make your system swap like mad and everything slow to a crawl. Also, note that some of these config options may effect per-thread allocation. I don't know which ones off the top of my head, but I think the manual makes it clear. Things to remember: MySQL stores index data in the key_buffer. It does not store data there. MySQL does not cache data. If you tell it to allocate more memory than the system has, you'll use up all memory for the index, allocate swap for it (really slow), and leave no space for the OS to cache data. We usually allocate between 30 and 50% of the available DRAM for the index and leave the remaining things much smaller. This lets the OS do some caching on its own. If you take all the memory for the indexes of MySQL, I am amazed that it was able to run with any speed at all. What it looks like is that you allocated your 2G of memory and then wandered quickly into the weeds. Swap != RAM. Best, Kyle On Friday 18 January 2002 07:37, Franklin, Kevin wrote: [snip] The behavior suggests that we are running out of memory / swap, but we have over 2 gig of memory and 10 gig of swap free. If you hit swap, you hit the wall in performance and go splat. We run PCs with this much RAM. RAM=Performance with MySQL. Even for Sun's RAM is pretty cheap. Our server settings are: key_buffer=5120M Danger Will Robinson! This is larger than your RAM! max_allowed_packet=1M table_cache=1024 sort_buffer=6M This is pretty big and allocated on a thread by thread basis I think. record_buffer=4M This might be allocated on a thread by thread basis too, but I can't remember. Hmm, looks like it is. Do you run absolutely huge queries? Do you really need 10MB _per thread_? thread_cache=12 thread_concurrency=12 You have a lot of processors? If so, you don't have much RAM. myisam_sort_buffer_size=512M This is somewhat high given that you've already use all available RAM for indexes more than twice over. The server tends to crash upon reaching a total memory usage of around 4 GB I am surprised that it responds at all after it uses up RAM and starts to swap. You must have a good disk subsystem. Here is the output from the error log. Of particular interest to us is the negative key_buffer_size quoted. The same value (-4096) appears with each crash. Is there some sort of memory limit imposed on the server or do you have suggestions for debugging this problem? I think that you rolled a 32-bit integer somewhere. Try setting key_buffer to 1G. This could be a bug in MySQL. See below. This might mean that it is a 32-bit executable. mysqld got signal 11; That's not good. Is your ulimit set to 2G for MySQL. Is MySQL actually a 64-bit executable? Perhaps it is a 32-bit executable. key_buffer_size=-4096 This doesn't look good. record_buffer=4190208 sort_buffer=6291448 max_used_connections=308 max_connections=1024 threads_connected=309 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 2093044 K bytes of memory Read this line carefully. I think the server is trying to tell you something. Note that it is really using -4096 as the key_buffer_size in the calculation above. Note that the math seems to be wrong too since you set record_buffer to 4M and sort_buffer to 6M, you should be allocating 10M per thread. That's a lot of RAM for a system with only 2G. Hope that's ok, if not, decrease some variables in the equation I think it has the right idea here. Best, Kyle - 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
ostream, C, C++
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I have a problem compiling an app that uses the MySQL C API. My program itself is C++ using Visual C++ 6.0 in Windows 2000, but the C api is plenty sufficient for me. I suspect the problem comes because when I include C++ streams, I use the ANSI C++ standard way of doing so: #include iostream (and then I import the std namespace) rather than the deprecated way of doing so: #include iostream.h When I include the C api by doing: #include config-win.h #include mysql.h I get a slew of errors. For the life of me, I cannot figure out how to fix them (I must be sleepy and/or hungry). Can someone help me out? I tried searching the mailing lists but I couldn't find anything. Here are my errors, everything else that does not use MySQL compiles just fine: f:\vs6\vc98\include\ostream(106) : error C2535: 'class std::basic_ostream_E,_Tr __thiscall std::basic_ostream_E,_Tr::operator (int)' : member function already defined or declared f:\vs6\vc98\include\ostream(66) : see declaration of '' f:\vs6\vc98\include\ostream(272) : see reference to class template instantiation 'std::basic_ostream_E,_Tr' being compiled f:\vs6\vc98\include\ostream(106) : error C2535: 'class std::basic_ostreamchar,struct std::char_traitschar __thiscall std::basic_ostreamchar,struct std::char_traitschar ::operator (int)' : member function already defined or declared f:\vs6\vc98\include\ostream(66) : see declaration of '' f:\vs6\vc98\include\ostream(373) : see reference to class template instantiation 'std::basic_ostreamchar,struct std::char_traitschar ' being compiled f:\vs6\vc98\include\ostream(106) : error C2535: 'class std::basic_ostreamunsigned short,struct std::char_traitsunsigned short __thiscall std::basic_ostreamunsigned short,struct std::char_traitsunsigned short ::operator (int)' : member fu nction already defined or declared f:\vs6\vc98\include\ostream(66) : see declaration of '' f:\vs6\vc98\include\ostream(379) : see reference to class template instantiation 'std::basic_ostreamunsigned short,struct std::char_traitsunsigned short ' being compiled f:\vs6\vc98\include\istream(103) : error C2535: 'class std::basic_istream_E,_Tr __thiscall std::basic_istream_E,_Tr::operator (int )' : member function already defined or declared f:\vs6\vc98\include\istream(67) : see declaration of '' f:\vs6\vc98\include\istream(423) : see reference to class template instantiation 'std::basic_istream_E,_Tr' being compiled f:\vs6\vc98\include\istream(103) : error C2535: 'class std::basic_istreamchar,struct std::char_traitschar __thiscall std::basic_istreamchar,struct std::char_traitschar ::operator (int )' : member function already defined or declared f:\vs6\vc98\include\istream(67) : see declaration of '' f:\vs6\vc98\include\istream(544) : see reference to class template instantiation 'std::basic_istreamchar,struct std::char_traitschar ' being compiled f:\vs6\vc98\include\istream(103) : error C2535: 'class std::basic_istreamunsigned short,struct std::char_traitsunsigned short __thiscall std::basic_istreamunsigned short,struct std::char_traitsunsigned short ::operator (int )' : member function already defined or declared f:\vs6\vc98\include\istream(67) : see declaration of '' f:\vs6\vc98\include\istream(564) : see reference to class template instantiation 'std::basic_istreamunsigned short,struct std::char_traitsunsigned short ' being compiled -BEGIN PGP SIGNATURE- Version: PGP Personal Security 7.0.3 iQA/AwUBPEhuBgAttZAy2w6WEQJKeQCg7Q0Boc2Fe8GP/sWhqYRNok9bOqUAoLHQ Wd+TBIoG6WffQGGbjJ/WmWX+ =AeiD -END PGP SIGNATURE- - 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: Optimization problem in 3.23.44
Did you get an answer to this problem. I'm experiencing the same behavior. Mike Wexler wrote: When I do EXPLAIN SELECT status.itemKey, status.auctionUrl, status.hideItem, status.auctionId, status.action, status.auctionHouse FROM auction.status, inventory.thisItem WHERE status.itemKey=thisItem.itemKey AND (status.closeDate=NOW() OR (status.closeDate IS NULL AND action=queued)) AND status.action'build' I get +--+++---+-+--+---++ | table| type | possible_keys | key | key_len | ref | rows | Extra | +--+++---+-+--+---++ | thisItem | system | NULL | NULL | NULL | NULL | 1 || | status | range | itemKey,itemKey_2,closeDate,action | closeDate | 9 | NULL | 23417 | where used | +--+++---+-+--+---++ 2 rows in set (0.01 sec) Note that the second table matches 23417 rows. Here is inventory.thisItem: mysql show fields from inventory.thisItem; +-++--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +-++--+-+-+---+ | itemKey | bigint(10) | | | 0 | | +-++--+-+-+---+ and auction.status: mysql show fields from auction.status; +-+-+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +-+-+--+-+-+---+ | action | enum('atTIAS','build','uploaded','sold','queued','unknown') | | MUL | atTIAS | | | actionDate | timestamp(14) | YES | | NULL| | | auctionHouse| varchar(10) | | | | | | batchNum| int(11) unsigned | | MUL | 0 | | | auctionId | varchar(64) | | MUL | | | | auctionUrl | varchar(255) | YES | | NULL| | | minimumBid | decimal(7,2) | YES | | NULL| | | reserve | decimal(7,2) | YES | | NULL| | | finalBid| decimal(7,2) | YES | | NULL| | | closeDate | datetime | YES | MUL | NULL| | | durationHrs | int(11) | YES | | NULL| | | buyerEmail | varchar(128) | YES | | NULL| | | hideItem| enum('Link','Hide','Ignore','NoAuction') | | | Link| | | buyerName | varchar(64) | YES | | NULL| | | title | varchar(128) | YES | | NULL| | | description | text | YES | | NULL| | | invoiced| enum('no','yes') | | | no | | | uploadKey | varchar(128) | YES | | NULL| | | qty | int(11) | | | 0 | | | uploadFee | decimal(7,2) | YES | | NULL| | | bold| varchar(32) | | | no | | | private | varchar(32) | | | no | | | feature1| varchar(32) | | | no | | | feature2| varchar(32) | | | no | | | feature3| varchar(32) | | | no | | | feature4| varchar(32) | | | no | | | feature5| varchar(32) | | | no | | | feature6| varchar(32) | | | no | | | feature7| varchar(32) | | | no | | | feature8| varchar(32) | | | no | | | imageUrl0 | varchar(255) | YES | | NULL| | | imageUrl1 | varchar(255) | YES | | NULL| | | imageUrl2 | varchar(255) | YES | | NULL| | | imageUrl3 | varchar(255) | YES | | NULL| | | imageUrl4 | varchar(255) | YES | | NULL| | | imageUrl5 | varchar(255) | YES | | NULL| | | imageUrl6 | varchar(255) | YES | | NULL| | | imageUrl7 | varchar(255) | YES | | NULL| | | imageUrl8 | varchar(255) | YES | | NULL| | | takePrice | decimal(7,2) |
host = %
Hi ppl, When I set database and user host to % I can't connect to database when using localhost - authorization fails. When I connect using domain name, every things works fine. Q1: What is the problem using localhost? Q2: How can I set default localhost to domain name? Thank You. Best Regards, Steve - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: host = %
Hi ppl, When I set database and user host to % I can't connect to database when using localhost - authorization fails. When I connect using domain name, every things works fine. Q1: What is the problem using localhost? No problem - just a different type of connection. When you specify localhost, you're also saying accept connections through a socket. When you say % or some derivation thereof, you're telling the server to accept connections through TCP/IP. Q2: How can I set default localhost to domain name? I don't believe you can - not for the server, at any rate. For the client, you can twiddle values in my.cnf to suit your needs. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - 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
Unable to create gc thread
Description: When attempting to run mysqld, it says 'Can't create gc thread'. Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables Fatal error 'Can't create gc thread' at line ? in file /usr/src/lib/libc_r/uthread/uthread_create.c (errno = ?) Abort trap - core dumped Installation of grant tables failed! How-To-Repeat: After the first install, a reboot causes mysqld to not run. It does not run at all anymore, even after a clean install. Fix: None known. Submitter-Id: submitter ID Originator:RobBob Organization: BobFlash.COM MySql Support: none Synopsis: mysqld does not run. Severity: critical Priority: high Category: mysql Class: sw-bug Release: mysql-3.23.47 (FreeBSD port: mysql-server-3.23.47) Environment: System: FreeBSD jinx.bobflash.com 4.5-RC FreeBSD 4.5-RC #1: Fri Jan 18 13:41:49 EST 2002 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/JINX i386 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Using builtin specs. gcc version 2.95.3 20010315 (release) [FreeBSD] Compilation info: CC='cc' CFLAGS='-O -pipe ' CXX='cc' CXXFLAGS='-O -pipe -felide-constructors -fno-rtti -fno-exceptions' LDFLAGS='' LIBC: -r--r--r-- 1 root wheel 1208074 Jan 18 13:28 /usr/lib/libc.a lrwxr-xr-x 1 root wheel 9 Jan 18 13:28 /usr/lib/libc.so - libc.so.4 -r--r--r-- 1 root wheel 573760 Jan 9 00:47 /usr/lib/libc.so.4 Configure command: ./configure --localstatedir=/var/db/mysql --without-perl --without-debug --without-readline --without-bench --with-mit-threads=no --with-libwrap --with-low-memory '--with-comment=FreeBSD port: mysql-server-3.23.47' --enable-assembler --with-berkeley-db --with-innodb --prefix=/usr/local i386--freebsd4.5 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
Full Text Search with and without index - possible bug?
Hi. I thought it would be useful to share my findings. They all relate to the 4.0.1 release. It would be nice to have some clarification on whether this is expected behaviour, whether this behaviour is wrong (i.e. bug, corrupted index, etc), and what you guys think could be causing it. 1.1) Full Text Search can, according to the manual, be performed without the FTS index, but it is slower. 1.2) MySQL can only use 1 index per join per table. = This means that if I specify the USE INDEX (some_non_fulltext_index), the FTS will be performed without the index, and this will only work IN BOOLEAN MODE. Otherwise, MySQL returns an error, complaining about the lack of an index. HOWEVER, please someone explain why the following results are happening: Two nearly identical queries, similar to: SELECT Table1.ID, Table1.Title, Table1.Type, Table1.Description, DATE_FORMAT(Retrieved, '%d-%b-%Y %H:%i:%S') AS Retrieved FROMTable1 WHERE Type = 'SomeType' AND Retrieved '2002011800' MATCH (Title, Description) AGAINST ('some words to match' IN BOOLEAN MODE) ORDER BY MATCH (Title, Description) AGAINST ('some words to match' IN BOOLEAN MODE) DESC; and SELECT Table1.ID, Table1.Title, Table1.Type, Table1.Description, DATE_FORMAT(Retrieved, '%d-%b-%Y %H:%i:%S') AS Retrieved FROMTable1 USE INDEX (Table1_Retrieved_Index) WHERE Type = 'SomeType' AND Retrieved '2002011800' MATCH (Title, Description) AGAINST ('some words to match' IN BOOLEAN MODE) ORDER BY Retrieved DESC; These two queries return DIFFERENT numbers of records! If my understanding of the documentation is correct, the second example should be slower because the FTS index isn't used. But the results should be the same right? Well, that definitely isn't the case in my database. I have just done a REPAIR TABLE Table1, Table2... EXTENDED, so the tables definitely aren't corrupted. The FTS index search returns 24 records on my data set (~ 60K records), and the non-fts search returns 7 records. The reason I have been even trying this is because FTS is a bit slow for some of the things I am doing. By limiting the data set through the Retrieved date field, I can usually cut the data down to about 10% of the total size, hoping that non-indexed FTS on that will be faster. Well, it turned out to be faster for cases where the data set was cut down a lot by the index, but the IN BOOLEAN MODE FTS doesn't seem to be reacting to things like '-word' in the MATCH/AGAINST clause, as it should per the FTS search. Sometimes, specifying a '-word' that should only remove a few results returns 0 rows - which is clearly wrong in some cases. Is there a know bug in the indexless FTS that causes this? The indexed FTS is behaving well, but I was really hoping to gain some speed by using a different index in some specific cases... Regards. Gordan - 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: Tergat MySQL Studio
Unfortunately Mascon doesn't have any ER diagramming tools for schema modeling. I bought Heraut Solutions' Dezign for Databases for this purpose a while back, but its somewhat clunky, unprofessional look/feel has been a bit of a turn off. I've enjoyed using Sybase' Powerdesigner for this purpose, it works pretty well. I only wish it supported MySQL in a more integrated, native fashion. I haven't had the pleasure of using Erwin, but I understand it's a good tool. Any other recommendations for ER modeling? -Original Message- From: Chris Lott [mailto:[EMAIL PROTECTED]] Sent: Friday, January 18, 2002 12:39 PM To: MySQL List (E-mail) Subject: RE: Tergat MySQL Studio So basically, if you already own Mascon (or buy it from http://www.scibit.com/ for $49.00), and download the latest installable binary releases of MySQL, Apache, etc, you've got the MySQL Studio, and as a bonus, it features a clean, standard UI, with the standard Windows style widgets. Ah, this is good to know. I wasn't interested in the binary installers or the Apache/MySQL since I build those myself. But I keep hoping for an enterprise level tool that works with MySQL. ER Studio and other packages really simplify my life with SQL Server, so I am greedy and want the same kind of design and management tools for MySQL :) c -- Chris Lott http://www.chrislott.org/ - 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 Upgrading
I had 3.23.41 installed. It came with Rh7.2. I had some mistakes in initial start up . So I thought i would reinstall it. I downloaded the rpm for 3.23.47. And ran the rpm installation. I am not sure if it did the whole install. Now I have a safe_mysqld and 2 other mysqld process runinng. But I can't start using mysql. If i try to uninstall it says package is not install. And if i try to install it says it is already installed. I am not sure whats wrong here. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Full Text Search with and without index - possible bug?
Hi! On Jan 18, Gordan Bobic wrote: Hi. I thought it would be useful to share my findings. They all relate to the 4.0.1 release. It would be nice to have some clarification on whether this is expected behaviour, whether this behaviour is wrong (i.e. bug, corrupted index, etc), and what you guys think could be causing it. 1.1) Full Text Search can, according to the manual, be performed without the FTS index, but it is slower. 1.2) MySQL can only use 1 index per join per table. = This means that if I specify the USE INDEX (some_non_fulltext_index), the FTS will be performed without the index, and this will only work IN BOOLEAN MODE. Otherwise, MySQL returns an error, complaining about the lack of an index. Gordan, you're right. It's the way it was expected to behave :-) It's not a known bug as the code is rather new. Can you create a test case for this ? 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
2cpu vs 4cpu / use of many cpus
--j2AXaZ4YhVcLc+PQ Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable We use mysql heavily in production with tables over 30GB. We are going to purchase a new db server soon and the decision to be made now is whether we should go with a 4 cpu 700-900MHz system or a 2 cpu 1.4GHz+ system. Most of the time there is only one connection to this large=20 database doing large queries including joins. What I am trying to find=20 out is when (and how well) extra CPUs could speed up SQL operations when=20 there is only one client/connection. In the opinion of those who know,=20 which system would best serve our needs? The four slower processors, or the= =20 two faster processors? Why? Thanks in advance, Chris PS Please cc me responses as I only read this list through the archives. --j2AXaZ4YhVcLc+PQ Content-Type: application/pgp-signature Content-Disposition: inline -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.4 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE8SIkgRHOBDNKYhKERAvsvAJ942f100KcPzWFHcV6NQc4zNN9cyQCgiuPV CoBeRPrJ6Jt2hKNY8UoYxxc= =Pg9R -END PGP SIGNATURE- --j2AXaZ4YhVcLc+PQ--
Re: 2cpu vs 4cpu / use of many cpus
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 At 03:44 PM 1/18/2002 -0500, you wrote: We use mysql heavily in production with tables over 30GB. We are going to purchase a new db server soon and the decision to be made now is whether we should go with a 4 cpu 700-900MHz system or a 2 cpu 1.4GHz+ system. Most of the time there is only one connection to this large database doing large queries including joins. What I am trying to find out is when (and how well) extra CPUs could speed up SQL operations when there is only one client/connection. In the opinion of those who know, which system would best serve our needs? The four slower processors, or the two faster processors? Why? From the user manual: 9.3.1 MySQL Threads The MySQL server creates the following threads: * The TCP/IP connection thread handles all connection requests and creates a new dedicated thread to handle the authentication and and SQL query processing for each connection. * On Windows NT there is a named pipe handler thread that does the same work as the TCP/IP connection thread on named pipe connect requests. * The signal thread handles all signals. This thread also normally handles alarms and calls process_alarm() to force timeouts on connections that have been idle too long. * If mysqld is compiled with -DUSE_ALARM_THREAD, a dedicated thread that handles alarms is created. This is only used on some systems where there are problems with sigwait() or if one wants to use the thr_alarm() code in ones application without a dedicated signal handling thread. * If one uses the --flush_time=# option, a dedicated thread is created to flush all tables at the given interval. * Every connection has its own thread. * Every different table on which one uses INSERT DELAYED gets its own thread. * If you use --master-host, a slave replication thread will be started to read and apply updates from the master. mysqladmin processlist only shows the connection, INSERT DELAYED, and replication threads. As you are looking at having only one connection, I would say it is likely that 2 1.4 Ghz CPUs will give you better results than 4 900 Mhz CPUs, all other things being equal. Also, remember that operating systems don't scale linearly in the best of cases, though Linux scales well up to 4 CPUs. Someone more knowledgable than I will speak up, I'm sure, but I'd focus on dual CPUs with more memory rather than going for a 4 CPU machine. Also, high speed disks would be nice, too. In fact, I'd say more likely you'll see more performance with ONE CPU with more memory and faster drives than you would with a 4 CPU machine limited in RAM and hard drive speed. -BEGIN PGP SIGNATURE- Version: PGP Personal Security 7.0.3 iQA/AwUBPEiLrgAttZAy2w6WEQIYKgCghq00GE1/2TXOguN6FkxacH9gumMAn0Vi eUcuISI6S/W/h0KtvDeAliuy =gmoV -END PGP SIGNATURE- - 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 Upgrading
Islam, Sharif wrote: I had 3.23.41 installed. It came with Rh7.2. I had some mistakes in initial start up . So I thought i would reinstall it. I downloaded the rpm for 3.23.47. And ran the rpm installation. You got the 3.23.47 RPM from MySQL's site, I presume? That RPM is not an upgrade for a RedHat RPM (RedHat packages MySQL differently from the MySQL AB folks - something to do with the Linux file system layout standard). The names are also different - mysql for Redhat vs MySQL for the MySQL image. You'll have to: * rpm -e the Red Hat package (mysql). * Do another rpm -Uvh of the MySQL package to be sure that no common component got blasted. * Set up the /etc/init.d stuff if needed to start mysql at system boot. -- Shankar. - 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 Upgrading
Islam, Sharif wrote: I had 3.23.41 installed. It came with Rh7.2. I had some mistakes in initial start up . So I thought i would reinstall it. I downloaded the rpm for 3.23.47. And ran the rpm installation. You got the 3.23.47 RPM from MySQL's site, I presume? That RPM is not an Yes upgrade for a RedHat RPM (RedHat packages MySQL differently from the MySQL AB folks - something to do with the Linux file system layout standard). The names are also different - mysql for Redhat vs MySQL for the MySQL image. You'll have to: * rpm -e the Red Hat package (mysql). it says mysql not installed. * Do another rpm -Uvh of the MySQL package to be sure that no common component got blasted. It says package MySQL-3.23.47-1 is already installed * Set up the /etc/init.d stuff if needed to start mysql at system boot. - 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
Column Alias Bug??
Is this a bug? I can't find an answer to this question in FAQs or archives. CREATE TABLE aa ( a int); INSERT INTO aa VALUES (1),(2),(3),(2),(4),(5),(1),(6),(3); the following : mysql select a,count(*) as z from aa where z1 group by a; displays this error: ERROR 1054: Unknown column 'z' in 'where clause' Why isn't z recognized as a column identifier? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Column Alias Bug??
Hi, Try : SELECT a,COUNT(*) AS z FROM aa GROUP BY a HAVING z1; Regards, Jocelyn - Original Message - From: Rick Emery [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, January 18, 2002 10:30 PM Subject: Column Alias Bug?? Is this a bug? I can't find an answer to this question in FAQs or archives. CREATE TABLE aa ( a int); INSERT INTO aa VALUES (1),(2),(3),(2),(4),(5),(1),(6),(3); the following : mysql select a,count(*) as z from aa where z1 group by a; displays this error: ERROR 1054: Unknown column 'z' in 'where clause' Why isn't z recognized as a column identifier? - 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
Database locks up on certain queries. Is this intentional ?
Hello, I'm experincing a problem with my database locking up on some queries. Any explanation or solutions anyone can provide will be much appreicated. - ##Scenario: 3 tables: company, co_type_assoc, co_type ##with data pertaining to [co_id in (0,1) as follows] mysql select * from co_type; ++--+--+--+ | co_type_id | co_super_type_id | code | description | ++--+--+--+ | 1 |4 | AC | Associate Consultant | | 2 |4 | AL | Associate Life Member| | 3 |4 | AM | Associate Media | ++--+--+--+ 3 rows in set (0.00 sec) mysql select * from company where co_id = 0; Empty set (0.00 sec) mysql select * from company where co_id = 1; +---+---+---+---+---+-++ | co_id | name1 | name2 | sort_name | email | website | pri_co_type_id | +---+---+---+---+---+-++ | 1 | SHOPA | | | | | 1 | +---+---+---+---+---+-++ 1 row in set (0.00 sec) mysql select * from co_type_assoc where co_id in (0,1); Empty set (0.00 sec) - ##When I run the following query, there is no problem: mysql Select cta.co_type_id , ct.description from company c, co_type_assoc cta, co_type ct where c.co_id = cta.co_id and ct.co_type_id = cta.co_type_id and c.co_id = 1; - ##But if I run this query, the entire database locks up: mysql Select cta.co_type_id , ct.description - from company c, co_type_assoc cta, co_type ct - where c.co_id = cta.co_id - and ct.co_type_id = cta.co_type_id - and c.co_id = 0; ERROR 1015: Can't lock file (errno: -30989) - On examing the queries using EXPLAIN, I get the following: - mysql explain - Select cta.co_type_id , ct.description - from company c, co_type_assoc cta, co_type ct - where c.co_id = cta.co_id - and ct.co_type_id = cta.co_type_id - and c.co_id = 0; +-+ | Comment | +-+ | Impossible WHERE noticed after reading const tables | +-+ - mysql explain - Select cta.co_type_id , ct.description - from company c, co_type_assoc cta, co_type ct - where c.co_id = cta.co_id - and ct.co_type_id = cta.co_type_id - and c.co_id = 1; +---++---+-+-++- -+-+ | table | type | possible_keys | key | key_len | ref| rows | Extra | +---++---+-+-++- -+-+ | c | const | PRIMARY | PRIMARY | 4 | const |1 | | | cta | ref| PRIMARY | PRIMARY | 4 | const |1 | where used; Using index | | ct| eq_ref | PRIMARY | PRIMARY | 1 | cta.co_type_id |1 | | +---++---+-+-++- -+-+ 3 rows in set (0.00 sec) - So my question is 1) Why does the database lock up ? 2) Is this intentional, i.e. the optimizer is smarter than I want. 3) How can I overcome this problem ? Any help anyone can provide will be very much appreciated. Thank you. Kalok - 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-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Max Row Length
is there a max row length for MyISAM tables? I'm having a hard time finding it. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Column Alias Bug??
count(*) works if I do not alias it with z, and do not use WHERE clause: mysql select a,count(*) from aa group by a; +--+--+ | a| count(*) | +--+--+ |1 |2 | |2 |2 | |3 |2 | |4 |1 | |5 |1 | |6 |1 | +--+--+ 6 rows in set (0.40 sec) -Original Message- From: Nathan [mailto:[EMAIL PROTECTED]] Sent: Friday, January 18, 2002 3:34 PM To: Rick Emery Subject: Re: Column Alias Bug?? What does the count(*) do? If that's failing, maybe the alias doesn't get created? Shot in the dark obviously... :-) # Nathan - Original Message - From: Rick Emery [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, January 18, 2002 2:30 PM Subject: Column Alias Bug?? Is this a bug? I can't find an answer to this question in FAQs or archives. CREATE TABLE aa ( a int); INSERT INTO aa VALUES (1),(2),(3),(2),(4),(5),(1),(6),(3); the following : mysql select a,count(*) as z from aa where z1 group by a; displays this error: ERROR 1054: Unknown column 'z' in 'where clause' Why isn't z recognized as a column identifier? - 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