#! /usr/bin/perl use Time::Local; $time=timelocal(0,0,0,(localtime)[3,4,5]); $time=$time-35*86400; print "unixtime $time\n"; print scalar(localtime($time)),"\n";
./time.pl unixtime 1305748800 Thu May 19 00:00:00 2011
[root@dlc-zabb-db]/var/lib/mysql# cat /etc/my.cnf|grep -iv '^#' [client] port = 3306 socket = /var/lib/mysql/mysql.sock [mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock back_log = 50 max_connections = 100 max_connect_errors = 10 table_open_cache = 2048 max_allowed_packet = 16M binlog_cache_size = 1M max_heap_table_size = 64M read_buffer_size = 2M read_rnd_buffer_size = 16M sort_buffer_size = 8M join_buffer_size = 8M thread_cache_size = 8 thread_concurrency = 16 query_cache_size = 64M query_cache_limit = 2M ft_min_word_len = 4 default-storage-engine = INNODB thread_stack = 192K transaction_isolation = REPEATABLE-READ tmp_table_size = 64M log-bin=mysql-bin binlog_format=mixed slow_query_log long_query_time = 2 server-id = 1 key_buffer_size = 32M bulk_insert_buffer_size = 64M myisam_sort_buffer_size = 128M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover innodb_additional_mem_pool_size = 16M innodb_buffer_pool_size = 2G innodb_data_file_path = ibdata1:10M:autoextend innodb_write_io_threads = 8 innodb_read_io_threads = 8 innodb_thread_concurrency = 16 innodb_flush_log_at_trx_commit = 1 innodb_log_buffer_size = 8M innodb_log_file_size = 256M innodb_log_files_in_group = 3 innodb_max_dirty_pages_pct = 90 innodb_lock_wait_timeout = 120 innodb_file_per_table [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash [myisamchk] key_buffer_size = 512M sort_buffer_size = 512M read_buffer = 8M write_buffer = 8M [mysqlhotcopy] interactive-timeout [mysqld_safe] open-files-limit = 8192 [root@dlc-zabb-db]/var/lib/mysql#
history Обзор Структура Поиск Вставить Очистить Удалить ~772,587 InnoDB utf8_general_ci 59.1 МБ - history_uint Обзор Структура Поиск Вставить Очистить Удалить ~359,109 InnoDB utf8_general_ci 29.1 МБ - items Обзор Структура Поиск Вставить Очистить Удалить 6,210 InnoDB utf8_general_ci 2.2 МБ
asterisk # ls -lah queue_log.* 3-rw-rw---- 1 mysql mysql 8.7K Июл 29 00:36 queue_log.frm -rw-rw---- 1 mysql mysql 156M Авг 17 00:51 queue_log.ibd -rw-rw---- 1 mysql mysql 11K Июл 30 03:05 queue_log.TRG asterisk # mysql -pQwestions Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 53831352 Server version: 5.1.56-log Gentoo Linux mysql-5.1.56 Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved. This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL v2 license Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> delete from asterisk.queue_log where time<=unix_timestamp(now() - INTERVAL 1 DAY); Query OK, 728553 rows affected (29.68 sec) mysql> exit Bye asterisk # ls -lah queue_log.* -rw-rw---- 1 mysql mysql 8.7K Июл 29 00:36 queue_log.frm -rw-rw---- 1 mysql mysql 156M Авг 17 00:52 queue_log.ibd -rw-rw---- 1 mysql mysql 11K Июл 30 03:05 queue_log.TRG asterisk # mysql -p Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 53832311 Server version: 5.1.56-log Gentoo Linux mysql-5.1.56 Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved. This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL v2 license Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> optimize table asterisk.queue_log; +--------------------+----------+----------+-------------------------------------------------------------------+ | Table | Op | Msg_type | Msg_text | +--------------------+----------+----------+-------------------------------------------------------------------+ | asterisk.queue_log | optimize | note | Table does not support optimize, doing recreate + analyze instead | | asterisk.queue_log | optimize | status | OK | +--------------------+----------+----------+-------------------------------------------------------------------+ 2 rows in set (2.24 sec) mysql> exit Bye asterisk # ls -lah queue_log.* -rw-rw---- 1 mysql mysql 8.7K Авг 17 00:53 queue_log.frm -rw-rw---- 1 mysql mysql 20M Авг 17 00:53 queue_log.ibd -rw-rw---- 1 mysql mysql 11K Июл 30 03:05 queue_log.TRG
Comment