fenway

You have to escape the quotes -- mysql_real_escape_string() comes to mind.

That's a php issue... mysql doesn't know what you want to do.

What was wrong with Barand's idea... except use a user variable as row counter, and check MOD 5 of that?

Which table is vendor_id in?

It's not really a good idea, as max_packet_size can be an issue... use the FS for what it was meant for.

What doesn't work about it?

You'll need to use STR_TO_DATE if they're not really dates.

The # of different user names isn't really going to make much of a difference...

What if you drop the order by clause?

I feel like I've answered this question before... partitioning is a very advanced concept, and not really necessary.

There are always performance issues... do you have a specific qurestion?

That should be: DATE_FORMAT(from_unixtime(topic_time),'%m %d %Y')

Then how are we supposed to help?

English-only, please....

I tried to re-write your query: SELECT DISTINCT ic_data.bucket FROM ic_data INNER JOIN ic_index_buckets ON (ic_index_buckets.sid=ic_data.bucket AND ic_index_buckets.csv=ic_data.csv ) INNER JOIN ic_index_bucketgroups ON ( ..... ) WHERE ( ic_data.csv BETWEEN 3 AND 4 OR ic_data.csv BETWEEN 8 AND 17 OR ic_data.csv BETWEEN 20 AND 21 ) AND value ( = ????? ) GROUP BY ic_data.bucket ORDER BY SUM( ic_data.value ) DESC I'm confused by a few things: 1) Why is ic_index_bucketgroups used? How is it related to the other tables? 2) you're not checking "value" for anything in the where clause? 3) Why GROUP BY / ORDER BY if you're using DISTINCT with a single column! 4) There are many missing indexes.

Have you confirmed that the DB value is actually the same before/after? Is the php version the same?

Can we see the actual query that caused that error?

Mysql 5.1 has partioning for this very reason.

Not that I know of... why would you want to?

Yeah, but they're leaving federated in/out of certain production builds, so you have to be careful.

Yes, you should definitely use another table for multiple countries... but I would also split the username/password from the address info.

I assume you got those from the sticky -- what currently doesn't "work" about it?

You can do it, but anything other than the group-by'ed column will be meaningless!

Strictly speaking, you need the join condition -- it's an accident if it works.

Not without MySQL 5.