One question that comes up relatively commonly in support is how
much memory can MySQL use on my system. As you may know, MySQL
runs in a single process with many threads. So the memory limit
it has is based upon the operating system limits for a single
process. Different operating systems have different limits, but
the one I want to discuss is Windows 32-bit (such as 2000, XP,
2003, vista).
The short answer is that your mysqld-nt.exe can use up to ~1.8G
of RAM. The question is why is that so. Since we have a 32-bit
address space, in theory there is 2^32 mapping for the address
space (4G). However, Windows uses what is called a 2G/2G split in
that addressable space. 2G are allowed for the actual application
to use and 2G is for the kernel mappings.
This 2G is then the address space of points, which normally ends
up with around 1.8G of memory really being usable. If you try to
use more than this, then you end up getting …
Living in Portland, OR, I was sad to see O’Reilly move OSCON to San Jose this year (don’t they have enough with MySQL, Velocity, …?). So what did the Portland locals do? Start their own:
Open Source Bridge (we have a lot of bridges here in Portland).
It looks like they just opened up their call for papers recently, quoting from their page: “Open Source Bridge is accepting proposals now through March 31st for our 2009 conference, which will take place June 17–19 at the Oregon Convention Center in Portland, OR.”
Tomorrow I’m going to be giving a free webinar on Gearman through MySQL. I’ll be describing the basics of Gearman and then look at a few common use cases. I’ll even be touching on some more advanced topics such as Map/Reduce and persistent queues.
Our download servers have just been loaded with the latest
version of our current GA version of MySQL Workbench 5.0. We
managed to close 27 bugs for this release. While 10 were actually
fixed in code, we also re-validated many reports in our bug-DB
and found 17 bug-reports which could be closed
as the reported issue has been fixed in the meantime. We also
added some shortcut-keys to the wizard interfaces - it’s now
possible to flip through the wizard pages (next, cancel, back)
using shortcut key-combinations.
Please hop right to the download page and fetch the new release.
While the costs of managing a data center are becoming a major concern with the increased number of under-utilized servers, customers are actively looking for solutions to consolidate their workloads to:
- improve server utilization
- improve data center space utilization
- reduce power and cooling requirements
- lower capital and operating expenditures
- reduce carbon footprint, ..
To cater those customers, Sun offers several virtualization technologies such as Logical Domains, Solaris Containers, xVM at free of cost for SPARC and x86/x64 platforms.
In order to help our customers who are planning for the consolidation of their MySQL databases on systems running Solaris 10, we put together a document with a bunch of installation steps and the best practices to run MySQL inside a Solaris Container. Although the document was focused on the Solaris Containers technology, …
[Read more]While the costs of managing a data center are becoming a major concern with the increased number of under-utilized servers, customers are actively looking for solutions to consolidate their workloads to:
- improve server utilization
- improve data center space utilization
- reduce power and cooling requirements
- lower capital and operating expenditures
- reduce carbon footprint, ..
To cater those customers, Sun offers several virtualization technologies such as Logical Domains, Solaris Containers, xVM at free of cost for SPARC and x86/x64 platforms.
In order to help our customers who are planning for the consolidation of their MySQL databases on systems running Solaris 10, we put together a document with a bunch of installation steps and the best practices to run MySQL inside a Solaris Container. Although the document was focused on the Solaris Containers technology, …
[Read more]Open-source software such as MySQL's wins over users when it's easy to use, but money is the thing that ensures that more will be developed.
On the mailing lists we get the question from time to time:
How can I access internal information inside a proxy script ?
MC documented them in the manual, perhaps it is easier to get an idea if you see a picture instead.
The file is generated from a .dot file which will soon end up in the lauchpad trees. The above graph is a bit ahead of time as it references my routing tree which changes the way the "address" fields are exposed.
Filed GCC bug 39228:
#include <stdio.h>
#include <math.h>
int main()
{
double a= 10.0;
double b= 1e+308;
printf("%d %d %dn", isinf(a*b), __builtin_isinf(a*b), __isinf(a*b));
return 0;
}
mtaylor@drizzle-dev:~$ gcc -o test test.c
mtaylor@drizzle-dev:~$ ./test
0 0 1
mtaylor@drizzle-dev:~$ gcc -o test test.c -std=c99
mtaylor@drizzle-dev:~$ ./test
1 0 1
mtaylor@drizzle-dev:~$ gcc -o test test.c
-mfpmath=sse -march=pentium4
mtaylor@drizzle-dev:~$ ./test
1 1 1
mtaylor@drizzle-dev:~$ g++ -o test test.c
mtaylor@drizzle-dev:~$ ./test
1 0 1
Originally I found the simple isinf() case to be different on x86 than x86-64, ppc32 and sparc (32 and 64).
After more research, I found that x86-64 uses the sse …
[Read more]#include <stdio.h>
#include <math.h>
int main()
{
double a= 10.0;
double b= 1e+308;
printf("%dn",isinf(a * b));
return 0;
}
Prints 1 on: 64bit intel, 32bit PowerPC, 32bit SPARC, 64bit Sparc. But prints zero on 32bit intel.
Oh, but if you build that with g++ instead of gcc on 32bit Intel, you get 1.