MySQL - universal way of getting approx. row size in bytes -


ok, won't mad if nobody wants me nonsense, wanted have way approximate row row byte size of table in mysql console (well i'm using phpmyadmins sql window).

the inner query reads desired table columns schema , group_concats them a statement, while adding char_length() function every column name. did not find better way, using separator this, separator comes first after first element, add 2 nonsense elements : "empty" @ beginning , "zzempty" @ end. thoses stripped of replace later.

the best part is, think code want, problem is, results fetched not displayed.

what easiest way results fetched prepared statement? way results put them table?

set    @query = concat('select ',  (select    replace(group_concat( column_name   order    case        when column_name="empty" 0        when column_name = 'zzempty'then 99        else 1     end,    column_name   separator '`) + char_length(`'),    'empty`) + ',    '')          (select       'empty' column_name,       '1' id     union    select       column_name,       1 id               information_schema.columns               table_schema = 'db_name'               , table_name = 'table_name'     union    select       'zzempty' column_name,       '1' id ) t1       group    id),' `table_name`');    set @query2 = replace( @query, '+ char_length(`zzempty',  '')  ;   prepare stmt @query2;   execute stmt ;

in fact, think there must easier way row size, did not find any.

it's easier ask mysql it, using show table status statement:

mysql> show table status name='apirequest'\g *************************** 1. row ***************************            name: apirequest          engine: innodb         version: 10      row_format: compact            rows: 105  avg_row_length: 1872     data_length: 196608 max_data_length: 0    index_length: 16384       data_free: 2520776704  auto_increment: 114     create_time: 2015-05-29 13:00:13     update_time: null      check_time: null       collation: utf8_unicode_ci        checksum: null  create_options:         comment: 1 row in set (0.00 sec)

Comments

Post a Comment

Popular posts from this blog

Magento/PHP - Get phones on all members in a customer group -

i working on custom magento extension. working around adminhtml part , i've created custom form there. here form code: <?php class vivasindustries_smsnotification_block_adminhtml_sms_sendmass_edit_form extends mage_adminhtml_block_widget_form { public function _preparelayout() { $extensionpath = mage::getmoduledir('js', 'vivasindustries_smsnotification'); $head = $this->getlayout()->getblock('head'); $head->addjs('jquery.js'); $head->addjs('vivas.js'); return parent::_preparelayout(); } protected function _prepareform() { $form = new varien_data_form(array( 'id' => 'edit_form', 'action' => $this->geturl('*/*/save', array('id' => $this->getrequest()->get...
Read more

php - Bypass Geo Redirect for specific directories -

i'm trying bypass redirect specific url within site. wondering if might able help. the code below code use, original urls replaces example.com i'd able access http://example.com/admin without redirect occuring. is there way this, , there way using own ip? function country_geo_redirect() { $country = getenv('http_geoip_country_code'); if ($country == "us" ) { wp_redirect("http://usa.example.com/"); exit; } else if ($country == "gb" ) { wp_redirect("http://uk.example.com/"); exit; } } add_action('init', 'country_geo_redirect'); you can bypass redirection code if server found ip address. if ip address == <my ip address> ' nothing here else country_georedirect() end if
Read more

php - .htaccess mod_rewrite for dynamic url which has domain names -

i want convert url ex:( example.com/link.php?url=facebook.com ) ( example.com/facebook.com.php ) how can using .htaccess. or there other process make job easier ? i tried adding script .htaccess file options +followsymlinks rewriteengine on rewriterule url-(.*)\.htm$ link.php?url=$1 but converting url adding "url-" ( example.com/url-facebook.com.php ) i want remove "url-" , want make ( example.com/facebook.com.php ) rewriteengine on rewritecond %{the_request} ^get.*link\.php\?url\= [nc] rewritecond %{request_uri} !/system/.* [nc] rewriterule (.*?)link\.php\?url\=/*(.*) /$1$2 [r=301,ne,l] not sure how above work edit of used use remove index.php url
Read more