0 Members and 1 Guest are viewing this topic.
du -sch /var/lib/mysql/sun1984*29M /var/lib/mysql/sun1984_1243M /var/lib/mysql/sun1984_1087M /var/lib/mysql/sun1984_1115M /var/lib/mysql/sun1984_1261M /var/lib/mysql/sun1984_2173M /var/lib/mysql/sun1984_3342M /var/lib/mysql/sun1984_421M /var/lib/mysql/sun1984_547M /var/lib/mysql/sun1984_676M /var/lib/mysql/sun1984_7403M /var/lib/mysql/sun1984_846M /var/lib/mysql/sun1984_91.6G total
| 3260095 | kloxo | localhost | kloxo | Sleep | 127 | | NULL | 0.000 || 3260139 | kloxo | localhost | kloxo | Sleep | 126 | | NULL | 0.000 || 3260140 | root | localhost | NULL | Query | 126 | closing tables | drop database sun1984_5 | 0.000 |
[mysqld]#skip-networking#bind-address = 0.0.0.0#server-id=1#log-bin = mysql-bin#skip-name-resolve#skip-grant-tablesdatadir=/var/lib/mysqltmpdir=/dev/shmsocket=/var/lib/mysql/mysql.sockuser=mysql#log_warnings=2skip-external-lockingquery_cache_limit=64Mquery_cache_size=256Mquery_cache_type=1max_connections=900max_user_connections=50max_connect_errors=5000open_files_limit = 1024000thread_handling = pool-of-threadsthread_cache_size=6key_cache_segments=6key_buffer=2048Minnodb-buffer-pool-instances=6innodb_buffer_pool_size = 2048Minnodb_thread_concurrency=6innodb_log_file_size=64Minnodb_log_buffer_size = 8Minnodb_lock_wait_timeout = 100innodb_flush_log_at_trx_commit = 2innodb_support_xa=0innodb_read_io_threads = 2innodb_write_io_threads = 2innodb_max_dirty_pages_pct = 90innodb_file_per_table=1innodb_use_native_aio=1innodb_doublewrite=1innodb_use_fallocate=1innodb_use_atomic_writes=0innodb_flush_method = ALL_O_DIRECTinnodb_file_format=barracudainnodb_lru_scan_depth=2000innodb_io_capacity=400innodb_io_capacity_max=1000sync_binlog=0join_buffer_size=1Mmax_allowed_packet=32Mtable_open_cache=2048sort_buffer_size=1Mread_buffer_size=1Mread_rnd_buffer_size=1Mtmp_table_size=32Mmax_heap_table_size=1Mlong_query_time=2myisam_sort_buffer_size=64Mmax_write_lock_count = 1default-storage-engine=MyISAM[mysqld_safe]log-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pidplugin-load=archive=ha_archive.so;blackhole=ha_blackhole.soopen_files_limit = 1024000[mysqldump]quickmax_allowed_packet=16M
All tables using innodb, myisam or mix?.
Page created in 0.035 seconds with 17 queries.