Hello everyone,
I'm using MySQL Enterprise Monitor 3.0.5. Is there any possibility to
customize the dashboard, eg. one database activity graph for every
instance?
Does anyone know it?
Best Regards
Christian Molecki
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/
Hi,
thanks for the hint, I was testing the settings for the
myisam_sort_buffer_size so I totally forgot it.
But I have another three of these databases to do, so next time I do it
with one ALTER statement
Christian
Am 21.06.2012 16:50, schrieb mos:
At 02:04 AM 6/21/2012, you wrote:
Thank
where PARTITION shines. (I have not seen such [yet] in your application.)
-Original Message-
From: Christian Koetteritzsch [mailto:ckoetteritz...@e-humanities.net]
Sent: Wednesday, June 20, 2012 1:42 PM
To: Rick James
Cc: Ananda Kumar; mysql@lists.mysql.com
Subject: Re: Indexing about 40
sorry I forget the ORDER BY in the SELECT statement so the correct
SELECT statement is:
SELECT ruid1, ruid2, overlap FROM l4_link WHERE ruid1=xxx OR ruid2=xxx
ORDER BY overlap DESC
Am 20.06.2012 22:42, schrieb Christian Koetteritzsch:
Thanks for the information. It is no problem if it takes
in common.
I hope the informations I gave you are helpful. If you have more
questions than you can ask them.
Kind regards
Christian
-Original Message-
From: Ananda Kumar [mailto:anan...@gmail.com]
Sent: Wednesday, June 20, 2012 4:37 AM
To: Christian Koetteritzsch
Cc:mysql@lists.mysql.
x_sort_file_size", but this didn't work.
It still says "repair with keycache" after it copied the data to the
temp dir.
I hope you have any idea how to fix this.
Thanks in advance.
Christian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
the meaning of Warning: mysql_fetch_array(): supplied argument is not a valid
MySQL result resource in C:\Program Files\EasyPHP 2.0b1\www\memo3\index.php on
line 64
Hi i am on to create a database with a lot of entries.
each user may have Records like:
data1 (textfield)
data2 (textfield)
data3 (char [300])
and more like that
Now I am thinking about what is better
a:
to create for each field an own Table
like: table_user_data1 (records: userid,
Thanks.
Yes it's a delicate construct but tables like 'IP2Location' give me a
headache as NDB tables.
Yet I have to test if 7.0.X can handle it.
-Original Message-
From: Michael Dykman [mailto:mdyk...@gmail.com]
Sent: Mittwoch, 14. Oktober 2009 17:33
To: Christian Meis
Hi guys.
Ok lets say i've 2 server running MySQL, NDB node and NDB manager on each.
Now I don't want to convert all tables to NDB instead I leave a few as
MyISAM.
Is it officially supported if I setup a master-master replication between
the two MySQL instances and add ignore entries for all NDB ta
ah sorry... there are a few UPDATEs too but most is SELECTs...
60:40 i would say.
> Excuse me. But why concurrent queries request table locks?
>
> 2009/4/20 living liquid | Christian Meisinger
>
>> Hi there.
>>
>> I've a small table with my daily banner
Hi there.
I've a small table with my daily banner hits.
1. version was with myisam but with a lot of concurrent queries (all SELECTs) i
get too many table locks.
so i changed it to an innodb table.
works great most of the time.
sometimes it seems to be too much, starting at about 500 concurrent
2009/3/29 Oscar :
> Hi all-
>
> I want to know what the difference between IN and OR is under the hood.
>
> select * from dummy_table where id in (2, 3, 4, 5, 6, 7);
>
> select * from dummy_table where id=2 or id=3 or id=4 or id=5 or id=6 or
> id=7;
I've have thought once the query is compiled, th
2008/10/31 Moon's Father <[EMAIL PROTECTED]>
> *A prepared statement is also global to the connection. If you create a
> prepared statement within a stored routine, it is not deallocated when the
> stored routine ends. *
>
> Then I don't know how to deallocate the memory used by prepare statement
2008/10/21 Moon's Father <[EMAIL PROTECTED]>:
> Could you please give me an idea of how to manage the privileges inside
> mysql?
http://www.google.co.uk/search?q=mysql+grant
first hit :)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://list
2008/10/17 Reyna.Sabina <[EMAIL PROTECTED]>:
> Hi,
>
> Running Environment:
> MySQL Server version: 5.0.45
> OS is Red-Hat 64-bit
>
> The table 'junk' doesn't have a row with id=4. Two tests to trap 'errors'
> using DELETE follows:
>
Perhaps I'm missing something - but a delete matching no
2008/10/17 Rob Wultsch <[EMAIL PROTECTED]>:
> On Fri, Oct 17, 2008 at 1:33 PM, Rene Fournier <[EMAIL PROTECTED]> wrote:
>
>> Okay, I realize that query won't work, but that's essentially want I want
>> to do:
>>
>> Add four months to the current date, then return the first day of that
>> month, e.g
2008/10/17 Brent Baisley <[EMAIL PROTECTED]>:
> Why are you creating a subquery/derived table?
>
> Just change your limit to 1,2
> ORDER BY updates.AcctSessionTime DESC LIMIT 1,2
Because then the maths in the select part isn't executed, and I don't
get the figures I need.
--
MySQL General Maili
2008/10/17 Rob Wultsch <[EMAIL PROTECTED]>:
> *How long does the second query actually take to run compared to first?
Actually, really quickly - so quickly that I also suspected that a
full table scan was not taking place. I'd like to understand how the
output of EXPLAIN can differ from the act
2008/10/16 Krishna Chandra Prajapati <[EMAIL PROTECTED]>:
> I believe that yahoo, google and other companies must be generating reports.
> How they are doing. Any Idea.
This is how google do it: http://en.wikipedia.org/wiki/MapReduce
Have you seen federated tables? Be aware of the performance on
2008/10/17 dave aptiva <[EMAIL PROTECTED]>:
>
> I tried SELECT ID_number, max( count( CU_number ) ) but this causes an error
> "# - Invalid use of group function "
# sqlite3
SQLite version 3.5.9
Enter ".help" for instructions
sqlite> create table moo (id_number, cu_number);
sqlite> insert int
Hi all,
I'm trying to work out the difference in a field between the last 2
updates in an updates table. I'm doing this as shown below:
mysql>SELECT
-> (@in - AcctInputOctets) AS AcctInputOctets,
-> (@out - AcctOutputOctets) AS AcctOutputOctets,
-> (@in := AcctInp
e information schema. what makes the problem even
more fun is that not all users are affected for the same table.
another user could very well have the problem with table1 instead of
table2 and another user may have no problems at all.
Any thoughts or suggestions would be greatly appreciated.
Thanks
ing the NDB cluster engine but from your notes I would think that
even my old MyISAM tables are affected.
I do have *.MYD files as big as 15GB on a 32bit system and guess
that I'm not the only one.
Could you clarify that on the next release notes?
bye,
-christian-
--
MySQL General M
PK and text field seems to be the only sensible
decision. Thanks in advance,
Christian
On Tue, Mar 25, 2008 at 10:11 AM, Arthur Fuller <[EMAIL PROTECTED]> wrote:
> What is the size of the text field you're fulltext indexing? How often is
> that index used? You might be best off
size to about 2 GB. My question is: When mysql adds
indexes to the keycache, does it add each index individually or does
it dump the entire .MYI file to the keycache. If it is the latter, I
should move the fulltext index to another table.
Thanks in advance,
Christian
--
J. Christian Hesketh M.Sc
aying that you're only using innodb then you don't need
to lock the server. I'm using the attached script for backups. We
configure our slaves to use the given $slave_socket (to prevent normal
programs from writing to the db by accident), that's the reason for the
optional --
ent one (e.g.
his incoming IP)?
There are both PHP and Perl users, so it should preferably be a solution
that works for both.
Christian.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
actly what
needs to be done?
Thanks in advance,
Christian Parpart.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On 8/14/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Christian High wrote:
> > On 8/14/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
> >> Hi,
> >>
> >> Christian High wrote:
> >>> I have a table that includes a date and
On 8/14/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Christian High wrote:
> > I have a table that includes a date and a scale reading like
> >
> > datescale_reading
> > 2007-08-01 150
> > 2007-08-02 125
> >
I have a table that includes a date and a scale reading like
datescale_reading
2007-08-01 150
2007-08-02 125
these reading may or may not be taken everyday. I need to develop a
query that will subtract the scale reading on one day from the scale
reading on the next m
On 8/8/07, Brent Baisley <[EMAIL PROTECTED]> wrote:
> One thing to check is to make sure you are not quoting your NULL
> value for your insert statement. MySQL will try to convert that to a
> numeric value, which may end up as 0.
>
> On Aug 8, 2007, at 12:55 PM, Mahmoud Badreddine wrote:
>
> > Hell
I believe that excel files generally terminate lines with '\r\n' and
if you use terminated by '\n' it will cause this behavior. so try it
with lines terminated by '\r\n' or get TextPad or a similar editor
that can save the file as unix platform that uses the same line
terminators that MySQL expects
ed DB?
Thanks in advance,
Christian Parpart.
signature.asc
Description: This is a digitally signed message part.
of course you'll need to restart the server after making the changes
to the options file..
On 7/30/07, Christian High <[EMAIL PROTECTED]> wrote:
> set these options in the option file under the [mysqld] section
>
> log-slow-queries=
> log=
>
> log= is the g
set these options in the option file under the [mysqld] section
log-slow-queries=
log=
log= is the general query log
i am not sure what you mean by the mysql log. if you mean the error
log than that would be
log-error=
if you mean the binary log that would be
log-bin=
if you don't enter anyt
if you are using MySQL 5 you could use a stored procedure
On 7/27/07, Samrat Kar <[EMAIL PROTECTED]> wrote:
>
> I want to execute three sql statements in single query which will perform
> following task...
> 1. select a particular row
> 2. insert that row to another table
> 3. delete that row from
Hi All,
How do I create a mysql data dump from a slave to seed another slave?
Using --master-data with mysqldump from my existing slave sets the
master to the slave I was dumping, not the real master.
Many Thanks,
Ian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/my
? (coudn't find any trace in the
net yet) and what about potential future storage engines in mysql, or will
there be myisam as the one and only feature blown one?
Thanks in advance,
Christian Parpart.
pgpAz6gblxJiP.pgp
Description: PGP signature
Hi all,
this statement indeed is a feature.
but why has it been marked obsolete?
it would be sooo easy instanciate master-slave replication.
Regards,
Christian Parpart.
signature.asc
Description: This is a digitally signed message part.
>I'ld like to accomplish something like:
>
>set @myvar=concat_ws(",",(SELECT column from table1 order by column;
>where ...))
>
>or
>
>select concat_ws(",",(SELECT column from table1 order by column where ...));
>
>for further usage in sql-scripts
I forgot to mention: As I need it in a function, i
>I'ld like to accomplish something like:
>
>set @myvar=concat_ws(",",(SELECT column from table1 order by column;
>where ...))
>
>or
>
>select concat_ws(",",(SELECT column from table1 order by column where ...));
>
>for further usage in sql-scripts
I forgot to mention: As I need it in a function
Hi y'all,
I'ld like to accomplish something like:
set @myvar=concat_ws(",",(SELECT column from table1 order by column;
where ...))
or
select concat_ws(",",(SELECT column from table1 order by column where ...));
for further usage in sql-scripts
--
MySQL General Mailing List
For list archive
hi all,
Here's a nut to crack:
I would like to extract a part of a string stored in a varchar column in a
mysql table.
Since the part of string I want to extract is neither at a fixed position
nor logically separated by a fixed character I was thinking using regexp
would by a good idea
Sample d
hi all,
Here's a nut to crack:
I would like to extract a part of a string stored in a varchar column in a
mysql table.
Since the part of string I want to extract is neither at a fixed position
nor logically separated by a fixed character I was thinking using regexp
would by a good idea
Sample d
when - back
to being in sync.
Why these defaults changed on a minor mysql release update is beyond me,
however I suspect this is gentoo's fault, not MySQLs.
--
Ian P. Christian ~ http://pookey.co.uk
signature.asc
Description: OpenPGP digital signature
Ian P. Christian wrote:
> I upgraded my slave server a few weeks ago, and the slave failed, with
> an error similar to the one shown below.
I have figured out what happened here now - and I'm part of the way
though fixing it.
It turned out the defaults had changed somewhere, and
deas/suggestions welcome, reseeding the slave will literally take days.
--
Ian P. Christian ~ http://pookey.co.uk
signature.asc
Description: OpenPGP digital signature
stem?
Yes - I've been doing this for some time, works fine.
--
Ian P. Christian ~ http://pookey.co.uk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On 4/23/07, Andreas Iwanowski <[EMAIL PROTECTED]> wrote:
Hello MySQL experts,
I am trying to create a view whose access is based on a User ID that
need to be looked up in a different table.
Here is an example of what I'm trying to do:
CREATE OR REPLACE ALGORITHM=UNDEFINED [EMAIL PROTECTED] SQL
On 4/22/07, Christian High <[EMAIL PROTECTED]> wrote:
On 4/22/07, YL <[EMAIL PROTECTED]> wrote:
>
> I have a contact table looks like
>
> id type owner_idowner_type value
> 11email21 person [EMAIL PROTEC
On 4/22/07, YL <[EMAIL PROTECTED]> wrote:
I have a contact table looks like
id type owner_idowner_type value
11email21 person [EMAIL PROTECTED]
12phone 21 person 303-777-
13PO Box18
ve). Then "INSERT INTO newtable SELECT * FROM
> oldtable WHERE primarykey in ( your 50,000 keys )", then "DELETE FROM
> oldtable WHERE primarykey in ( your 50,000 keys )", then COMMIT, which
> will cause your insertions and deletions to be truly atomic.
Ah of cours
hange because any
new records would get included in the LIMIT.
Will it not always use the natural order of the table in
selects/deletes, and therefore return results in the order in which they
were inserted?
--
Ian P. Christian ~ http://pookey.co.uk
--
MySQL General Mailing List
For list archives:
(if I don't limit to small numbers in the LIMIT, I/O gets too high, so
I'm moving data slowly in batches)
Thanks,
--
Ian P. Christian ~ http://pookey.co.uk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
a, and remember to never store the CVV number.
--
Ian P. Christian ~ http://pookey.co.uk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
his:
http://forums.mysql.com/read.php?30,14020,14020
which honestly, I've not read - but you might want to :)
--
Ian P. Christian ~ http://pookey.co.uk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Neil Tompkins wrote:
I'm looking to use MD5() to encrypt credit card numbers. How do I
unencrypt this when reading the value ?
you can't.
Google for MD5, or better still look at wikipedia, I'm sure they will
have something
--
Ian P. Christian ~ http://pookey.co.uk
-
Filip Krejci wrote:
> Hi,
>
> I suppose this is really I/O problem.
>
You're right, it looks like it was just an I/O problem - your suggestion
was spot on. I've now managed to dump my master data, and can get my
slave back online!
Thanks a lot for your suggestion,
--
I
eue
2 read views open inside InnoDB
Main thread process no. 23228, id 2367634320, state: sleeping
Number of rows inserted 356882, updated 1963990, deleted 293832, read
875872021
2.05 inserts/s, 10.32 updates/s, 0.21 deletes/s, 48500.03 reads/s
Thanks again,
--
Ian P. Christian ~ http://pookey.co.uk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ldump --host x.x.x.x --master-data
--single-transaction > dump.sql) which cause separating writes on
another box?
I did do this under the assumption it could simply be an I/O problem -
however the problem persists. It might be because the network
connection between the two hosts is pretty fast
Marcus Bointon wrote:
Hi Marcus :)
> On 7 Mar 2007, at 08:44, Ian P. Christian wrote:
>
> --single-transaction doesn't _do_ the dump as a transaction, it simply
> wraps the dump in begin/commit statements so it's atomic when restoring.
>
> If the dump is to preserve
though), and what I could do about it?
Many Thanks,
--
Ian P. Christian ~ http://pookey.co.uk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
stion is what permissions do I need to give
> [EMAIL PROTECTED] to just access that one permission?
I've seen the table mysql.procs_priv, it's probably defined there.
bye,
-christian-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
options to
CREATE PROCEDURE? With them it should be possible to
* deny selects to users on the tables
* allow selects to users to this procedure
* having the procedure itself working with the rights of root/definer
bye,
-christian-
--
MySQL General Mailing List
For list archives: http://lists
ized.
You can check at least open_files in "SHOW STATUS" IIRC.
> Key buffer usage is often hitting 100%, and just 0.01 tables are opened
> per second. Number of queries/second is 269.
BTW, try "mysqlreport" to find other bottlenecks.
bye,
-christian-
--
MySQL Ge
On 2007-02-19 Nhadie Ramos wrote:
> Hi Christian,
>
> Thanks for the reply. I got the table repaired and deleted some data on it.
> What combination can i use to overcome the 4GB limit?
Read http://www.suse.de/~aj/linux_lfs.html and google a bit. Basically any
recent Kernel 2.4 o
doing that with MyISAM, too.
Use mysqlhotcopy or mysqldump for that.
If you stop the server, then copy the files and make sure that you have
the same innodb_data_file_path statements at the target host, it maybe works.
bye,
-christian-
--
MySQL General Mailing List
For list archives
t; on them. If they end up with >4GB then delete as much as
necessary and they will be usable on your old computer again.
HTH,
-christian-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
re running MySQL 3.23 and wish to upgrade to
a newer series, upgrade to MySQL 4.0 rather than to 4.1 or 5.0."
bye,
-christian-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-+
1 row in set (0.00 sec)
> "Also could someone give a hint how to recode digits in order to anonymize
> data."
Depending on what exactly you want, play around with random() and substring().
bye,
-christian-
--
MySQL General Mailing List
For list archives: http://list
or the database
type.
> And is InnoDB recommended now?
It depends.. :)
> Does it support full text indexes?
> Or if not, is there a way of using full text indexes and foreign keys in
> MySQL?
No fulltext indexes in InnoDB and
no foreign keys in MyISAM as of 5.0.
bye,
-christian-
ounts` records) have been wiped out of
GbEntries table.
DELETE GbEntries Accounts WHERE Sender "NOT IN Accounts.ID";
but how's the proper SQL syntax for this?
Thanks in advance,
Christian Parpart.
pgpRXubTioFGf.pgp
Description: PGP signature
ounts` records) have been wiped out of
GbEntries table.
DELETE GbEntries Accounts WHERE Sender "NOT IN Accounts.ID";
but how's the proper SQL syntax for this?
Thanks in advance,
Christian Parpart.
pgp2l9v1LOnci.pgp
Description: PGP signature
a "Merge-Table" to access them all in one SELECT.
bye,
-christian-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Is it possible to restrict the range that can be put in a floating point, or
other data type that allows decimal numbers. The data being stored will be
that of the result of chemical analysis. The result could very well be
2.41however it would never be
24.1 so i want to ensure that a simple typo l
f the same comment. How can I
> refine this query to give me 3 unique/distinct ones?
Maybe
SELECT DISTINCT
rand() as rnd,
*,
DATE_FORMAT(created_on, '%b %D') as date_format
FROM
comments
ORDER BY
rnd
LIMIT
3
;
bye,
-christian-
--
MySQL General Mailing List
Or an SQL command?
What does "find /var/lib/mysql/ -ls" and "df -h" say?
bye,
-christian-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
acters be treated literally?
Hm, no, the "-" inside "[" and "]" is a special character, i.e. "[a-z]" means
all chars
from a to z. So in your case that would have been all chars from . to a which
makes not
much sense. If you write "[-az]" on the
lass it is usually threaten literally as it makes no
sense
as "from..to" separator in those cases.
bye,
-christian-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ange what is called
"wait_timeout" in "SHOW VARIABLES".
bye,
-christian-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On 2006-11-07 Sayed Hadi Rastgou Haghi wrote:
> Dear All,
>
> I want to set wait_timeout variable on mysqld startup.
> Is there any way to do that?
Put "wait_timeout = XXX" into the "[mysqld]" stanza of your
/etc/mysql/my.cnf (or wherever your global co
it down that much?
"slow" always depends.. if the table has only 200 rows and the query is run
twice a day, don't care about speed :)
-christian-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
't know how the regular expression function was called exactly but you
get the idea)
SELECT subject FROM table ORDER BY cooked_subject;
Of course you could also put the regular expression in the SELECT but that
would be slower.
bye,
-christian-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
that updates the start_yr_mo
whenever start_date is modified but I'm unsure if triggers are present
before 5.1.
Of course the best way could be to drop the start_yr_mo completely and let
the application render it. Storing redundant data in a database is seldom
a good idea and using SQL for f
r it's easier to track down if you use exactly the same binaries than
the mysql team.
And it safes you time, of course :)
Most people take the binary packages that their distribution offers which is
a good compromise.
bye,
-christian-
--
MySQL General Mailing List
For list archives: http://list
ions and some connection tracking table runs full.
bye,
-christian-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
e
'/^(.{14}):(.{8})\|,(\d+),(\d+)\|[^\|]+\|[^\|]+\|,(\d+)\|.*\|,(\d+)\|$/ &&
print "INSERT INTO t VALUES (\"$1\",$2,$3,$4,$5,$6);\n";'
The output is ready to be piped into mysql:
"INSERT INTO t VALUES ("E524541015.txt",20061004,535,999,
he compound
> index. Ugh. Any ideas?
Search the docs for "FORCE INDEX ()" and "IGNORE INDEX ()" if you don't
want to rely on MySQL's cleverness.
bye,
-christian-
--
Christian Hammers WESTEND GmbH | Internet-Business-Provider
Technik
we have simultaneous connections with 2 DBs?
Using /usr/bin/mysql? Even with one connection you can access as much
databases as you like. Even a join of tables from different databases
work.
bye,
-christian-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
ry_cache_wlock_invalidate | OFF|
+--+--------+
thanks,
-christian-
--
Christian Hammers WESTEND GmbH | Internet-Business-Provider
Technik CISCO Systems Partner - Authorized Reseller
Lütticher Straße 10
032 0 4230 0 7 5 88 0
1 0 0 2958220 139712 383074800 0 596 3904 0 8 5 87 0
bye,
-christian-
--
Christian Hammers WESTEND GmbH | Internet-Business-Provider
Technik CISCO Systems Partner - Autho
ot;. The datadir is only
4GB in total so that I even guess that almost all tables will fit into the
process memory.
bye,
-christian-
--
Christian Hammers WESTEND GmbH | Internet-Business-Provider
Technik CISCO Systems Partner - Authorized Reseller
Hallo
On Tue, Aug 22, 2006 at 09:25:09AM -0500, Dan Buettner wrote:
> Christian, can you post the output of
> SHOW STATUS
> and
> SHOW VARIABLES
> please?
>
> This will tell us how your server is configured, and how it has been
> running. It's possible you're n
n result from inefficient queries and
wrong configuration settings, too, but as this would get quite complex
then I first want to rule out this cause)
thanks,
-christian-
--
Christian Hammers WESTEND GmbH | Internet-Business-Provider
Technik CISCO Sy
en you lose the connection and reconnect, can you not clear the
cache for the autoinc table so it gets the current value?
The framework does that, after reconnecting it does reread the PK
values. The problem must be somewhere else...
Christian
--
MySQL General Mailing List
For list
t itself. But in the end this patch didn't solve the
problem, these error messages still occur.
Does anybody have an idea how to solve this problem? In what
direction could we search next? Is there a switch to let mysql log a
lost db connection? Any hints are appreciated!
Thanks!
Christ
> We're using Opterons, Linux 2.6.x, and a SiL (Silicon Image) SATA
> chipset whose particular model number I don't have in front of me.
>
> After MUCH MUCH MUCH trial and error we've discovered that:
> 1) 2.6.16 substantially alleviates the problem but doesn't eliminate it.
> 2) There is a 3Ware
> * - For example: We faced a NASTY problem using AMD 64-bit CPUs + SATA +
> Linux where I/O on the system (the WHOLE system, not JUST the SATA
> spindles -- network, PATA, USB, EVERYTHING) would suddenly come to a
> grinding halt (or very nearly halted) randomly when the SATA subsystem
> was under
1 - 100 of 355 matches
Mail list logo
