…and built-in mysql replication are independent from each other. Q: I installed Percona as cluster database working with Zabbix (innodb…cluster_address and wsrep_cluster_name as an argument. It will join the …and not xtrabackup itself while holding a lock using FLUSH TABLES WITH READ LOCK. MyISAM…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
Post: Guidance for MySQL Optimizer Developers
September 20, 2009 By 4 Comments
… (even for Disk tables such MyISAM or Innodb) others keep database on SSD which has completely different ratio between CPU and IO cost. Focus… because MySQL simply does not have execution method to resolve query in optimal way – loose index scan, hash join, sort merge join are all the examples of such. For me it is most important to ensure MySQL has proper…
Post: To pack or not to pack - MyISAM Key compression
May 13, 2006 By 4 Comments
…MyISAM performing better than Innodb. In this article I’ll get in a bit more details about packed keys and… is not going to work and MySQL will need to scan …table with 100.000 rows with columns. And I set id=c to keep it simple: CREATE TABLE… got some 8 times faster and join on string value is almost…
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
…innodb_log_file_size = 512M innodb_open_files=2048 #Replication-skip replicate-ignore-table=mysql.gsd_runs replicate-ignore-table=mysql.gsd_monitor ======== ==> max_heap_table…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…MyISAM which isnt used. sort_buffer_size=2M query_cache_size=10M # Might be increased thread_cache_size=40 table…innodb_log_group_home_dir=/var/log/mysql innodb_log_arch_dir=/var/log/mysql innodb_table_locks=0 innodb…
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 141 Comments
…table. MYISAM table…and all of that is so very cumbersome (mysqlhotcopy is not available, for instance) and eking performance out of an InnoDB table…tables and we needed referential integrity and such, MySQL was a pathetic “option”. Yes 5.x has included triggers, stored procedures, and…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…tables‘ ‘–enable-assembler’ ‘–enable-local-infile’ ‘–with-mysqld-user=mysql‘ ‘–with-unix-socket-path=/var/lib/mysql/mysql…InnoDB will take significantly longer to close than MyISAM…innodb] msl patch currently can log three types of information: query timings, execution plan details and InnoDB…
Post: New OLAP Wikistat benchmark: Introduction and call for feedbacks
January 28, 2010 By 16 Comments
…in fact table. Example of query ( again, full list on Benchmark Wiki) SELECT project, sum(page_count) sm FROM pagestat JOIN …to load data and run queries against available engines: MySQL MyISAM / InnoDB (to have reference results) InfoBright InfiniDB MonetDB LucidDB Greenplum and I will report…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
…tested MySQL-5.1.30 with InnoDB plugin, Xtradb-1.0.2-1, and …table_type=MYISAM ft_min_word_len=4 innodb_additional_mem_pool_size=16M innodb_buffer_pool_size=15G innodb…innodb_status_file=0 innodb_thread_concurrency=0 innodb_io_capacity=1000 innodb_write_io_threads = 16 innodb_read_io_threads = 16 join…
Comment: A common problem when optimizing COUNT()
September 22, 2008 By 19 Comments
…innodb; Now what do you think MySQL will do with various types of COUNT() queries? Try putting a few rows into the table…and COUNT(col1). You might be surprised. Convert to MyISAM and try again. Make col1 nullable and try again. Now imagine the table… commented about LEFT OUTER JOIN is right on the …
