Hello List,
I am kind of novice to MySQL
I am using MySQL 5.1.44 with partitioning.
I have a table with daily partitions. Master table and child tables are in
innodb engine.
Few days before I have created partition for april month from 1st to 30th.
Everything was working properly till today ,Today I saw that my partitions till
14th are not in the database nor those table file in data directory.
here is my.cnf
[r...@smart mysql]# cat /etc/my.cnf
[mysqld]
datadir=/data/mysql/
socket=/var/lib/mysql/mysql.sock
user=mysql
transaction-isolation = READ-COMMITTED
skip-locking
innodb_file_per_table = 1
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
#binlog-format=MIXED
log-bin=smart-bin
relay-log=smart2-relay-bin
server-id = 1
binlog-do-db=smart
innodb_buffer_pool_size = 1024M
innodb_log_file_size = 256M
#innodb_log_buffer_size = 8M
innodb_additional_mem_pool_size = 20M
innodb_flush_log_at_trx_commit = 0
innodb_support_xa = 0
innodb_lock_wait_timeout = 20
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
I do have a replication setup as well also there is a cronjob which does
ANALYZE those partition table everynight.
Any clue where are my partitions? or I am doing something silly?
Any help will be highly appreciated.
Thanks in advance
--ashish
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
