How to disconnect slaves from master without accesing...
Re: How to disconnect slaves from master without accesing...
Check table if you have table rot_page_items in that db and if it's ok
Don't forget to run script update
Re: How to disconnect slaves from master without accesing...
yes the rot _ page items is there. and it looks ok... I think something wrong with the master database, how to fix it? What u suggest? everytime slaves try to connect, it take so long to generate the page.admin wrote:Check table if you have table rot_page_items in that db and if it's ok
Re: How to disconnect slaves from master without accesing...
post more details plzI think something wrong with the master database
Don't forget to run script update
Re: How to disconnect slaves from master without accesing...
THESE ARE ALL I HAVE... I gave u the mysql logs and all the details... and situations, I AM A SEO GUY time is important if i can't fix it, then everything is dead. why do u keep asking me back and forth. just give me any suggestions or solutions so I can try and get those thing back up... Its simple, I have 100 sites on one BOX and connect to ONE MYSQL master and hell they are very slow when I add more copies, so I am asking u how do I work around and make things faster, u can't just build a script and say u webmaster only can put 10 copies on a $300 a month dedicated box, thats ridiculous... and u know what, mysql really suck when it comes to CMS, and when u put more copies on a dedicated server it adds huge load plus all those cron running every min. I see some webmasters go to nginx, and no I dont use that... I told u everything i can, u know the script better than anyone, just give me any suggestions
there u go, thats all I have man...
--------
FILE I/O
--------
I/O thread 0 state: waiting for i/o request (insert buffer thread)
I/O thread 1 state: waiting for i/o request (log thread)
I/O thread 2 state: waiting for i/o request (read thread)
I/O thread 3 state: waiting for i/o request (read thread)
I/O thread 4 state: waiting for i/o request (read thread)
I/O thread 5 state: waiting for i/o request (read thread)
I/O thread 6 state: waiting for i/o request (write thread)
I/O thread 7 state: waiting for i/o request (write thread)
I/O thread 8 state: waiting for i/o request (write thread)
I/O thread 9 state: waiting for i/o request (write thread)
Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] ,
ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
Pending flushes (fsync) log: 0; buffer pool: 1
22520 OS file reads, 4665 OS file writes, 757 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 2.90 writes/s, 0.05 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 187, seg size 189, 3 merges
merged operations:
insert 3, delete mark 0, delete 0
discarded operations:
insert 0, delete mark 0, delete 0
Hash table size 4425293, node heap has 105 buffer(s)
4.30 hash searches/s, 7.65 non-hash searches/s
---
LOG
---
Log sequence number 60890357836
Log flushed up to 60890325394
Last checkpoint at 60890324987
0 pending log writes, 0 pending chkp writes
2840 log i/o's done, 2.75 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 2197815296; in additional pool allocated 0
Dictionary memory allocated 5537454
Buffer pool size 131072
Free buffers 121530
Database pages 9437
Old database pages 3502
Modified db pages 62
Pending reads 0
Pending writes: LRU 0, flush list 1, single page 0
Pages made young 1, not young 0
0.05 youngs/s, 0.00 non-youngs/s
Pages read 9397, created 40, written 3555
0.00 reads/s, 0.05 creates/s, 0.15 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 1 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 9437, unzip_LRU len: 0
I/O sum[0]:cur[3], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
2 read views open inside InnoDB
Main thread id 34393341952, state: flushing buffer pool pages
Number of rows inserted 196, updated 2321, deleted 3, read 112005
2.80 inserts/s, 0.00 updates/s, 0.00 deletes/s, 4.65 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
InnoDB: ###### Diagnostic info printed to the standard error stream
140312 4:08:14 [ERROR] /usr/local/mysql/bin/mysqld: Table './kenhirai_cxc2/rot_page_items' is marked as crashed and should be repaired
140312 4:08:14 [Warning] Checking table: './kenhirai_cxc2/rot_page_items'
140312 4:12:24 [ERROR] /usr/local/mysql/bin/mysqld: Table './kenhirai_cxfs/rot_page_items' is marked as crashed and should be repaired
140312 4:12:24 [Warning] Checking table: './kenhirai_cxfs/rot_page_items'
140312 4:14:18 [ERROR] /usr/local/mysql/bin/mysqld: Table './kenhirai_cxbtg/rot_page_items' is marked as crashed and should be repaired
140312 4:14:18 [Warning] Checking table: './kenhirai_cxbtg/rot_page_items'
140312 4:16:08 [ERROR] /usr/local/mysql/bin/mysqld: Table './kenhirai_cxcc/rot_page_items' is marked as crashed and should be repaired
140312 4:16:08 [Warning] Checking table: './kenhirai_cxcc/rot_page_items'
140312 4:24:07 [ERROR] /usr/local/mysql/bin/mysqld: Table './kenhirai_cxe/rot_page_items' is marked as crashed and should be repaired
140312 4:24:07 [Warning] Checking table: './kenhirai_cxe/rot_page_items'
140312 4:32:26 [ERROR] /usr/local/mysql/bin/mysqld: Table './kenhirai_bkw/rot_page_items' is marked as crashed and should be repaired
140312 4:32:26 [Warning] Checking table: './kenhirai_bkw/rot_page_items'
140312 4:35:37 [ERROR] /usr/local/mysql/bin/mysqld: Table './kenhirai_cambop/rot_page_items' is marked as crashed and last (automatic?) repair failed
140312 4:38:32 [ERROR] /usr/local/mysql/bin/mysqld: Table './kenhirai_cxch/rot_page_items' is marked as crashed and should be repaired
140312 4:38:32 [Warning] Checking table: './kenhirai_cxch/rot_page_items'
140312 4:51:02 InnoDB: error: space object of table 'kenhirai_tpp/out_ips',
InnoDB: space id 30468 did not exist in memory. Retrying an open.
140312 4:51:02 InnoDB: Operating system error number 2 in a file operation.
InnoDB: The error means the system cannot find the path specified.
140312 4:51:02 InnoDB: Error: trying to open a table, but could not
InnoDB: open the tablespace file './kenhirai_tpp/out_ips.ibd'!
InnoDB: Have you moved InnoDB .ibd files around without using the
InnoDB: commands DISCARD TABLESPACE and IMPORT TABLESPACE?
InnoDB: It is also possible that this is a temporary table #sql...,
InnoDB: and MySQL removed the .ibd file for this.
InnoDB: Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/ ... adict.html
InnoDB: for how to resolve the issue.
140312 4:51:02 InnoDB: cannot calculate statistics for table kenhirai_tpp/out_ips
InnoDB: because the .ibd file is missing. For help, please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/ ... oting.html
140312 4:51:02 [ERROR] MySQL is trying to open a table handle but the .ibd file for
table kenhirai_tpp/out_ips does not exist.
Have you deleted the .ibd file from the database directory under
the MySQL datadir, or have you used DISCARD TABLESPACE?
See http://dev.mysql.com/doc/refman/5.5/en/ ... oting.html
how you can resolve the problem.
140312 7:37:31 [ERROR] /usr/local/mysql/bin/mysqld: Table './kenhirai_cambop/rot_page_items' is marked as crashed and last (automatic?) repair failed
140312 8:35:21 [ERROR] /usr/local/mysql/bin/mysqld: Table './kenhirai_cambop/rot_page_items' is marked as crashed and last (automatic?) repair failed
there u go, thats all I have man...
--------
FILE I/O
--------
I/O thread 0 state: waiting for i/o request (insert buffer thread)
I/O thread 1 state: waiting for i/o request (log thread)
I/O thread 2 state: waiting for i/o request (read thread)
I/O thread 3 state: waiting for i/o request (read thread)
I/O thread 4 state: waiting for i/o request (read thread)
I/O thread 5 state: waiting for i/o request (read thread)
I/O thread 6 state: waiting for i/o request (write thread)
I/O thread 7 state: waiting for i/o request (write thread)
I/O thread 8 state: waiting for i/o request (write thread)
I/O thread 9 state: waiting for i/o request (write thread)
Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] ,
ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
Pending flushes (fsync) log: 0; buffer pool: 1
22520 OS file reads, 4665 OS file writes, 757 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 2.90 writes/s, 0.05 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 187, seg size 189, 3 merges
merged operations:
insert 3, delete mark 0, delete 0
discarded operations:
insert 0, delete mark 0, delete 0
Hash table size 4425293, node heap has 105 buffer(s)
4.30 hash searches/s, 7.65 non-hash searches/s
---
LOG
---
Log sequence number 60890357836
Log flushed up to 60890325394
Last checkpoint at 60890324987
0 pending log writes, 0 pending chkp writes
2840 log i/o's done, 2.75 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 2197815296; in additional pool allocated 0
Dictionary memory allocated 5537454
Buffer pool size 131072
Free buffers 121530
Database pages 9437
Old database pages 3502
Modified db pages 62
Pending reads 0
Pending writes: LRU 0, flush list 1, single page 0
Pages made young 1, not young 0
0.05 youngs/s, 0.00 non-youngs/s
Pages read 9397, created 40, written 3555
0.00 reads/s, 0.05 creates/s, 0.15 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 1 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 9437, unzip_LRU len: 0
I/O sum[0]:cur[3], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
2 read views open inside InnoDB
Main thread id 34393341952, state: flushing buffer pool pages
Number of rows inserted 196, updated 2321, deleted 3, read 112005
2.80 inserts/s, 0.00 updates/s, 0.00 deletes/s, 4.65 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
InnoDB: ###### Diagnostic info printed to the standard error stream
140312 4:08:14 [ERROR] /usr/local/mysql/bin/mysqld: Table './kenhirai_cxc2/rot_page_items' is marked as crashed and should be repaired
140312 4:08:14 [Warning] Checking table: './kenhirai_cxc2/rot_page_items'
140312 4:12:24 [ERROR] /usr/local/mysql/bin/mysqld: Table './kenhirai_cxfs/rot_page_items' is marked as crashed and should be repaired
140312 4:12:24 [Warning] Checking table: './kenhirai_cxfs/rot_page_items'
140312 4:14:18 [ERROR] /usr/local/mysql/bin/mysqld: Table './kenhirai_cxbtg/rot_page_items' is marked as crashed and should be repaired
140312 4:14:18 [Warning] Checking table: './kenhirai_cxbtg/rot_page_items'
140312 4:16:08 [ERROR] /usr/local/mysql/bin/mysqld: Table './kenhirai_cxcc/rot_page_items' is marked as crashed and should be repaired
140312 4:16:08 [Warning] Checking table: './kenhirai_cxcc/rot_page_items'
140312 4:24:07 [ERROR] /usr/local/mysql/bin/mysqld: Table './kenhirai_cxe/rot_page_items' is marked as crashed and should be repaired
140312 4:24:07 [Warning] Checking table: './kenhirai_cxe/rot_page_items'
140312 4:32:26 [ERROR] /usr/local/mysql/bin/mysqld: Table './kenhirai_bkw/rot_page_items' is marked as crashed and should be repaired
140312 4:32:26 [Warning] Checking table: './kenhirai_bkw/rot_page_items'
140312 4:35:37 [ERROR] /usr/local/mysql/bin/mysqld: Table './kenhirai_cambop/rot_page_items' is marked as crashed and last (automatic?) repair failed
140312 4:38:32 [ERROR] /usr/local/mysql/bin/mysqld: Table './kenhirai_cxch/rot_page_items' is marked as crashed and should be repaired
140312 4:38:32 [Warning] Checking table: './kenhirai_cxch/rot_page_items'
140312 4:51:02 InnoDB: error: space object of table 'kenhirai_tpp/out_ips',
InnoDB: space id 30468 did not exist in memory. Retrying an open.
140312 4:51:02 InnoDB: Operating system error number 2 in a file operation.
InnoDB: The error means the system cannot find the path specified.
140312 4:51:02 InnoDB: Error: trying to open a table, but could not
InnoDB: open the tablespace file './kenhirai_tpp/out_ips.ibd'!
InnoDB: Have you moved InnoDB .ibd files around without using the
InnoDB: commands DISCARD TABLESPACE and IMPORT TABLESPACE?
InnoDB: It is also possible that this is a temporary table #sql...,
InnoDB: and MySQL removed the .ibd file for this.
InnoDB: Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/ ... adict.html
InnoDB: for how to resolve the issue.
140312 4:51:02 InnoDB: cannot calculate statistics for table kenhirai_tpp/out_ips
InnoDB: because the .ibd file is missing. For help, please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/ ... oting.html
140312 4:51:02 [ERROR] MySQL is trying to open a table handle but the .ibd file for
table kenhirai_tpp/out_ips does not exist.
Have you deleted the .ibd file from the database directory under
the MySQL datadir, or have you used DISCARD TABLESPACE?
See http://dev.mysql.com/doc/refman/5.5/en/ ... oting.html
how you can resolve the problem.
140312 7:37:31 [ERROR] /usr/local/mysql/bin/mysqld: Table './kenhirai_cambop/rot_page_items' is marked as crashed and last (automatic?) repair failed
140312 8:35:21 [ERROR] /usr/local/mysql/bin/mysqld: Table './kenhirai_cambop/rot_page_items' is marked as crashed and last (automatic?) repair failed
Last edited by kenhirai on Wed Mar 12, 2014 6:01 pm, edited 1 time in total.
Re: How to disconnect slaves from master without accesing...
Well, looks like you need to setup properly your server
You have 3 options
1. google, read docs and do it by yourself
2. ask admin to look into it, give me more details on situation
3. PM me with a custom task and i'll take a look at your server setup
You have 3 options
1. google, read docs and do it by yourself
2. ask admin to look into it, give me more details on situation
3. PM me with a custom task and i'll take a look at your server setup
Don't forget to run script update