Has anyone else been having problems sending mail to mysql-
[EMAIL PROTECTED]
I tried it with two mail accounts (one at work and also GMail)
I get this as a response...for some reason it doesn't seem to be
getting to the list at all. The mail servers are somehow taking that
address and
I have an index on `food` and on `active`, how come the result of the
EXPLAIN doesn't show the query using an index? I'm concerned that as
the query time will grow with the table.
My Query:
SELECT `food` , COUNT( `food` ) AS 'population'
FROM `users`
WHERE `active`=1
GROUP BY `food`
LIMIT
I have a table that has a Primary key using the 'id' column.
The table also has a 'receiver_id' and a 'sender_id'.
I have queries that will use
(1) WHERE receiver_id =
or
(2) WHERE sender_id=
but never WHERE receiver_id='###' AND sender_id='###'
Also, I want the receiver_id/sender_id pair to be
will let MySQL do the work instead of filtering with an IF
in PHP.
-James
On May 10, 2007, at 12:20 PM, David T. Ashley wrote:
On 5/9/07, James Tu [EMAIL PROTECTED] wrote: The database server
and the web server are on separate machines.
Table A contains a record for each user.
Let's say Table
/07, James Tu [EMAIL PROTECTED] wrote:
I think b/c of the way the tables are designed, I have to perform
multiple queries, unfortunately.
Hi James,
My suggestion to you would be that if you have a situation you
don't believe
you can handle in one query, post all the details to the MySQL list
The database server and the web server are on separate machines.
Table A contains a record for each user.
Let's say Table B contains 'relationship' information. They can be
of type 'friend' or 'family'.
If a user knows another user, this relationship would be kept in this
table, along with
= * AND
hub_caps_type = 1
If you could perform a query like the one above, would MySQL still
use the multi-column index that I set up?
-James
On Apr 24, 2007, at 4:47 PM, James Tu wrote:
What do you guys think of this approach...
Always query on all 5 columns...and then create a multicolumn index
using
for the search.
Mike
At 11:16 AM 4/23/2007, James Tu wrote:
I have a table which will be searched via some of the fields in the
column.
An example of the list of searcheable columns:
make
model
body_color
tire_type
hub_caps_type
The thing is that people might do a search using one or many
What do you guys think of this approach...
Always query on all 5 columns...and then create a multicolumn index
using all 5 columns?
-James
On Apr 24, 2007, at 11:42 AM, James Tu wrote:
Thanks Mike.
So let's say I have in index on each of the columns below...and I
do a search
I have a table which will be searched via some of the fields in the
column.
An example of the list of searcheable columns:
make
model
body_color
tire_type
hub_caps_type
The thing is that people might do a search using one or many of the
fields as criteria.
For example someone might
, at 11:21 AM, James Tu wrote:
Is there some quick way to do the following in MySQL? (I know I
can use PHP to search through the result set, but I wanted to see
if there's a quick way using some sort of query)
Let's say I know that Joe is from Maine.
I want to do a query of all employees from
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: James Tu [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 04, 2007 1:05 PM
To: James Tu
Cc: MySQL List
Subject: Re: Finding a record in a result set
Right now I'm trying to use PHP to do a binary search on the result
set so I don't have
in
the list ahead of him, rather than determining position within the
result
set.
As in:
SELECT COUNT(*) FROM some_table
WHERE state = Maine
AND hire_date (SELECT hire_date FROM some_table
WHERE last_name = Smith
AND first_name = Joe
AND state = Maine)
Dan
On Mar 22, 2007, at 11:21 AM, James
, at 11:21 AM, James Tu wrote:
Is there some quick way to do the following in MySQL? (I know I
can use PHP to search through the result set, but I wanted to see
if there's a quick way using some sort of query)
Let's say I know that Joe is from Maine.
I want to do a query of all employees from
on a
page of results that will contain the user, I'm still going to take a
hit right?
Or are you concerned about performance b/c MySQL and subqueries are
really slow?
-James
On Mar 23, 2007, at 8:05 PM, Maciej Dobrzanski wrote:
James Tu [EMAIL PROTECTED] wrote in message =
news:[EMAIL
Is there some quick way to do the following in MySQL? (I know I can
use PHP to search through the result set, but I wanted to see if
there's a quick way using some sort of query)
Let's say I know that Joe is from Maine.
I want to do a query of all employees from Maine, ordered by hiring
on that field. Otherwise you need to scan the entire table
to find
out which users are of the type you are searching for.
- Original Message -
From: James Tu [EMAIL PROTECTED]
To: MySQL List mysql@lists.mysql.com
Sent: Tuesday, January 23, 2007 12:04 PM
Subject: speeding up a join COUNT
I'm performance testing my 'users' table. It currently has roughly
1M user records. The 'geo_entities' table has ~ 250 records.
Here's my query.
SELECT users.entity_id, geo_entities.entity_name,
geo_entities.short_code, COUNT( users.entity_id )
FROM users, geo_entities
WHERE
The first time I tried to run the mysqlhotcopy script, I got an error
that indicated that Perl couldn't find the DBI module.
So, I found a site (http://www.quicomm.com/apm_dbddbi.htm) that
stepped me through making and installing
MySQL DBD and the DBI modules(? don't know if I'm using the
We're working on a site that will most likely be up 24 hours a day.
What is the best backup strategy for the database?
The client will be using hosting services, but they haven't' picked
anyone yet.
I've been playing around with mysqlimport (pretty straightforward)
and mysqlhotcopy
Hi:
I'm going use MySQL to log transactions so that I can report on them
later.
Ex:
CREATE TABLE statistics (
id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT
, user_id BIGINT UNSIGNED
, entity_id INT UNSIGNED
, transaction_type INTEGER(2) UNSIGNED
, datetime_logged
I want to design a database for lots of users. Each user will be
managing their own messages. Does it make sense to create a table
for each user after they've registered?
Or should I just create one MESSAGES table and store messages there
keyed off of their user_id?
If I create a table
referencing the destinating user as well.
-Original Message-
From: James Tu [mailto:[EMAIL PROTECTED]
Sent: Monday, August 07, 2006 1:56 PM
To: mysql@lists.mysql.com
Subject: Database design question
I want to design a database for lots of users. Each user will be
managing
their own
`)
)
What that does is give each user their own incrementing message
id. Then you can do things like allow users to enter a message id
directly with a number that would be easy for them to remember.
Just an idea.
- Original Message - From: James Tu [EMAIL PROTECTED]
To: mysql
I've also checked the error log and there isn't anything that indicates
where these aborted_client connections are coming from. I checked today and
I have 100 more of these.
-James
I used phpMyAdmin to look at the stats for my MySQL server.
here's what they show...
http://www.2-bit-toys.com/db_info/server_status.html
What concerns me mainly are the stats at the top-right...'Failed attempts'
and 'Aborted.'
When would these situations occur? Is it normal to see these?
I'm
I just issued a show status query and the numbers are what MySQL returns.
Strange.
Failed attempts (aka aborted_clients) : 8154
Aborted (aka Aborted_connects): 319
Total (aka Connections) : 4626
So phpMyAdmin is basing the % calculations on these numbers, that's why we
see the weird percentage.
What have people done in the past regarding backup strategies?
Is it adequate enough to rely on filesystem backups for mysql? Basically
such that we can restore MySQL to the last filesystem backup. Is there a
reason not to do this?
I don't have any mission critical data and data that is lost
Thank you for all of your answers and suggestions. I feel a lot more
confident finishing my table designs
-James
Hi:
Let's say I want to store the following information.
Unique ID - INT(10) autoincrement
First Name - VARCHAR (25)
Last Name - VARCHAR (25)
Age - INT(3)
Date - DATETIME
Activity - VARCHAR(100)
Data - TEXT
I would be basing my queries on all columns _except_ the Data column. I.e. I
would be
What does MySQL do internally when you perform a LEFT JOIN?
Let's say you have two tables:
Table A has 1,000,000 rows
Table B has 5,000 rows
When you perform the following LEFT JOIN:
Select A.*, B.*
FROM A, B
WHERE
A.lastname = 'doe' AND A.id http://A.id = B.id http://B.id
What does MySQL do
I had to migrate from 4.0.11 to 4.1.12. I saved the data directory from the
older version. I also exported all the information using phpMyAdmin's export
tool. I have one huge .sql file.
When I upgraded to 4.1.12, I followed instructions to copy the contents of
the old data directory to the new
I have four different activities. Each has its own set of data that
I want to save. So, I made four different tables to hold the saved
data. Each record also has 'keywords' field (essentially this is the
only field that all tables have in common.)
Later on, I want to search all the keywords
33 matches
Mail list logo