Hi
I have created the following 2 views:
CREATE VIEW `cpes_noise_num` AS
SELECT cpes_dsl_line_stats.id_cpes,
sum(IF(cpes_dsl_line_stats.snr_downstream
(SELECT snr_downstream FROM admin_configs WHERE admin_id =0),1,0)) AS
snr_downstream, sum(IF((cpes_dsl_line_stats.bit_errors /
In the last episode (Jun 10), Yariv Omer said:
I have created the following 2 views:
CREATE VIEW `cpes_noise_num` AS
[ big view]
CREATE VIEW `my_connect` AS
[ big view joining on cpes_noise_num ]
when I am trying to do something like:
SELECT count(*) from my_connect
It takes 1 minute
If I have a computer with many cores and multiple disks, disjoint
filesystems on those disks, and enough I/O bandwidth in the machine to
keep the disks busy, can MySQL keep those disks busy if I have it working
on different databases at the same time? If so, can one MySQL server
process do
Hi Mike,
The way we do it is installing each mysql instance from a
precompiled binary.
So if you had an 8 core box, and you wanted to use each of the 8
cores, you could install a mysql binary installation and then make 7
copies of it. We use an internal naming convention like the
In the last episode (Jun 10), Mike Spreitzer said:
If I have a computer with many cores and multiple disks, disjoint
filesystems on those disks, and enough I/O bandwidth in the machine to
keep the disks busy, can MySQL keep those disks busy if I have it working
on different databases at the
I've been using phpmyadmin as a MySQL GUI for some time and worked great for
me.
www.*phpmyadmin*.net
Isart
On Tue, Jun 9, 2009 at 8:57 PM, Daevid Vincent dae...@daevid.com wrote:
SQLYog by Webyog is the best mySQL GUI client for Windows. Hands down. not
even a question. I've used them all
I think we've got almost all of the big ones listed. To complete the list
(or at least grow the list by one), let me offer up Toad for MySQL:
http://www.toadsoft.com/toadmysql/
On Wed, Jun 10, 2009 at 1:55 PM, Isart Montane isart.mont...@gmail.comwrote:
I've been using phpmyadmin as a MySQL
Hi,
any message on the error log? Have you tried restarting the mysql server?
On Tue, May 26, 2009 at 7:24 PM, PJ af.gour...@videotron.ca wrote:
Hydro Quebec just f***ed my server just as I was booting up three
machines; XP is ok, FreeBSD 7.1 is the one with mysql problem, FreeBSD
4.10 -
I find my MySQL Community Edition 5.1.34 server running out of space on
/tmp (which is indeed small). Why is it using /tmp? How much free space
do I need on /tmp? Can/should I make the server use a different location
instead of /tmp?
Thanks,
Mike Spreitzer