select o.vstdate,o.vsttime,o.hn,d.*,dt.name,concat(p.pname,p.fname,'  ',p.lname) as ptname  ,t.name as pttype_name
from pq_doctor d
left outer join doctor dt on dt.code = d.doctor
left outer join ovst o on o.vn = d.vn
left outer join patient p on p.hn = o.hn
left outer join pttype t on t.pttype = o.pttype
where d.doctor in ("0076","0091","0157","0208","0229","0230")  and  (d.doctor_date between '2014-06-02' and '2014-06-06'
or  d.doctor_date between '2014-06-09' and '2014-06-13')
and d.doctor_time  between "08:30:00" and "16:30:00"

order by doctor_date,doctor_time

[client]
port      = 3306
socket      = /var/lib/mysql/mysql.sock
default-character-set=tis620

[xtrabackup]
target_dir=/mysqlbackup
datadir=/var/lib/mysql

[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
#skip-locking
skip-external-locking
log_bin_trust_function_creators = 1


key_buffer = 128M
max_allowed_packet = 512M
#table_cache = 1500
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 1M
join_buffer_size = 2M
myisam_sort_buffer_size = 64M
thread_cache = 8
query_cache_type=1
query_cache_size = 256M
thread_concurrency = 8
#default-character-set=tis620
character-set-server=tis620
init_connect = 'SET NAMES tis620'
skip-name-resolve
innodb_file_per_table
skip-character-set-client-handshake
init_connect = 'SET NAMES tis620'
max_heap_table_size = 512M


innodb_data_home_dir = /var/lib/mysql/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /var/lib/mysql/


innodb_buffer_pool_size = 1024M
innodb_additional_mem_pool_size = 20M
innodb_thread_concurrency = 0
innodb_log_file_size = 64M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 2
innodb_lock_wait_timeout = 50
innodb_flush_method=O_DIRECT
innodb_doublewrite=0
innodb_support_xa = 0
innodb_open_files = 2000


innodb_io_capacity = 400
transaction_isolation = REPEATABLE-READ
#innodb_adaptive_checkpoint = 1
innodb_write_io_threads = 16
innodb_read_io_threads = 16

innodb_data_file_path = ibdata1:200M:autoextend
innodb_log_buffer_size = 16M
innodb_log_file_size = 256M

innodb_locks_unsafe_for_binlog=1
concurrent_insert = 2
max_connections = 100


[mysqldump]
quick
max_allowed_packet =512M
allow-keywords

[mysql]
no-auto-rehash
default-character-set=tis620

[isamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

[mysql_safe]
open-files-limit = 50000

121127 02:58:28 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
121127  2:58:28 [Note] Plugin 'FEDERATED' is disabled.
121127  2:58:28 InnoDB: The InnoDB memory heap is disabled
121127  2:58:28 InnoDB: Mutexes and rw_locks use GCC atomic builtins
121127  2:58:28 InnoDB: Compressed tables use zlib 1.2.3
121127  2:58:28 InnoDB: Using Linux native AIO
121127  2:58:28 InnoDB: Initializing buffer pool, size = 1.0G
121127  2:58:28 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file /var/lib/mysql/ibdata1 did not exist:
InnoDB: a new database to be created!
121127  2:58:28  InnoDB: Setting file /var/lib/mysql/ibdata1 size to 200 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100 200
121127  2:58:30  InnoDB: Log file /var/lib/mysql/ib_logfile0 did not exist: new to be created
InnoDB: Setting log file /var/lib/mysql/ib_logfile0 size to 256 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100 200
121127  2:58:32  InnoDB: Log file /var/lib/mysql/ib_logfile1 did not exist: new to be created
InnoDB: Setting log file /var/lib/mysql/ib_logfile1 size to 256 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100 200
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
121127  2:58:35  InnoDB: Waiting for the background threads to start
121127  2:58:36 Percona XtraDB (http://www.percona.com) 1.1.8-rel29.1 started; log sequence number 0
121127  2:58:36 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
121127  2:58:36 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
121127  2:58:36 [Note] Server socket created on IP: '0.0.0.0'.
121127  2:58:36 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
121127  2:58:36 [ERROR] Do you already have another mysqld server running on port: 3306 ?
121127  2:58:36 [ERROR] Aborting

121127  2:58:36  InnoDB: Starting shutdown...
121127  2:58:41  InnoDB: Shutdown completed; log sequence number 1597914
121127  2:58:41 [Note] /usr/sbin/mysqld: Shutdown complete

121127 02:58:41 mysqld_safe mysqld from pid file /var/lib/mysql/phraodatacenter.com.pid ended