tips.kaali.co.uk
Tips and Tricks » INFORMATION_SCHEMA
http://tips.kaali.co.uk/tag/information_schema
You are viewing Posts Tagged ‘INFORMATION SCHEMA’. MySQL auto increment capacity calculation. September 26, 2013. Have you ever wondered if your tables in a MySQL database may be nearing capacity on INT AUTO INCREMENT columns? Dental Implant and Veneer. Setup PHP dev env with Eclipse. Grab while it lasts. Free 10GB Cloud Storage. Inject empty transactions in MySQL 5.6 GTID based Replication. MySQL auto increment capacity calculation. Prestashop direct wget download. Prestashop delete guest cart.
tips.kaali.co.uk
Tips and Tricks» Blog Archive » MySQL auto_increment capacity calculation
http://tips.kaali.co.uk/2013/09/26/mysql-auto_increment-capacity-calculation
MySQL auto increment capacity calculation. September 26, 2013. Have you ever wondered if your tables in a MySQL database may be nearing capacity on INT AUTO INCREMENT columns? First things first: If your application design allows, set the AUTO INCREMENT column to be UNSIGNED. It effectively doubles it’s capacity. The following query on INFORMATION SCHEMA provides a convenient way to verify your usage. Only top 100 columns are listed but you can change the query to suit your requirements.
tips.kaali.co.uk
Tips and Tricks » AUTO_INCREMENT
http://tips.kaali.co.uk/tag/auto_increment
You are viewing Posts Tagged ‘AUTO INCREMENT’. MySQL auto increment capacity calculation. September 26, 2013. Have you ever wondered if your tables in a MySQL database may be nearing capacity on INT AUTO INCREMENT columns? Dental Implant and Veneer. Setup PHP dev env with Eclipse. Grab while it lasts. Free 10GB Cloud Storage. Inject empty transactions in MySQL 5.6 GTID based Replication. MySQL auto increment capacity calculation. Prestashop direct wget download. MAC ssh-copy-id (password less ssh login).
tips.kaali.co.uk
Tips and Tricks » GTID
http://tips.kaali.co.uk/tag/gtid
You are viewing Posts Tagged ‘GTID’. Inject empty transactions in MySQL 5.6 GTID based Replication. September 26, 2013. As you probably already know, SET GLOBAL SQL SLAVE SKIP COUNTER = n doesn’t work anymore if you GTID based replication. Is there a way to skip a single transaction in such a case? Dental Implant and Veneer. Setup PHP dev env with Eclipse. Grab while it lasts. Free 10GB Cloud Storage. Inject empty transactions in MySQL 5.6 GTID based Replication. MySQL auto increment capacity calculation.
tips.kaali.co.uk
Tips and Tricks» Blog Archive » How to prepare SD Card for Raspberry Pi on a MAC
http://tips.kaali.co.uk/2013/01/12/how-to-prepare-sd-card-for-raspberry-pi-on-a-mac
How to prepare SD Card for Raspberry Pi on a MAC. January 12, 2013. If you didn’t buy the pre-populated SD card to boot up your Pi, you need to prepare one yourself. Relax, it’s easy…. These instructions are for preparing the SD card on a MAC, but should work on various flavours of Linux as well. Insert the card into the card reader (my MAC had an integral SD card reader but you can use any). Format it as FAT filesystem via Disk Utility (easily found via Spotlight search – top right lens). Inject empty t...
tips.kaali.co.uk
Tips and Tricks» Blog Archive » Inject empty transactions in MySQL 5.6 GTID based Replication
http://tips.kaali.co.uk/2013/09/26/inject-empty-transactions-in-mysql-5-6-gtid-based-replication
Inject empty transactions in MySQL 5.6 GTID based Replication. September 26, 2013. As you probably already know, SET GLOBAL SQL SLAVE SKIP COUNTER = n doesn’t work anymore if you GTID based replication. Is there a way to skip a single transaction in such a case? Yes, there is! Inject an empty transaction. MySQL documentation is available at http:/ goo.gl/ygvRkc. But let’s take a look at an example. Say replication on a GTID based replication slave is stopped with an error as shown below:. STOP SLAVE; SET...
tips.kaali.co.uk
Tips and Tricks» Blog Archive » Cross browser iframe auto-resize script
http://tips.kaali.co.uk/2010/06/19/cross-bowser-iframe-auto-resize-script
Cross browser iframe auto-resize script. June 19, 2010. Tags: iframe auto-resize script. A useful script to automatically resize an iframe (height and width) to fit contents in. No scrollbars ever again! I use this to display a DHTML site tree inside an iframe. The height of the iframe is dynamically set to contain the tree contents without displaying the vertical scrollbars. Doesn’t work in Google Chrome yet. If anyone gets it going, please share. Framestyle : frame; objToResize.height = innerDoc...
tips.kaali.co.uk
Tips and Tricks » replication
http://tips.kaali.co.uk/tag/replication
You are viewing Posts Tagged ‘replication’. Inject empty transactions in MySQL 5.6 GTID based Replication. September 26, 2013. As you probably already know, SET GLOBAL SQL SLAVE SKIP COUNTER = n doesn’t work anymore if you GTID based replication. Is there a way to skip a single transaction in such a case? Dental Implant and Veneer. Setup PHP dev env with Eclipse. Grab while it lasts. Free 10GB Cloud Storage. Inject empty transactions in MySQL 5.6 GTID based Replication. Prestashop direct wget download.
tips.kaali.co.uk
Tips and Tricks » iframe auto-resize script
http://tips.kaali.co.uk/tag/iframe-auto-resize-script
You are viewing Posts Tagged ‘iframe auto-resize script’. Cross browser iframe auto-resize script. June 19, 2010. Tags: iframe auto-resize script. A useful script to automatically resize an iframe (height and width) to fit contents in. No scrollbars ever again! Dental Implant and Veneer. Setup PHP dev env with Eclipse. Grab while it lasts. Free 10GB Cloud Storage. Inject empty transactions in MySQL 5.6 GTID based Replication. MySQL auto increment capacity calculation. Prestashop direct wget download.
tips.kaali.co.uk
Tips and Tricks » MAC
http://tips.kaali.co.uk/category/mac
You are viewing the archive for the ‘MAC’ Category. MAC ssh-copy-id (password less ssh login). March 05, 2013. If your OS does not support “ssh-copy-id” command, you can use the following instead. Continue Reading. Convert .dmg file on a MAC to .iso. April 14, 2012. Tags: Mac dmg iso. How to convert .dmg (disk image) file on a MAC to .iso so that it can be used on a Windows or Linux box? Increase Virtual Box VDI disk size on MAC or Windows. March 16, 2012. Need more space on your Virtual Box disc?