Question : I ran the following command to create a mysqldump mysqldump -ubackup -psomething –single-transaction –quick somedatabase | gzip > […]
Tag: mysql-5.5
Will Partitions and Indexes on the same table help in performace of Inserts and Selects?
Question : I have a table containing the list of visitors and this table has the following information. Visitor Browser […]
How to take physical backup of MYSQL database
Question : I am trying to find out some tool which can take physical backup of MYSQL database. Like mysqlbackup […]
MySQL Database Archive
Question : We have 300 databases in our environment mixed of MyISAM and Innodb(innodb_file_per_table has been enabled) tables.Using MySQL 5.5.19 […]
Is my.cnf for mysql 5.5 is suitable and well tuned for below hardware spec?
Question : My Hardware Spec Technology: Ivy Bridge CPU: Intel Xeon E3 1245v2 Intel Smart Cache: 8MB Cores / Threads: […]
MySQL Community Edition Capacity
Question : I am using MySQL Community Edition on Amazon RDS service. It is a very large database, 2/3 tables […]
Purge mysql log bins older than two weeks automatically
Question : I have to manually write purge binary logs bin to “mysql-bin.somenumbers” ; Once in a while, I need […]
MySQL indexing on 11 million rows
Question : I have a development and production server, both with different amounts of RAM. Development machine has 8G, while […]
how to add removed partition?
Question : This is the structure of my table: — Table: t_keyword_conversion_ga — Create Table: CREATE TABLE `t_keyword_conversion_ga` ( `id` […]
Can I safely kill OPTIMIZE TABLE on an InnoDB table?
Question : MySQL’s documentation for kill warns: Warning Killing a REPAIR TABLE or OPTIMIZE TABLE operation on a MyISAM table […]