<div>
i read that text and mediumtext are both stored separately and not in the table only a pointer to that is stored in table...<br />
<br />
how can i verify this on my own...<br />
because when i do select from table<br />
i see the whole text only in the ouput and not any pointer
</div>


<div>
You can't easily verify it on your own. &nbsp;It is supposed to act like single field. &nbsp;The pointer is an internal function for the MySQL server, not for the user.
</div>


<div>
ok. where exactly does mysql stores the text data...and what exactly happens when we query the table. how does it retrieve the data for text type columns or mediumtext type columns
</div>


<div>
Thx for the grade and points.
</div>


<div>
<div class="content wysiwyg-content">
hi,<br />
i have a mysql table with a column of type text. i want to change the type to mediumtext to support large amount of data.<br />
what are the performance implications of the same. <br />
will the queries be slow ?<br />
<br />
thanks
</div>
</div>


hi,
i have a mysql table with a column of type text. i want to change the type to mediumtext to support large amount of data.
what are the performance implications of the same. 
will the queries be slow ?

thanks

i read that text and mediumtext are both stored separately and not in the table only a pointer to that is stored in table...

how can i verify this on my own...
because when i do select from table
i see the whole text only in the ouput and not any pointer

You can&amp;#39;t easily verify it on your own.  It is supposed to act like single field.  The pointer is an internal function for the MySQL server, not for the user.

ok. where exactly does mysql stores the text data...and what exactly happens when we query the table. how does it retrieve the data for text type columns or mediumtext type columns

performance implication of using mediumtext over text in mysql

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.