Getting the size of MySql databases and tables

Getting the size of MySql databases and tables

Friday, Jan 4, 2019
Getting accurate results about the size and growth of your database tables enabled you to make smart decisions about partitioning and management of storage. I can guarantee that no-one wants to run out of storage on a database server. Show the largest database from a database server This has the assumption that you have access to the root account on the database server. You can normally look inside /var/lib/mysql to get an idea of the overall disk space, however, you will likely get more reliable results from querying the information_schema table inside MySql. ...

Read more
Starting the Drupal Serial module from a certain number

Starting the Drupal Serial module from a certain number

Friday, Mar 15, 2013
Recently I have been building a ticketing system in Drupal, which allows logged in users to create support tickets and administrators to comment on them, change them between statuses and close them. All this is mainly done by controlling a content type, called tickets, which only administrators and the creators can see alongside enabling comments and firing a few Rules off to control notifying people of changes and changing between statuses. ...

Read more
Tuning MySql using mysqltuner.pl

Tuning MySql using mysqltuner.pl

Wednesday, Dec 5, 2012
There are lots of details online about how to create and edit web pages/sites and how to make things look pretty, however, there is a lot less about how to get things working nicely on servers be them development or live servers. Of course, hosting websites is maybe not something for everyone and certainly at Will Hall Online, my usual response may well be to get a server to run your website but if you are running a small website, with limited resource requirements, shared hosting can do a fantastic job. ...

Read more
Create An Output File From A SQL Query

Create An Output File From A SQL Query

Monday, Sep 10, 2012
Sometimes, keeping files as hard copy, or just being able to move things in and around using csv files or such like can be great. However, doing so when you don’t have access to a mysql client (like phpmyadmin) can be a bit tricky. Hopefully this script can help you out. Of course you can change things inside it to make a whole wealth of different files with different data inside it. ...

Read more
Updating embedded content from the database

Updating embedded content from the database

Tuesday, Aug 21, 2012
This is part 2 (or a re-visit) of a previous blog post (Drupal Post Migration Data Cleanup) on updating content after moving it to another domain . If you have your data inside a multisite, you probably have some embedded some images/files into node bodies (or such like) and want an easy way to replace all of the instances. OK great. Using the REPLACE function in MySql you can easily replace instances where the url for the files is wrong. ...

Read more
Migration to Drupal

Migration to Drupal

Thursday, Apr 15, 2010
After presenting on ‘Migration to Drupal’ on Monday 12th April at DrupalCambs, had a few good chats about the nature of the Drupal database and associated points. Potentially, Migration to Drupal, I believe is fairly straighforward depending that you understand both the source and the target data well. Therefore in most cases you need to know your database and the Drupal MySql (or PostgreSql) database. However, for future reference it appears that when using content management systems, there is a belief that you don’t need to understand how the data interacts providing that it does. ...

Read more
NoSql, MongoDB and its future in IT

NoSql, MongoDB and its future in IT

Monday, Mar 29, 2010
Recently I have been reading a lot more about NoSQL databases, specifically MongoDB and CouchDB, ad how 2010 will be the year of NoSql. NoSql databases themselves move away from the structure of a relational database, mssql/mysql, and move more toward storing all of their data in views, which can contain a range of information. Why NoSql? Well NoSql’s inherant lack of rigid structure enables it to be far more flexible with regards to the data that you can insert. ...

Read more