Posts Tagged ‘Database’
Identifying Slow MySQL queries
In: Aashish| Linux| Monitoring| MySQL| Scripts
13 Feb 2010MySQL can sometimes create big problems on a server when you have users abusing it.
This article will teach you how to correctly identify the queries that are creating a problem for your server.
The Beauty of mysqlcheck
In: Database| Maintenance| MySQL| Repair
22 Jun 2009I manage a ton of mysql databases, from single wordpress instances, to clusters, to systems that have a core data structure that selectively replicates out to as many as 50 systems. Fortunately, or maybe not, they seldom have issues and after setup, other than disk space issues, I seldom have to touch them.
Recently, as I [...]
When to use MySQL BlackHole Tables
In: Database| Maintenance| MySQL
14 Jun 2008We read about the black hole table type a long time ago and it’s kind of been a running joke – why in the hell would somebody want to insert into a black hole? Many times it’s been suggested as the solution to all of our data problems… Just swap out all the InnoDB [...]
Recent Posts
Categories
- Aashish (11)
- Amazon (1)
- apache (3)
- Audio (1)
- Backup (2)
- Bushan (1)
- centos (2)
- cluster (1)
- Database (4)
- Education (3)
- Hack Admin (1)
- Hardware (1)
- iptables (2)
- Key Strokes (1)
- Khaled (3)
- LDAP (1)
- Linux (23)
- Maintenance (5)
- Monitoring (2)
- MySQL (9)
- Network (5)
- OpenVPN (1)
- Repair (2)
- Replication (2)
- S3 (1)
- Scripts (4)
- Security (5)
- Software (3)
- TCP/IP (5)
- ubuntu (7)
- Windows (1)
- Workaround (3)
- HARRY: [...]
- JEREMY: [...]
- JACKIE: [...]
- nathaniel: [...]
- HUBERT: [...]