asked on
Select MIN(TimeSlot) from B;
It won't return a value. I let it run for over an hour before I stop it and before that it had ran for 20 minutes or more 2 or 3 times and then disconnected me.datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# CACHES AND LIMITS #
tmp-table-size = 32M
max-heap-table-size = 32M
query-cache-type = 0
query-cache-size = 0
max-connections = 1024
thread-cache-size = 50
open-files-limit = 65535
table-definition-cache = 4096
table-open-cache = 4096
# INNODB #
innodb-flush-method = O_DIRECT
innodb-log-files-in-group = 2
innodb-log-file-size = 1G
innodb-flush-log-at-trx-commit = 0
innodb-file-per-table = 1
innodb-buffer-pool-size = 21G
innodb-write-io-threads = 16
innodb-log-buffer-size = 256M
#innodb_doublewrite = 0
max_allowed_packet = 1024M
binlog_format = STATEMENT
expire_logs_days = 0
host_cache_size = 342
[mysqld_safe]
#log-error = /var/log/mysql_error.log
pid-file = /var/run/mysqld/mysqld.pid
Any suggestions would be greatly appreciated. Thank you!