Members   Search   Help    Register    Login   Home

Show: Today's Messages  :: Show Polls :: Message Navigator

Script to analyze all entries in a table and suggest optimal column data types. [message #1494] Wed, 27 June 2007 16:27  RichardBronosky Messages: 20 Registered: June 2007 Junior Member I've been working on a bash script that does this. I thought it was going to be really short and simple, but it is turning out to be quite complex. Before I continue with it, I want to know if such a thing already exists. Basically I do a lot of queries to test each column like: "select 'false.', \`$field\` from $TABLE where lpad(cast(0+\`$field\` as binary), length(\`$field\`), '0') != \`$field\` limit 1;" Which tests to see if the data is an INT ZEROFILL. Is there already a solution for this? If not, would anyone else be interested in helping to develop this? I intended to create a source forge project for it once I got a working version. But, I'm not finding the time to complete it. .+# Richard Bronosky #+. MySQL DBA, MythTV User Report message to a moderator

	Script to analyze all entries in a table and suggest optimal column data types. By: RichardBronosky on Wed, 27 June 2007 16:27
	Re: Script to analyze all entries in a table and suggest optimal column data types. By: RichardBronosky on Fri, 29 June 2007 13:44
	Re: Script to analyze all entries in a table and suggest optimal column data types. By: Speeple on Sun, 01 July 2007 14:03
	Re: Script to analyze all entries in a table and suggest optimal column data types. By: RichardBronosky on Sun, 01 July 2007 19:54
	Re: Script to analyze all entries in a table and suggest optimal column data types. By: roman on Sun, 15 July 2007 07:53
	Re: Script to analyze all entries in a table and suggest optimal column data types. By: RichardBronosky on Wed, 25 July 2007 11:30

Previous Topic:	Slow one-row INSERTs
Next Topic:	HELP: mysqld Threads and Memory Usage Reporting

Goto Forum:

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [ ]