is somewhat off topic, so I suggest looking elsewhere. I'm sure
there are some good forums online at various sites where you can ask
this kind of question and get better answers.
Matthew Walker
-
Before posting, please check:
http
in
the columns that come /before/ the AutoIncrement column in the index.
Hope this helps someone. I know it's going to help me significantly.
Matthew Walker
-
Before posting, please check:
http://www.mysql.com/manual.php
Price.
MySQL == Free
Oracle ==
On Thu, 2002-08-15 at 20:25, Elizabeth Bogner wrote:
A company I work with is in the process of upgrading its databases from
some
motheaten system to something current. My impression is that they
want to go with Oracle, and I'm not sure if this is
/ that
behavior, and think it should be a feature, but before I go further, I
need to know if I can count on it to hang around. And if it is a
feature, why it doesn't work in three column indexes.
Please CC the reply-to address in your responses.
Thanks for your time,
Matthew Walker
I need help optimizing the query below. I've included the query, the
table declerations, and the output of explain. Any help would be greatly
appreciated.
What I'd really like is to find out how to get it to use a key on the
lineitems table. I've tried adding indexes on the OrderID and
sql,query
I have a table with the following structure:
CREATE TABLE cartconfig_module (
UserID int(10) unsigned NOT NULL default '0',
GroupID int(10) unsigned NOT NULL default '0',
SiteID int(10) unsigned NOT NULL default '0',
Perms enum('Modify','View','Deny') NOT NULL default 'View',
Interesting idea, Andrew. I don't know how to do what you're asking for,
but I'd be interested to see it added too. I'd never heard of geometric
means, but I can already think of several areas where they might be
useful. Thanks for sharing the information on how they're calculated!
Matthew
I have to say that I disagree. It would be a very good idea to recompile
the kernel, to get rid of all the fancy sound and graphics options. The
smaller your kernel, the better. Also, you might want to look at the
Preemptive patch for the kernel, to help improve performance further.
Matthew
Wrong. Windows uses \ for their paths, so MySQL should use the same
thing.
Matthew Walker
Senior Software Engineer
ePliant Marketing
-Original Message-
From: Bob Ryan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 09, 2002 1:59 PM
To: 'ali hafiz'; [EMAIL PROTECTED]; [EMAIL PROTECTED
Overhead is 'wasted' space in the table. It happens if a table has
variable length rows, and you delete one in the middle of the table. To
fix it, OPTIMIZE the table occasionally.
Matthew Walker
Senior Software Engineer
ePliant Marketing
-Original Message-
From: Soheil Shaghaghi
sql,query
Regardless of what you might call it, Overhead is what phpMyAdmin calls
it.
Matthew Walker
Senior Software Engineer
ePliant Marketing
=20
-Original Message-
From: Svensson, B.A.T. (HKG) [mailto:[EMAIL PROTECTED]]=20
Sent: Wednesday, April 17, 2002 3:16 PM
To: Matthew Walker
*light goes on* You know, I think I've been confused about that. Thanks
for clearing things up. I for some reason didn't make the connection (no
pun intended) that each page would be getting it's own connection to the
DB, and so couldn't interfere with the last_insert_ID queries.
Matthew Walker
Did you FLUSH the permissions? (aka, reload the server, in phpMyAdmin)
Matthew Walker
Senior Software Engineer
ePliant Marketing
-Original Message-
From: Mark Roberts [mailto:[EMAIL PROTECTED]]
Sent: Sunday, April 14, 2002 5:31 PM
To: [EMAIL PROTECTED]
Subject: Question about grants
the value you just set in the update.)
As far as performance goes, my PHP app can do 40+ queries in less that
.05 seconds. So you shouldn't have problems there.
Good luck!
Matthew Walker
Senior Software Engineer
ePliant Marketing
-Original Message-
From: Craig Westerman [mailto:[EMAIL
Actually, with a pconnect, there would be a trade off. Since it uses a
shared connection, the last insert ID could change between the update
and calling the api function. But as I said, it doesn't matter for the
counter.
Matthew Walker
Senior Software Engineer
ePliant Marketing
-Original
MySQL is the 'standard' MySQL. MySQL-Max include high end features, for
big systems. Things like InnoDB, for one. Stuff that the average user
might not want.
So, essentially, it just tells you what features are in that release.
Matthew Walker
Senior Software Engineer
ePliant Marketing
I just went in looked at mySQLMan, and I must say, I'm not very
impressed with it. If you like that package, you should really try out
phpMyAdmin. You can download it at http://phpmyadmin.sourceforge.net.
It's completely free, quite secure, and very easy to use.
Matthew Walker
Ecommerce Project
As to your second question, I'd /highly/ recommend
http://phpwizard.net/projects/phpMyAdmin/. I use it to manage all the
databases where I work, and have had very few problems with it.
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
From: Kory Wheatley
?
Filter: mysql
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.332 / Virus Database: 186 - Release Date: 3/6/2002
I have, but I'd rather not reinvent the wheel if I don't have to, though
I'm almost to the point where I'm going to need to.
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
From: Todd Williamsen [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 08, 2002 3
I've been poking around some more online, and I've found a very nice
session module, that can easily be expanded to handle user logins. Check
it out at http://www.php.lt/sqlsession/
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
From: Matthew Walker
Actually, upgrading the kernel is /not/ hard. Simply follow the
instructions in the INSTALL file inside the tarball. Many people have a
fear of doing this, but if you read the instructions, and know your
machine, it's a simple matter.
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
Hmmm. Wonder if this would be why MySQL-Max failed to install on my new
Penguin Computing server... It's running RH7.1
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 22, 2002 5:32
You /can/, but it may not work. SuSE uses a slightly different directory
structure, and RedHat RPMs may get confused. If at all possible, use
SuSE provided packages.
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
From: Victoria Reznichenko [mailto
This would fail dramatically. The squareroot of a negative number is not
a real number.
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
From: Keith A. Calaman [mailto:[EMAIL PROTECTED]]=20
Sent: Monday, February 11, 2002 5:24 PM
To: David Mackay; 'David
on it. Oh, and SETI@Home, to burn in the processors. ;)
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
From: Tobias Lind - Telia Internet [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 13, 2002 9:32 AM
To: [EMAIL PROTECTED]
Subject: MySQL on Linux, Athlon
. And all without adding any lines. Maybe this will help someone
else in the future who is in the same situation.
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
From: Thomas Spahni [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 08, 2002 5:25 AM
SELECT * FROM Table WHERE Fruit LIKE banana%
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
From: Rutledge, Aaron [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 12:56 PM
To: Mysql List (E-mail)
Subject: LIKE work around??
I am trying
I need to find a text editor for Linux that doesnt load the whole file
into memory. I need to edit a 1.5 gig text flatfile to add two lines.
But I dont have enough ram to open it in most programs. Can anyone
recommend something?
Filter: sql,query
Matthew Walker
Ecommerce Project Manager
I ended up using head and tail to split it into 2 files, so that I
didn't have to edit it. See, it was the output of a mysqldump from two
databases, and I needed to make sure each part went where it needed to
go.
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message
SELECT schdays FROM courses WHERE (schdays LIKE M) OR (schdays LIKE
W) OR (schdays LIKE F)
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
From: Douglas Brantz [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 29, 2002 1:15 PM
To: [EMAIL PROTECTED
To get rid of overhead, run an OPTIMIZE TABLE on the table.
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
From: Mark Stringham [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 29, 2002 11:02 AM
To: Scott Wang; [EMAIL PROTECTED]
Subject: Re: Lost Data
Personally, I just run it whenever I delete any large quantity of rows.
You could run it once a week, or day, or whatever. Up to you.
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
From: Mark Stringham [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January
Use YaST to edit your configuration file. Scroll down to 'start_mysql',
and set it to 'yes'. Hit F10, and wait while it reconfigures things.
Enjoy.
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
From: Samy Elashmawy [mailto:[EMAIL PROTECTED]]
Sent
You can only do this while compiling it from source.
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
From: Chetan Lavti [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 28, 2002 9:11 PM
To: [EMAIL PROTECTED]
Subject: InnoDB help !!
hi,
I have downloaded
I'd recommend decimal(10,2), myself.
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Saturday, January 26, 2002 5:57 PM
To: Shankar Unni
Cc: [EMAIL PROTECTED]
Subject: Re: most appropriate data
This brings to mind a question I've had for a while. Is there any way to
automatically build and update an enum based on another very simple (1
column) table?
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
From: James E. Hicks III [mailto:[EMAIL
on that table.
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 25, 2002 2:02 PM
To: Matthew Walker; [EMAIL PROTECTED]
Subject: RE: MySQL Checkbox table field
At 14:04 -0700 1/25/02, Matthew
Use decimal(10,2) for fields that will contain monetary values. If you
use a float it will round the values, while decimal won't.
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
From: Keith W [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 07, 2002 3:07
(ID),
FULLTEXT KEY Name (FirstName,LastName)
) TYPE=MyISAM;
Query:
SELECT * FROM Customers WHERE MATCH (FirstName,LastName) AGAINST
('walker')
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http
(select last_insert_id());
$dbhandle-query(UNLOCK TABLES);
$result = $res-fetchRow();
return $OrderID = $result[0];
} else {
return $OrderID;
}
} // end func
--
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
---
--
Matthew Walker
Ecommerce Project Manager
That won't work. The connection is being made through the PEAR DB class,
so the standard PHP functions won't work. (And yes, I did just test it.)
-Original Message-
From: rc [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 30, 2001 1:58 PM
To: Matthew Walker
Cc: [EMAIL PROTECTED
Sounds to me like the database was possibly created on a different
architecture, so the DB files are incompatible. Only way /I/ know of
(Warning: I Am Not A MySQL Guru) to transfer the DBs reliably is to dump
the DB to a flat text file on one platform, and then import it back into
MySQL on the
?
--
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.281 / Virus Database: 149 - Release Date: 9/18/2001
How would I go about turning them off? Yes, I know. Another RTFM
question, but some of these things are a little hard to find in the
online manual.
-Original Message-
From: Matthew Simpson [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 21, 2001 1:47 PM
To: Matthew Walker
Cc: [EMAIL
: Wednesday, August 29, 2001 1:00 PM
To: Joshua J. Kugler
Cc: David Turner; Matthew Walker; MySQL Mailling List
Subject: Re: Hot Backups
Didn't read your last item before I fired my last message off. If
mysqldump locks the
table before it dumps then it is interupting service. If I have a high
What's the best way of doing a hot backup on a database? Our server is
set up in such a way that it's not a simple matter to shut down
apache/mysql and do the backup then. So, is it safe to just copy the
mysql directories, or is there some recommended procedure for this?
Matthew Walker
System
that server up. I would like to hear how
other
people are backing up servers without interupting service.
Dave
On Wed, Aug 29, 2001 at 12:50:06PM -0600, Matthew Walker wrote:
What's the best way of doing a hot backup on a database? Our server
is
set up in such a way that it's not a simple matter
48 matches
Mail list logo
