0021742: indices en las tablas - MantisBT - Signup temporarily disabled due to spam

ID	Project	Category	View Status	Date Submitted	Last Update

0021742	mantisbt	db mysql	public	2016-10-03 18:54	2016-10-28 10:43

Reporter	lzambrano	Assigned To	atrol
Priority	urgent	Severity	major	Reproducibility	random
Status	closed	Resolution	no change required
Platform	linux	OS	redhad	OS Version	6
Product Version	1.2.0

Summary	0021742: indices en las tablas
Description	Buenas tardes cuento con el sistema mantis y tengo problemas de lentitud en la BD y consultas que se cuelgan en el servidor ya vamos en 1466479 ticket generados y sigen subiendo se procedio en frametar la informacion por años pero unas cuantas tablas no se pueden realizar ya que no cuentan con indices por años favor de considerar este comentario ejemplo de tabla mantis_custom_field_string_table no puedo separar la informacion por años y liberar las consultas
Tags	No tags attached.

atrol 2016-10-03 19:06 developer ~0054117 Last edited: 2016-10-03 19:06	English please. 1.2.0 is quite outdated, you should upgrade your installation in a first step, at least to 1.2.20. After that, provide detailed step by step instructions to reproduce the issue. The following additional information may also be useful: Exact version of MantisBT, PHP, Database, Web server, Browser and Operating System Relevant customizations (e.g. changes in config_inc.php, etc) Installed plugins or custom functions ? Was the MantisBT source code modified in any way ?

lzambrano 2016-10-07 12:40 reporter ~0054171	Good afternoon I am counting on the mantis system and have problems of slow queries the database and hang on the server and we go on and generated ticket 1,466,479 sigen up we proceeded in frametar information for years but a few tables can not be made because they have no indices for years Please consider this comment mantis_custom_field_string_table example table can not separate the information for years It is a theme of your tables that no indices but not the mantis system

atrol 2016-10-07 13:50 developer ~0054173	and have problems of slow queries the database Which query is slow?

atrol 2016-10-17 09:19 developer ~0054249	lzambrano, You did not provide feedback; I am therefore resolving this issue as "no change required". Feel free to reopen the issue at a later time and provide the requested information.