Re: OPTIMIZE TABLE

Not an expert, but: 2009/11/14 Krishna Chandra Prajapati prajapat...@gmail.com: I would like to know how optimize table work internally. A table contains 200 millions records. Whether query performance will be faster after deletion of 30 million records from this table or not. Use of OPTIMIZE

Selecting data from multiple tables

Hi folks, I'm trying to, possibly do the impossible here. I have to select data from 4 different tables to come up with the right information and I'm having one heck of time trying to figure it out. This is going to be a long email ... Table_1:

Re: log sql queries?

Ah! Thanks - I see. 5.1.39 Actually I did look i the manual, but failed to note the differences between 5.1.29 and 5.1.29 I was using the syntax for 5.1.29. Now I am using the correct syntax in /etc/my.cnf $ grep general /etc/my.cnf general_log=1 general_log_file=/var/log/mysql/mysql.log

RE: Selecting data from multiple tables

These table names are extraordinarily confusing; especially since your schema is de-normalized. One of these tables should have (user_id int unsigned not null auto increment primary key, username varchar(100) ); All the rest should be using user_id. Anyway, to answer your first question:

How to change root password?

I am running MySQL 5 on OS X Snow Leopard... Have it set up (by installing the pref pane) to always be running as soon as my MacBook starts. For some odd reason, I can't remember the password I issued for root user and wish to either change it back to blank or a new specific password. What

Re: How to change root password?

Michael Wilson írta: I am running MySQL 5 on OS X Snow Leopard... Have it set up (by installing the pref pane) to always be running as soon as my MacBook starts. For some odd reason, I can't remember the password I issued for root user and wish to either change it back to blank or a new

Re: mysql Create table in system database

Thanks Shawn for the quick response. But then What I am doing is I am doing copy paste of one database and rename it to another. but I cannot read the tables inside it. Can you tell me what might be the possible reason for that. -- Thanks and Regards, Manasi Save Artificial Machines Pvt Ltd.

Re: How to change root password?

On Sun, 15 Nov 2009 20:13:38 -0800, Michael Wilson michaelwilso...@gmail.com wrote: I am running MySQL 5 on OS X Snow Leopard... Have it set up (by installing the pref pane) to always be running as soon as my MacBook starts. For some odd reason, I can't remember the password I issued for