domstat.net

Website loading time

during the test: 1.32 s

cable connection (average): 1.59 s

DSL connection (average): 1.87 s

modem (average): 16.29 s

HTTP headers

HTTP/1.0 200 OK

Date: Sat, 15 Oct 2011 07:50:16 GMT

Server: Apache

X-Pingback: http://mysqlhacker.com/xmlrpc.php

Connection: close

Content-Type: text/html

Information about DNS servers

Received from the first DNS server

Request to the server "mysqlhacker.com"
You used the following DNS server:
DNS Name: dns4.name-services.com
DNS Server Address: 98.124.194.1#53
DNS server aliases:

HEADER opcode: REQUEST, status: NOERROR, id: 47621
flag: qr aa rd REQUEST: 1, ANSWER: 7, AUTHORITY: 0, ADDITIONAL: 0

REQUEST SECTION:
mysqlhacker.com. IN ANY

ANSWER SECTION:
mysqlhacker.com. 3600 IN NS dns5.name-services.com.
mysqlhacker.com. 3600 IN SOA dns1.name-services.com. info.name-services.com. 2002050701 10001 1801 604801 181
mysqlhacker.com. 3600 IN NS dns2.name-services.com.
mysqlhacker.com. 3600 IN A 66.60.178.149
mysqlhacker.com. 3600 IN NS dns1.name-services.com.
mysqlhacker.com. 3600 IN NS dns3.name-services.com.
mysqlhacker.com. 3600 IN NS dns4.name-services.com.

Received 199 bytes from address 98.124.194.1#53 in 77 ms

Received from the second DNS server

Request to the server "mysqlhacker.com"
You used the following DNS server:
DNS Name: dns5.name-services.com
DNS Server Address: 98.124.196.1#53
DNS server aliases:

HEADER opcode: REQUEST, status: NOERROR, id: 10048
flag: qr aa REQUEST: 1, ANSWER: 7, AUTHORITY: 0, ADDITIONAL: 5

REQUEST SECTION:
mysqlhacker.com. IN ANY

ANSWER SECTION:
mysqlhacker.com. 3600 IN A 66.60.178.149
mysqlhacker.com. 3600 IN SOA dns1.name-services.com. info.name-services.com. 2002050701 10001 1801 604801 181
mysqlhacker.com. 3600 IN NS dns1.name-services.com.
mysqlhacker.com. 3600 IN NS dns2.name-services.com.
mysqlhacker.com. 3600 IN NS dns3.name-services.com.
mysqlhacker.com. 3600 IN NS dns4.name-services.com.
mysqlhacker.com. 3600 IN NS dns5.name-services.com.

SECTION NOTES:
dns1.name-services.com. 3600 IN A 98.124.192.1
dns2.name-services.com. 3600 IN A 98.124.197.1
dns3.name-services.com. 3600 IN A 98.124.193.1
dns4.name-services.com. 3600 IN A 98.124.194.1
dns5.name-services.com. 3600 IN A 98.124.196.1

Received 299 bytes from address 98.124.196.1#53 in 8 ms

Subdomains (the first 50)

Typos (misspells)

Location

IP: 66.60.178.149

continent: NA, country: United States (USA), city: Rocklin

Website value

rank in the traffic statistics:

There is not enough data to estimate website value.

Basic information

website build using CSS

code weight: 104.76 KB

text per all code ratio: 66 %

title: mysqlhacker — mysql> SELECT Hacks, Tips, Tricks FROM projects;

description:

keywords:

encoding: UTF-8

language: en

Website code analysis

one word phrases repeated minimum three times

two word phrases repeated minimum three times

three word phrases repeated minimum three times

B tags

U tags

I tags

images

headers

H1

H2

MySQLHacker.com

Removing Forieign Key Constraints Using phpMyAdmin

Wget mysqltuner.pl

Changing Default MySQL Temp Dir from /tmp to someting else

A Practical SPEED-UP Story for Large MySQL Installation

Background

Investigating the Source of the Problem: Traffic Management

The Solution: Simulate Replicated Environment

Freeing Disk Space from MyISM Table Space

MySQL Blocked Becauase of Too Many Connections

Debugging a MySQL Issue with PHP Using XMP instead of PRE

Using mysqladmin for monitoring MySQL server (Part I)

Increasing the Memory Size for Memory Tables

Exporting (dumping) VIEWs Using mysqldump

Understanding MySQL Query Cache for PHP Developers (Part I)

Using SQL Directives to Control Query Performance

Using mytop to Interactively Monitor MySQL Processes

Backing Up MySQL Using a BASH Shell Script

Calculating Maximum Connections for MySQL Server

Beware of MySQL View Filtering in Your PHP Code

Using SHOW FULL PROCESSLIST to Debug PHP Query

Keeping Your Database “Fresh” Using MERGE Engine

Distributing Your MySQL Database Across Disk Partitions

Backing Up a Live MySQL Database without Locking it!

Solution

Reclaiming Your InnoDB Tablespace

Automatically Loading MySQL Memory Tables on MySQL Startup or Reboot

Speeding Up ZenCart with MySQL Memory Tables

Understanding Useful Table Engine Types

H3

MySQLHacker.com

Removing Forieign Key Constraints Using phpMyAdmin

Wget mysqltuner.pl

Changing Default MySQL Temp Dir from /tmp to someting else

A Practical SPEED-UP Story for Large MySQL Installation

Background

Investigating the Source of the Problem: Traffic Management

The Solution: Simulate Replicated Environment

Freeing Disk Space from MyISM Table Space

MySQL Blocked Becauase of Too Many Connections

Debugging a MySQL Issue with PHP Using XMP instead of PRE

Using mysqladmin for monitoring MySQL server (Part I)

Increasing the Memory Size for Memory Tables

Exporting (dumping) VIEWs Using mysqldump

Understanding MySQL Query Cache for PHP Developers (Part I)

Using SQL Directives to Control Query Performance

Using mytop to Interactively Monitor MySQL Processes

Backing Up MySQL Using a BASH Shell Script

Calculating Maximum Connections for MySQL Server

Beware of MySQL View Filtering in Your PHP Code

Using SHOW FULL PROCESSLIST to Debug PHP Query

Keeping Your Database “Fresh” Using MERGE Engine

Distributing Your MySQL Database Across Disk Partitions

Backing Up a Live MySQL Database without Locking it!

Solution

Reclaiming Your InnoDB Tablespace

Automatically Loading MySQL Memory Tables on MySQL Startup or Reboot

Speeding Up ZenCart with MySQL Memory Tables

Understanding Useful Table Engine Types

H4

Is your MySQL server alive and kicking?

Is Your MySQL server about to Lock Up?

Step 1: What is your current maximum memory allocation for memory tables?

Step 2: Change /etc/my.cnf to set custom memory allocation size for memory tables

Step 3: Restart MySQL and verify the new allocation is effective or not

Delay that INSERT Query

Slow Down that Update Query

Slow Down Your DELETE Query

Control Caching that SELECT Query

Step 1: Installing mytop pre-requisites

Step 2: Installing mytop

Step 3: Using mytop

Step 1: Setting up mysql_backup.sh on a backup server

Step 2: Granting MySQL access to your backup server

Step 3: Running for the first time

Step 4: Setting up a cron job to run it every night

Step 5: Checking the log

Step 1: Backup your /etc/my.cnf file

Step 2: Prepare for many connections

H5

H6

internal links

external links