แสดงกระทู้
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
พี่ก็ใช้ตัว upgrade นะ
เง้อ!! ของผมตั้งภาษาไทยผิดตรงไหนอ่ะ งง แท้ เดี๋ยวของเอาตัวติดตั้งตัวเต็ม v เก่าทับดีกว่า
วันนี้ลองทำอีกเครื่องก็ใช้ได้ตามปกติเช่นกัน
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
# You can adjust key_buffer to 10% off Physical memory (for innodb base engine)
# or adjust key_buffer to 60% off Physical memory (for myisam base engine)
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
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/
# You can adjust innodb_buffer_pool_size to 70% off Physical memory (for innodb base engine)
# or adjust innodb_buffer_pool_size to 10% off Physical memory (for myisam base engine)
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
#***percona Extra-DB Only***
innodb_io_capacity = 10000
#innodb_adaptive_checkpoint = 1
innodb_write_io_threads = 16
innodb_read_io_threads = 16
#***percona Extra-DB Only***
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
ของผม พิษณุโลกใช้ catonnet ทั้งจังหวัดครับ รพใช้ leaseline ทั้งจังหวัดครับ สำรองใช้ tot
สอบถามทางฝ่ายธุรการมาให้แล้วนะค่ะ
ได้ทำการจัดส่งวารสารไปให้เมื่อวันศุกร์นะค่ะ (น้องแพรวเป็นผู้แจ้งให้ทางฝ่ายธุรการจัดส่งให้ค่ะ)
อดใจรอสักนึด..อาจจะวันนี้หรือไม่ก็พรุ่งนี้นะค่ะ
*-ฝ่ายลูกค้าสัมพันธ์-*
[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