In the INSERT, I used the CHAR function, rather than the ASCII, sorry
for the mistake.
Thanks again
Roland
Roland Kaber wrote:
It looks like it is really a character set conflict. The copyright
character © is ascii 169 and is part of latin-1. However, there is a
similar character, (C) the cir
It looks like it is really a character set conflict. The copyright
character © is ascii 169 and is part of latin-1. However, there is a
similar character, (C) the circled latin capital letter c which is not
in the latin-1 character set. I have found two solutions:
1. setting the column's cha
Here are a couple ideas:
* Decrease innodb_autoextend_increment to 8 or even 4. You may see
additional IO wait because you're pre-allocating space in chunks
disproportinate to what you immediately need, causing bursty performance.
* If your remaining MyISAM tables don't need it, take 2GB of the ke
On Thu, Sep 4, 2008 at 6:43 PM, Josh Miller <[EMAIL PROTECTED]> wrote:
> We'd like to prove InnoDB and move onto that storage engine for the
> transaction support, MVCC, etc.. but we're finding that performance is poor.
Well, thousands of large InnoDB database users prove that the engine
itself ha
Perrin said it right.
If your app needs InnoDB (transaction, row level locks...) write it that
way.
Don't expect performance from a MyIsam compliant app when using InnoDB.
TomH
-Original Message-
From: Josh Miller [mailto:[EMAIL PROTECTED]
Sent: Friday, September 05, 2008 12:42 AM
To: T
Perrin Harkins wrote:
What you really need to do is look at which queries are slow and run
EXPLAIN plans for them. Most big performance problems like you're
describing are due to index issues, so that's where you should be
looking. Server tuning comes lat
We definitely need to work on re-des
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 the InnoDB logs before restart.
Not sure about this, but please also set innodb_log_buff
On Thu, Sep 4, 2008 at 4:26 PM, Josh Miller <[EMAIL PROTECTED]> wrote:
> We're seeing a significantly higher percentage of IO wait on the system,
> averaging 20% now with the majority of that being user IO. The system is
> not swapping at all.
O_DIRECT may not be the best setting for your hardwa
It is a character set conflict between the source of the data and the
column. I run into this all of the time when using the CLI. Programmatically
it can be avoided.
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 /
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 the InnoDB logs before restart.
Not sure about this, but please also set innodb_log_buffer_size. Try
something
b
> 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
Tom Horstmann wrote:
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
structur
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
Good afternoon,
I have recently converted a large table from MyISAM to InnoDB and am
experiencing severe performance issues because of it. HTTP response
times have gone from avg .25 seconds to avg 2-3 seconds. Details follow:
PHP/MySQL website, no memcached, 3 web nodes that interact with D
Hello
I recently encountered the following problem. I changed the sql mode to
TRADITIONAL recently. Here is a test table for demonstration purposes.
CREATE TABLE `text_t` (
`t` text collate latin1_general_cs
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs
The following INSER
On Thu, Sep 4, 2008 at 3:23 PM, Ryan Schwartz <[EMAIL PROTECTED]> wrote:
> I'll have to crack open my copy - haven't read through it in a while
If you have the first edition, I recommend getting the newer one. It
has a lot more tuning info.
- Perrin
--
MySQL General Mailing List
For list archi
I concur.
The SELECT time is going to resemble something like:
K_1 * F_1(number_of_records_in_database) + K_2 *
F_2(number_of_records_selected)
If the indices are effective, F_1 = log(N), but if the indices are not
effective, F_1 = N.
One thing you may want to try to narrow down the problem is
On Thu, Sep 4, 2008 at 10:38 AM, mos <[EMAIL PROTECTED]> wrote
Jim,
The problem is likely your index is not defined properly. Use an "Explain"
in front of the query to see if it can use just one index from each table.
I would try building a compound index on
Products: (RecordReference, FeedId)
Jim,
I've re-posted your message to the list so others can join in the
fray. :)
Mike
At 10:50 AM 9/4/2008, you wrote:
Hi Mike,
I do believe we have done the indexing properly. Please advise if we can
make any adjustments. Here is the output from the explain statements;
16634be.png
On Sep 4, 2008, at 1:48 PM, Ranjeet Walunj wrote:
Hi ryan.
As pointed by Johnny, it is difficult to give optimization advise
without exactly knowing the performance of your machine.
I'm assuming you are using the machine as Database Server and not
running application (Web/other) on the sa
mysqldump. There are other users, but the behavior recurs even if the
database is only being used by mysqldump.
Thanks,
LA
Michael Dykman wrote:
How are you performing the backup? What tools are involved? Are
there any ther users of the database while you are doing this?
- michael dykm
Ryan Schwartz wrote
mysql> show variables like '%buffer%'\G
*** 1. row ***
*** 3. row ***
Variable_name: innodb_buffer_pool_size
Value: 8388608
*** 4. row *
Hello,
I am looking for someone to give a talk on MySQL at the upcoming
PostgreSQL Conference in October. Something like Why I chose MySQL over
PostgreSQL: A Technical analysis (or similar).
Any takers?
http://www.pgcon.us/west08/talk_submission/
Sincerely,
Joshua D. Drake
--
MySQL Gener
>-Original Message-
>From: Brent Baisley [mailto:[EMAIL PROTECTED]
>Sent: Wednesday, September 03, 2008 5:35 PM
>To: Jim Leavitt
>Cc: mysql@lists.mysql.com
>Subject: Re: Large Query Question.
>
>That's a lot of data to return, make sure you factor in data load and
>transfer time. You may tr
It's highly unlikely hardware upgrades are needed unless you're on a really
underpowered machine. How similar are the queries on the other machines?
The "limit" clause won't reduce the time taken to do the join and grouping,
it will only reduce the amount of output.
Also, I assumeyou have indexes
At 02:49 PM 9/3/2008, Jim Leavitt wrote:
Hi Mike,
Yes sometimes, the application is an online book selection tool with
about 1 million titles in it. Now the queries which return 100,000 rows
would be something like returning all titles from a given publisher. Most
of the common searches are
On Thu, Sep 4, 2008 at 12:15 AM, Ryan Schwartz <[EMAIL PROTECTED]> wrote:
> We're seeing a huge surge in our qps and I'd like to make sure we're tuned
> as well as we can be. I'm wondering if I've got some variables maybe set too
> large (is that even possible?) ? We do have a fair bit of innodb, s
Here's all the buffer variables:
mysql> show variables like '%buffer%'\G
*** 1. row ***
Variable_name: bulk_insert_buffer_size
Value: 8388608
*** 2. row ***
Variable_name: innodb_buffer_pool_aw
Hello,
I am planning to write a UDF (User Defined Function) that acts like a
server side client. This UDF is called by a client first. After that the UDF
spwans a thread then exits. Within this spawned thread it will get work from
a network socket. After that it will start executing SQL statemen
Dear MySQL specialists,
this is a MySQL-newbie question: I want to create a view of a table,
where all NULL-values are substituted by 0. Therefore I tried:
SELECT *,
IFNULL(*,0)
FROM table
Unfortunately IFNULL seems not to accept any wildcards like * as
placeholder for the column-name. REGEXP d
30 matches
Mail list logo
