An error occurred fetching the project authors.
- 18 Jun, 2007 1 commit
-
-
thek@adventure.(none) authored
When all table blocks were removed from the query cache the client session hung in a tight loop waiting on an impossible condition while consuming a lot of CPU. This patch also corrects an error which caused valid tables to sometimes be removed from the query cache.
-
- 08 May, 2007 3 commits
-
-
thek@adventure.(none) authored
-
thek@adventure.(none) authored
-
thek@adventure.(none) authored
- Queries in the query cache are identified by the individual characters in the query statement, the current database and the current environment expressed as a set of system variable flags. - Since the set of environment flags didn't properly describe the current environment unexpected results were returned from the query cache. - Query cache is now cleared when the variable ft_boolean_syntax is updated. - An identification flag for the variable default_week_format is added to the query cache record. Thanks to Martin Friebe who has supplied significant parts of this patch.
-
- 09 Mar, 2007 1 commit
-
-
guilhem@gbichot3.local authored
Cache". WL#1569 "Prepared Statements: implement support of Query Cache". Prepared SELECTs did not look up in the query cache, and their results were not stored in the query cache. This made them slower than non-prepared SELECTs in some cases. The fix is to re-use the expanded query (the prepared query where "?" placeholders are replaced by their values, at execution time) for searching/storing in the query cache. It works fine for statements prepared via mysql_stmt_prepare(), which are the most commonly used and were the scope of this bugfix and WL. It works less fine for statements prepared via the SQL command PREPARE...FROM, which are still not using the query cache if they have at least one parameter (because then the expanded query contains names of user variables, and user variables don't work with the query cache, even in non-prepared queries). Note that results from prepared SELECTs, which are in the binary protocol, and results from normal SELECTs, which are in the text protocol, ignore each other in the query cache, because a result in the binary protocol should never be served to a SELECT expecting the text protocol and vice-versa. Note, after this patch, bug 25843 starts applying to query cache ("changing default database between PREPARE and EXECUTE of statement breaks binlog"), we need to fix it.
-
- 14 Feb, 2007 1 commit
-
-
msvensson@pilot.mysql.com authored
- Implement --secure-file-priv=<dir> option that limits "load_file", "LOAD DATA" and "SELECT .. INTO OUTFILE" to work with files in specified dir. - Use above option for mysqld in mysql-test-run.pl
-
- 17 Nov, 2006 1 commit
-
-
Fix tests for new behaviour: an error is thrown if a NON DETERMINISTIC stored function (SF) is called during statement-based replication (SBR).
-
- 14 Nov, 2006 1 commit
-
-
evgen@moonbone.local authored
The regression is caused by the fix for bug 14767. When INSERT ... SELECT used a view in the SELECT list that was not inlined, and there was an active transaction, the server could crash in Query_cache::invalidate. On INSERT ... SELECT only the table being inserted into is invalidated. Thus views that can't be inlined are skipped from invalidation. The bug manifests itself in two ways so there is 2 test cases. One checks that the only the table being inserted into is invalidated. And the second one checks that there is no crash on INSERT ... SELECT.
-
- 04 Oct, 2006 1 commit
-
-
msvensson@neptunus.(none) authored
Update tests and result files after running with new mysqltest that better detects problems with test files
-
- 29 Jul, 2006 1 commit
-
-
msvensson@shellback.(none) authored
-
- 20 Jun, 2006 1 commit
-
-
monty@mysql.com authored
SHOW STATUS does not anymore change local status variables (except com_show_status). Global status variables are still updated. SHOW STATUS are not anymore put in slow query log because of no index usage. Implemntation done by removing orig_sql_command and moving logic of SHOW STATUS to mysql_excute_command() This simplifies code and allows us to remove some if statements all over the code. Upgraded uc_update_queries[] to sql_command_flags and added more bitmaps to better categorize commands. This allowed some overall simplifaction when testing sql_command. Fixes bugs: Bug#10210: running SHOW STATUS increments counters it shouldn't Bug#19764: SHOW commands end up in the slow log as table scans
-
- 02 May, 2006 1 commit
-
-
elliot@mysql.com authored
This will make charset code easier to understand
-
- 26 Feb, 2006 1 commit
-
-
monty@mysql.com authored
-
- 24 Feb, 2006 1 commit
-
-
monty@mysql.com authored
(Needed for "list of pushes" web page and autopush)
-
- 26 Jan, 2006 1 commit
-
-
msvensson@neptunus.(none) authored
Cleanup the sideeffects from most of the testcases with sideeffects.
-
- 24 Jan, 2006 1 commit
-
-
msvensson@neptunus.(none) authored
-
- 04 Jan, 2006 1 commit
-
-
holyfoot@deer.(none) authored
Now it supports queries returning several results (particularly important with the SP)
-
- 01 Dec, 2005 1 commit
-
-
bell@sanja.is.com.ua authored
to be in the query cache. (BUG#14652)
-
- 23 Nov, 2005 1 commit
-
-
monty@mysql.com authored
The table opening process now works the following way: - Create common TABLE_SHARE object - Read the .frm file and unpack it into the TABLE_SHARE object - Create a TABLE object based on the information in the TABLE_SHARE object and open a handler to the table object Other noteworthy changes: - In TABLE_SHARE the most common strings are now LEX_STRING's - Better error message when table is not found - Variable table_cache is now renamed 'table_open_cache' - New variable 'table_definition_cache' that is the number of table defintions that will be cached - strxnmov() calls are now fixed to avoid overflows - strxnmov() will now always add one end \0 to result - engine objects are now created with a TABLE_SHARE object instead of a TABLE object. - After creating a field object one must call field->init(table) before using it - For a busy system this change will give you: - Less memory usage for table object - Faster opening of tables (if it's has been in use or is in table definition cache) - Allow you to cache many table definitions objects - Faster drop of table
-
- 29 Sep, 2005 1 commit
-
-
msvensson@neptunus.(none) authored
- Packets out of order when reading cached data stored by a normal select from a ps or vice versa. - Add pkt_nr to query cache flags
-
- 06 Sep, 2005 1 commit
-
-
ramil@mysql.com authored
-
- 04 Aug, 2005 1 commit
-
-
jimw@mysql.com authored
-
- 29 Jul, 2005 1 commit
-
-
hf@deer.(none) authored
notembedded-specific part moved to the new test
-
- 28 Jul, 2005 1 commit
-
-
monty@mysql.com authored
-
- 23 Jul, 2005 1 commit
-
-
bell@sanja.is.com.ua authored
-
- 27 Jun, 2005 1 commit
-
-
bell@sanja.is.com.ua authored
-
- 23 Jun, 2005 1 commit
-
-
bell@sanja.is.com.ua authored
temporary tables of subquery in the from clause just skipped during processing QC tables (BUG#11522)
-
- 14 Jun, 2005 1 commit
-
-
bell@sanja.is.com.ua authored
-
- 10 Apr, 2005 1 commit
-
-
dlenev@mysql.com authored
function". We should not cache queries using CURRENT_USER() function as we do it for some other functions, e.g. USER() function.
-
- 01 Apr, 2005 1 commit
-
-
jimw@mysql.com authored
in the query cache. (Bug #9549)
-
- 11 Mar, 2005 1 commit
-
-
jimw@mysql.com authored
-
- 08 Mar, 2005 1 commit
-
-
jimw@mysql.com authored
administrative statements that may alter the table, such as REPAIR TABLE. (Bug #8480)
-
- 30 Dec, 2004 1 commit
-
-
gluh@gluh.mysql.r18.ru authored
added syntax: 'show variables where', 'show status where', 'show open tables where'
-
- 21 Oct, 2004 1 commit
-
-
bell@sanja.is.com.ua authored
-
- 10 Sep, 2004 1 commit
-
-
bell@sanja.is.com.ua authored
-
- 30 Mar, 2004 1 commit
-
-
bell@sanja.is.com.ua authored
-
- 04 Mar, 2004 1 commit
-
-
bell@sanja.is.com.ua authored
fixed linking query_prealloc_size to query cache presence
-
- 09 Feb, 2004 1 commit
-
-
monty@mysql.com authored
Fixed output from mysqlbinlog when using --skip-comments Fixed warnings from valgrind Fixed ref_length when used with HEAP tables More efficent need_conversion() Fixed error handling in UPDATE with not updateable tables Fixed bug in null handling in CAST to signed/unsigned
-
- 10 Dec, 2003 1 commit
-
-
Deprecate the use of TYPE=... Preferred syntax is ENGINE=
-
- 04 Dec, 2003 1 commit
-
-
bell@sanja.is.com.ua authored
-