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.
Select MIN(TimeSlot) from B;
Any suggestions would be greatly appreciated. Thank you!
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
Experts Exchange (EE) has become my company's go-to resource to get answers. I've used EE to make decisions, solve problems and even save customers. OutagesIO has been a challenging project and... Keep reading >>