12-31-2019
Hi Neo,
my 2 cents:
You maybe did so but if not, knowing the type of process it involves, I would have chosen as you did a calm period for the task, and to not waste proc time due to the different caches, try to optimize what I can/ where I can e.g. not sure you can change the cache ration of the FS or underlying storage ( I suppose that is more the provider's duty...) but you have access to your RDBMS kernel I would reduce its cache working storage to force the reading of the true data) this is efficient for big batch processes when you know you are after data not often read ( so no chance of finding them in caches), of course, it impacts ordinary online interactive work but as you have fewer requests thrown by online users its acceptable... it should improve a bit your step 4...
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hello ,
I just installed openssh in my system . I actually tried to man sshd but it says no entry , though there is a man directory in the installation which have the man pages for sshd .
Can anyone tell me how should i install these man pages .
DP (2 Replies)
Discussion started by: DPAI
2 Replies
2. UNIX for Dummies Questions & Answers
Hi,
I've written now a man pages, but I don't knwo how to get 'man' to view them. Where have I to put this files, which directories are allowed??
THX Bensky (3 Replies)
Discussion started by: bensky
3 Replies
3. UNIX for Dummies Questions & Answers
Hi folks,
I want to know all the commands for which man pages are available. How do i get it?
Cheers,
Nisha (4 Replies)
Discussion started by: Nisha
4 Replies
4. UNIX for Dummies Questions & Answers
When reading man pages, I notice that sometimes commands are follwed by a number enclosed in parenthesis. such as:
mkdir calls the mkdir(2) system call.
What exactly does this mean? (4 Replies)
Discussion started by: dangral
4 Replies
5. UNIX for Dummies Questions & Answers
can anybody explain me how to read unix
man pages?
for example when i want to get information about ps command
man ps gives me this output:
***********************************
Reformatting page. Please wait... completed
ps(1) ... (2 Replies)
Discussion started by: gfhgfnhhn
2 Replies
6. UNIX for Dummies Questions & Answers
Hi,
I want to install man pages package from solaris 10.
Solaris 10 has already been installed on my servor but I have to add the man pages packages. I search for a long time on internet this package but I didn't find a compatible one... So I downloaded Solaris 10 from Sun site to get this... (1 Reply)
Discussion started by: MasterapocA
1 Replies
7. Fedora
Hello sir,
I am using FEDORA 9.
I wanted to know why do we have ".1" extension in the archives of man pages. I know we are giving format.
I want to know the importance or purpose of this format.
Can you please tell me :confused: (2 Replies)
Discussion started by: nsharath
2 Replies
8. Solaris
Hi everyone,
I have a small query, in solaris the man pages get displayed on half of the terminal , can i get a full terminal or full screen display ?:) (2 Replies)
Discussion started by: M.Choudhury
2 Replies
9. HP-UX
Can anyone supply me with the man pages for:
omnidatalist
omnibarlist
omnisap.exe
I prefer the source man pages in nroff format.
A clue about the software bundles which supply these man pages is fine as well.
OS: HP-UX
TIA (11 Replies)
Discussion started by: sb008
11 Replies
10. Shell Programming and Scripting
what command should i use for displaying the manual pages for the socket, read and connect system calls? (1 Reply)
Discussion started by: Nabeel Nazir
1 Replies
LEARN ABOUT PHP
mysqlnd_qc_set_storage_handler
MYSQLND_QC_SET_STORAGE_HANDLER(3) 1 MYSQLND_QC_SET_STORAGE_HANDLER(3)
mysqlnd_qc_set_storage_handler - Change current storage handler
SYNOPSIS
bool mysqlnd_qc_set_storage_handler (string $handler)
DESCRIPTION
Sets the storage handler used by the query cache. A list of available storage handler can be obtained from mysqlnd_qc_get_available_han-
dlers(3). Which storage are available depends on the compile time configuration of the query cache plugin. The default storage handler is
always available. All other storage handler must be enabled explicitly when building the extension.
PARAMETERS
o $handler
- Handler can be of type string representing the name of a built-in storage handler or an object of type mysqlnd_qc_han-
dler_default. The names of the built-in storage handler are default, APC, MEMCACHE, sqlite.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
If changing the storage handler fails a catchable fatal error will be thrown. The query cache cannot operate if the previous storage han-
dler has been shutdown but no new storage handler has been installed.
EXAMPLES
Example #1
mysqlnd_qc_set_storage_handler(3) example
The example shows the output from the built-in default storage handler. Other storage handler may report different data.
<?php
var_dump(mysqlnd_qc_set_storage_handler("memcache"));
if (true === mysqlnd_qc_set_storage_handler("default"))
printf("Default storage handler activated");
/* Catchable fatal error */
var_dump(mysqlnd_qc_set_storage_handler("unknown"));
?>
The above examples will output:
bool(true)
Default storage handler activated
Catchable fatal error: mysqlnd_qc_set_storage_handler(): Unknown handler 'unknown' in (file) on line (line)
SEE ALSO
Installation, mysqlnd_qc_get_available_handlers(3).
PHP Documentation Group MYSQLND_QC_SET_STORAGE_HANDLER(3)