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
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
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 are accessed
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.
You need to delete/move
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:
. 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]
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
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
Marco
Tom Horstmann wrote:
Dear Marco,
i'm not sure, this can be solved by MySQL itself
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. I'm
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 created in
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
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.
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 =
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 941 /
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
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
read the
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 * from
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
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 want
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.
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 (for
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)
);
That is
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 directly to
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 name of
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
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 1 )
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 column
28 matches
Mail list logo