MySQL Performance: MySQL => New to MySQL

Members

Help

Home

Home » Performance » MySQL » New to MySQL

Show: Today's Messages :: Show Polls :: Message Navigator

New to MySQL [message #3271]

Fri, 11 July 2008 02:02

icedhacker
Messages: 6
Registered: July 2008
Location: Ahmedabad

Junior Member

Hi..

I am new to MySQL....
We are making a social networking website and wanted to add email facility to it....what are the features of MySQl that would be useful for me....
Please suggest some performance tweaks as well....
we are using the InnoDb storage engine by default....is it fine or should we change that also....

I have heard about something called archival in MySQL....please enlighten me on this topic as welll...will it be useful for me....

Thanks in advance

Report message to a moderator

Re: New to MySQL [message #3289 is a reply to message #3271 ]

Mon, 14 July 2008 07:33

debug
Messages: 132
Registered: March 2008

Senior Member

Do you mean archive storage engine?
http://dev.mysql.com/tech-resources/articles/storage-engine. html

Mikhail Solovyev, MySQL Performance Expert
MySQL Performance Blog
MySQL Consulting

Report message to a moderator

Re: New to MySQL [message #3294 is a reply to message #3271 ]

Tue, 15 July 2008 00:57

icedhacker
Messages: 6
Registered: July 2008
Location: Ahmedabad

Junior Member

Thanks for correcting me...
Will the Archive Storage Engine be useful for my project..
Please tell me how to install the Archive Storage engine...
i tries configuring my table to archive storage engine but it gave an error in MySQL Query Browser that "the storage engine is not enabled currently"...
Please tell me how to enable it and also enlighten me on the advantages of using this storage engine for implementing the Email facility in my project.....

Report message to a moderator

Re: New to MySQL [message #3295 is a reply to message #3294 ]

Tue, 15 July 2008 01:01

debug
Messages: 132
Registered: March 2008

Senior Member

Please do 'SHOW ENGINES' and post result here.

Mikhail Solovyev, MySQL Performance Expert
MySQL Performance Blog
MySQL Consulting

Report message to a moderator

Re: New to MySQL [message #3296 is a reply to message #3295 ]

Tue, 15 July 2008 01:26

icedhacker
Messages: 6
Registered: July 2008
Location: Ahmedabad

Junior Member

I have attached the result of SHOW ENGINES command... s/fa/34/0/

Attachment: showEngines.jpg
(Size: 59.92KB, Downloaded 190 time(s))

[Updated on: Tue, 15 July 2008 01:27]

Report message to a moderator

Re: New to MySQL [message #3297 is a reply to message #3296 ]

Tue, 15 July 2008 02:10

debug
Messages: 132
Registered: March 2008

Senior Member

Do you have self-built MySQL? I've checked several Redhat and Debian boxes, and ARCHIVE storage engine is enabled on all of them. Looks like you have to rebuild MySQL with enabled ARCHIVE engine.

Mikhail Solovyev, MySQL Performance Expert
MySQL Performance Blog
MySQL Consulting

Report message to a moderator

Re: New to MySQL [message #3298 is a reply to message #3297 ]

Tue, 15 July 2008 02:35

icedhacker
Messages: 6
Registered: July 2008
Location: Ahmedabad

Junior Member

I am using MySQL on a windows PC...
Could you please give me the command that i should use to rebuild MySQL with enabled Archive Storage Engine..

Report message to a moderator

Re: New to MySQL [message #3299 is a reply to message #3298 ]

Tue, 15 July 2008 02:40

icedhacker
Messages: 6
Registered: July 2008
Location: Ahmedabad

Junior Member

Please also suggest me which would be the best storage engine to use for a social networking website with email facility....
The performance of the site is the main issue....we dont want any problems with the performance speed of the site....So please suggest the best storage engine accordingly...

Report message to a moderator

Re: New to MySQL [message #3300 is a reply to message #3299 ]

Tue, 15 July 2008 03:41

debug
Messages: 132
Registered: March 2008

Senior Member

It's hard to say anything definitely without having detailed information about your application.
But in general - look at http://dev.mysql.com/doc/refman/5.0/en/storage-engines.html, it describes features of different engines. Choose the best one for you (those one which fits all your requirements)

Mikhail Solovyev, MySQL Performance Expert
MySQL Performance Blog
MySQL Consulting

Report message to a moderator

Re: New to MySQL [message #3301 is a reply to message #3298 ]

Tue, 15 July 2008 03:44

debug
Messages: 132
Registered: March 2008

Senior Member

icedhacker wrote on Tue, 15 July 2008 13:35

I am using MySQL on a windows PC...
Could you please give me the command that i should use to rebuild MySQL with enabled Archive Storage Engine..

Use google Smile

http://forums.mysql.com/read.php?112,45335,45335

Mikhail Solovyev, MySQL Performance Expert
MySQL Performance Blog
MySQL Consulting

Report message to a moderator

Re: New to MySQL [message #3317 is a reply to message #3301 ]

Fri, 18 July 2008 02:07

icedhacker
Messages: 6
Registered: July 2008
Location: Ahmedabad

Junior Member

Thanks a lot...i think that should do it...

Report message to a moderator

Previous Topic:	Queries are well optimized but they are causing many slow queries
Next Topic:	MySQL 5.0 and Partitioning

Goto Forum:

-=] Back to Top [=-

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 10 03:21:12 EDT 2009

Total time taken to generate the page: 0.03531 seconds

.:: Contact :: Home ::.

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.