Posted by Baron Schwartz |
…performance, future performance, scalability, ability
to recover from disasters? We also…skip-name-resolve is easy
to miss, as is the absence…write the report
to the client. I
copy and paste the…Created_disk_
tmp_
tables, I’ll paste in
mysql> show global…
Posted by
Baron Schwartz @ 9:42 pm ::
tuning ::
Posted by peter |
…of them.
This obviously makes
table inaccessible on master for duration…errors properly) you may rename
table instead of locking – for many…sec)
mysql> load data infile ‘/
tmp/rep.txt’ into
table rep…data loaded
to “rep”
table you will get the
copy of…
Posted by Greg Greenhaw |
… system runs mainly
#
MySQL.
#
# You can
copy this file
to
# /etc/my.cnf … entries for some specific programs
# The
MySQL server
[mysqld]
port = 3306
socket =…= 3072
open_files_limit = 9216
tmp_
table_size=1000M
sort_buffer_…
Posted by Maciej Dobrzanski |
…for all the recent
MySQL releases.
To remind anyone who has…into the slow log. Originally
MySQL database offered a second time…Take your output and
copy&paste it
to some notepad for…temporary storage for intermediate results “
tmp_
table_on_disk,filesort_on…
Posted by
Maciej Dobrzanski @ 5:38 am ::
patch ::
Posted by Vadim |
… 06:03:29 innobackupex: All
tables unlocked
090404 06:03:29… in directory ‘/mnt/data/
tmp‘
innobackupex:
MySQL binlog position: filename ‘db02…time when you want only
copy changed pages you can do…greater than given) will be
copied to specified dir. You may…
Posted by
Vadim @ 8:23 pm ::
Backups ::
Posted by peter |
…under control.
Prevent running multiple
copies This is the most important…in
MySQL. The second one is good if you want
to…also helpful if you want
to limit concurrency for certain processes…complete in time. Create the
table in the database and store…
Posted by
peter @ 8:05 am ::
mysql ::
Posted by peter |
….frm for Innodb
Table
If we simply
copy .frm file back …’t support.
See http://dev.
mysql.com/doc/refman/5.1…Aborted
[root@test3 test]# cp /
tmp/test_innodb.frm .
cp: overwrite…Lost connection
to MySQL server during query
Recovering CREATE
TABLE from…
Posted by Vadim |
… that load statement is:
mysql -S /
tmp/
mysql-ib.sock -e…YEAR}_$i.txt.tr’ INTO
TABLE ontime FIELDS TERMINATED BY ‘,’ ENCLOSED…lsql –database=ontime -t -s “
COPY 700000 records INTO ontime FROM…oriented stored engine took 30min
to get result.
I really like…
Posted by Vadim |
…,
To restore data you can
copy backup
to final /data directory directly and run…prepare and create iblogs ready
to use, that is
MySQL will be ready
to …
xtrabackup binary works only with innodb
tables.
innobackupex handles all instance including MyISAM,…
Posted by
Vadim @ 2:50 pm ::
Backups ::
del.icio.us
digg