Ideas, releases, practical guides, and perspectives from the people building with MySQL.
Tuning MySQL Performance with MySQLTuner
MySQLTuner is a Perl script that analyzes your MySQL performance and, based on the statistics it gathers, gives recommendations which variables you should adjust in order to increase performance. That way, you can tune your my.cnf file to tease out the last bit of performance from your MySQL server and make it work more efficiently.
Some months ago I helped out in another project in which they had
some performance problems. They had a very big table and the
index of the table was bigger than the table itself. As every
change in the table causes MySQL to recalculate/reload the index,
this can take some seconds for such big tables.
So, I thought it would be a good idea to split that big table
into very small ones. This should reduce the overhead of
reloading big indices and instead reload only very small parts.
And the next thought was: Is it possible to use the "new"
MySQL-Partitioning for that?
Continue reading "Is MySQL-partitioning useful for
very big real-life-problems?"
Lets start a mysqld instance on a host machine :
bash-3.1$ ./mysql/libexec/mysqld
--defaults-file=./mysql/etc/my.cnf
080902 11:55:50 [Warning] option 'thread_stack': unsigned value
65536 adjusted to 131072
080902 11:55:50 [Note] Event Scheduler: Loaded 0 events
080902 11:55:50 [Note] ./mysql/libexec/mysqld: ready for
connections.
Version: '5.1.24-rc' socket: '/tmp/mysql_9090.sock'
port: 9090 Source distribution
As you can see I have used 'defaults-file' option to specify the
options file to the
server. This is to avoid the conflict if there are more mysqld
instances running on the
same machine.
So, MySQL server is up and running and listening to port 9090 as
specified in my.cnf file.
Note : Default port for mysqld is 3306.
Now, we can try connecting to this server both locally as well as
remotely.
…
[Read more]
Lets start a mysqld instance on a host machine :
bash-3.1$ ./mysql/libexec/mysqld
--defaults-file=./mysql/etc/my.cnf
080902 11:55:50 [Warning] option 'thread_stack': unsigned value
65536 adjusted to 131072
080902 11:55:50 [Note] Event Scheduler: Loaded 0 events
080902 11:55:50 [Note] ./mysql/libexec/mysqld: ready for
connections.
Version: '5.1.24-rc' socket: '/tmp/mysql_9090.sock'
port: 9090 Source distribution
As you can see I have used 'defaults-file' option to specify the
options file to the
server. This is to avoid the conflict if there are more mysqld
instances running on the
same machine.
So, MySQL server is up and running and listening to port 9090 as
specified in my.cnf file.
Note : Default port for mysqld is 3306.
Now, we can try connecting to this server both locally as well as
remotely.
…
[Read more]Hi,
We are planning a series of live webinars for the time slot which is convenient for APAC regions.
Have you concerned scalability or performance of MySQL in a production environment at a fast-growing company? Then, this is a chance to learn MySQL more! This series of webinars consists of four webinars which will explain MySQL features and resolve such concerns. Each webinar will introduce actual case studies and best practices to drive your understandings on MySQL. Also we will include descriptions on relative MySQL Enterprise purchase options at the end.
Planned Webinar Topics
1. High Availability/Scalability
2. Clustering
3. Monitoring/Backup/Recovery
4. Performance
*The above topics are subject to change.
1st Webinar Schedule
“MySQL High Availability/Scalability Solutions”
For the enterprise …
[Read more]
Gnu is 25 years. How time flies...
I still remember my first contact with the free software people
at the Stockholm-Helsinki cruise 1991 (where Minix was first
released).
I was back then, of course, already an emacs and gcc user, but
that trip was when I first felt an urge to release something as
free software. (The concept 'open source' didn't exist back
then). It did however take me until 1995 before David and I felt
we had something that was good enough to be released.
We haven't yet achieved world domination in all categories, but
we are definitely getting there; Some things take time, but we
have time on our side.
As a way to celebrate, the actor and humorist Steven Fry has made
a video
entitled 'Happy Birtday to Gnu'. Please check it out!
Happy birthday to Gnu!
Our goal at Continuent is to be the go-to guys for database
scale-out. Last Thursday we opened up a new community site for
scale-out software at http://community.continuent.com. The site is
driven by Joomla and has a number of very nice additions like
Fireboard Forums and Mediawikis for
each project. The first day or two was a bit bumpy as we nailed
down some final issues, but most features are now working. We
hope the result will be a nice place to meet other people who are
interested in database scale-out and share ideas as well as
software.
As you will see when visiting the community site, we have a
variety of projects that we collectively call the Tungsten
Scale-Out Stack. We have had this …
Can Google's Chrome reshape the Internet browser landscape? READ MORE
It’s important that for any software application good standards exist. Standards ensure a number of key considerations. Standards are necessary to enforce and provide reproducible software and to provide a level of quality in a team environment, ease of readability and consistency.
If you were going to create a MySQL Naming Standard you have to make a number of key decisions. Generally there is no true right or wrong, however my goals tend towards readability and simplicity. In 2 decades of database design I’ve actually changed my preference between some of these points.
1. Pluralism
Option 1
All database objects are defined in the logical form, that being
singular.
For example: box, customer, person, category, user, order, order_line product, post, post_category
Option 2
For database tables & views, objects are defined in plural. …
[Read more]