Good.
On Fri, Jun 13, 2008 at 3:23 AM, Lori Kurovski <[EMAIL PROTECTED]> wrote:
> We are currently looking for a contractor for 30 days in Kansas City that
> has experience doing MySQL DBA/Windows Server Administration work. This
> will be a production support role as the consultant will be cove
Thanks a lot Edwards!
I'm using MySQL 5.1. Your query works great!
- Original Message -
From: "Rolando Edwards" <[EMAIL PROTECTED]>
To: "Elim Qiu" <[EMAIL PROTECTED]>;
Sent: Friday, June 13, 2008 10:32 AM
Subject: RE: query counts of a database
If you are using MySQL 5.0 or later, use
Ok, thanks for all the information. I have tried solving the problem via
perl, but I am using DBIx::Class and Catalyst, which are both relatively new
to me. The way DBIC deals with grabbing data from the database combined
with my limited skills had me looking for a mysql solution.
You're saving
From: Jim Lyons [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2008 12:10 PM
To: Boyd, Todd M.
Subject: Re: natural sort via substrings
What I would do is form 2 additional fields from the first, an alphanumeric
field and a numeric field so:
jane-2 jane- 2
alex 3 alex 3
> -Original Message-
> From: Emily Heureux [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 12, 2008 8:25 PM
> To: mysql@lists.mysql.com
> Subject: natural sort via substrings
>
> Hi, I am attempting to do a "natural sort" from within mysql, if
> possible. So, for example, jane2 would come
Sorry, my email didn't make the intention clear.
I want the number of records per table in a database like:
querytime | -xx-xx-xx:xx:xx
tNm1 | yyy
tNm2 | zzz
..
where tNm1, tNm2 are table names in the database.
- Original Message -
From: "Boyd, Todd M." <[EMAIL PROTE
> -Original Message-
> From: Emily Heureux [mailto:[EMAIL PROTECTED]
> Sent: Friday, June 13, 2008 11:12 AM
> To: Boyd, Todd M.; mysql@lists.mysql.com
> Subject: RE: natural sort via substrings
>
> Hi, I am sorry for being so vague. The values are not as simple as
> jane20,
> jane10, or j
If you are using MySQL 5.0 or later, use the INFORMATION_SCHEMA database.
It has an in-memory table of table names called (as you would expect) 'tables'.
SELECT table_rows,table_name FROM information_schema.tables
WHERE table_schema = '';
If you are using a current database then do this:
SELECT
Hi, I am sorry for being so vague. The values are not as simple as jane20,
jane10, or jane2. There are names like, jane-2, alex 3, alex4, and just
'jane', etc. ORDER BY sorts by either numerical OR string, not both, as far
as I can tell. I'll have to think about zero-fill, but I doubt that will
That's pretty much what I've been doing to get that the drive is running
at 100% bandwidth.
What I'd like is something that just gives the bandwidth of the device
in terms of Mb/s: you can probably work it out using that iostat
command, seeing how much it wrote and what percentage of the bandwidth
> -Original Message-
> From: Elim Qiu [mailto:[EMAIL PROTECTED]
> Sent: Friday, June 13, 2008 10:56 AM
> To: mysql@lists.mysql.com
> Subject: query counts of a database
>
> I'm looking for a query that reports the count of each table in the
> database.
> the query should not assume the tab
I'm looking for a query that reports the count of each table in the
database.
the query should not assume the table list of the database.
Thanks for any inputs
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTE
> -Original Message-
> From: Ananda Kumar [mailto:[EMAIL PROTECTED]
> Sent: Friday, June 13, 2008 10:48 AM
> To: [EMAIL PROTECTED]
> Cc: mos; mysql@lists.mysql.com
> Subject: Re: Fulltext index -first query slow, subsequent queries fast
>
> Hi
>
> Is sphinxsearch avialable only on for win
On Fri, June 13, 2008 08:26, Ian Simpson wrote:
> Hi Jerry,
>
> It could be a kernel issue; however, currently I'm suspecting that the
> drive in the new server simply doesn't have the same bandwidth
> capability. The iostat results I'm getting (although I'm not an expert
> in reading them, having
Hi
Is sphinxsearch avialable only on for windows
regards
anandkl
On 6/13/08, Rory McKinley <[EMAIL PROTECTED]> wrote:
>
> mos wrote:
>
>
>> Why not switch to Sphinx full text search for MySQL? It is faster and can
>> handle more data than MySQL's built in fulltext search.
>> http://www.sphinxsea
> -Original Message-
> From: Boyd, Todd M. [mailto:[EMAIL PROTECTED]
> Sent: Friday, June 13, 2008 10:33 AM
> To: Emily Heureux; mysql@lists.mysql.com
> Subject: RE: natural sort via substrings
---8<--- snip
> Forgive me if I am incorrect, but wouldn't "jane2" already be listed
> before "
> -Original Message-
> From: Per Jessen [mailto:[EMAIL PROTECTED]
> Sent: Friday, June 13, 2008 5:17 AM
> To: mysql@lists.mysql.com
> Subject: what is the proper way to store timezone information?
>
> All,
>
> I will be recording timezone information based on user input using the
> time z
> -Original Message-
> From: Emily Heureux [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 12, 2008 8:25 PM
> To: mysql@lists.mysql.com
> Subject: natural sort via substrings
>
> Hi, I am attempting to do a "natural sort" from within mysql, if
> possible.
> So, for example, jane2 would co
Hi Jerry,
It could be a kernel issue; however, currently I'm suspecting that the
drive in the new server simply doesn't have the same bandwidth
capability. The iostat results I'm getting (although I'm not an expert
in reading them, having only learned of it about 3 hours ago) suggest
that the olde
> -Original Message-
> From: Jesse [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 12, 2008 1:40 PM
> To: Martijn Tonies; MySQL List
> Subject: Re: Function Still Not Working
>
> > Any difference in default collation?
>
> Not sure what that is. I'm using a visual tool (EMS) to create my
>Having delved a little more into the capabilities of iostat, I've
>discovered that the drive bandwidth seems to be maxed out while MySQL is
>running, which I'd peg as the primary candidate for the problem.
[JS] That suggests even more strongly that there is a difference in the kernel
configuratio
Hi Guys,
Having delved a little more into the capabilities of iostat, I've
discovered that the drive bandwidth seems to be maxed out while MySQL is
running, which I'd peg as the primary candidate for the problem.
Looks like I'll be having more words with my hosting company about
this...
Thanks f
>Disk usage: the older server (the one that's running fine) is running
>more transactions per second, but has lower blocks written and read per
>second than the new server:
[JS] That, to me, suggests that the difference might be in the way the systems
themselves are configured. Unfortunately, I do
replication based inserts are serial whereas most of the time the inserts on
masters are concurrent. this leads to the slaves falling behind. to tackle
this we have used the following strategies :
1. Use raid 0 on the slaves (master users raid 10) so as to speed up writes.
2. pre fetch and cache
Hi guys, thanks for pitching in.
The inserts are from replication; we're not using transactions on the
master (yet), and I don't think there's a way of telling MySQL to batch
incoming replication statements if they're not already in a transaction.
Disk usage: the older server (the one that's runn
also how often do you issue a commit. batching the inserts inside a
transaction might help.
On Fri, Jun 13, 2008 at 6:53 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote:
> check for iostat to see if the disk is heavly used.
>
> On 6/13/08, Ian Simpson <[EMAIL PROTECTED]> wrote:
>>
>> Hi Alex,
>>
>> Co
check for iostat to see if the disk is heavly used.
On 6/13/08, Ian Simpson <[EMAIL PROTECTED]> wrote:
>
> Hi Alex,
>
> Configurations are identical, other than the differences I initially
> mentioned. I've diffed both the configuration files and the output of
> SHOW VARIABLES on both servers.
>
>
Hi Alex,
Configurations are identical, other than the differences I initially
mentioned. I've diffed both the configuration files and the output of
SHOW VARIABLES on both servers.
I've contacted my hosting provider to ask about the RAID settings.
Variable_name: innodb_flush_log_at_trx_commit
Please check if the my.cnf configurations to be the same.
What are your configuration parameters in terms of innodh flush log trx
commit , bin logging, sync binlog and innodb unsafe for binlog ?
If the systems have raid, check if the BBWC is enabled on the new host and
WB is enabled.
On Fri, J
Hi list,
Have a bit of a mystery here that I hope somebody can help with.
I've just got a new server that I'm using as a dedicated MySQL server.
In terms of hardware it's pretty much identical, if not slightly
superior to an existing server already in production use.
It's having a real struggle
All,
I will be recording timezone information based on user input using the
time zone names from mysql.time_zone_name - names
like 'America/Los_Angeles'.
When recording this information, do I store the full name or just
the 'time_zone_id' which is present in mysql.time_zone_name ?
thanks
Per
31 matches
Mail list logo
