How can I tell this? I ran the following:
# echo '\s' | mysql
--------------
mysql Ver 14.14 Distrib 5.1.63, for debian-linux-gnu (x86_64) using
readline 6.1
Connection id: XX
Current database:
Current user: XX
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.1.63-0ubuntu0.10.04.1-log (Ubuntu)
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: latin1
Db characterset: latin1
Client characterset: latin1
Conn. characterset: latin1
UNIX socket: XXX
Uptime: 1 hour 12 min 18 sec
Threads: 1 Questions: 200 Slow queries: 14 Opens: 615 Flush tables: 1
Open tables: 152 Queries per second avg: 0.46
On Fri, Oct 12, 2012 at 3:53 PM, Jeff Wolkove <
wolkove@biz-link.com> wrote:
> Can't tell much from that. Sure it's a 64 bit build?
>
> Jeff Wolkove
>
> ----- Reply message -----
> From: "Vimal Shah" <vimals@sokikom.com>
> To: <azphp@list.azphp.org>
> Cc: "Main PLUG discussion list" <plug-discuss@lists.plug.phoenix.az.us>
> Subject: [AzPHP] Tuning MySQL DB server
> Date: Fri, Oct 12, 2012 3:49 pm
>
>
> Server version: 5.1.63-0ubuntu0.10.04.1-log (Ubuntu)
>
> On Fri, Oct 12, 2012 at 3:22 PM, Jeff Wolkove <wolkove@biz-link.com>wrote:
>
>> What build & version of mySQL are you running now? How much memory is set
>> aside for cache, etc? It may help to post your my.cnf (edited for privacy)
>>
>> Jeff Wolkove
>>
>>
>> ----- Reply message -----
>> From: "Vimal Shah" <vimals@sokikom.com>
>> To: <azphp@list.azphp.org>, " Main PLUG discussion list" <
>> plug-discuss@lists.plug.phoenix.az.us>
>> Subject: [AzPHP] Tuning MySQL DB server
>> Date: Fri, Oct 12, 2012 1:44 pm
>>
>>
>> Hello all,
>>
>> I recently had many teachers and students logging into my site, this is a
>> good thing. The server infrastructure (Linode VPS = 1 load balancer => 2
>> webservers and 1 database (DB) server) started to show CPUs that were
>> railing at peaks times on the Munin graphs. This was not so good. The
>> bandaid (which I need to fix) was to add more servers, I now have 5
>> webservers each have 2GB of RAM and have 2.2.7 GHz CPU (4 of them on each
>> box). This has to be overkill.. Later, realized that MySQL's system
>> variables were not optimized for the DB server. Ran Percona's
>> configuration tool <https://tools.percona.com/> along with the mysqltunner
>> perl script <https://github.com/rackerhacker/MySQLTuner-perl>. This led
>> to the discovery that 32-bit version of Ubuntu will not allow MySQL to use
>> any more that 2GB.
>>
>> NEW DB server = After upgrading the DB server to 8GB and along with going
>> to 64-bit Ubuntu 10.04, I am *still unable to get to the box to use all
>> the memory*. The process I've been using is (1) use apache bench or
>> jmeter to fling large connections (and long queries) at the DB server (2)
>> run the tuner script to see it's recommendations to the system variables
>> (2) update the variables, restart mysql and start over..
>>
>> This has led to unsatisfactory results. I know that fixing the slow
>> queries (which is in process) is a place to start, but I feel that the DB
>> server should be using more RAM. Can someone point out the flaws in my
>> process or maybe even suggest a better way to do this?
>>
>> Thank you very much for you time.
>>
>> First day DBA,
>> -Vimal
>>
>> PS Thanks Eric C., for starting me down the right direction.
>>
>> _______________________________________________
>> azPHP mailing list
>> azPHP@list.azphp.org
>> http://list.azphp.org/mailman/listinfo/azphp_list.azphp.org
>>
>>
>
>
> --
> Vimal (rhymes with Kimmel) Shah
> VP of Engineering
> Sokikom
> Mobile: (480) 752-9269
> Email: vimals@sokikom.com
> Web: www.sokikom.com
>
> Follow us: twitter.com/sokikom <http://www.twitter.com/sokikom>
> Like us: facebook.com/sokikom <http://www.facebook.com/sokikom>
>
>
> _______________________________________________
> azPHP mailing list
> azPHP@list.azphp.org
> http://list.azphp.org/mailman/listinfo/azphp_list.azphp.org
>
>
--
Vimal (rhymes with Kimmel) Shah
VP of Engineering
Sokikom
Mobile: (480) 752-9269
Email: vimals@sokikom.com
Web: www.sokikom.com
Follow us: twitter.com/sokikom <
http://www.twitter.com/sokikom>
Like us: facebook.com/sokikom <
http://www.facebook.com/sokikom>
---------------------------------------------------
PLUG-discuss mailing list -
PLUG-discuss@lists.plug.phoenix.az.us
To subscribe, unsubscribe, or to change your mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
(text/plain)