mysql tuning - need recommendation

[J. Bakshi]

Dear list,

Let me arise all-time favorite topic mysql performance tuning once again.
I have a ***dedicated server only for mysql; equipped with i5 processor and 8GB RAM.***
It is debian squeeze. The tables are mixed types i.e. some are InnoDB and some are MyISAM.

I have installed mysqltuner and I am filtering out the interested findings and my questions

*****
- [OK] Maximum possible memory usage: 5.6G (72% of installed RAM)

---> How can I increase the limit ? I have 8 GB RAM.


*****
- [!!] Key buffer hit rate: 94.6% (821K cached / 44K reads)

---> What should I do here ?


*****
- [!!] Table cache hit rate: 0% (4K open / 596K opened)

---> What should I do here ?


*****
- [!!] InnoDB data size / buffer pool: 4.9G/8.0M

---> What should I do here ?


mysqltuner also suggest the following


-------- Recommendations -----------------------------------------------------
General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance
MySQL started within last 24 hours - recommendations may be inaccurate
Increase table_cache gradually to avoid file descriptor limits
Variables to adjust:
table_cache (> 4000)
innodb_buffer_pool_size (>= 4G)
`````````````

So, Please suggest me based on my H/W how can I get optimum from mysql ?

Thanks


--
To UNSUBSCRIBE, email to debian-us...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listm...@lists.debian.org
Archive: http://lists.debian.org/20111228171...@shiva.selfip.org

[hamed hosseini]

hi, i cant help you,but i like your work,can you tell me and show me how can create webserver?
i have i7 and 4 GB ram.
note:i have install mysql and phpmyadmin and apache,but i am new in linux,and i want create webserver.

[J. Bakshi]

On Wed, 28 Dec 2011 15:15:52 +0330
hamed hosseini <hos...@gmail.com> wrote:

> hi, i cant help you,but i like your work,can you tell me and show me how
> can create webserver?
> i have i7 and 4 GB ram.
> note:i have install mysql and phpmyadmin and apache,but i am new in
> linux,and i want create webserver.
>
> On Wed, Dec 28, 2011 at 3:10 PM, J. Bakshi <baks...@gmail.com> wrote:
>

Well.. you are already have the components. Just install a ftp server too
and point it at /var/www/ or /var/www<site-name> for file related operation for your users.

Surely you will run the php enabled sites. So install php5 , related modules ( based on your site requirements).

Tune the apache server tuning part for good performance. Use apacahe benchmark (ab command).

And obviously do google. As you start working on your web server, you gradually understand it's requirement.
Always have a close eye on logs. It is always useful.

Hope this helps.

--
To UNSUBSCRIBE, email to debian-us...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listm...@lists.debian.org

Archive: http://lists.debian.org/20111228173...@shiva.selfip.org