Could Jemalloc improve performance no MySQL 5.6 on Windows 64-bit? How could we use Jemalloc on Windows 64-bit without compiling MySQL 5.6 source code with it? Thanks! Great article!!
Comment: Beware: key_buffer_size larger than 4G does not work
September 22, 2008 By 17 Comments
As of MySQL 5.0.52, values larger than 4GB are allowed for 64-bit platforms (except 64-bit Windows).
Comment: Limiting InnoDB Data Dictionary
February 12, 2009 By 13 Comments
+extern ulong srv_dict_size_limit; This patch has a problem : innodb_dict_size_limit cannot exceed 4GB on 64 bit Windows. Using variations of long is generally not a good idea – it is the worst datatype when it comes to portability. You need size_t for it or larger (i.e ulonglong).
Post: PHP vs. BIGINT vs. float conversion caveat
January 10, 2008 By 27 Comments
… about the mess that 64-bit integers are in PHP. But if the numbers you use do not cover 64-bit range fully, floats… are in fact doubles, i.e. double-precision 64-bit numbers. They have 52 bits for mantissa, and integer values up to 2…: s1=1125899906842600 s2=1125899906842625 And PHP 5.2.2 on Windows produces yet another variant: s1=1125899906840000 s2=1125899906842625 As you…
Comment: Limiting InnoDB Data Dictionary
February 12, 2009 By 13 Comments
… or SILP) model for 64 bit handling (http://en.wikipedia.org/wiki/64-bit) In fact, the whole 64 bit support on Windows in compiler and SDK and reference compiler on this platform (MSVC) has been LLP on 64 bit (long…
Comment: Which Linux distribution for a MySQL database server? A specific point of view.
December 10, 2011 By 38 Comments
… MySQL on Debian/Ubuntu, CentOS/RHEL/OEL, Solaris and on Windows. On Windows: There is no OS version of MySQL. And the… Windows behaves for production MySQL. The drawbacks from using Windows are in the third party software. There is a XtraBackup version for windows… some other Perl/Python vendor and is sometimes limited. (The 64-bit MySQL Python module is only available if you bought a…
Comment: The #1 mistake hosting providers make for MySQL servers
July 30, 2008 By 30 Comments
… different number on 32-bit windows, but it’s not over 4GB, because that’s all a 32-bit pointer can address. Sergi, it sounds like you are mixing 64-bit vs 32-bit with dual-core vs… blog. They are the ones who get stuck with 32-bit systems. Then they call us and we help them go…
Comment: The #1 mistake hosting providers make for MySQL servers
July 29, 2008 By 30 Comments
“… MySQL can’t use it because it runs in a single process, which is limited to about 2.5GB of memory.” Does this also apply to 32-bit Windows environments running on 64-bit hardware?
Post: Percona Server 5.1.58-12.9
August 17, 2011 By 2 Comments
… to a server crash. Bug Fixed: #627189 (Yasufumi Kinoshita). The 64-bit CAS implementation may lead to a server crash on IA32… Distribution patch has been fixed on Solaris (supported platform) and Windows (experimental). Bug Fixed: #737947 (Laurynas Biveinis) Improvements and fixes on…
Comment: Limiting InnoDB Data Dictionary
February 12, 2009 By 13 Comments
… value is limited to ULONG_MAX that is 4GB on Windows 64 bit.
