Is there a max number of databases that will run under mysql
---
Keith Schuster
Schuster & Company LLC
ph:704-799-2438
fx:704-799-0779
iChat/AIM:FSHSales
WWW.FlagShipHosting.com
WWW.Schusterandcompany.com
WWW.Vsheet.net
--
MySQL
Wow! Great timing.
Thanks Jeremy
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 02, 2003 11:13 PM
To: Adam
Cc: [EMAIL PROTECTED]
Subject: Re: SuperSmack on x86_64 / gcc 3.2.2
On Tue, Sep 02, 2003 at 10:23:42PM -0400, Adam wrote:
> Anyone eve
I installed and linked 0.9.2 on RH9 as instructed, and when
I start mysqlcc, I get the server registration dialog. When I attempt to
connect, I get a message in the message dialog which says “connecting…”
and that’s it! It never actually connects. I have checked to make sure
that mysqld
Hi,
I was wondering if it is possible to customise the message that appears
when logging in using the mysql command line tool.
When I connect using mysql I get the standard message below. This is the
message I would like to customise with some extra information of my own.
Does this information c
John:
How do you plan to "remove" an $array[2]?
If you are using associative arrays, then you can remove an element
using the unset() function, and then the answer to your question is
"yes", so to speak:
For example:
\n";
}
$array = array( 'first' => 'one', 'second' => 'two', 'third' =>
'thr
Hi,
Can anyone tell me which function have more security/encryption?
PASSWORD( ) ?
ENCODE( ) ?
MD5( ) ?
Thanks a lot.
Fernando Bernardino
On Tue, Sep 02, 2003 at 10:23:42PM -0400, Adam wrote:
> Anyone ever get super-smack to compile on this system?
>
> I get tons of warnings/errors that look like syntax errors almost. Not
> sure what I am doing wrong.
Funny you mention that. I'm about to post version 1.2 that may work
for you.
S
Hello ,
I need to copy the database contents from one operating system to
another operating system..if i copy the entire database folder it is
coping only the table structure..contents is not getting copied..can
anyone please tell me how do i go do this ??
Regards,
Uma
--
MySQL Genera
At 23:14 -0400 9/2/03, Keith Schuster wrote:
Is there a max number of databases that will run under mysql
Not unless your operating system limits the number of directories
that a given directory can contain. (MySQL represents each database
by a directory under the data directory.)
--
Paul DuBois,
Hi,
I suspect that I have a 'double' installation of MySQL that have giving me
lots of problems with other packages (RMysql, but not with perl-mysql or
php-msql).
I started with a Mandrake 9.0, with MySQL version 3.20 and I upgrade recently
to 4.0.12.
How can I verify if really I have two ve
Yes, it should. Check it yourself by printing out array values:
echo array[2];
echo array[3]; etc.
If it's a really long array and you want to print the whole thing, look at
foreach, http://us2.php.net/manual/en/control-structures.foreach.php
--> might be equal to the max number of directories you file system
supports.
Thomas Spahni
On Tue, 2 Sep 2003, Keith Schuster wrote:
> Is there a max number of databases that will run under mysql
> ---
> Keith Schuster
> Schuster & Company LLC
> ph:704-799-2438
> fx
"gibex" <[EMAIL PROTECTED]> wrote:
>
> I have 2 tables and I want a faster report like this.
>
> | counter | user_company_name |
> +-++
> | 65537 | company1 |
> | 65535 | company2 |
> | 64563 | company3 |
> | 52676 | comp
I have a query with a column in HAVING clause that not refer any column listed in
SELECT statement because I don't need to group by this column and ... this query don't
work.
It's possible or this feature is planned for the future?
Any solution?
Thanks
* Keith Schuster
> Is there a max number of databases that will run under mysql
This is AFAIK limited only by the OS: how many directories can exist inside
one directory.
Most file systems will perform slower with a high number of entries in a
single directory, how high this number is depends on
I've been using MySQL and PHP for a while in a shared hosting
environment, but recently we shifted to a co-located server, so I am
new to administering mysqld.
Periodically our PHP sites will fail to connect using mysql_pconnect().
We currently have three sites on the colo box (two more are wai
On Tue, 2 Sep 2003 21:40:35 -0500
"John Macon" <[EMAIL PROTECTED]> wrote:
> I have a quick question about arrays. I know that this is probably pretty easy for
> most of you out there, so here it goes.
>
> If you remove $array[2], would $array[3] then automatically become the new $array[2]?
>
>
Dear Vivian Wang:
This depends a little upon what version you are using,
===
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 77 to server version: 4.1.0-alpha-max-debug
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> select version();
Thanks Fortuno, Adam
Actually, I was thinking about concurrent users that mysql can handle,
provided with reasonable hardware.
Looking for comments / suggestions.
Regards,
Tariq
Fortuno, Adam wrote:
Tariq,
Check the list's history - this is actually a frequent question. The answer
everyone i
Hi,
I was creating tables with more or less columns with their index. When I try
to created one of these tables I was sent the next message:
EXCEPTION java.sql.SQLEXCEPTION:Invalid argument value, message from server
"Two many key part specified. Max 16 parts allowed".
The query to create this t
"Joris Beckers" <[EMAIL PROTECTED]> wrote:
>
> I used the flush privileges command
>
> There are in total 6 databases
>
> But only mysql and cehdb are visible.
>
> The MySQL version is 4.1.0-max-nt
>
> There are no other hosts configured for that user other then %
>
> Because it's mysql 4, th
Hi
I have 2 tables and I want a faster report like this.
| counter | user company name |
+-++
| 65537 | company1 |
| 65535 | company2 |
| 64563 | company3 |
| 52676 | company4 |
User table description
| Field
Mark Matthews wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Spam Bait wrote:
[snip]
Does anyone have a link to some docs on the syntax for 'create procedure'?
I checked on the net for PL/SQL syntax, and found some Oracle and
Postgres examples, but none of them worked for me.
Just a litt
Hi all,
consider I want to compare one field stored in two tables (the field
being a key in both tables), like
SELECT table1.field FROM table1, table2 WHERE table1.field=table2.field
I have the choice (I'm developping the datamodel right now) to define
this field as an INT(6) or as an VARCHAR(6)
I am trying to select the column names from a table to be displayed in a
web page. Is there anyway to select column names without desc?
Thanks,
Jake Johnson
[EMAIL PROTECTED]
__
Plutoid - http://www.plutoid.com - Shop Plutoid fo
Hi,
We are running numerous queries which join anything from 3 - 10 tables together.
Can I please ask the advice of the group as to the most efficient way to write such
queries in MySQL V4. The example below has one 3 tables but 6/7 is more common.
1. using the WHERE statement to show the matc
Hey folks,
I am trying to run the following sql query in mysql:
SELECT TD.project_id, P.project_manager
FROM time_daily TD
INNER JOIN projects P ON P.project_id = TD.time_project_id
WHERE TD.time_user_id = 'xpt' AND (
SUM( TD.time_hours_worked ) <> '0.00'
)
And I keep getting the # errno
Matt:
The left joint query take 4 ever to generate - in fact - I left it 5 mins
and still no results
I have done it for the moment with a loop through php and querying the
vtconlineusers table by creation date/dealercode for each return hits date,
but that takes too long also - 30 seconds fo
John,
John Dangler said:
> I installed and linked 0.9.2 on RH9 as instructed, and when I start
> mysqlcc, I get the server registration dialog. When I attempt to
> connect, I get a message in the message dialog which says "connecting."
> and that's it! It never actually connects. I have checked
Looks like an interesting benchmarking tool.
BTW, I thought http://highperformancemysql.com/ looked interesting; when's
it due to be published?
David.
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Adam" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, Sep
Uma,
Uma Shankari T. said:
>
>
> Hello ,
>
>
>I need to copy the database contents from one operating system to
> another operating system..if i copy the entire database folder it is
> coping only the table structure..contents is not getting copied..can
> anyone please tell me how do i go do t
Darryl,
Sorry for not responding sooner.
Looking at this. First I'd recommend delimiting by something other than
tabs. I typically use pipes '|' as my delimiter. Tabs and commas can be
problematic for a variety of reasons.
Second, double check your dates. All I can think of is SQL Server syntax
On 3 Sep 2003 at 15:43, Stefano Fraccaro wrote:
> I have a query with a column in HAVING clause that not refer any
> column listed in SELECT statement because I don't need to group by
> this column and ... this query don't work. It's possible or this
> feature is planned for the future?
Can you g
Stefano,
OOh! You're taking me back a few years. As best I remember, the 'HAVING'
operator applies to the results returned by the query not in shaping the
results to be generated. For example, if you have a table that stores
trouble tickets per user. You select the user's last name, first name, an
Matt:
The left joint query take 4 ever to generate - in fact - I left it 5 mins
and still no results
I have done it for the moment with a loop through php and querying the
vtconlineusers table by creation date/dealercode for each return hits date,
but that takes too long also - 30 seconds fo
I have the same question as posted in this thread:
http://lists.mysql.com/list.php?list=mysql&post=71462
- Dhsieh
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On 3 Sep 2003 at 18:59, eli wrote:
> EXCEPTION java.sql.SQLEXCEPTION:Invalid argument value, message from
> server "Two many key part specified. Max 16 parts allowed".
> [...]
> INDEX(ID, Field_1, Field_2,Field_3, Field_23)
> )
>
> I was supossed the maximum number of index was 32.
The maxim
I can log into mysql using
safe_mysqld --skip-grant-tables &
mysql -u root -mysql
The directions say that from mysql I should be able to manually execute
the SQL commands in mysql_install_db
and then run mysqladmin flush-privileges afterword.
It is not apparent to me how to manually e
At 9:26 +0200 9/3/03, Hoeven, Maarten van der wrote:
Hi all,
consider I want to compare one field stored in two tables (the field
being a key in both tables), like
SELECT table1.field FROM table1, table2 WHERE table1.field=table2.field
I have the choice (I'm developping the datamodel right now) t
At 22:45 -0700 9/2/03, Jake Johnson wrote:
I am trying to select the column names from a table to be displayed in a
web page. Is there anyway to select column names without desc?
What's wrong with using DESCRIBE?
You could issue SELECT * FROM tbl_name WHERE 0 and then examine the
result set metad
At 11:11 +0100 9/3/03, Liz Scates wrote:
Hi,
We are running numerous queries which join anything from 3 - 10
tables together.
Can I please ask the advice of the group as to the most efficient
way to write such queries in MySQL V4. The example below has one 3
tables but 6/7 is more common.
If a
At 11:24 -0500 9/3/03, Cory Hicks wrote:
Hey folks,
I am trying to run the following sql query in mysql:
SELECT TD.project_id, P.project_manager
FROM time_daily TD
INNER JOIN projects P ON P.project_id = TD.time_project_id
WHERE TD.time_user_id = 'xpt' AND (
SUM( TD.time_hours_worked ) <> '0.00'
Tariq Murtaza said:
> Thanks Fortuno, Adam
>
> Actually, I was thinking about concurrent users that mysql can handle,
> provided with reasonable hardware.
> Looking for comments / suggestions.
>
> Regards,
>
> Tariq
>
> Fortuno, Adam wrote:
>
>>Tariq,
>>
>>Check the list's history - this is actuall
Cory,
Cory Hicks said:
> Hey folks,
>
> I am trying to run the following sql query in mysql:
>
> SELECT TD.project_id, P.project_manager
> FROM time_daily TD
> INNER JOIN projects P ON P.project_id = TD.time_project_id
> WHERE TD.time_user_id = 'xpt' AND (
> SUM( TD.time_hours_worked ) <> '0.00'
>
not knowing anything about PHP (java geek, myself), I'm guessing that your connections
are timing out, and php is not configured to try to reconnect
Another option is that you are not closing your connections, so you can't get a new
connection to do anything with. Also new to MySQL, I'm not
Sorry,
I think it should be
GROUP BY TD.project_id, P.project_manager
Cory Hicks said:
> Hey folks,
>
> I am trying to run the following sql query in mysql:
>
> SELECT TD.project_id, P.project_manager
> FROM time_daily TD
> INNER JOIN projects P ON P.project_id = TD.time_project_id
> WHERE TD.
I was wondering of there is a way to kill multiple processes in MySQL
rather than one at a time?
-James
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Ahh... the proverbial 'how many licks does it take to core the database'
There is no straightforward answer. That's the bad news.
However, the basics are identical for all databases
basically, though,
the more memory you have, the more concurrent connections you can handle.
The more CPU
Hi all, new to the list and new to mySQL...
I've only been at it for a few days and am looking at importing text files to
databases.
I'm having trouble with mysqlimport and would appreciate any help or solutions as to
what I'm doing wrong - I'm sure its a dumb mistake!
I tried LOAD DATA INFILE
>Any chance you OS swapped out part of your key_buffer? See if any
of
>mysqld's memory is sitting in swap.
>
>Jeremy
Hi,
how exactly do I tell this on linux?
Thanks,
- Mark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/
So, we have this table: ArpMon that looks like this:
-- mysql> describe ArpMon;
++---+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
++---+--+-+-+---+
| am_mac | varchar(20) | | PRI |
I'm having a problem where a complex SELECT query begins eating up lots
of CPU and never returns. In "show processlist", it
reports "Copying to tmp table". Other queries seem to get locked
waiting for this query, as well.
This is on version 3.23.36 of mySQL, and I'm considering upgrading to
the
I'm writing a search engine to query a database to my site. I know how
to use a WHERE product_name = "foo" if somebody enters the exact product
name, but how could I do something like: WHERE product_name = "*foo*" so
all results containing "foo" in product name would be returned and not
just produ
At 21:26 -0400 9/3/03, Dan Anderson wrote:
I'm writing a search engine to query a database to my site. I know how
to use a WHERE product_name = "foo" if somebody enters the exact product
name, but how could I do something like: WHERE product_name = "*foo*" so
all results containing "foo" in produc
At 15:46 -0700 9/3/03, James Kelty wrote:
I was wondering of there is a way to kill multiple processes in MySQL
rather than one at a time?
-James
Not with the KILL statement, which accepts a single thread ID at a time.
You can use the mysqladmin program to specify multiple IDs:
mysqladmin kill id1,
At 16:49 -0700 9/3/03, James Kelty wrote:
So, we have this table: ArpMon that looks like this:
-- mysql> describe ArpMon;
++---+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
++---+--+-+-+---+
|
At 0:34 +0100 9/4/03, Neil Belch wrote:
Hi all, new to the list and new to mySQL...
I've only been at it for a few days and am looking at importing text
files to databases.
I'm having trouble with mysqlimport and would appreciate any help or
solutions as to what I'm doing wrong - I'm sure its a
One thing about the pooling, persistent connections is that if you create temporary
tables you need to drop them before you leave, or they just might be hanging around
and if you have routines that create them, they could/will be there, because the
session is still active.
At least I think that
I am using Linux 7.1 with MySql and client win98 .I have installed CC on win 98 and
after giving the info it needs to connect I get an error :
1/ if specified with username @ localhost [SQL-SERVER] ERROR 2003: Can't connect
to MySQL server on 'localhost' (10061)
2/ if specified with usern
Hello,
I am making a avatar chat you can see some of my work and I hope you could
help me in a small area that im needing help in which is making your client
and server to be able to split avatars such as like on www.habbohotel.com
you have one user with his / her own avatar and you have another us
On Wed, 3 Sep 2003 11:42:35 -0400
Parker Morse <[EMAIL PROTECTED]> wrote:
> Periodically our PHP sites will fail to connect using mysql_pconnect().
> We currently have three sites on the colo box (two more are waiting on
> shared hosting until I can solve this problem) and they all fail at
> on
On Wed, 3 Sep 2003 00:14:42 -0300
"Fernando (BOL)" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Can anyone tell me which function have more security/encryption?
> PASSWORD( ) ?
> ENCODE( ) ?
> MD5( ) ?
Please, read http://www.mysql.com/doc/en/Miscellaneous_functions.html
PASSWORD & MD5 are realizations
On Wed, 3 Sep 2003 18:23:00 -0400
"Dan Greene" <[EMAIL PROTECTED]> wrote:
> not knowing anything about PHP (java geek, myself), I'm guessing that your
> connections are timing out,
> and php is not configured to try to reconnect
PHP always reconnects, but *_pconnect seeks for the already exi
Fabrice Trichard <[EMAIL PROTECTED]> wrote:
>
> I am using Linux 7.1 with MySql and client win98 .I have installed CC on win 98 and
> after giving the info it needs to connect I get an error :
>
> 1/ if specified with username @ localhost [SQL-SERVER] ERROR 2003: Can't connect
> to MySQL se
To Walt,
>
> I came across the articles on archiving log file which posted on Wed,
>07 Aug 2002.
> can i have a copy of the shell script regarding on automatically
>archive log file in MySql. I m currently writing a perl script on
>archiving log file generated by Snort Sensor? This scr
65 matches
Mail list logo