Quick question: How can I execute MySQL queries on my server directly when I access Apache remotely via SSH? Currently I use phpmyadmin front-end interface and it works fine, but I want to be able to get see the query execution times (which I don't know if you can do on phpmyadmin when using the raw SQL box.) I Also how do I configure mysql server to allow query caching, I know these need to be configured but not sure how to go about doing it: have_query_cache query_cache_limit query_cache_size query_cache_type Thanks.
You can set MySQL variables globally by setting them in the /etc/my.cnf file (restart MySQL after). Also, phpmyadmin does show execution time.
Thanks DP, can you explain using SSH (which I am a complete beginner with) how to modify the my.cnf to turn on query caching? ...and then how to restart mysql. Thanks!
So how does one modify the query cache? My my.cnf file only has about 5 lines it, no mention of query cache anywhere. Would love to hear other peoples experience on improvements (or lack of) from using this feature.