.
Baroda - 390007
Gujarat, India
Personally I'm always ready to learn, although I do not always like being taught
From: Gavin Towey
To: Sudhir N ; Mysql
Sent: Tue, 15 December, 2009 2:16:53 AM
Subject: RE: Optimization suggestions
Id should probably
y, December 14, 2009 10:31 AM
To: Mysql
Subject: Optimization suggestions
I have following table structure, I have to use merge storage engine.
Please have a look, and provide feedback if theres some thing wrong or if
there's space for optimization.
/*Table structure for table `messa
After one very quick look, the index on folderid alone is unnecessary since
you have another index in which that field is the high-order field.
On Mon, Dec 14, 2009 at 12:31 PM, Sudhir N wrote:
> I have following table structure, I have to use merge storage engine.
> Please have a look, and prov
I have following table structure, I have to use merge storage engine.
Please have a look, and provide feedback if theres some thing wrong or if
there's space for optimization.
/*Table structure for table `messages2009` */
CREATE TABLE `messages2009` (
`id` varchar(36) NOT NULL default '',
`
Please see my comments below :
On Thu, 2005-12-01 at 14:06 -0600, Ross Anderson wrote:
> I have read the suggestions for optimization for innodb however I'm
> curious if anyone can help me understand which buffers are common (thus
> used by innodb action) and which are specific to myiasm. The s
I have read the suggestions for optimization for innodb however I'm
curious if anyone can help me understand which buffers are common (thus
used by innodb action) and which are specific to myiasm. The server has
2GB of ram but runs multiple services. I have a number of different
types of conne
