Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 31 to 40 of 16461 10 Older Entries

Displaying posts with tag: mysql (reset)

Percona Toolkit for MySQL with MySQL-SSL Connections
+1 Vote Up -0Vote Down

I recently had a client ask me how to use Percona Toolkit tools with an SSL connection to MySQL (MySQL-SSL). SSL connections aren’t widely used in MySQL due to most installations being within an internal network. Still, there are cases where you could be accessing MySQL over public internet or even over a public “private” network (ex: WAN between two colo datacenters). In order to keep packet sniffers at bay, the connection to MySQL should be encrypted.

If you are connecting to Amazon RDS from home or office (ie: not within the AWS network) you better be encrypted!

As there is already a MySQL Performance Blog post on how to setup MySQL SSL

  [Read more...]
Benchmarking Presentation at Percona Live London 2014
+0 Vote Up -0Vote Down

In a few weeks I’m presenting “Performance Benchmarking: Tips, Tricks, and Lessons Learned” at Percona Live London 2014 (November 3-4). I continue to learn lessons and improve my benchmarking capabilities, so the content is a full upgrade from my presentation at Percona Live Santa Clara in April 2013. Anyone interested in achieving and sustaining the best performance out of their software/hardware/application should attend.

Also, Tokutek is sponsoring so we’ll be available in the expo hall throughout the

  [Read more...]
InnoDB: Supporting Page Sizes of 32k and 64k
Employee_Team +1 Vote Up -0Vote Down

In the new InnoDB lab release we support page sizes of 32k and 64k. This gives users even more choices on the page size, allowing you to further customize InnoDB for your particular workload.

There are some things worthy of note related to this new feature:

  • The extent size changes when the innodb_page_size is set 32k or 64k.
    The extent size is 2M for 32k page sizes, and 4M for 64k page sizes (the extent size is 1M for 4k, 8k, and 16k page sizes). If we do not enlarge the extent size then we will have too many extent headers on the allocation bitmap page, and the bitmap page will overflow.
  • The

  •   [Read more...]
    Ignoring the lost+found Directory in your Datadir
    +0 Vote Up -0Vote Down

    I still get asked about the lost+found directory enough, and so I wanted to provide a current update.

    The lost+found directory is a filesystem directory created at the root level of a mapped drive. Thus this is common to see if you create your mysql datadir at the root level of a mapped drive.

    In the past, you could ignore it, if it wasn’t too problematic for you, or you could move your datadir down a level, and then it wouldn’t be created in the datadir anymore.

    However, there is now the –ignore-db-dir option. It is actually not too new (it’s been in MariaDB since 5.3.9 and 5.5.28, and in MySQL as of 5.6.3), but I don’t think many are too familiar with it.

    But when you do run into this problem, some/many would prefer to add a single line to the config file rather than move the datadir.

    To do this, just

      [Read more...]
    libAttachSQL Single Thread vs. libmysqlclient Multi Thread
    +0 Vote Up -0Vote Down

    I have recently posted up benchmarks of libAttachSQL vs. libmysqlclient using sysbench. Whilst these are great and shows the results I hoped for, this isn't what we designed libAttachSQL for. It was designed for non-blocking many connections per thread.

    With this in mind I spent today knocking up a quick benchmark tool which replicates the Sysbench "Select" test but using libAttachSQL's connection groups on a single thread. The code for this can be seen in the new AttachBench GitHub tree. Of course the secondary reason for this is to try and hammer the connection groups feature, which of course did find a bug when I scaled to around 32

      [Read more...]
    How to close POODLE SSLv3 security flaw (CVE-2014-3566)
    +0 Vote Up -0Vote Down
    Padding Oracle On Downgraded Legacy Encryption

    First off, the naming “convention” as of late for security issues has been terrible. The newest vulnerability (CVE­-2014-3566) is nicknamed POODLE, which at least is an acronym and as per the header above has some meaning.

    The summary of this issue is that it is much the same as the earlier B.E.A.S.T (Browser Exploit Against SSL TLS), however there’s no known mitigation method in this case – other than entirely

      [Read more...]
    Updates with secondary index maintenance: 5.7 vs previous releases
    +0 Vote Up -0Vote Down
    My previous results for an update-only workload to a cached and IO-bound database used a table that did not require secondary index maintenance from the update. Prior to that I ran tests using mysqlslap and might have found a regression in InnoDB when the update requires secondary index maintenance (bug 74235). The mysqlslap test did all updates to the same row. The test I describe here chooses the row to update at random and this workload does not reproduce the worst case from bug 74235.

    The results are that newer releases tend to do

      [Read more...]
    Rackspace doubling-down on open-source databases, Percona Server
    +0 Vote Up -0Vote Down

    Founded in 1998, Rackspace has evolved over the years to address the way customers are using data – and more specifically, databases. The San Antonio-based company is fueling the adoption of cloud computing among organizations large and small.

    Today Rackspace is doubling down on open source database technologies. Why? Because that’s where the industry is heading, according to Sean Anderson, Manager of Data Services at Rackspace. The company, he said, created a separate business unit of 100+ employees focused solely on database workloads.

    The key technologies under the hood include both relational databases (e.g., MySQL,

      [Read more...]
    Sysbench IO-bound updates: MySQL 5.7 vs previous releases
    +0 Vote Up -0Vote Down
    I repeated the sysbench update-only test after reducing the InnoDB buffer pool to 1G. The test database is 16G so the test should be IO-bound. MySQL 5.7.5 is 10% worse than 5.0.85 at 1 thread and much better at 8+ threads.

    The previous blog post has more details on the setup. The configuration is not crash safe as the doublewrite buffer and binlog are disabled and innodb_flush_log_at_trx_commit=2. This test continued to use direct IO for InnoDB but this test requires a high rate of reads from storage. The previous test did many writes but no reads. A fast flash device is used for storage.

    results at 1-thread

    Only 1 table is used so there is a 2G database and 1G buffer pool. This test is less IO-bound than the many threads tests reported in





      [Read more...]
    Recover orphaned InnoDB partition tablespaces in MySQL
    +0 Vote Up -0Vote Down

    A few months back, Michael wrote about reconnecting orphaned *.ibd files using MySQL 5.6. I will show you the same procedure, this time for partitioned tables. An InnoDB partition is also a self-contained tablespace in itself so you can use the same method described in the previous post.

    To begin with, I have an example table with a few orphaned partitions and we will reconnect each partition one by one to the original table.

    mysql [localhost] {msandbox} (recovery) > SHOW CREATE TABLE t1 G
    *************************** 1. row ***************************
    Table: t1
    Create Table: CREATE TABLE `t1` (
    [...]
    KEY `h_date` (`h_date`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1
    /*!50100 PARTITION BY RANGE (year(h_date))
    (PARTITION p0 VALUES LESS THAN
      [Read more...]
    10 Newer Entries Showing entries 31 to 40 of 16461 10 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.