… London, November 11-12 at the Millenium Gloucester Conference Center. Login or register as speaker and submit your proposals. Your participation… step up and volunteer to present your unique insights into MySQL and MySQL-related technologies either as a keynote, tutorial or breakout… sponsors. This is the showcase event for Europe’s growing MySQL community of developers, business managers, technology evangelists, DBAs and entrepreneurs…
Comment: Can't Create Thread: Errno 11 (A Tale of Two Ulimits)
April 17, 2013 By 12 Comments
… just restart MySQL from the same session that you were logged in with, or did you start a new login session to do the restart? If you just created the file and then did a restart of MySQL, that… and then log back in, and then do a service mysql restart. Alternatively, you can use the trick in this post…
Comment: Can't Create Thread: Errno 11 (A Tale of Two Ulimits)
April 17, 2013 By 12 Comments
…=/usr –datadir=/var/lib/mysql2 –plugin-dir=/usr/lib64/mysql/plugin –user=mysql –log-error=/var/log/mysqld2.log –open-files-limit…/lib/mysql2/g4.dmz.local.pid –socket=/var/lib/mysql2/mysql.sock –port=3307 $ sudo cat /proc/35967/limits Limit Soft…. 1. ssh to server and stop mysqld 2. logout 3. login to server and start mysqld. And still get: Max processes…
Post: Auditing login attempts in MySQL
December 28, 2012 By 4 Comments
… a recurrent question made by our MySQL Support customers: How can I audit the login attempts in MySQL? Logging all the attempts or… are not too many audit capabilities in MySQL Community so the first option to audit MySQL‘s authentication process is to get… an example: Enable the log: general_log_file = /var/log/mysql/mysql.log general_log = 1 User correctly authenticated: 121227 8:31…
Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
….0.180 root@192.168.0.180′s password: Last login: Fri Feb 22 23:27:49 2013 from percona.<...> [root... mysqld Connect using the mysql client: [root@alarmpi ~]# /usr/bin/mysql Welcome to the MySQL monitor. Commands end with ; or \g. [...] mysql> SHOW ENGINES… few other points: This setup uses Percona Server for MySQL with the latest mysql client, which is untested, but should be “ok…
Post: Profiling MySQL Memory Usage With Valgrind Massif
January 9, 2013 By 3 Comments
…. After mysqld is properly started (check if you can login with your mysql client), you would execute whatever steps you think are…) 0x728DAA: Log_event::read_log_event(st_io_cache*, st_mysql_mutex*, Format_description_log_event const*) (in /usr/local/percona…) 0x728DAA: Log_event::read_log_event(st_io_cache*, st_mysql_mutex*, Format_description_log_event const*) (in /usr/local/percona…
Post: How to use a smartphone for two-factor authentication with Percona Server for MySQL
February 24, 2013 By Leave a Comment
… non-trivial way to authenticate users in Percona Sever for MySQL. Percona Server comes with PAM authentication plugin, which allows you… a smartphone for two-factor authentication with Percona Server for MySQL[/caption] With two-factor authentication a user is required to… to login with user ‘vadim’, the server asks me both password and Verification Code (generated on my smartphone in Authentificator application) mysql…
Post: Secure passwords being insecure
May 27, 2012 By 6 Comments
… combination. Let’s execute the previous examples: Login to mysql: root@debian:~# mysql -uroot -ps11P$||!sh&2 mysql -uroot -ps11P$||shutdown -r now&2… the “shutdown -r now” command from the history. Ok, login to mysql is not very safe. We’re going now to check… –password=3kj39|/etc/init.d/mysql restart Stopping MySQL database server: mysqldinnobackupex: Missing command line argument . Starting MySQL database server: mysqld. In this…
Post: MySQL Consulting - Being on your own
February 20, 2007 By 7 Comments
… market is now great for MySQL Consulting. The number of MySQL users is growing rapidly thanks for MySQL Marketing and Sales departments and… something like broken replication or any other issues we can login and fix it quick. This works especially well for smaller… – it is very hard to find people with good enough MySQL knowledge. MySQL themselves are searching for them, Google is searching for…
Post: Recovering Linux software RAID, RAID5 Array
August 27, 2011 By 2 Comments
Dealing with MySQL you might need to deal with RAID recovery every so …. ReadyNAS has Debian inside and as you can get root login via SSH it can be recovered as any generic Linux…
