- Git - lists.phpmyadmin.net

[Phpmyadmin-git] [SCM] phpMyAdmin branch, master, updated. RELEASE_3_4_3_1-13283-gff6b491
by Madhura Jayaratne 07 Aug '11

07 Aug '11

The branch, master has been updated via ff6b491a63d8053b34f3e7e1f9c9049ffc4f7919 (commit) from a137097f20211f2393bd4a2283773e3afb2695ca (commit) - Log ----------------------------------------------------------------- commit ff6b491a63d8053b34f3e7e1f9c9049ffc4f7919 Author: Madhura Jayaratne <madhura.cj(a)gmail.com> Date: Sun Aug 7 18:49:34 2011 +0530 Typo ----------------------------------------------------------------------- Summary of changes: ChangeLog | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/ChangeLog b/ChangeLog index ca7feb5..128f603 100644 --- a/ChangeLog +++ b/ChangeLog @@ -46,7 +46,7 @@ phpMyAdmin - ChangeLog - bug #3375325 [interface] Page list in navigation frame looks odd - bug #3313235 [interface] Error div misplaced - bug #3374802 [interface] Comment on a column breaks inline editing -- bug #3383711 [display] Order by a column in a view doesn't work in some cases +- patch #3383711 [display] Order by a column in a view doesn't work in some cases - bug #3386434 [interface] Add missing space to server status 3.4.4.0 (not yet released) hooks/post-receive -- phpMyAdmin

1 0

[Phpmyadmin-git] [SCM] phpMyAdmin branch, master, updated. RELEASE_3_4_3_1-13282-ga137097
by Madhura Jayaratne 07 Aug '11

07 Aug '11

The branch, master has been updated via a137097f20211f2393bd4a2283773e3afb2695ca (commit) from 275637daa25a94e8e29f07137403a7a17aac9b1d (commit) - Log ----------------------------------------------------------------- commit a137097f20211f2393bd4a2283773e3afb2695ca Author: Madhura Jayaratne <madhura.cj(a)gmail.com> Date: Sun Aug 7 18:41:04 2011 +0530 Wrong ChangeLog entry ----------------------------------------------------------------------- Summary of changes: ChangeLog | 1 - 1 files changed, 0 insertions(+), 1 deletions(-) diff --git a/ChangeLog b/ChangeLog index 6bc67e4..ca7feb5 100644 --- a/ChangeLog +++ b/ChangeLog @@ -48,7 +48,6 @@ phpMyAdmin - ChangeLog - bug #3374802 [interface] Comment on a column breaks inline editing - bug #3383711 [display] Order by a column in a view doesn't work in some cases - bug #3386434 [interface] Add missing space to server status -- patch #3385954 [interface] "Unknown table status: Create_time" on dispalying view 3.4.4.0 (not yet released) - bug #3323060 [parser] SQL parser breaks AJAX requests if query has unclosed quotes hooks/post-receive -- phpMyAdmin

1 0

[Phpmyadmin-git] [SCM] phpMyAdmin branch, master, updated. RELEASE_3_4_3_1-13281-g275637d
by Madhura Jayaratne 07 Aug '11

07 Aug '11

The branch, master has been updated via 275637daa25a94e8e29f07137403a7a17aac9b1d (commit) via fcb4986598223d6aa61bc2d1d6c6215bf9fdfda5 (commit) via ed45a8e1f5502995c219144d4dbbb2b276aec28d (commit) from a11a782cb6a387a9defb380887844ccd7bcbe96b (commit) - Log ----------------------------------------------------------------- commit 275637daa25a94e8e29f07137403a7a17aac9b1d Author: Madhura Jayaratne <madhura.cj(a)gmail.com> Date: Sun Aug 7 18:33:13 2011 +0530 ChangeLog entry for patch #3385954 commit fcb4986598223d6aa61bc2d1d6c6215bf9fdfda5 Author: Sven Strickroth <email(a)cs-ware.de> Date: Thu Aug 4 01:50:04 2011 +0200 there is no create_time-status for views Signed-off-by: Sven Strickroth <email(a)cs-ware.de> commit ed45a8e1f5502995c219144d4dbbb2b276aec28d Author: Sven Strickroth <email(a)cs-ware.de> Date: Thu Aug 4 01:31:30 2011 +0200 use i10n for error message Signed-off-by: Sven Strickroth <email(a)cs-ware.de> ----------------------------------------------------------------------- Summary of changes: ChangeLog | 1 + libraries/Table.class.php | 8 ++++---- libraries/display_tbl.lib.php | 6 ++++-- 3 files changed, 9 insertions(+), 6 deletions(-) diff --git a/ChangeLog b/ChangeLog index ca7feb5..6bc67e4 100644 --- a/ChangeLog +++ b/ChangeLog @@ -48,6 +48,7 @@ phpMyAdmin - ChangeLog - bug #3374802 [interface] Comment on a column breaks inline editing - bug #3383711 [display] Order by a column in a view doesn't work in some cases - bug #3386434 [interface] Add missing space to server status +- patch #3385954 [interface] "Unknown table status: Create_time" on dispalying view 3.4.4.0 (not yet released) - bug #3323060 [parser] SQL parser breaks AJAX requests if query has unclosed quotes diff --git a/libraries/Table.class.php b/libraries/Table.class.php index d2a0dbe..80ab727 100644 --- a/libraries/Table.class.php +++ b/libraries/Table.class.php @@ -300,7 +300,7 @@ class PMA_Table if (! isset(PMA_Table::$cache[$db][$table][$info])) { if (! $disable_error) { - trigger_error('unknown table status: ' . $info, E_USER_WARNING); + trigger_error(__('unknown table status: ') . $info, E_USER_WARNING); } return false; } @@ -1338,7 +1338,7 @@ class PMA_Table } } else if ($property == self::PROP_COLUMN_ORDER || $property == self::PROP_COLUMN_VISIB) { - if (isset($this->uiprefs[$property])) { + if (! PMA_Table::isView($this->db_name, $this->name) && isset($this->uiprefs[$property])) { // check if the table has not been modified if (self::sGetStatusInfo($this->db_name, $this->name, 'Create_time') == $this->uiprefs['CREATE_TIME']) { @@ -1376,8 +1376,8 @@ class PMA_Table $this->loadUiPrefs(); } // we want to save the create time if the property is PROP_COLUMN_ORDER - if ($property == self::PROP_COLUMN_ORDER || - $property == self::PROP_COLUMN_VISIB) { + if (! PMA_Table::isView($this->db_name, $this->name) && ($property == self::PROP_COLUMN_ORDER || + $property == self::PROP_COLUMN_VISIB)) { $curr_create_time = self::sGetStatusInfo($this->db_name, $this->name, 'CREATE_TIME'); if (isset($table_create_time) && diff --git a/libraries/display_tbl.lib.php b/libraries/display_tbl.lib.php index 797a3eb..19a1749 100644 --- a/libraries/display_tbl.lib.php +++ b/libraries/display_tbl.lib.php @@ -414,8 +414,10 @@ function PMA_displayTableNavigation($pos_next, $pos_prev, $sql_query, $id_for_di echo '<input id="col_visib" type="hidden" value="' . implode(',', $col_visib) . '" />'; } // generate table create time - echo '<input id="table_create_time" type="hidden" value="' . - PMA_Table::sGetStatusInfo($GLOBALS['db'], $GLOBALS['table'], 'Create_time') . '" />'; + if (! PMA_Table::isView($GLOBALS['table'], $GLOBALS['db'])) { + echo '<input id="table_create_time" type="hidden" value="' . + PMA_Table::sGetStatusInfo($GLOBALS['db'], $GLOBALS['table'], 'Create_time') . '" />'; + } } // generate hints echo '<input id="col_order_hint" type="hidden" value="' . __('Drag to reorder') . '" />'; hooks/post-receive -- phpMyAdmin

1 0

[Phpmyadmin-git] [SCM] phpMyAdmin branch, master, updated. RELEASE_3_4_3_1-13278-ga11a782
by Madhura Jayaratne 07 Aug '11

07 Aug '11

The branch, master has been updated via a11a782cb6a387a9defb380887844ccd7bcbe96b (commit) via 969c59e8a676746c5a14881698fb473bd4c60c26 (commit) via 7b13b6f8645ad3514e8aa1472562c8fbffd20d11 (commit) from a5394bdc1de0382f7939233a04a0b5f3a0491219 (commit) - Log ----------------------------------------------------------------- commit a11a782cb6a387a9defb380887844ccd7bcbe96b Merge: 969c59e8a676746c5a14881698fb473bd4c60c26 a5394bdc1de0382f7939233a04a0b5f3a0491219 Author: Madhura Jayaratne <madhura.cj(a)gmail.com> Date: Sun Aug 7 18:23:22 2011 +0530 Merge branch 'master' of ssh://phpmyadmin.git.sourceforge.net/gitroot/phpmyadmin/phpmyadmin commit 969c59e8a676746c5a14881698fb473bd4c60c26 Merge: 55c6eacf3e56da064dae69650480d84acd92d5a3 7b13b6f8645ad3514e8aa1472562c8fbffd20d11 Author: Madhura Jayaratne <madhura.cj(a)gmail.com> Date: Sun Aug 7 18:21:34 2011 +0530 Merge branch 'QA_3_4' Conflicts: server_status.php ----------------------------------------------------------------------- Summary of changes: Documentation.html | 1 + 1 files changed, 1 insertions(+), 0 deletions(-) diff --git a/Documentation.html b/Documentation.html index 393e5c7..72387ab 100644 --- a/Documentation.html +++ b/Documentation.html @@ -3095,6 +3095,7 @@ RewriteRule .* - [E=REMOTE_USER:%{HTTP:Authorization},L] <li><a href="http://www.hardened-php.net/suhosin/configuration.html#suhosin.post.max_arr…">suhosin.post.max_array_index_length</a> should be increased (eg. 256)</li> <li><a href="http://www.hardened-php.net/suhosin/configuration.html#suhosin.request.max_…">suhosin.request.max_totalname_length</a> should be increased (eg. 8192)</li> <li><a href="http://www.hardened-php.net/suhosin/configuration.html#suhosin.post.max_tot…">suhosin.post.max_totalname_length</a> should be increased (eg. 8192)</li> + <li><a href="http://www.hardened-php.net/suhosin/configuration.html#suhosin.get.max_valu…">suhosin.get.max_value_length</a> should be increased (eg. 1024)</li> <li><a href="http://www.hardened-php.net/suhosin/configuration.html#suhosin.sql.bailout_…">suhosin.sql.bailout_on_error</a> needs to be disabled (the default)</li> <li><a href="http://www.hardened-php.net/suhosin/configuration.html#logging_configuration">suhosin.log.*</a> should not include SQL, otherwise you get big slowdown</li> </ul> hooks/post-receive -- phpMyAdmin

1 0

[Phpmyadmin-git] [SCM] phpMyAdmin branch, QA_3_4, updated. RELEASE_3_4_3_1-67-g7b13b6f
by Madhura Jayaratne 07 Aug '11

07 Aug '11

The branch, QA_3_4 has been updated via 7b13b6f8645ad3514e8aa1472562c8fbffd20d11 (commit) from 20298630ed949dba0cab7f6b4bb968c8a5de935f (commit) - Log ----------------------------------------------------------------- commit 7b13b6f8645ad3514e8aa1472562c8fbffd20d11 Author: Madhura Jayaratne <madhura.cj(a)gmail.com> Date: Sun Aug 7 18:08:25 2011 +0530 Documentation about suhosin.get.max_value_length limitation ----------------------------------------------------------------------- Summary of changes: Documentation.html | 1 + 1 files changed, 1 insertions(+), 0 deletions(-) diff --git a/Documentation.html b/Documentation.html index d7f2501..f8791d6 100644 --- a/Documentation.html +++ b/Documentation.html @@ -3036,6 +3036,7 @@ RewriteRule .* - [E=REMOTE_USER:%{HTTP:Authorization},L] <li><a href="http://www.hardened-php.net/suhosin/configuration.html#suhosin.post.max_arr…">suhosin.post.max_array_index_length</a> should be increased (eg. 256)</li> <li><a href="http://www.hardened-php.net/suhosin/configuration.html#suhosin.request.max_…">suhosin.request.max_totalname_length</a> should be increased (eg. 8192)</li> <li><a href="http://www.hardened-php.net/suhosin/configuration.html#suhosin.post.max_tot…">suhosin.post.max_totalname_length</a> should be increased (eg. 8192)</li> + <li><a href="http://www.hardened-php.net/suhosin/configuration.html#suhosin.get.max_valu…">suhosin.get.max_value_length</a> should be increased (eg. 1024)</li> <li><a href="http://www.hardened-php.net/suhosin/configuration.html#suhosin.sql.bailout_…">suhosin.sql.bailout_on_error</a> needs to be disabled (the default)</li> <li><a href="http://www.hardened-php.net/suhosin/configuration.html#logging_configuration">suhosin.log.*</a> should not include SQL, otherwise you get big slowdown</li> </ul> hooks/post-receive -- phpMyAdmin

1 0

[Phpmyadmin-git] [SCM] phpMyAdmin branch, master, updated. RELEASE_3_4_3_1-13275-ga5394bd
by Herman van Rink 06 Aug '11

06 Aug '11

The branch, master has been updated via a5394bdc1de0382f7939233a04a0b5f3a0491219 (commit) via f1025544e631c4006ac42be2ddcc5904b567ae8d (commit) from db29c02f7a96d10e0369e1adf43fd285cdb3f230 (commit) - Log ----------------------------------------------------------------- commit a5394bdc1de0382f7939233a04a0b5f3a0491219 Merge: f1025544e631c4006ac42be2ddcc5904b567ae8d db29c02f7a96d10e0369e1adf43fd285cdb3f230 Author: Herman van Rink <rink(a)initfour.nl> Date: Sat Aug 6 17:13:04 2011 +0200 Merge branch 'master' of ssh://phpmyadmin.git.sourceforge.net/gitroot/phpmyadmin/phpmyadmin commit f1025544e631c4006ac42be2ddcc5904b567ae8d Author: Herman van Rink <rink(a)initfour.nl> Date: Sat Aug 6 17:09:01 2011 +0200 Added SQL dump of databases and tables useful for security testing ----------------------------------------------------------------------- Summary of changes: test/test_data/exploit_test.sql | 150 +++++++++++++++++++++++++++++++++++++++ 1 files changed, 150 insertions(+), 0 deletions(-) create mode 100644 test/test_data/exploit_test.sql diff --git a/test/test_data/exploit_test.sql b/test/test_data/exploit_test.sql new file mode 100644 index 0000000..dce733f --- /dev/null +++ b/test/test_data/exploit_test.sql @@ -0,0 +1,150 @@ +-- phpMyAdmin SQL Dump +-- version 3.5.0-dev +-- http://www.phpmyadmin.net +-- +-- Host: barclay +-- Generation Time: Aug 06, 2011 at 04:53 PM +-- Server version: 5.1.49-3-log +-- PHP Version: 5.3.3-7+squeeze1 + +SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; +SET time_zone = "+00:00"; + + +/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; +/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; +/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; +/*!40101 SET NAMES utf8 */; + +DROP DATABASE `"><script>alert(200);</script>`; +DROP DATABASE `'><script>alert(201);</script>`; +DROP DATABASE `exploit_test`; + +-- +-- Database: `"><script>alert(200);</script>` +-- +CREATE DATABASE `"><script>alert(200);</script>` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci; + +-- +-- Database: `'><script>alert(201);</script>` +-- +CREATE DATABASE `'><script>alert(201);</script>` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci; + +-- +-- Database: `exploit_test` +-- +CREATE DATABASE `exploit_test` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci; +USE `exploit_test`; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `"><script>alert(109);</script>` +-- + +CREATE TABLE IF NOT EXISTS `"><script>alert(109);</script>` ( + `id` int(2) NOT NULL, + `foo` varchar(255) NOT NULL +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +-- +-- Dumping data for table `"><script>alert(109);</script>` +-- + +INSERT INTO `"><script>alert(109);</script>` (`id`, `foo`) VALUES +(1, ''), +(2, ''); + +-- -------------------------------------------------------- + +-- +-- Table structure for table `'; eval('alert(107)')` +-- + +CREATE TABLE IF NOT EXISTS `'; eval('alert(107)')` ( + `id` int(11) NOT NULL +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `'><script>alert(106);</script>` +-- + +CREATE TABLE IF NOT EXISTS `'><script>alert(106);</script>` ( + `id` int(2) NOT NULL +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `<script>alert(105);</script>` +-- + +CREATE TABLE IF NOT EXISTS `<script>alert(105);</script>` ( + `dsaf` int(4) NOT NULL +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +-- +-- Dumping data for table `<script>alert(105);</script>` +-- + +INSERT INTO `<script>alert(105);</script>` (`dsaf`) VALUES +(1); + +-- -------------------------------------------------------- + +-- +-- Table structure for table `evil_column_names` +-- + +CREATE TABLE IF NOT EXISTS `evil_column_names` ( + `<script>alert(100);</script>` int(1) NOT NULL, + `"><script>alert(101);</script>` int(2) NOT NULL, + `'><script>alert(102);</script>` int(2) NOT NULL, + `evil_comment` int(3) NOT NULL COMMENT '<script>alert(104);</script>' +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +-- +-- Dumping data for table `evil_column_names` +-- + +INSERT INTO `evil_column_names` (`<script>alert(100);</script>`, `"><script>alert(101);</script>`, `'><script>alert(102);</script>`, `evil_comment`) VALUES +(1, 23, 45, 5), +(2, 3, 77, 3); + +-- -------------------------------------------------------- + +-- +-- Table structure for table `evil_content` +-- + +CREATE TABLE IF NOT EXISTS `evil_content` ( + `text` varchar(255) NOT NULL + ) ENGINE=MyISAM DEFAULT CHARSET=latin1; + + +-- +-- Dumping data for table `evil_content` +-- + +INSERT INTO `evil_content` (`text`) VALUES +('"><script>alert(301);</script>'), +('''><script>alert(302);</script>'), +('<script>alert(303);</script>'), +('''; eval(''alert(304)'');'); + +-- -------------------------------------------------------- + +-- +-- Table structure for table `evil_table_comment` +-- + +CREATE TABLE IF NOT EXISTS `evil_table_comment` ( + `id` int(1) NOT NULL +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='"><script>alert(400);</script>'; + + +/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; +/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; +/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; hooks/post-receive -- phpMyAdmin

1 0

[Phpmyadmin-git] [SCM] phpMyAdmin branch, master, updated. RELEASE_3_4_3_1-13273-gdb29c02
by Piotr Przybylski 06 Aug '11

06 Aug '11

The branch, master has been updated via db29c02f7a96d10e0369e1adf43fd285cdb3f230 (commit) via 7e749a5f43dfe665cdf566da9963b4b2595fe789 (commit) from 017c1ee960e8f3b3fc2c36e15330c1af72991e4c (commit) - Log ----------------------------------------------------------------- commit db29c02f7a96d10e0369e1adf43fd285cdb3f230 Merge: 7e749a5f43dfe665cdf566da9963b4b2595fe789 017c1ee960e8f3b3fc2c36e15330c1af72991e4c Author: Piotr Przybylski <piotrprz(a)gmail.com> Date: Sat Aug 6 12:54:28 2011 +0200 Merge branch 'master' of ssh://phpmyadmin.git.sourceforge.net/gitroot/phpmyadmin/phpmyadmin Conflicts: libraries/advisory_rules.txt commit 7e749a5f43dfe665cdf566da9963b4b2595fe789 Author: Piotr Przybylski <piotrprz(a)gmail.com> Date: Sat Aug 6 12:50:20 2011 +0200 Fix broken character ----------------------------------------------------------------------- Summary of changes: libraries/advisory_rules.txt | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/libraries/advisory_rules.txt b/libraries/advisory_rules.txt index da95d48..c193f85 100644 --- a/libraries/advisory_rules.txt +++ b/libraries/advisory_rules.txt @@ -139,7 +139,7 @@ rule 'Query cache fragmentation' [!fired('Query cache disabled')] Qcache_free_blocks / (Qcache_total_blocks / 2) * 100 value > 20 The query cache is considerably fragmented. - Severe fragmentation is likely to (further) increase Qcache_lowmem_prunes. This might be caused by many Query cache low memory prunes due to {query_cache_size} being too small. For a immediate but short lived fix you can flush the query cache (might lock the query cache for a long time). Carefully adjusting {query_cache_min_res_unit} to a lower value might help too, e.g. you can set it to the average size of your queries in the cache using this formula: (query_cache_size � qcache_free_memory) / qcache_queries_in_cache + Severe fragmentation is likely to (further) increase Qcache_lowmem_prunes. This might be caused by many Query cache low memory prunes due to {query_cache_size} being too small. For a immediate but short lived fix you can flush the query cache (might lock the query cache for a long time). Carefully adjusting {query_cache_min_res_unit} to a lower value might help too, e.g. you can set it to the average size of your queries in the cache using this formula: (query_cache_size - qcache_free_memory) / qcache_queries_in_cache The cache is currently fragmented by %s% , with 100% fragmentation meaning that the query cache is an alternating pattern of free and used blocks. This value should be below 20%. | round(value,1) rule 'Query cache low memory prunes' [Qcache_inserts > 0 && !fired('Query cache disabled')] hooks/post-receive -- phpMyAdmin

1 0

[Phpmyadmin-git] [SCM] phpMyAdmin branch, master, updated. RELEASE_3_4_3_1-13271-g017c1ee
by Dieter Adriaenssens 06 Aug '11

06 Aug '11

The branch, master has been updated via 017c1ee960e8f3b3fc2c36e15330c1af72991e4c (commit) from 67d5346da5fdcfacdd73bf49c444a88842c88ae7 (commit) - Log ----------------------------------------------------------------- commit 017c1ee960e8f3b3fc2c36e15330c1af72991e4c Author: Dieter Adriaenssens <ruleant(a)users.sourceforge.net> Date: Sat Aug 6 12:24:17 2011 +0200 fix typos ----------------------------------------------------------------------- Summary of changes: libraries/advisory_rules.txt | 4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-) diff --git a/libraries/advisory_rules.txt b/libraries/advisory_rules.txt index 3f3f985..da95d48 100644 --- a/libraries/advisory_rules.txt +++ b/libraries/advisory_rules.txt @@ -78,7 +78,7 @@ rule 'Slow query logging' rule 'Release Series' version !PMA_DRIZZLE && substr(value,0,3) != "5.1" - The MySQL server version less than 5.1. + The MySQL server version is less than 5.1. You should upgrade, as MySQL 5.1 has improved performance, and MySQL 5.5 even more so. Current version: %s | value @@ -139,7 +139,7 @@ rule 'Query cache fragmentation' [!fired('Query cache disabled')] Qcache_free_blocks / (Qcache_total_blocks / 2) * 100 value > 20 The query cache is considerably fragmented. - Severe fragementation is likely to (further) increase Qcache_lowmem_prunes. This might be caused by many Query cache low memory prunes due to {query_cache_size} being too small. For a immediate but short lived fix you can flush the query cache (might lock the query cache for a long time). Carefully adjusting {query_cache_min_res_unit} to a lower value might help too, e.g. you can set it to the average size of your queries in the cache using this formula: (query_cache_size � qcache_free_memory) / qcache_queries_in_cache + Severe fragmentation is likely to (further) increase Qcache_lowmem_prunes. This might be caused by many Query cache low memory prunes due to {query_cache_size} being too small. For a immediate but short lived fix you can flush the query cache (might lock the query cache for a long time). Carefully adjusting {query_cache_min_res_unit} to a lower value might help too, e.g. you can set it to the average size of your queries in the cache using this formula: (query_cache_size � qcache_free_memory) / qcache_queries_in_cache The cache is currently fragmented by %s% , with 100% fragmentation meaning that the query cache is an alternating pattern of free and used blocks. This value should be below 20%. | round(value,1) rule 'Query cache low memory prunes' [Qcache_inserts > 0 && !fired('Query cache disabled')] hooks/post-receive -- phpMyAdmin

1 0

[Phpmyadmin-git] [SCM] phpMyAdmin branch, master, updated. RELEASE_3_4_3_1-13270-g67d5346
by Piotr Przybylski 06 Aug '11

06 Aug '11

The branch, master has been updated via 67d5346da5fdcfacdd73bf49c444a88842c88ae7 (commit) from eb66564960eeb840a7521a35c00d32aebb9525bb (commit) - Log ----------------------------------------------------------------- commit 67d5346da5fdcfacdd73bf49c444a88842c88ae7 Author: Piotr Przybylski <piotrprz(a)gmail.com> Date: Sat Aug 6 11:02:25 2011 +0200 Fix typo ----------------------------------------------------------------------- Summary of changes: server_synchronize.php | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/server_synchronize.php b/server_synchronize.php index 623681c..28a7193 100644 --- a/server_synchronize.php +++ b/server_synchronize.php @@ -913,7 +913,7 @@ if (isset($_REQUEST['synchronize_db'])) { } foreach ($source_tables_uncommon as $tbl_nc_name) { $rows[] = array( - 'src_table_name' => '+ ' + $tbl_nc_name, + 'src_table_name' => '+ ' . $tbl_nc_name, 'dst_table_name' => $tbl_nc_name); } foreach ($target_tables_uncommon as $tbl_nc_name) { hooks/post-receive -- phpMyAdmin

1 0

[Phpmyadmin-git] [SCM] phpMyAdmin branch, master, updated. RELEASE_3_4_3_1-13269-geb66564
by Piotr Przybylski 05 Aug '11

05 Aug '11

The branch, master has been updated via eb66564960eeb840a7521a35c00d32aebb9525bb (commit) from 680cfbe726e52c016435683fec809d105954afa1 (commit) - Log ----------------------------------------------------------------- commit eb66564960eeb840a7521a35c00d32aebb9525bb Author: Piotr Przybylski <piotrprz(a)gmail.com> Date: Fri Aug 5 22:44:06 2011 +0200 Fix typo ----------------------------------------------------------------------- Summary of changes: libraries/advisory_rules.txt | 6 +++--- 1 files changed, 3 insertions(+), 3 deletions(-) diff --git a/libraries/advisory_rules.txt b/libraries/advisory_rules.txt index 9e1b0ec..3f3f985 100644 --- a/libraries/advisory_rules.txt +++ b/libraries/advisory_rules.txt @@ -78,14 +78,14 @@ rule 'Slow query logging' rule 'Release Series' version !PMA_DRIZZLE && substr(value,0,3) != "5.1" - The MySQL server version less then 5.1. + The MySQL server version less than 5.1. You should upgrade, as MySQL 5.1 has improved performance, and MySQL 5.5 even more so. Current version: %s | value rule 'Minor Version' version !PMA_DRIZZLE && substr(value,4,2) < 30 - Version less then 5.1.30 (the first GA release of 5.1). + Version less than 5.1.30 (the first GA release of 5.1). You should upgrade, as recent versions of MySQL 5.1 have improved performance and MySQL 5.5 even more so. Current version: %s | value @@ -139,7 +139,7 @@ rule 'Query cache fragmentation' [!fired('Query cache disabled')] Qcache_free_blocks / (Qcache_total_blocks / 2) * 100 value > 20 The query cache is considerably fragmented. - Severe fragementation is likely to (further) increase Qcache_lowmem_prunes. This might be caused by many Query cache low memory prunes due to {query_cache_size} being too small. For a immediate but short lived fix you can flush the query cache (might lock the query cache for a long time). Carefully adjusting {query_cache_min_res_unit} to a lower value might help too, e.g. you can set it to the average size of your queries in the cache using this formula: (query_cache_size � qcache_free_memory) / qcache_queries_in_cache + Severe fragementation is likely to (further) increase Qcache_lowmem_prunes. This might be caused by many Query cache low memory prunes due to {query_cache_size} being too small. For a immediate but short lived fix you can flush the query cache (might lock the query cache for a long time). Carefully adjusting {query_cache_min_res_unit} to a lower value might help too, e.g. you can set it to the average size of your queries in the cache using this formula: (query_cache_size � qcache_free_memory) / qcache_queries_in_cache The cache is currently fragmented by %s% , with 100% fragmentation meaning that the query cache is an alternating pattern of free and used blocks. This value should be below 20%. | round(value,1) rule 'Query cache low memory prunes' [Qcache_inserts > 0 && !fired('Query cache disabled')] hooks/post-receive -- phpMyAdmin

1 0