Dear Marco,
i'm not sure, this can be solved by MySQL itself, but if you're e.g.
using php you may try to use mysql_pconnect () instead of
mysql_connect (). Please see
http://www.php.net/manual/en/function.mysql-pconnect.php
and
http://www.php.net/manual/en/function.mysql-connect.php
In your favo
Original Message-
> From: ESV Media GmbH [mailto:[EMAIL PROTECTED]
> Sent: Saturday, January 14, 2006 4:27 PM
> To: mysql@lists.mysql.com
> Subject: Reload Problem -> "Mass-Reload" crashes DB
>
> Thanks for your quick reply.
>
> Thanks a lot for your help
Right... and perhaps try MySQL Enterprise Monitor. A trial is available from
mysql.com. It may give you hints on your mysql.cnf.
Kind regards,
TomH
-Original Message-
From: Brent Baisley [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 03, 2008 11:35 PM
To: Jim Leavitt
Cc: mysql@lis
Hello Josh,
why you moved your table to InnoDB? Your description doesn't sound like the
tables rows
are accessed concurrently and need to be locked? Are you sure you need
InnoDB for this table?
If you need InnoDB you probably need to redesign your queries and table
structure to get them
more conv
> The rows in this table are accessed concurrently as any activity on the
> site is recorded/added/updated to this table. We have several others
> which serve similar purposes, (sessions, totaltraffic, etc...).
Is the performance lag occurring with read-only queries and updates/inserts
to the I
between 16-32MB if you have many transactions.
TomH
-Original Message-
From: Tom Horstmann [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 04, 2008 11:15 PM
To: 'Josh Miller'
Cc: mysql@lists.mysql.com
Subject: RE: innodb/myisam performance issues
> The rows in this table
AM
To: Tom Horstmann
Cc: mysql@lists.mysql.com
Subject: Re: innodb/myisam performance issues
Tom Horstmann wrote:
> Addendum..
> Please also try increasing your innodb_log_file_size to a much higher
value
> if you
> have lots of writes/transactions. Maybe 250MB is a good first try.
>
67296 byte / 300 byte/day = 1431 days
No issues for about 3 years. And after that time you could simply create a
new table.
hth,
Tom Horstmann
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> I have MySQL 4.1.12 running on a MacOS X 10.4.1 development
> setup where I often load a 1Gb db and later on drop
> it/reload/generally make a mess. I just noticed that though
> the database is holding only
> 4 small records totalling less than 1k, my ibdata1 file is
> sitting at over 800Mb.
> mysql> create table ABC (col1 varchar(10));
> Query OK, 0 rows affected (0.03 sec)
>
> mysql> show tables;
> +--+
> | Tables_in_userdb |
> +--+
> | abc |
> +--+
> 1 row in set (0.00 sec)
>
> mysql>
>
> NOTE THE FACT THAT THE TABLE IS
Hi all,
i want to store an unfixed number of object-characteristics
of an unfixed datatype for 1-8000 objects. Data is mostly
read, rarely written. Is there an quite optimal table-structure
for that?
If i use one table for all characteristics i need as many
columns as there are datatypes used. On
Thanks Chris,
> Will you have an object hierarchy of any type to speak of?
no hierarchy, they're all roots.
> Which language are you looking at building this funky thing
> in? If it's
> Java or C++, you might want to look at persistant object
> stores that are
> specifically for this purpose (
Hi Brad,
> create table entity (
> ent_id number primary key,
> ent_namevarchar(50)
> );
>
> create table nameval (
> nv_id number primary key,
> nv_ent_id number,
> nv_name varchar(50),
> nv_val varchar(50)
> )
Hi Craig,
> I have a very large web app that uses timestamp for unique IDs.
> Everything was rolling fine until we started getting many users per
> second, causing some of the unique IDs to not be unique -- users were
> being assigned the same timestamp. Since the web app is so large we
> don't wa
Hi,
i need some assistance in choosing an ADO.NET- provider for MySQL.
We will port an app from Visual Objects to C# soon. Currently we
are using the C-API. Our tables are mainly innoDB and we use
transactions. We will use relations.
Most of our customers have
- 5-20 concurrent users
- the ser
Hi Marcelo,
> Hi I was wondering if there is a way to give the a number of
> connections that I want simultaniusly to the database, supose
> I only want that 8 computers to access the database at the same time
try "max_connections" to limit the connections the server allows.
http://dev.mysql.c
Hi Kerry,
> The problem is more fundamental with the scrolling through
> the records/rows of Master. [..] It is not sensible to allow
> 200 million pieces of data to be transferred to the Delphi PC
> to build a local Dataset to scroll through.
>
[..]
> Getting the first row is easy
>
> select
> I know i have to connect first to the server. I tried issuing
> the command like this:
> mysql> mysql -h localhost -u root -p;
> but it says error in syntax. if i take out the semi colon,
> the shell would just add a '->' below.
You are already running mysql by typing that. You should have
rea
Hi all,
do you know how to set innodb_lock_wait_timeout = 0? Why is it
to be > 0?
Regards,
TomH
--
PROSOFT EDV-Loesungen GmbH & Co. KGphone: +49 941 / 78 88 7 - 121
Ladehofstrasse 28, D-93049 Regensburg cellphone: +49 174 / 41 94 97 0
Geschaeftsfuehrer: Axel-Wilhelm Wegmann [EMAIL PROTECT
> Is there a way to directly import DBF data into MySQL table
> or do I HAVE to convert it into CSV (Using EXCEL) or some
> other method?
Not as far as i know, but there are some tools out there. Do
a google for "dbf2mysql".
Regards,
TomH
--
PROSOFT EDV-Loesungen GmbH & Co. KGphone: +49
Dear Matthew,
> PHP
> ---
> $res = mysql_real_query($mysql,"SELECT col1, col2 FROM
> table"); while($row = mysql_fetch_row($res)) {
> print $row['col1'];
> print $row['col2'];
> }
>
> Is the only way/best way to do the above in C by using a
> nested for-loop?
> Ex:
>
> fields = mys
:),
i need to do an automatic, dynamic installation
of the win binary distribution. The only thing i know, is
mysql beeing put on a win-machine( >= 98 ) and possibly
the directory it should be placed to.
Did someone work on that before? May i give parameters to the
msi-file, patch it, create a new
Lee,
> I get the feeling there is a more efficient method using
> binary operations
> (only one field populated with zeros and ones) but I can't
> find anything to
> help in the manuals.
i think you should try to avoid such thing as much as you can.
Storing more than one piece of data in a colu
> > The question is how can I use some sort of statement using
> mysql and php
> > to select all rows between 1 and 0 NOT 0 and 9 like the
> above statement
> > performs.
Sure, an option was nicer, but isn't the following possible?
SELECT ... WHERE ... AND ( x BETWEEN 1 AND 9 OR x BETWEEN 0 AND
> Now, how can I save only these 1000++ data into a file in my pc?
Normaly you should get the data into a file with that
something you sent the query to mysql with. What is that
something in your case?
Regards,
TomH
--
PROSOFT EDV-Lösungen GmbH & Co. KG
Geschäftsführer: Axel-Wilhelm Wegmann
AG
> I did something very stupid: I locked myself out of the
> MySQL server (all accounts, incl administrator)...
>
> My problem: I use MySQLFront to change the allowed
> hosts and did it for all users. They were 'localhost'
> and I set them to 'localhost; EcolMod1' where the
> EcolMod1 is the na
> I've scoured the web and can't seem to find any examples, and
> can't find
> anything that shows flash actually making the connection to
> mysql on its
> own. They all seem to rely upon PHP or something passing the value.
> Refreshing the page is not acceptable.
Flash is executed in the client
> I disagree, you can restrict access to SELECT only
Sure, but no access is much more secure than restricted access.
> and plus
> any normal form
> on a web page has access to a DB in much more insecure ways
> (SQL injection,
> etc.),
What you consider insecure should not been written directl
Hi all,
i try to simulate dBase-like record-skips through a compound
(dbf-) order. Anybody did that before? Please give me a hint.
thx in advance,
TomH
--
PROSOFT EDV-Lösungen GmbH & Co. KG phone: +49 941 / 78 88 7 - 121
Ladehofstraße 28, D-93049 Regensburg cellphone: +49 174 / 41 94 97 0
29 matches
Mail list logo
