Percona's MySQL & InnoDB performance and scalability blog
…, here is how to get Percona Server for MySQL up and running: Insert the SD card into a slot on your laptop… Windows (Tunnelier): $ ssh root@192.168.0.180 root@192.168.0.180′s password: Last login: Fri Feb 22 23:27:49… for inter-conflicts… Targets (4): libaio-0.3.109-6 libmysqlclient-5.5.30-1 mysql-clients-5.5.30-1 percona…
…0 | +—————————+——–+ 10 rows in set (0.00 sec) mysql> insert…
… 363096003 Last checkpoint at 363096003 Max checkpoint age 7782360 To speed up flushing we can set dirty pages percentage to zero: mysql> set global innodb_max_dirty_pages_pct=0; Query OK, 0 rows affected (0.01 sec) It is… writes: FILE I/O ——– I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state…
…Last_Errno: 1146 Last_Error: Error ‘Table ‘test.t’ doesn’t exist’ on query. Default database: ”. Query: ‘insert…insert into test.t(a) values(1) *************************** 5. row *************************** Log_name: mysql…
…_actor_last_name (last_name) -> )ENGINE=InnoDB DEFAULT CHARSET=utf8; Query OK, 0 rows affected (0.56 sec) # ./page_parser -f /var/lib/mysql/ibdata1…_PTR. Unfortunately this pointer is lost when new record is inserted. But the actual old values remain in the undo segment…_indexes /var/lib/mysql/ibdata1 15 0-18 0-19 # Apparently 0-18 is PRIMARY index and 0-19 is index idx_actor_last_name. It…
… int begin update seq set val=last_insert_id(val+1) where name=seq_name; return last_insert_id(); end // delimiter ; CREATE TABLE `seq… code it seems to confuse a lot of people because last_insert_id() is used rather unusual way – with argument. This way… in the case above can be quite helpful – in MySQL 5.0 you may with to use them instead of auto_increment…
…. This is true for all MySQL versions, including the latest 5.6 development tree as of last week. There have been efforts… Two client threads: FRF: Insertions in 900 seconds: 42946880. VmPeak: 10069040 kB DRF: Insertions in 900 seconds: 43325887 (0.88% faster). VmPeak: 10069048…; Also we modify the sysbench non-transactional INSERT test to insert strings of random length between 0 and 4096 in uniform distribution, that…
… number of other environments. INSERT ON DUPLICATE KEY UPDATE had a unfair share of replication issues in MySQL 5.0. There are number… logs for the last month to see how frequently this functionality is used. Happily there are only few INSERT ON DUPLICATE KEY… out one of the float columns stored “-0” in MySQL 5.0 but it was displayed as “0” when data loaded to Percona Server…
INSERT … ON DUPLICATE KEY UPDATE is very powerful but often forgotten MySQL feature. It was introduced in MySQL 4.1 but I still…, hits int unsigned not null, last_hit timestamp); insert into ipstat values(inet_aton(’192.168.0.1′),1,now()) on duplicate key… would be just incremented and last visit timestamp updated. The benefit of using this feature insted of INSERT + UPDATE could be different…
… (0.02 sec) mysql: SET GLOBAL innodb_ft_server_stopword_table=’test/innodb_ft_list2′; Query OK, 0 rows affected (0.00 sec) mysql: INSERT INTO innodb_ft_list2 SELECT * FROM innodb_myisam_stopword; Query OK, 543 rows affected (0.01… your current MyISAM FTS, the results may surprise you. That last point bears particular emphasis, as it also illustrates an important…
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.