Ubuntu
mysql-dfsg-5.1 package

mysql server dedicated ESX VM image or OVF

Asked by Mesut GULNAZ

i am triying to migrate all of my MSSQL systems to mysql. my server is ubuntu LTS in english. all of my tables and dbs are latin5 or utf-8 (turkish). my ubuntu server is on ESX 4.0. it is a virtual server with Fiber Disks and 8 CPU and 24 GB DDR3 RAM. the only thing i need is a special configuration for ubuntu installation (optimized installation include File Systems, services and packages) and a mysql server configuration for maximum performance. i mean buffering configs, cache configs and any other configs in my.cnf. perhaps you can send me a OVF file to use. if i can success this, i dont wanna use MSSQL serverS any more. thanks for all.

Question information

Language:
English Edit question
Status:
Answered
For:
Ubuntu mysql-dfsg-5.1 Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Mesut GULNAZ (mesutgl) said : 		#1

does it set the File system and kernel parameters for shared memory and file system inodes and etc...

Revision history for this message
Mesut GULNAZ (mesutgl) said : 		#2

Does this project set all the necessary options in kernel and sysctl for
inodes and memory usage and others???

On 27.02.2011 14:09, "marcobra (Marco Braida)"
<email address hidden> wrote:

>Your question #147084 on mysql-dfsg-5.1 in ubuntu changed:
>https://answers.launchpad.net/ubuntu/+source/mysql-dfsg-5.1/+question/1470
>84
>
> Project: Ubuntu => mysql-dfsg-5.1 in ubuntu
>
>--
>You received this question notification because you are a direct
>subscriber of the question.

Revision history for this message
David Hoeffer (d-hoeffer) said : 		#3

There's no such thing as a generic configuration for maximum performance. The reason why there are tunable parameters is that you can adapt mysql to different workloads and environments. The values you choose depend on your requirements.

Can you help with this problem?

Provide an answer of your own, or ask Mesut GULNAZ for more information if necessary.

To post a message you must log in.