Computer memory is not bit-addressable, how can you store a bit as an
independent data unit ?
Other than as part of a record, there are no C data types (which is
used to implement MySQL kernel) that can
process bit as a data type.
If i miss the context, please advise me back.
thanks
On Mon, May
> That's why you really need to be more precise in the data structures
> you are planning on using. This can change the results significantly.
>
> So no, I don't have any specific answers to your questions as you don't
> provide any specific information in what you ask.
Yeah. Let me see if I can f
kimky...@fhda.edu ("Kyong Kim") writes:
> I don't have all the details of the schema and workload. Just an
> interesting idea that was presented to me.
> I think the idea is to split a lengthy secondary key lookup into 2 primary
> key lookups and reduce the cost of clustering secondary key with pr
What about sub selects. As I see it you only care about the highest
and lowest order of results in each list.
Sorry, in am on a mobile so I can nit make a test case, and this will
be pseudo SQL.
Select * from table where start <= (select foo) and ( select foo) ...
Also look at the "between
hi Olaf,
in unix you have small programms that do one thing and not more.
What you want to archive is a compressed output files.
the most easy way is:
| gzip -c >outfile
depending on your data replace gzip with zoo,lha,bzip2,compress,.
re,
wh
Olaf Stein schrieb:
> Or even better, can I
Simon,
Thanks for the feedback.
I don't have all the details of the schema and workload. Just an
interesting idea that was presented to me.
I think the idea is to split a lengthy secondary key lookup into 2 primary
key lookups and reduce the cost of clustering secondary key with primary
key data by
providing accurate information would've helped the op in this situation
i agree!
thanks,
Martin
__
Disclaimer and Confidentiality/Verzicht und Vertraulichkeitanmerkung/Note de
déni et de confidentialité
This message is confidential. If you should not
starting MYSQL
%MYSQL_HOME%\bin>mysqld --log-output=FILE --log-error=MySQL.log
--result-file=results.log
--perform some minor operation
mysql -u username -p root DBNAME
mysql>show databases;
mysql>use database;
mysql>show tables;
please display the results of these operations of %MYSQL_HOME%\da
Simon, I am totally new to MySQL and followed some instructions from the
internet. Here is the install script I put together that seems to work.
cd /home/qsys
gzip -cd /home/qsys/mysql-5.1.32.tar.gz | tar xf -
mv /home/qsys/mysql-5.1.32 /home/qsys/mysql-5.1.32.source
cd /home/qsys/mysql-5.1.3
compu...@videotron.ca (michel) writes:
> I might have it fixed! I tried /home/qsys/mysql-5.1.32/libexec/mysqld
> and I would get
>
> /home/qsys/mysql-5.1.32/libexec/mysqld: Table 'mysql.plugin' doesn't exist
>
> 090510 0:19:54 [ERROR] Can't open the mysql.plugin table. Please run
> mysql_upgrade
Simon,
I might have it fixed! I tried /home/qsys/mysql-5.1.32/libexec/mysqld and I
would get
/home/qsys/mysql-5.1.32/libexec/mysqld: Table 'mysql.plugin' doesn't exist
090510 0:19:54 [ERROR] Can't open the mysql.plugin table. Please run
mysql_upgrade to create it.
090510 0:19:54 [ERROR] F
compu...@videotron.ca (michel) writes:
> I set up MySQL and when I try to start it it fails telling me that I
> need to run 'mysql_upgrade'.
Show us the full error output and provide information on the version
of MySQL you are using.
> When I run 'mysql_upgrade' it runs
> 'mysqlcheck' which is s
kimky...@fhda.edu ("Kyong Kim") writes:
> I was wondering about a scale out problem.
> Lets say you have a large table with 3 cols and 500+ million rows.
>
> Would there be much benefit in splitting the columns into different tables
> based on INT type primary keys across the tables?
To answer y
13 matches
Mail list logo
