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 your
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
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]
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 to
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
starting MYSQL
%MYSQL_HOME%\binmysqld --log-output=FILE --log-error=MySQL.log
--result-file=results.log
--perform some minor operation
mysql -u username -p root DBNAME
mysqlshow databases;
mysqluse database;
mysqlshow tables;
please display the results of these operations of
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
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
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:
send to stdout | gzip -c outfile
depending on your data replace gzip with zoo,lha,bzip2,compress,.
re,
wh
Olaf Stein schrieb:
Or even
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
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 primary
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
12 matches
Mail list logo