All Questions
Tagged with mysql-5 configuration
4 questions
1
vote
2
answers
14k
views
How to force higher values of open_files_limit or table_open_cache?
I'm having a frustrating problem where setting my.cnf to values higher than I currently have them does not 'take'.
This is MySQL 5.6.14 on MacOS X 10.8.3
I'm trying to address dropped connections ...
- 11
1
vote
1
answer
11k
views
Where is the MySQL variable - innodb_flush_method?
I would like to tweak the value of innodb_flush_method to find out its performance impact on a database server. That variable is listed when I run the command SHOW VARIABLES.
But I could not find it ...
- 367
1
vote
1
answer
491
views
Installing Sphinx on Mac OS with XAMPP
We have:
Sphinx 2.0.3
Mac OS 10.6.8
XAMPP 1.7.3 (with MySQL 5.1.44)
Here is PATH:
user:sphinx-2.0.3-release user$ echo $PATH
/Applications/xampp/xamppfiles/bin:/opt/local/bin:/opt/local/sbin:/...
- 11
2
votes
1
answer
768
views
How we can enable `index_condition_pushdown`?
I have optimizer_switch variable as
mysql> show variables like 'optimizer_switch';
+------------------+-------------------------------------------------------------------------------------------+
|...
- 9,717