Community discussions

 
ssaner
just joined
Topic Author
Posts: 9
Joined: Wed Oct 24, 2012 11:28 pm
Location: Wichita, KS
Contact:

Displaying routes from a large routing table

Wed Oct 24, 2012 11:40 pm

Not sure if this question should go here or in the BGP forum, but I'll start here.

I have a RouterBOARD with a full BGP table, so 400K+ routes plus some OSPF routes.

If I wish to see if there is a route for a particular netblock or IP address in the table and do something like:

/ip route print where x.x.x.x in dst-address

This takes a very loooong time to return. I assume that is due to the size of the table, but I'm talking like nearly a minute to return. I'm used to doing a "show ip route x.x.x.x" on a much less powerful Cisco and getting a response in a couple seconds. Am I doing something wrong or is this just the way it is?

Thanks

Steve
Steven Saner
Hubris Communications
http://www.hubris.net/
 
User avatar
omega-00
Forum Guru
Forum Guru
Posts: 1167
Joined: Sat Jun 06, 2009 4:54 am
Location: Australia
Contact:

Re: Displaying routes from a large routing table

Sat Oct 27, 2012 6:28 am

Hi ssaner,

what RouterBoard model and version are you using and what is the CPU utilisation before and while running the command?

On an x86 (1.8ghz dual core) test box with approx 10k routes the search takes under a second to output a result.
brightwifi.com | mikrotik-routeros.com | MTCNA,MTCWE.MTCTCE | Give karma where due
 
User avatar
martini
Member Candidate
Member Candidate
Posts: 296
Joined: Tue Dec 21, 2004 12:13 am

Re: Displaying routes from a large routing table

Sat Oct 27, 2012 9:40 pm

He he )) Its a very old issue with ROS )
If you have route tables with more than 100k routes - its a nightmare to search route in table )) in winbox or in console .. I have border with 3 full bgp tables )) i prefer do not open routes in winbox ). And again - in linux or Freebsd, with quagga or bird , all ok, i can find one route in second...
 
ssaner
just joined
Topic Author
Posts: 9
Joined: Wed Oct 24, 2012 11:28 pm
Location: Wichita, KS
Contact:

Re: Displaying routes from a large routing table

Wed Oct 31, 2012 6:40 am

He he )) Its a very old issue with ROS )
If you have route tables with more than 100k routes - its a nightmare to search route in table )) in winbox or in console .. I have border with 3 full bgp tables )) i prefer do not open routes in winbox ). And again - in linux or Freebsd, with quagga or bird , all ok, i can find one route in second...
Thanks for the response. That's what I was afraid of. I take it that there is no work around?
Steven Saner
Hubris Communications
http://www.hubris.net/
 
User avatar
nickshore
Member
Member
Posts: 473
Joined: Thu Mar 03, 2005 4:14 pm
Location: Suffolk, UK.
Contact:

Re: Displaying routes from a large routing table

Wed Oct 31, 2012 4:52 pm

Try using a slightly different command:
 /ip route print where dst-address in x.y.z.0/24

I think you'll find that a lot quicker !

(Just tested on a router with 3 BGP feeds)

Hope that helps

Nick.
Nick Shore MTCNA MTCWE MTCRE MTCINE MTCTCE
LinITX.com - MultiThread Consultants
Get your MikroTik RBs and Training: http://linitx.com/brand/mikrotik
Official UK MikroTik Distributor
IRC chan: #routerboard on irc.z.je (IPv4 and IPv6)
 
ssaner
just joined
Topic Author
Posts: 9
Joined: Wed Oct 24, 2012 11:28 pm
Location: Wichita, KS
Contact:

Re: Displaying routes from a large routing table

Wed Oct 31, 2012 5:07 pm

Try using a slightly different command:
 /ip route print where dst-address in x.y.z.0/24

I think you'll find that a lot quicker !

(Just tested on a router with 3 BGP feeds)

Hope that helps

Nick.

Hmmm... Well, yes that is very fast, but it doesn't always get me the result I desire. It only finds routes that are /24 or longer. What if there is a route that has a shorter netmask? I guess I can successively look for /23, /22, /21, etc, but that becomes a pain pretty quickly.

Given the above comment that this is an old issue, does Mikrotik have any plans to fix this that anyone knows about?

Thanks
Steven Saner
Hubris Communications
http://www.hubris.net/
 
User avatar
nickshore
Member
Member
Posts: 473
Joined: Thu Mar 03, 2005 4:14 pm
Location: Suffolk, UK.
Contact:

Re: Displaying routes from a large routing table

Thu Nov 01, 2012 5:14 pm

Start you query with a big netmask then

just use /16 to start with
Nick Shore MTCNA MTCWE MTCRE MTCINE MTCTCE
LinITX.com - MultiThread Consultants
Get your MikroTik RBs and Training: http://linitx.com/brand/mikrotik
Official UK MikroTik Distributor
IRC chan: #routerboard on irc.z.je (IPv4 and IPv6)

Who is online

Users browsing this forum: AlexadreKlykov and 117 guests