04-16-2009
Quote:
Originally Posted by
muay_tb
might sound obvious as i know its possible in PHP but...
why not grab records from the database using a set query whereby you pass a sort (or order by) parameter to the function and in the perl manipulate the rows fetched and re-display:
Yes it will work. For most applications I will go with this myself also, but sometimes this is not desirable for performance reasons. Especially if the database itself has already been overloaded, having to ask the database again just to change the sorting will be an overkill. In that case you might want to rely on the server-side language (PHP/Perl) or client-side (Javascript-based) to do the sorting instead. Performance may not necessarily be better, but if the database server is on another host then at least it can be freed for serving other database queries.
This is based on observation because in production environment, database server is very often the performance bottleneck.
9 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I have two radio buttons with corresponding text boxes for input, when one is chosen I am disabling the text box for the other, is there a way to "gray out" the disabled text box using background-color or something? Any help is greatly appreciated, right now my onClick looks like this:
... (1 Reply)
Discussion started by: k@ssidy
1 Replies
2. UNIX for Dummies Questions & Answers
Hey guys,
I needed to add a route to my routing table and I got it to work but on reboot it gets removed. Anyone know what file I can add this route to so it stays on the machine after a reboot? (9 Replies)
Discussion started by: kingdbag
9 Replies
3. Shell Programming and Scripting
I am trying to transpose tables listed in the format into format. Any help would be greatly appreciated.
Input:
test_data_1
1 2 90%
4 3 91%
5 4 90%
6 5 90%
9 6 90%
test_data_2
3 5 92%
5 4 92%
7 3 93%
9 2 92%
1 1 92%
...
Output:... (7 Replies)
Discussion started by: justthisguy
7 Replies
4. Shell Programming and Scripting
Please advise a script to get rid of the following code which is infected in a large number of files ( in particular php and html files )
<div id="testws35fdgh"></div>
<script language="JavaScript">
var0 = "\x69\x3c\x33\x27\x34\x38\x30\x75\x3b\x34"; var1 =... (20 Replies)
Discussion started by: fed.linuxgossip
20 Replies
5. Shell Programming and Scripting
Hi ,
I have two tables with same length t1 and t2, I want to cretae a new third table where i put the difference between the elements of t2 and t1,
t3= t1 - t2
t3= t1 - t2
I am new to scripts, any help please? thanks (7 Replies)
Discussion started by: Celine19
7 Replies
6. Programming
Hi ,
I wanted to know if its possible to execute a javascript function like this
E:- function js1(){
alert ("this is js1");
}
function js2(){
alert ("this is js2");
}
function js3(){
....
execthisscript(js1);
execthisscript(js2);
}
... (1 Reply)
Discussion started by: daptal
1 Replies
7. Programming
Hi guys,
Ok first, let me explain what I want to do. I'm making a theme for the iphone, and I found a nice wallpaper slideshow script. Here is how it knows which wallpapers to use:
<script type="text/javascript">
// SLIDE ROTATION FREQUENCY (in minutes)
var slideRotation = 0.4;... (3 Replies)
Discussion started by: kicker75
3 Replies
8. IP Networking
Hi all,
Now my need is:
This should forward each client to 1.11 and 1.12 as per each request.
I mean :
First request should go to : http://192.168.1.10:8080/MySite
Second request should go to : http://192.168.1.11:8081/MySite
Third request should go to ... (1 Reply)
Discussion started by: linuxadmin
1 Replies
9. Shell Programming and Scripting
I have 3 file inputs,
file1
20160302|5485368299953|96|510101223440252|USA|5485368299953|6|800|2300|0
20160530|5481379883742|7|510101242850814|USA|5481379883742|5|540|2181|1500
20160513|5481279653404|24|510100412142433|INDIA|5481279653404|3|380|1900|0... (1 Reply)
Discussion started by: radius
1 Replies
LEARN ABOUT CENTOS
pmdamysql
PMDAMYSQL(1) Performance Co-Pilot PMDAMYSQL(1)
NAME
pmdamysql - MySQL database PMDA
DESCRIPTION
pmdamysql is a Performance Co-Pilot PMDA which extracts live performance data from a running MySQL database.
INSTALLATION
pmdamysql uses a configuration file from (in this order):
o /etc/pcpdbi.conf
o $PCP_PMDAS_DIR/mysql/mysql.conf
This file can contain overridden values (Perl code) for the settings listed at the start of pmdamysql.pl, namely:
o database name (see DBI(3) for details)
o database user name
o database pass word
Once this is setup, you can access the names and values for the mysql performance metrics by doing the following as root:
# cd $PCP_PMDAS_DIR/mysql
# ./Install
If you want to undo the installation, do the following as root:
# cd $PCP_PMDAS_DIR/mysql
# ./Remove
pmdamysql is launched by pmcd(1) and should never be executed directly. The Install and Remove scripts notify pmcd(1) when the agent is
installed or removed.
Binary Status values in text
Some of the status values are in the form of YES/NO or ON/OFF.
Since these cannot be intepreted by tools like PMIE, they have been duplicated with a _num extension and the values of 1 (YES/ON) or 0
(NO/OFF).
Eg:
o mysql.slave_status.slave_io_running
o mysql.slave_status.slave_io_running_num
FILES
/etc/pcpdbi.conf
configuration file for all PCP database monitors
$PCP_PMDAS_DIR/mysql/mysql.conf
configuration file for pmdamysql
$PCP_PMDAS_DIR/mysql/Install
installation script for the pmdamysql agent
$PCP_PMDAS_DIR/mysql/Remove
undo installation script for the pmdamysql agent
$PCP_LOG_DIR/pmcd/mysql.log
default log file for error messages from pmdamysql
SEE ALSO
pmcd(1), pmdadbping.pl(1) and DBI(3). # vi: sw=4 ts=4 et:
3.8.10 Performance Co-Pilot PMDAMYSQL(1)