 | | | MySQL General | | Michael
Add this to you 're my.cnf and then restart mysql. See if that solves your
problem.
open-files-limit 36864
Donny
> -----Original Message-----
> From Michael Bacarella [mailto mbaI am running mysql version 3.23.49 on a Debian Linux box.
Recently (about a month ago) I noticed that alot of my databse access
scripts were failing intermitently. It was anoying but I have onlyandres@(protected) wrote
> Hi
>
> I need to prevent users from holding down the server issuing the next
> query the server becomes so slow that the other clients can 't even login!
> tHi
I am construction a Full Text Search engine replacing the internal MySQL
engine in an experiment for index all the content of neswspaper 's 20 years
of publications and the first layer to doMark Swanson <mark@(protected) > wrote
>
> I am having replication troubles with 4.0.15. Some info
>
> mysql > show slave status
> | www.x.com | replicon | 3306 | 60 Does this number indicate the current number of connections or the max
number of connections during the current uptime?
We have this number max set to 200 from the default 100
how does this numHi
I have a few questions concerning stored procedures
1. If I create a stored procedure (like the one below) why does the
returned values not change though in the stored prcoedure the id hHi
I have a table that looks like
mysql > desc test
+-----------+Jon Thingvold <jonth@(protected) > wrote
> >Description
> >From error.log
>
> 040308 9 34 00 InnoDB Assertion failure in thread 13835301 in file row0upd.c line 713
> InnoDB Failing assertionupdate gci_copy dis set
gci_copy.products_description concat_ws( ' <br > ' gci_copy.products_description dis.products_model dis.products_description)
where gci_copy.products_image dis.products_image
That depends on your nationality. Two children born in the same year
are commonly called Irish twins. But that 's even more off topic.
On Mar 8 2004 at 5 59 AM Jigal van Hemert wrote
> - ItJustin Camp wrote
> Greetings!
>
> I 'm having a bit of a problem compiling mysql that I 've been chewing
> on for more than a week now..
>
> I 'd preferably like to use the pre-built binarHans Sved?ker wrote
> Hi
>
> I have a problem with replication and "replace delayed " statements. They
> generate this error on the slave machine a couple of times every night
> (When there arDean
It is the number of concurrent connections
They disappear either when they are closed by the application which has
opened them or when wait_timeout expires for inactive connections
TheI have been experiencing a small problem with altering a table once it
has been locked. If you alter a table (adding a column) while that table
is locked subsequent calls to that table result in Greetings All
As promised a few weeks ago (but only delivered today) MySQL is
offering a $100 discount on the MySQL 2004 User Conference conference
fee for attendees who contribute to the Fre
If your infact (sounds like) storing the pictures meta-data (name size
owner etc) and the data (blob of some kind) .. I would definately break
up the design into 2 tables. That way when dealinThree solutions to this problem including the one here are discussed
in the manual
<http //www.mysql.com/doc/en/example-Maximum-column-group-row.html >
Michael
Darran Kartaschew wrote
At 21 55 -0300 3/7/04 Volnei Galbino wrote
>Hi
>
>Does anybody know where I can find information about "query
>optimization " in MySQL? Of which the techniques that are used?
>
>Regards
>
>I 'm trying to understand whether setting up a MySQL cluster running on
Windows 2000/2003 is possible.
I am not a cluster expert actually I have only read the MS white papers
about it and done socheck this thread - lots of links for more info.
http //lists.mysql.com/mysql/157588
olinux
--- Richard Carlier wrote
> Hi !
>
> There is any way to have hierarchical list with
> MysWalt
You can also use VB with MySQL without problems. There are several
connectors available at the MySQL site
Freddie
-----Urspr?ngliche Nachricht-----
Von Walt [mailto wkolb@(protected)You shouldn 't have any problems using VB to write software with MySQL.
-----Original Message-----
From Walt [mailto wkolb@(protected)]
Sent Sunday March 07 2004 11 01 AM
To mysql@(protected)Andre
----- Original Message -----
From <andrebras@(protected) >
Newsgroups mailing.database.myodbc
Sent Sunday March 07 2004 3 28 PM
Subject transactions
> Hello there.
>
> i 'm workiAt 20 13 +0700 3/7/04 neal wrote
>I would like to do something like
>Create table xyz as show fields from test.abc
>
>Or maybe
>
>Select Field from (show fields from test.abc)
>
>Is this pHi all
We are about to upgrade one of our database servers to a Dual Xeon machine
with HT. We have been testing FreeBSD 5.x for 6-7 months on a Uniprocessor
box and we haven 't had any problems wCliff
----- Original Message -----
From " "Cliff " " <cliff@(protected) >
Newsgroups mailing.database.myodbc
Sent Saturday March 13 2004 11 32 PM
Subject Re InnoDB tables using 90% cpSELECT DISTINCT sensor_id other_fields FROM table_name
ORDER BY time_stamp_field DESC LIMIT 40
Not sure if that will work but does it point you in the right direction?
j----- k-----
On SatThis one time at band camp Kevin Waterson <kevin@(protected) > wrote
> seasonDateFrom seasonDateTo seasonRateWeekly
> 2004-06-02 00 00 00 2004-10-31 00 00 00 42.86
>At 12 57 +1100 3/7/04 Mark Beauman wrote
>I have 15 tables all with the same column names (but different
>values) where i want to SELECT all rows over all tables but not to
>JOIN. Is there a w |
|
|
