Hello,
I'm new to mysql (and databases, fo that matter) and have problems
finding a solution. The situation is as follows:
I have one table with filtered information about users, the columns
are, say, id, field and value. As you can see, any id can have more
rows assiciated with him, each
HI,
We are working on a software tool for keyword analysis.
Our proposed software will have Mysql as the backend database server.
The proposed database will contain atleast 80 million rows and there will a lot
of concurrent search (string search) and update operation by the software on
the
Hello,
is there any way to tell the number of simultaneous connections to a
mysql database at a given time, using SQL or a scripting language such
as php, perl, etc. ?
Many thanks.
Philippe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Philippe de Rochambeau wrote:
Hello,
is there any way to tell the number of simultaneous connections to a
mysql database at a given time, using SQL or a scripting language such
as php, perl, etc. ?
Many thanks.
Philippe
show status is your friend:
show status like Connections
HTH,
Wolfram
--
andrej h wrote:
Hello,
I'm new to mysql (and databases, fo that matter) and have problems
finding a solution. The situation is as follows:
I have one table with filtered information about users, the columns
are, say, id, field and value. As you can see, any id can have more
rows assiciated with
You seem to be confused in your posting. Your first list is in ASC order
and appears correct. Your second list seems to be in DESC order and also
seems to be correct. Why is it your results need to have '2004-11-20'
pretend to be AFTER '2004-11-24' so that it appears first in a descending
On Wed, 2004-11-24 at 09:15 -0600, Jeff Smelser wrote:
On Wednesday 24 November 2004 07:32 am, Hristo Chernev wrote:
How to upgrade from 3.23.58 to 4.1.7? Which is the easiest way with minimal
risk and downtime?
Yeah right.. ;)
Background: Heavy loaded mysql server, only one database
Date: Mon, 29 Nov 2004 14:03:32 +0100
To: [EMAIL PROTECTED]
From: Philippe de Rochambeau [EMAIL PROTECTED]
Subject: Number of connections to a database
Message-Id: [EMAIL PROTECTED]
Hello,
is there any way to tell the number of simultaneous connections to a
mysql database at a given time, using
Hello.
Looks like you've solved the problem? Remove quotes from show create...
statements:
show create table table_name;
Steve Mansfield [EMAIL PROTECTED] wrote:
---
On Saturday 27 November 2004 12:38, Steve Mansfield wrote:
Seem to be answering my own
Hello.
Usually such error occurs on Windows boxes. If you can apply recomendations
for Windows to FreeBSD :), look at:
http://dev.mysql.com/doc/mysql/en/Windows_troubleshooting.html
Can you upgrade to 4.0.22 or 4.1.7?
Ricardo David Martins [EMAIL PROTECTED] wrote:
Hi
I am
Hello.
From http://www.mysql.com/products/cluster/faq.html:
Near-linear scalability shown on system where each storage node executed
on the following hardware:
CPU:2x Intel Xeon Processors at 2.8 GHz
Memory: 16GB RAM
HDD:4 x 73GB SCSI
RAID 1 Controller
Gigabit
Hello.
Usually you should follow instructions in chapters at:
http://dev.mysql.com/doc/mysql/en/Debugging_server.html
Stuart Felenstein [EMAIL PROTECTED] wrote:
I'm not sure what happened but when I ran some test
yesterday on a transaction it failed. Being puzzled
I started
What steps are needed to upgrade (or remove) the builtin mysql [3.23.49]
included with php 4.3.1 source?
I have mysql 4.x installed and working by itself, but php continues to use
3.23.49.
I have tried recompiling php 4.3.1 without --with-mysql on the configure
line. Doing so did not remove
I've been having this issue as well, happening more frequently to our
production web /ejb servers. I've increased the logging to warning level,
but my logs don't contain much (if any) information. Is there a way to
increase logging to debug level, or get more information as to what is
causing
Stembridge, Michael wrote:
I have tried recompiling php 4.3.1 without --with-mysql on the configure
line. Doing so did not remove the builtin 3.23.49 package.
You need to run configure with the new MySQL directory explicitly
specified, e.g.
./configure --with-mysql=/usr/local/mysql_4.1.7
HTH,
--
I'm trying to create the most efficient way to allow a user to change
the display order of a group of rows in a table.
Lets say the basic table is:
id
group_id
name
sort_order
The query to display it would be
SELECT id, name FROM mytable WHERE group_id = $x ORDER BY sort_order
Now when I display
I wouldn't use a loop but an UPDATE statement instead.
If I understand you correctly, all of your records are in the same group
but you need them displayed in a user-defined order. It would be MUCH
easier to manage that if the sort order values were already in sequential
order. You may need
Michael J. Pawlowsky wrote:
I'm trying to create the most efficient way to allow a user to change
the display order of a group of rows in a table.
Lets say the basic table is:
id
group_id
name
sort_order
The query to display it would be
SELECT id, name FROM mytable WHERE group_id = $x ORDER BY
I have a table of members, about 13,000 rows.
Each night I need to shuffle the table. I have a small int column called
random_position. Currently I am creating a position list (based on the count
of the members), shuffle it, then while iterating through the members
assigning them a a position.
At 11:08 AM 11/29/2004, you wrote:
I have a table of members, about 13,000 rows.
Each night I need to shuffle the table. I have a small int column called
random_position. Currently I am creating a position list (based on the count
of the members), shuffle it, then while iterating through the
It would be equally easy to swap any two items in the list, not just two
adjecent items. Just swap sort_order values.
Yup... I think that is the key!
Basically as they are inserted I will look up the max sort_order value
for that group so far and increase that by one for the current insert.
On 11/29/04 12:27 PM, mos [EMAIL PROTECTED] wrote:
Mike,
Your solution is way too complicated (it makes my head hurt).g
Try this:
set @n=0;
update tmp set rnd = @n := @n + 1 order by RAND()
Mike
I'll give this a shot. Follow-up question:
I've had a lot of trouble with RAND() on
I have a replication server that is running out of disk space because of
old relay binary log files.
Both it and the master server are version 4.0.20.
I have a cron script that maintains a 3 day history of binary log files
on the master server.
Has someone figured out a way to manage the
Hi List,
I installed the MySQL 4.1.7 on my Windows XP and for that I have used the
my.ini to set the startup configuration for using a different language and
to use the old_password.
Now I am installing on my Mac and I am wondering if there is any my.ini
or my.cnf on Mac OS X.
Does anyone knows
- Original Message -
From: Mike Zornek [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, November 29, 2004 12:08 PM
Subject: SQL question Trying to improve upon my PHP solution.
I have a table of members, about 13,000 rows.
Each night I need to shuffle the table. I have a
Bill Thomason wrote:
I have a replication server that is running out of disk space because of
old relay binary log files.
Both it and the master server are version 4.0.20.
I have a cron script that maintains a 3 day history of binary log files
on the master server.
Has someone figured out a way to
Scott Tanner wrote:
I've been having this issue as well, happening more frequently to our
production web /ejb servers. I've increased the logging to warning level,
but my logs don't contain much (if any) information. Is there a way to
increase logging to debug level, or get more information as
Wouter de Jong wrote:
Hello,
For a few servers with 1000 concurrent connections,
I've compiled glibc 2.3.3 with a patched STACK_SIZE in
linuxthreads/descr.h :
#ifndef STACK_SIZE
#define STACK_SIZE (128 * 1024)
#endif
instead of #define STACK_SIZE (2 * 1024 * 1024)
This by the hints on the
Mac OS X is Unix, so you follow the directions for Unix, which means you use
my.cnf. See the manual for details
http://dev.mysql.com/doc/mysql/en/Option_files.html.
Michael
Andre Matos wrote:
Hi List,
I installed the MySQL 4.1.7 on my Windows XP and for that I have used the
my.ini to set the
On Monday 29 November 2004 09:01 am, Greg Macek wrote:
I am actually in the process of planning a similar upgrade for our
database server. None of our databases are that big, but was wondering
about what gotcha's I should be on the lookout for. I planned on
walking through the upgrade pages
Stuart,
you probably have
skip-innodb
in my.cnf.
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php
- Original Message -
Ronan Lucio wrote:
Hi All,
I´m having a trouble where my server is falling to it's knees
when a certain number of connections are match.
Well, in a short, I configured the my.cnf files to accept up to
120 connections. When the server receives about to 55
connections, it hangs the connections and I
At 12:57 -0600 11/29/04, Jeff Smelser wrote:
On Monday 29 November 2004 09:01 am, Greg Macek wrote:
I am actually in the process of planning a similar upgrade for our
database server. None of our databases are that big, but was wondering
about what gotcha's I should be on the lookout for. I
On 11/29/04 1:26 PM, Rhino [EMAIL PROTECTED] wrote:
I don't think this is a question about SQL at all; I think you already know
how to write the SQL to select, insert, update or delete rows.
I think that what you really want to know is if there is a more efficient
way to shuffle your rows
--- Heikki Tuuri [EMAIL PROTECTED] wrote:
Stuart,
you probably have
skip-innodb
in my.cnf.
Best regards,
Heikki Tuuri
Heikki - Nope , doesn't seem so. My.cnf is below.
Also, I'm guessing that if it was set to skip-innodb,
I wouldn't not have had the ability to change them
back.
I want to put a table
in Ram (HEAP) with a field of at least 500 characters. I do I do this if
Blob and text are not allowed?
ThanksDonny LairsonPresidenthttp://www.gunmuse.com469 228 2183
At 11:53 AM 11/29/2004, you wrote:
On 11/29/04 12:27 PM, mos [EMAIL PROTECTED] wrote:
Mike,
Your solution is way too complicated (it makes my head hurt).g
Try this:
set @n=0;
update tmp set rnd = @n := @n + 1 order by RAND()
Mike
I'll give this a shot. Follow-up question:
I've had a
I just have finished to install the version 4.1.7 on my Mac and I looked at
these directories below and I couldn't find the file my.cnf as described
on the like that you gave me:
/etc/my.cnf
DATADIR/my.cnf
~/.my.cnf
Do I need to create it or MySQL is suppose to do the job?
Thanks.
Andre
On
At 15:26 -0500 11/29/04, Andre Matos wrote:
I just have finished to install the version 4.1.7 on my Mac and I looked at
these directories below and I couldn't find the file my.cnf as described
on the like that you gave me:
/etc/my.cnf
DATADIR/my.cnf
~/.my.cnf
Do I need to create it or MySQL is
Hello,
I installed a tar.gz version and I found it in a support directory:
there are some my.cnf file my{}.cnf where is large, huge,
...
Santino
At 15:26 -0500 29-11-2004, Andre Matos wrote:
I just have finished to install the version 4.1.7 on my Mac and I looked at
these directories
Stuart,
ok, then this is a complete mystery. I have not heard about this before.
Regards,
Heikki
- Original Message -
From: Stuart Felenstein [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Monday, November 29, 2004 9:33 PM
Subject: Re: Bizarre table type switch
--- Heikki
At 1:09 PM -0700 11/29/04, [EMAIL PROTECTED] wrote:
I want to put a table in Ram (HEAP) with a field of at least 500
characters. I do I do this if Blob and text are not allowed?
The glib answer would be: you can't.
Two alternatives would be: (1) split your text field up into as many
Create a myISAM table and put the table on a RAM DISK. It will support
everything that heap does and more, like ranges ( 4.1 only allows Hash
lookups).
CREATE TABLE TABLE NAME (
..
) INDEX DIRECTORY = /dev/shm DATA DIRECTORY = /dev/shm
DVP
Dathan Vance Pattishall
I have MySQL installed on my Windows XP machine. No problems.
I have seen examples of MySQL interfacing with C in the UNIX
environment.
I can install Visual C++ on my XP machine. Is it possible to interface
any such Windows-based C/C++ compiler with MySQL?
Any examples?
Thanks.
Thank you Michael for your very thoughtful reply. I know that it takes
time and effort to answer at the level you did.
Michael Stassen Michael.Stassen-at-verizon.net |Lists| wrote:
You seem to have a fundamental misunderstanding of the TIMESTAMP type.
No timezone or DST information is stored
pete-at-holidian.com |Lists| wrote:
Disclaimer: I'm new to source control in general and Subversion in specific
...
I'd like to be able to make the change and then push those changes...
I just wanted to make sure you are aware that the server doesn't know
about / keep track of all the checked out
thanks for all the help
this will help as I think the client wants this project in 3 languages
On Nov 28, 2004, at 7:25 AM, Rhino wrote:
- Original Message -
From: Gleb Paharenko [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, November 27, 2004 5:36 AM
Subject: Re: Newbie: How to
Ok, I'm new to MySql (or SQL in general). I'm curious what exactly a
stored procedure in MySql is, and what the benefit would be?
Steve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
- Original Message -
From: Steve Grosz [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, November 29, 2004 10:55 PM
Subject: Stored Procedure?
Ok, I'm new to MySql (or SQL in general). I'm curious what exactly a
stored procedure in MySql is, and what the benefit would be?
On Mon, 2004-11-29 at 13:11 -0600, Paul DuBois wrote:
At 12:57 -0600 11/29/04, Jeff Smelser wrote:
On Monday 29 November 2004 09:01 am, Greg Macek wrote:
I am actually in the process of planning a similar upgrade for our
database server. None of our databases are that big, but was
I'm using multiple dbs for my very high traffic
multiple sites.
One of my db (say parentDb) just maintains users who
can login to all the sites. Others are sites specific
dbs(say childDbs).
I'm using INNODb tables for my parentDb while my
childDbs tables are of MyISAM type.
Some code does have
Good morning!
Important: SQL Server used: MySQL (version 4.0.17) on UNIX FreeBSD.
Answer this question please:
Can I make a request, consisting of several SQL commands at one step, like this:
use DBI;
my $db = DBI-new();
$db = DBI-connect(...) or die Can't connect to DataBase:, error code,
\n;
52 matches
Mail list logo