By: Dan Nelson
Sep 2001
- Re: Can't get MySQL to use available memory (performance very slow)
- Re: Designing a recovery plan for MySQL
- Re: mySQL: ORDER
Oct 2001
- Re: what is the security issue with dynamic format?
- Re: Bizarre query performance
- Re: Bizarre query performance
- Re: Bizarre query performance
- Re: Last try guys! What is with the Spawning processes??
- Re: Preventing Nagle with mysql (was: Bizarre query performance)
- Re: Last try guys! What is with the Spawning processes??
- Re: FreeBSD v.s. Linux on dual processor
- Re: FreeBSD v.s. Linux on dual processor
- Re: MySQL Data Recovery Information Requested
- Re: Problem doing bulk and regular inserts
- Re: Can Mysql search full text fast through 3.3 million text documents?
- Re: MyISAM API
- Re: Length limit of 500 on primary keys?
- Re: Tree in SQL
- Re: Bugreport: Incorrect rows affected number!
- Re: can auto_increment wrap?
- Re: "ROW_FORMAT=compressed" has no effect on db file sizes
Nov 2001
- Re: Q about mysql_install_db under FreeBSD ports
- Re: Innodb file sizes
- Re: key cache optimization
- Re: mysqlclient.10
- Re: mysqlclient.10
- Re: Zip Code Database
- Re: Get real mysqld hostname
- Re: Natural Sort
- Re: Natural Sort
- Re: mysqld shutdown
- Re: shutdown still a problem on Darwin
- Re: shutdown still a problem on Darwin
- Re: MySQL on FreeBSD Dual CPU machine
- Re: MySQL on FreeBSD Dual CPU machine
- Re: width and height performance
- Re: Fwd: Help? create function returns errno 0: unsupported file type
- Re: Problem compiling MySQL 4.0.0 on FreeBSD 4.0-RELEASE
- Re: Problem compiling MySQL 4.0.0 on FreeBSD 4.0-RELEASE
- Re: why doesn't prepared statement work?
- Re: does each database connect cause mysqld to fork?
Dec 2001
- Re: SQL syntax error
- Re: No Database Encryption
- Re: 4 G table limit?
- Re: Mysql query it too slow in big table
- Re: How to see progress on long index ops
- Re: DOC BUG: mysqladmin
- Re: 4.0.1 bug reports. Has it been released yet?
- Re: How to optimize this
- Re: Support for older Berkeley databases
Jan 2002
- Re: Command Line Editing Mode
- Re: Mysql daemon monitoring
- Re: 2 GB limit reached
- Re: primary key that doesn't autoincrement
- Re: 2 GB limit reached
- Re: mySQL vs Interbase
- Re: Database Size Limit
- Re: Very large mysqld processes
- Re: synchronize??
- Re: Memory
- Re: regarding the MySQL's server Caching feature
- Re: Bytes sent vs. Bandwidth used
- Re: calculated fields
- Re: MySQL Checkbox table field
- Re: MySQL Checkbox table field
- Re: MySQL Checkbox table field
- Re: repairing corrupt tables
- Re: Grant Permission Syntax/Qualifier for Column?
- Re: MySQL PASSWORD function
- Re: Please Help with Pattern Matching
- Re: Suppress WARNING
- Re: OT: procmail recipe for this list?
Feb 2002
- Re: Starting MySQL (w/ InnoDB) for the firs time
- Re: Bug in UNIQUE?
- Re: sysctl & process limitations
- Re: deleting var="0.1"
- Re: Problem wish slashes & LIKE query
- Re: Problem wish slashes & LIKE query
- Re: Is The MySQL Mailing List On Crack?
- Re: Porting from MsSQL to MySQL (VERRY XML RELATED)
- Re: Problems finding parts of mysql on FreeBSD
- Re: Problems finding parts of mysql on FreeBSD
Mar 2002
- Re: making " : " an allowable character in tables & colums
- Re: making " : " an allowable character in tables & colums
- Bad pthreads detection on Tru64 5.1a
- Bad pthreads detection on Tru64 5.1a
- Re: MySQL, FreeBSD problem
- Re: 4.0.x memory bug on FreeBSD...?
- Re: delete vs delete quick
- Re: FreeBSD+MySQL
- Re: FreeBSD+MySQL
- Re: Impact of Free ORACLE
- Re: mysql stripslash fonction ? to escape ' ""
Apr 2002
- Re: Best hardware for a very large MySQL server? looking at x86
- Re: More then 2-way SMP, process threading & Sun Fire v880: Re: Best hardware for a very large MySQL server? looking at x86
- Re: accessing MySQL database from Access
- Re: Help with Tables Please
- Re: See complete SQL sentence in mysqladmin process
- Re: Turning off innodb
- Re: print on top
May 2002
- Re: Can I create a table name 'INT'?
- Re: inserting into the lowest possible id
- Re: Real-time data warehousing
- Re: MySQL on iSCSI or IPSAN?
- Re: MyISAM -> Innodb
- Re: Concurrency control
- Re: [7241] Indexes on columns that are declared differently?
- Re: query - primary key
- Re: query - primary key
- Re: MySQL on iSCSI or IPSAN?
- Re: FreeBSD & LinuxThreads from BK Tree?
- Re: Where is my.cnf in FreeBSD?
- Re: Alternate to varchar2
- Re: Recent Updates
- Re: I need 50.000 inserts / second
- Re: my.cnf necessity
Jun 2002
- Re: Column names that contain %
- Re: mysqlhotcopy regexp problem with 640 and more Databases
- Re: Comparing array elements
- Re: Maximum JOINED tables
- Re: Max Number of Rows
- Re: Can I connect to a MySQL Database on a unix platform from a PC?
- Re: Plagued by Error 127
- Re: inserting values w/ relationships
- Re: How many MySQL tables can we open paralel
- Re: Delete
- Re: GRANTs and %
- Re: MySQL AB: Need documentation clarification
- Re: Problem when POSTING
- Re: Problem when POSTING
- Re: problem with mysql threads on freebsd
- Re: Sql Alter Table error handling
- Re: Is this an FAQ?
- Re: Working libmysqld.a for Tru64 5.1?
- Re: Don't even know where to start on this one
- Re: Don't even know where to start on this one
- Re: multiple updates
- Re: Multi-threaded MySQL?
- Re: 3.23.51 LIMIT efficiency problem
- Re: auto_increment and clustering sequence
- Re: Need last 100 records...
- Re: cpu consumption.
- Re: Increasing number of open_files -- no takers on this one?
- Re: Increasing number of open_files -- no takers on this one?
- Re: InnoDB made MyIsam DELETE's slow
- Re: InnoDB - count() slow
Jul 2002
- Re: Strange problem - could be a bug?
- Re: Growing memory usage/processes
- Re: Keyfile size
- Re: Keyfile size
- Re: C API: mysql_data_seek
- Re: Basic Q's: Numerical Sorting
- Re: query to update record by the position of row
- Re: Char type changes to Varchar type
- Re: what's the deal?
- Re: Using Inner Join in MySQL
- Re: Error: undefined symbol "strtoll"
- Re: CHECK syntax
- Re: mysql-4.0.2-alpha BROKEN on OSX 10.1.4 Server; WORKAROUNDS incl., but need help with FIXes
- Re: mysql-4.0.2-alpha BROKEN on OSX 10.1.4 Server; WORKAROUNDS incl., but need help with FIXes
- Re: Three easy, FAST-REPLY questions re: MySQLGUI
- Re: Auto_Increment Starting Number
- Re: Installation Problem
- Re: Surrounding Rows
- Re: Surrounding Rows
- Re: faster update
- Re: MySQL databases lost?
- Re: libmysqlclient.so.10
- Re: Query Optimization
- Re: 4.0.2 libmysqlclient.so.10 not found
- Re: 32 key max in InnoDB
- Re: Accessing multiple indexes
- Re: Set different sizes on a per-database level?
- Re: MySQL ERROR 1062: Duplicate entry '1' for key 1
- Re: question about cached result
- Re: Bit XOR not working
- Re: Speed issues...
Aug 2002
- Re: Speed issues...
- Re: Speed issues...
- Re: Mysql's equivalent of SQL Loader or BCP/DTS??
- Re: Data Replication in MySQL 3.22.25-log
- Re: fulltext phrase search
- Re: SIGPROF problem in FreeBSD 4.6 (REPOST)
- Re: Re-installing MySQL
- Re: Query problem/mysql
- Re: limitation mysql in request?
- Re: upgrading from MySQL 3.21.33 to MySQL 3.23.51
- Re: Need help how to make Directory system in MySQL with 6.5 mill subscribers ?
- Re: upgrading from MySQL 3.21.33 to MySQL 3.23.51
- Re: query quandary
- Re: Supplied argument is not a valid MySQL result resource!!
- Re: Still trying to build libmysqld.a on Tru64
- Re: MySQL vs. Oracle (not speed)
- Re: Still trying to build libmysqld.a on Tru64
- Re: AUTO_INCREMENT PROBLEM
- Re: auto increment as primary key
- Re: Displaying the real thread PIDs.
- Re: Displaying the real thread PIDs.
- Re: Still trying to build libmysqld.a on Tru64
- Re: Still trying to build libmysqld.a on Tru64
- Re: ERROR 1062
- Re: Process Sleeping
- Re: Process Sleeping
- Re: MySQL/InnoDB-4.0.3 is released
- Re: Join with Union
- Re: Join with Union
- Re: Stored Procedureish Advise needed
- Re: Installing mysql 4.0.3 with linux threads on freebsd
Sep 2002
- Re: "my.ini" in RH Linux 7,2
- Re: Vaibhav Difference between amount <> null and amount is not null
- Re: aggregate functions producing bad data
- Re: Queries Per Second
- Re: Auto Increment ID of Inserted Row
- Re: user variables in ODBC
- Re: Max NB of MyISAM tables / DB ( Ext3 & linux )
- Re: Known Database "Unknown"...
Oct 2002
- Re: OT: Reply-Adress in this list
- Re: Linux GUIDs
- Re: .Optimize mySQL memory usage ? 41MB threads ??
- Re: .Optimize mySQL memory usage ? 41MB threads ??
- Re: how to check .MYI file withour shutdown database
- Re: does mysqlimport actually recreate the table schmea as well as import data?
- Re: Mysql Innodb performance slow
Nov 2002
- Re: behaviour of WHERE statement with NULL fields
- Re: Key/table cache size?
- Re: MySql 4.1 Sub Selects and not stored procedures
- Re: Problems with simple(?) query
- Re: support table synonyms?
- Re: MySQL quits serving on Mac OS X Server 10.2
- Re: Disappearing records?
- Re: Disappearing records?
- Re: redhat8 mysql remote connections
- Re: feature suggestion - indexes with "where" clause or similar
- Re: mysql source for 4.0.5
- Re: mysql query error
- Re: irrelevant multi-column index yields incredible speedup!
- Re: Executing concurrent select statements from perl on MySQL ISAM tables (fwd)
- Re: Need to force Mysql to use port, NOT socket
- Re: Connecting via 127.0.0.1 (was Need to force Mysql to use port, NOT socket)
- Re: this is WEAK!
Dec 2002
- Re: adding a column after table creation
- Re: Cant Explain Error Message
- Re: sleeping threads problem
- Re: Questions Compressed Tables & Indexs
- Re: alter table syntax
- Re: alter table syntax
- Re: Bug in GROUP BY/CASE/MAX?
- Re: Am I Violating Any Rules ?
- Re: Am I Violating Any Rules ?
- Re: really slow query results --- SOLVED
- Re: MySQL Netware vs Linux
- Re: time of query
- Re: What terminates a query?
- Re: 4.1 questions: subqueries which use dual
- Re: ORDER dilemma
- Re: Replication priority / speed
- Re: replication
Jan 2003
- Re: Mysql.sock gets deleated
- Re: MySQL for Netware
- Re: Select * from names where words(name) = 3
- Re: Embedding images stored in database
- Re: SHOW STATUS LIKE 'Com_%'
- Re: Avg_row_length
- Re: Mysql on FreeBSD with a NT linked database
- Re: Confirmation of SELECT...IN syntax
- Re: FreeBSD 5.0 Thread Work...
- Re: FreeBSD 5.0 Thread Work...
- Re: smallest dumpfiles in Windows in one step?
- Re: moving users/privileges
- Re: upgrade mySQL
- Re: error with 4.0.9 "c" API or user
- Re: Configure prob with FreeBSD/Linuxthreads
- Re: mysql dump for remote db
- Re: Configure prob with FreeBSD/Linuxthreads
- Re: problems creating fulltext index
- Re: Increment in update
- Re: query cache
- Re: Increment in update
- Re: Storage issue
- Re: Character problems
- Re: Configure prob with FreeBSD/Linuxthreads
- Re: Configure prob with FreeBSD/Linuxthreads
Feb 2003
- Re: last_insert_id() returns 0 in windows
- Re: When are MyIsam Tables physically updated?
- Re: When are MyIsam Tables physically updated?
- Re: tablespace
- Re: Why so many mysqld lines in process list on Linux box
- Re: Innodb: Limited creation of tables
- Re: Mysql 4 production quality
- Re: Data being not inserted in the table inspite of success from mysql
- Re: backslash before newline
- Re: How to Archive and restore the data in MySQL database.
- Re: mysqldump oddness.
- Re: AW: apostrophe and comma error on submit (auto)
- Re: IP Addresses -- How to Store
- Re: Is there anything equivalent to Oracle9i's list partitioning?
- Re: cannot compile 3.23, 4.0 or Redhat SRPMs
- Re: CREATE INDEX is sooo slow! any ideas?
- Re: Slow retrieval of distinct on indexed fields
- Re: Slow retrieval of distinct on indexed fields
- Re: reserved or key words as database object names.
- Re: Is this a bug?
- Re: mysql or pathon date question
Mar 2003
- Re: mysqld: Can't lock file (errno: 45) (More Info)
- Re: HAVING vs. WHERE
- Re: Foreign keys and being FIRST index
- Re: Foreign keys and being FIRST index
- Re: syntax error 1064 ||
- Re: Telneting failed
- Re: Replication [p]threads problem
- Re: forcing mysql client to use TCP socket?
- Re: FreeBSD + MySQL bottleneck
- Re: How to compile mysql-3.23.55 on Aix 4.3.3.11
- Re: Please tell me why to use KEY (a_id, b_id) rather than KEY (a_id), KEY (b_id)
- Re: Process Limit on Linux ?
- Re: Process Limit on Linux ?
- Re: UNION operates incorrectly
- Re: building MySQL on Alpha-Dec-OSF4 with gcc
- Re: MyISAM rebuilding questions
- Re: Could we make this a web discussion forum?
Apr 2003
- Re: Open_files drops fast. Why?
- Re: MySQL index fun
- Re: MySQL index fun
- Re: Temp Table Creation: Got error 12 from table handler
- Re: rounding/truncation of decimal fields
- Re: Unable to make mysql40-client
- Re: stable version ?
- Re: When will we be able to write such queries??
- Re: [MySQL] emailing Lists
- Re: running on FreeBSD from compiled source
- Re: last_insert_id() with multiple users
- Re: compiler error
- Re: handle nulls
- Re: crash in mysql 4.1.0 EXPLAIN w/ subquery
- Re: Python and MySQL
- Re: performance
- Re: performance
- Re: crash in mysql 4.1.0 EXPLAIN w/ subquery
- Re: Index File Size
- Re: strange behavior with query optimizer regarding 'range'
May 2003
- Re: Next issue: Can't execute multiple statements?
- Re: Getting to the shell from mysql> prompt
- Re: fastest why of retreiving data from arrays
- Re: Getting to the shell from mysql> prompt
- Re: mySQL Design Question
- Re: A seroius trouble with MySQL
- Re: count()
- Re: how to automatically run a script some time after a record is created
- Re: does a 2gig memory limitation exist on the win2k MySQL-Max 4.x build?
- Re: Linux x86 file size limit w.r.t. MySQL
- Re: Explaining unix ODBC in plain english
- Re: ERROR 1062: Duplicate entry '1' for key 1
- Re: can the MySQL graphical client connect to NON MqSQL servers?
- Re: How to select the dictionary list of a FTS table
- Re: How to select the dictionary list of a FTS table
- Re: How to select the dictionary list of a FTS table - now we have a compilation problem
- Re: Minimum Requirement to run a MySQL test setup
- Re: Slow queries on 4.0.13, FreeBSD 4.8 STABLE, linuxthreads, zawodny blog
- Re: Slow queries on 4.0.13, FreeBSD 4.8 STABLE, linuxthreads, zawodny blog
- Re: Slow queries on 4.0.13, FreeBSD 4.8 STABLE, linuxthreads, zawodny blog
- Duplicate messages [alphafoo@yahoo.com: Re: Slow queries on 4.0.13, FreeBSD 4.8 STABLE, linuxthreads, zawodny blog]
- Re: Slow queries on 4.0.13, FreeBSD 4.8 STABLE, linuxthreads, zawodny blog
- Re: Optimize this query...
- Re: DEFAULT value for DATETIME field
- Re: DEFAULT value for DATETIME field
- Re: How to write this query pls?
- Re: silly old hostname help?
Jun 2003
- Re: indexes question
- Re: indexes question
- Re: How to empty the cache?
- Re: INT type
- Re: INT type
- Re: does MySql Supports shared Objects
- Re: extending MySql
- Re: Anyone had a chance to try an Opteron yet?
Jul 2003
- Re: HAVING clause - MySQL 4.0.13 - unknown column error
- Re: Difference of MySQL Standard and Max Version
- Re: InnoDB Performance issues
- Re: Stopping MySQL taking down a server?
- Re: Storage efficiency of VARCHARs
- Re: Small problem installing on FreeBSD
- Re: MySQL, FreeBSD, LinuxThreads, and > 950 connections?
- Re: MySQL, FreeBSD, LinuxThreads, and > 950 connections?
- Re: MYI file difference
- Re: Difference of MySQL Standard and Max Version
- Re: quotas
- Re: quotas
- Re: Is it necessary to compress tables?
- Re: functions
- Re: How to know the maxmimum length of data in a perticular column?
- Re: What is a good benchmark?
- Re: What is a good benchmark?
- Re: What is a good benchmark?
- Re: batch mode
- Re: Transactions
Aug 2003
- Re: Update from 3.23 to 4.0
- Re: Nested SELECT statements problem
- Re: Nested SELECT statements problem
- Re: Problem with merge tables in 4.1
- Re: Corrupt index = mysqld freeze?
- Re: How to speed up the access
- Re: PHP or Perl?
- Re: Table locking...
- Re: "hard" sort table order
- Re: MySQL 4.0.13 Memory problem under heavy load
- Re: Grown defects in a RAID array
- Re: Oracle DBA here looking for advice on MySQL ....
- Re: RAID or not?
- Re: finding out what localhost is
- Re: Optimize Question
- Re: Optimize Question
- Re: Optimize Question
- Re: Why are Duplicate keys allowed???
Sep 2003
- Re: spaces in index name
- Re: ISAM....the name sounds so familiar....
- Re: MYSQL not starting
- Re: How much memory does MySQL need?
- Re: Storing Unprintable Characters
- Re: Does Null == ""?
- Re: Slow query join problem
- Re: Large number of Databases
- Re: Fragmentation problem with MYD/MYI files
- Re: Can someone explain the difference between these two queries?
- Re: How much data can mysql support?
- Re: # processes vs. #threads, and memory usage (Revisited for thread cache)
- Re: Text formatting
- Re: SQL Injection
- Re: What are the effects of key_buffer on a dedicated slave
Oct 2003
- Re: Can records be moved between tables without knowing columns
- Re: How does LIMIT affect Query Caching
- Re: Select always "Using FileSort"
- Re: Queries per second unjustifyingly increases over time
- Re: OR in MySQL statement?
- Re: natural sorting
- Re: Resume indexing after powerloss?
- Re: syslog
- Re: Innodb vs myisam
Nov 2003
- Re: query time in ~3M row table
- Re: query time in ~3M row table
- Re: Table Creation
- Re: ROWID
- Re: Problems storing SHA1 Hash
- Re: 50 000 tables - table_cache
- Re: Functions and Procedures in Mysql
- Re: Functions and Procedures in Mysql
- Re: Functions and Procedures in Mysql
- Re: Repeated 100% CPU problem in FreeBSD
- Re: Storing binary data (string with nulls/ASCII 0 in them) in CHAR/VARCHAR?
- Re: MySQL separate downloads
Dec 2003
- Re: Mysql won't start
- Re: [OT] Importing content from Word
- Re: UDF on AMD64
- Re: UDF on AMD64
- Re: integer not being inserted correctly
- Re: Performance Question
- Re: Performance problems using 1GB Linux server and trying to avoid swapping
- Re: Performance problems using 1GB Linux server and trying to avoid swapping
- Re: Combining tables
- Re: load data in file
- Re: Use of Parameters
- Re: FULLTEXT Search and Hyphens
Jan 2004
- Re: Deciding whether to convert to InnoDB
- Re: elminating filesort
- Re: Knowing the real size of a column
- Re: Query takes 1703.57 sec
- Re: Rounding to nearest one sixteenth of an inch.
- Re: Mysql listed in spamcop?
- Re: why: mysqldump and mysqlimport?
- Re: Multi Level Transaction (InnoDB)
- Re: Select on indexed columns
- Re: Shared Physical Database Question
- Re: char count
- Re: Reducing MySQL memory consumption?
- Re: Reducing MySQL memory consumption?
- Re: Preparing new lib files
- Re: ORDER BY may remove result rows
Feb 2004
- Re: query the data of a fulltext index directly from index?
- Re: Memory Leak using InnoDB ?
- Re: maximum number of mysql connections and process
- Re: Maximum tables in a join (4.0.x)
- Re: MySQL 4.0.18 has been released
- Re: Setting "PACK_KEYS=1" on existing tables
- Re: Does thread_concurrency do anything on a non-Solaris OS?
- Re: White Space
- Re: Improving seek/access times -- does RAID help?
- Re: Compatibility question
Mar 2004
- Re: PgSQL vs MySQL
- Re: MERGE table with some packed tables?
- Re: MERGE table with some packed tables?
- Re: mysql:it's a db not a dbms... how it's possible?!
- Re: Sorting with an alpha numeric field.
- Re: Sorting with an alpha numeric field.
- Re: 6.5 seconds seems slow for the following search?
Apr 2004
- Re: innodb_buffer_pool_size limit
- Re: MySQL on Linux
- Re: raid configure option?
- Re: Problem with 2GB limit.
- Re: Problem with 2GB limit.
- Re: Problem with 2GB limit.
- Re: Oracle Listener Like Functionality
- Re: Creating Users and Passwords
May 2004
- Re: Need to know how many current connections
- Re: [mysql] replication of database structure changes
- Re: "INSERT INTO" dropping slashes from strings
- Re: Title Case
- Re: GUID storage
- Re: GUID storage
- Re: InnoDB filesystem
- Re: Integers - How would you enter 112,249?
- Re: OPTIMIZE TABLE and mySQL replication
- Re: OPTIMIZE TABLE and mySQL replication
- Re: OPTIMIZE TABLE and mySQL replication
- Re: COUNT
- Re: Running more than one level of MySQL
- Re: Large sample data sets for testing
- Re: Links to myisam database files
- Re: mysql_qury returns -1!
Jun 2004
- Re: Does MySQL Daemonize?
- Re: Tuning MySQL 4.0.20 for large full table scans
- Re: Tuning MySQL 4.0.20 for large full table scans
- Re: Moving tables to different disks (High Performance MySQL)
- Re: inserting works fine but I cant update.
- Re: inserting works fine but I cant update.
- Re: Tough Query Problem
- Re: Fetching 12 columns or 1 TEXT field?
- Re: Rights required to run myisamcheck
- Re: Database Partitioning
- Re: GUID storage
Jul 2004
- Re: Finding Tables created by views
- Re: 16-Page Database Table Limit?
- Re: Can't Publish Tables Online
- Re: INTEL vs. SPARC
- Re: interactive_timeout
- Re: deleting millions of records did not change the file size
- Re: do i need an index for this?
- Re: do i need an index for this?
- Re: do i need an index for this?
- Re: empty_blob() equivalent
- Re: empty_blob() equivalent
- Re: SHOW TABLE STATUS in MySQL 4.1.latest different from 4.1.1 !?
- Re: Indexed Database still slow
Aug 2004
- Re: Why drop a index takes so long to do?
- Re: problem with 4.1.3
- Re: What would you store in a BLOB field?
- Re: Query Cache
- Re: Strange Text Field
- Re: 1 day 28 min insert
- Re: 1 day 28 min insert
- Re: Compilation error
- Re: Compilation error
- Re: Calculated fields - is there any way to do this?
- Re: Debating over table types
- Re: Two indexes on same column. Crazy ?
- Re: Duplicate Keys when auto-increment??
Sep 2004
- Re: please explain why this query isn't optimized
- Re: when to use backquote in SQL
- Re: when to use backquote in SQL
- Re: List of MySQL Keywords
- Re: MySQL speed
- Re: 4.1.4a-gamma in production?
- Re: Reason for a slow "remove index"-operation?
Oct 2004
- Re: Memory problems
- Re: Memory problems
- Re: COMPRESS engine
- Re: IP address to searchable number
- Re: MySQL 4.0.22 has been released
Nov 2004
- Re: field name (1 and 2) causes error
- Re: Fast method needed to determine if a table is corrupt
- Re: C api incompatability from 3.x to 4.1
- Re: 4.1.7 insert locks killing me
- Re: 4.1.7 insert locks killing me
- Re: Access front end problem
- Re: MySQL 4.0.2 is topping out at 1024 threads!
- Re: MySQL 4.0.2 is topping out at 1024 threads!
- Re: Mysql 4.1 and the LIMIT sql statement
- Re: MySQL 4.1 and PHP5 with old client
- Re: Using epoch date instead of calendar date
- Re: about berkeley db
Dec 2004
- Re: Help with installation: MySQL, FreeBSD 5, Sparc64
- Re: if last binary byte is space (ascii 32) mysql drops it
- Re: Performance and indexing for time intervals...
- Re: Deleted: 0 Skipped: 0 Warnings: a lot
- Re: Why is this simple query so slow?
- Re: Load Index Into Cache is broken! ... and a workaround
- Re: DBI->connect does not work in crontab but works interactively
- Re: DBI->connect does not work in crontab but works interactively
- Re: To use Quotes or not to, that's the question.
- Re: To use Quotes or not to, that's the question.
- Re: mysql_fetch_lengths()
- Re: mysql_fetch_lengths()
Jan 2005
Feb 2005
Mar 2005
- Re: stop and restart mysql on freebsd?
- Re: mysqldump vs. 'mysql [db] > file.sql'
- Re: Query_cache_size Question
- Re: Query_cache_size Question
- Re: Obtaining a List of Available MySQL Functions
- Re: subquery fails when a NOT IN operator tests a subset with NULL valu
- Re: show all running queries on linux
- Re: Converting Integer values to date type
- Re: a very tricky string extraction
- Re: Recovering Lost Database
- Re: PACK_KEYS not packing keys?
- Re: How does a multi-row INSERT work?
Apr 2005
- Re: weird characters from mysqldump?
- Re: A picture perfect problem
- Re: Size of BLOB types?
- Re: Database load and table design ?
- Re: Unique items from all columns, very slow
- Re: Slow query: mysql not using correct indexes?
May 2005
- Re: mysql mem usage
- Re: mysql mem usage
- Re: INSERT DATE using USA Date Format
- Re: MySQL not using optimum disk throughput.
- Re: MySQL not using optimum disk throughput.
- Re: data length vs index length ??
- Re: Subquery question
Jun 2005
- Re: SQL for performance statistics
- Re: Problem building 4.1.12 on HP-UX 10.20
- Re: Seriously.. When are we going to get subqueries?!
- Re: 'Single quotation mark' makes different results for 'explain select'
- Re: Ordinal number within a table
- Re: lexer for query strings
- Re: Not sure about Error
- Re: Table caching
- Re: Possible to delay index writes until server is less busy?
Jul 2005
- Re: Possible to delay index writes until server is less busy?
- Re: Different versions differnet results
- Re: GROUP BY approximation
Aug 2005
Sep 2005
- Re: trouble understanding why query is not using the index.
- Re: Locking Methods
- Re: Timezone query similiar to pgsql
- Re: Circular Replication
- Re: UUIDs - first usage for me
- Re: mysql_free_result() WITHOUT mysql_fetch_row()
- Re: Failure to install on Solaris.
- Re: Memory usage question
- Re: "Sort Aborted" errors after upgrade to 4.1.14
- Re: HELP - Group_Concat broken after update
Oct 2005
Nov 2005
Dec 2005
- Re: Index merge optimization with joined tables?
- Re: Mysqldump segmentation fault(core dumped)
- Re: NULL, OR, and indexes
- Re: NULL, OR, and indexes
Jan 2006
Feb 2006
- Re: AUTOINCREMENT / UNIQUE Behavior [Newbie Question]
- Re: Surviving MySQL crash
- Re: showing zero counts in select statements with group by
- Re: Table grows much faster than others.
Mar 2006
- Re: puzzled by date functions (long)
- Re: Table with multiple primary keys - How
- Re: How to Log Warnings and Errors from queries
- Re: Care and feeding of MySQL tables (aka Preventative Maintenance via Cron)
- Re: insert my_ulonglong data with C API
- Re: insert my_ulonglong data with C API
- Re: Authenticating MySQL off of an LDAP
- Re: Comparing x.x.x.x strings
- Re: Client does not support authentication protocol requested by server
Apr 2006
- Re: new password will not be effective for connection immediately
- Re: Full text score
- Re: Fulltext and reserved words
- Re: MySQL cache problem - innodb_buffer_pool_size and FS cache
- Re: MySQL cache problem - innodb_buffer_pool_size and FS cache
- Re: where group and inner join
- Re: where group and inner join
- Re: How to initiate a prog. via mysql
- Re: mysql 5 vs. mysql 4: str_to_date
- Re: Table design; 2-column index
- Re: Table design; 2-column index
- Re: Timeseries
May 2006
- Re: Q2. Is there anything could be done to speed up this query
- Re: MySQL 5 Calculate Field query
- Re: inserting server time into mysql
- Re: how to extract common text string from field?
- Re: max_allowed_packet via SQL Statement
- Re: Looking for free MySQL Administrator
- Re: dump stored procedure
- Re: select sum(qty*unitpri) wrong result
Jun 2006
- Re: dropping primary key - 99%CPU
- Re: Aborting a greedy querry from the command line
- Re: reclaim disk space
- Re: A lot of HD Writing
- Re: Show tables replacement
Jul 2006
- Re: what are those MySQL files for?
- Re: stack explanation ?
- Re: Is it possible to combine mysql with nis?
- Re: transaction
- Re: Can Innodb reuse the deleted rows disk space?
- Re: Threads of terminated clientapplications
- Re: Can Innodb reuse the deleted rows disk space?
- Re: Threads of terminated clientapplications
Aug 2006
- Re: list of words in fulltext key index
- Re: How a VIEW is stored
- Re: CentOS 4.3 - MySQL - NIS user issue
- Re: SOLVED (was: Weird SELECT bug in 5.0.21)
Sep 2006
- Re: problem with InnoDB
- Re: problem with InnoDB
- Re: View hidden temporary files
- Re: MySQL mailing list's strange responses
- Re: MIT Kerberos integration with MySQL
- Re: [mysql]Concurrency with inserts
- Re: [mysql]Concurrency with inserts
- Re: [mysql]Concurrency with inserts
- Re: making varchar field to act like numeric field
- Re: comparing two databases
Oct 2006
- Re: creating indexes on a table already containing data
- Re: How to get the size of a row
- Re: Too many open processes??
- Re: InnoDB, 1 file per table or 1 BIG table?
- Re: InnoDB, 1 file per table or 1 BIG table?
- Re: Using posix users
- Re: mysqlclient in Apache
- Re: Order to run ANALYZE, OPTIMIZE and CHECK
- Re: Optimizer Bug?
- Re: Optimizer Bug?
- Re: MSSQL NoLock vs MySQL NoLock
Nov 2006
- Re: Slightly bizzare query strategy
- Re: Regular expression not working as expected (documented)?
- Re: Using MySQL to log and report transactions
- Re: float numbers
- Re: float numbers
- Re: Importing Text File Into mySQL
- Re: Importing Text File Into mySQL
- Re: shutdown database but not mysqld
- Re: Performance Question And Problem
- Re: Performance Problems With Two Tables With Over 500K Rows
- Re: bind-address: settable via /etc/mysql/my.cnf only?
- Re: Performance Problems With Two Tables With Over 500K Rows
- Re: Performance Problems With Two Tables With Over 500K Rows
- Re: username audit column
Dec 2006
- Re: Converting a field or converting a date?
- Re: How to determine MyISAM sort order?
- Re: Sort Select by List
- Re: Sort Select by List
- Re: What to do if a table is supposed to get > 3GB data per day?
- Re: Befuddled Why This Locks
- Re: Befuddled Why This Locks
- Re: [MySQL] Re: Filling blanks on SELECT
Jan 2007
- Re: mysql question regarding distinct/group by...
- Re: How to access an array variables in a single query
- Re: Indexing issue in slave !!
- Re: Selecting avg()...
- Re: how to take advantage of STR_TO_DATE
- Re: Primary key
- Re: Question in ORACLE
- Re: Query skips one set of records
- Re: SQL Query Question
- Re: MYSQL reporting an error with subquery query
- Re: Safe DB Distribution
- Re: Database Layout (Design) Question
- Re: Replication not working?
- Re: Fulltext relevance and weighting....
Feb 2007
- Re: Dump to old dump format?
- Re: max_allowed_packet in my.ini
- Re: Updating from 4.0.20 to 5.0.27
- Re: about partition key type
- Re: SQL Translation
- Re: using contraints on Mysql
Mar 2007
- Re: function based index
- Re: How can I increase the size of the table
- Re: Searching for Dates
- Re: Searching for Dates
- Re: Why doesn't the InnoDB count() match table status?
- Re: Why doesn't the InnoDB count() match table status?
- Re: a 'safe' way to move data?
Apr 2007
- Re: InnoDB data log files
- Re: Mysql Hogging all system resources
- Re: Problem on millions of records in one table?
May 2007
- Re: ROLLUP and Text on total lines
- Re: Issue with locking and INSERT DELAYED
- Re: Need script to populate data.
- Re: Table compression with write (append) support
Jun 2007
- Re: Stable mysql 4.xx
- Re: Innodb tablespace
- Re: Hiding columns used in GROUP BY and HAVING clauses
- Re: Hiding columns used in GROUP BY and HAVING clauses
- Re: Hiding columns used in GROUP BY and HAVING clauses
- Re: How do you reference custom column names
Jul 2007
- Re: Replication Question
- Re: How to Query by First Part of a VARCHAR?
- Re: View pocedures/backup procedures
Aug 2007
- Re: how to use all system RAM for myisam db?
- Re: Building MySql 5.0.45 on Solaris 6
- Re: Recreate Table With Sorted Data
- Re: Why is the average of an int column returned as a string
Sep 2007
- Re: mysqldump with single rows per dataset
- Re: The current version is 5.0.48, no?
- Re: MySQL 5.1.21 won't build on OpenBSD unless...
- Re: MySQL 5.1.21 won't build on OpenBSD unless...
Oct 2007
- Re: SAN and ibdata files
- Re: SAN and ibdata files
- Re: upgrade from 4.1 to 5.0 KO
- Re: Table Size
- Re: ibdata file size
- Re: ibdata file size
- Re: MYSQL connection failed: Can not connect to MySQL server
Nov 2007
Jan 2008
- Re: Does SQL_NO_CACHE work?
- Re: Need to know how to do INSERTS, using variables for VALUE
- Re: Using Variables in Insert
Feb 2008
- Re: very strange slow plain select
- Re: Number of rows not constant
- Re: Migrating form 3.23.49 to 5.0.32
- Re: records ordered incorrectly
Mar 2008
Apr 2008
May 2008
- Re: comparison operations in IN subquery
- Re: ????: RE: comparison operations in IN subquery
- Re: Triggering an action every 24 hours
- Re: MySQL error database.....?
- Re: Table Size
Jun 2008
- Re: JAVA UDF HOW
- Re: How to ensure column expression gets stored as Double and notDecimal
- Re: convertion to utf-8
Jul 2008
- Re: convertion to utf-8
- Re: Mysqldump turn off quotes
- Re: Create Table from Results of SQL Query
- Re: Log
- Re: Log
- Re: mysqldump
Aug 2008
Sep 2008
- Re: How many key buffer size should be allocate?
- Re: make In statement non case sensitive?
- Re: innodb log files but we only use MYISAM
- Re: how to figure out what options are supported, was Re: Oddcrash with MySQL Embedded 5.1.28
- Re: Tables are too wide
Oct 2008
- Re: replication question -different db name on slave server
- Re: MySQL und dual cores
- Re: MySQL und dual cores
- Re: FLOOR(DATE_ADD(CURDATE(), INTERVAL 4 MONTH)) -- ?
Nov 2008
Dec 2008
Jan 2009
- Re: Why does changing a table property rebuild the table?
- Re: Why does changing a table property rebuild the table?
Feb 2009
- Re: enabling storage engine with RPM install
- Re: MySQL Closing/Opening tables
- Re: MySQL Closing/Opening tables
Mar 2009
Apr 2009
May 2009
Jun 2009
- Re: slow select when using VIEW
- Re: Available parallelism in MySQL community edition 5.1.34?
- Re: The size of an index (INDEX_LENGTH)
- Re: How to Optimize distinct with index
- Re: Half Hour Sub-query in MySQL vs. 5 Seconds in VFP?
- Re: Custom agregate functions
Jul 2009
- Re: What OS is the best platform for MySQL ?
- Re: How to use LIKE for detecting numbers with commas?
- Re: Triggers For Radius DB
- Re: Another Trigger Question!
- Re: Slow query Performance
- Re: When does indexing happen?
Aug 2009
- Re: Slow performance Query
- Re: Erratic query performance
- Re: show tables is slow/uncached
- Re: Inquiry:MySql table data missing problem
- Re: Very Slow Query
- Re: Very Slow Query
Sep 2009
- Re: InnoDB doubles size when converting from MyIsam
- Re: Right Date format mask
- Re: Access denied; you need the RELOAD privilege for this operation
- Re: many-inserts go faster the second time
Oct 2009
- Re: Dump / restore rows in table?
- Re: Low performance due high network latency - batching ?
- Re: MySQL - determine last date of shutdown and analyze
Nov 2009
Jan 2010
- Re: Can't open file error number 24
- Re: Better that `NOT IN`
- Re: query returning empty row
- Re: Subquery performance slow to non-existent...
- Re: Event feature already working in Server 5.1.37
- Re: Event feature already working in Server 5.1.37
Feb 2010
Mar 2010
- Re: 5.1.42 community version select ordno>=' ' error (2)
- Re: 5.1.44 community version select ordno>=' ' error (2)
- Re: mysql & RAID
- Re: Is Mysql for freebsd 8.0 available?
Apr 2010
- Re: MyISAM better than innodb for large files?
- Re: Recommended swap partition size
- Re: Make delete requests without impact on a database
- Re: CLI can't read data from table
- Re: How to select rows from only the first N rows in a table?
May 2010
Jun 2010
- Re: Missing database file names
- Re: Geting current user pasword.
- Re: selecting data for computation
- Re: selecting data for computation
Jul 2010
- Re: update replace() regex
- Re: Innodb Choosing Random Index
- Re: idle query
- Re: idle query
- Re: idle query
- Re: idle query
- Re: idle query
- Re: IS NULL returns Empty set, but I have empty items
Aug 2010
- Re: Performing subtraction between fields
- Re: How many pager command within mysql command line client?
- Re: Fast Index Creation and fill factor
Sep 2010
- Re: Too Strange for Words
- Re: Migrating my mindset from MyISAM to InnoDB
- Re: INSERT DELAYED and created_on timestamps
Oct 2010
Dec 2010
Jan 2011
Mar 2011
May 2011
Jun 2011
Jul 2011
Aug 2011
- Re: Extraneous warning 1292 (Incorrect datetime value)
- Re: a lesson in query writing and (maybe) a bug report
Sep 2011
Oct 2011
- Re: User defined Variables
- Re: How to enable tabular output when reading command from file?
- Re: User defined Variables