Startup memory difference Percona Server vs MariaDB

When browsing for FreeBSD ports on database section I stumbleupon percona server and decide to see whats the difference between pkg and ports : update pkg # pkg update Updating FreeBSD repository catalogue… FreeBSD repository is up-to-date. All repositories are up-to-date. # update ports #portsnap fetch #portsnap extract pkg and ports give same version : …

More

Can’t locate Compress/Zlib.pm

edp# perl /usr/local/sbin/mysqlblasy.pl Can’t locate Compress/Zlib.pm in @INC (@INC contains: /usr/local/lib/perl5/5.8.8/BSDPAN /usr/local/lib/perl5/site_perl/5.8.8/mach /usr/local/lib/perl5/site_perl/5.8.8 /usr/local/lib/perl5/site_perl /usr/local/lib/perl5/5.8.8/mach /usr/local/lib/perl5/5.8.8 .) at /usr/local/lib/perl5/site_perl/5.8.8/Archive/Zip.pm line 11. BEGIN failed–compilation aborted at /usr/local/lib/perl5/site_perl/5.8.8/Archive/Zip.pm line  11. Compilation failed in require at /usr/local/sbin/mysqlblasy.pl line 1340. BEGIN failed–compilation aborted at /usr/local/sbin/mysqlblasy.pl line 1340. Solution : edp# cd /usr/ports/archivers/ edp# cd p5-Compress-Zlib && make install edp# …

More

MYSQL server has gone away

Its very rare case when I see message : “MYSQL server has gone away” , a few things to consider are : * Check variable max_timeout * Check variable max_allowed_packet These setting available in my.ini or my.cf file, edit the value and restart mysql daemon. Example : max_allowed_packet=16M max_timeout=28800 Try again to import database using …

More

Unknown SMSD service type (“MYSQL”)

That message show up when I install gammu from source in Ubuntu server 8.04 : root@dns:/home/edpteam# gammu –smsd MYSQL smsdrc Unknown SMSD service type (“MYSQL”) After dig in mailing list I have clue to install mysql library : apt-get install libmysqlclient15-dev apt-get install libmysqlclient15-dev Reading package lists… Done Building dependency tree Reading state information… Done …

More

Stop GAMMU smsd (27)

C:\gammu2>gammu –smsd MYSQL smsdrc Log filename is “smsdlog” Stop GAMMU smsd (27) Fri 2008/06/06 11:06:10 : Stop GAMMU smsd (27) Fri 2008/06/06 11:06:53 : Start GAMMU smsd Fri 2008/06/06 11:06:53 : PIN code is “1234” Fri 2008/06/06 11:06:53 : commtimeout=1, sendtimeout=10, receivefrequency=0, resetfrequency=0 Fri 2008/06/06 11:06:53 : deliveryreport = no Fri 2008/06/06 11:06:53 : phoneid …

More

MySQL and Null

Just for my own record, dealing with Null type field. Checking with : select * from tablename where field1=”  -> this one not work select * from tablename where field1=’Null’ -> same too is null is the answer select * from tablename where field1 is null Save my day, thanks to St4r

Mysql Trigger Tutorial and Tools

Deal with gammu and mysql make learn more about mysql feature in mysql 5.0 called trigger. Books always good to start with so I choose MySQL Stored Procedure Programming book to start with but others might help to for someone looking for practical solution in cookbook form etc : High Performance MySQL: Optimization, Backups, Replication, …

More

Postfix and LOCK tables

just found error in /var/log/messages and when I try to backup postfix database. mail# mysqldump -upostfix -p postfix > postfix.sql Enter password: mysqldump: Got error: 1044: Access denied for user ‘postfix’@’localhost’ to database ‘postfix’ when using LOCK TABLES checking user privileges using information_schema mail# mysql -upostfix -p Enter password: Welcome to the MySQL monitor.  Commands …

More

MySQL date range, case study

Just stumble upon situation where I need to find out if specific date in a date range. I’ve try using lower than with greater than operator and use between in second attempt. Quick mysql shell mode Microsoft Windows XP [Version 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. C:\Documents and Settings\alam>cd c:\appserv\mysql\bin   C:\AppServ\mysql\bin>mysql -uroot -p Enter …

More

Export picture from mysql database to file

[amazonify]032152599X:left[/amazonify] As our data getting mobile and copying picture is annoying for me I decide to save the picture in the database (mysql). Another challenge came when other division need the data exported in a directory with same dimension (135 x 180 pixel). Structure for table ‘student_pic’  : CREATE TABLE `student_pic` (   `image_id` int(10) …

More

Get table diff with sqlyog

As the job area getting bigger and bigger, new tables created and others table get normalize. It’s often to see adding field or remove some field from table. Development phase also take some place and different computer.  Need more time to get ‘whats new‘ in table structure. An illustration for example : Working to make …

More

ERROR 2003: Can’t connect to MySQL server

I Need to add remote user for add, select, update and delete in mysql. grant select,insert,update,delete on postfix.* to "postfix_rc"@"%" identified by "postfix_xxxxyyy" with grant option; try to access : -bash-2.05b$ mysql -upostfix_rc -p -h 172.88.1.5 Enter password: ERROR 2003: Can’t connect to MySQL server on ‘172.88.1.5’ (61) according to this, that means no tcp/ip …

More