Archive for the ‘Maintenance’ Category
Getting Rid Of MySQL Binary Logs
In: Database| Maintenance| MySQL
25 Jun 2009If you’re in charge of a mysql database that does any sort of volume, you might find yourself in the peculiar situation where your binary logs have piled up to an unmanageble level. Typically you’ll use the binary logs for replication from a master server to a slave. This may not always be the case [...]
- No Comments
- Tags: binary, binary logs, logs, master, MySQL, mysql master, MySql Slave, slave
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)
- longchamp: nordstrom http://jmultipleir-djjq.04FORDPARTS.US/tag/nordstrom+longchamp+purses/ : purses.. [...]
- r2: r2 http://eavedaspaxf.AUTOPARTSVILLE.INFO/tag/r2+Sap+Aveda/ : Sap... Aveda... [...]
- price: Microwave http://aemersonw0mq76.BEDROOMPROPERTY.INFO/tag/price+Emerson+Microwave/ : Emerson [...]
- projection: projection http://aprojectionvbt-i0.03GMCPARTS.US/tag/projector+projection+TV/ : projector. [...]
- Perfume: Perfume http://dnurserywclsbf.bestpartsstore.info/tag/pictures+Perfume+givenchy/ : Perfume. [...]