Search results for query: *

I am logging source / destination IP addresses and ports along with bytes, times etc (netflow) and I want to keep 30 days of data for up to 100 sites. I dumbed down the example table, all the data types are either int(32), int(16),tinyint(4) or varchar(16). The idea is that each branch manager...

I gave up on the idea of having mysql handle 750 million records because it obviously can't be done. If it could, it wouldn't be that hard to find a solution. I modified the process of data collection as towerbase had suggested but I was trying to avoid that because it it ugly. Thanks...

ok so the table partitioning looks promising. However, would it not be so much simpler to just split them into separate tables? I would rather do that, why am I the only one in the world that wants to do this? I must be missing something.

Well DonQ this is why I am asking. now to google 'table partitioning' :D

Sort of, sorry for not being clear. I need this done dynamically. Creating the tables manually is ok, but I am unable to write if statements because the device numbers could be anything (not just 1-100). So I need something like this... set _device_table = concat('table_',NEW.device) create...

Hi experts, I have a table that will potentially grow to 750 million records. To deal with this, I need to split the table into multiple tables via a trigger or something. Can anyone help with how to do that? I don't need line by line syntax or anything, just some general logic. Here is the...

The information I need is network traffic information from each of the senders, such as total amount of 'http' traffic, or smtp traffic etc. Behind each of them is a small network consisting of ~5 - ~50 users, and these devices monitor their internet usage basically. If I could split this large...

266 seconds is quicker than I thought! Still needs to be much quicker, because there could be multiple queries queuing up from multiple users :| Yes, I will be needing to upgrade my hardware (don't shoot me for running this on a virtual machine....) Thanks for looking at this Andrew.

Thanks for replying. At the moment there are only 4 devices sending data, and there are 30 million records for 30 days worth of data. I won't be keeping any more than 30 days, and I would expect no more than 100 devices. The table is simple... senderip, srcaddr...

Hi experts. I have a table that collects netflow traffic from multiple devices and it is MASSIVE. To be able to report on that in a timely manor I would like to split it up into separate tables based on the IP address of the sending device. The reason for this is because all the reports will...

Hey there I have just 4 ubuntu linux servers that are running on ESXi - postfix, mysql, web, ldap - which I would like to replicate to another site. I have a second site that I have bridged, so IP addressing can remain the same for simplicity. Ideally, I would like to replicate the Virtual...

hi all mac guys. i have a scenario where I have a mac domain with all mac servers and clients. I also have a new windows file server with direct attached storage. Is it possible to have the windows server join the mac domain and be able to authenticate mac users with their existing...

This is an atm interface, and has to authenticate the ppp session. I have been researching half-bridging, and this is what I need to use. On the dialer interface, the command ppp bridge ip enables half-bridging, but I haven't had any success yet. I only have 1 dynamic IP assigned by the isp. I...

I have a FortiGate firewall behind a cisco 857 router, and rather than double-nat I would like to be able to bridge the interfaces on the 857 so that the public IP terminates on the Fortigate firewall. Yes they want the firewall for web filtering. Is this possible? Surely it is. cheers all.

update: I set the compand-type to a-law and cptone to NZ. Getting full pages sometimes, half pages other times. cheers.

I have a uc520 with 2 BRI interfaces and 4 FXS interfaces. My fax line comes in on the BRIs, and the fax machine is hooked up to fxs port 0/0/0. when I test the fax, the fax machine picks up, but errors saying it can't detect a fax or unable to negotiate fax protocol. I need a direction to...

whykap, thanks for your help. all is well again, i restarted the server.

cheers. you are on the money. my phone and hunt groups registered successfully and i was able to forward my number through the server. I will try rebooting the subscriber on Saturday, or if I grow some balls I will do it this afternoon.

whykap, how do you manually register a hunt list?

OK I just checked RTMT under Database summary it says 392 replicates created for bot nodes, and replication status is 2 for both nodes. Is this enough to verify replication is ok? Sorry I am fairly new to CUCM. cheers.