…article can cover, and might wander into Apache, networking config, caching layers, etc….the tail it has information on core dumps and so on. It’s …with the database. The first step is to find out what MySQL instances are … the queries which cause the greatest load on the server (in aggregate) and…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
… kit which helps improve the performance of queries against a MySQL database by distributing the work over multiple machines and/or multiple… dumped the data to tab delimited flat files using mysqldump. I started by loading the raw data from the BTS into a single database… on a single database schema containing all of the data. Before loading, there was approximately 23GB of data. After loading, ICE compressed this…
Post: Living with backups
November 6, 2008 By 28 Comments
…€™s some nightly batch job that just dumps all MySQL tables into a text file or ordinarily copies the… a busy database server it may turn out that running a simple copy operation from MySQL data …or include things like processlist information, CPU load avergages, I/O load, etc. In this case tar …
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
… MySQL bug and some pages in Innodb tablespace got corrupted. In such cases Innodb will typically print something like this: InnoDB: Database… you will need to look into it more later. Another alternative is to dump table with MySQLDump and load it back. It is…) mysql> insert ignore into test2 select * from test where id>250; ERROR 2013 (HY000): Lost connection to MySQL server during query mysql> insert ignore into…
Post: Quickly finding unused indexes (and estimating their size)
December 5, 2012 By 2 Comments
…customer recently who needed to reduce their database size on disk quickly without a lot…then you may need to dump and load a copy of that table into your working index_analysis …loaded them into my schema as separate tables. Then I simply created a view of a UNION DISTINCT of those two tables: mysql…
Post: Recovery after DROP & CREATE
August 22, 2012 By 1 Comment
… | grep PRIMARY LOAD DATA INFILE ‘/root/src/recovery-tool/s_tools/dumps/default/SYS_INDEXES’ REPLACE INTO TABLE `SYS… know which index_id belongs to which database/table. Sometime it’s not possible to …s review an example: # ./s_tables /var/lib/mysql/ibdata1 sakila/actor sakila/actor 15 # ./s_indexes…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
…. Q6: Does Innodb policy replacement algorithm takes into account page position in btree index ? HT: No…innodb to do a full write of the database (basically dump memory to disk) once every minute or…load is CPU bound and you’re scaling out you can get better performance by using couple of MySQL…
Comment: What's the recommended MySQL version?
August 22, 2011 By 24 Comments
… required is the updates to the system tables in the mysql database. I’m mainly pointing out that you don’t have… is a pretty common thing people believe is necessary: dump, load into 5.1; dump, load into 5.5. That can take an eternity and make…
Post: Can Innodb Read-Ahead reduce read performance ?
June 26, 2007 By 2 Comments
… into pretty interesting behavior today. We needed to dump and reload large database and we had pretty good IO …. Unlike in other case when we did load in parallel, dump in parallel did not increase IO rate … doing (I was adviseor in this project from MySQL AB side) – to improve how Innodb read-ahead …
Post: Alternatives of PHP ?
September 9, 2006 By 28 Comments
When I loaded GigaBytes of XMLs into mysql database with PHP script, I was thinking about PHP alternatives. Why … – I’m just tired of debugging with ‘echo’ and ‘var_dump‘ 3. Unpredictable memory consumption – it’s easy in processing of… refresh my mind. List of my requirements: – Stable binding to MySQL, support of new protocol with prepared statement is necessary. – good…
