June 19, 2013

Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80

…, 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…

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

0 | +—————————+——–+ 10 rows in set (0.00 sec) mysql> insert

Post: Recovery deleted ibdata1

… 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…

Post: Can MySQL temporary tables be made safe for statement-based replication?

Last_Errno: 1146 Last_Error: Error ‘Table ‘test.t’ doesn’t exist’ on query. Default database: ”. Query: ‘insertinsert into test.t(a) values(1) *************************** 5. row *************************** Log_name: mysql

Post: Recovery after DROP & CREATE

…_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…

Post: Stored Function to generate Sequences

… 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…

Post: Dynamic row format for MEMORY tables

…. 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…

Post: The story of one MySQL Upgrade

… 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…

Post: INSERT ON DUPLICATE KEY UPDATE and summary counters.

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…

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

… (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…