Read the original article at Oracle DBAs… You Know You Want MySQL!
If you’re an Oracle DBA or developer and considering migrating an application over to MySQL you probably have a lot of questions. Here’s a five minute summary of what you should know. Looking to hire a top flight MySQL DBA? Check out our MySQL interview guide. What is truly delicious o a command line that’s [...]
For more articles like these go to Sean Hull's Scalable Startups
Related posts:
[Read more]I have been very happy with the benefit from InnoDB compression and a lot of hard work locally by my peers to make it work in production for us. When a table is compressed with InnoDB, you must declare a compression factor for that table (key_block_size=...) so that the table will possibly be compressed by 2X, 4X, 8X, or 16X. We have been using key_block_size=8 for many tables to get 2X compression.
I think it is possible to do much (2X or more) better than InnoDB. InnoDB uses an update-in-place approach to modify database pages on disk. There are solutions described as write-optimized (shadow pages, log-structured merge tree, fractal tree) that have a few significant advantages and one potential disadvantage with respect to compression. The advantages of the write-optimized family include:
Just a note to remind folks that MySQL Connect’s early bird discount is expiring next Friday, July 27th. If you want to save $200 on the conference, do not forget to register! MySQL Connect is a technical conference put on by Oracle which brings together MySQL Community speakers and Oracle engineers. It’s a weekend conference with almost 80 sessions in the heart of San Francisco, September 29th and 30th. And yes, I will be speaking:
I will be speaking about Database Scaling at Mozilla and Google-Hacking MySQL. See you there!
Today let’s talk about how to change MySQL user password
We can use 2 ways, 1 – mysqladmin, 2 – linguagem SQL
1. mysqladmin:
The syntax is easy:
mysqladmin -u USER -p password NEWPASSWORD
Let’s then change the password of ‘marcelo’ user to ’123′
mysqladmin -u marcelo -p password '123'
For this command, we have 3 problems:
. You can just change your own user
. You need SUPER PRIVILEGES to run this command
. If you share you linux user account with other users, this command will appear on historic, to avoid it we can edit ~/.bash_history and delete this lines
2. SQL (the best on my opinion):
To change the password, we’ll just run an update on user’s table on mysql db, you can do this in 2 ways, both have the same result
SET PASSWORD FOR 'user'@'host' = PASSWORD('newpass');
ou
UPDATE …[Read more]
Baltimore
BWI Airport Marriott
1743 West Nursery Road
Linthicum, MD, USA
Denver
Oracle Office
500 Eldorado Boulevard. Building 1, Room 1127
Broomfield, Colorado, USA
For Software & Hardware Vendors:
Improving Your Products with New MySQL Features and Faster
Performance
MySQL 5.5 and 5.6 are significant releases with many new features, improvements, and performance gains. For example, the read-write performance on Windows in MySQL 5.5 improved 1561% over MySQL 5.1, and query performance in MySQL 5.6 has shown even greater improvement. Join MySQL technical experts to …
[Read more]It’s been released. Use this with NIST::NVD 1.00.00 and you will be able to perform immediate look-ups of CVE and CWE data given a CPE URN. For instance:
cjac@foxtrot:/usr/src/git/f5/NIST-NVD-Store-SQLite3$ perl Makefile.PL ; make ; make test ; cjac@foxtrot:/usr/src/git/f5/NIST-NVD-Store-SQLite3$ perl -MNIST::NVD::Query -MData::Dumper -e '
$q = NIST::NVD::Query->new(store => q{SQLite3},database => q{t/data/nvdcve-2.0.db});
$cve_list = $q->cve_for_cpe( cpe => q{cpe:/a:microsoft:ie:7.0.5730.11} );
print Data::Dumper::Dumper { cve_list => $cve_list, first_cvss => $q->cve( cve_id => $cve_list->[0] )->{q{vuln:cvss}} }
'
$VAR1 = {
'cve_list' => [
'CVE-2002-2435',
'CVE-2010-5071'
],
'first_cvss' => {
'cvss:base_metrics' => { …[Read more]
TokuDB v6.1 is now generally available and can be downloaded here.
New features include:
6 new security fixes for Oracle MySQL have been detailed in the most current Oracle Critical Patch Update (CPU).
These are:
Oracle strongly recommends that customers apply CPU fixes as soon as possible. Unfortunately there is no easy description for MySQL users what that really entails. There is a reference to Critical Patch Update July 2012 Patch Delivery Document for Oracle Sun Products Suite My Oracle Support Note 1446033.1, however all the information is behind …
[Read more]
A big thanks to SUSECon.
I will be presenting a MySQL Crash Course talk at SUSECon
2012 this year in Orlando FL.
Historically, I try to pack a lot of information into this one
hour talk. So it will have a lot of references for you to take
with you and research more.
Look forward to seeing everyone !
MySQL Connector/Net 6.6.0, a new version of the all-managed .NET
driver for MySQL has been released. This is the first of
two alpha releases intended to introduce users to the new
features in the release. This release is not feature
complete and there are significant limitations but it should be
stable enough for users to understand the new features and how we
expect them to work. As is the case with all non-GA
releases, it should not be used in any production
environment. It is appropriate for use with MySQL server
versions 5.0-5.6
It is now available in source and binary form from http://dev.mysql.com/downloads/connector/net/#downloads and mirror sites (note that not all mirror sites may be up to date at this point-if you can't find this version on some mirror, please try again later or choose another download …
[Read more]