Recent changes to 294: High CPU usage by mysqld in phpipamhttps://sourceforge.net/p/phpipam/support-requests/294/2019-03-04T12:09:49.909000ZRecent changes to 294: High CPU usage by mysqld in phpipamHigh CPU usage by mysqld in phpipam2019-03-04T12:09:49.909000Z2019-03-04T12:09:49.909000ZAnonymoushttps://sourceforge.net/u/userid-None/https://sourceforge.net665ee1d8e80c3ad585b9ea7e056fbafe5bea6577<div class="markdown_content"><p>Hi</p>
<p>Referring to the case : <a href="https://sourceforge.net/p/phpipam/support-requests/253/">https://sourceforge.net/p/phpipam/support-requests/253/</a></p>
<p>To resolve when "ALTER TABLE <code>ipaddresses</code> ADD INDEX (<code>subnetId</code>);" is given, it shows the below error:</p>
<p>mysql> ALTER TABLE ipaddresses ADD INDEX (subnetId);<br/>
ERROR 1170 (42000): BLOB/TEXT column 'subnetId' used in key specification without a key length</p>
<p>This is the output of SHOW CREATE TABLE ipaddresses ;</p>
<p>===============================================<br/>
+-------------+----------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- --------------+<br/>
| Table | Create Table |<br/>
+-------------+----------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- --------------+<br/>
| ipaddresses | CREATE TABLE <code>ipaddresses</code> (<br/>
<code>id</code> int(11) NOT NULL AUTO_INCREMENT,<br/>
<code>subnetId</code> text NOT NULL,<br/>
<code>ip_addr</code> varchar(100) NOT NULL,<br/>
<code>description</code> varchar(64) DEFAULT NULL,<br/>
<code>dns_name</code> varchar(64) NOT NULL,<br/>
<code>mac</code> varchar(20) DEFAULT NULL,<br/>
<code>owner</code> varchar(32) DEFAULT NULL,<br/>
<code>state</code> varchar(1) DEFAULT '1',<br/>
<code>switch</code> varchar(32) DEFAULT NULL,<br/>
<code>port</code> varchar(32) DEFAULT NULL,<br/>
<code>note</code> text,<br/>
PRIMARY KEY (<code>id</code>)<br/>
) ENGINE=MyISAM AUTO_INCREMENT=9925 DEFAULT CHARSET=utf8 |<br/>
+-------------+----------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- --------------+<br/>
1 row in set (0.00 sec)</p>
<p>===============================================</p>
<p>Could you please check and suggest a solution for this?</p>
<p>Thanks.</p></div>