>Description:
Whenever I try to start up the daemon it gives a
'Segmentation fault '
message and shuts down.
>How-To-Repeat:
Just try to start the daemon up
>Fix:
?
>Submitter-Id: [EMAIL PROTECTED]
>Originator: [EMAIL PROTECTED]
>Organizatio
On Fri, Mar 22, 2002 at 04:37:07PM +, ds wrote:
> Hi, did you get any answer ?
> I'm having the same problem.
>
> If i wanted all results from table1, even if they don't appear in table2
> i would do like:
>
> SELECT . FROM table1 LEFT JOIN table2 ON (table1.id=table2.id) ...
>
> But h
--- [EMAIL PROTECTED] wrote:
> Your message cannot be posted because it appears to
> be either spam or
> simply off topic to our filter. To bypass the filter
> you must include
> one of the following words in your message:
>
> sql,query
>
> If you just reply to this message, and include the
> e
I'm coming up empty on this one and it should be quite simple. Maybe
because it's Friday??
I have 2 tables, Dept and Employee. I want to count the # of employees in
each dept and store it in the corresponding Dept row.
To do the tally it is simply creating a temporary table:
drop table if exis
mysql
Brian,
Fine...lots of typing.:)
I'm looking for a function that will take a string or char* of 256bit
ascii (or other stuff) and convert it into something that can be
inserted into a varchar type in mysql. Then when the data gets pulled
out it would be converted back. I know I need to convert quotes and
some control characters
Hi,
sorry to bother you with this, but one thing one might look into is:
When table was dumped with --extended-insert option, that the server importing
the table does NOT perform well. In the output from `vmstat 1` each
second there's a lot of I/O, and at least on linux 2.4.19-pre1 it runs more
Egor:
Yes, im sure that the host.xxx tables are in the directory I specified to
the mysql_install_db script.
One thing to note..
This is a software package for my distro... I did not compile from source so
I dont know what options were used in the compile process.
It may be that the server i
This *might* make your updates a bit faster. I don't think MySQL optimizes
updates this way (it would be nice if it did.)
Depending on your data it may be possible to eliminate updating some of the
rows if the row already has the new value. As strange as this seems,
something as simple as:
upd
Below is a table declaration in a database I just created. The oddity is the
2 fields, CL_FIRST_TS and CL_LAST_TS, are automatically marked as "Required"
in the table's "Validity Checks" listing. This means that I have to add a
value to both of them each time I insert a new record. They are involv
In the last episode (Mar 22), Ozette Brown said:
> Dan,
>
> I guess I'm not hitting my systems openfile limit because I do not see "file table
>full"
> in my /var/log/messages.
> Here's the other info you inquired about:
>
> m1# sysctl kern.maxfiles kern.maxfilesperproc kern.openfiles
> kern.ma
I am not sure what the heck the problem is. I'm trying to install mysql
(client) on a RH 7.2 box. When I run ./configure --without-server I get
a bunch of messages about mysql passwords being changed and mysql daemon
being started with databases from /install directory -- sorry I can't
inclu
On Thu, Mar 21, 2002 at 08:13:16PM -0500, alan4100 wrote:
> mysql
>
> Hi Colin,
>
> I wish I can be able to live chat with you, but because of my hearing impaired...it
>would not be possible..But what is the real problem? A few days ago I got assistance
> from others on my Mysql problem. It
I am not sure what the heck the problem is. I'm trying to install mysql
(client) on a RH 7.2 box. When I run ./configure --without-server I get
a bunch of messages about mysql passwords being changed and mysql daemon
being started -- sorry I can't include the exact messages but I have no
way
After much stress, I finally found the answer to my problem. Here is the
error message that I was getting:
020322 11:54:29 Slave: Failed reading log event, reconnecting to retry, log
'bend149-bin.002' position 2407727
020322 11:54:29 Slave: reconnected to master
'[EMAIL PROTECTED]:3306',replic
You have to tell it to use gcc. It doesn't look like you're following the
directions for compiling on HP-UX. See
http://www.mysql.com/doc/H/P/HP-UX_10.20.html
or
http://www.mysql.com/doc/H/P/HP-UX_11.x.html
If you need help after that, specify your version of HP-UX, version of
MySQL, ve
Your client won't drop Access in favor of a faster, more secure database
like mySQL? Why is your client stuck on Access? The data can be dumped
and make the GUI web based to look just like the Access one... Stick in
on a Intranet server, and lock it down... I would rather have that than
a slow,
Chuck -
I am looking for a way for both MS access and MySQL to share realtime
data so that if someone where to insert (through a web based admin)
or update table in a MySQL db you could open your Access db and see
the same data. I don't know if it is possible but that way there
wouldn't be an
Dan Nelson wrote:
> In the last episode (Mar 22), Ozette Brown said:
> > Andrey,
> >
> > Thank you for the reply.
> >
> > I read somewhere that when checking your maximum file descriptors your
>"kern.maxfiles
> > should be greater than kern.maxfilesperproc. My settings are:
> > kern.maxfiles =
Sir/Madam
I installed the binary version of (MySQL)
mysql-3.23.49a-pc-linux-gnu-i686.tar.gz.
The steps followed to install are:
tar xvzf mysql-3.23.49a-pc-linux-gnu-i686.tar.gz.
cd mysql-3.23.49a-pc-linux-gnu-i686
./configure
scripts/mysql_install_db
cp support-files/my_medium.cnf/etc/my.cnf
You have written the following:
Hi!
I am running Apache on Linux and MySql database is running
on a windows200 server.
Is there a way to connect to that database using the IP address ?
Thanks for your help!
Paul
-
Before pos
I am still a new to mysql. What is the syntax for backing up a table and how
do I make it no-lock while doing so. I need the tables to still be able to
be written to. I know that this will make my backup a little unaccurate but
that doesnt really matter...
Kathy Reyes
Live Technology Internationa
There are other windows front ends to mysql, but this one is the best:
http://ems-hitech.com/mymanager/
Are you sure the server allows remote connections?
Ken
Charles McGrotty wrote:
>
> Hi,
>
> Can someone tell me how to configure the MySQL ODBC (v3.51) Driver so I
> can connect to a remote M
On Fri, 22 Mar 2002, TAKAHASHI, Tomohiro wrote:
> Hi, Lonnie
>
> Lonnie Wormley wrote:
> >
> > TAKAHASHI, Tomohiro wrote:
> >
> > >
> > > Do you want to use mm mysql Driver with JB6's DataPilot?
> > > What kind of error does DataPilot say?
> > >
> > Here is the stack trace:
> >
> > See com.bo
In the last episode (Mar 22), Ozette Brown said:
> Andrey,
>
> Thank you for the reply.
>
> I read somewhere that when checking your maximum file descriptors your "kern.maxfiles
> should be greater than kern.maxfilesperproc. My settings are:
> kern.maxfiles = 8232
> kern.maxfilesperproc = 8232
Andrey Kotrekhov wrote:
> äÏÂÒÙÊ ÄÅÎØ.
>
> I have the same problem.
> We increase max number of users in the kernel config and recompile.
> The problem is solve at most.
> Try to increase max number of open files in kernel.
>
> > Hi,
> >
> > I'm currently running FreeBSD 4.3-stable with MySQL 3.2
try:
http://www.justunixjobs.com
http://www.dice.com
-amen
PS> If you know php, you can learn asp easy.
On Fri, 22 Mar 2002, Jonathan Hilgeman wrote:
> I'm currently working as a e-commerce web programmer specializing in PHP,
> MySQL, and Apache systems. I've had experience on FreeBSD and L
Rance,
Friday, March 22, 2002, 4:53:41 PM, you wrote:
RH> here goes (not that it will give you any better information than I did
RH> already but since you asked...)
RH> <<>>
RH> 020318 14:30:48 mysqld started
RH> 020318 14:30:49 /usr/libexec/mysqld: Table 'mysql.host' doesn't exist
RH> 02
äÏÂÒÙÊ ÄÅÎØ.
I have the same problem.
We increase max number of users in the kernel config and recompile.
The problem is solve at most.
Try to increase max number of open files in kernel.
> Hi,
>
> I'm currently running FreeBSD 4.3-stable with MySQL 3.23.39. My problem
> is weird an unpreditab
Hi,
Can someone tell me how to configure the MySQL ODBC (v3.51) Driver so I
can connect to a remote MySQL database.
I have tried putting an IP address in that I found by lookup of the
domain name, and I entered the database name and password, but I get an
error saying connection from ~db_name~@~
This happened on our server, and we had to reload the grant table
(mysqladmin reload). Also, the mysql directories were owned by root so
we had to chown them to the mysql user.
I hope that helps,
Martin
Kuntrynet Office wrote:
>
> I recently installed MySQL version 3.23.22 on a Linux server.
you can create my.cnf file with the contents
[mysqld]
socket=/var/lib/mysql/mysql.sock
and put it in path. In case you need to know where the my.cnf file should
be put, execute:
mysqld --help | grep my.cnf
or with your command line mysql binary do
mysql -uusername -p -S=/tmp/mysql.sock
--
Hi,
I'm currently running FreeBSD 4.3-stable with MySQL 3.23.39. My problem
is weird an unpreditable. I have a database driven website which has
several hundred visitors per day. After viewing my logs on a daily
basis, I see a "Unknown database" error appear from time to time. Now,
I also have
I recently installed MySQL version 3.23.22 on a Linux server. It used to run
fine. The problem is when I run a php query on a database it returns the
error "Cannot connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111) " Hmm. My mysql.sock file is located in
/tmp/mysql.sock
Well I was able to fix the problem by doing a Select into Outfile and
specifying in my select list and using IF...
thanks
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "David M. Peak" <[EMAIL PROTECTED]>; "MySQL List"
<[EMAIL PROTECTED]>
Sent: Thursday, March 21, 20
Am Freitag, 22. März 2002 11:58 schrieben Sie:
> > Egor:
> > Thanks for the hint. I browsed the manual for readline(3) and for
> > /etc/inputrc, but found nothing wrong with it. I can enter umlauts in all
> > other programs and from the bash command-line - only in mysql they don't
> > work. Where
Ok this works on myisam tables, but what about InnoDB
On Fri, 22 Mar 2002, Egor Egorov wrote:
> Date: Fri, 22 Mar 2002 15:38:03 +0200
> From: Egor Egorov <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: Optimizing tables
>
> Vijay,
> Friday, March 22, 2002, 1:14:33 PM, you wrote:
>
> V>
Hi,
is there any way to debug a c-programm that uses the mysql c-api? I want
to use checker for memleak checking but it seems to be impossible to
compile the mysql client libraries using checker. The reason seems to be
some assembly language parts. All other libraries I need compile.
Did anybody
I'm doing something similar, with an Access front-end and mysql
back-end.
> -Original Message-
> From: Mark Stringham [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 22, 2002 3:11 AM
> To: MySQL
> Subject: MySQL, MyODBC and MS Access
>
>
>
> I have a project where I may need to connect a
Hi,
We just moved our operation to a new hosting company, and in the
process went from an old version of Slackware linux running MySQL
3.22.xx to systems running RedHat 7.1 and MySQL 3.23.37.
When I do a large LOAD DATA INFILE or something else that puts a
tidbit of strain on the database, al
hello mark,
been doing this quite a bit recently but i cheat a bit...
1st step is to export the table from access as a text file - delimited by
comma's.
if you load up phpMyAdmin (available at
http://www.phpwizard.net/projects/phpMyAdmin/), create your database and
then mimic the table set up f
Hi Sinisa!
>Thank you for your bug report.
Thank /you/ for MySQL (:
tam
--
eCS 1.00, Ducati 750SS '92 up and running
http://tam.belchenstuermer.de/
-
Before posting, please check:
http://www.mysql.com/manual.php (the manu
Hi, did you get any answer ?
I'm having the same problem.
If i wanted all results from table1, even if they don't appear in table2
i would do like:
SELECT . FROM table1 LEFT JOIN table2 ON (table1.id=table2.id) ...
But how to join
SELECT . FROM table1 LEFT JOIN table2 ON (table1.id=t
I'm currently working as a e-commerce web programmer specializing in PHP,
MySQL, and Apache systems. I've had experience on FreeBSD and Linux systems,
and now the company I work for seems to be being "bought out" at which
point, several of us may lose our jobs. Now, I've been searching all over
Mo
At 05:53 AM 3/22/2002, you wrote:
>Hi, I'm using a db with few tables, one of which is reported below:
>
> CREATE TABLE `keywords` (
> `keyword` varchar(128) NOT NULL default '',
> `codice` varchar(16) NOT NULL default '',
> `timestamp` int(11) NOT NULL default '0',
> `soundekw` varchar
I don't understand your question
-Original Message-
From: Sukhdev Sethi [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 22, 2002 7:20 AM
To: [EMAIL PROTECTED]
Subject: querying check constraints
Hi,
I have created a table as below:
create table myTable
(
Field1 int auto_increment no
On Thu, 2002-03-21 at 13:07, Shawn McCool wrote:
> /usr/local/bin/mysql -hhostname -uusername -ppassword -e "flush logs;"
I guess I wasn't clear that I wanted old binary logs removed. I don't
want to have to manually worry about disk space due to ever increasing
binary logs.
It seems to me FLUS
I know I'm new to this and despite checking FAQs and the manual, am having
difficulties getting MySQL to work properly under Windows 95. Unfortunately,
I don't have a choice of operating system, even though I'm developing for
Windows NT/2000.
Anyway I have started the server with mysqld, a fact t
On 21 Mar 2002, at 12:11, David M. Peak wrote:
> Is there a way to tell MySQL to put a blank space instead of \N in the
> tab-delimited files when it does a dump? I'm working on a MySQL to SQL
> Server migration and having problems with the output files.
If you don't care about the distinction
We have a problem with other system..
When a service that uses the MySQL database loops and so creates to many
connects to the DB it uses up all the available connections. So we have DOS
from aware own server.
I know that we can limit the connections used over 1 hour but I need to set
a max co
Ok Egor,
here goes (not that it will give you any better information than I did
already but since you asked...)
<<>>
020318 14:30:48 mysqld started
020318 14:30:49 /usr/libexec/mysqld: Table 'mysql.host' doesn't exist
020318 14:30:49 mysqld ended
<<>>
because I have about 18 similar b
There might be a better way but here's a suggestion:
When I needed to switch from an Access db to mysql I couldn't find any
docs about exporting the table structures from Access to mysql, so I
documented the Access db and manually built the same table structures in
mysql. Then export the Access
I have a problem with compiling mysql on HP-UX.
I can't compile because it doesn't know that I have gcc. I have this
error with ./configure :
checking for gcc... cc
checking whether the C compiler (cc -Ae -D_REENTRANT ) works... yes
checking whether the C compiler (cc -Ae -D_REENTRANT ) is a
c
Using "select Url from table where Ref like 'foo'" gives these results:
1 row in set (2 min 11.54 sec)
Using "select Url from table where Ref = 'foo'" gives these results:
1 row in set (8 min 47.69 sec)
The same "foo" was used for each one of those queries.
I believe the time pr
Hi me again , regarding my situation i was able to get a responce via
>mysql > \r library(eexample db) localhost
thus used the select cmd select * from members; and everthings fine .
From the manual it does mention that certian installations allow user
to connect as anonymous unamed user to
* Chuck Amadi
> Nevertheless i have been ok so far upto now! The problem is that when i
> try to run mysql server i get the following error
> ERROR 2005: Unknown MySql Server Host 'host' (11001).
>
> Setup - Mysql v3 O/S Win 98 utilising the mysqladmin & mysqlManager
>
> I have tried from ms-dos
* [EMAIL PROTECTED]
> I encountered a problem with my pictures-DB which I with PHP.
> The table's stops at row 126, all photos I store in DB afterwards all get
> the ID 127.
>
> I don't know if it's php or MySQL causing this.
>
> My table structure is
> field typeAllow Nulls
í¼ø¹Î,
Friday, March 22, 2002, 8:48:56 AM, you wrote:
> I've set backlog of mysql to 100. And now I need to increase it.
> But I don't know how many backlog my OS can support.
> Where can I get that information and how can improve it.
> Although I use Red Hat 7.2, other OS's informations are also
Art,
Friday, March 22, 2002, 7:10:24 AM, you wrote:
AL> I ran into the same problem you did. After some searching on the web, this
AL> is what I came up with:
AL> First save the text file in the directory corresponding to the database you
AL> are currently using (menagerie). So the file will b
Vijay,
Friday, March 22, 2002, 1:14:33 PM, you wrote:
V> how do i optimize mysql tables
I think chapter 4.4.6.10 Table Optimization in
MySQL manual will be useful for you. Look at:
http://www.mysql.com/doc/O/p/Optimisation.html
V> vijay
--
For technical support contracts, goto htt
Rance,
Thursday, March 21, 2002, 9:30:26 PM, you wrote:
RH> I issued the chown command as indicated by Andreas
RH> but it doesnt help
RH> I still get the "Table mysql.hosts doesnt exist"
RH> I know that all the tables created by mysql_install_db are infact owned by
RH> mysql
RH> but the server d
Aragon,
Thursday, March 21, 2002, 10:35:06 PM, you wrote:
AA> I have compiled mysql-3.23.49 from source distribution on a NetBSD
AA> 1.5.2 (sparc) box. Everything compiled fine, no-errors. Installed fine,
AA> no-errors. Starts and Stops fine no-errors. But when I go to run mysql or
AA> my
Vijay,
Friday, March 22, 2002, 1:00:24 PM, you wrote:
V> I have to delete the unwanted things from my mysql db
Use DELETE statement. You can find description of it in the manual:
http://www.mysql.com/doc/D/E/DELETE.html
V> thanks
V> vijayt
--
For technical support contracts, goto
Kathy,
Thursday, March 21, 2002, 7:48:10 PM, you wrote:
KR> I just gave up, everything that I tried did not work.
KR> I killed mysql and then
KR> started with safe_mysql --skip-grant-tables
KR> then I was able to connect to mysql without an error.
KR> But when I tried to
KR> Grant all on mys
Hi there, I have gone thru the pdf doc's etc and i have been playiing
around with devshed articles as well as being a db programmer using
PostgreSql v7 on my Linux Box and that horrible thingy called M$ Access
2000 ( The non-cocurrent issue) on my Win98 Box.
Nevertheless i have been ok so far
On Friday, 22. March 2002 14:04, [EMAIL PROTECTED] wrote:
Hello,
> I encountered a problem with my pictures-DB which I with PHP.
> The table's stops at row 126, all photos I store in DB afterwards all get
> the ID 127.
>
> I don't know if it's php or MySQL causing this.
>
> My table structure is
Hi,
I have created a table as below:
create table myTable
(
Field1 int auto_increment not null,
Field2 varchar(25) not null,
Field2 enum('Fair','Good','Excellent'),
primary key (Field1))
auto_increment=1
I would like to know how to query the table for only
the enum values I have
Thank you for your bug report.
This bug is now fixed in 3.23.50, which will very soon be available.
This is a patch that fixes a bug :
--- 1.12/sql/item.ccWed May 23 02:32:52 2001
+++ 1.13/sql/item.ccFri Mar 22 14:03:42 2002
@@ -59,12 +59,28 @@
}
}
-bool Item::eq(const Item
Hi,
I'm new to DB's and MySQL
I encountered a problem with my pictures-DB which I with PHP.
The table's stops at row 126, all photos I store in DB afterwards all get
the ID 127.
I don't know if it's php or MySQL causing this.
My table structure is
field typeAllow Null
* Mickael Bailly
> I got a table having an auto_increment field, let's say 'id'.
> tis table has a varchar field too, let's say 'name'.
>
> Is there a way to do something like:
>
> select id, name from table where id in (5,3,7)
>
> AND that mysql orders the results the way I gave into the
>
Hi, Lonnie
Lonnie Wormley wrote:
>
> TAKAHASHI, Tomohiro wrote:
>
> >
> > Do you want to use mm mysql Driver with JB6's DataPilot?
> > What kind of error does DataPilot say?
> >
> Here is the stack trace:
>
> See com.borland.dx.dataset.DataSetException error code: BASE+82
> com.borland.dx.d
[EMAIL PROTECTED] writes:
> >Description:
>
> Take two tables (call them a and b), which have identical structures. Table a
> has no rows, table b has some (say 10) rows. If you do this:
>
> select * from a union select * from b limit 0,5
>
> It works as expected. Now do this:
>
> select *
--- Kathy Reyes <[EMAIL PROTECTED]> wrote:
> Now I have a different problem. When I type mysql it
> gives me the message
> Access denied for user: 'root@localhost' (Using
> password: NO)
> how do I get it to use the password.
> When I type mysql -u root -p
> I get in...
^
What do you mea
Hi,
I am using Mysql version 3.23.47-Max client and server and using Innodb
table type.
I am doing my database backup using the mysqldump utility.
Once I have done with database backup, I am deleting all my database and
again recovering(creating) the database using the dumped file.
Now, the ques
Hi, I'm using a db with few tables, one of which is reported below:
CREATE TABLE `keywords` (
`keyword` varchar(128) NOT NULL default '',
`codice` varchar(16) NOT NULL default '',
`timestamp` int(11) NOT NULL default '0',
`soundekw` varchar(32) NOT NULL default '',
PRIMARY KEY (`key
Hi,
What about taking a look at the manuel before ? ;)
http://www.mysql.com/doc/
Regards,
Jocelyn Fournier
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, March 22, 2002 12:14 PM
Subject: Optimizing tables
>
>
Hi again,
Little more information about the problem that I wrote about in my last
email.
As I said before, the database wont accept any query to that table. It just
hangs. However I'm not sure of which query that is executed the first time
the table hangs. I'm not sure if this matters. But i
Placed At : MAA
Vijay T@SATYAM
03/22/2002 04:44 PM
Hi
how do i optimize mysql tables
vijay
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hi all,
I have a problem with a table in the database. I created it a while ago (a
month maby) and then everything worked fine. Now however, every time I query
the table the query hangs and I don't know why. I understand that it's
difficult to tell me what the problem is based on that little i
Hello,
the 'order by' clause just order my results by ascending value, but don't keep
the order I gave in the 'IN(...)' clause..
So it doesn't solve my problem.
Mickael
On Friday 22 March 2002 12:08, Jayasimhan A wrote:
> Try "order by id".
> All the best,
> Jayasimhan A
> - Original Me
Hello,
there is no difference between
select id, name from table where id in (5,3,7)
and
select id,name from table where find_in_set (id, "5,3,7");
Or I didn't see it... anyway this doesn't solve my problem.
Mickael
On Friday 22 March 2002 11:32, Georg Richter wrote:
> On Friday, 22. March 2
Placed At : MAA
Vijay T@SATYAM
03/22/2002 04:30 PM
Hi
I have to delete the unwanted things from my mysql db
pls sugges me to go ahead
thanks
vijayt
-
Before posting, pl
Try "order by id".
All the best,
Jayasimhan A
- Original Message -
From: Mickael Bailly <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, March 22, 2002 3:13 PM
Subject: keeping given order in resulset
>
> Hello !
>
> I got a table having an auto_increment field, let's say 'id'.
Hi,
I know, many fulltext bugs fixed last two weeks, thanks!
But this nice mysql4 feature are critical for us, we plan to use it in many
projects... and we test it again and again... :)
My test case:
http://www.graphit.ru/fulltext402.tar.gz
test.res - output from 4.0.2 cloned 2002-03-21.
With
Hi!!
You can try
select format_date(field2, '%m %d %Y)as timestamp, count(*), field1 from mad
group by field1
all the best,
Jayasimhan A
- Original Message -
From: cristian ditoiu <[EMAIL PROTECTED]>
To: mysql <[EMAIL PROTECTED]>
Sent: Friday, March 22, 2002 1:20 PM
Subject: group by time
On Friday, 22. March 2002 10:43, Mickael Bailly wrote:
> Hello !
>
> I got a table having an auto_increment field, let's say 'id'. tis table
> has a varchar field too, let's say 'name'.
>
> Is there a way to do something like:
>
> select id, name from table where id in (5,3,7)
>
> AND that mysql
Hello !
I got a table having an auto_increment field, let's say 'id'. tis table has a
varchar field too, let's say 'name'.
Is there a way to do something like:
select id, name from table where id in (5,3,7)
AND that mysql orders the results the way I gave into the 'IN(...)' clause ?
Hi, all:
I am doing a project that we will insert a lot of data to mysql by C API
everyday, so the table files will become bigger and bigger, it will not only
takea long time to query,but also lead to the file size limits.
In order to query fast and avoid leading to the file size limits, I
We have a problem with other system..
When a service that uses the MySQL database loops and so creates to many
connects to the DB it uses up all the available connections. So we have DOS
from aware own server.
I know that we can limit the connections used over 1 hour but I need to set
a max co
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
> sql,query
> If you just reply to this message, and include the entire text of it in the
> reply, your re
MySQL every so often will return "unknown database" errors for no apparent
reason on a FreeBSD 4.4 (and earlier 4.x versions) server I maintain.
This affects different user, scripts, and databases. One user says there
is a big slowdown around each event, perhaps a load issue, but at least
when
TAKAHASHI, Tomohiro wrote:
>
> Do you want to use mm mysql Driver with JB6's DataPilot?
> What kind of error does DataPilot say?
>
Here is the stack trace:
See com.borland.dx.dataset.DataSetException error code: BASE+82
com.borland.dx.dataset.DataSetException: The driver:
org.git.mm.mysql.Drive
92 matches
Mail list logo
