queries

How Internet Browse Time Reports works in Websense

Calculating a user’s Internet browse time is challenging, because it is difficult to determine whether the user is actually reading the page, just opening or closing the browser, performing another task in a different application with the browser open, or possibly away from the desk entirely with the browser open. Websense software makes a reasonable [...]

How to skip duplicate replication errors in MySQL

Normally MySQL replication will stop whenever there is an error running a query on the slave. This happens in order for us to be able to identify the problem and fix it, and keep the data consistent with the mater that has sent the query. You can skip such errors, even if this is not recommended, as [...]

How can I speed up facet counts in Solr

Performance problems can arise when faceting on fields/queries with many unique values. If you are faceting on a tokenized field, consider making it untokenized (field classsolr.StrField, or using solr.KeywordTokenizerFactory). Also, keep in mind that Solr must construct a filter for every unique value on which you request faceting. This only has to be done once, [...]

How to Configure Windows Server 2003 DNS Service

To configure the Windows Server 2003 DNS service by using the Configure DNS Server Wizard, follow these steps: Click Start, point to Administrative Tools, and then click DNS to open the DNS MMC snap-in. In the navigation pane, click the DNS Server object for your server, right-click the server object, and then click Configure a [...]

How to Monitor MySQL’s performance

Here are some ideas, how you can monitor the database performance of your MySQL installation. Monitoring is always an iterative and continuous process. You need to learn what patterns are OK for your database and what are the signs of slight problems or even dangerous situations. Below are the main items you can use to [...]

How to Use Nslookup to query Domain Name System

nslookup is a computer program used in Windows and Unix to query Domain Name System (DNS) servers to find DNS details, including IP addresses of a particular computer, MX records for a domain and the NS servers of a domain. The name nslookup means “name server lookup”. The most common version of the program is [...]

How to Create tables in Mysql – PHP & MySQL Code

Before you can enter data (rows) into a table, you must first define what kinds of data will be stored (columns). We are now going to design a MySQL query to summon our table from database land. In future lessons we will be using this table, so be sure to enter this query correctly! PHP [...]

Single Google Query uses 1000 Machines in 0.2 seconds

Google is normally quite secretive about their search infrastructure but, in a break from tradition, they have revealed that a single search query on Google can consume the processing power of 1000 machines. Google Fellow Jeff Dean, in a keynote talk at WSDM 2009, shared some numbers about Google’s impressive growth run from 1999 to [...]

How to Access The MySQL Command Line

MySQL has its own command line interpreter (CLI). You need to know how to access it to do very basic administration. You can access the MySQL CLI using the mysql command followed by the -u option for the username and -p, which tells MySQL to prompt for a password. Here user root gains access: [root@bigboy [...]

How to change SQL Server Instance Name?

Each instance of SQL Server consists of a distinct set of services that have specific settings for collations and other options The directory structure, registry structure, and service names all reflect the instance name and a specific instance ID created during SQL Server Setup. An instance is either the default instance or a named instance. [...]

How to Use the Grep Command – A brief to Grep Command

One of the problems with writing an entry on the grep command is that it’s so invloved. Grep is a “take it or leave it” command. By that I mean that it can be used easily and quickly with few options, or it can be used with jedi-like mastery. You can basically get as involved [...]

How to to configure BIND9 in Ubuntu

There a many ways to configure BIND9. Some of the most common configurations are a caching nameserver, primary master, and a as a secondary master. When configured as a caching nameserver BIND9 will find the answer to name queries and remember the answer when the domain is queried again. As a primary master server BIND9 [...]

Howto Create a DNSBL to Black Lists well known sources of SPAM

Black Lists are used in the context of email to define the IP addresses or netblocks of well known sources of SPAM. DNSBL defines a method of using standard DNS zone files to store such IP addresses. Standard DNS A RR queries are used to interrogate the black list which is organised as a reverse [...]