By: Baron Schwartz
Oct 2006
Apr 2007
- Why is the Falcon license listed as 'PROPRIETARY' in 5.2.3?
- Re: Replication among disconnected Servers
- Re: Query needed for this sol.
- Re: Revoking Privileges
- Re: Query Question
- Re: Query Question
- Re: creating a function in mysql
- Re: a little user rights help?
- Re: MySQL slave error when creating view
- Re: Is an index on varchar column efficient?
- Re: Query Question
- Re: replace / insert into with sum not working
- Re: How could write this SQL
- Re: ORDER BY multiple columns
- Re: Possible Replication Issue?
- Re: Possible Replication Issue?
- Re: what kind of indices to set up
- Re: My bin.log directory is getting full
- Re: Interesting SQL Query - Total and Grouped Counts together?
- Re: Bin logs and mysql 4
- Re: Bin logs and mysql 4
- Re: Bin logs and mysql 4
- Re: Transpose
- Re: InnoDB table lock on INSERT
- Re: status variables Table_Locks_*
May 2007
- Re: Need help with query
- Re: IS NULL Question
- Re: View select results
- Re: expire_logs_days
- Re: expire_logs_days
- Re: expire_logs_days
- Re: Enforcing Data Format
- Re: Less | More
- Re: expire_logs_days
- Re: Order By and Ignore Punctuation
- Re: How do I find products when a user types freeform strings like'Sony 20" TV' or '20" Sony TV'?
- Re: expire_logs_days
- Re: expire_logs_days
- Re: Can't find file: 'general_log'
- Re: Can't find file: 'general_log'
- Re: expire_logs_days
- Re: indexing order column
- Re: indexing order column
- Re: How do I find products when a user types freeform strings like'Sony 20" TV' or '20" Sony TV'?
- Re: slave replication fails, cannot create user
- Re: slave replication fails, cannot create user
- Re: Error message on trying to start service
- Re: Help with Query
- Re: Deleted Root Account
- Re: duplicating a replicated slave environment
- Re: duplicating a replicated slave environment
- Re: finding next and prev record in mysql
- Re: finding next and prev record in mysql
- Re: Query Cache Behavior
- Re: finding next and prev record in mysql
- Re: BLOB Storage question
- Re: SELECT statement returning columns for a given table?
- Re: Network address functions in MySQL?
- Re: Network address functions in MySQL?
- Re: Create Foreign Key Issue
- Re: Problem with GRANT ... 'user'@'%'
- Re: speedup mysql restore
- Re: Problem with GRANT ... 'user'@'%'
- Re: Problem with GRANT ... 'user'@'%'
- Re: spool command to file.
- Re: spool command to file.
- Re: spool command to file.
- Re: Mysql and Textarea
- Re: Help with Migration/Foreign Key
- Re: Help with Migration/Foreign Key
- Re: problem with timestamp data type
- Re: Need confirmation: Subselects are broken with regards to indexusage?
- Re: How to get the table.column in mysql client tab completion? Orfeature request to add this.
- Re: do I need 2 selects?
- Re: Table compression with write (append) support
- Re: row lock
- Re: CSV import
- Re: Tellico and MySQL
- Re: General Questions About Indexes
- Re: Strange result from multiple JOIN
- Re: Exporting Data To File and Can't Create/Write to File
- Re: Strange result from multiple JOIN
- Re: selecting the last and second last id's
- Re: using tinymce and inserting the contents in a database
- Re: datetime type conversion problem
- Re: index not used
- Re: doubt about indexes
- Re: FLUSH TABLE LOCK READ
- Re: selecting second last row
- Re: Does mysql support groups?
- Re: FLUSH TABLE LOCK READ
- Re: mysql creating lots of processes (not threads, linux processes)
- Re: Redirecting all queries to mysql dababase to another instance
- Re: Trigger question
- Re: mysql old 4.* query fails on 5.*
- Re: Moving Data between Tables
Jun 2007
- Re: Padding result
- Re: Padding result
- Re: error while doing a select
- Re: Server/Client connection compression
- Re: Find and Add Unmatched Records
- Re: Find and Add Unmatched Records
- Re: high physical and buffer reads.
- Re: Using the last_insert_id() function
- Re: Exporting blob / text column with hyphen delimited text
- Re: Stable mysql 4.xx
- Re: Obtaining the first or second instance of an event
- Re: Stable mysql 4.xx
- Re: External Program Execution
- Re: Data migration Verification
- Re: Lock Tables Question
- Re: Diff between restore from tar and recover from power outage
- Re: privileges and deleting from tables
- Re: privileges and deleting from tables
- Re: Figuring out the difference in value between 2 fields
- Re: explain
- Re: Select and COUNT
- Re: String Locks
- Re: Advanced Indexing
- Re: MYSQL data replication
- Re: repairing/verifying tables
- Re: Select and COUNT
- Re: Arbitrary Boolean Functions as Relational Database Structure?
- Re: Add column from another table
- Re: MYSQL data replication
- Re: perl DBI does not do execute mysql statement
- Re: Access Denied When Trying to Create Database
- Re: Access Denied When Trying to Create Database
- Re: Insert into multiple tables using auto_increment reference
- Re: Translation of sql into mysql
- Re: MySQL upgrade from 5.0.32 to 5.0.42 broke replication
- Re: syntax to revoke
- Re: syntax to revoke
- Re: syntax to revoke
- Re: syntax to revoke
- Re: MySql Host through Heartbeat
- Re: MySql Host through Heartbeat
- Re: MySql Host through Heartbeat
- Re: Error 2013 (Lost Connection to MySQL Server) On A Solaris 10Box
- Re: date function question
- Re: Create Table Warning
- Re: [Q] event for client?
- Re: Before I shoot myself in the foot...
- Re: Before I shoot myself in the foot...
- Re: Before I shoot myself in the foot...
- Re: Change in behaviour in version 5.0.41
- Re: Hiding columns used in GROUP BY and HAVING clauses
- Re: mysqldump problem with large innodb tables...
- Re: mysqldump problem with large innodb tables...
- Re: mysqldump problem with large innodb tables...
- Re: mysqldump problem with large innodb tables...
- Re: Hiding columns used in GROUP BY and HAVING clauses
- Re: Change in behaviour in version 5.0.41
- Re: Hiding columns used in GROUP BY and HAVING clauses
- Re: mysqldump problem with large innodb tables...
- Re: KEY vs. INDEX
- Re: Storing a linked list
- Re: Getting list of queries run against a database
- Re: Getting list of queries run against a database
- Re: master status is null
- Re: can mysql use an index where like used
- Re: can mysql use an index where like used
- Is there a way to tell the type of a value?
- Re: How do you allow external computers to access server instance?
Jul 2007
- Re: zipcode to timezone
- Re: Full Text Search, Storage Engine Types
- Re: Recursive queries
- Re: Dynamic ORing
- Re: User variables in update statement
- Re: how to stop replication at a specific position?
- Re: giving a row the new highest id
- Re: giving a row the new highest id
- Re: starting a second slave from a first slave's dump
- Re: Query against two data types
- Re: monitoring mysql
- Re: Hanging Database
- Re: Hanging Database
- Re: slave backups & master data
- Re: replicating from multiple masters
- Re: speeding imports
- Re: when should I start master's binlog?
- Re: speeding imports
- Re: SQL LINKING TABLE Command
- Re: replication error with system's "mysql" db
- Re: Mysql monitering and performance tool
- Re: Extract String only from varchar Field?
- Re: Mysql monitering and performance tool
- Re: Mysql monitering and performance tool
- Re: Mysql monitering and performance tool
- Re: Best way to backup three live databases
- Re: [mysql] crosstabs
Aug 2007
- Re: KEEPING 3 MONTHS DATA ON SERVER AND ARCHIVE ALSO
- Re: question on replication
- Re: Complex query
- Re: Update error on ver 3.23, works on ver 5.0
- Re: KEEPING 3 MONTHS DATA ON SERVER AND ARCHIVE ALSO
- Re: How can I delete a block of random rows?
- Re: adding an index to a very large table (hours and hours??)
- Re: HOW QUERIES WORK
- Re: date query
- Re: date query
- Re: Scheduled events
- Re: Scheduled events
- Re: Slow query involving ORDER BY
- Re: run out of memory
- Re: Problem with a complex query
- Re: Query cache problem with stored procedures
- Re: Replication problem
- Re: A select for a game ranking page.
- Re: Why is the average of an int column returned as a string
- Re: Column type suggestions
- Re: Synchronizing two MySQL servers over slow network
- Re: [MYSQL]Time formatting for cycle time.
- Re: bitwise logic
- Re: mysql-table-checksum with mixed storage enginges
- Re: Unknown column error after upgrading from 4.0 to 5.0
- Re: innodb engine status
- Re: Two/more seperately unique columns in a table?
- Re: JOIN migration from Oracle to MySQL
Sep 2007
- Re: servers full potential / FT searches locking tables
- Re: finding count of spaces in a string
- Re: SQL injection?
- Re: Editing fields in bulk
- Re: transaction problem
- Re: Delete query question
- Re: Slow MySQL Table Inserts
- Re: Fulltext Index / Index .. both?
- Re: table based replication into a different db
- Re: Big SELECT: ordering results by where matches are found
- Re: Big SELECT: ordering results by where matches are found
- Re: Really strange index/speed issues
- Re: Implement a logging table; avoiding conflicting inserts
- Re: Really strange index/speed issues
- Re: Copying InnoDB files to remote server -> remote server won'tstart
- Re: Copying InnoDB files to remote server -> remote server won'tstart
- Re: Does this MySQL client exist?
- Re: Does this MySQL client exist?
- Re: Does this MySQL client exist?
- Re: DIAGNOSTIC MYSQL
- Re: adress stored as an array
- Re: query using connected username
- Re: REVOKE ERROR
- Re: [mysql] duplicating lines
- Re: The current version is 5.0.48, no?
- Re: Performance Problems With JOINS - Tunnng required or upgradehardware?
- Re: modify default value
- Re: Lock is Always Free
- Re: excessive time spent in "statistics" status
- Re: Rollback on a Transaction with No Updates
- Re: Slave Misbehavin'
- Re: Rollback on a Transaction with No Updates
- Re: Query to find "foo" within "(foo)"
- Re: temporary tables on disk?
- Re: bookmarks and keywords
- Re: bookmarks and keywords
- Re: bookmarks and keywords
- Re: regexp negate string help
- Re: Ouch! ibdata files deleted. Why no catastrophe?
- Re: Ouch! ibdata files deleted. Why no catastrophe?
- Re: How to use an hardcoded list of values
- Re: MYSQL CLIENT PROBLEM
- Re: Count syntax
- Re: Having trouble storing monetary values...
- Re: Multi Lookup Table Joins
Oct 2007
- Re: Having trouble storing monetary values...
- Re: Proper way to Re-cync in Replication
- Re: Replication Issues
- Re: Replication Issues
- Re: Replication Issues
- Re: funky characters in columns
- Re: Mysql innodb commandline check and repair
- Re: Full Innodb Table Locks deadlocking with AUTO_INC locks.
- Re: Full Innodb Table Locks deadlocking with AUTO_INC locks.
- Re: DB Schema Comparison Utility ?
- Re: Multipart + IN comparison on the second part + JOIN does notuse full index
- Re: LIMIT within GROUP BY
- Re: single line inserts with on duplicate key
- Re: How to change "long_query_time" with mySql 3.23
- Re: DROP TRIGGER IF EXISTS throws error??
- Re: LIMIT within GROUP BY
- Re: Debugging batch sql statements
- Re: how to select second records in a group
- Re: My first trigger in MySQL
- How to get sane error log behavior
- Re: Problem with repeated replication corruption - Could not parserelay log event entry
- Re: [Replication] - load
- Re: Saving space disk (innodb)
- Re: Saving space disk (innodb)
- Re: Saving space disk (innodb)
- Re: Saving space disk (innodb)
- Re: Saving space disk (innodb)
- Re: Not In join query.
- Re: Are transactions atomic?
- Re: Error 1064 on a basic UPDATE query
- Re: Deadlocks with High Concurrency SELECT FOR UPDATE
- Re: Replication - urgent
- Re: finding non-ascii characters within a string
- Re: [MYSQL]time of elapsed time
- Re: Slow Subquery
- Re: german datetime format?
- Re: Reply-to is to originator rather than to list
- Re: Replication still stopping...
- Re: How to know the number of rows used in a SELECT MAX() query?FOUND_ROWS() not working.
- Re: Replication still stopping...
- Re: Index usage for simple query
- Re: correct way to simulate 'except' query in mysql 4.1
- Re: Index usage for simple query
- Re: Index usage for simple query
- Re: load data infile and character set
- Re: correct way to simulate 'except' query in mysql 4.1
- Re: Comparing keys in two tables
- Re: Comparing keys in two tables
- Re: load data infile and character set
- Re: Comparing keys in two tables
- Re: How to encrypt Text and still be able to use full text search?3rd Attempt ++
- Re: How to encrypt Text and still be able to use full text search?3rd Attempt ++
- Re: Table Size
- Re: Table Size
- Re: correct way to simulate 'except' query in mysql 4.1
- Re: Table Size
- Re: Left outer join trouble
- Re: query question
- Re: Group by time range.
- Re: Fulltext Relevancy not returning anticipated results?
Nov 2007
- Re: corrupted query cache?
- Re: Detecting new records
- Re: corrupted query cache?
- Re: sporadic error 13 on windows
- Bounty on MySQL Table Sync features
- Re: grouping
- Re: Table Size
- Re: How to emulate a DATE() in MySQL 4.0?
- Re: append on insert
- Re: Which is faster when deleting rows? In() or Separate Delete stmts?
- Re: SOLVED: Problem with *very* slow replication, FreeBSD 6.2
- Re: Is this kind of ORDER BY possible?
- Re: Replication - Master/Slave Issue...
- Re: privileges headache
- Re: privileges headache
- Re: Transactions and locking
- Re: How to find Free space in innodb
- Re: Replication Issue with Upgrade from 4.0.x to 5.0.x
- Re: select sum & order
- Re: Transactions and locking
- Re: Transactions and locking
- Re: Transactions and locking
- Re: Transactions and locking
- Re: SET GLOBAL don't work
- Re: MySQL - Replication (Master/Slave) Question
- Re: creating indexes with myisamchk
- Re: master/slave replication - errors!!
Jan 2009
- Re: Recommended MySQLDump options
- Re: Help with formatting of 1:n relationship
- Re: Mysqld fails to start
- Re: INNODB and Max Processors
- Re: mysql 5 performance
- Re: mysql 5 new install help requested
- Re: UPDATE ... where max(datecolumn)
Feb 2009
- Re: newbie config help needed
- Re: Question about triggers
- Re: Trying to work out why a join query is so slow
- Re: mysqld memory usage
- Re: WHERE vs. ON
- Re: Instance scale-out
- Percona Performance Conference adjacent to MySQL Conference & Expo
- Re: What ever happened to NitroEDb engine for MySQL
- Re: What ever happened to NitroEDb engine for MySQL
- Re: What ever happened to NitroEDb engine for MySQL
- Re: Updatable view using subquery??
- Re: MySQL View
- Re: Updatable view using subquery??
- Re: InnoDB: Thousands of Tables or Hundreds of Databases?
- Re: Size limitation of user variable?
- Re: mysql optimization tips
- Re: mysql optimization tips
- Re: Size limitation of user variable?
- Re: Select data from another Mysql Server?
- Re: Is the Relational Database Doomed?
- Re: Codd's rule 8 (physical data idependence)
- Re: Simple data, simple query giving me a brain-ache
- Re: query and insert data on multiple tables
- Re: SPARC to x64 Transition
- Re: How to execute prepare statement when the placeholder is a specific table name?
- Re: Resend: enabling storage engine with RPM install
- Re: InnoDB - CREATE INDEX - Locks table for too long
- Re: Best RAID for a DB + LVM?
- Re: how to get text SQL log
- Re: mysqlimport huge table
- Re: auto insert to another table
- Re: Does binlog stay in memory when replication happens?
- Re: MySQL Closing/Opening tables
- Re: MySQL Closing/Opening tables
Mar 2009
- Re: MyISAM large tables and indexes managing problems
- Re: Select query locks tables in Innodb
- Re: Finding replicated database
- Re: Select query locks tables in Innodb
- Re: Select query locks tables in Innodb
- Re: MySQL Log and Data directories
- Re: Select query locks tables in Innodb
- Re: view doesn't refresh inside transaction
- Re: Concurrent Inserts with merged table
- Re: Concurrent Inserts with merged table
- Re: Finding replicated database
- Re: MySQL Log and Data directories
- Re: help with fulltext search
- Re: Query from HPM book to limit rows scanned doesn't appear to work as described
- Re: Replica questions
- Re: Query from HPM book to limit rows scanned doesn't appear to work as described
- Re: MySQL 5.1 Rolling back a transaction containing Create Alter Drop table statements
- Re: if there're a tool which can replace mysql-proxy?
- Re: Upgrade large databases from 4.1 to 5.1
- Re: IN vs. OR on performance
Apr 2009
- Re: MySQL runs on 16-cores server
- Re: MySQL runs on 16-cores server
- Re: MySQL runs on 16-cores server
- Re: MySQL runs on 16-cores server
- Re: MySQL replication status plugin
- Re: Shutdown time
- Re: binlog question
- Re: binlog question
- Re: Extremely slow access to information_schema
May 2009
- Re: MySQL could not support bit storage?
- Re: xtrabackup
- Re: innodb_file_per_table cost
- Re: Logging SQL queries
- Re: Should I be able to DELETE FROM ... WHERE .. IN ( ... ) with multiple a column key?
- Re: innodb_file_per_table cost
- Re: Why can't I kill the query cache?
Jul 2009
- Re: Anyone using LVM for backing up?
- Re: Client deleted database, semi high priority master slave question
Dec 2009
- Re: Here's an Idea for Re-Syncing Master and Slave During Production Hours without Interrupting Users (Much)
- Re: Here's an Idea for Re-Syncing Master and Slave During Production Hours without Interrupting Users (Much)
- Re: InnoDB Corrupted databases (innodb_force_recovery not working)
- Re: UPDATE and simultaneous SELECT ... similar to RETURNING?
- Re: mysql load balancing
- Re: mysql load balancing
Jan 2010
- Re: Probability Selects
- Re: tmp tables
- Re: tmp tables
- Re: SUM() acting funny when joining
- Re: When using "FOR UPDATE" whole the table seems to lock instead of selected row
Feb 2010
- Re: logging of BAD queries
- Re: compare column value to anything in a list of values
- Re: EXPLAIN says DEPENDENT SUBQUERY despite no free variables
- Re: Index analyser
- Re: Using symlinks for database creation in mysql
- Re: Any faster building primary/unique indexes after Load Data Infile?
Apr 2010
- Re: MySQL threads taking time in "statistics" state
- Re: Small issue with FULLTEXT searches
- Re: Obtain week number between years
May 2010
- Re: mysql spatial functions (Was: Best index for searching on lat / long data i.e. decimal vs. float)
- Re: Innodb buffer pool size
- Re: Slow query using string functions
Jun 2010
- Re: Strange GREATEST() result in 5.0.32
- Re: Strange GREATEST() result in 5.0.32
- Re: selecting data for computation
Jul 2010
Aug 2010
- Re: There is something wrong with bugs.mysql.com email server I think (another one)
- Re: Problem with mytop
- Re: calculating memory size (again)
Sep 2010
- Re: Replaying the mysqld.log file from production onto QA???
- Re: statistics statement in general log
- Re: Encryption with MYSQL
- Re: document for mysql performance improvement
Feb 2012
Mar 2012
- Re: preg_replace in update statement
- Re: Trying to update existing prices and sizes in products table
- Free tickets to MySQL conference
- Re: ERROR 1146 (42S02): Table 'ois.metadata' doesn't exist
- Re: Free tickets to MySQL conference
- Re: how to sync mysql.user table between to two mysql instances
- Re: date comparison query
- Re: New Fast MySQL Compatible Server
Apr 2012
May 2012
- Re: mixing and matching mysql & mssql whileloop within an if case
- Free webinar about MySQL problem diagnosis
- Re: MySQL Community Server 5.1.63 has been released
- Re: Deadlock due lockwait. How can I tell mysql to wait longer?
- Re: Deadlock due lockwait. How can I tell mysql to wait longer?
- Re: Deadlock due lockwait. How can I tell mysql to wait longer?
- Re: SQL query help. Retrieve all DVDs that have at least one scene ofa certain encoding format
- Re: Reducing ibdata1 file size
- Re: Query weirdness...
- Re: Mysql starts to die at 27 SQL processes
Jun 2012
- Re: Connect to MySQL server from a c++ application
- Re: i need advice on redundancy of mysql server.
- Re: i need advice on redundancy of mysql server.
- New releases of Percona Toolkit, Percona Monitoring Plugins