On 10/08/2015 09:02 AM, LEIBOVICI Thomas wrote:
> I can't understand why "SELECT id FROM ENTRIES" would return nothing!
>
> You can try this in the mysql prompt: "explain SELECT id FROM ENTRIES"
> This will indicate how it runs the request.
Here it is:
mysql> explain SELECT id FROM ENTRIES\G
*************************** 1. row ***************************
id: 1
select_type: SIMPLE
table: ENTRIES
type: index
possible_keys: NULL
key: PRIMARY
key_len: 66
ref: NULL
rows: 199304552
Extra: Using index
1 row in set (0.00 sec)
Here is the my.cnf file (nothing exotic, mysql 5.1.73 straight from
CentOS 6 repository):
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# for robinhood. We tolerate 1 second data loss
innodb_file_per_table
innodb_flush_log_at_trx_commit=2
innodb_buffer_pool_size=6G
innodb_thread_concurrency=4
innodb_max_dirty_pages_pct=15
max_connections=256
connect_timeout=60
innodb_log_file_size=500M
bind-address = 127.0.0.1
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
I've ran an mysqlcheck on all the table and everything looks fine.
Maybe the problem is related to the number of rows and my specific setup ?
That's weird.
Jean-Baptiste
------------------------------------------------------------------------------
_______________________________________________
robinhood-support mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/robinhood-support
