I’d like to show you some useful commands to do some MYSQL administration tasks: show processlist; – displays a list of active processes in the database: mysql> show processlist; +—–+——+———–+————+———+——+——-+——————+ | Id | User | Host | db | Command | Time | State | Info | +—–+——+———–+————+———+——+——-+——————+ | 564 | root | localhost | videoguide | Query | 0 | NULL | show processlist […]
Whisky PC
What you can do with a bottle of whisky? To drink it with your firends, for example. And then? And then you’ll throw out the empty bottle to the waste-bin. But don’t hurry! There is a better way to use it. The empty whisky bottle can be a computer case. Sounds unbelievably? Have a look this article with detailed explanation how to do it! P. […]
Measure your programmer’s level
On reaching some level of programming developers want to measure their knowledge and experience some how. For example, Perl developers built a monastery where they do meditation, ask and asnwer questions, demonstrate cool and useful stuff. The church hierarchy is used to measure experience of monks. I belong to Perl monastery too (I’m just a Deacon there :)). I like this virtual place. You can […]
Extended INSERT
To insert many records in one time it’s better to use extended INSERT: INSERT INTO table_name (field1, field2, …, fieldN) VALUES(value11, value12, …, value1N), (value21, value22, …, value2N), … , (valueN1, valueN2, …, valueNN); There is an one default restiction in MYSQL. It doesn’t allow execute query with more than 1 MB. The speed of this kind of insert is amazing! For example, extended insert […]
How to get Mysql table structure via mysql shell
Note: it maybe useful if you need to copy existing table srtucture somewhere. To do that just type: show create table table_name; For example, let’s run this command for table ‘test’: mysql> show create table test; and there is our result: mysql> show create table test1; +——-+————————————-+ | Table| Create Table | +——-+————————————-+ | test1 | CREATE TABLE `test1` ( `f1` varchar(20) default NULL ) […]
.htaccess tips and tricks
Very clear and useful article about configure and use .htaccess. Somethimes it’s easier to put your setting in the place where you have permissions to write. Also, after add or change existing settings in the .htaccess you don’t have to restart Apache. Read it and tune your web host!
Keep your stuff online
Memotoo.com is an online system to keep contacts, calendar, phone book, email addresses and bookmarks and synchronize them between desktop computer, mobile phone, laptop etc. It was developed by French guys I think. But it includes English interface as well. I just created an account and didn’t dive into functionality. But idea to put information from different places in one is great.