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

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

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, December

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

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

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 LOAD to be something

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

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 id = 5, name =

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

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)

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.

RE: why would LOWER

. 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 French -Original Message- From: Joe Kaiping [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 30, 2001 4:14 PM To: [EMAIL

RE: why would LOWER

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 that LOWER(email) is an expression and expressions on the left hand

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

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

\ -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 == cnf file settings: == [mysqld

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

- 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 episode (Sep 12), Joe Kaiping said: Hi there, I'm having trouble