<div dir="ltr">I'm trying to use the <i>Tablespace fragmentation control</i> function, but it throws an error about me not having "(at least one of) the PROCESS privilege(s)" (see below).<div><br></div><div>I've granted myself every logical privilege that's available (the ones I haven't granted myself are illogical, e.g. restricted and normal corpus access when I already have full access). </div><div><br></div><div>So what privileges do you need to use this function, and how do you create and/or grant them?</div><div><br></div><div>Thanks in advance!</div><div>Scott</div><div><br></div><div><table class="gmail-concordtable gmail-fullwidth" style="width:1454px;border-style:solid;border-color:rgb(255,255,255);border-width:5px;color:rgb(0,0,0);font-family:"Times New Roman";font-size:medium"><tbody><tr><th class="gmail-concordtable" colspan="5" style="padding:7px 3px;background-color:rgb(255,136,153);border-style:solid;border-color:rgb(255,255,255);border-width:2px;font-family:"Open Sans",Arial,Helvetica,Verdana,sans-serif">Tablespace fragmentation control</th></tr><tr><td class="gmail-concordgrey" colspan="5" style="padding:3px 7px;background-color:rgb(213,213,213);font-size:10pt;border-style:solid;border-color:rgb(255,255,255);border-width:2px;font-family:"Open Sans",Arial,Helvetica,Verdana,sans-serif"><p>MySQL InnoDB database tables are stored in tablespace files. These files can become fragmented, in which case they will begin to occupy more disk space than they theoretically ought to. This can cause the cache to overflow.</p><p>Using the "Optimise" command can reduce the space occupied by a tablespace file so that it does not overflow.</p><p>The display below lists all CQPweb cache-database tablefiles, in order of how fragmented they appear to be.</p></td></tr><tr><th class="gmail-concordtable" style="padding:7px 3px;background-color:rgb(255,136,153);border-style:solid;border-color:rgb(255,255,255);border-width:2px;font-family:"Open Sans",Arial,Helvetica,Verdana,sans-serif">Table name</th><th class="gmail-concordtable" style="padding:7px 3px;background-color:rgb(255,136,153);border-style:solid;border-color:rgb(255,255,255);border-width:2px;font-family:"Open Sans",Arial,Helvetica,Verdana,sans-serif">Theoretical size</th><th class="gmail-concordtable" style="padding:7px 3px;background-color:rgb(255,136,153);border-style:solid;border-color:rgb(255,255,255);border-width:2px;font-family:"Open Sans",Arial,Helvetica,Verdana,sans-serif">Size on disk</th><th class="gmail-concordtable" style="padding:7px 3px;background-color:rgb(255,136,153);border-style:solid;border-color:rgb(255,255,255);border-width:2px;font-family:"Open Sans",Arial,Helvetica,Verdana,sans-serif">Ratio</th><th class="gmail-concordtable" style="padding:7px 3px;background-color:rgb(255,136,153);border-style:solid;border-color:rgb(255,255,255);border-width:2px;font-family:"Open Sans",Arial,Helvetica,Verdana,sans-serif">Optimise</th></tr><tr><td class="gmail-concorderror" style="padding:3px 7px;background-color:rgb(221,221,255);font-size:10pt;border-style:solid;border-color:rgb(255,255,255);border-width:2px;font-family:"Open Sans",Arial,Helvetica,Verdana,sans-serif"><p class="errormessage" style="font-size:large">An SQL query did not run successfully!</p><p class="errormessage" style="font-size:large">Original query: select `NAME` from `INFORMATION_SCHEMA`.`INNODB_SYS_TABLESPACES` limit 1 /* from User: scott | Function: can_get_sql_real_size() | 2019-Jun-14 12:46 */</p><p class="errormessage" style="font-size:large">Error # 1227: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation</p></td></tr><tr><th class="gmail-concordtable" style="padding:7px 3px;background-color:rgb(255,136,153);border-style:solid;border-color:rgb(255,255,255);border-width:2px;font-family:"Open Sans",Arial,Helvetica,Verdana,sans-serif">PHP debugging backtrace</th></tr><tr><td class="gmail-concorderror" style="padding:3px 7px;background-color:rgb(221,221,255);font-size:10pt;border-style:solid;border-color:rgb(255,255,255);border-width:2px;font-family:"Open Sans",Arial,Helvetica,Verdana,sans-serif"><pre>array(6) {
[1]=>
array(4) {
["file"]=>
string(42) "/var/www/html/cqpweb/lib/exiterror-lib.php"
["line"]=>
int(300)
["function"]=>
string(9) "exiterror"
["args"]=>
array(3) {
[0]=>
array(3) {
[0]=>
string(38) "An SQL query did not run successfully!"
[1]=>
string(173) "Original query:
select `NAME` from `INFORMATION_SCHEMA`.`INNODB_SYS_TABLESPACES` limit 1
/* from User: scott | Function: can_get_sql_real_size() | 2019-Jun-14 12:46 */
"
[2]=>
string(100) "Error # 1227: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation "
}
[1]=>
NULL
[2]=>
NULL
}
}
[2]=>
array(4) {
["file"]=>
string(36) "/var/www/html/cqpweb/lib/sql-lib.php"
["line"]=>
int(198)
["function"]=>
string(20) "exiterror_mysqlquery"
["args"]=>
array(3) {
[0]=>
int(1227)
[1]=>
string(85) "Access denied; you need (at least one of) the PROCESS privilege(s) for this operation"
[2]=>
string(153) "select `NAME` from `INFORMATION_SCHEMA`.`INNODB_SYS_TABLESPACES` limit 1
/* from User: scott | Function: can_get_sql_real_size() | 2019-Jun-14 12:46 */"
}
}
[3]=>
array(4) {
["file"]=>
string(36) "/var/www/html/cqpweb/lib/sql-lib.php"
["line"]=>
int(906)
["function"]=>
string(12) "do_sql_query"
["args"]=>
array(1) {
[0]=>
string(153) "select `NAME` from `INFORMATION_SCHEMA`.`INNODB_SYS_TABLESPACES` limit 1
/* from User: scott | Function: can_get_sql_real_size() | 2019-Jun-14 12:46 */"
}
}
[4]=>
array(4) {
["file"]=>
string(53) "/var/www/html/cqpweb/lib/admin-cachecontrol-forms.php"
["line"]=>
int(1217)
["function"]=>
string(21) "can_get_sql_real_size"
["args"]=>
array(0) {
}
}
[5]=>
array(4) {
["file"]=>
string(38) "/var/www/html/cqpweb/lib/adminhome.php"
["line"]=>
int(358)
["function"]=>
string(30) "printquery_innodbfragmentation"
["args"]=>
array(0) {
}
}
[6]=>
array(4) {
["file"]=>
string(34) "/var/www/html/cqpweb/adm/index.php"
["line"]=>
int(1)
["args"]=>
array(1) {
[0]=>
string(38) "/var/www/html/cqpweb/lib/adminhome.php"
}
["function"]=>
string(7) "require"
}
}</pre></td></tr></tbody></table></div></div>