Re: Innodb gets disabled

I did the same as you have written, but innodb storage engine is not available now. Even the skip-innodb is commented in my.cnf On Jan 16, 2008 9:43 PM, Rolando Edwards [EMAIL PROTECTED] wrote: 1) 'mysqldump' all databases to an SQL file 2) Drop all databases 3) Shutdown mysqld 4) Delete

[HELP] I'm looking for document about References attribute for Mysql 4.1

Hi all, I'm looking for information about References attribute in Mysql, help me! thanks in advance. Bo

MySql at 100% CPU

Dear MySql, I hope you can help me trace a problem. Every few days one of my 5.0.45 will stick at 100% CPU whilst not doing very much. The server is a replication master and slave, but idle at this time. I am running 100% InnoDB and there is nothing in the error log. It will stay that

Re: Lost Connection each hour :(

On Tue, Jan 15, 2008 at 09:27:10PM +0100, MAS! wrote: Can anyone help me to understand why my site (php 4.4.2 / ubuntu dapper) loose all connections to mysql server when /etc/cron/hourly starts? (there are no process to start hourly, the directory is empty) Is the assumption correct, that

performances and optimization in multiple join queries

Hello everybody! I have a huge query (something similar to a search engine), full of left joins and my testing server takes several minutes each time to output the recordset. I was looking for some (right) way to optimize the search. there were some solutions proposed around, like split in n

mysqldump - new version = no data?

I've been using mysqldump in a Perl script for a client of mine to do database dumps for several years and until recently it has worked fine. However I noticed that in a recent dump, no data or schema was created. Since I don't know for sure where 'mysqldump' is located on the remote system I

Re: performances and optimization in multiple join queries

So many tables join.OH. Can you paste your explain results here? On 1/17/08, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hello everybody! I have a huge query (something similar to a search engine), full of left joins and my testing server takes several minutes each time to output the

memory usage in relation to open connections

hello, i'm searching for some information about how many system memory mysql uses in relation to the open connections. in the last weeks we often had the problem of too many connections, but before raising the configuration value, we would like to calculate a maximum amount of used memory. the

Re: performances and optimization in multiple join queries

[EMAIL PROTECTED] schrieb: Hello everybody! I have a huge query (something similar to a search engine), full of left joins and my testing server takes several minutes each time to output the recordset. I was looking for some (right) way to optimize the search. there were some solutions

Re: Innodb gets disabled

Have you checked filesystem permissions where InnoDB needs to create its files? And you're sure you've removed ALL of InnoDB's previous data and log files? And there's nothing in the server's error logs? Are you looking in the right error logs? (cause an error deliberately and look for it to be

RE: changed directory name

This is actually a PHP issue and nothing to do with MySQL. You're correct in that since you renamed the directory, the scripts can't find their includes. Ideally, they should be using relative path names and/or setting the include_path php.ini variable to avoid this. The quick however, answer is

creating temp file, modifying data and putting into other table

Can someone please advise. I am looking to create a multiuser friendly way of getting a subset number of rows from a table into another whilst making a modification. I thought that this could be done using a temporary table in a batch script that is unique to that session e.g. create temporary

slaves to specific tables

hey guys - is it possible to have a lightweight slave setup? so that you only take X amount of tables from the DB curious what good solutios are out there

changed directory name

Hi guys, Im really new to this (I only have html background) so if im asking stupid q's please bare with me. I changed my open reallty file name to extreme, when I try to load the file http://localhost/Extreme/admin/index.php in explorer and I keep on getting these errors, I think I have to

Re: MySql at 100% CPU

At 3:25a -0500 on 17 Jan 2008, Ben Clewett wrote: I need to know why MySql does this. If any person knows how I an identify the problem, please let me know! I think this package helped another person out on this list a couple days ago:

Re: slaves to specific tables

I do it all the time, look at: --replicate-do-table In: http://dev.mysql.com/doc/refman/5.0/en/replication-options.html Section of my mysql.conf: # Replication Options replicate_do_table = db.member replicate_do_table = db.company replicate_do_table =

Sun and mysql

I am still amazed by the fact that youtube is worth 1.5 billion and MySQL AB barely 1 billion. Did they sell under price? Or does Google just have way to much many to spend/waste? Greetings from the just wondering... Olaf - Confidentiality Notice: The

RE: Sun and mysql

[snip] I am still amazed by the fact that youtube is worth 1.5 billion and MySQL AB barely 1 billion. Did they sell under price? Or does Google just have way to much many to spend/waste? [/snip] Or that Facebook is 'worth' multiple billions when they do not really have a way to make money yet.

Re: Prepared SQL statements - Faster performance?

I can't speak to the exact internals of MySQL, but in database practice one *generally* uses prepared statements for two reasons: 1. Security 2. Speed If your system is at all exposed to the outside world *and you at all value your data*, your biggest concern should /absolutely/ be security.

RE: Innodb gets disabled

Login to mysql and execute SHOW VARIABLES LIKE 'innodb%'; And email the display Also, show the last 30-50 lines of your error log And let's see if they reveal anything From: Krishna Chandra Prajapati [mailto:[EMAIL PROTECTED] Sent: Thursday, January 17, 2008

Re: Sun and mysql

On Thu, 17 Jan 2008 11:07:19 -0500 Olaf Stein [EMAIL PROTECTED] wrote: I am still amazed by the fact that youtube is worth 1.5 billion and MySQL AB barely 1 billion. Did they sell under price? Or does Google just have way to much many to spend/waste? On Thu, 17 Jan 2008 10:14:36 -0600 Jay

Re: Sun and mysql

Olaf Stein wrote: I am not judging this move by mysql, as long as it stays open source, this is probably good for the product itself. I just think it is weird that a pure entertainment website (admittedly with lots of users) is estimated at so much more than a software company. Two words:

Re: Sun and mysql

I am not judging this move by mysql, as long as it stays open source, this is probably good for the product itself. I just think it is weird that a pure entertainment website (admittedly with lots of users) is estimated at so much more than a software company. Olaf On 1/17/08 12:10 PM, Barry

Re: Sun and mysql

Olaf Stein wrote: I am still amazed by the fact that youtube is worth 1.5 billion and MySQL AB barely 1 billion. Did they sell under price? Or does Google just have way to much many to spend/waste? Greetings from the just wondering... Olaf MySQL A.B., so far as I know, derives

generating numbers from other fields

how can i join three fields Values into one field? so in three select boxes i have date : Projects type 1 - 7 and project type 1 - 6 so the third Filed would be 116200824 generated by the other three fields? thanks -- MySQL General Mailing List For list archives:

valuation tangent (was Re: Sun and mysql)

Olaf Stein [EMAIL PROTECTED] wrote: It will be interesting to see if facebook, youtube and alike websites will ever generate enough earnings to cover the costs they were bought for. Just because 50 million people know a website, it does not mean it makes money automatically. The Google model

Re: MySql at 100% CPU

Hi Kevin, Thanks for the advise. The package you show gives the same output as the 'SHOW PROCESSLIST' output, which I included in my previous email :) The problem I have is that the process list, by 'mytop' or 'SHOW PROCESSLIST' shows the server doing noting. Yet 'top' and other tools

Re: Sun and mysql

You have a point. But, facebook makes NO money at this time, has about 400 employees and Microsoft estimates its values at 15 billion dollars. I simply think this is nuts. Maybe I am too old with 30, but I have never even been to facebook. It will be interesting to see if facebook, youtube and

Re: Sun and mysql

Olaf Stein wrote: I am still amazed by the fact that youtube is worth 1.5 billion and MySQL AB barely 1 billion. Did they sell under price? Or does Google just have way to much many to spend/waste? Greetings from the just wondering... Olaf MySQL A.B., so far as I know, derives income from

Re: Sun and mysql

I am not judging this move by mysql, as long as it stays open source, this is probably good for the product itself. I just think it is weird that a pure entertainment website (admittedly with lots of users) is estimated at so much more than a software company. Much bigger market :-)

Re: Sun and mysql

I understand the marketing and hype thing. I still have a hard time believing that the net worth is actually that high. I guess we will see in 10 years or so... Maybe facebook should by GM, Ford can use some of that hype On 1/17/08 12:19 PM, Mark Leith [EMAIL PROTECTED] wrote: Olaf Stein

Upcoming Mandatory Changes post-Sun Acquisition

Greetings! Bill Bilano here to chime in on what the Sun acquisition will mean to everyone here! Below you will find a list of changes that may impact how the MySQL Server and Client tools products will be utilized in the future. This list is in no way complete and I believe that additional

Re: Sun and mysql - sorry

I guess Ford is not a GM brand. Just substitute Ford with a GM brand On 1/17/08 12:23 PM, Olaf Stein [EMAIL PROTECTED] wrote: I understand the marketing and hype thing. I still have a hard time believing that the net worth is actually that high. I guess we will see in 10 years or so...

Re: MySql at 100% CPU

At 12:08p -0500 on 17 Jan 2008, Ben Clewett wrote: The package you show gives the same output as the 'SHOW PROCESSLIST' output, which I included in my previous email :) Heh, that'll teach me to actually /use/ the package before recommending it. :-P (I just found out about it when that

Re: Computerworld reporter would like to hear from you ASAP today, on MySQL,acquisition by Sun...

Todd, I'd be happy to answer all of your questions. See my responses in-line below: What are your impressions of this deal? I think it is fantastic because it means that even more money will be made and this is what Sun's top priority is and represents what they care about,

Re: creating temp file, modifying data and putting into other table

On Jan 17, 2008 2:22 PM, Kerry Frater wrote: Can someone please advise. I am looking to create a multiuser friendly way of getting a subset number of rows from a table into another whilst making a modification. create temporary table Ttable1 (select * from masterlist where ref='ABCDE');

Computerworld reporter would like to hear from you ASAP today on MySQL acquisition by Sun...

Hello, I'm a reporter at Computerworld magazine and I'm writing a story today on MySQL user and developer reax to the Sun acquisition of MySQL. Can you drop me a note and let me know your thoughts about this ASAP? I'd like to know: What are your impressions of this deal? Is this good for the

RE: creating temp file, modifying data and putting into other table

Thanks for the input Jochem. I am testing the code using the MySQL Query Browser 1.1.20 and putting the script in a single Query window over multiple lines. The first line create temporary table Ttable1 (select * from masterlist where ref='ABCDE'); works fine (well I don't get any errors). The

RE: [SPAM] - Re: Sun and mysql - Email found in subject

-Original Message- From: Olaf Stein [mailto:[EMAIL PROTECTED] Sent: Thursday, January 17, 2008 12:13 PM To: Peter (MySQL List); MySql Subject: [SPAM] - Re: Sun and mysql - Email found in subject You have a point. But, facebook makes NO money at this

Full Text Search

hi all, i just want to know whether it is useful to alter the 50% threshold scheme that mysql uses by default ,is it beneficial in any way regarding serach(either by increasing or decreasing its value)or is it good to use default value of 50% only. which is better (altering the file to change