What decide Storage Engine you should use?

answer: locking and concurrency as well as transactions the storage engine can handle

To KILL a mysql process from SHOWED Processlist

to show the processlist and get the THREAD ID  to kill the process

 mysql> SHOW PROCESSLIST;

 
 use the KILL command followed by the thread ID returned by SHOW PROCESSLIST:
 mysql> KILL 27;
 Query OK, 0 rows affected (0.05 sec)
To kill the query being executed by a thread but leave the connection active (yes, MySQL even allows such fine-grained control), use the KILL QUERY command instead, followed by the appropriate thread ID.
 

To check the Database size for mysql

SELECT 

CONCAT(sum(ROUND(((DATA_LENGTH + INDEX_LENGTH - DATA_FREE) / 1024 / 1024),2))," MB") AS Size FROM INFORMATION_SCHEMA.TABLES where TABLE_SCHEMA like 'nplay' ;

To check mysql database size

run the sql query below:

SELECT TABLE_SCHEMA AS 'Database', TABLE_NAME AS 'Table',

CONCAT(ROUND(((DATA_LENGTH + INDEX_LENGTH - DATA_FREE) / 1024 / 1024),2)," Mb") AS Size FROM INFORMATION_SCHEMA.TABLES;

Miva Merchant 5.5

Miva Merchant - an online shopping cart .... 

using their own proprietary scripts language ......

the source file in .MV extension 

the compiled binary file would call .MVC 

the scripts compiler call MIVA Scripts compiler, which is free .. BUT, you still need to register it with the license come together with your MIVA merchant