RE: [PHP] Performance [Slightly OT]

Hi Markus, I've only seen the last couple messages from this thread, but to my knowledge PHP doesn't close the MySQL connection at the end of each block. It will close the connection automatically once the entire PHP script has finished processing, though, if you haven't. I prefer not to interm

RE: running MySQL on WinXP

Sounds like you need to add permission to connect from localhost. You might want to check out: http://www.mysql.com/doc/S/e/Secure_GRANT.html or you might need to use the "-u root" option to mysql > -Original Message- > From: Curt Kliewer [mailto:[EMAIL PROTECTED]] > Sent: Sunday, Decem

RE: Question

Hi, http://www.mysql.com/doc/m/y/mysqladmin.html and http://www.mysql.com/doc/C/o/Connecting.html are a good start. If SSHing into a Unix box, you can also use "man mysqladmin" and "man mysql", and "man mysqldump" for more info. -Joe > -Original Message- > From: Scott Johnson [mail

RE: Hacked Servers

Hi there, I feel for you. Been there myself before I installed a firewall router. (Very useful, BTW, to restrict access to only your customers IPs instead of the whole world.) There isn't really enough info provided here to know for sure, but it might be that when you were hacked, your inetd.co

RE: problems loading a datafile into a database table

Hi Roger, You might just need to set File_priv='Y' in the "user" table in the "mysql" database for the user that you logged into MySQL as. Don't forget to do a "flush privileges;" after you make the change so that it takes affect. -Joe > -Original Message- > From: Greenlaw, Roger [mail

Any suggestions on how to improve this SELECT query?

Hi there, I'm wondering if someone can help me figure out how the following SELECT can be improved. SELECT count(*) FROM mm_ind_intrst mm0 STRAIGHT_JOIN ind STRAIGHT_JOIN mm_ind_intrst mm1 WHERE ind.cust=8 AND ind.mail_list=1 AND ( (mm0.intrst='148' AND mm

RE: Load data infile

Hi, your test.csv file has some flaws in records 5 and 7 because the OPTIONALLY ENCLOSED BY char=" isn't matched for each column. Changing those offending CSV lines to be instead something like: > "Record 5","\"some\"data\"","Fails" > "Record 7","some data\"","Fails" and then modifying your LO

RE: Help On Load Data File

Hi Calvin, Check out http://www.mysql.com/doc/L/O/LOAD_DATA.html and search for "Warnings". A paragraph probably of particular interest to you is: "Warnings occur under the same circumstances as when values are inserted via the INSERT statement (see section 6.4.3 INSERT Syntax), except that

RE: mysql config problems

Hey Tim, I've run into this before. The docs say that if you don't have the grant tables set up you'll get that error: http://www.mysql.com/doc/P/o/Post-installation.html (search for "host.frm" in page) But I've also seen it when I tried copying the support_files/mysql.server to the /etc/rc.d/

RE: Can one SELECT records depending on multiple entries in a many to many table?

> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Benjamin > Hi. > > On Mon, Oct 01, 2001 at 07:54:37PM -0700, [EMAIL PROTECTED] wrote: > > > > Hi there, > > > > I have a many-to-many relationship: > > > > ind table > > - > > id = 4, name = Joe

Can one SELECT records depending on multiple entries in a many to many table?

Hi there, I have a many-to-many relationship: ind table - id = 4, name = Joe id = 5, name = Jane bus_ctr table - id = 1, name = downtown mall id = 2, name = sunshine mall id = 3, name = express shop mm_ind_bus_ctr table (many to many association table)

RE: sql syntax INSERT

You probably want a unique index for those cols. Check out: http://www.mysql.com/doc/C/R/CREATE_TABLE.html (search for unique in page) and http://www.mysql.com/doc/C/R/CREATE_INDEX.html -Joe > -Original Message- > From: Robert Martin [mailto:[EMAIL PROTECTED]] > Sent: Monday, October

RE: why would LOWER

> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Benjamin > Pflugmann > Sent: Sunday, September 30, 2001 1:55 PM > To: Joe Kaiping > Cc: [EMAIL PROTECTED] > Subject: Re: why would LOWER > > > Hi. > > The problem is th

RE: why would LOWER

h of the searched > for value and > looking that up in a hash table for the index. If the > character set you are > using is case sensitive (and I assume it is or you wouldn't > need the LOWER), > then the hashing algorithm would also be case sensitive. > > Will Frenc

why would LOWER

Hi there, Is it expected that using the LOWER function should greatly increase query time? Or is there a MySQL setting that can help speed it up? Below are the results of a query against a table that has an index on cols (email,cust). Using LOWER increases the query time by 10.5 seconds. (eek!

ERD modeler and schema generator/modifier

Hi list, Can anyone recommend an ERD modeler for MySQL? I've tested the evaluation version of "Dezign for databases" and while I like it and was able to generate an initial schema with it, I couldn't get it to create SQL to alter the schema after I had modified the initial ERD. (I was only able

RE: Can't get MySQL to use available memory (performance very slow)

> -Original Message- > From: Dan Nelson [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, September 12, 2001 9:17 AM > To: Joe Kaiping > Cc: [EMAIL PROTECTED] > Subject: Re: Can't get MySQL to use available memory (performance very > slow) > > > In the last ep

Can't get MySQL to use available memory (performance very slow)

key_buffer=64M -O table_cache=256 \ -O sort_buffer=4M -O record_buffer=1M & with little or no improvement. Can someone explain why MySQL isn't using more memory or point me in the right direction to improve MySQL's performance? Many thanks in advance, Joe Kaiping =