splitting mysqlapi