Shawn Green (MySQL) wrote:
> On 9/10/2010 10:01 AM, george larson wrote:
>>
>> Uwe Brauer wrote:
>> ...
>> The only one I know of, for my environment, is /etc/my.cnf.  I believe
>> that it can be located elsewhere but you could just use 'find' to find
>> it.  I've broken my dev. MySQL many, many times and that's the only file
>> I know about outside of my data directory.  :)
>>
>> I don't have any good ideas about discerning precisely what version of
>> MySQL was running, though.
>>
>
> The error log will have the version information. Each successful
> startup includes something similar to
>
> 100910  7:50:30 [Note] mysqld: ready for connections.
> Version: '5.1.48-enterprise-gpl-advanced'  socket: ''  port: 3306 
> MySQL Enterprise Server - Advanced Edition (GPL)
>
> For more information on how to locate the error log:
> http://dev.mysql.com/doc/refman/5.1/en/error-log.html
>
That's a neat trick and I don't mean to steal the thread but that didn't
work for me:

---
:/var/lib/mysql # head mysqld.log
100910 12:50:09 mysqld_safe Starting mysqld daemon with databases from
/var/lib/mysql
100910 12:50:09 [Warning] option 'table_cache': unsigned value 536870912
adjusted to 524288
100910 12:50:09 [Warning] The syntax '--log_slow_queries' is deprecated
and will be removed in MySQL 7.0. Please use
'--slow_query_log'/'--slow_query_log_file' instead.
100910 12:50:09 [Warning] Changed limits: max_open_files: 65535 
max_connections: 50  table_cache: 32737
100910 12:50:09 [Note] Plugin 'ndbcluster' is disabled.
100910 12:50:09 [Note] Plugin 'FEDERATED' is disabled.
---

I'm going to comb through my 'my.cnf' to see if it might have somehow
been disabled.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=arch...@jab.org

Reply via email to