Hi. > options SCHED_4BSD # 4BSD scheduler Try to use SCHED_ULE or SCHED_CORE. ::[ | | | | ]:: Alexey Tarasov master_at_preved.cn 04.06.2007, Χ 21:42, Abdullah Ibn Hamad Al-Marri ΠΙΣΑΜ(Α): > Hello, > > I have IRC services and it stored the dbs as MyISAM in MySQL 5.0.41 > which runs on dedicated C2D 6600 with 2 GB of ram. > > FreeBSD 7.0-CURRENT #4: Sun Jun 3 22:56:52 GMT 2007 i386 > > Here is my kernel config > > cpu I686_CPU > ident SERVICES > > options SCHED_4BSD # 4BSD scheduler > options PREEMPTION # Enable kernel thread > preemption > options INET # InterNETworking > options FFS # Berkeley Fast Filesystem > options SOFTUPDATES # Enable FFS soft updates > support > options UFS_ACL # Support for access > control lists > options UFS_DIRHASH # Improve performance on > big directories > options UFS_GJOURNAL # Enable gjournal-based UFS > journaling > options GEOM_PART_GPT # GUID Partition Tables. > options GEOM_LABEL # Provides labelization > options COMPAT_43TTY # BSD 4.3 TTY compat [KEEP > THIS!] > options COMPAT_FREEBSD4 # Compatible with FreeBSD4 > options COMPAT_FREEBSD5 # Compatible with FreeBSD5 > options COMPAT_FREEBSD6 # Compatible with FreeBSD6 > options SCSI_DELAY=5000 # Delay (in ms) before > probing SCSI > options KTRACE # ktrace(1) support > options SYSVSHM # SYSV-style shared memory > options SYSVMSG # SYSV-style message queues > options SYSVSEM # SYSV-style semaphores > options _KPOSIX_PRIORITY_SCHEDULING # POSIX P1003_1B real-time > extensions > options KBD_INSTALL_CDEV # install a CDEV entry in /dev > options ADAPTIVE_GIANT # Giant mutex is adaptive. > options STOP_NMI # Stop CPUS using NMI > instead of IPI > options SC_DISABLE_REBOOT # Disable reboot > key sequence > > # To make an SMP kernel, the next two lines are needed > options SMP # Symmetric MultiProcessor > Kernel > device apic # I/O APIC > > device acpi # Compile acpi in statically > > # Bus support. > device eisa > device pci > > # Bus support. > device eisa > device pci > > # ATA and ATAPI devices > device ata > device atadisk # ATA disk drives > options ATA_STATIC_ID # Static device numbering > > # atkbdc0 controls both the keyboard and the PS/2 mouse > device atkbdc # AT keyboard controller > device atkbd # AT keyboard > device vga # VGA video card driver > > # syscons is the default console driver, resembling an SCO console > device sc > > # PCI Ethernet NICs that use the common MII bus controller code. > # NOTE: Be sure to keep the 'device miibus' line in order to use > these NICs! > device miibus # MII bus support > device sk # SysKonnect SK-984x & SK-982x > gigabit Ethernet > > # Pseudo devices. > device loop # Network loopback > device random # Entropy device > device ether # Ethernet support > device pty # Pseudo-ttys (telnet etc) > device snp # Snoop Device > > # The `bpf' device enables the Berkeley Packet Filter. > # Be aware of the administrative consequences of enabling this! > # Note that 'bpf' is required for DHCP. > device bpf # Berkeley packet filter > > Here is the sysctl of kern > > kern.maxvnodes: 100000 > kern.maxproc: 6164 > kern.maxfiles: 32768 > kern.argmax: 262144 > kern.clockrate: { hz = 1000, tick = 1000, profhz = 666, stathz = 133 } > kern.posix1version: 200112 > kern.ngroups: 16 > kern.job_control: 1 > kern.saved_ids: 0 > kern.bootfile: /boot/kernel/kernel > kern.maxfilesperproc: 11095 > kern.maxprocperuid: 5547 > kern.ipc.maxsockbuf: 262144 > kern.ipc.sockbuf_waste_factor: 8 > kern.ipc.somaxconn: 1024 > kern.ipc.max_linkhdr: 16 > kern.ipc.max_protohdr: 40 > kern.ipc.max_hdr: 56 > kern.ipc.max_datalen: 148 > kern.ipc.nmbjumbo16: 0 > kern.ipc.nmbjumbo9: 0 > kern.ipc.nmbjumbop: 0 > kern.ipc.nmbclusters: 25600 > kern.ipc.piperesizeallowed: 1 > kern.ipc.piperesizefail: 0 > kern.ipc.pipeallocfail: 0 > kern.ipc.pipefragretry: 0 > kern.ipc.pipekva: 16384 > kern.ipc.maxpipekva: 16777216 > kern.ipc.msgseg: 2048 > kern.ipc.msgssz: 8 > kern.ipc.msgtql: 40 > kern.ipc.msgmnb: 2048 > kern.ipc.msgmni: 40 > kern.ipc.msgmax: 16384 > kern.ipc.semaem: 16384 > kern.ipc.semvmx: 32767 > kern.ipc.semusz: 92 > kern.ipc.semume: 10 > kern.ipc.semopm: 100 > kern.ipc.semmsl: 60 > kern.ipc.semmnu: 30 > kern.ipc.semmns: 60 > kern.ipc.semmni: 10 > kern.ipc.semmap: 30 > kern.ipc.shm_allow_removed: 0 > kern.ipc.shm_use_phys: 0 > kern.ipc.shmall: 8192 > kern.ipc.shmseg: 128 > kern.ipc.shmmni: 192 > kern.ipc.shmmin: 1 > kern.ipc.shmmax: 33554432 > kern.ipc.maxsockets: 25600 > kern.ipc.numopensockets: 26 > kern.ipc.nsfbufsused: 0 > kern.ipc.nsfbufspeak: 5 > kern.ipc.nsfbufs: 6656 > kern.dummy: 0 > kern.ps_strings: 3217031152 > kern.usrstack: 3217031168 > kern.logsigexit: 1 > kern.iov_max: 1024 > kern.hostuuid: 802D1F15-461D-D711-A11F-C7ABFF8EBB17 > kern.arandom: 653627002 > kern.disks: ad2 ad0 > kern.geom.collectstats: 1 > kern.geom.debugflags: 0 > kern.geom.label.debug: 0 > kern.elf32.fallback_brand: -1 > kern.init_shutdown_timeout: 120 > kern.init_path: > /sbin/init:/sbin/oinit:/sbin/init.bak:/rescue/init:/stand/sysinstall > kern.acct_suspended: 0 > kern.acct_configured: 0 > kern.acct_chkfreq: 15 > kern.acct_resume: 4 > kern.acct_suspend: 2 > kern.cp_time: 5327530 0 60047 15732 9213550 > kern.openfiles: 121 > kern.kq_calloutmax: 4096 > kern.ps_arg_cache_limit: 256 > kern.stackprot: 7 > kern.randompid: 0 > kern.lastpid: 3158 > kern.ktrace.request_pool: 100 > kern.ktrace.genio_size: 4096 > kern.module_path: /boot/kernel;/boot/modules > kern.malloc_count: 134 > kern.fallback_elf_brand: -1 > kern.maxusers: 384 > kern.ident: SERVICES > kern.kstack_pages: 2 > kern.shutdown.kproc_shutdown_wait: 60 > kern.shutdown.poweroff_delay: 5000 > kern.sync_on_panic: 0 > kern.corefile: %N.core > kern.nodump_coredump: 0 > kern.coredump: 1 > kern.sugid_coredump: 0 > kern.sigqueue.alloc_fail: 0 > kern.sigqueue.overflow: 0 > kern.sigqueue.preallocate: 1024 > kern.sigqueue.max_pending_per_proc: 128 > kern.forcesigexit: 1 > kern.fscale: 2048 > kern.timecounter.tick: 1 > kern.timecounter.choice: TSC(-100) ACPI-fast(1000) i8254(0) dummy > (-1000000) > kern.timecounter.hardware: ACPI-fast > kern.timecounter.nsetclock: 3 > kern.timecounter.ngetmicrotime: 1966 > kern.timecounter.ngetnanotime: 1 > kern.timecounter.ngetbintime: 0 > kern.timecounter.ngetmicrouptime: 4172907 > kern.timecounter.ngetnanouptime: 2512 > kern.timecounter.ngetbinuptime: 401300 > kern.timecounter.nmicrotime: 2986925 > kern.timecounter.nnanotime: 423 > kern.timecounter.nbintime: 2987361 > kern.timecounter.nmicrouptime: 3182 > kern.timecounter.nnanouptime: 8 > kern.timecounter.nbinuptime: 3825003 > kern.timecounter.stepwarnings: 0 > kern.timecounter.tc.i8254.mask: 65535 > kern.timecounter.tc.i8254.counter: 27888 > kern.timecounter.tc.i8254.frequency: 1193182 > kern.timecounter.tc.i8254.quality: 0 > kern.timecounter.tc.ACPI-fast.mask: 16777215 > kern.timecounter.tc.ACPI-fast.counter: 2515696 > kern.timecounter.tc.ACPI-fast.frequency: 3579545 > kern.timecounter.tc.ACPI-fast.quality: 1000 > kern.timecounter.tc.TSC.mask: 4294967295 > kern.timecounter.tc.TSC.counter: 4040078241 > kern.timecounter.tc.TSC.frequency: 2394010377 > kern.timecounter.tc.TSC.quality: -100 > kern.timecounter.smp_tsc: 0 > kern.threads.virtual_cpu: 2 > kern.threads.max_threads_hits: 0 > kern.threads.max_threads_per_proc: 1500 > kern.threads.umtx_max_spins: 3000 > kern.threads.umtx_dflt_spins: 0 > kern.ccpu: 1948 > kern.sched.runq_fuzz: 1 > kern.sched.preemption: 1 > kern.sched.ipiwakeup.htt2: 0 > kern.sched.ipiwakeup.onecpu: 0 > kern.sched.ipiwakeup.useloop: 0 > kern.sched.ipiwakeup.usemask: 1 > kern.sched.ipiwakeup.delivered: 1796942 > kern.sched.ipiwakeup.requested: 1796941 > kern.sched.ipiwakeup.enabled: 1 > kern.sched.quantum: 100000 > kern.sched.name: 4BSD > kern.devstat.version: 6 > kern.devstat.generation: 177 > kern.devstat.numdevs: 2 > kern.kobj_methodcount: 105 > kern.log_wakeups_per_second: 5 > kern.msgbuf_clear: 0 > kern.msgbuf: > kern.always_console_output: 0 > kern.log_console_output: 1 > kern.smp.forward_roundrobin_enabled: 1 > kern.smp.forward_signal_enabled: 1 > kern.smp.cpus: 2 > kern.smp.disabled: 0 > kern.smp.active: 1 > kern.smp.maxcpus: 16 > kern.nselcoll: 0 > kern.tty_nout: 198594 > kern.tty_nin: 1711 > kern.drainwait: 300 > kern.constty_wakeups_per_second: 5 > kern.consmsgbuf_size: 8192 > kern.consmute: 0 > kern.console: consolectl,/consolectl, > kern.pts.max: 1000 > kern.pts.enable: 0 > kern.minvnodes: 25000 > kern.metadelay: 28 > kern.dirdelay: 29 > kern.filedelay: 30 > kern.chroot_allow_open_directories: 1 > kern.random.yarrow.gengateinterval: 10 > kern.random.yarrow.bins: 10 > kern.random.yarrow.fastthresh: 192 > kern.random.yarrow.slowthresh: 256 > kern.random.yarrow.slowoverthresh: 2 > kern.random.sys.seeded: 1 > kern.random.sys.harvest.ethernet: 1 > kern.random.sys.harvest.point_to_point: 1 > kern.random.sys.harvest.interrupt: 1 > kern.random.sys.harvest.swi: 0 > > I see both daemons use CPU0 most of the time, and the other one is > idling. > > last pid: 3138; load averages: 0.70, 0.56, 0.70 > up 0+15:20:36 17:29:46 > 34 processes: 2 running, 32 sleeping > CPU states: 48.9% user, 0.0% nice, 1.7% system, 0.0% interrupt, > 49.4% idle > Mem: 711M Active, 420M Inact, 183M Wired, 32K Cache, 112M Buf, 685M > Free > Swap: 2048M Total, 2048M Free > > PID USERNAME THR PRI NICE SIZE RES STATE C TIME WCPU > COMMAND > 3135 services 3 96 0 29716K 27432K select 0 0:27 60.75% > services > 3106 mysql 14 96 0 637M 628M ucond 0 3:42 33.35% > mysqld > > > last pid: 3142; load averages: 0.83, 0.61, 0.71 > up 0+15:21:13 17:30:23 > 34 processes: 2 running, 32 sleeping > CPU states: 47.2% user, 0.0% nice, 4.9% system, 0.2% interrupt, > 47.7% idle > Mem: 711M Active, 420M Inact, 183M Wired, 32K Cache, 112M Buf, 684M > Free > Swap: 2048M Total, 2048M Free > > PID USERNAME THR PRI NICE SIZE RES STATE C TIME CPU > COMMAND > 3135 services 3 96 0 29716K 27668K select 0 0:55 72.61% > services > 3106 mysql 14 96 0 637M 628M ucond 0 3:52 24.66% > mysqld > > Both of them using libthr as well. > > Now my question is, why they don't use 100% of both COREs while > syncing to 4k users? > > Here is my my.cnf > > [mysqld] > thread_concurrency=100 > max_connections=5000 > wait_timeout=300 > max_allowed_packet=32M > key_buffer=512M > read_buffer_size=3M > sort_buffer_size=9M > join_buffer_size=3M > myisam_sort_buffer_size=100M > read_rnd_buffer_size=5M > query_cache_limit=1M > query_cache_size=64M > query_cache_type=1 > thread_cache_size=256 > table_cache=2048 > max_tmp_tables=1024 > tmp_table_size=512M > safe-show-database > skip-networking > socket=/tmp/mysql.sock > > [client] > socket=/tmp/mysql.sock > > The total database size is less than 60 MBs. > > mysqladmin status > Uptime: 878 Threads: 2 Questions: 225769 Slow queries: 0 Opens: 31 > Flush tables: 1 Open tables: 25 Queries per second avg: 257.140 > > > -- > Regards, > > -Abdullah Ibn Hamad Al-Marri > Arab Portal > http://www.WeArab.Net/ > _______________________________________________ > freebsd-current_at_freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-current > To unsubscribe, send any mail to "freebsd-current- > unsubscribe_at_freebsd.org"Received on Mon Jun 04 2007 - 15:55:54 UTC
This archive was generated by hypermail 2.4.0 : Wed May 19 2021 - 11:39:11 UTC