trouble sending mail to [EMAIL PROTECTED]

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 tu

GROUP BY...not using index?

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 0

index, unique index question

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

Re: Which is a better design?

7, at 12:54 PM, David T. Ashley wrote: On 5/10/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 yo

Re: Which is a better design?

now I 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

Which is a better design?

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 th

Re: what kind of indices to set up

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

Re: what kind of indices to set up

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 searc

Re: what kind of indices to set up

ex 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 m

what kind of indices to set up

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 search

Re: Finding a record in a result set

uot;Maine") Dan On Mar 22, 2007, 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) &

Re: Finding a record in a result set

Ave. Farmington, CT 06032 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

Re: Finding a record in a result set

es On Mar 22, 2007, 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

Re: Finding a record in a result set

do a query 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 PROTECT

Re: Finding a record in a result set

results? -James On Mar 22, 2007, 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

Finding a record in a result set

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 da

Re: speeding up a join COUNT

o create an index 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" Sent: Tuesday, January 23, 2007 12:0

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 users.user_ty

Best way to backup a 24/7 database

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 (haven'

mysqlhotcopy errors osx

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 right

Using MySQL to log and report transactions

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 DATET

Re: Database design question

PRIMARY KEY (`userid`,`messageid`) ) 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: "

Re: Database design question

n key 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 thei

Database design question

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 fo

Re: Are these db stats normal...part 2

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

Are these db stats normal...part 2

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.

Are these db stats normal?

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

Backup and Maintenance Strategies

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 si

Re: Fw: Inner workings of a JOIN

Thank you for all of your answers and suggestions. I feel a lot more confident finishing my table designs -James

Inner workings of a JOIN

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 = B.id What does MySQL do

Query performance...two table design options

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 u

Upgrading from 4.0 to 4.1

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

database design question

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 i