… working on the system with custom compiled MySQL. How to upgrade to the new MySQL Options while preserving as much of original… looking at “Configure-Command”: Configure command: ./configure ‘–localstatedir=/var/db/mysql‘ ‘–without-debug’ ‘–without-readline’ ‘–without-libedit’ ‘–without-bench’ ‘–without-extra…
Post: Rebuilding MySQL Binary
November 16, 2006 By 2 Comments
… RPM based or other packaged MySQL Binary you may have a problem if you would like to rebuild binary for some reason…
Post: Innodb vs MySQL index counts
November 29, 2011 By 6 Comments
… different from the number of indexes 7 defined in the MySQL This customer was running Percona Server 5.1 and they… consider this on a newer version of Percona Server or MysqL 5.6. Another person (I’m looking at you, Baron… doing: ALTER TABLE table_name ENGINE=Innodb; This, of course, rebuilds the whole table based on the .frm table definition and…
Post: Hijacking Innodb Foreign Keys
January 2, 2012 By 2 Comments
… requires table rebuild. Yes you get it right even though Innodb is able to drop indexes without rebuilding table since MySQL 5.1 (Innodb Plugin) dropping foreign keys which should only require meta data change needs a table rebuild… how to Hijack innodb Foreign Keys or drop them without rebuilding the table ?
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
…. The cost of the query The complete method completely rebuilds an MV from scratch at each refresh. This means …| +——————+ | 155187034 | <-- too high +------------------+ 1 row in set (0.68 sec) mysql> select sum(total_lines) from dashboard_customer_sales ; +——————+ | sum(…
Post: Recovering Linux software RAID, RAID5 Array
August 27, 2011 By 2 Comments
Dealing with MySQL you might need to deal with RAID recovery every so … 4 active sync /dev/sde3 5 8 83 5 spare rebuilding /dev/sdf3 In this case I know/dev/sdf3 was… for a way to tell mdadm to change status of rebuilding drive into “failed” and removed in “active sync” but I…
Post: The #1 mistake hosting providers make for MySQL servers
July 25, 2008 By 30 Comments
… gladly install 8 or 16GB of memory for you, but MySQL can’t use it because it runs in a single… about 2.5GB of memory. And then you have to rebuild the whole operating system from scratch. But you don’t… a slave, switch your site to use it, and then rebuild the old server. That 32-bit OS turned into a…
Post: New MySQL Community Release Policies published
August 9, 2007 By 9 Comments
… main issue for me is Change policy for MySQL Community version. We are patching MySQL with minor extension so this concerns us… interesting to note 4 source releases for MySQL Community Version vs Monthly rapid updates for MySQL Enterprise version – to me this means…. Not to mention as Source Tree is available you can rebuild and rename binaries same as CentOS does for RedHat Enterprise…
Post: MySQL Releases first real Community Release
March 18, 2007 By 2 Comments
… contributions accepted into community version. The great question however why MySQL did not announce the split just now when it really… for production servers, which is effectively rebuild of RedHat Enterprise Version. Community Version of MySQL has all chances to be as stable… reasonable quality assurance to accepted code. What is about binaries ? MySQL 5.0.37 was rare exception of community release with…
Post: MySQL EXPLAIN limits and errors.
July 24, 2006 By 6 Comments
… query execution, sometimes being dynamic based on data. With EXPLAIN MySQL kind of simulates execution but it obviously does not access… expected to rebuild index by sort of key_cache as it can for MyISAM. EXPLAIN may take long time In MySQL 5… how many rows will be examined MySQL will still print full number. Here is example: mysql> explain select * from lt limit 10…
