Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Previous 30 Newer Entries Showing entries 61 to 90 of 1115 Next 30 Older Entries

Displaying posts with tag: Linux (reset)

Using MariaDB on CentOS 6
+4 Vote Up -0Vote Down

This is just for testing purposes, but you might want to play around with MariaDB 5.5.29 coming via the CentOS 6 repositories as mentioned in this post. Please test it out and report bugs if required. The process was simple on a fresh install:

yum update
cd /etc/yum.repos.d/
wget http://dev.centos.org/centos/6/mariadb/mariadb.repo
yum list mariadb\*
yum install mariadb-server mariadb
/etc/init.d/mysqld start

That’s it, it just works. It comes with MEMORY, CSV, MRG_MYISAM, BLACKHOLE, MyISAM, PERFORMANCE_SCHEMA, ARCHIVE, FEDERATED, InnoDB (XtraDB) and Aria.

Remember this replaces mysql-libs, and is set to replace MySQL in your install. Here’s hoping it hits mainline CentOS soon.

Related posts:

  •   [Read more...]
    Is MySQL bigger than Linux?
    +0 Vote Up -0Vote Down

    I’m going to take the numbers from my previous post, MySQL Modularity, Are We There Yet? for the “kernel” size of MySQL – that is, everything that isn’t a plugin or storage engine.

    For Linux kernel, I’m just going to use the a-bit-old git tree I have on my laptop. I’ve decided that the following directories are for “plugins” drivers/ arch/ sound/ firmware/ crypto/ usr/ virt/ tools/ scripts/ fs/*/* and everything else is core kernel code.

    Version Total LoC Total Plugin LoC Remaining (kernel) MySQL 5.6.10 1,049,344 265,189 784,155 (74% kernel) MariaDB 5.5 1,142,118  [Read more...]
    Installing Nginx With PHP5 (And PHP-FPM) And MySQL Support On Scientific Linux 6.3
    +0 Vote Up -1Vote Down

    Installing Nginx With PHP5 (And PHP-FPM) And MySQL Support On Scientific Linux 6.3

    Nginx (pronounced "engine x") is a free, open-source, high-performance HTTP server. Nginx is known for its stability, rich feature set, simple configuration, and low resource consumption. This tutorial shows how you can install Nginx on a Scientific Linux 6.3 server with PHP5 support (through PHP-FPM) and MySQL support.

    Building a MySQL Private Cloud: Step 1
    +1 Vote Up -0Vote Down

    Building clusters is usually a fun time. Here’s one of my setups at the Equinix LAX1 facility that is being used for VPN services, OpenVZ clustering, and general RADIUS and MySQL clustering integration. Once the clustering design is finalized, it’s still in flux state while I try out different setups, I’ll post some physical+logical architecture diagrams to show “How to Build a Fault Tolerant Infrastructure for Virtualized MySQL NDB Cluster + Python-based VPN systems.” Stay tuned for more.

    Percona Server on the Nexus 7: Your own MySQL Database Server on an Android Tablet
    +0 Vote Up -2Vote Down

    Percona Server on the Nexus 7: Your own MySQL Database Server on an Android Tablet

    Following Roel’s post, Percona Server on the Raspberry Pi: Your own MySQL Database Server , I thought what other crazy gadget can I run Percona Server on? And having an Asus Nexus 7 Android tablet I decided to give it a try.

    Anything below contains a risk that you break your tablet if

      [Read more...]
    Installing Apache2 With PHP5 And MySQL Support On Scientific Linux 6.3 (LAMP)
    +0 Vote Up -0Vote Down

    Installing Apache2 With PHP5 And MySQL Support On Scientific Linux 6.3 (LAMP)

    LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on a Scientific Linux 6.3 server with PHP5 support (mod_php) and MySQL support.

    OpenVZ and Amazon S3: how to solve the dreaded connection throttle failure
    +0 Vote Up -0Vote Down

    Sometimes we encounter odd application responses that seem to make no sense. One of these such issues is related to running virtual server instances (OS Containers not Para-Virtualized VMs) and attempting to back up their data to Amazon’s S3 cloud storage. For moderately sized virtual machines running MySQL databases or Python/PHP based websites and code repositories this can be an inexpensive, quickly provisioned, and easy way to provide disaster recovery backups in numerous geographic locations, since we generally want DR content to be located in a physically distant location. Nevertheless, we can encounter errors if using an S3 mount in a distance location from our server if the timezone/sync data is incorrect.

    The commonly seen error is as follows – and it doesn’t give much information for

      [Read more...]
    #DBHangOps 02/27/13
    +1 Vote Up -0Vote Down

    EDIT: Video from today’s #DBHangOps!

    Hey there peeps!

    February 27th at 12:00pm PST it is! Check back here for more info and keep a watchful eye on the twitter search (and feel free to join the conversation!). The topics we’re looking to cover this week are:

    • Day-to-day pain points (what takes more time than it should?)
      • rolling restarts and upgrades
      • Performing checksums on your data
        $ /usr/bin/pt-table-checksum \
        --quiet \
        --ignore-databases=mysql,percona,information_schema,per
        formance_schema \
        --lock-wait-time=50 \
        --chunk-size-limit=0 \
        --no-check-plan \
        --no-check-binlog-format \
        --max-lag=1 \
        --replicate percona.checksums \
        h=database.example.com











      [Read more...]
    Installing a driver for Microsoft SQL Server and Sybase ASE in Linux and Mac
    Employee_Team +3 Vote Up -0Vote Down

    In a recent post we showed you how to migrate a SQL Server database to MySQL. There, we used the oficial Microsoft ODBC driver and that’s OK if you are running MySQL Workbench in Windows. But what if your desktop OS is some Linux variant or Mac OS X?

    It turns out that Microsoft has recently released an ODBC driver for Linux. However, you can’t use this driver with MySQL Workbench for Linux. (Actually you can, but you would have to rebuild Workbench). The main reason is that this ODBC driver was linked against unixODBC (an ODBC driver manager), while Workbench uses another ODBC driver manager: iODBC and the two of them

      [Read more...]
    The InnoDB Quick Reference Guide is now available
    +3 Vote Up -0Vote Down

    I’m pleased to announce that my first book, the InnoDB Quick Reference Guide, is now available from Packt Publishing and you can download it by clicking here. It covers the most common topics of InnoDB usage in the enterprise, including: general overview of its use and benefits, detailed explanation of seventeen static variables and seven dynamic variables, load testing methodology, maintenance and monitoring, as well as troubleshooting and useful analytics for the engine. The current version of MySQL ships with InnoDB as the default table engine, so whether you program your MySQL enabled applications with PHP, Python, Perl or otherwise, you’ll likely benefit from this

      [Read more...]
    MySQL Performance: MySQL 5.6 GA -vs- MySQL 5.5 tuning details
    Employee +7 Vote Up -0Vote Down

    This post is the next part following the initial article about MySQL 5.6 vs 5.5 benchmark results (and MySQL 5.6 scalability).

    The focus in this article is on the "tuning impact" used during the published tests, and also I have for you few more test results to present which were missed initially -- Sysbench tests using 8 tables instead of a single one (as it does by default).

    All my.conf setting I've used during the tests was already presented within an initial article, so let's go directly to details about special tuning setting.

      [Read more...]
    MySQL Performance: MySQL 5.6 GA and MySQL 5.5 scalability
    Employee +9 Vote Up -0Vote Down

    As promised, this is the first part of details about MySQL 5.6 vs 5.5 benchmark results I've published earlier last week. The following graphs are representing scalability results obtained for both MySQL versions on the published tests (and I have yet more test results to present to you, but these test's are still running)..

    Few remarks based on comments and discussions I've got since then:

    • I'm using a "true" 32cores server (true 32 cores, each one yet has 2 threads (HT), so 64 threads in total)
    • I'm not using "CPU threads" terminology as I'm finding it confusing (for ex. when you're reading "16 CPU
      [Read more...]
    #DBHangOps on 1/30/13 \o/
    +1 Vote Up -0Vote Down

    UPDATE: Here’s the recording, enjoy!

    Hello everybody!

    #DBHangOps coming at you this week, Wednesday 1/30/12 at 12:00pm PST. Be sure to check out this blog post tomorrow or check this twitter search to grab the link to join the Google Hangout.

    This week’s topics were:
    * bug fixes in recent versions
    * Plugins
    ** authorization plugins (e.g. LDAP)
    ** audit plugin API — http://dev.mysql.com/doc/refman/5.5/en/writing-audit-plugins.html
    *** state transitions of records in MySQL with a plugin?
    * InnoDB Status variables from twitter — https://github.com/twitter/mysql/wiki/InnoDB-Status-Variables
    * Table alters/schema changes
    ** Twitter patch for non-blocking alter table (throws a different error than









      [Read more...]
    MySQL Performance: InnoDB heavy I/O RW workloads limits in 5.6
    Employee +7 Vote Up -0Vote Down

    This article was initially planned to follow the previous posts about RW (Read+Write) workloads on MySQL & Linux (part#1, part#2)... But, when I've started to run real MySQL/InnoDB IO-bound tests on the Fusion-io card, I've quickly realized that I'm hitting so hot internal contentions within InnoDB code, that I'm simply unable to use storage capacity on its full power.. So, I've moved to another server (having SSD only), and then continued with it (as to explain RW limits it'll be pretty enough). Also, curiously, on this server XFS performance on writes is way better than EXT4 (while on the the

      [Read more...]
    Packages to get MariaDB and tests up and running
    +0 Vote Up -0Vote Down

    yum

    It’s often pain to guess package names when you need to install stuff on, lets say, CentOS. So there is a list, although maybe not full, of what I needed to get another VM build and run MariaDB server and to execute at least some tests on it (all done via yum install):

    cmake
    gcc
    ncurses-devel
    bison
    g++
    gcc-c++
    aclocal
    automake
    libtool
    perl-DBD-MySQL
    gdb
    libaio-devel
    openssl-devel

    Same in one line, for lazy me:
    sudo yum install cmake gcc ncurses-devel bison g++ gcc-c++ aclocal automake libtool perl-DBD-MySQL gdb libaio-devel openssl-devel

    To install bzr:

    su -c ‘rpm -Uvh http://download.fedora.redhat.com/pub/epel/5/i386/epel-release-5-2.noarch.rpm’
    (check the architecture)

    and then can use yum















      [Read more...]
    Migrating MySQL 5.5.25a jiradb ERROR 2013 (HY000) on huge single db import
    +0 Vote Up -0Vote Down

    well, I incremented max_allowed_packet from 16M to 512M
    anyway, I got the same error on the next clean import.
    so decided to find a workaround.
    so, how to get the data separated from the ddl statements:

    # get the tables names into the insert statement, its better to have that in file for future usage
    sed '/^INSERT INTO/!d;s/ VALUES.*$//' jiradb.20130118.sql | sort | uniq > tablas.como.nombres.txt
    

    then how to get the data separated:

    root@jiragg:[Fri Jan 18 15:26:33]:[/usr/local/BACKUP]$ cat make.inserts.sh
    #!/bin/sh
    # trim function thank to http://stackoverflow.com/questions/369758/how-to-trim-whitespace-from-bash-variable
    # and http://codesnippets.joyent.com/posts/show/1816
    trim() {
        local var=$1
        var="${var#"${var%%[![:space:]]*}"}"   # remove



      [Read more...]
    Install MySQL at non default data directory on different drive on CentOS6.3/RHEL 6
    +0 Vote Up -0Vote Down

    We assume the new disk is /dev/sdb1 formatted as ext3
    and it will be mounted as /data

    # 0. make sure there is no mysqlm mysql data directory :
    yum remove mysql mysql-server -y 
    test -d /data/mysql/ && rm -rf /data/mysql/
    test -d /var/lib/mysql/ && rm -rf /var/lib/mysql/
    
    # 1. install Mysql
    yum install mysql mysql-server -y
    
    # 2. check the mysql  status
    service mysqld status
    
    # 3. start the mysqld if not started
    service mysqld start
    
    # 4. check the mysql status again
    service mysqld status
    
    # 5. stop mysqld in case its started, and check thre is n mysql process:
    service mysqld stop
    ps axu | grep mysql
    
    # 6. make sure the /data partition is added to the /etc/fstab. If not add it:
    test  `cat  /etc/fstab | grep /data | wc -l ` -eq 0  && echo "/dev/sdb1 /data ext3

      [Read more...]
    #DBHangOps on 01/16/13!
    +2 Vote Up -0Vote Down

    Update: Recording!

    Finally, the end of year madness is over and we’re in a fresh new year. That must mean it’s time to get back into #DBHangops! Tune in on Wednesday, 1/16/13 at 5:00pm PST to get in on the fun and share your experiences.

    Check back on this blog post tomorrow or check this twitter search to grab the link to join the Google Hangout.

    Topics for this weeks hangout include:
    * triggers: maintenance, problems, etc.
    * Oracle MySQL utilities (similar to Percona toolkit)
    ** Slideshow of MySQL utilities
    * Database caching and cache




      [Read more...]
    General: new site theme based on Twitter Bootstrap
    +0 Vote Up -1Vote Down

    Just a quick note to say that the site has been updated to a new theme which is based on the super awesome Twitter Bootstrap UI framework. To make life easier, since this site is also using WordPress at the core, I’ve made use of the WordPress Bootstrap plugin which allows for very simple integration. However, that wasn’t enough because the Bootstrap plugin comes with rather basic and boring generic styles; so I added the plugin for Google Font support and then modified the CSS accordingly.

    You will also notice that the site is undergoing some reorganization of categories and content tags. This should help clean up search results as

      [Read more...]
    Super Python: three applications involving IRC bot master, MySQL optimization, and Website stress testing.
    +1 Vote Up -0Vote Down

    In my ongoing efforts to migrate my fun side projects and coding experiments from SVN to Git I’ve come across some of my favorite Python based apps – which are all available in their respective repos on BitBucket, as follows:

    IRC Bot Commander

    • What it does: it’s an IRC bot that takes commands and does your bidding on whichever remote server the bot is installed on.
    • How it does it: the bot runs on whatever server you install it on, then it connects to the IRC server and channel you configured it to connect to and it waits for you to give it commands, then it execs the commands and returns the output to your IRC chat window.
      [Read more...]
    Simple jQuery: how to validate IPv4 addresses and netmasks
    +0 Vote Up -0Vote Down

    Unfortunately jQuery doesn’t come with default form validation to check for ip-addresses or subnet masking. So without a long winded explanation here’s the code. Just include this as a separate JS file like the rest of your page’s JS.

    // 'ipv4': IPv4 Address Validator
    $.validator.addMethod('ipv4', function(value) {
        var ipv4 = /^[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}$/;    
        return value.match(ipv4);
    }, 'Invalid IPv4 address');
    
    // 'netmask': IPv4 Netmask Validator
    $.validator.addMethod('netmask', function(value) {
        var mask = /^[1-2]{1}[2,4,5,9]{1}[0,2,4,5,8]{1}\.
    [0-2]{1}[0,2,4,5,9]{1}[0,2,4,5,8]{1}\.
    [0-2]{1}[0,2,4,5,9]{1}[0,2,4,5,8]{1}\.
    [0-9]{1,3}$/;    
        return value.match(mask);
    }, 'Invalid IPv4 netmask');
    

    You can use it like this.

    $("#myform_here").validate({
        rules:{
    	ipaddress:{
      [Read more...]
    Bash scripting: ElasticSearch and Kibana init.d scripts
    +0 Vote Up -0Vote Down

    As a follow up to the previous post about logstash, here are a couple of related init scripts for anyone implementing the OpenSource Log Analytics setup that is explained over at divisionbyzero. These have been tested on CentOS 6.3 and are based on generic RC functions from Redhat so they will work with Redhat, CentOS, Fedora, Scientific Linux, etc.

      [Read more...]
    #DBHangOps 11/28/12
    +2 Vote Up -0Vote Down

    Now that the thanksgiving holiday is over, it seems like the perfect time to have another #DBHangOps. If you’re interested, check this twitter search or check back on my blog here for a link to the google hangout.

    Items currently on our agenda for today:
    * Data corruption!
    * Monitoring — what do you monitor, why, etc.
    * Query killing — do you kill queries in production regularly, or in emergencies?
    * Fun or useful configurations

    Looking forward to chatting about MySQL stuff today!
    Fun time hitting these topics this week. Check out the recording:

    Compile MariaDB 5.5.28 MySQL on Slackware i486-slackware-linux-gcc-3.3.4 with Cmake 2.8.10.1
    +0 Vote Up -0Vote Down

    1. install Cmake

    wget  http://www.cmake.org/files/v2.8/cmake-2.8.10.1.tar.gz
    tar xvfz cmake-2.8.10.1.tar.gz
    cd cmake-2.8.10.1/
    ./configure
    gmake -j3
    

    2. install libaio

    gmake -wget  http://www.kernel.org/pub/linux/kernel/people/bcrl/aio/libaio-0.3.92.tar.gz
    tar xvfz libaio-0.3.92.tar.gz
    cd libaio-0.3.92/
    make prefix=/usr/
    make prefix=/usr/ installj3 install
    

    3. install MariaDB 5.5.28
    go to https://downloads.mariadb.org/mariadb/5.5.28/ OR

    wget https://downloads.mariadb.org/f/mariadb-5.5.28/kvm-tarbake-jaunty-x86/mariadb-5.5.28.tar.gz/from/http:/mariadb.ulak.net.tr/
    tar xvf mariadb-5.5.28.tar.gz
    cd mariadb-5.5.28/
    

    the build will fail :

    root@bubu:[Tue Nov 27

      [Read more...]
    Simple MySQL: using TRIGGERs to keep datetime columns updated without direct SQL calls
    +0 Vote Up -0Vote Down

    If you’ve ever used non-opensource code, or applications that you don’t have complete control over, then you may have run into situations you need to alter data on a per-row basis but been unable to do so for lack of application SQL access. The solution to this type of problem is to use a MySQL TRIGGER, which allows us to execute arbitrary SQL commands when defined events occur. Why is this useful and how does it work? Well…

    For example, I have a freeRADIUS server that uses MySQL as a backend for the user authentication, and one of my server applications (HostBill) provides a freeRADIUS plugin that allows my users to manage their RADIUS accounts; however the default freeRADIUS schema lacks a DATETIME column on the user table. When a user is created (INSERT) or has their password changed (UPDATE)

      [Read more...]
    Meeting the MySQL Team at UKOUG (ICC Birmingham, December 3-5 | 2012)
    +4 Vote Up -1Vote Down
    If you're planning to attend UKOUG in Birmingham on Dec 3-5, here's your guide to know more about Oracle's MySQL.

    There's a MySQL stream on Monday 5th and we've a great list of sessions, including:



      [Read more...]
    MySQL Performance: InnoDB vs MyISAM in 5.6
    Employee +9 Vote Up -0Vote Down

    Since the latest changes made recently within InnoDB code (MySQL 5.6) to improve OLTP Read-Only performance + support of full text search (FTS), I was curious to compare it now with MyISAM..

    While there was no doubt that using MyISAM as a storage engine for a heavy RW workloads may become very quickly problematic due its table locking on write design, the Read-Only workloads were still remaining favorable for MyISAM due it's extreme simplicity in data management (no transaction read views overhead, etc.), and specially when FTS was required, where MyISAM until now was the only MySQL engine capable to cover this need.. But then FTS came into InnoDB, and the open question for me is now: is there still any reason to use MyISAM for RO OLTP or FTS wokloads from performance point of view,

      [Read more...]
    Installing MySQL Workbench in Ubuntu 12.10
    Employee_Team +2 Vote Up -0Vote Down

    Last month Ubuntu 12.10 was released and we tried to install MySQL Workbench on it. So we went to http://www.mysql.com/downloads/workbench/ (http://www.mysql.com/downloads/workbench/) and downloaded the .deb file for the most recent Workbench version (5.2.44 as of this writing). We then opened the .deb file with the Ubuntu Software Center application and tried to install it. Unfortunately the following message appeared:

    Dependency is not satisfiable: libctemplate0

    The problem here is that the libctemplate package provided by Ubuntu 12.10 corresponds to a higher version (libctemplate2). Installing this version instead wouldn’t work since MySQL Workbench is linked against the older one. We’ll handle this dependency issue in

      [Read more...]
    Remote MySQL Performance And Query Monitoring
    +0 Vote Up -0Vote Down

    Remote MySQL Performance and Query Monitoring

    There may be the situation that you have to monitor a MySQL server remotely. There are some linux tools to do performance and query monitoring locally, and these tools can also used to monitor remotely - but only unencrypted ! Also often MySQL is only listening on the loopback interface, so it is even not reachable remotely over the net (which is very good seen from the security viewpoint). But there is an easy solution in the Linux world.

    #DBHangOps
    +0 Vote Up -0Vote Down

    Woooo, just wrapped up another night of #DBHangOps, check out the video:

    For those of you who aren’t familiar with this awesome series of videos, it’s a bi-weekly meeting of MySQL DBAs via a Google Hangout to simply talk about databases (specifically MySQL). The discussions range anywhere from silly stories to awesome learnings and even little gotchas to know about when working with MySQL operationally. If you’re interested in catching when the next #DBHangops will happen, check MySQL planet for a blog post about it, or check this twitter search.

    We look forward to talking with you!

    Previous 30 Newer Entries Showing entries 61 to 90 of 1115 Next 30 Older Entries

    Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

    Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.