By: Rick James
Mar 2012
- Re: mysqld got signal 6 (problem why bigger than I initially realised)
- Re: New Fast MySQL Compatible Server
- Re: mysqld got signal 6 (problem why bigger than I initially realised)
- Re: mysqld got signal 6 (problem why bigger than I initially realised)
- Re: HA & Scalability w MySQL + SAN + VMWare: Architecture SuggestionWanted
Apr 2012
- Re: MySQL Multi-Master Replication
- Re: HA & Scalability w MySQL + SAN + VMWare: Architecture SuggestionWanted
- Re: create multiple tables in a single query
- Re: Innodb Table Gets Locked while Drop
- RE: forcing mysql to use batched key access (BKA) optimization forjoins
- RE: Why does the limit use the early row lookup.
- RE: problems with INNODB tables
- RE: Why does the limit use the early row lookup.
- RE: Why does the limit use the early row lookup.
- RE: Postal code searching
- RE: Why does the limit use the early row lookup.
- RE: engine is now innoDB instead of MyISAM.
- RE: update query
May 2012
- RE: MySQL Crash when Open_files reach 128
- RE: RFE: Allow to use version-specific my.cnf files
- RE: Can the mysql replication limited to one database
- RE: problems with INNODB tables
- RE: Can the mysql replication limited to one database
- RE: Can the mysql replication limited to one database
- RE: Can the mysql replication limited to one database
- RE: master BIN-LOG maintenace
- RE: using the bin-log approach on the master side, how can Iaccomplish my replication objectives
- RE: mixing and matching mysql & mssql whileloop within an if case
- RE: Myisam won't support replication
- RE: Why is creating indexes faster after inserting massive datarows?
- RE: 回复： Why is creating indexes faster after inserting massive data rows?
- RE: One table gets locked by itself
- RE: 回复： Why is creating indexes faster after inserting massive data rows?
- RE: 回复： 回复： Why is creating indexes faster after inserting massive data rows?
- RE: drop partitions
- RE: How to quickly detect if there are any crashed tables
- RE: drop partitions
- RE: MySQL Community Server 5.1.63 has been released
- RE: drop partitions
- RE: Deadlock due lockwait. How can I tell mysql to wait longer?
- RE: MySQL Community Server 5.1.63 has been released
- RE: Foreign key and uppercase / lowercase values
- RE: Query help,,,
- RE: create alias for columns bound to database?
- RE: create alias for columns bound to database?
- RE: Reducing ibdata1 file size
- RE: Need help for performance tuning with Mysql
- RE: large temp files created by mysql
- RE: Need help for performance tuning with Mysql
- RE: Architectural Help
- RE: sort order
- RE: Architectural Help
- RE: Mysql starts to die at 27 SQL processes
Jun 2012
- RE: NoSQL help
- RE: i need advice on redundancy of mysql server.
- RE: Minor collation question
- RE: Foreign key and uppercase / lowercase values
- RE: NoSQL help
- RE: NoSQL help
- RE: Is there any performance difference, maintaining separateibdata files for each and every table insted of having one singl tabale forall databases.
- RE: Foreign key and uppercase / lowercase values
- RE: Which Database when lot of insert / update queries to execute
- RE: Foreign key and uppercase / lowercase values
- RE: mysqldump not escaping single quotes in field data
- RE: optimize DB - bad experience
- RE: Need Query Help
- RE: Indexing about 40 Billion Entries
- RE: Indexing about 40 Billion Entries
- RE: Indexing about 40 Billion Entries
- RE: Indexing about 40 Billion Entries
- RE: UNION and ORDER BY
- RE: Triggers and column names
Jul 2012
- RE: Composite Index Usage in Joins
- RE: Unique index - opinions sought
- RE: mysql - uppoer limit for doing simultaneous red/writes..
- RE: why this query doesn't use index?
- RE: Unique index - opinions sought
- RE: MySQL crashed..
- RE: Fwd: Query take too long time - please help!
- RE: Trouble with Average
- RE: GA download reverted back to 5.5.24?
- RE: Subquery taking too much time on 5.5.18?
- RE: Subquery taking too much time on 5.5.18?
- RE: alternative to slow query
- RE: Trouble with Average
- RE: GA download reverted back to 5.5.24?
- RE: Looking for consultant
- RE: Reading in NA's into a column with Decimal datatype
- RE: Disable DB without deleting data
- RE: YEAR and time types
- RE: restrict Connect Time
- RE: mysqlimport --use-threads / mysqladmin processlist
- RE: How often the slave to pull data from master?
Aug 2012
- RE: query help
- RE: How often the slave to pull data from master?
- RE: How often the slave to pull data from master?
- RE: how to replace this data in a complex field?
- RE: create roles/groups in MYSQL
- RE: Replication setup hep
- RE: manage mysql-bin.xxxxxx files on mac
- RE: Strange Replication Behavior
- RE: About character_set_*
- RE: changing mySQL table name screws phpMyAdmin?? reverting changefixes??
- RE: Hi, how did u do de-emphasis of sql statements?
- RE: Best design for a table using variant data
- RE: MySQL LDAP Authentication Plugin - Full example with source code
- RE: help with correlated subquery
- RE: help with correlated subquery
- RE: view query is slow
- RE: Replication question: How to make a slave a master?
- RE: Replication question: How to make a slave a master?
- RE: MySQL, UTF8 and collations
- RE: MySQL, UTF8 and collations
- RE: qcache settings and block meaning
- RE: qcache settings and block meaning
Sep 2012
- RE: Aggregate
- RE: Understanding Slow Query Log
- RE: Understanding Slow Query Log
- RE: Understanding Slow Query Log
- RE: Create a VIEW with nested SQL
- RE: Create a VIEW with nested SQL
- RE: query help
- RE: function INTERVAL in view
- RE: Making myself crazy...
- RE: Older mysql client with newer server compatibility
- RE: Are Single Column Indexes are sufficient
- RE: getting certain rows from a group by
- RE: getting certain rows from a group by
- RE: getting certain rows from a group by
- RE: InnoDB vs. other storage engines
- RE: Making myself crazy...
- RE: getting certain rows from a group by
- RE: Making Myself Crazy
- RE: mysql is eating up lot of CPU and memory
- RE: Partitioning on a Substring of Varchar Column in Mysql
- RE: Default Values for Max User and Max Connections.
- RE: Risks involved in MyISAM to Innodb
- RE: How to block SELECT * FROM table; but not SELECT * FROMT tableWHERE...;
- RE: [ask] count items in the SET(value1,value2,value3)
- RE: user not able to login from localhost
- RE: Doubt Regd. Circular Replication In Mysql
- RE: Need Help Converting Character Sets
- RE: checking progress of alter table on a MyISAM table
- RE: i am running mysqlrepair on 80G myisam table.
- RE: checking progress of alter table on an InnoDB table (Was: Re:checking progress of alter table on a MyISAM table)
- RE: Need Help Converting Character Sets
Oct 2012
- RE: Need Help Converting Character Sets
- RE: Accessing Column Aliases In Other Columns?
- RE: InnoDB corrupt after power failure
- RE: InnoDB corrupt after power failure
- RE: user last activity and log in
- RE: mysql 5.5.24/27 massive slow down since upgrade to solaris 10u9 with 147440-19
- RE: date-IFNULL-sum bug?
- RE: Query Cache Crashing
- RE: Slow queries / inserts InnoDB
- RE: innodb_lock_wait_timeout
- RE: column aliases in query
- RE: RE: innodb_lock_wait_timeout
- RE: Extract text from string
- RE: mysql logs query with indexes used to the slow-log and notlogging if there is index in reverse order
- RE: mysql logs query with indexes used to the slow-log and notlogging if there is index in reverse order
- RE: mysql logs query with indexes used to the slow-log and notlogging if there is index in reverse order
- RE: Can I measure the use of index?
- RE: Unexpected gradual replication log size increase.
- RE: error 13
- RE: Odd Behavior During Replication Start-Up
- RE: Schemas for storing and reporting on hashtags
- RE: Help with purging old logs for each customer ID
- RE: Replication Question
- RE: Help with purging old logs for each customer ID
- RE: MySQL Monitor and Percona
- RE: MySQL Monitor and Percona
- RE: what is stored in /var/lib/mysql_log/ ?
- RE: index & innodb
- RE: what is stored in /var/lib/mysql_log/ ?
Nov 2012
- RE: Mysql backup for large databases
- RE: Mysql backup for large databases
- RE: MySQL Thread Pool Plugin + Percona Server?
- RE: Change storage engine to InnoDB
- RE: How to verify mysqldump files
- RE: Dynamic crosstab got me lost.
- RE: query tuning
- RE: query tuning
- RE: Query Optimization
- RE: Change storage engine to InnoDB
- RE: Innodb, MySQL 5.5.28 - Would an incorrect setting in my.cnfcause mysqld to randomly crash on high load?
- RE: Query Plan Analyzer
- RE: Update One of Three tables in a single query
- RE: Retrieve the values from the table of its max date
- RE: MySQL Replication Error
Dec 2012
Jan 2013
- RE: Query Resulting error
- RE: questions about group_concat_max_len
- RE: InnoDB interaction between secondary and primary keys.
- RE: InnoDB interaction between secondary and primary keys.
Feb 2013
- RE: Can't drop table after crash
- RE: Question about Innodb
- RE: Mysqldump routines dump, problem with lock tables.
- RE: IF and CASE
- RE: file level encryption on mysql
- RE: Upgrading form mysql 5.0.90 to 5.5 or 5.6
- RE: slave replication with lots of 'duplicate entry' errors
- RE: Upgrading form mysql 5.0.90 to 5.5 or 5.6
- RE: slave replication with lots of 'duplicate entry' errors
- RE: Upgrading form mysql 5.0.90 to 5.5 or 5.6
- RE: Upgrading form mysql 5.0.90 to 5.5 or 5.6
- RE: MyISAM table size vs actual data, and performance
- RE: MySQL 5.1: incorrect arithmetic calculation
- RE: replication fails after upgrade to 5.6
- RE: data loss due to misconfiguration
Mar 2013
- RE: MySQL Cluster Solution
- RE: auto_increment field behavior
- RE: auto_increment field behavior
- RE: How to return resultset from MySQL Stored Procedure usingprepared statement?
- RE: Blob implementation question
- RE: Retrieve most recent of multiple rows
- RE: a little doubt on text about MySQL
- RE: mysql cluster and auto shard
- RE: How to change max simultaneous connection parameter in mysql.
- RE: MySQL Error#: 2002
- RE: How to change max simultaneous connection parameter in mysql.
- RE: How to change max simultaneous connection parameter in mysql.
- RE: Defragmentation of MySQL tables, how many times have I to do it?
Apr 2013
- RE: How to change max simultaneous connection parameter in mysql.
- RE: How to change max simultaneous connection parameter in mysql.
- RE: How to change max simultaneous connection parameter in mysql.
- RE: Determing number of queries
- RE: Update and lock question.
- RE: MySQL on RHEL4
- RE: How to tweek the max connections
- RE: Mesaure query speed and InnoDB pool
- RE: Mesaure query speed and InnoDB pool
- RE: Mesaure query speed and InnoDB pool
- RE: Troubleshoot excessive memory usage in InnoDB
- RE: Troubleshoot excessive memory usage in InnoDB
- RE: how to list record in column (instead of a row)
- RE: Performance of delete using in
- RE: MySQL Cluster or MySQL Cloud
- RE: Long integer constant problem in views
- RE: Rookie question
May 2013
- RE: Adding language support to tables
- RE: Chain Replication QUestion
- RE: Slow Response -- What Does This Sound Like to You?
- RE: Slow Response -- What Does This Sound Like to You?
- RE: Slow Response -- What Does This Sound Like to You?
- RE: Triggers
- RE: Dropping column/index from MyISAM table increases disk spacewithout calling "optimize"
- RE: fragmentation in innodb tables
- RE: Mysql server - which filesystem to choose? Is it really thatimportant nowadays?
- RE: Version 5.6.2-m5 Boolean Datatype
- RE: Bug in BETWEEN same DATETIME
- RE: Bug in BETWEEN same DATETIME
- RE: Bug in BETWEEN same DATETIME