Äú¶©µÄ»õµ½ÁË

mysql£ºÄúºÃ£¡ ¸Û°ÄµçÄÔÍøµÍÓÚÊг¡¼Û50%µÄ¼Û¸ñÏúÊ۱ʼDZ¾µçÄÔ,ÊÖ»ú, ͶӰÒÇ,ÊýÂëÉãÏñ»ú,ÊýÂëÏà»ú, ɨÃèÒÇ,·þÎñÆ÷,´òÓ¡»ú,µçÄÔÅä¼þCPU,Ö÷°å,ÄÚ´æ,Ó²ÅÌ,¹âÇý,DVD,¿Ì¼»ú,ÈíÇý,ÏÔ¿¨,Éù¿¨,»úÏä,ÏÔʾÆ÷,µçÔ´,ÍâÖô洢É豸,½ú,̨ʽ»ú,Ó²Å̺Ð,Ä«ºÐ,Îø¹Ä,¼¯ÏßÆ÷,ÉãÏñÍ·, ÊýÂë¼·Å»ú,¹âÅÌƬµÈϵÁвúÆ·; IBM±Ê¼Ç±¾R32GEC/7000

Need Help!!!

Hi to All, I've been a member of this mailing list for quite a long time and very thankful that most of my difficulty in creating queries are being answered by just reading responses to questions. Right now I have a problem in creating a query (in fact I'm not sure if this is possible) that will

mysql.sock is missing

Hi, I'm staring mysql with mysql -u root mysql but I'm geting this error message: "Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'. I cannot find Mysql.sock anywhere, but I was running mysql before reboot the linux sytem. What can I do to recover/reinstall/run the m

Re: copying innodb data

Hello Scott Pippin A small mistake on myside. Everything worked fine. Thanks for the suggestions. regards KayambooSuresh - Original Message - From: "Scott Pippin" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Saturday, January 25, 2003 5:54 AM Subject: Re:

Re: copying innodb data

Hello Pippin I installed MySQLFront and can connect to my remote LinuxBox DB server. But I cant connect to my local machine with MySQLFront. My LinuxBOX server is listening to port 3316. My WinNTBOX server is listening to port 3306 But using PhpMyAdmin I can connect to both the servers fro

Will MYSQL scale to 100 million+ records for an online content exchangebased on something like oscommerce?

Hello! I very much appreciate the threads on similar topics, and I apologize if this seems redundant. Suppose I am using something like oscommerce.com for an online stock photography site. I have bugun modifying oscommerce for such a purpose at http://vvgallery.org . Does anyone have any feelin

Server Down - Need Help

Hello all: I have a production server that is currently down and am looking for help. WIN2k Server, mysql 3.23 The background is this - I was creating an index, and someone decided to reboot the system. When the system came back up, mysql would not start. When we looked at the service, it

Lack of DBD support for mysql in Windows XP?

I tried in vain to get DBD::mysql installed on a Windows XP machine running mysql. I used ppm to download DBD, and DBD::mysql and DBD-mysql, etc. and got the following errors. 'Error installing package 'DBD' : Could not locate a PPD file for package DBD. I know this is really a PERL problem, bu

Weird Problem.

Ok, I have a program I am working on, there is probably just something I don't understand about the behaviour of the C API and not a bug with MySQL's C api. I have an app that listens on a specified TCP port, once a user connects and successfully authenticates, two more processes are spawned (le

RE: Is there anything like Query Analyser for MySQl

You're right. Perhaps it had something to do with the massive worm attack yesterday. It was erroring out with a file not found when I tried last night, but today it worked. -- Loren McDonald [EMAIL PROTECTED] -- Loren McDonald Gods Of Music Reviewer/Editor [EMAIL PROTECTED] http://www.GodsOfMu

LWE - Dinner with Richard Stallman

I wanted to thank Monty, Dave Axmart and the MYSQL team for coming to support the NYLXS - Free Software Institute in NYC this past week after LWE!! Monty - Your the greatest... but we all knew that Ruben -- __ Brooklyn Linux Solutions ___

Re: How to speed things up in MySQL ?

Steven Roussey wrote: > > I guess the reason for this is that the I have a some blob fields > whitch are > > all used.. (each record consist of approx 600 KB...) > > There it is. MySQL's MyISAM will get the whole record even if it only > needs a part. You can try InnoDB as it does it differently.

RE: Is there anything like Query Analyser for MySQl

Have a look at urSQL -- http://www.urbanresearch.com/ursql > --- Scott Lewis <[EMAIL PROTECTED]> wrote: > I was wondering, is there a program simialar to MS > SQL server - Query > Analyser, where you can write sql queries to query > MySQl databases? ---

Problem connecting to DB

Zdravo mysql, Hi I have problem connectong to DB MySQL Attempting to attach to database... The database has failed to connect because you do not have permission to connect to the server. Please go back to the last step and ensure that you have entered all your login details correctly. I did a

Problems downloading myodbc

Dear Sir or Madam, I have been having problems downloading myodbc from your website. I went to web page http://www.mysql.com/downloads/api-myodbc-2.50.html. I then selected the option "MyODBC 2.50.39NT/2000/XP full setup (1.5M)Download" As a result of a number of attempts one of two things hap

Re: problem

On Sun, 2003-01-26 at 15:58, Beogradjanin wrote: > Zdravo mysql, > > I tried to install MySQL mysql-3.23.55-win on WinXp Platform. I did > installed it but I can't start MySQL...??? > Can You Help me??? What happens when you try Startup->AdminTools->Services->mysql->start? -- __

Strange behaviuor in ver. 4.1(maybe dusty)

Hi, Something very strange was happened on my production server where i have mounted MySQL ver. 4.1 (latest pull on Jan 25, 12:00 GMT) Unfortunatelly i'm not able(a...i didn't start with --log) to reproduce the exact sequence of queries which was send to the server. MySQL was "down" on this que

RE: MySQl and webpages

www.php.net --> links www.google.com --> search for tutorials mysql php --B. -Oorspronkelijk bericht- Van: Doug Thompson [mailto:[EMAIL PROTECTED]] Verzonden: zondag 26 januari 2003 16:39 Aan: [EMAIL PROTECTED]; Scott Lewis Onderwerp: Re: MySQl and webpages For decent explanations of

RE: Is there anything like Query Analyser for MySQl

I've just downloaded it and it works for me. Thanks, Barry G. Sumpter -Original Message- From: Loren McDonald [mailto:[EMAIL PROTECTED]] Sent: Monday, 27 January 2003 7:26 AM To: 'Karam Chand'; 'Scott Lewis'; [EMAIL PROTECTED] Subject: RE: Is there anything like Query An

Re: How to speed things up in MySQL ?

> I guess the reason for this is that the I have a some blob fields whitch are > all used.. (each record consist of approx 600 KB...) There it is. MySQL's MyISAM will get the whole record even if it only needs a part. You can try InnoDB as it does it differently. [At some point I may try and add

RE: Is there anything like Query Analyser for MySQl

That seems to be a dead download link. -- Loren McDonald Gods Of Music Reviewer/Editor [EMAIL PROTECTED] http://www.GodsOfMusic.com > -Original Message- > From: Karam Chand [mailto:[EMAIL PROTECTED]] > Sent: Sunday, January 26, 2003 11:42 AM > To: Scott Lewis; [EMAIL PROTECTED] > Subje

Make fails when compiling 4.0.9 on Mac OS X 10.2.3

Hello: I've recently upgraded my OS to Jaguar. I tried to compile the latest MySQL (4.0.9). However, make fails because it can't find dlfcn.h . I'm certain this is NOT present in Jaguar (OS 10.2.4) even with the latest developer tools installed. I think from the responses on the Apple discussi

problem

Zdravo mysql, I tried to install MySQL mysql-3.23.55-win on WinXp Platform. I did installed it but I can't start MySQL...??? Can You Help me??? +++Info About this E-mail+ +Poruka je napisana u 11:57:54 + +Dana Sunday, January 26, 2003 + +Files in this E-mail massage

[50 character or so descriptive subject here (for reference)]

>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator:Yuriy Povhanich >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category: mysql >Class: >Rel

Re: How to speed things up in MySQL ?

Sergei Golubchik <[EMAIL PROTECTED]> wrote: > > Because MyISAM always reads the record as a whole, it cannot read only > selected fields. > > You can convert your table to InnoDB table type - as InnoDB *can* read > only selected fields. > > Actually, it's useful optimization to store big, rarely se

Fw: How to speed things up in MySQL ?

> [...] > > Why does MySQL needs to scan the Entire Table (all 200 MB) when I only have > > selected ID & ProductionYear in the SELECT statement ?? > > Because you have a table with variable-width records and there is no > way to easily find out where a field of a record is stored without > reading

Re: Segmentation fault when scanning mysqld port

Hello, yep, this one fixed it: ftp://ftp.suse.com/pub/suse/i386/update/8.1/rpm/i586/glibc-2.2.5-161.i586.rpm mysql - gotta love that filter -- Manuel Kiessling - Before posting, please check: http://www.mysql.com/manua

Re: Is there anything like Query Analyser for MySQl

Hey Try SQLyog at http://www.webyog.com/sqlyog Similar interface like MS Query Analyzer and extremely fast. Karam --- Scott Lewis <[EMAIL PROTECTED]> wrote: > I was wondering, is there a program simialar to MS > SQL server - Query > Analyser, where you can write sql queries to query > MySQl data

Re: How to speed things up in MySQL ?

Hi! > I guess the reason for this is that the I have a some blob fields whitch are > all used.. (each record consist of approx 600 KB...) Yes, it's the reason. 600K per record... > But since I donesn't include any of the blob fields in the SELECT statement > I can't see no reason why MySQL shou

Using LIMIT in simple query gives error

Hi, I have a simple query utilizing LIMIT: SELECT * FROM quotes ORDER BY RAND() LIMIT 1; I've actually had this query on a page for a while now, but all of a sudden ALL my queries with LIMIT in them give this error: "You have an error in your SQL syntax near 'LIMIT -1' at line 1" I don't kn

Re: MySQl and webpages

For decent explanations of concepts and practicalities, try http://www.webmasterbase.com/subcats/53 and more specifically http://www.webmasterbase.com/article/228 There are also good and more advanced tutorials at http://www.onlamp.com/ http://www.devshed.com/ These are superficial scratches on

Re: Is there anything like Query Analyser for MySQl

Scott, > I was wondering, is there a program simialar to MS SQL server - Query > Analyser, where you can write sql queries to query MySQl databases? It's called EXPLAIN. More info: http://www.mysql.com/doc/en/EXPLAIN.html Regards, -- Stefan Hinz <[EMAIL PROTECTED]> Geschäftsführer / CEO iCon

Re: How to speed things up in MySQL ?

Hi. On Sun 2003-01-26 at 15:22:06 +0100, [EMAIL PROTECTED] wrote: > Benjamin Pflugmann" <[EMAIL PROTECTED]> wrote: [...] > Why does MySQL needs to scan the Entire Table (all 200 MB) when I only have > selected ID & ProductionYear in the SELECT statement ?? Because you have a table with variable-w

Red Hat 8.0 problems installing from source

I am installing MySQL 4.0.9 on a server running Red Hat 8.0 but am running into some showstoppers. I seem to have success compiling - no warnings are raised - but mysql_install_db will crash when installing the grant tables. Initially I thought it may have been the hardware configuration (I have

Re: How to speed things up in MySQL ?

Benjamin Pflugmann" <[EMAIL PROTECTED]> wrote: > Hi. > Hi Benjamin :-) > On Sun 2003-01-26 at 00:26:32 +0100, [EMAIL PROTECTED] wrote: > > Here is the table definition as requested. > > > > I'm sorry I could take a full dump... Each record consist of approx 600 KB > > (just as in the Paradox tabl

Re: How to speed things up in MySQL ?

Zak Greant wrote: > I am coming in a bit late on this - however, did you send in a copy of > the table structure? > > It sounds like you don't have indexes on the tables. > > --zak > > On Sun, Jan 26, 2003 at 12:59:31AM +0100, Thomas Kvamme wrote: > > Hi again, > > > > Just did another test which

Needed: Working VB6 example of DAO DSN LESS connection using MyODBC to MySQL preferably with passthruquery

Thanks, Barry G. Sumpter Proud Tritoneer President - Triton Woodworkers Club Holmesglen THE TRITONEER Woodworking Australia Bulletin Board Triton Owners and Users Forum Holmesglen Short/DIY Courses

Re: Segmentation fault when scanning mysqld port

Manuel, > > And again, this looks like the "SuSE bug" to me. > that's good news, at least now i know it's not just me. > Anyone has a good tutorial about updating glibc? :-) If you're lucky, you might be able to use this RPM: ftp://ftp.suse.com/pub/suse/i386/update/8.1/rpm/i586/glibc-2.2.5-161.

RE: Cannot connect from WInXp > MYSQL server - help

I've been having the same problem with WinXP to MySQL running under a totally "up2date-ed" Red Hat 8 installation. What I did was to modify my /etc/my.cnf to look like: [mysqld] datadir=/raid/mysql socket=/raid/mysql/mysql.sock set-variable=max_allowed_packet=10M

Re: GPL online backup for innodb tables

Salvatore, - Original Message - From: "Salvatore Enrico Indiogine" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Saturday, January 25, 2003 6:22 AM Subject: GPL online backup for innodb tables > Greetings! > > I would like to know whether in MySQL I can do an online (hot)

MySQl and webpages

As you can tell - very new to Mysql. I was wondering, has anyone some links to howto or even better examples of databases and webpages that I can install, and see the web interaction with webpages and a mysql database. Looking at going down that road as exaaples would help. Scott --

Is there anything like Query Analyser for MySQl

I was wondering, is there a program simialar to MS SQL server - Query Analyser, where you can write sql queries to query MySQl databases? Scott - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: Segmentation fault when scanning mysqld port

Hi, found some advise here (in german): http://groups.google.de/groups?q=suse+glibc+mysql&hl=de&lr=&ie=UTF-8&oe=UTF-8&selm=apkaeo%242cspr%242%40ID-121729.news.dfncis.de&rnum=3 -- Manuel Kiessling - Before posting, please chec

Backing up mysql databases

Whats the best way to backup the mysql databses. I was thinking along the lines of adding something to my crons cript that will backup all the databases, permissions etc and copy then to an external hard drive, which I do at the moment for other files Can anyone advise? Scott www.toptravelsites.

Re: Segmentation fault when scanning mysqld port

Manuel, Benjamin, > > /usr/local/mysql/3.23.55/bin/safe_mysqld: line 280: 1757 Segmentation > > fault And again, this looks like the "SuSE bug" to me. Here's my posting about an error like this on Red Hat: > Synopsis: Server crashes on remote connection I'm not a Unix guru but I experien

Re: Cannot connect from WInXp > MYSQL server - help - cont.

I ahve upgraded to gcc v 3.2.7:- Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.2/specs Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking --host=i386-redha t-linux --with-system-zlib --e

Re: error with 4.0.9 "c" API or user

In the last episode (Jan 25), sam said: > I am getting the following message when submitting the following: > > [sam@linux sam]$ make > > gcc -o listener main.o common.o -L/usr/lib/mysql -lmysqlclient -lm > /usr/lib/mysql/libmysqlclient.a(my_compress.o): > In function `my_uncompre

Re: Slave on same machine?

- Original Message - From: "Paul DuBois" <[EMAIL PROTECTED]> To: "Mark" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, January 26, 2003 4:29 AM Subject: Re: Slave on same machine? > At 5:07 +0100 1/25/03, Mark wrote: > >Hi, > > > >I know, it sounds a bit like a stupid question, bu

Re: How to speed things up in MySQL ?

Hi. On Sun 2003-01-26 at 00:26:32 +0100, [EMAIL PROTECTED] wrote: > Here is the table definition as requested. > > I'm sorry I could take a full dump... Each record consist of approx 600 KB > (just as in the Paradox table) so the file would be very big. (200 MB). Well, you should have told us th

RE: weird comparison problem

>From the manual: 6.3.2.2 Case-Sensitivity BINARY The BINARY operator casts the string following it to a binary string. This is an easy way to force a column comparison to be case-sensitive even if the column isn't defined as BINARY or BLOB: mysql> SELECT "a" = "A"; -> 1 mysql> SELECT B

RE: How to speed things up in MySQL ?

Just to toss something into the fray: I had a similar problem, where any query was taking a very long time to run. I never did discover what the problem was but suddenly, one day later the problem was gone. I had rebooted my server twice in the mean time with no resolve. There is quite a bit r

RE: Need nulls in my join

Seeing a little more data on your situation does change things quite a bit. It sounds like you are also needing to use a SELECT DISTINCT of specific criteria, so that you avoid pulling the same thing more than once. What those criteria are, naturally depends on what the various possibilities are

想住便宜的酒店吗？

×ð¾´µÄmysql:ÄúºÃ! ÎÒÃÇÏòÄúÌṩÀ¥Ã÷µØÇø¾ÆµêÔ¤¶©·þÎñ£¬¼Û¸ñµÍµÃÁîÈËÄÑÒÔÖÃÐÅ£¡ ÎåÐǼ¶¾Æµê280Ôª£¬ËÄÐǼ¶¾Æµê180Ôª£¬3ÐǼ¶¾Æµê140Ôª¡­¡­ Ïêϸ×ÊÁÏÇëÀ´µçÀ´ÓÊË÷È¡¡£ ·þÎñÈÈÏߣº0871-3562788 ·þÎñ´«Õ棺0871-3570448 E-mail: [EMAIL PROTECTED] Ö Àñ! KMCTRIP ¡¡

RE: How to speed things up in MySQL ?

Thomas, Just a thought: In your Delphi/cgi script, how do you define/call the database-server? Meaning, do you use the IP address, localhost, a domain name, a server name etc.? Can it be that it's not the query but the time to establish a connection or resolve the name that is so long? I've seen t