Where do I go to set the max_connections settings so I can have over
100?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>Description:
MySQL v4.1.0-alpha only allows a client to prepare a maximum of 254
statements. On the 255th mysql_prepare() call, a failure is returned
with no information returned by mysql_error(). This occurs even if
the statements are closed after each use.
>How-To-Repeat:
The following program
>
> At 8:20 +0100 7/22/03, Marek Lewczuk wrote:
> >On our Linux server we get this error:
> >030722 08:09:55 mysqld started
> >/usr/local/mysql/bin/mysqld: ERROR: unknown variable
> 'ft_min_word_len =
> >2' 030722 08:09:55 mysqld ended [...]
> >
> >It's strange becouse I can set this variable
At 8:20 +0100 7/22/03, Marek Lewczuk wrote:
On our Linux server we get this error:
030722 08:09:55 mysqld started
/usr/local/mysql/bin/mysqld: ERROR: unknown variable 'ft_min_word_len =
2'
030722 08:09:55 mysqld ended [...]
It's strange becouse I can set this variable through my.ini on my
Windows
On our Linux server we get this error:
030722 08:09:55 mysqld started
/usr/local/mysql/bin/mysqld: ERROR: unknown variable 'ft_min_word_len =
2'
030722 08:09:55 mysqld ended [...]
It's strange becouse I can set this variable through my.ini on my
Windows. Anyone can help me solve this problem ?
There seems to be a significant penalty imposed by the optimizer when these
3 clauses are uses together. If we use the Full Text Search the penalty is
gone. However, the Full Text Search is not a very good option in my case as
it does not offer the granularity needed.
Please see below:
Op
At 1:04 -0400 7/22/03, [EMAIL PROTECTED] wrote:
You are right above the max date query and I really appreciate your
help, but the subselect query its other question. I try the subselect
query with the 4.0.12-max win32 with the --new option in the command
line to start the server, according to the m
You are right above the max date query and I really appreciate your
help, but the subselect query its other question. I try the subselect
query with the 4.0.12-max win32 with the --new option in the command
line to start the server, according to the manual this should enable the
subselect feature,
At 21:04 -0600 7/21/03, Jim McAtee wrote:
What tools are available for importing delimted text files into MySQL tables?
I've got several very large, but simple (just seven columns of integer and
varchar) text files to import into a table.
Use the LOAD DATA statement or the mysqlimport command-line
What tools are available for importing delimted text files into MySQL tables?
I've got several very large, but simple (just seven columns of integer and
varchar) text files to import into a table.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:h
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 21 July 2003 18:48, [EMAIL PROTECTED] wrote:
> Cod Product date
> 10Nissan Car 2003-06-20
> 20Guitar Yamaha 2003-07-01
> 10Nissan Car 2003-05-01
> 30Stereo Cables 2003-01-20
> 20Gui
Dyego,
thank you for an excellent bug report. You probably tested the 4.0.14 tree?
That was where I was able to repeat the bug.
The bug was that InnoDB first deleted the old record and only after that
tested if the new record is too long (table handler error 139). You have
lots of BLOBs in the ta
On Mon, 2003-07-21 at 16:38, Michel Albert wrote:
> I've read it now a few times around here and was curious what
> "innodb" means. Is it a table-type for MySQL or a completely
> different DBMS?
>
>
It's a table type, see here:
http://www.mysql.com/doc/en/InnoDB_overview.html
for info
No problem, this is:
Kardex Table:
+---+-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
+---+-+--+-+-+---+
| Nro | bigint(20) | | PRI | 0 | |
| Fecha
Hi
This is no problem
To do this,
1 - Duplicate database A, creating second database B, ensuring that both
have separate serve IDs.
2 - Configure both A+B to replicate each other, but enable log-update on
database A. This will allow database A to act as a master to both databases.
3 - Create thi
I've read it now a few times around here and was curious what
"innodb" means. Is it a table-type for MySQL or a completely
different DBMS?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello guys, I have this question:
I need to replicate 2 databases (each one resides in a different
server) to a single slave server. Reading the documentation I have
running the master/slave replication, but i need to replicate the
other database too, the problem is: I need replicate the other
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 21 July 2003 04:14, Egor Egorov wrote:
> Michael Satterwhite <[EMAIL PROTECTED]> wrote:
> > I'm trying to add a foreign key to a table. All tables are INNODB. Table
> > a has following partial Definition:
> >
> > TableA
> > ( Fld1 int Primary
> > Worked like a charm! I couldn't find anything about this in
> > MySQL docs
> You have to search for 'string functions' to find it. Problem is that a
> search for REPLACE will bring up the REPLACE syntax, not the REPLACE()
Or you can look at the function index
http://www.mysql.com/doc/en/Funct
You have to search for 'string functions' to find it. Problem is that a
search for REPLACE will bring up the REPLACE syntax, not the REPLACE()
syntax (not the brackets ;-) )
Regards,
Mike Hillyer
www.vbmysql.com
> -Original Message-
> From: Dean Householder [mailto:[EMAIL PROTECTED]
> Se
Worked like a charm! I couldn't find anything about this in MySQL docs
though... Neither before I knew what to search for nor after. What's up
with that?
Dean
- Original Message -
From: "Mike Hillyer" <[EMAIL PROTECTED]>
To: "Dean Householder" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
S
Well it turned out we had table and index corruption on the master db
(db01) so I've fixed it and am rebuilding db02. We're having a mgmt
meeting this wed to discuss updating the production servers to MySQL ver
4.x.
The current servers run RedHat 7.1 with a single Pent-III 933mhz with
256k L2 cac
UPDATE mytable SET mytext = REPLACE(mytext,'"','');
Assuming you wised to strip a double quote, modify to suit.
Regards,
Mike Hillyer
www.vbmysql.com
> -Original Message-
> From: Dean Householder [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 21, 2003 2:49 PM
> To: [EMAIL PROTECTED]
>
Is it possible to run a query that will just alter text possibly using a regular
expression? I have about 250 rows that I want to strip quotes out of. Does anyone
know of an easy way to do this?
Dean
Does MySQL have support for calling functions in C/C++ DLLs from trigger
scripts similar to the Extended Stored Procedures functionality provided in
SQL Sever? Thanks.
Charles...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.
HI List
Need advise on a suitable my.cnf for 3.23.56 on SunOS5.8
MySQL is installed on a virtual machine with plenty of ram and swap space.
However, there is no my.cnf file currently, and mysql seems to lock up
completely from time to time even though system seems fairly stable
(although I saw som
Hi,
I'd found a bug when I'd tried to use blob fields and innoDb.
To see the bug, do the follow:
*) Create a database.
*) Import the dump file that is attached to this e-mail.
(cfgimpressao.dump)
*) Use the following commands:
select Ci_Descricao from cfgimpressao;
Actually evern if I hit enter it keeps the tty. The only way I can get
it to release is to nohup the ${MYSQL}/bin/sae_mysqld, if not I actually
have to shutdown the term window and reconnect..
Chad
On Mon, 2003-07-21 at 13:57, gerald_clark wrote:
> It writes a status message to the screen, and
At 13:43 -0400 7/21/03, chad kellerman wrote:
Hey guys,
Anyone ever notice that when you restart mysql ( whether is be thru
mysql.server or ${MYSQL}/bin/sae_mysqld the tty stays connected.
Thanks,
Chad
This may be a function of your operating system. I notice this when
I connect via ssh from
Since you are hoping to not repeat the replication setup, your one
chance is that the slave was fully synced at the time of the power
failure. If you check the master, you will see that it is now using a
different log file (whenever mysqld stops/starts a new log is
created). You can shutdown the
It writes a status message to the screen, and overwrites your shell prompt.
Hit enter, and you will probably find that you have a prompt afterall.
chad kellerman wrote:
Hey guys,
Anyone ever notice that when you restart mysql ( whether is be thru
mysql.server or ${MYSQL}/bin/sae_mysqld the tt
It appears that an application I've been trying to run (RelataMail/Relata
CRM) deletes the mysql.sock from my system. I'm running Redhat 8.0 with
MySQL 4.0.13. Is there any way to restore the mysql.sock file (eg, from
the rpm) without having to rebuild the whole system? (Reinstal
I've never used windows MYSQL, but both solaris and linux work with
up/down arrow keys to recall, edit, etc previous commands. Uses the
std emacs editing keys with a 1 line buffer.
Hmmm. Do F1 or F3 produce the last command given?
--
Ray Thompson
> >
> >I remember in WIN NT 4
Hey guys,
Anyone ever notice that when you restart mysql ( whether is be thru
mysql.server or ${MYSQL}/bin/sae_mysqld the tty stays connected.
Thanks,
Chad
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Hi,
I am trying select field / 1 as Number from table1 where id = 1;
I don't want any rounding taking place, but MySQL is currently doing it.
How can I ask for a specific number of digits with division?
The field contains 1234.5678, MySQL returns 1234.57, don't want that!
Thanks,
Cory Twibe
I was hoping not to have to do that...
Jeff McKeon
IT Manager
Telaurus Communications LLC
[EMAIL PROTECTED]
(973) 889-8990 ex 209
***The information contained in this communication is confidential. It
is intended only for the sole use of the recipient named above and may
be legally privileged. I
Hi, you don't oblige to reinstall MySQL.
One solution is to stop de mysqld (daemon) and restart it, this will
recreate
the socket file.
Hope this help.
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]
Sent: lundi 21 juillet 2003 15:59
To: [EMAIL PROTECTED]
Subject: Re: mysl
Try recreate the replication (shut down the servers, copy the master
database into the slave place and so on).
- Original Message -
From: "Jeff McKeon" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Monday, July 21, 2003 7:20 PM
Subject: Slave not working
> I had a po
I had a power failure on the master and it bounced rather ungracefully.
Now I'm getting this error on the slave and it's not replicating. Both
are ver 3.23
mysql> slave start;
Query OK, 0 rows affected (0.00 sec)
mysql> show slave status \G;
*** 1. row ***
Creigh Shank <[EMAIL PROTECTED]> wrote:
> It appears that an application I've been trying to run (RelataMail/Relata
> CRM) deletes the mysql.sock from my system. I'm running Redhat 8.0 with
> MySQL 4.0.13. Is there any way to restore the mysql.sock file (eg, from
> the rpm) without having to r
Hello,
About a week ago I created two databases on the master mysql engine while
the slave engine was off.
After that I tried to start the slave mysql engine and I received an error
message and in some seconds the slave service shuts down.
After I copied the database from the master database fold
It appears that an application I've been trying to run (RelataMail/Relata
CRM) deletes the mysql.sock from my system. I'm running Redhat 8.0 with
MySQL 4.0.13. Is there any way to restore the mysql.sock file (eg, from
the rpm) without having to rebuild the whole system? (Reinstalling MySQL
d
At 01:12 AM 7/20/2003, you wrote:
my table is small but I can't tell what is faster.. a max or a limit
mysql> select max(counter) from web;
mysql> select counter from web order by counter desc;
They seem to be the same in performance.
Regards,
Jake Johnson
[EMAIL PROTECTED]
Jake,
I tried
Bogdan TARU <[EMAIL PROTECTED]> wrote:
>
>Hi Martin,
>
> Hm. Don't really get it. Basically both mysqladmin and 'show variables'
> should read these variables from the mysql server, right? Why then would
> they give separate results?
mysql command-line client runs in interactive mode and
At 16:02 +0200 7/21/03, Edgar Kraus wrote:
Hello,
is there any detailed documentation out,
which explains the new character set feature in version 4.1,
where a specific character set can be used for tables and/or columns?
Thanks
Eddie Kraus
http://www.mysql.com/doc/en/Charset.html
--
Paul DuBois,
Hello,
is there any detailed documentation out,
which explains the new character set feature in version 4.1,
where a specific character set can be used for tables and/or columns?
Thanks
Eddie Kraus
Hi Martin,
Hm. Don't really get it. Basically both mysqladmin and 'show variables'
should read these variables from the mysql server, right? Why then would
they give separate results?
Thanks,
bogdan
On Mon, 21 Jul 2003, Martin Gainty wrote:
> mysqladmin has the capability to specif
mysqladmin has the capability to specify the my.ini file to read on startup
under " my.ini Setup "
hth,
Martin
- Original Message -
From: "Bogdan TARU" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 21, 2003 6:37 AM
Subject: set/show variables
>
> Hi everyone,
>
> I have
I would export the makefile
and try to include the MySQL library with the other libraries
nmake -f makefile
-Martin
- Original Message -
From: "Ron Ohmer" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 21, 2003 6:15 AM
Subject: MySQL++ & Visual Studio.Net
> Has anyone got
Hi everyone,
I have recently installed MySQL 4.0.13 on a freebsd box, and I have
stumbled into the following problem:
I have set the following in /etc/my.cnf:
set-variable= max_connections=100
set-variable= wait_timeout=60
(tried with and w/o 'set-variable ='). Then I restar
There might be an error in the code.
Some Tech books will have a website dedicated to any corrections of it's contents.
The site location might be mentioned in the intro or you can search the publisher's
web site for it.
> >
> > Ok so the mysql_send.php loads great. ( Apache 2 is the web
> > s
"Yves Goergen" <[EMAIL PROTECTED]> wrote:
> I'm wondering if I can set safe_show_database on my Windows 2000 MySQL 3.23.56-nt.
> Here's what I did:
>
> --- (c:\winnt\my.ini)
> [mysqld]
> set-variable = safe_show_database=1
> ---
>
> -> NT Service didn't want to (re)start anymore.
You should spec
Has anyone gotten this to compile, and if so can you point me in the right direction
of the library?
Thanks
I suppose datetime would be the better option here
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]
Sent: Friday, July 18, 2003 10:00 AM
To: [EMAIL PROTECTED]
Subject: Re: mysqlbinlog suggestion
"Luc Foisy" <[EMAIL PROTECTED]> wrote:
>
> allowing date range option
Depending on your version of windows you may have to type doskey at the
command prompt to turn on the doskey feature.
-Original Message-
From: Ray Thompson [mailto:[EMAIL PROTECTED]
Sent: Monday, July 21, 2003 7:47 AM
To: Neeraj Vasudeva; [EMAIL PROTECTED]
Subject: RE: doskey feature in my
Hmmm. Do F1 or F3 produce the last command given?
--
Ray Thompson
> >
> >I remember in WIN NT 4 if we type cmd at the run prompt, then
> >command prompt use to come up
> >and we can repeat the commands i.e. doskey feature is available.
> >
--
MySQL General Mailing List
For list archives: http:
Is it at all possible to group by and have it return all variables from
a single row based on a max() criteria of a single variable?
For instance in SPSS I can sort by id number descending then in an
aggregate have it say that newvar2=first(newvar) or last(newvar).??
Just a thought?? any ideas
unsuscribe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
#!/usr/bin/perl
use DBI;
my $database = "desired database";
my $dbhost = "desired database host";
my $username = "your username";
my $password = "your password";
my $data_source = "DBI:mysql:$database:$dbhost";
my $dbh = DBI->connect($data_source, $username, $password);
my $sourcefile = "the name
Download mysqlcc instead. It works much better and is easier to use.
mysqlgui is deprecated as far as i know.
Curtis
On Thursday 17 July 2003 18:08, Emanuele wrote:
> HI!
> I have problem to download
> http://www.mysql.com/Downloads/mysqlgui/mysqlgui-win32-static-1.7.5-2.zip
>
> Is there some
Hi,
I'll have the same problem, too, in some months...
What I was thinking about is to create a cron job that runs say every hour and
calculates each user's database size. Comparing it with a stored per-user value, the
script (running as kind of a mysql superuser) REVOKEs or re-GRANTs UPDATE and
"PaT!" <[EMAIL PROTECTED]> wrote:
>
> I need a hint how to use myisamchk
>
> I use this syntax in a shell but it doesn't work
>
> myisamchk -R=ID \mysql\data\db\mytable.myi
>
> ID is the index name I want to use to sort the table
>
> I'm using mysql 4.0.13 on Win 2K server
myisamchk -Rindex_
"Tom Roos" <[EMAIL PROTECTED]> wrote:
>
> does this option only apply when the mysqld starts up or each time a table is opened
> for read/write?
On open.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
Naoufal Rih <[EMAIL PROTECTED]> wrote:
> Hi
> I have 3 machines M1 M2 and M3, i need to setup the following :
> M1 is the master
> M2 is reading from M1
> M2 is a master for M3
> M3 is reading from M2
> The problem i got, is when i run a command in M2, it's replicated in M3,
> but when the command
Hi
I have 3 machines M1 M2 and M3, i need to setup the following :
M1 is the master
M2 is reading from M1
M2 is a master for M3
M3 is reading from M2
The problem i got, is when i run a command in M2, it's replicated in M3,
but when the command is being run in M1, it's replicated in M2 but not in
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Sunday 20 July 2003 22:59, Tanamon wrote:
> ++---+--+
>
> | id | file_name | max(version) |
>
> ++---+--+
>
> | 6 | ffour |2 |
> | 1 | fone |3 |
> | 5 | fthree|
Hello,
I am using a threaded C program and each thread creates its own
connection to mysql database using mysql_init(). When I run Valgrind on
the program it reports that there has been a small leak stemming from
several mysql_init and one mysql_real_connect. I have read
http://www.mysql.com/doc/e
harsh <[EMAIL PROTECTED]> wrote:
>
> Hi all,
> How do i do this ?
> i have a table with one of the column named uid,
> Now i want to insert a new row,only if no other
> row exist with the uid i m trying to insert.
> I hope its clear.
Define column as a PRIMARY or UNIQUE key and use INSERT IGNORE:
Michael Satterwhite <[EMAIL PROTECTED]> wrote:
>
> I'm trying to add a foreign key to a table. All tables are INNODB. Table a has
> following partial Definition:
>
> TableA
> ( Fld1 int Primary Key,...
> )
>
> TableB
> (Fld2 int Primary Key,
> Fld1 int not null, ...
> )
>
> I use the following
[EMAIL PROTECTED] wrote:
>
> I was reading the manual and it said that the subselect is only
> available in 4.1 or using the 4.0.12 with the mysqld ?new command line
> to start it.
>
> But it doesn?t working!! So I downloaded the 4.1 alpha version with the
> same problem. The error is:
>
> ERROR
Hi,
I've set up a ODBC DSN to connect to Mysql. This DSN works fine with MS Excel.
However, it returned the following error when I tried to link some Mysql tables from
Access 2000:
ODBC--call failed.
[MySQL][ODBC 3.51 Driver][mysql-4.0.4-beta-max-nt]Access denied for user: '@' to database 'trad
Hello,
On Sun, 2003-07-20 at 14:59, Stefan Hinz wrote:
> Matthew,
>
> > Hi, I'm clear as to what is meant by "The mysql client" in the MySQL core
> > certification revision check list. I understand that the mysql database
> > itself is the "server". Would client then be any program that talks to
hi listers
does this option only apply when the mysqld starts up or each time a table is opened
for read/write?
thanks
_ ___ _ __
/______/ / ___/ / \ //
/ / / // / / ^ v /
/ / / /__/ / / / \/ / /
Thanks Michale. The problem is solved.:)
Michael Satterwhite <[EMAIL PROTECTED]> wrote:
>-BEGIN PGP SIGNED MESSAGE-
>Hash: SHA1
>
>On Sunday 20 July 2003 14:18, Veysel Harun Sahin wrote:
>> Hello,
>>
>> I have to join two columns from different tables in a query. Assume that
>> I have two
74 matches
Mail list logo
