10-09-2010
Network Tweaking - Database Query Across Internet
Hi
We run a script that queries a database via the internet and we need the fast possible connections to the database server.
I have centos server which sends the requests to the database across the internet . it sends upto 800 queries per milliseconds however this using the default settings on our server.
Are their any tweaks we can make to the network card / settings on centos 5.4 ?
I have increased MTU frames to 1500 but thats about it.
Any suggestion would be welcomed
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi!.
I have problems installing my network card under
ther redhat kernel.
First i tryed my integrated intel pro set 10/100
then my d-link 530tx Pci but none of them seems to
be found.
also i huse my network card to connect to the net
trough PPPOE where i need to type my username and... (3 Replies)
Discussion started by: Gibbler
3 Replies
2. Shell Programming and Scripting
I am executing a SQL query in Unix Server:
select status,location from user_information where request_id='DS-43720'
In shell script I am writing this query in the below manner:
echo "select status,location from user_information where request_id='DS-43720' ;" >> $directory/info.sql
... (3 Replies)
Discussion started by: debu
3 Replies
3. Shell Programming and Scripting
Hi friends,
I have written a script which retrieves one value from the database.
It takes time for the sql query to get the desired output. So the query runs fine from TOAD or from UNIX console.
However if I put this in a script it doesn't work. The script is as below.
#! /bin/ksh... (2 Replies)
Discussion started by: vivek_damodaran
2 Replies
4. Shell Programming and Scripting
Hi,
Am using informix database. When i give "isqlrf <database name> - " from the command prompt , i get connected to the database and i can run sql queries..
I am moving to freeBSD and when i give the same command at the prompt i get an error : Index already exists on column
Why is this... (0 Replies)
Discussion started by: jisha
0 Replies
5. Shell Programming and Scripting
Hi all,
I would want to spool file for a database query, however by using crontab, the file is not spooled. Below shows my script:
ORACLE_HOME="/u01/oraprod/perpdb/10.1.0/db_1"
OUTFILE="/tmp/invalid.out"
FILE="$HOME/admin/scripts"
$ORACLE_HOME/bin/sqlplus -s "/as sysdba"... (0 Replies)
Discussion started by: *Jess*
0 Replies
6. Solaris
i have a router from my isp provider 02. my internet works fine in windows but i am unable to use internet in solaris. when i tried ifconfig command
i was able to see the lo0 which is my laoopback adapter. pls can someone advice. (7 Replies)
Discussion started by: seyiisq
7 Replies
7. IP Networking
Hi! :D
I'm new here, and I will appreciate all the help you can give.
This is the problem we are trying to solve at my office.
At office 1 we have SCO UNIX 5.0.can't remember last number. On it runs database software on which we input/read/modify data throughout terminal software, on remote... (1 Reply)
Discussion started by: PNemesis
1 Replies
8. Programming
How can i modify the below to search for the things i'm looking for during a certain time frame?
select Node, NodeAlias, Summary, Tally, AlertKey, AlertGroup, Manager, Agent from mrtg_alerts where LastOccurrence > '5-Dec-2010' order by Manager desc;
In this particular case, this query is... (3 Replies)
Discussion started by: SkySmart
3 Replies
9. Shell Programming and Scripting
Thank you for taking the time to read my issue. I need to set up a script to run from a wagon wheel type toplogy where 1 server needs to query about 10 to 15 remote servers for duplicate values in a database table. If a duplicate value is found, send an email to me( or wall command to console).... (5 Replies)
Discussion started by: lutador72
5 Replies
10. Programming
I am getting an error function in date formate while importing the date ccolumn in oracle sql developer tool
My date format in table is 6-Nov-14 and while importing its converted to 6/11/14 eventhough the format is as 6-Nov-14 in excel.
could you please let help me out what I need to change... (6 Replies)
Discussion started by: ramkumar15
6 Replies
LEARN ABOUT CENTOS
radrelay
RADRELAY(8) FreeRADIUS Daemon RADRELAY(8)
NAME
radrelay -- Deprecated command.
DESCRIPTION
The functions of radrelay have been added to radiusd. One benefit is that one instance of radiusd can read multiple detail files, among
others.
The rlm_sql_log module does something similar, but for SQL queries. See it's man page for details.
REPLICATION FOR BACKUPS
Many sites run multiple radius servers; at least one primary and one backup server. When the primary goes down, most NASes detect that and
switch to the backup server.
That will cause your accounting packets to go the the backup server - and some NASes don't even switch back to the primary server when it
comes back up.
The result is that accounting records are missed, and/or the administrator must jump through hoops in order to combine the different detail
files from multiple servers. It also means that the session database ("radutmp", used for radwho and simultaneous use detection) gets out
of sync.
We solve this issue by "relaying" packets from one server to another, so they both have the same set of accounting data.
See raddb/sites-available/buffered-sql for more information.
BUFFERING FOR HIGH-LOAD SERVERS
If the RADIUS server suddenly receives a many accounting packets, there may be insufficient CPU power to process them all in a timely man-
ner. This problem is especially noticable when the accounting packets are going to a back-end database.
Similarly, you may have one database that tracks "live" sessions, and another that tracks historical accounting data. In that case,
accessing the first database is fast, as it is small. Accessing the second database many be slower, as it may contain multiple gigabytes
of data. In addition, writing to the first database in a timely manner is important, while data may be written to the second database with
a few minutes delay, without any harm being done.
See raddb/sites-available/copy-to-home-server for more information.
SEE ALSO
radiusd(8), rlm_sql_log(5)
AUTHOR
The FreeRADIUS Server Project
23 October 2007 RADRELAY(8)