Claudio Nanni wrote:
If he really cared about MySQL he would have not sold it or prevent from
selling it to Sun.
Initially her was convinced that MySQL as a division of Sun would really
benefit the future of MySQL [1]. Obviously his relationship with Sun
changed a bit later on.
It shows that
Claudio Nanni wrote:
Due to selling MySQL to Sun, Widenius earned about 16.6 million € in
(...)
This isn't about Monty or how much he earns. This is about protecting MySQL and
open source, without which many of us wouldn't have a job.
and besides, having dedicated 27 years of his life
Gods. What is this, a creche ?
*plonk*
On Sun, Dec 13, 2009 at 6:44 PM, Victor Subervi victorsube...@gmail.comwrote:
On Sun, Dec 13, 2009 at 12:21 PM, Pinter Tibor tib...@tibyke.hu wrote:
Victor Subervi wrote:
Hi;
mysql insert into *tem126072414516* (ProdID, Quantity) values (2,
2009/12/13 Victor Subervi victorsube...@gmail.com:
[...]
Please advise.
review your sql: you are inserting into
tem126072414516
and selecting from
tem126072385457
( Asterisk in Pinter Tibor's mail means bold )
Greetings,
Mattia Merzi.
--
MySQL General Mailing List
For list archives:
Heh. You'll need to just create an empty .frm file, and then issue the drop
table statement.
On Mon, Dec 14, 2009 at 6:11 AM, Manasi Save
manasi.s...@artificialmachines.com wrote:
Hi All,
I really don't know how to elaborate this problem because it is quite
strange-
I have deleted .frm
I am using mysql 5.0.77 on RHEL 5. Storage engine in MyISAM.
Please refer to the below two statements. First query is checking for
lastname 'clarke' where as second query is checking for lastname 'clark'.
Rest everything is same with these two queries. However, the explain output
shows ref
Hi,
Can any body help me how to create new instance at the same mysql databas
server in 5.0.85 community version ?
Thanks
Jeetendra Ranjan
Thanks Johan,
I tried doing this. When I try to delete that empty table it is giving
me an error saying Unknow table 'tblename'.
I have created empty .frm file at folder level. can I create one from mysql.
Thanks in advance.
--
Regards,
Manasi Save
Quoting Johan De Meersman
Can any body help me how to create new instance at the same mysql databas
server in 5.0.85 community version ?
You might find useful:
http://code.openark.org/blog/mysql/manually-installing-multiple-mysql-instances-on-linux-howto
At least i used that last time i had to set 2 instances on my
I don't think there's an actual problem as such, the optimiser is just
making a decision to merge the lastname and firstname indices for the second
query. At a guess, I'd say that the cardinality of clark in your lastname
index is too high, so it uses both; the cardinality for clarke will be
No, if you were to try a create statement, mysql would notice the
still-existing data in the InnoDB file. You just have to create a .frm file
on the filesystem level, and assign it the correct permissions (on unix,
ug=rw and owned by mysql:mysql or something similar).
On Mon, Dec 14, 2009 at
Thanks Johan.
More to add here, execution time for query with 'clarke' is much higher than
query with 'clark'. This is why it looks a bit strange behavior.
From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De
Meersman
Sent: Monday, December 14, 2009 8:33 PM
To: Manish
Already did Analyze table and table is up to date. It seems like optimizer
glitch only but I am not sure. Will try adding index hints.
From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De
Meersman
Sent: Monday, December 14, 2009 9:14 PM
To: Manish Ranjan
Cc:
Heh. Try running analyze table, so the index stats are correct. If that
doesn't help, you may have stumbled upon an optimizer glitch, or maybe
there's something happening that I'm not seeing. If all else fails, try to
add index hints.
On Mon, Dec 14, 2009 at 4:30 PM, Manish Ranjan
Thank you John, You have hit on my point exactly. There are
thousands on companies and 100's of thousands of jobs which are owed
to this product. That is what we are defending.
- michael dykman
On Mon, Dec 14, 2009 at 4:27 AM, John Daisley mg_s...@hotmail.com wrote:
Claudio Nanni wrote:
Hi;
I have the following:
mysql select SKU, Quantity, Name, Price, p.sizes,
p.colorsShadesNumbersShort from tem126080739853 t join products p on
t.ProdID-p.ID;
Empty set (0.00 sec)
mysql select * from tem126080739853;
+++--+-+--+
| ID |
... on t.ProdID-p.ID;
Your join clause subtracts the two IDs, so it's on IDs that differ, and
apparently there aren't any.
PB
-
Victor Subervi wrote:
Hi;
I have the following:
mysql select SKU, Quantity, Name, Price, p.sizes,
p.colorsShadesNumbersShort from tem126080739853 t join
On Mon, Dec 14, 2009 at 12:37 PM, Peter Brawley peter.braw...@earthlink.net
wrote:
... on t.ProdID-p.ID;
Your join clause subtracts the two IDs, so it's on IDs that differ, and
apparently there aren't any.
I beg to differ:
mysql select SKU, Quantity, Name, Price, p.sizes,
i don't really thinks this is about open source or not.
MySQL became more closed when Sun bought it and while i think that
Oracle will try to get this even more closed IMO it's time to fork it as
a really open source project. Monty could lead this. The are a lot of
forks around that make
Victor Subervi wrote:
On Mon, Dec 14, 2009 at 12:37 PM, Peter Brawley peter.braw...@earthlink.net
wrote:
... on t.ProdID-p.ID;
Your join clause subtracts the two IDs, so it's on IDs that differ, and
apparently there aren't any.
I beg to differ:
...
So why does my select join fail?
Victor,
As far as I can see... change the '-' to '='.
-- fixed query --
SELECT
SKU
, Quantity
, Name
, Price
, p.sizes
, p.colorsShadesNumbersShort
FROM
tem126080739853 t JOIN products p ON
t.ProdID = p.ID
;
-- end --
I
Victor Subervi wrote:
On Mon, Dec 14, 2009 a
mysql select SKU, Quantity, Name, Price, t.sizes,
t.colorsShadesNumbersShort from tem126080739853 t join products p on
t.ProdID-p.ID http://t.prodid-p.id/;
Empty set (0.00 sec)
mysql select ID, SKU, Name, Price from products;
Victor,
I beg to differ:
mysql select SKU, Quantity, Name, Price, p.sizes,
p.colorsShadesNumbersShort from tem126080739853 t join products p on
t.ProdID-p.ID http://t.prodid-p.id/;
...on t.ProdID-p.ID... _subtracts_ the two IDs. To match them use '='
rather than '-'.
PB
-
Victor
hi list,
is it possible to get a list of all tables with a certain type in one statement
?
for now i collect all tables (show tables) and search for the type (show
columns).
Any way to circumvent that ? make it one statement ?
re,
wh
--
MySQL General Mailing List
For list archives:
walter harms wrote:
hi list,
is it possible to get a list of all tables with a certain type in one statement
?
for now i collect all tables (show tables) and search for the type (show
columns).
Any way to circumvent that ? make it one statement ?
use information_schema;
select
On Mon, Dec 14, 2009 at 1:04 PM, Peter Brawley
peter.braw...@earthlink.netwrote:
...on t.ProdID-p.ID... _subtracts_ the two IDs. To match them use '='
rather than '-'.
Thank you for all of you that caught that.
V
I have following table structure, I have to use merge storage engine.
Please have a look, and provide feedback if theres some thing wrong or if
there's space for optimization.
/*Table structure for table `messages2009` */
CREATE TABLE `messages2009` (
`id` varchar(36) NOT NULL default '',
On 12/14/09 1:49 AM, Claudio Nanni claudio.na...@gmail.com wrote:
If he really cared about MySQL he would have not sold it or prevent from
selling it to Sun.
i don't see the logic in this sentence.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
On 12/13/09 11:23 AM, Neil Aggarwal n...@jammconsulting.com wrote:
Doug:
I do not
see anyone willing to put up anything to support mysql... you
don't like
it... put up a billion dollars an take control or shut the heck up!
Assuming MySQL as it stands today is 100% open source,
I
You build a green park where children can play.
Then you sell the park to a private company.
The company can: not mantain it so that the park becomes junkies place, have
people pay to access it or even close it.
I, the builder, would not start a crusade or weep after I have sold it,
Once it is on
and thanks for sharing your view. here's mine:
mysql was sold to sun, a company with a long and deep commitment to oos.
while there were obviously risks to the sale, one plausible motive (among
others) is that a company like sun would be better placed to further
develop, market and support mysql,
I think we are on the same line, I put it to excess to spotlight the
crucial point, how it was based on the 'good will' of Sun, which I
simply adhore and thank only for existing
I was actually happy when that happened because with Sun, MySQL was
perfectly fitting in the big picture of Sun
After one very quick look, the index on folderid alone is unnecessary since
you have another index in which that field is the high-order field.
On Mon, Dec 14, 2009 at 12:31 PM, Sudhir N sudhir_nima...@yahoo.com wrote:
I have following table structure, I have to use merge storage engine.
Id should probably be an auto_incrementing INT, if you still need a unique text
identifier, then I would make a separate field. Though my opinion isn't the
only way; there is much debate on natural vs. surrogate keys.
I would normalize folderid into a lookup in another table, and make folderid
Hey there,
I have recently imported the database files from a crashed server and I am
currently trying to get the new server running with the old data.
However, after starting the MySQL Server, I only get the following error
message:
091214 20:51:46 mysqld started
InnoDB: The user
Lukas,
If you can't get innodb_force_recovery to work, then you might have to
try to recover the data with these tools:
http://code.google.com/p/innodb-tools/
Regards
Baron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
MySQL is a huge and trusted brand, yes you could run with a fork but at the end
of the day it will never be MySQL. Its that MySQL brand name which sells the
underlying software, support packages, books, training, certifications and the
services of a huge number of Sun and independent
Yeah, plus just think about all those job sites and resumes that would
have to change from LAMP Developer to LAxP Developer
if MySQL forked and changed names! Myself included. All those poor
recruiters would need to be trained to know that dbXYZ == MySQL. LOL.
How many LADP Developsers do you
All,
I am using MySQL currently, but am starting to think that maybe I don't
really need to use an RDBMS. The data I am storing ends up getting
indexed with Sphinx because I have full-text indexes for about 40
million records.
I have an items table that is heavily updated with 40 million
I am using MySQL currently, but am starting to think that
maybe I don't
really need to use an RDBMS
You can use flat file storage, but that would be inefficient.
I guess you could try to create a custom system and keep
all the records in RAM. That would require some decent
coding to make
I am using MySQL currently, but am starting to think that
maybe I don't
really need to use an RDBMS
I just thought of another thing:
It is always faster to insert into a table without
indexes than inserting into a table with indexes.
I also think it might be faster to clear the table,
Dear all,
i am nowing having a problem with the mysql server optimization, i have 20
database on a server,each database is about 80Gb,the sql seems very
slow,almost 5s.and the server i/o is so high,when i check the
processlist,the 'copying to tmp table' state takes a long time.
i have already
I am trying to import a database of notable quotations. It is really
quite simple, but I'm finding importing via phpMyAdmin is (IMHO)
erroneous.
The database came from FileMaker Pro 7, and there are no options for
changing the output. There are two choices:
1) tabs between fields (with no
Jan:
For example, importing a quote with a Context field of:
The Hitchhiker's Guide to the Galaxy
results in a field containing:
The Hitchhiker
You are going to have to escape quotes, so your string should
look like this:
The Hitchhiker\'s Guide to the Galaxy
See this
Hi,
I am getting error while creating a simple trigger
mysql CREATE TRIGGER CONSUMER_PROFILE_before_delete BEFORE DELETE ON
CONSUMER_PROFILE FOR EACH ROW
- begin
- INSERT INTO
Jeetendra,
ERROR 1054 (42S22): Unknown column 'CAMPAIGN_ID' in 'OLD'
But this column is exist in DELETED_CONSUMER_ACTION_AUDIT table.
But does it exist in consumer_profile?
PB
-
Jeetendra Ranjan wrote:
Hi,
I am getting error while creating a simple trigger
mysql CREATE TRIGGER
Tables has varchar36 primary keys, because I use UUID and not auto increment
columns.
I have verified all the queries that are going to run on tables using Explain
and it show correct index being used.
Thanks
SN
Sudhir NimavatSenior software engineer.
Quick start global PVT LTD.
Manish,
On Mon, Dec 14, 2009 at 05:33:43PM +0530, Manish Ranjan wrote:
I am using mysql 5.0.77 on RHEL 5. Storage engine in MyISAM.
Please refer to the below two statements. First query is checking for
lastname 'clarke' where as second query is checking for lastname 'clark'.
Rest
Tom Worster f...@thefsb.org :
my guess is that it would be better if mysql did not need to fork.
the harm would be the confusion caused to users.
I really dont think it is a problem.
_Users_ lazzy to follow the fork will stay with MySQL under Oracle.
_Users_ less lazzy will switch.
49 matches
Mail list logo
