-
Bugs Page for MySQL and Friends
After completing my recent ‘downloads‘ page (similar to my ‘changelogs‘, ‘documentation‘, and ‘server variables‘ pages), it occurred to me that I should add a ‘bugs‘ page as well.
So, I’ve added a bug page, which has links to the main bug listing/reporting pages for MySQL, MariaDB (Aria), Drizzle, Percona Server (XtraDB), Xtrabackup, Sphinx, MONyog, and SQLyog (thus far).
Bug Page:
http://www.chriscalender.com/?page_id=876
Hope this helps.
(And feel free to drop me a line if you have any suggestions.)
-
Why not make a tool to improve existing configurations?
A couple of users of our very popular MySQL Configuration Wizard have submitted feedback such as “I’d love to input my existing server settings and get suggestions on how to improve it.”
This sounds like it would be great, doesn’t it? We’ve considered doing this, and even partially implemented it. But during our pre-release testing, we found a lot of potentially serious problems with the idea. It turns out to be very subtle — perhaps too subtle to be done with any computer program, no matter how smart, because there might be a lot of assumptions it’s forced to make, which could turn out to be dangerous. Every approach we considered carried a high risk of de-optimizing a server so it performs worse than before.
So in the end, although our tool is excellent for creating a starting my.cnf, my old blog post about the ultimate my.cnf tuner tool, which claims that an expert human is the only safe way to do this, might be an evergreen truth.
PS: my favorite user feedback so far is this one:
Great job, very good results! Now please take it offline before I am rendered obsolete.
-
Building MariaDB 5.3 on Windows
I just wanted to share my steps for building MariaDB 5.3 on Windows. (Note, this is not much different than the instructions Wlad posted here).
But, things are not always so smooth, and of course I ran into a couple small issues, so I wanted to share my outputs plus those issues and their solutions (once again many thanks go to Wlad!) for those out there who might encounter the same.
Here are the steps to build:
Download MariaDB 5.3 and extracted to C:\mariadb-5.3
cd C:\mariadb-5.3
mkdir bld
cd bld
cmake .. -G "Visual Studio 9 2008"
cmake --build . --config relwithdebinfo --target package
* By making a sub-dir named ‘bld’ and cd’ing into it, you’ll keep all of your build files in their own dir. This way, it is easy to start over (just delete /bld/) and it also keeps your sourcedir clean and looking like it does originally.
** The last command is the build command issued from the command line. You could accomplish the same with the following commands from within Visual Studio:
VS2008: File -> Open -> Solution -> C:\mariadb-5.3\bld\MySql.sln
VS2008: Build -> Build Solution
VS2008: Right-click "PACKAGE" -> Build
..
Outputs:
C:\Users\Chris>cd C:\mariadb-5.3
C:\mariadb-5.3>mkdir bld
C:\mariadb-5.3>cd bld
C:\mariadb-5.3\bld>cmake ..
-- Building for: Visual Studio 8 2005
-- Check for working C compiler using: Visual Studio 8 2005
-- Check for working C compiler using: Visual Studio 8 2005 -- works
-- Detecting C compiler ABI info
-- Detecting C compiler ABI info - done
-- Check for working CXX compiler using: Visual Studio 8 2005
-- Check for working CXX compiler using: Visual Studio 8 2005 -- works
-- Detecting CXX compiler ABI info
-- Detecting CXX compiler ABI info - done
-- Looking for sys/types.h
-- Looking for sys/types.h - found
-- Looking for stdint.h
-- Looking for stdint.h - not found
-- Looking for stddef.h
-- Looking for stddef.h - found
-- Check size of void *
-- Check size of void * - done
-- Using Aria for temporary tables
build ARCHIVE as static library (libarchive.lib)
build BLACKHOLE as static library (libblackhole.lib)
build CSV as static library (libcsv.lib)
build FEDERATEDX as static library (libfederatedx.lib)
build HEAP as static library (libheap_s.lib)
build ARIA as static library (libaria_s.lib)
build MYISAM as static library (libmyisam_s.lib)
build MYISAMMRG as static library (libmyisammrg_s.lib)
build PBXT as static library (libpbxt_s.lib)
build XTRADB as static library (libxtradb.lib)
build FEEDBACK as static library (libfeedback.lib)
build EXAMPLE as DLL (ha_example.dll)
build FEDERATED as DLL (ha_federated.dll)
build INNODB_PLUGIN as DLL (ha_innodb_plugin.dll)
-- Could NOT find Boost
-- Performing Test BOOST_OK
-- Performing Test BOOST_OK - Failed
build SPHINX as DLL (ha_sphinx.dll)
-- Looking for MFC
-- Looking for MFC - found
-- Cannot find wix 3, installer project will not be generated
-- Configuring done
-- Generating done
-- Build files have been written to: C:/mariadb-5.3/bld
I first compiled from within Visual Studio (alternate step #6), and here is the last line of that output:
========== Build: 84 succeeded, 1 failed, 2 up-to-date, 6 skipped ==========
(More on the 1 error below – but it’s safe to ignore.)
And here is the output from the command line compilation (since I did this second, there was not nearly the output, so I ‘ll post it all):
C:\mariadb-5.3\bld>cmake --build . --config relwithdebinfo --target package
Microsoft (R) Visual C++ Express Edition Version 9.0.30729.1.
Copyright (C) Microsoft Corp 2007. All rights reserved.
1>------ Build started: Project: PACKAGE, Configuration: RelWithDebInfo Win32 ------
1>
1>Performing Post-Build Event...
1>CPack: Create package using ZIP
1>CPack: Install projects
1>CPack: - Install project: MySql
1>CPack: Create package
1>CPack: - package: C:/mariadb-5.3/bld/mariadb-5.3.3-win32.zip generated.
1>Build log was saved at "file://c:\mariadb-5.3\bld\PACKAGE.dir\RelWithDebInfo\BuildLog.htm"
1>PACKAGE - 0 error(s), 0 warning(s)
========== Build: 1 succeeded, 0 failed, 86 up-to-date, 0 skipped ==========
..
Error Appendix:
CMake – Cannot find source file “cmake_dummy.cc”:
cmake ..
...
Cannot find source file "cmake_dummy.cc"
Solution:
Upgrading CMake from 2.6 (2.6.4) to 2.8 (2.8.7) worked and eliminated this error. You can download it from here.
..
CMake – General Comment:
If you have previously installed Visual Studio 2005 and now have installed Visual Studio 2008 (or 2008 and 2010, or some other mix), it is probably best to specify the Generator when invoking cmake. I was getting various strange errors when I did not specify the generator of the Visual Studio I use to compile. Specifically, my cmake was using the VS2005 generator, but I was building with VS2008. So, I had to perform a conversion when opening the solution in VS, not to mention some other starange issues were occurring (saying I passed MFC test, but I was using VS2008 Express, so I did not have the proper MFC for VS2008). Similarly, cmake using relwithdebinfo failed too.
Solution:
Instead of using:
cmake ..
Use:
cmake .. -G "Visual Studio 9 2008"
If you’re not sure what string to use for -G, simply run “cmake” from the command line, with no arguments, and it will display the various available options. For instance:
C:\>cmake
cmake version 2.8.7
...
Generators
The following generators are available on this platform:
Visual Studio 10 = Generates Visual Studio 10 project files.
Visual Studio 11 = Generates Visual Studio 11 project files.
Visual Studio 8 2005 = Generates Visual Studio .NET 2005 project
Visual Studio 9 2008 = Generates Visual Studio 9 2008 project files.
..
Build – afxwin.h missing error – mysql_upgrade_wizard error:
VS2008 Build ..
...
11>Build log was saved at "file://c:\mariadb-5.3\bld\win\upgrade_wizard\
11>mysql_upgrade_wizard.dir\Debug\BuildLog.htm"
11>mysql_upgrade_wizard - 1 error(s), 0 warning(s)
..
c:\mariadb-5.3\win\upgrade_wizard\stdafx.h(23) : fatal error C1083:
Cannot open include file: 'afxwin.h': No such file or directory
Solution:
Since this is just the mysql_upgrade_wizard, this can be ignored unless you specifically need this.
Otherwise, locate ‘afxwin.h’ and store it to the correct location.
Note that you’re likely receiving this if you using the Visual Studio Express Edition, as ‘afxwin.h’ is not available in the Express Edition, as described on the following pages:
http://stackoverflow.com/questions/5543523/afxwin-h-file-is-missing-in-vc-express-edition
http://social.msdn.microsoft.com/forums/en-US/Vsexpressvc/thread/7c274008-80eb-42a0-a79b-95f5afbf6528/
..
Other common build errors and their solutions can be found here.
..
Related Build Links:
How to Build MySQL 5.5 from Source Code on Windows:
http://www.chriscalender.com/?p=689
Building MariaDB 5.1 on Windows:
http://www.chriscalender.com/?p=736
Building MariaDB 5.3 on Windows:
http://www.chriscalender.com/?p=864
MySQL 5.5 Windows Build Appendix : Full Outputs and Common Errors from Building MySQL 5.5 on Windows:
http://www.chriscalender.com/?p=720
Maintaining (and Building) your MySQL Source Tree on Windows:
http://www.chriscalender.com/?p=759
Resolving the bison.exe m4 Invalid argument Error when building MySQL/MariaDB/XtraDB on Windows:
http://www.chriscalender.com/?p=798
Building XtraDB on Windows:
http://www.chriscalender.com/?p=820
-
User Group Videos....
I have been attempting to be better about letting folks in the general MySQL world know when the videos from the Boston MySQL User Group are up. We have a great group, with anywhere from 20-50 attendees each month, and the speakers are always great, even when the group asks some tough questions.* Thanks to the generous donation of time that Richard Laskey puts in editing the videos, there are 2 videos I can share with you:
Ivan Zoratti of SkySQL presented MySQL HA Reloaded at the December MySQL Boston Users Group. Slides are online at http://www.slideshare.net/izoratti/ha-reloaded-11261643
Tim Callaghan of Tokutek presented Fractal Tree Indexes -- Theoretical Overview and Customer Use Cases at the January MySQL Boston Users Group.
The next meeting is Monday, February 13th from 7-9 pm and will feature "Scaling MySQL with Transparent Database Sharding", by Victoria Dudin of ScaleBase. RSVP for the free meeting here or wait until the video comes out, if you are not local.
* The group is really great about RSVP'ing too -- we usually get the approximate number of folks RSVP'd actually showing up. I recently went to a local user group that had over 100 people RSVP' and only about 1/3 of them showed up. I guess if you know the pattern you know how to 'read' the numbers, but as a speaker I would have been disappointed to expect an audience of 100 and have an audience of 30.
Then again, maybe the speaker was informed of this...I have no clue. I guess what I am trying to say is that I really appreciate the Boston group!
-
OurSQL Episode 78: Removing Evil Queries, part 2
Registration for Percona Live: MySQL Conference and Expo is open! The conference is from Tuesday, April 10th through Thursday, April 12th at the Santa Clara, CA convention center. Early bird pricing ends March 12th, 2012.
Use code PL-pod and save 10% off the early bird prices!. Check out the tutorial and session schedule!
SkySQL and MariaDB Solutions Day on Friday, April 13th, 2012 in Santa Clara, CA.
read more
|
