RW-splitting partitionning, ERROR 24
I'm actually using the 0.8.0 mysql-proxy.
i've a random error when i use mysqlslap, for stressing Mysql with partitionning by range (date).
MY variables:
key_buffer_size = 1024M
max_allowed_packet = 1M
table_open_cache = 1024
table_definition_cache=1024
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size= 16M
open_files_limit=32640
max_connections = 500
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8
Undepending if master-slave :
ERROR : Out of resources when opening file './DATABASEX/TABLETEST#P#p200101.MYD' (Errcode: 24)
Subject
Views
Written By
Posted
RW-splitting partitionning, ERROR 24
3931
February 01, 2010 09:35AM
2104
February 02, 2010 03:38AM
2195
February 08, 2010 02:06AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.