tnt.aufbix.org mysql

mysql:backup

anonymous@undisclosed.example.com (Anonymous) — Sat, 30 Jan 2010 13:33:07 +0000

FIXME FIXME FIXME * * * * How To Back Up MySQL Databases With mylvmbackup * Back Up (And Restore) LVM Partitions With LVM Snapshots How To Back Up MySQL Databases With mylvmbackup * - is a Perl script for quickly creating MySQL backups. It uses LVM's snapshot feature to do so. To perform a backup, my…

mysql:custer-data-tables

anonymous@undisclosed.example.com (Anonymous) — Tue, 23 Feb 2010 09:54:36 +0000

STLYLING How Disk Data Tables work A set of UNDO logs and data files can be created which are on every data node in the cluster. The UNDO logs bring the disk data back to a consistent point so that during node restart the REDO logs can be replayed when a node is started.

mysql:error-codes

anonymous@undisclosed.example.com (Anonymous) — Thu, 17 May 2012 08:38:45 +0000

mysql:optimization

anonymous@undisclosed.example.com (Anonymous) — Thu, 11 Feb 2010 20:25:24 +0000

wget -q http://maatkit.org/get/mk-query-digest perl mk-query-digest /var/log/mysql/mysql-slow.log

mysql:replication

anonymous@undisclosed.example.com (Anonymous) — Mon, 25 May 2009 00:35:02 +0000

MySQL replication * How to repait MySQL replication mysql> SHOW SLAVE STATUS \G ... Replicate_Wild_Ignore_Table: Last_Errno: 1146 Last_Error: Error 'Table 'mydb.taggregate_temp_1212047760' doesn't exist' on query. Default database: 'mydb'. Query: 'UPDATE thread AS thread,taggregate_temp_1212047760 AS aggregate SET thread.views = thread.views + aggregate.views WHERE thread.threadid = aggregate.threadid' ...

mysql:scripts

anonymous@undisclosed.example.com (Anonymous) — Mon, 25 May 2009 00:35:02 +0000

Pretty InnoDB Buffer Pool Stats Now I can quickly see buffer pool stats in the following format: buffer pool size: 27999076352 bytes (27G) used: 16563568640 bytes (16G) (59.00%) modified db pages: 4747952128 bytes (4G) (16.00%) Kill every MySQL SELECT older than X seconds

mysql:security_tips

anonymous@undisclosed.example.com (Anonymous) — Thu, 03 Jan 2013 09:09:28 +0000

MySQL Security tips Never store the MySQL ‘root’ user password in a ~root/.my.cnf file. Do you need to store a MySQL password in a file? Yes. Connection management for your application is an example, however that use should never be ‘root’ user to connect to your application. You may also need to run scripts to backup your data with mysqldump. The solution is to create a dedicated user .e.g. ‘backup’, and then grant that user only the permissions necessary to do the specific task at hand. By d…

mysql:sidebar

anonymous@undisclosed.example.com (Anonymous) — Sat, 17 Apr 2010 00:46:52 +0000

MySQL * MySQL * Useful scripts * Replication * MySQL tunning * MySQL Error Codes * MySQL backup * SQL Optimization * Securing MySQL * custer-data-tables elsewhere * How To Set Up A Load-Balanced MySQL Cluster With MySQL 5.1 * Sundry MySQL Scripts and Docs * Mysqltuner * Converting 4.0 Character Columns to 4.1 Format * MySQL Forge Wiki * Zmanda Open Source backup * Zmanda Wiki * InnoDB hot backup * Percona adds enhancements to the MySQL server code and re…

mysql:troubles

anonymous@undisclosed.example.com (Anonymous) — Mon, 25 May 2009 00:35:02 +0000

MySQL quick troubleshoting Corruption Can't open file: 'table.MYI' (errno: 145) try mysql -p dbname dbhost > repair table or run this in command line myisamchk -r

mysql:tunning

anonymous@undisclosed.example.com (Anonymous) — Sat, 01 Jan 2011 19:16:59 +0000

MySQL tunning See also: * Tuning a MySQL server in 5 minutes 3 Minute MySQL (tuning) * max_connections - set to the same (or a little bigger than) as MaxChildren from apache if you’re only using one mysql connection per request (this is most common) * key_buffer_size - Set to roughly half your available ram.