By putting this on your mysql config file:
[mysqld]
innodb_buffer_pool_size = 2G
In dedicated db machines, you can set this to close to 80% of the available memory. This will avoid disk writes and speed up things in general.
The mysql configuration file is on :
/etc/my.cnf (usually)
Restaring mysql, and barabum barabim
The typical error message you get when this is too small is:
Mysql::Error: The total number of locks exceeds the lock table size:
INSERT INTO table_name (column1, column2, column3,…)
VALUES (value1, value2, value3,…)
ALTER TABLE [table_name] ADD COLUMN [clumn_name] timestamp with time zone;
DELETE FROM [table_name] where [condition_column]=’blahblah’;
GRANT DELETE ON [table_name] TO [user_name];
ALTER TABLE pub_agreements DROP COLUMN registration_id;
UPDATE [table] SET [column_name]=’whatever value’ WHERE name=’Channel AB’
CREATE TABLE films ( code char(5) CONSTRAINT firstkey PRIMARY KEY, title varchar(40) NOT NULL, did integer NOT NULL, date_prod date, kind varchar(10), len interval hour to minute, is_boolean boolean );
ALTER TABLE lib2lib ADD COLUMN greeting int;
select name from channel where name LIKE ‘%CNET%’;
The % matches 0 or more characters, if you want to match only one character, you use _