Slow disk access: 1.4m to do a select count over 23GB table.

Hi, I'm using mysql 4.1.21, a legacy system. Next step to migrate it, but for now, I need the community help. I have a 23GB table, if I do a select count(over_an_index) from table it uses 1.4minutes to read. The main issue is that this table is the main table of a system and each query is taking t

Re: Query Help

I believe you're describing a crosstab query. This should help you put it together: http://rpbouman.blogspot.com/2005/10/creating-crosstabs-in-mysql.html ---Michael On Friday, July 09, 2010 07:37:41 pm Phillip Baker wrote: > Hello All, > > > For the life of me I cannot remember how to make a

Query Help

Hello All, For the life of me I cannot remember how to make a query like this and what it is called. I know it is fairly basic though. Table 1 Product_id Product_Name Table 2 Category_id, Category_name Table 3 Product_id, Category_id Each product can have one or more categories. So I want a

Last day to submit your Surge 2010 CFP!

Today is your last chance to submit a CFP abstract for the 2010 Surge Scalability Conference. The event is taking place on Sept 30 and Oct 1, 2010 in Baltimore, MD. Surge focuses on case studies that address production failures and the re-engineering efforts that led to victory in Web Application

Re: combined or single indexes?

At 12:43 AM 7/9/2010, you wrote: On Fri, Jul 9, 2010 at 7:30 AM, Neil Tompkins wrote: > > Should we be looking to create a index for all fields that we might be > perform a select condition in a where clause for ? Neil, Keep in mind that the more indexes you add to a table, the slower yo

Re: Permissions and Into Outfile

Hi all, >From the manual: *Any file created by INTO OUTFILE or INTO DUMPFILE is writable by all users on the server host. The reason for this is that the MySQL server cannot create a file that is owned by anyone other than the user under whose account it is running. (You should never run mysqld

WTA Query For Winner Drawing

Dear List, I'm developing a winner drawing application using PHP+MySQL. As we know that MySQL has a built in function RAND() to randomize the result. But using that function will only randomize, my goal is the player with higher point gets higher posibility when randomizing. Anybody can help? Ma