Thanks for the help Fajar, We wish to fix this in house so don't want to pay
for a dba BUT we are not getting much closer to the issue though
I have found that a lot of the tables are actually indexed I just didn't know
where to look.
PHPmyadmin runtime info states that Select_full_join
On Tue, Jun 7, 2011 at 2:38 PM, OzSpots - Carl Sawers
c...@ozspots.com.au wrote:
Thanks for the help Fajar, We wish to fix this in house so don't want to pay
for a dba BUT we are not getting much closer to the issue though
... because you lack the skill of a DBA.
I have found that a lot
One of the servers I maintain has 18 qps average and the load is
0.62,0.54,0.63 (1min, 5min, 15min)
Beside the database and radius, that server is used for hundred other
things and it works perfectly (1GB of RAM, dual core CPU)
The point is not how much queries per second do you have. You can
Hi,
Are all the slow query entries potentially a problem, I mean should
yes. any slow queries are potentially a problem. in your
case I believe that you have that many rows in your DB table - and because
there is no index, all entries have to be seen - as previous post says,
you need a DBA or
Thanks for the advice everyone!
I have removed scripts which caused the VERY slow queries and have now
had the slow query log on for a few days. It is still showing loads of
entry's but http access performance is not noticeably slow(on occasion
there is a small delay). The slow queries appear to
On Tue, Jun 7, 2011 at 10:54 AM, OzSpots - Carl Sawers
c...@ozspots.com.au wrote:
SELECT radacct.UserName AS UserName
, radcheck.Value AS Value
FROM radacct
left outer join radlookupnas
ON radlookupnas.user = radacct.UserName
AND radlookupnas.macauth = '0'
AND radacct.CallingStationId =
Thanks Guys,
The slow query log has a lot of entry's in it. It's not obvious which
are causing the most issues but I have found a script that was always
slowish so have removed it. The line read
# Query_time: 5 Lock_time: 0 Rows_sent: 3 Rows_examined: 17286222
No idea where it thinks there
On 06/06/2011 05:05 AM, OzSpots - Carl Sawers wrote:
Thanks Guys,
The slow query log has a lot of entry's in it. It's not obvious which
are causing the most issues but I have found a script that was always
slowish so have removed it. The line read
# Query_time: 5 Lock_time: 0 Rows_sent: 3
Hi All, I have a freeradius server which has some slow mysql queries and
some errors like the below happen now and again(daily).
We have actually just upgraded to this server and have imported all the
MYsql data into the new server (it was working fine on the older quite
similar server). One
be the reason
for this... You can notice this problem with
# ps ax|grep radiusd
and search for radiusd defunct
On 06/04/2011 12:47 PM, OzSpots - Carl Sawers wrote:
Hi All, I have a freeradius server which has some slow mysql queries and
some errors like the below happen now and again(daily).
We have
On Sat, Jun 4, 2011 at 5:47 PM, OzSpots - Carl Sawers
c...@ozspots.com.au wrote:
Hi All, I have a freeradius server which has some slow mysql queries and
some errors like the below happen now and again(daily).
We have actually just upgraded to this server and have imported all the
MYsql data
11 matches
Mail list logo