• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 197
  • Last Modified:

install 5.5.16 from source

hi
 there are many article in Google about how to install from source.

so i definitely not looking for any how to documents.

i am after some advise from people who has experience to install mysql from source in a very busy production environment

mainly this will be very busy mysql server 64 gb ram and it will be mainly innodb database .

i used to install with this flag

  ./configure --prefix=/usr/local/mysql --with-ssl --with-plugins=innobase

but is there any extra flag i need to mention to make it perfect for innodb databases ??

thanks for your advise ..


0
fosiul01
Asked:
fosiul01
  • 4
  • 2
1 Solution
 
johanntagleCommented:
Think you should also add --enable-thread-safe-client (http://dev.mysql.com/doc/refman/5.0/en/source-configuration-options.html#option_configure_enable-thread-safe-client)

Alternatively, you might want to consider a different MySQL build that has enhanced version of InnoDB - http://www.percona.com/software/percona-server/

On either option of course, the tuning after installation is the most critical.  See references below.

References:
http://linuxadminzone.com/compile-mysql-5-1-with-innodb-and-optimize-for-heavy-usage/
http://blog.codesherpas.com/on_the_path/2011/03/tuning-mysql.html
http://www.mysqlperformanceblog.com/2006/09/29/what-to-tune-in-mysql-server-after-installation/
http://vbtechsupport.com/657/ (benchmarking MySQL vs Percona)
0
 
mohansahuCommented:
Hi,
Install required dependencies to compile MySQL like
$ yum install gcc gcc-c++ ncurses-devel
$ cd mysql-5.1.45
$ ./configure --prefix=/var/lib/mysql  --localstatedir=/var/lib/mysql/data --sysconfdir=/etc/mysql --with-mysqld-user=mysql --with-plugins=innobase,myisam --enable-thread-safe-client
$ make
$ make install

and then change the permissions of mysql directory
$ chown -R /var/lib/mysql:mysql mysql/

MS
0
 
fosiul01Author Commented:
hi its 5.6 , not 5.1

i just installed 5.6  in test and production

then installation is is quite differ from 5.1
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
fosiul01Author Commented:
Sorry 5.5 , not 5.1
0
 
mohansahuCommented:
0
 
fosiul01Author Commented:
i have already installed it

anyway thanks for your help
0
 
fosiul01Author Commented:
i instaleld it before hand
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now