search

tony2001 / pinba_engine

Pinba - MySQL plugin and storage engine
http://pinba.org
GNU General Public License v2.0
475 stars 41 forks source link

Can't create any table using ENGINE=PINBA #39

Open iowelinux opened 9 years ago

iowelinux commented 9 years ago

Hello,

I use Centos 6.5 x86_64. pinba_engine was compiled and installed successfully.

mysql> show engines \G Engine: PINBA Support: YES Comment: Pinba engine Transactions: NO XA: NO Savepoints: NO

mysql> show plugins \G

Name: PINBA Status: ACTIVE Type: STORAGE ENGINE Library: libpinba_engine.so License: GPL

However it is not possible to create any table with PINBA engine:

mysql> create table test (id int(8)) ENGINE=PINBA; Query OK, 0 rows affected (0.00 sec)

mysql> show tables; Empty set (0.00 sec)

Is there a way I can debug the engine? BTW, I speak Russian if you'd like to speak it.

tony2001 commented 9 years ago

There's no point in creating this particular table. All Pinba tables are fixed-column views providing access to the data in memory. Try to create default tables with mysql < default_tables.sql. Pinba reads the table comment and determins how this particular table should behave.

iowelinux commented 9 years ago

Well actually I've already tried to import data from default_tables.sql with no luck. show tables doesn't show anything after the import

tony2001 commented 9 years ago

Do you see any errors?

iowelinux commented 9 years ago

No I don't.

150331 11:05:55 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.1.73-rel14.11' socket: '/var/lib/mysql/mysql.sock' port: 3306 Percona Server (GPL), 14.11, Revision 603 150331 11:09:28 [Warning] option 'pinba-temp-pool-size-limit': signed value 0 adjusted to 1000 150331 11:09:28 [Warning] option 'plugin-pinba-temp-pool-size-limit': signed value 0 adjusted to 1000

tony2001 commented 9 years ago

So it just performs all the queries from default_tables.sql with no errors whatsoever?

iowelinux commented 9 years ago

Exactly!

[root@houston tony2001-pinba_engine-cc33203]# mysql pinba < default_tables.sql [root@houston tony2001-pinba_engine-cc33203]#

tony2001 commented 9 years ago

Did you build Pinba yourself or did you use some package?

iowelinux commented 9 years ago

I've built by myself using mysql-5.1.73 source. ./configure --prefix=/usr --with-mysql=../mysql-5.1.73 --libdir=/usr/lib64/mysql/plugin/

tony2001 commented 9 years ago

Please make sure the sources are configured using the same options as the mysqld server you're using - the options are usually present in the package spec file. You might want to try to build mysqld server yourself - this way it'll work for sure.

travmi commented 9 years ago

I keep receiving the following error when using the default tables sql file: ERROR 1005 (HY000) at line 242: Can't create table 'pinba.report_by_status' (errno: 140)

Setup: I'm using all the packages from the Pinba repository. http://yum.aclub.net/pub/linux/centos/6/umask/x86_64/)

Packages: CentOS 6.6, mysql55-server, mysql55-plugin-pinba as well as the required dependencies.

I have the Pinba Plugin installed on the Mysql server as well.